Processing Mass Salary Increases

This chapter discusses how to:

Update salaries by salary plan or pay group.
Update salaries by job code.
(USF) Administering mass pay adjustments

Updating Salaries by Salary Plan or Pay Group

To update salaries by salary plan or pay group, use the Update by Sal Plan/Paygroup (RUNCTL_CMP008) component.

This section provides an overview of updating salaries and discusses how to update the job compensation rate.

Understanding Salary Updating

Use the Update by Sal Plan/Paygroup (update by salary plan or paygroup) process to perform salary grade or step updates for all workers in a salary grade. This is useful if the compensation has changed retroactively. Use pay group parameters or salary plan parameters to run the update.

The system performs the following processes for all workers in the specified pay group or salary grade during the specified time period:

For grade changes, the system checks the Salary Grade Table for any changes in minimum, midpoint, and maximum pay rate during the specified dates for the worker’s job. If it finds a pay rate change, it enters a new job row with the effective date of the grade change.
For step changes, the system compares the compensation package of the worker with the package of the step. If it finds a change in the step, it enters a new job row with the effective date of the step change, the new package, and marks it as a manual change.

To run the Update by Sal Plan/Paygroup process:

Run the process (CMP008) using PeopleSoft Application Engine to apply the update to the salary plan or paygroup.
Run the SQR report (CMP008) to review the data created by running the process.
In a separate run, run process HR_SP_CI using PeopleSoft Application Engine to load data to the Job Data pages for your workers.

Note. You run all these processes from the same run control page but you must have run the CMP008 Application Engine program and SQR report to completion before you run the HP_SP_CI Application Engine program.

Page Used to Run the Sal Plan/Paygroup Process

Page Name	Object Name	Navigation	Usage
Update by Sal Plan / Paygroup	RUNCTL_CMP008	Compensation, Base Compensation, Maintain Plans, Update by Plan/Paygroup	Update the job compensation rate when the salary grade or step changes retroactively.

Updating the Job Compensation Rate

Access the Update by Sal Plan / Paygroup page.

Report Request Parameter(s)

From Date and End Date	Enter the from and end dates of the period. The system retrieves the salary change between these dates.
Show Components on Report?	Select if you want the pay components to appear on the report.
Action and Reason	Enter the action and reason defining the salary update on the new job row.
Update Future Rows?	Select to have the process update future dated rows (those rows with an effective date later than the Salary Change Effective Date) with salary information.
Don’t Absorb Changes	Select to instruct the system to leave absorbable rate codes unchanged if there is a change in the defaulted salary amount. This option only applies to workers who have a Target Comprate and are assigned to a salary plan with the Auto Calculated Premium function enabled.

Process By

Paygroup	Select to process by pay group. The fields in the Paygroup Parameters group box become available.
Sal Plan/Grade	Select to process by salary plan and grade. The fields in the Sal Plan/Grade Parameters group box become available.
By Group? and Group ID	Select the process by Group ID. The Group ID field will become available. Enter the Group ID you want to process.

Paygroup Parameters

Company and Pay Group

Select the company and pay group for which you want to update salaries.

Sal Plan/Grade Parameters

Business Unit, Salary Administration Plan, and Salary Grade

Select the business unit, salary administration plan, and salary grade for which you want to update salaries.

Updating Salaries by Job Code

To update salaries by job code, use the Update by Job Code (RUNCTL_CMP010) component. Use the CI_JOB_CODE_TBL component interface to load data into this component interface.

This section provides an overview of the Update by Job Code process and discusses how to reclassify a job code.

Understanding the Update by Job Code Process

Use the Update by Job Code process to update salary data for all workers in a job code when you change the job code salary administration plan, grade, or step in the Job Code Table. The process inserts a new job row with the action and action reason codes that you specify on the Run Control page. The effective date of the change is the From Date that you specify as the run control parameter.

Page Used to Update by Job Code

Page Name	Object Name	Navigation	Usage
Update by Job Code	RUNCTL_CMP010	Compensation, Base Compensation, Maintain Plans, Update by Job Code	Reclassify a job code.

Reclassifying a Job Code

Access the Update by Job Code page.

Business Unit

Select the business unit for which you want to update salaries.

Job Code

Select the job code that you are updating.

Start Date and End Date

Enter the start and end dates of the period for which you want to update salaries. The system uses the Start Date as the effective date of the salary change.

Action and Reason Code

