Person, Assignment, Payroll data for Active and Future Employees with Multiple Work Relationships an
SummaryThe following definition will extract basic person, assignment, payroll and element entries data for active and future employees.
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'