New Hire extract
Summary
New hire extract displaying the previous assignment for rehiresContent
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'
Tagged:
0