The Salary, Grades, and Pay Administration Intelligence reports enable you to compare and contrast salaries among employees working in different circumstances, such as different jobs or organizations, within your enterprise. You can also examine salary trends, or you can view salary details for individual employees. You can set Key Performance Indicators to alert you to critical changes in salaries.
Note: These reports will not return data if you have not attached your Grade Rates to a Salary Basis.
To enable you to get the most out of the Salary, Grades, and Pay Administration intelligence reports, you need to understand the following key concepts:
The Salary, Grades, and Pay Administration reports enable you to select the currency on which you want to report. If salaries exist that are not paid in the currency you select, you can include or exclude them from the report. If you include salaries that are not in the currency you select, the reports convert the salary using the general ledger (GL) daily rates. If the report cannot find a valid exchange rate, it ignores the salary.
For more information, see Entering A Conversion Rate Type, Oracle HRMS Configuring, Reporting, and System Administration Guide.
Most of the reports display salary values as annualized figures. Reports use the salary basis set up for the assignment to calculate the annualized figure. Reports only include the salary values they can convert to an annualized figure.
Reports display the minimum, mid-point, and maximum payments in a grade range as annualized figures. Reports use the grade annualization factor set up as part of the pay basis to calculate the annualized figure.
The Salary, Grades, and Pay Administration reports show salaries for all assignments that satisfy the following criteria. For an assignment to be included in the reports, it must:
Be active or suspended.
Note: By including employees with a status of suspended, the reports ensure that employees on military leave, or those who have been temporarily suspended, are still included in the salary analysis.
Have the latest approved salary proposal. Assignments with unapproved salary proposals are not included.
Have all components of a salary increase approved.
Have a performance rating related to a current approved salary, if you group by performance.
Fit the criteria you enter. For example, if you enter a location, the assignment must be for that location.
Each assignment that matches the selection criteria appears on the report. If an employee has more than one assignment that matches all the criteria, the employee appears more than once on the report.
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
Additional Information: See also My Oracle Support Knowledge Document 2277369.1, Oracle E-Business Suite Support Implications for Discoverer 11gR1.
This workbook has the following worksheets:
Organization Hierarchy
Supervisor Hierarchy
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.
How much do my employees within each organization earn and how does that compare with their grade rate?
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.
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.
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.
How much do the employees for a given supervisor earn and how does that compare with their grade rate?
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.
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.
Related Topics
Salary, Grades, and Pay Administration Key Concepts
This workbook enables you to report on employee details based on employee primary assignment, in a non-legislative specific format. This is useful for global reporting.
Employee details include:
Current annual salary
Hire date
Employment category
Additional Information: See also My Oracle Support Knowledge Document 2277369.1, Oracle E-Business Suite Support Implications for Discoverer 11gR1.
This workbook has the following worksheets:
Organization Hierarchy
Supervisor Hierarchy
This worksheet enables you to report on employee details based on employee primary assignment, in a non-legislative specific format, for a given organization and its subordinate organizations.
How much do my employees within each organization earn?
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.
This worksheet enables you to report on employee details based on employee primary assignment, in a non-legislative specific format, for a given supervisor and his/her subordinates.
How much do the employees for a given supervisor earn?
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.
Related Topics
Salary, Grades, and Pay Administration Key Concepts
This workbook investigates salary changes over specified periods of time within your organization. The resulting information allows you to:
Compare salary changes for similar organizations
Analyze employee salary by length of service
Analyze salary change by gender
Ensure employees are rewarded for high performance
Additional Information: See also My Oracle Support Knowledge Document 2277369.1, Oracle E-Business Suite Support Implications for Discoverer 11gR1.
This workbook has the following worksheets:
Summary
By Years of Service
By Gender
By Performance Rating
By Person
This worksheet enables you to view information about salary changes within your organization. The resulting information allows you to analyze salary changes across all organizations in a Business Group.
What are the details of the most recent salary changes for employees?
You must specify a value for the following parameter:
Salary Change Date
This worksheet displays salary change information by years of service across organizations. The resulting information allows you to:
Compare salary change across Business Groups and organizations.
View salary change information by length of service.
What are the details of the most recent salary changes for my employees, by years of service?
You must specify a value for the following parameter:
Salary Change Date
This worksheet enables you to analyze salary change within your organization, by gender. It enables you to analyze differences in salary changes between male and female employees across organizations.
What are the details of the most recent salary changes for my employees, by gender?
You must specify a value for the following parameter:
Salary Change Date
This worksheet enables you to investigate the effects of performance ratings on employee salary change across organizations. It enables you to ensure employees are rewarded for performance.
What are the details of the most recent salary changes for my employees, by performance?
You must specify a value for the following parameter:
Salary Change Date
This worksheet enables you to investigate salary changes for individual employees.
What are the details of the most recent salary changes for my individual employees?
You must specify a value for the following parameter:
Salary Change Date
Related Topics
Salary, Grades, and Pay Administration Key Concepts
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.
Additional Information: See also My Oracle Support Knowledge Document 2277369.1, Oracle E-Business Suite Support Implications for Discoverer 11gR1.
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.
Related Topics
Salary, Grades, and Pay Administration Key Concepts
This workbook enables you to report on current employee tenure details based on the employee primary assignment in a non-legislative specific format.
In addition to the basic employee primary assignment details, you can report on:
Most recent hire date
Original date of hire
Total years of service
Recent years of service
Additional Information: See also My Oracle Support Knowledge Document 2277369.1, Oracle E-Business Suite Support Implications for Discoverer 11gR1.
This workbook has the following worksheets:
Organization Hierarchy
Supervisor Hierarchy
This worksheet enables you to report on employee tenure details (based on the employee primary assignment in a non-legislative specific format) for a given organization and its subordinate organizations.
How long have my employees within a given organization hierarchy been working within my enterprise?
You must specify values for the following parameters:
Organization Hierarchy
Top Organization
Employment Category
The worksheet includes those employees currently employed within the selected organization hierarchy, and within the selected employment category.
This report uses the following calculations:
Recent Years Service
Calculates the employee's length of service since their most recent hire date as a number of years.
Total Years Service
Calculates the employee's length of service since their first hire date as a number of years.
This worksheet enables you to report on employee tenure details (based on the employee primary assignment in a non-legislative specific format) for a given supervisor and his/her subordinates.
How long have employees, reporting directly or indirectly to a given supervisor, been working within my enterprise?
You must specify values for the following parameters:
Supervisor
Employment Category
The worksheet includes those employees currently employed by the selected supervisor, and within the selected employment category.
This report uses the following calculations:
Recent Years Service
Calculates the employee's length of service since their most recent hire date as a number of years.
Total Years Service
Calculates the employee's length of service since their first hire date as a number of years.
Related Topics
Salary, Grades, and Pay Administration Key Concepts
This workbook enables you to compare employee salaries for each job and grade. The worksheet shows the average, minimum, and maximum employee salaries for jobs and grades.
This workbook has the following worksheets:
Organization Hierarchy
Supervisor Hierarchy
This worksheet enables you to compare employee salaries for each job and grade. The report shows the average, minimum, and maximum employee salaries for jobs and grades, for a given organization and its subordinate organizations.
How do the lowest, average and highest salaries of employees in each organization, in a particular job, compare with the grade minimum, mid point and maximum?
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 within the selected organization hierarchy at the time of the Effective Date.
This report uses the following calculations:
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.
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 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.
Number of incumbents
This returns the total number of assignments for an employee on the effective date.
This worksheet enables you to compare employee salaries for each job and grade. The worksheet shows the average, minimum, and maximum employee salaries for jobs and grades, for a given supervisor and his/her subordinates.
How do the lowest, average and highest salaries of employees for a given supervisor, in a particular job, compare with the grade minimum, mid point and maximum?
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.
This report uses the following calculations:
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.
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 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.
Number of incumbents
This returns the total number of assignments for an employee on the effective date.
Related Topics
Salary and Grade Related Pay and Progression Key Concepts
The Salary Survey Comparison Workbook provides information on salary surveys linked to jobs and positions. It enables you to analyze salary information per job or position.
This workbook has the following worksheets:
Salary Survey Mappings
This worksheet enables you to analyze salary surveys, which have been mapped to particular jobs or positions.
What are the details of salary surveys?
Related Topics
Salary and Grade Related Pay and Progression Key Concepts
The Employee Salary (Organization Hierarchy) Trend Analytics workbook lists the average salaries of employees, within a given date range, for time periods such as year, semi-year, month, bi-month, and quarter. Each worksheet represents the average salaries for one specific time period.
You can select which area of your enterprise you want to investigate. 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.
Are average salaries in my enterprise rising at a faster rate now than in previous time periods?
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:
Area
Country
Region
Location
Job
Grade
Position
Performance Rating
Include Currencies
This workbook has the following worksheets:
By Year
By Semi Year
By Quarter
By Bi Month
By Month
By Year and Organization
By Quarter and Organization
By Month and Organization
The worksheets display one row for each time period. For example, the by Year worksheet displays one row per year. The three reports that include Organization break the data down even further. For example, the by Month and Organization worksheet displays one row for each month per organization.
All worksheets contain the following columns:
A time period column
This heading depends on the selected worksheet, for example, in the by Year worksheet, this column is named “Year”.
Organization
One column for each sub-organization – appears only in the three worksheets that break the report down into time period and organization.
Date
The date corresponding to the start of each time period.
Total Salary
The total salary for each time period and organization.
Average Salary
The average annualized salary per time period– appears only in the five worksheets that do not break the report down into sub-organizations.
Related Topics
Salary and Grade Related Pay and Progression Key Concepts
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.
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?
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
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.
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.
Related Topics
Salary and Grade Related Pay and Progression Key Concepts
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.
Related Topics
Salary and Grade Related Pay and Progression Key Concepts
Within your enterprise you have many different groups of employees. You can group employees by common criteria, such as ethnic origin, grade, job, gender, and service band.
This workbook enables you to investigate the average salaries of these different groups of employees.
You can also select which area of your enterprise you want to investigate. You can choose the currency you want to view the salaries in and include or exclude salaries that you pay in a different currency.
Are average salaries in my enterprise rising at different rates for different groups of people in my enterprise?
How do salaries vary between different ethnic groups?
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 Category
Job
Grade
Position
Include Currencies
The workbook has the following worksheets, each representing a salary grouping:
By Organization
By Location
By Job
By Grade
By Position
By Performance Rating
By Length of Work Band
By Age Band
By Gender
By US Ethnic Group
By GB Ethnic Group
The worksheets display one row for each grouping. For example, the by Position worksheet displays one row per position.
When you use the US Ethnic Group worksheet, or the GB Ethnic Group worksheet, employees from other countries will appear in the report with no ethnic group recorded against them. These employees will be counted as a separate group. To avoid this, you could restrict the report to just employees in the US or GB.
All worksheets contain the following columns
A grouping column
The heading depends on the selected worksheet, for example, in the by Length of Work Band worksheet, this column is named “Length of Work Band”
Average Salary
The current average annualized salary per grouping.
Related Topics
Salary and Grade Related Pay and Progression Key Concepts
Within your enterprise it is useful to know the salary ranges for different groups of employees. This workbook investigates the spread of salaries within groups such as age, position, grade, organization and location.
Employees, within the area of the enterprise you select, have their salary plotted against a group. You can then quickly see where the main spread of salaries lie for each group.
What range of salaries do employees have in a particular group?
How do salaries vary across age groups?
How do salaries vary across organizations or locations?
To what extent do salaries increase with length of service?
In order for this report to return data, you must have successfully attached performance reviews to the pay proposals. To attach a performance review, set a performance review date before you approve the pay proposal. For instructions see: Changing Other Information in Proposing a Salary Change for a Current Employee, Oracle HRMS Compensation and Benefits Management Guide
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
Performance Rating
Include Currencies
The workbook has the following worksheets, each representing a salary grouping:
By Organization
By Location
By Job
By Grade
By Position
By Performance Rating
By Age
By Length of Service
The worksheets display one row for each person. Age and Length of Service are measured in years.
All worksheets contain the following columns
A grouping column
The heading depends on the selected worksheet, for example, in the by Grade worksheet, this column is named “Grade”.
Person
Employee names listed within each grouping.
Total Salary
Displays the employee's total annualized salary for all assignments Each employee appears in the worksheet grouping.
Related Topics