New Hire extract

Summary

New hire extract displaying the previous assignment for rehires

Content

Hi,

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.

Person Criteria:

(ps.person_id in (select asg1.person_id from per_all_assignments_f asg1 

where asg1.Assignment_type  in ('E','C')

and asg1.PRIMARY_FLAG='Y'