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'
Tagged:
4