The Change
A new Alert and Export have been developed. They show all salaried employees whose rate of pay is below the national minimum wage (NMW) for a given pay period.
1. 143911 – Salaried Employees NMW - Alert
2. 143912 – Salaried Employees NMW - Export
Reason for the Change
Salaried employees who are included in the rota are scheduled to work certain hours each day; irrespective of these hours they are paid their standard salary. In some circumstances this could result in employees working more hours than covered by their standard salary. The risk then incurred is that employees being are paid below the NMW in a given pay period.
This alert and export has been developed in order for People System customers to run a check to understand whether any of their employees are falling below the NMW. Customers are then able to take appropriate and timely actions with their impacted employees.
Customers Affected
All People System customers.
Release Notes
Calculation
- Employees will appear on the alert and export if their calculated gross pay is less than the calculated NMW.
- The gross pay is calculated as follows:
- The NMW is calculated as follows:
- If the salary is changed during the pay period then a pro-rata gross annual pay based on the number of days worked at the different salaries.
- If the NMW rate changes in the reporting period due to an age change or the HMRC rate change, the NMW rate will be pro-rata’d.
1. 143911 – Salaried Employees NMW – Alert
Fig 1 - Edit Alert
- To set up an alert showing salaried employees below national minimum wage follow the path: HR > Audit & Alerts Menu > Alert Set Up > Select an existing alert template or create a new one.
- Click the ‘Assign Events’ button.
Fig 2 - Assign Events
- Select the ‘Salaried Employees Below NMW’ event.
- Save the assigned events.
- Save the edited alert template.
2. 143912 – Salaried Employees NMW - Export
Export Location
Fig 3 - Export Location & Criteria
- The export is located in the Rotas module: Rotas > Reports > Exports > Export Name: ‘Salaried Employees Below NMW’.
- The export displays data only from current pay period.
Export Fields
The export contains the fields below:
Column | Field | Format | Example |
---|---|---|---|
A | Employee Name | Text | Tom Jones |
B | Employee Number | Text | FH1089 |
C | Location | Text | Regent Street |
D | Age | Number | 37 |
E | NMWRate | Currency | 6.31 |
F | AnnualSalary | Currency | 24000 |
G | TotalHrsWorked | Decimal | 390 |
H | SalaryForPayPeriod | Currency | 2000 |
I | NMWPay | Currency | 2410 |
J | HoursScheduledNetOfNMW | Decimal | -66.3 |
K | Week/Month Number | Number | 1 |
L | DateFrom (Pay period start date) | Date | 01/01/2014 |
M | DateTo (Pay period end date) | Date | 31/01/2014 |
Comments
0 comments
Please sign in to leave a comment.