Before You Begin: By default, Dayforce shows all of the data in the employee list using each employee’s local currency. You can clear the Show Employee Local Currency in Worksheet checkbox in the Currency drop-down list to convert all of the values to the worksheet currency instead (that is, the one selected in the Currency drop-down list). See Currency in Compensation Worksheets.
The worksheet shows a list of employees that you’re responsible for and provides information to help you make compensation decisions. When you first open the worksheet, the list shows all of the columns that the compensation administrator has configured to show by default. You can update the list of displayed columns by clicking View in the toolstrip. See Toolstrip.
| Item | Description |
|---|---|
|
Information Icon |
An information icon ( |
|
Expander Column |
A column with an expander arrow is included by default to the left of each employee’s name. You can click this arrow to expand a panel that contains additional information to help you with allocations. This additional information is shown in three tabs which are described in detail in the following sections: |
|
Employee Column |
The Employee column is included by default and shows the name of each employee that you manage. |
|
Experience Level Column |
Depending on the configuration, the Experience Level column is shown either as a read-only field or as a drop-down list in the worksheet. Either way, if an employee has an experience level saved from a previous compensation cycle, it's populated in this field by default. If the field is read-only, it indicates that the market data isn’t mapped based on experience level. If the field includes a drop-down list, it indicates that the market data is mapped based on experience level. In this case, you must select an experience level for each employee to load their applicable market data in the worksheet. If an experience level is already selected, you can update it using the drop-down list. To help you determine which level is appropriate, Dayforce shows the help icon ( |
|
Currency Column |
The Currency column is included by default in worksheets that include one or more employees with a currency type that’s different from the cycle currency. This column shows each employee's local currency. You can filter the list by currency type using the Currency Code filter parameter in the Filter panel. See Toolstrip. |
|
Market Percentile Columns |
The Market Hourly Rate 50th Percentile and Market Hourly Salary 50th Percentile columns show the mid-point of the market distribution range (for either salary or hourly rates) for jobs with similar responsibilities to the employees, according to the configured market data. |
|
Job Assignment Column |
The Job Assignment column is included by default in worksheets that are configured to allow promotions. This column shows each employee's current job assignment. When you promote an employee, Dayforce shows both the old and new job assignment in this column. |
|
Performance Rating Column |
The Performance Rating column is included in worksheets that are configured to use performance ratings. This column allows you to review or enter performance ratings for your employees. See Performance Ratings in Compensation Worksheets. |
|
Pay Component Columns |
Pay component columns are included in each worksheet, as configured in Compensation Setup > Compensation Cycles. You can use these columns to allocate budget to your employees. See Allocate Budget to Employees. Note: These columns are color-coded in the worksheet according to the cycle configuration. |
) is shown next to calculated values (such as target bonuses, prorated salaries, and currency conversions) in the worksheet. You can click this icon to view additional calculation details. 
) next to the drop-down list for each employee. You can click this icon to open a tooltip with a description of each of the available experience levels.