Person, Assignment, Payroll data for Employees with Multiple Work Relationships and Assignments

Summary

The following definition will extract basic person, assignment, payroll and element entries data for active employees.

Content

It is assumed that employee has multiple Work relationship, multiple Assignments, and employee person type is ‘EMP’ for active employees. This extract is driven by Person and Work Relationship User Entities.

Sample Criteria:

i) If you want INACTIVE Persons, you need to change Person Level Data Group Filter accordingly.

• Extract Person System Person Type in ('EMP', 'EX_EMP')

ii) If you want ACTIVE Persons, you need to change Person Level Data Group Filter accordingly.

• Extract Person System Person Type = 'EMP'

                    iii) At Assignment Level criteria to get Only Active Assignments: