Employee Hierarchy

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.