Employee Salary Range Report

This report displays the salary range of each employee in the report criteria.

To access the Employee Salary Range report, go to Reports > Standard Reports. Under the Compensation tab, select the Employee Salary Range Report link.

Filter

• User Criteria- Limit report output to the users matching the specified user criteria.
• The report will only run within the defined constraints for the user running the report.
• This is the standard organizational unit (OU) availability selection criteria drop-down. Choose from available OU types.
• Defaults: If no User Criteria are selected, then the report will run for the entire available population within the report user's permission constraints.
• User Status - Select this option to include inactive users in the report. Note: Only inactive users that were part of the compensation task and meet the criteria defined in the User Criteria section are included.
• Wage Types - Determine which wage type tasks are included in the report. Note: This criterion is not based on the employee's current Wage Type value. It is based on the Wage Type value of the task. The available options are:
• All Wage Types - Include employees from all wage types in the report. If this option is selected, a Wage Type column is added to the report to display each user's wage type.
• Each available wage type is available. Selecting a wage type only includes employees from selected wage type in the report.
• Annualize Rates - Select this option to annualize the non-annual rates for non-annual employees. If this option is selected, any component allocated to a non-annual employee at a non-annual rate is annualized based on their Labor Hours value for the task (not their current Labor Hours value). Note: This option is only available if the Wage Type is set to All Wage Types or a non-annual wage type.
• Market Salary - Check to display market salary/rate.
• Report Title - Enter report title or leave blank to default to Employee Salary Range title.

Report Settings

This is an asynchronous report, which allows the administrator to define the standard report and generate the report asynchronously. As a result, when administrators process the report, the system generates the report in the background, while the administrator can move on to other areas of the system. When the report is finished processing, the administrator can then view the full report in its entirety.

• Up to three separate reports can generate asynchronously, allowing greater flexibility for creating and storing different versions of the report.
• If you process a report or refresh a stored report, the report appears in the table as Queued.
• The most recently created report displays at the top of the table.
• Since the user can generate up to three reports, the administrator can define a report title for each of the generated reports.
• Clicking the View Details icon changes the report settings on the page to match those of the selected previously run report.

Output

• Printable Version link to view the results in a web page, or Export to Excel link to save/open as an Excel file.
• After the report is processed, you can:
• Update the data on the report, click the Refresh icon .
• View the details on the report, click on the Details icon .
• Delete the report, click on the Delete icon .

The report will display each employee's current salary/rate, compa-ratio, range minimum, midpoint, and maximum as well as the OU's used to determine the employee's salary/rate range.

Tertiary Organizational Unit

For portals that have configured their salary ranges with a tertiary OU, then a Tertiary OU column is included in the report output and displays the tertiary OU for users who are part of a primary, secondary, and tertiary OU. The column name is the name of the tertiary OU that is configured on the Salary Structures page.

Considerations

• If a user has a tertiary OU on their user record, and the tertiary OU is not listed on the Salary Structure page, then the Tertiary OU column displays the user’s tertiary OU from the user record.
• The report will show the salary range minimum, range midpoint, and salary range maximum for the tertiary OU for users who are part of a primary, secondary, and tertiary OU when the Salary Structures page has a defined tertiary OU salary range minimum, range midpoint, and salary range maximum.
• If the Salary Structures page has a primary, secondary, and tertiary OU defined:
  • and the user only has a primary OU, then the system shows the primary salary range minimum, range midpoint, and salary range maximum in the report output.
  • and the user only has a primary and secondary OU, then the system shows the primary and secondary salary range minimum, range midpoint, and salary range maximum in the report output.
  • and a tertiary OU is not present for the user on the user record, tertiary OU will remain blank in the Tertiary OU column.
• If "None" is selected in the Select Tertiary OU field on the Salary Structures page, then the Tertiary OU column does not display on the Employee Salary Range Report.
• The Employee Salary Range Report will display the edited midpoint when the Edit Midpoint option is selected on the Salary Structures page, regardless of the level of the OUs defined for the position.