This workbook enables you to report on employees based on their primary assignment. The workbook output is in a non-legislative specific format, which is useful for global reporting.

You can report on employee details, including:

• Current annual salary

• Previous annual salary

• Salary grade rates

• Date of birth

• Working hours

• Gender

• Age

Worksheets

This workbook has the following worksheets:

• Organization Hierarchy

• Supervisor Hierarchy

Organization Hierarchy Worksheet

This worksheet enables you to report on employee details based on the employee primary assignment (in a non-legislative specific format) for a given organization and its subordinate organizations.

Business Questions

How much do my employees within each organization earn and how does that compare with their grade rate?

Worksheet Parameters

You must specify values for the following parameters:

• Organization Hierarchy

• Top Organization

• Effective Date

The worksheet includes those employees who held a primary assignment at the time of the Effective Date, and were employed in the selected organization hierarchy at the time of the Effective Date.

Headings and Calculations

This report uses the following calculations:

• Annualized Grade Minimum

  Calculates the annualized minimum payment in a grade range. The calculation uses the grade annualization factor that is set up as part of the pay basis.

• Annualized Grade Mid Value

  Calculates the annualized mid value payment in a grade range. The calculation uses the grade annualization factor that is set up as part of the pay basis.

• Annualized Grade Maximum

  Calculates the annualized maximum payment in a grade range. The calculation uses the grade annualization factor that is set up as part of the pay basis.

• Salary Increment

  Calculates an employee's salary increment as a percentage of the previous salary.

• Recent Years Service

  Calculates the employee's length of service as the number of years since their most recent hire date.

Supervisor Hierarchy Worksheet

This worksheet enables you to report on employee details based on the employee primary assignment (in a non-legislative specific format) for a given supervisor and his/her subordinates.

Business Questions

How much do the employees for a given supervisor earn and how does that compare with their grade rate?

Worksheet Parameters

You must specify values for the following parameters:

• Supervisor

• Effective Date

The worksheet includes those employees who held a primary assignment at the time of the Effective Date, and were assigned to the selected supervisor at the time of the Effective Date.

Headings and Calculations

This report uses the following calculations:

• Annualized Grade Minimum

  Calculates the annualized minimum payment in a grade range. The calculation uses the grade annualization factor that is set up as part of the pay basis.

• Annualized Grade Mid Value

  Calculates the annualized mid value payment in a grade range. The calculation uses the grade annualization factor that is set up as part of the pay basis.

• Annualized Grade Maximum

  Calculates the annualized maximum payment in a grade range. The calculation uses the grade annualization factor that is set up as part of the pay basis.

• Salary Increment

  Calculates an employee's salary increment as a percentage of the previous salary.

• Recent Years Service

  Calculates the employee's length of service as the number of years since their most recent hire date.