Understanding Compensation Pivot Grids
PeopleSoft Pivot Grid is a PeopleTools technology that provides operational dashboard reporting. Pivot Grids are self-service, multi-dimensional analytics built into the applications that provide users with improved analytic capabilities and the business intelligence needed to make informed decisions. Compensation leverages this functionality and builds pivot grids that will streamline the process of viewing and analyzing data for users in compensation cycles.
Using pivot grids:
Managers can view salary information in a graphical format to better understand the overall compensation levels of their employees. They are able to view and compare the performance rating and compensation levels of their direct and indirect reports to ensure that their employees are being compensated equitably according to their performance.
Administrators are able to keep track of the status of all salary proposals within a compensation cycle, as well as identify the proposals that are outside the recommended guidelines that need follow-up.
Compensation delivers a number of pivot grids to provide quick, real-time reporting capabilities to administrators and managers during a compensation cycle. By default, they are displayed as charts but users can change to the display option easily to have them presented in the grid format.
For more information on the setup and capabilities of PeopleSoft Pivot Grid, see PeopleTools: Pivot Grid.
Salary Increase by Performance
This chart shows the percentage or amount allocated for all direct and indirect reports of a manager within a particular compensation cycle, broken down by performance rating. It helps managers to reward their employees commensurate with their performance level.
This pivot grid is available only for salary plans.
Variable Compensation by Performance
This chart shows the amount allocated for all direct and indirect reports of a manager for a specific cash type variable compensation plan within a particular compensation cycle, broken down by performance rating. Its functions are similar to the Salary Increase by Performance pivot grid except that it is built for cash-type variable compensation plans.
Salary Analysis
This chart shows a comparison of salary compensation for all of a manager’s employees, broken down by employee. Managers can drill into each data segment (bar, pie wedge, and so on) in the chart to view each employee’s salary data and see how their team members compare to each other with respect to compensation.
Compensation Distribution
This chart shows how the salary amounts of a manager's direct reports are distributed within their salary range. Managers can see where their employees are compared to their salary minimum, maximum and midpoint. They can drill into each data segment in the chart to view the compensation distribution of employees by job family or proposal status.
Cycle Guidelines
This chart shows the numbers of allocation proposals that fall within and outside of the recommended guidelines, as defined by the minimum and maximum salary increase percentages. It provides drill-through capability for administrators to view the data by proposal status, group node, department, location, salary plan and so on. Administrators can use the group node entry to see who they might later want to follow up with regarding any proposals that fall outside the recommended guidelines.
Cycle Tracking
This chart shows the total number of proposals, broken down by proposal status. It provides drill-through capability for administrators to view the data by location, job code, employee, and so on. When necessary, they can notify the appropriate people (shown in group node) regarding issues they find in the proposals.