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.
SQL to pull Previous Line Manager
Summary
Sample SQL to pull Line Manager from the Previous Assignment RowContent
We have created a data model that pulls most current assignment row where actions = Promotion and also pulls in the previous assignment details. Example: It pulls in details for current Line Manager, Dept, Job, Job Family, Grade etc and prior assignment details (where PER_ALL_ASSIGNMENTS_M_Previous row"."EFFECTIVE_END_DATE" ="PER_ALL_ASSIGNMENTS_M_Current row"."EFFECTIVE_START_DATE"-1) for the same fields.
The challenge we face is with the previous Line Manager data. If the previous assignment row had a manager change then there is an associated row in the PER_ASSIGNMENT_SUPERVISORS_F table and the line manager data pulled into the data model is correct.
Tagged:
1