You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register
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

edited May 13, 2021 11:46AM in Human Capital Management 1 comment

Summary

SQL to find the representatives of an active employee's assignment record

Content

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.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!