Viewing and Reporting Summary Salary Data

This chapter provides an overview of summary salary data and discusses how to:

View compensation history.
Run reports of compensation changes.
View worker ranking.
View job evaluations.

Viewing Compensation History

This section discusses how to:

View compensation history.
View compensation rate codes.

Understanding Compensation History

The Compensation History page shows the starting salary and all subsequent increases a worker has received. It does not display every administrative action; for example, it does not show job movements. It does show the Hire and Rehire actions and any administrative action that results in a change in salary data.

It shows the number of months since the worker’s last increase, as well as how long the worker has been in a salary grade, as of today. The details by pay component appear in a grid at the bottom of the page.

Pages Used to View Compensation History

Page Name	Object Name	Navigation	Usage
Compensation History	COMP_SUMMARY	Compensation, Base Compensation, Review Salary Information, Employee Compensation History	View the history of all pay rate changes the worker has received to date. This is a useful reference when planning new increases.
Comp Rate Code	COMP_RATECD5_SEC	Click Details on the Compensation History: Amounts page.	View additional information about the compensation rate code from the Comp Rate Code Table.

Viewing a Compensation Summary

Access the Compensation History page.

For each salary change the system displays the following data from the worker’s job and compensation records:

Month Last Increase(number of months)	The number of months since the last increase.
Seq (sequence)	The sequence number of the salary change action.
Action and Reason	The action and reason that resulted in a salary change.
Comp Rate (compensation rate) and Frequency	The worker’s compensation rate as of this effective date, sequence, action, and reason along with the frequency with which it is paid.
Annual Rate	The worker’s new annual rate as of this effective date, sequence, action, and reason.
Change Amount	The amount of the worker’s increase for this effective date, sequence, action, and reason.
Change Percent	The percent increase for this effective date, sequence, action, and reason.
Plan, Grade, and Step	The worker’s salary administration plan, salary grade, and salary step for this effective date, sequence, action, and reason.
Grade Entry Date	The date the worker entered the grade.
Compa Rto (compa-ratio)	The worker’s new compa-ratio for this effective date, sequence, action, and reason. The system calculates the compa-ratio figure from the data in the Salary Grade Table.
PIR (percent in range)	The worker’s new percent in range for this effective date, sequence, action, and reason. The system calculates the percent in range figure from the data in the Salary Grade Table.
#Yrs (number of years)	The number of years the worker has been in this grade.

Pay Components

The Amounts, Changes, and Conversions tabs display detailed pay information.

Running Compensation Change Reports

To run compensation change reports, use the Salary History By Employee (RUNCTL_CMP011), Salary History by Group (RUNCTL_CMP014), Salary History by Company (RUN_PER023), Employee Compensation Changes (RUN_PER013), and Report Merit Increases (RUN_SP_MERIT_RPT) components.

This section discusses how to generate:

Compensation history reports for a worker, group, or company.
Lists of workers who have received compensation rate changes or merit increases within a specified period.
Lists of workers who have not received a merit increase within a specified period.

Pages Used to Run Compensation Change Reports

Page Name	Object Name	Navigation	Usage
Salary History by Employee	RUNCTL_CMP011	Compensation, Base Compensation, Compensation Reports, Salary History By Employee	Print the Salary History by Employee report (CMP011). This report displays each salary change for a worker during a specified time period. For each salary change, it lists the associated job action, effective date, job code and title, salary grade, compensation rate, monetary amount, and percentage of change.
Salary History by Group	RUNCTL_CMP014	Compensation, Base Compensation, Compensation Reports, Salary History By Group	Run the Salary History by Group report (CMP014). This report provides the salary changes for the workers in a group during a specified time period. For each salary change, it lists the associated job action, effective date, job code and title, salary grade, compensation rate, monetary amount, and percentage of change.
Salary History for Company	RUNCTL_PER023	Compensation, Base Compensation, Compensation Reports, Salary History By Company	Run the Salary History for Company report (PER023) that displays each salary change for a worker during a specified time period.
EE Compensation Changes	RUNCTL_PER013	Compensation, Base Compensation, Compensation Reports, Employee Compensation Changes	Run the Employee Compensation Changes report (PER013) that lists workers who have had compensation rate changes within a selected time period.
Report Merit Increases	RUNCTL_SP_MERIT	Compensation, Base Compensation, Merit Increases, Report Merit Increases	Run the Merit Increase report (PER041) that lists all workers who have received a merit increase during the period entered on the parameter page.

Viewing Worker Ranking

To view worker ranking, use the Employee Ranking by Job Code (JOB_RANKING) and the Anonymous Ranking (JOB_RANKING_NO_EE) components.

This section discusses how to:

View worker ranking in terms of compensation.
View the details of worker compensation packages.
View unidentified workers ranking in terms of compensation.

Understanding Worker Ranking

The system provides two inquiry pages for viewing how workers rank in terms of compensation within a job code. Both pages group workers by salary plan and show the current ranges for the salary plan and grade. Use this information to compare compensation to the minimum, maximum, and midpoints for the grade, and to determine whether workers in a job code are being paid equitably in each location.

The Employee Ranking by Job Code page lists workers by name and worker ID, and displays their location, annual rate, compa-ratio, and percent in range.

Use a link to the Salary Components page to view the details of the selected worker’s compensation package.
The Ranking by Job Code - No Name page lists worker compensation without displaying names and worker ID numbers to preserve privacy.

The page sorts worker compensation by currency in descending order of salary amounts, and displays the location, annual rate, compa-ratio, and percent in range.

