SQL to pull Previous Line Manager — Cloud Customer Connect
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: Oracle Cloud SCM and Purchasing

SQL to pull Previous Line Manager

edited Aug 14, 2020 3:27PM in Reporting and Analytics for HCM 4 comments

Summary

Sample SQL to pull Line Manager from the Previous Assignment Row

Content

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:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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