Understanding the Employee/Supervisor Relationship Table

Before you open the compensation review process to the managers, you need to build the Employee/Supervisor Relationship Level table (F05840) to generate a list that shows the hierarchy of management above each active employee. This build is based on the information in the Employee Master Information table (F060116). The system deletes any existing records before writing the employee records. One record is written for each manager above the employee. The employee's immediate supervisor is written with a level 1, the supervisor's supervisor is written with a level 2, and so on.

The Employee/Supervisor Relationship Level table does not automatically reflect any changes made to the Employee Master Information table; therefore, you should build it nightly during the time that the compensation review process is open so that the table is always current.

The processing option must be set before you run the program. When a supervisor has given notice or is going to be terminated, you must decide when to remove the supervisor name from the employee/supervisor relationship level table. Use the Days Prior To Termination processing option to specify how many days before termination you want to exclude the supervisor from the table build. Any records for supervisors who have termination dates within the specified time period are not written to the table and are included in the exception report.