Single Worksheet Overview

Role feature access: Compensation Administration > Compensation Cycle Administration > View Organization in Single Worksheet

In Compensation and Compensation Administration > Compensation Cycle Administration features, you can view the worksheets of all managers across the organization consolidated in a single worksheet. Generally, senior managers, compensation administrators, and business partner roles have access to view the single worksheet in the organization. This single worksheet view helps you review and enter allocations for employees by monitoring the organization's overall budget. You can also use the single worksheet view for the following purposes across the organization:

Compare allocations for employees with similar performance ratings.
Review allocations for employees in their local currency.
Compare the current and new salary for employees in a similar job assignment.

You can access the single worksheet if you have the role feature access, an organization for the compensation cycle, and more than one worksheet in the organization, including your worksheet.

The single worksheet contains the budget summary section, which includes each pay component's total and remaining budget in the currency configured for the compensation cycle. When you expand the budget summary section, you can view the list of managers who are direct or indirect reports in the selected organization along with the number of employees in their worksheet.

The single worksheet lists a maximum of 400 employee records. You can filter the list of employees in the worksheet. The single worksheet shows pay components configured with the Salary Increase, Bonus, and Equity reward types, as grouped columns for the employee list. You can enter or update allocations for the pay components if the fields in the single worksheet are editable. The fields in the worksheet are editable based on your role, the configured compensation cycle, the workflow level, and the worksheet status. For example, a senior manager that uses a compensation cycle with the worksheet level workflow can’t edit the single worksheet when the status of the submitted worksheet is Pending Final Approval, but a compensation administrator can enter or update allocations. When you enter allocations, the budget summary section gets updated automatically.

You can also do the following in the single worksheet view:

Display the required worksheet columns using the View button in the worksheet toolstrip.
Filter employees based on various criteria using the Filter button in the worksheet toolstrip.
Save and manage filters using the Favorites button in the worksheet toolstrip.
View compensation details in different currencies other than the local currency of the employee using the Currency button in the worksheet toolstrip.
Auto-allocate for the filtered list of employees using the Auto-Allocate button in the worksheet toolstrip.
View the Job Assignment in Salary Range and Performance Rating and Gender Pay Equality charts using the Charts button in the worksheet toolstrip.
Export employees in the selected organization using the Export button in the worksheet toolstrip.
View the calculation details for pay components.
View the promotion details of employees.
View audit information in a tooltip.
Enter worksheet level comments for managers.
Enter comments for each employee.
Update the experience level for each employee.
View the market data information for each employee.
Access performance review information of employees.
Select or update performance rating for employees.
View employees that are manually excluded from the pay component posting process.
Save worksheets with blank or no allocations.

The following topics provide more information about the single worksheet view: