Loading position rates of pay involves entering or updating the compensation rates assigned to various job positions within your organization. This practice is essential for ensuring accurate payroll calculations and maintaining compliance with internal pay structures and external regulations.
By correctly loading position rates of pay, you ensure that employees receive the appropriate compensation for their roles.
We've compiled a list of steps to guide you on how to load, view, delete and carry out bulk updates for employees on a position rate.
Upload rates
To upload new position rates of pay for an employee, follow the steps below.
Create your CSV file.
The table below describes the fields that are available for loading new position rates of pay. The order of the fields is critical and should be aligned with this table.
Field Name | Contents |
Position | Position Scale/Grade as held via the Position References field. |
Point | Scale Point(s) associated with the Position Reference |
Rate Sequence | Always 1 (change accordingly for environments that use rate sequence ) |
Date Effective | DDMMYYYY |
Hourly Rate | Define value, otherwise set to 0 if not used |
Daily Rate | Define value, otherwise set to 0 or leave null if not used |
Weekly Rate | Define value, otherwise set to 0 or leave null if not used |
Annual Salary | Define value, otherwise set to 0 or leave null if not used |
Unit Type | Define value, otherwise set to 0 or leave null if not used |
Portal
After creating your CSV file with the fields, log in to portal and follow the steps below.
Click Uploads then under Rate of Pay Uploads, click Load Position Rates of Pay.
In the Reference field, enter a reference number then for File Type, select CSV.
To locate and upload the relevant CSV file, click Browse.
To complete the upload, click OK.
The new position rates will be uploaded on the PeopleXD system with new effective date. Once the system date reaches the new effective date, the system will create new salary for employees based on the rate effective.
📌Note: Rates are read by date effective and date input. If you input rate today for 01/09/22 and then input new rates in 3 months time for effective 01/09/22 they should all calculate arrears.
Delete incorrect upload
To delete the incorrect position rate of a pay file, follow the steps below.
Click Uploads.
Under Rate of Pay Uploads, click Load Position Rates of Pay.
In the Reference field, enter the reference for the load that was used during the original upload.
Click Delete.