Get Started with Redwood for Oracle Cloud HCM Begin Now
To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered. (newly added) Please note that it is also important to respond to EACH comment your question receives. Your Yes or No response ensures an accurate status for your question.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
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