adding type to yearly transcript sandbox data