Employees Tasks and Processes > Employment Processes > Mass Update Pay Rate

Mass Update Pay Rates

The Mass Update Pay Rate process allows you to change the pay rate for an entire group of employees at one time. You select the group or groups of employees whose rates or amounts are to be changed as well as the new rate.

We recommend you back up your data before beginning the Mass Update Pay Rate process. Backing up your data before you change it ensures you can always restore the original data and repeat the process if needed.

To Mass Update Pay Rates

From the navigation pane, select Employees > Processes > Mass Update Pay Rate.

This window allows you to specify the employees to be included in the process as well as which records you want to update. After you select the employee records to update, you are ready to choose a pay change date, reason, and the new pay rate.

View the Field List

Field Label	Field Description
Employer	Your selection of Enterprise or the individual employers to be affected by the change. If you select Multiple, a two-list chooser opens, allowing you to select the employers to include.
Organization Levels 1-5	The organization level that contains the employees for whom you want to change the pay rate. If you leave an organization level field blank, all the organizations within that level will be included in the pay rate update.
Changed Since	Enables you to change only employees whose pay rates have changed since a specified date.
Active	Selects active employees.
LOA	Selects employees on leave of absence.
Terminate	Selects terminated employees.
Employee	Selects a specific employee or group. For more information, read the Selecting Specific Employees Help topic.
Custom Criteria	Additional selection criteria, entered from the Criteria Code Table, the Criteria Builder, or the FoxPro Expression Builder. These features allow you to define criteria beyond the standard selection criteria provided by the Mass Update Pay Rate page. For more information, see Entering Your Own Criteria for Selecting Employees.
Exempt	Selects exempt or nonexempt employees.

Enter the new pay rate

When you select the employee records to update, you are ready to choose a pay change date, reason, and the new pay rate. Click OK on the Mass Update Pay Rate page to display the Pay Rate Update Selections page.
The Pay Change Date field defaults to today’s date and the Change Reason field defaults to the first alphabetical description in the Reason code table. If necessary, you can change the date or select another Reason code from the drop-down list. For more information see Reason codes.
You can enter the new rate directly in the New Pay Rate field or you can use the Expression Builder to assist you in building an expression for the pay rate. If you enter the rate directly, do not include a dollar sign or any commas. For instance, to enter a pay rate of $2,500, type 2500.
Or, to give a pay raise of 10 percent to every employee you selected, use the Expression Builder to help build the formula for the new rate.
From the Custom Criteria drop-down list, select Visual FoxPro Expression Builder to access the Expression Builder.
The Expression Builder helps you create the three parts of the expression. The box at the top of the Expression Builder is where your expression appears as you build it. You can use the other boxes to help build the expression. For this example, we will increase pay rates for selected employees by 10% of their current salary.
In the Fields list, scroll down to and double-click the field identified as "p_salary." Note that the Expression Builder inserts the field name in the expression box as "Pe.p_salary."
Click the Math drop-down list to choose a mathematical operator. Click * to indicate multiplication. The Expression Builder inserts the asterisk in the expression box.
Enter 1.1 directly in the expression box. The completed expression should look like this:Pe.p_salary * 1.1
Click OK to close the Expression Builder and save the expression in the Custom Criteria field.

Complete the process

Click OK to perform the Mass Update Pay Rate process.

Sage HRMS displays a message box telling you how many records will be updated and prompts you to proceed.
If you want to back up your database before the system mass updates the pay rate, click No and back up your data before you proceed.

If you click Yes, Sage HRMS performs the pay rate update and indicates the number of records updated upon completion.

Notes:

The Mass Update Pay Rate process adds the pay rate increases to the employees' job history files.
This process will not generate a history record for savings plans because the flat amounts or percentage amounts are not changed as a result of this rate change.