Select the action and reason code that you want the system to enter on the new job row for the salary update.

(USF) Administering Mass Pay Adjustments

To administer mass pay adjustments for federal workers, use the Mass Pay Adjustments USF (MASS_PAY_SETUP) component.

This section helps you identify the processes necessary to administer pay adjustments and shows you how to:

Defining a mass pay type.
Defining a mass pay plan.
Defining mass pay adjustments.
Generate a mass pay adjustment report.

Understanding Mass Pay Adjustments

With PeopleSoft Human Resources for U.S. Federal Government, you can administer and manage mass pay adjustments.

During the calendar year, the President or his pay agent may authorize changes in the salary structures for executive branch workers covered by Title 5 of the United States Code. This authority also extends to other workers covered under other sections of Title 5, as well as some workers covered under other sections of the law.

The President may also authorize changes in geographic comparability adjustments such as Locality Pay Adjustments, Interim Geographic Adjustments, or Special Pay Adjustments for Law Enforcement Officers authorized by the Federal Employees Pay Comparability Act (FEPCA) and administered under 5 USC 5304.

The United States Congress, as well as heads of certain agencies, has the discretionary authority to adjust pay for certain categories of their workers. These authorities generally authorize pay adjustments for salaried workers to be effective government-wide at the beginning of the first pay period of the new calendar year.

To administer mass pay adjustments:

Define mass pay adjustment parameters on the Mass Pay Type page and the Mass Pay Plan page.
Process a pay adjustment for workers on the Mass Pay Adjustments page.
Generate a mass pay adjustment report.

Defining Mass Pay Adjustment Parameters

Prior to performing mass pay adjustments, you need to define Mass Pay Types and Mass Pay Plans for each Mass Pay Adjustment Type. The Mass Pay Adjustment Types available in the system include:

Annual Federal Wage Service
FWS Special Rate Increase
GS Annual Pay Adjustment
GS Special Rate Increase
LEO Special Pay Adjustment
Locality Pay Adjustment

Note. Mass pay adjustments can be processed using either a percentage increase or calculated using the updated pay table salaries. Once the pay adjustment has been calculated, the Next Scheduled Pay Adjustment data on the Salary Plan table needs to be updated in order for any additional pay adjustments.

Pages Used to Define Mass Pay Adjustments

Page Name	Object Name	Navigation	Usage
Mass Pay Type	GVT_MPA_TYPE_TBL	Set Up HRMS, Product Related, Payroll for North America, Compensation and Earnings, Mass Pay Adjustment USF, Mass Pay Type	Define the percentage of the pay increase and the date that the pay adjustment will go into effect. In addition, adjustment control information, such as Action, Reason Code, and NOA code data is necessary for the SF50.
Mass Pay Plans	GVT_MPA_ERNPGM_TBL	Set Up HRMS, Product Related, Payroll for North America, Compensation and Earnings, Mass Pay Adjustment USF, Mass Pay Plans	Identifies the pay plan to be included in the pay adjustment processing as well as the type of calculation that is used. Multiple pay plans can be processed one at a time.
Mass Pay Adjustment Pay Tables	GVT_MPA_PAYTBL_SEC	Set Up HRMS, Product Related, Payroll for North America, Compensation and Earnings, Mass Pay Adjustment USF, Mass Pay Plans Click the Pay Tables link.	Click to view the pay table associated with the mass pay adjustment.
Mass Pay Adjustment	RUN_FGPY005	Set Up HRMS, Product Related, Payroll for North America, Compensation and Earnings, Create Mass Pay Adjustment USF, Mass Pay Adjustments	Indicate the parameters required to process the mass pay adjustments, or, alternatively, to generate a report. You can process a single agency and pay adjustment type or multiple agencies and adjustment types.

Defining a Mass Pay Type

Access the Mass Pay Type page.

Percentage

Specify the percentage of increase for the pay adjustment. If the calculation type on the Mass Pay Plan equals Percent, the system will use the value in this field. The Effective Date and Percentage entered become part of the key fields on the Mass Pay Plan table.

Action

Specify the appropriate action code for this mass pay adjustment. The value selected here will be reflected on the Data Control page at the worker level.

Reason Code

Enter the corresponding reason code for the specified action. The value selected here will be reflected on the Data Control page at the worker level.

Nature of Action Code

Enter the NOA code that justifies this mass pay.

Authority Order No.

Use this free-format field to enter the executive order number or other legal authority number that identifies which executive order was issued for pay raises. This information will print on SF50.

