The amount your enterprise spends on components of salaries is likely to change over time. Oracle HRMS can record a reason for each salary increase you give to an employee.

Use the Employee Salary Component (Organization Hierarchy) Trend Analytics workbook to investigate the cost of salary changes for each change component over different time periods. For example, you can determine what proportion of total salary changes for January 1999 to January 2000 is attributable to the cost of living. You can view the changes over different time periods, such as monthly, bi-monthly, and yearly.

You can investigate the salary changes by components for different organizations, jobs, grades, locations, and salary component reasons. You can also choose the currency you want to view the salaries in and include or exclude salaries that you pay in a different currency.

Business Questions

What is the cost of a particular salary component and how has it changed over time?

When do salary proposals occur, and how do they break down into the salary components?

Workbook Parameters

You must enter a value for the following parameters:

• Start Date

• End Date

• Organization Hierarchy

• Top Organization

• Rollup Organizations - Yes/No

• Convert to Currency

  The workbook converts the salaries to the currency you select here, before averaging them for the grouping

Use the following parameters to further restrict the values in the workbook:

• Location

• Job Category

• Job

• Grade

• Position

• Salary Component Reason

• Include Currencies

Worksheets

This workbook has the following worksheets:

• By Year

• By Semi Year

• By Quarter

• By Bi Month

• By Month

The worksheets display one row for each time period. For example, the by Year worksheet displays one row per year.

A Total row displays the cost of each salary component reason within the selected start and end dates.

Headings and Calculations

All worksheets contain the following columns:

• Start Date

  The start date of the time period.

• End Date

  The end date of the time period.

• A time period column

  This heading depends on the selected worksheet, for example, in the by Quarter worksheet, this column is named "Quarter".

• Salary component reason columns

  One column for each defined salary component reason - the total cost of the salary component for each time period.

• Blank

  The total cost of salary components with no associated reason for each time period.

• Total

  The total cost of all salary components for each time period.

  If no salary proposals occurred in a specific time period, a row for that time period does not appear.