Using Oracle HRMS you can define the minimum, mid points and maximum salaries for different grades in your enterprise.
This workbook is particularly useful if you set the midpoint at a recognized industry standard. You can then quickly see if any employees receive less than the standard salary, and how much it will cost to raise salaries to the industry standard.
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.
Which employees are paid more than the maximum for their grade?
Which employees are paid below the mid point or maximum for their grade and by how much?
What would be the cost of increasing a group of employees to the mid point or maximum for their grade?
You must enter a value for the following parameters:
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
Grade
Position
Include Currencies
This workbook has the following worksheets:
Full Details
Graph
The Full Details worksheet compares employees' current salaries to their grade minimum, mid, and maximum points, and displays the value required for the employee's salary to reach the next point in the grade. It also includes details of employees' organization, location, job, and position.
The worksheet displays one row for each employee. It also includes a row totaling salaries, To Min values, To Mid values, and To Max values.
What is the position of employee salaries in relation to their grade minimum, mid, and maximum points?
The table displays the following columns:
Grade
The employee's current grade.
Person
The employee's name.
Salary
The employee's current salary.
Grade Min
The minimum salary for the grade
To Min
If the employee's salary is less than the grade minimum, displays the difference between the two. This could occur if grade rates change, leaving the salary of an employee below the new grade minimum.
Grade Mid
The mid salary for the grade
To Mid
If the employee's salary is less than the grade mid point, displays the difference between the two.
Grade Max
The maximum salary for the grade
To Max
If the employee's salary is less than the grade maximum, displays the difference between the two.
Organization
The employee's organization.
Location
The employee's location.
Job
The employee's job.
Position
The employee's position.
The Graph worksheet displays a table and a chart that compare each employee's salary to the minimum, mid, and maximum points for their grade.
The table displays one row for each employee.
What is the position of employee salaries in relation to their grade minimum, mid, and maximum points?
The table data reflects the data displayed in the chart. It displays the following columns, which match the bars in the chart:
Person
The employee's name.
Below Min
The grade minimum value.
Min to Mid
The difference between the grade minimum and grade mid-point values.
Mid to Max
The difference between the grade mid-point and grade maximum values.
The worksheet chart has a horizontal axis that shows values ranging from 0.00k to 100.00k. These values reflect the currency you select in the workbook parameters.
Note: If you need to report on salaries outside of this range you can configure the Y1 axis and the Y2 axis of this worksheet using Discoverer Java Edition. You should ensure the Y1 axis and the Y2 axis remain equal in order to accurately plot the employee salaries against their grade.