Person, Assignment, Payroll data for Active and Future Employees with Multiple Work Relationships an

Summary

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

Content

It is assumed that employee has multiple work relationship and multiple assignments. This extract is driven by Person Now Future and Work Relationship user entities.

Sample Advanced Filter at Person Level to get only Active Employees:

Exists select 1 from per_all_assignments_m asg where per.person_id =  asg.person_id and asg.assignment_status_type = 'ACTIVE' and (pay_report_utils.get_parameter_value('EFFECTIVE_DATE')  between  asg.effective_start_date and asg.effective_end_date) and asg.assignment_type = 'E'