Defining a Mass Pay Plan

Access the Mass Pay Plans page.

Pay Plan

Enter the pay plan for the group of workers to receive the pay adjustment. You can include multiple pay plans, if necessary.

Authority (1), Authority (2)

Enter the legal authorities for the mass pay adjustment.

Calculation Type

Specify the type of calculation to be used in pay adjustment processing: Pay Tables, Percentage, or Special Calculation Routine.

Pay Table Action

Specify which pay table entries should be included or excluded from the pay adjustment. Values are Exclude Tables Listed, Include All For Pay Plan, and Include Tables Listed. Unless all pay tables are to be included in processing pay adjustments, the Pay Tables link will display to enable you to specify the appropriate selections.

Pay Tables

Select this link to specify the pay tables to include or exclude when processing this Mass Pay Adjustment.

Defining Mass Pay Adjustments

Access the Mass Pay Adjustments page.

Pay Adjustment Type

Select the type of pay adjustment to be processed by agency. You can process multiple agencies and pay adjustment types.

Percentage

Specify the percentage of the pay adjustment.

GVT Mass Pay Adj Process Act

Indicate whether you want to generate a report only or process the action and produce a report.

Note. Make sure that there is an entry for Mass Pay (FGPY005) for the USFED transaction on the Transaction Setup page (Set Up HRMS, Product Related, Workforce Administration, Workforce Data USF, Approval Transactions). Click the Batch Programs tab to check if the USFED transaction is included.

Generating a Mass Pay Adjustment Report

The Mass Pay Adjustment report lists workers who cannot be processed. For one condition or another, the workers listed in this error report failed to be updated.

You can generate this report only after running the pay adjustment process. This report should not be run with the processing of the adjustment since it relies on a table that is created by that process – otherwise, no results will be generated. If you run this report prior to processing the Mass Pay Adjustment, you’ll be able to determine which workers have an exception. You can then process the exceptions manually.

The type of exceptions that will appear on the report are as follows:

Pay Rate Determinant of worker − review and process manually.
Future effective-dated action detected − review and process manually.
Duplicate action found for transaction − review and process manually.
No pay rate found for the worker.
No hourly conversion factor for worker standard hours.
The FEGLI base rate is not updated because of the override flag.

Once the Mass Pay Adjustment process has been executed, then the Mass Pay Type Definition you created will be updated with a status of Processed.

Business Unit	Select the business unit for which you want to update salaries.
Job Code	Select the job code that you are updating.
Start Date and End Date	Enter the start and end dates of the period for which you want to update salaries. The system uses the Start Date as the effective date of the salary change.
Action and Reason Code	Select the action and reason code that you want the system to enter on the new job row for the salary update.

Percentage	Specify the percentage of increase for the pay adjustment. If the calculation type on the Mass Pay Plan equals Percent, the system will use the value in this field. The Effective Date and Percentage entered become part of the key fields on the Mass Pay Plan table.
Action	Specify the appropriate action code for this mass pay adjustment. The value selected here will be reflected on the Data Control page at the worker level.
Reason Code	Enter the corresponding reason code for the specified action. The value selected here will be reflected on the Data Control page at the worker level.
Nature of Action Code	Enter the NOA code that justifies this mass pay.
Authority Order No.	Use this free-format field to enter the executive order number or other legal authority number that identifies which executive order was issued for pay raises. This information will print on SF50.

Pay Plan	Enter the pay plan for the group of workers to receive the pay adjustment. You can include multiple pay plans, if necessary.
Authority (1), Authority (2)	Enter the legal authorities for the mass pay adjustment.
Calculation Type	Specify the type of calculation to be used in pay adjustment processing: Pay Tables, Percentage, or Special Calculation Routine.
Pay Table Action	Specify which pay table entries should be included or excluded from the pay adjustment. Values are Exclude Tables Listed, Include All For Pay Plan, and Include Tables Listed. Unless all pay tables are to be included in processing pay adjustments, the Pay Tables link will display to enable you to specify the appropriate selections.
Pay Tables	Select this link to specify the pay tables to include or exclude when processing this Mass Pay Adjustment.

Pay Adjustment Type	Select the type of pay adjustment to be processed by agency. You can process multiple agencies and pay adjustment types.
Percentage	Specify the percentage of the pay adjustment.
GVT Mass Pay Adj Process Act	Indicate whether you want to generate a report only or process the action and produce a report.