Let's Reconnect, thank you for making 2022 our best year yet.

Look Back
Employee Hierarchy — 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

Employee Hierarchy

Received Response
edited Oct 27, 2020 5:54PM in Human Resources 7 comments


Looking to find Level 0 - Level 4 Managers


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.


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