Market Data in Compensation Worksheets

Compensation Guide

Version
R2025.1.1
Market Data in Compensation Worksheets

Role feature access: Compensation > View Market Data

Compensation worksheets that use market data might include the Market Hourly Rate 50th Percentile and Market Hourly Salary 50th Percentile columns. For each employee, these columns show the mid-point of the market distribution range (based on salary or hourly rates) for similar jobs, according to the market data selected for the cycle.

If market data isn’t available for an employee, or if multiple market data records are available, Dayforce shows N/A for them in the market data percentile columns. See How Market Data Is Mapped.

For compensation cycles configured to map market data based on the experience level for each employee, you must assign an experience level using the drop-down list in the Experience Level column to load the employee's market data in the worksheet. When you select an option, Dayforce refreshes the row and shows the market data in the corresponding percentile columns in the worksheet. See Experience Levels in Compensation Worksheets.

You can click the value in the percentile columns to view the market data details for the employee. The dialog box includes the current and new salary or hourly rate for the employee, and a market data distribution graph, which plots the 25th, 50th, 75th, and 90th percentile values to provide a visual representation of the market range for the employee's job assignment. If any of these percentile values are missing from the market data record, Dayforce shows N/A in the graph:

Market salary graph showing the 25th, 50th, 75th, and 90th percentile values.

You can click the percentile sections in the graph to view the available compensation details (including bonuses and salary) in the Total Compensation section of the dialog box.