Split promotions from recent_exec_hires into a new field
being researched
E
Emerald Sheep
recent_exec_hires
is currently built to capture any new executive job title to surface new hires and promotions.This is confusing and possibly misleading as the
previous_company_x
fields populate based on the last known company. The only way to check if the profile is a net-new hire or a promotion is to compare the joined_date
to the experience.end_date
where job_company_id
= previous_company_id
The proposed solution would be to create a new field called
recent_exec_promotions
that only captures executive job changes where job_company_id
does not change between job_title
changes.
