New Hire extract
SummaryNew hire extract displaying the previous assignment for rehires
Our new hire extract is expected to generate a list of new hires (employees and contingent workers) and rehires. The new hire data is correct; however, for rehires, we're getting the previous assignment data rather than the current assignment info. I've listed the DG filter criteria used in our Person and Assignment DG's. Can anyone please suggest what might be wrong.
(ps.person_id in (select asg1.person_id from per_all_assignments_f asg1
where asg1.Assignment_type in ('E','C')