Note. The Manage Performance business process in PeopleSoft Human Resources also uses the Employee Ranking by Job Code and Ranking by Job Code - No Name pages.

Pages Used to View Worker Ranking

Page Name	Object Name	Navigation	Usage
Employee Ranking by Job Code	JOB_RANKING	Compensation, Base Compensation, Review Salary Information, Employee Ranking by Job Code	View how workers rank in terms of compensation within a job code.
Salary Components	COMP_EMPL_RANK_SEC	Click Component Details on the Employee Ranking by Job Code: Ratios page.	View the details of the worker’s compensation package associated with the current job data row.
Comp Rate Code (compensation rate code)	COMP_RATECD5_SEC	Click Details on the Salary Components page.	Review detail information on a specific rate code.
Ranking by Job Code - No Name	JOB_RANKING_NO_EE	Compensation, Base Compensation, Review Salary Information, Anonymous Ranking	View how workers rank in terms of compensation within a job code. To protect privacy, worker identification does not appear on the page.

Viewing Worker Ranking in Terms of Compensation

Access the Employee Ranking by Job Code page.

Min/Annual (minimum annual)

The minimum annual salary in the grade.

Midpt/Annual (midpoint annual)

The midpoint annual salary in the grade.

Max/Annual (maximum annual)

The maximum annual salary in the grade.

Compensation Ranking

workers are listed from the highest compensation to the lowest.

Ratios tab

Compa-Ratio	Where workers’ salaries lie in relation to the range midpoint for their salary grade.
%Range	Where workers’ salaries fall within the range for their salary grade.
	Click Component Details to access the Salary Components page, where you can view workers’ compensation details by pay component.

Viewing the Details of Worker Compensation Packages

Access the Salary Components page

For each salary change, this page displays pay component details from the worker’s job and compensation records.

Common Page Information

Compensation Rate and Comp Freq (compensation frequency)

The worker’s annual compensation rate and compensation frequency.

Pay Components

This section displays the details of the compensation package associated with the worker’s most current job data row displayed on the Employee Ranking by Job Code page.

Amounts tab

For each salary change this page displays pay component details from the worker’s job and compensation records. In the Amounts tab, the system displays the description of the pay component before the salary change.

Rate Code	The rate code of the salary change.
Seq (sequence)	The rate code sequence number.
Details	Click to view the details of the Rate Code definition and to access the Comp Rate Code page where more information about the rate code is displayed.
Comp Rate (compensation rate), Currency, and Frequency	The compensation rate, currency, and frequency associated with the rate code.
Points	If the rate code type is Points, the system displays the number of points defined for this rate code.
Percent	If the rate code type is Percent, the system displays the percent defined for this rate code.
Rate Code Group	If the rate code type is Percent, the system displays the rate code group to which the percent applies.

Changes tab

Change Amount	If the rate code type is flat amount or hourly rate, the system displays the change amount associated with the rate code.
Change Points and Change Percent	If the rate code type is Points or Percent, the system displays the change points and the change percent associated with the rate code.

Conversion tab

Default Without Override
Apply FTE	This check box is selected if you elected to apply FTE calculations to frequency calculations of this rate code.
Converted Comp Rate (converted compensation rate)	The new compensation rate for the rate code converted to the worker's compensation frequency and currency.

Viewing Workers’ Compensation Rank With Privacy Protected

Access the Ranking by Job Code - No Name page.

All the fields on this page are identical to fields on the Employee Rank by Job Code page, except for the following fields:

Grade Date	The date the worker entered the salary grade.
Yrs Grade (years in grade)	The number of years the worker has been in the grade.

Viewing Job Evaluations

This section discusses how to compare job evaluation criteria among job codes.

Understanding Viewing Job Evaluations

A job evaluation is a method of ranking job codes relative to one another. You create job evaluation criteria in the Job Code Table, assigning points for Knowhow, Accountability, and Problem-solving skills. In the Job Evaluations by Grade inquiry page, you can view the evaluation information alongside the managerial level and function of each job code. Job codes are sorted in descending order by total points.

You can also generate the Job Grading by Evaluation Points report (CMP002), which provides similar information.

Note. The Manage Performance business process in PeopleSoft Human Resources also uses the Job Evaluation by Grade page.

Pages Used to View Job Evaluations by Grade

Page Name	Object Name	Navigation	Usage
Job Evaluations by Grade	JOB_EVALUATIONS	Compensation, Base Compensation, Review Salary Information, Job Evaluations by Grade	Compare job evaluation criteria among job codes within a salary plan and grade.
Job Evaluations by Grade	GVT_JOB_EVALUATIONS	Compensation, Base Compensation, Review Salary Information, Job Evaluations by Grade USF	Compare job evaluation criteria among job codes within a salary plan and grade.

(GBL) (USF) Comparing Job Evaluation Criteria

Access the Job Evaluations by Grade page.

Current Annual Ranges

The system displays the following information about the salary grade, as you defined it on the Salary Grade Table page:

Minimum, Midpoint, and Maximum

Minimum, midpoint, and maximum annual compensation in the grade.

Job Evaluation

Total Points, Job Function, and Manager Level	Enter the corresponding values associated with this job code.
Knowhow, Accountability, and Problem-Solving	Displays the number of points associated with this criterion for this job code.

Min/Annual (minimum annual)	The minimum annual salary in the grade.
Midpt/Annual (midpoint annual)	The midpoint annual salary in the grade.
Max/Annual (maximum annual)	The maximum annual salary in the grade.