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: AI Resources for Oracle Cloud HCM – Go Here

Progress with Redwood: Redwood Resources for Oracle Cloud HCM -  Go Here

Employee Hierarchy

edited Oct 27, 2020 5:54PM in Human Capital Management 7 comments

Summary

Looking to find Level 0 - Level 4 Managers

Content

Does anyone have a working SQL that will provide employee hierarchy?  I am looking to identify Level 0(President) through Level 4(whatever job/person that may be).  I want to identify managers only.  For example the President may have 5 reports and 1 of which is the admin assistance with no direct reports the other 4 would be VPs and would have direct reports I would only want the 4 VPs(Level 1), etc, etc.

The goal is to identify those level managers for compensation approvals.  These individuals would be given a role that would allow them to perform that approval.  Of course, yearly employees change, jobs change and persons could move into the L0-4 or out of the L0-4.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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