HCM Extract - With All Latest Assignments and Future Contractors
SummaryHCM Extract - With All Latest Assignments and Future Contractors
I am looking to create an Extract that includes all the following.
- All current dated employees and Contractors with their latest Record (Max Date Start for each person)
- All Active Pending workers in the system
- All future dated Contingent Workers - Hires only
Unfortunately I want all of them in one File feed , every time I need to send a full file of these.
Right now I am using PER_EXT_PAY_EMP_UE, it is not doing what I would like in the extract. We also have Candidate details in the system and for some of the employees the Max(Date_start) is the internal Candidate record. So to avoid these we used Primary flag = Y but this is filtering out the Pending workers as they are not primary.