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.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
SQL to find the representatives of an active employee's assignment record
Summary
SQL to find the representatives of an active employee's assignment recordContent
Hi Experts,
I am looking for the AoR report that fetches all the active employee records and their associated representatives.
For Example:
If John is the Human Resource Rep for Michael and Nick is the Benefits Rep for Michael. Then the report should be in the below format
Employee Name | Employee Person Number | Employee Assignment Number | Representative Person Name | Representative Person Number | Representative Responsibility Type | From Date | End Date |
Michael | 110101 | E110101 | John | 220022 | Human Resource Representative | 01/01/2021 | |
Michael | 110101 | E110101 | Nick | 220023 | Benefits Representative | 01/01/2021 |
If you have SQL that can fetch the report in the above format or similar to this one, Please share.
Tagged:
0