HCM Extract - Future assignment details

Summary:

I have a requirement to pull active employee assignment changes along with details of future starters(pending workers, new assignments and new workrelationships). I have used (PER_ EXT_SEC_PERSON_NOW_FUTURE_UE) as the root data group and using filter criteria to extract only the current dated changes for existing employees and future assignments details for new assignments. I have used PER_EXT_SEC_ ASSIGNMENT_RANGE_UE to fetch the assignment details. Now the attributes I need for assignment record includes location name, department name, position name along with few DFF attributes defined at location, position ,department

Content (please ensure you mask any confidential information):