PeopleSoft Enterprise Human Resources 9.1 PeopleBook: Manage Base Compensation and Budgeting

Viewing and Reporting Summary Salary Data

This chapter discusses how to:

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

Viewing Compensation History

This section provides an overview of compensation history and discusses how to view a compensation history.

Understanding Compensation History

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

It also 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	Definition Name	Navigation	Usage
Employee Compensation History	COMP_SUMMARY	Compensation, Base Compensation, Review Salary Information, Employee Compensation History, Employee Compensation History	View the history of all pay rate changes the worker has received to date. This reference is useful when planning new increases.
Rate Code	WCS_RTCD_DETAILS	Click Details on the Compensation History: Controls page.	View additional information about the compensation rate code from the Comp Rate Code table.

Viewing a Compensation Summary

Access the Employee Compensation History page (Compensation, Base Compensation, Review Salary Information, Employee Compensation History, Employee Compensation History).

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

Seq (sequence)	The sequence number of the salary change action.
Action and Action Reason	The action and reason that resulted in a salary change.
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.
Yrs Grade (years in grade)	The number of years the worker has been in this grade.
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.
Month Last Incr (month last increase)	The number of months since the last increase.
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.
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.
Annual Rate	The worker's new annual rate as of this effective date, sequence, action, and reason.
% Range (percent range)	The worker's new percent that is in range for the effective date, sequence, action, and reason. The system calculates the percent in range figure from the data in the Salary Grade table.

Pay Components

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

Running Compensation Change Reports

This section lists the pages used to run:

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	Definition 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 by Company	RUNCTL_PER023	Compensation, Base Compensation, Compensation Reports, Salary History by Company	Run the Salary History by Company report (PER023). This report displays each salary change for a worker during a specified time period.
Employee Compensation Changes	RUNCTL_PER013	Compensation, Base Compensation, Compensation Reports, Employee Compensation Changes, Employee Compensation Changes	Run the Employee Compensation Changes report (PER013). This report 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). This report lists all workers who have received a merit increase during the period entered on the parameter page.

Viewing Worker Ranking

This section provides an overview of worker ranking and 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 it 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 Anonymous Ranking 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 it displays the location, annual rate, compa-ratio, and percent in range.

Pages Used to View Worker Ranking

Page Name	Definition 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.
Rate Code	WCS_RTCD_DETAILS	Click Details on the Salary Components: Controls page.	Review detail information about a specific rate code.
Anonymous Ranking	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 (Compensation, Base Compensation, Review Salary Information, Employee Ranking by Job Code).

Minimum Pay Rate-Annual

The minimum annual salary in the grade.

Midpoint Pay Rate-Annual

The midpoint annual salary in the grade.

Maximum Pay Rate-Annual

The maximum annual salary in the grade.

Ratios Tab

Compa-Ratio	Where workers' salaries lie in relation to the range midpoint for their salary grade.
%Range (percent range)	Where workers' salaries fall within the range for their salary grade.
	Click the Component Details icon 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 (click the Component Details icon on the Employee Ranking by Job Code page: Ratios tab).

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

Common Elements Used in This Page

Compensation Rate and Comp Freq (compensation frequency)

The worker's annual compensation rate and compensation frequency.

Pay Components

This section of the page displays the details of the compensation package associated with the worker's most current job data row, as 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. On 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.
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.

Controls Tab

Default Without Override

If this check box is selected, the compensation rate of the workers assigned to this rate code cannot be manually updated on the Compensation page of the Job Data component.

Typically, this option is used for seniority rate codes. It is also used for rate codes that use an absorbable premium on the Salary Plan table after the rate code has been added to a worker compensation package.

Details

Click to view the details of the Rate Code definition and to access the Rate Code page, which displays more information about the rate code.

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

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

Viewing Workers' Compensation Rank With Privacy Protected

Access the Anonymous Ranking page (Compensation, Base Compensation, Review Salary Information, Anonymous Ranking).

The fields on this page are identical to the fields on the Employee Rank by Job Code page with these exceptions:

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.
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 provides an overview of job evaluations and discusses how to compare job evaluation criteria among job codes.

Understanding 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 various skills, such as knowledge and experience (Knowhow), accountability, and problem-solving. On the Job Evaluations by Grade inquiry page, you can view the evaluation information along with 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.

Pages Used to View Job Evaluations by Grade

Page Name	Definition 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 USF	GVT_JOB_EVALUATION	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 (Compensation, Base Compensation, Review Salary Information, Job Evaluations by Grade).

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.

Minimum Pay Rate-Annual	The minimum annual salary in the grade.
Midpoint Pay Rate-Annual	The midpoint annual salary in the grade.
Maximum Pay Rate-Annual	The maximum annual salary in the grade.