using left function on global_term_id to get yearid