SummaryLooking 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.