This workbook enables you to report on employee salary change details; for example, the latest salary increment, the effective date of a salary change, the salary level compared to the grade minimum, mid value and maximum value. The details can be shown for a chosen period of time.
This workbook has the following worksheets:
Organization Hierarchy
Supervisor Hierarchy
The Organization Hierarchy worksheet enables you to report on employee salary change details by organization hierarchy for a given time period.
When did my employees' salaries change, and by how much?
You must specify values for the following parameters:
Organization Hierarchy
Top Organization
Start Date
End Date
The worksheet includes those employees who held a primary assignment, were employed in the selected organization hierarchy, and had a salary change, during the period from your selected Start Date to your selected End Date.
You can also enter a value for the following optional parameter:
Organization Hierarchy Effective Date
If you use the Organization Hierarchy Effective Date parameter, the worksheet will use the Organization Hierarchy Version effective on this date to display organization Hierarchy information.
This date will affect the output of your worksheet if your selected Start Date and End Date parameters cover more than one Organization Hierarchy Version for your selected Organization Hierarchy.
If you do not use the Organization Hierarchy Effective date parameter, the worksheet will default to the Organization Hierarchy Version effective on your selected End Date.
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.
Previous Annual Salary
Calculates the previous annual salary amount for an employee.
Salary Increment
Calculates an employee's salary increment as a percentage of the previous salary.
The Supervisor Hierarchy worksheet enables you to report on employee salary change details by supervisor hierarchy for a given time period.
When did my employees' salaries change, and by how much?
You must specify values for the following parameters:
Supervisor
Start Date
End Date
The worksheet includes those employees who held a primary assignment, were employed by the selected supervisor, and had a salary change, during the period from your selected Start Date to your selected End Date.
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.
Previous Annual Salary
Calculates the previous annual salary amount for an employee.
Salary Increment
Calculates an employee's salary increment as a percentage of the previous salary.