Guidelines to WPS
File Format
The Wages Protection System (WPS) was
implemented at the Central Bank of the UAE (CBUAE) to meet the desired
objectives of the Ministry of Labour (MOL). The
objective of UAEWPS is to provide a Safe, secure, efficient and robust
mechanism to streamline the timely payment of wages to employees by their
employers.
Mashreq Business Online provides the facility to
Mashreq customers to upload WPS file for processing the salaries of the
employees.
The file that needs to be uploaded
should be in .SIF format and the
name of the file should be as per the below standard:
EEEEEEEEEEEEEYYMMDDHHMMSS
EEEEEEEEEEEEE: Employer Unique ID
Employer Id can vary in length upto
13
YYMMDD :
File Creation Date
HHMMSS :
File Creation Time
The file will contain EDR records in
separate line for each employee where the salary payment needs to be paid. Each
employee record will start with EDR to indicate it is for the salary payment
for the employee.
At the end of the file there will be one
SCR record which will be the summary of the entire WPS file. The details of the
EDR and SCR record are provided below.
EDR – Employee Detail Record for each employee
Each employee record should be mentioned in a separate
line and each field should be comma separated. e.g.
EDR,10003128177364,201234567,AE920330000010790321544728,2015-04-01,2015-04-30,30,9500,0.00,0
EDR,200220128829070, 201234567,AE310333000010767710393,2015-04-01,2015-04-30,30,8400,0.00,0
|
Sr.
No |
Field
Name |
Length |
Details |
|
1 |
Record Type |
03 Characters |
Should always be “EDR” |
|
2 |
Unique Employee ID |
14 Characters |
Employee ID as per Labor Regulatory
Authority |
|
3 |
Routing Code of
AGENT |
09 Digit |
Routing code provided
by Central Bank. If the routing code is invalid then the entire WPS file will
be rejected. |
|
4 |
Employee Account |
23 Characters |
Employee Account / IBAN or Payroll
Card number. If any of the account number is incorrect then the entire WPS
file will be rejected. |
|
5 |
Pay Start Date |
10 Characters |
Must be YYYY-MM-DD. This cannot be
less than or more than 1 year from the current date. The Pay Start Date
should be equal to the date in the file name. |
|
6 |
Pay End Date |
10 Characters |
Must be YYYY-MM-DD. This needs to be
greater than Pay Start Date. |
|
7 |
Days in Period |
4 digit |
This must be equal to (“Pay Start
Date” - “Pay End Date” + 1) |
|
8 |
Income Fixed
Component |
15 digits |
Valid Amount in AED with 2 decimal
places (e.g. 2345.67, 23.00). No negative amount allowed. |
|
9 |
Income Variable
Component |
15 digits |
Valid Amount in AED with 2 decimal
places (e.g. 2345.67, 23.00). No negative amount allowed. |
|
10 |
Days on Leave
for period |
4 digits |
This is number of days the employee
has taken leave without pay in the pay period. If no leave without pay then
please mention “0”. |
SCR – Salary Control Record at the end of every file
At the end of the file there should be an SCR record
which provides the summary of the entire file. e.g.
SCR,0000000330894,203526101,2015-04-27,0937,042015,10,212150,AED,TEM1
|
Sr.
No |
Field
Name |
Length |
Details |
|
1 |
Record Type |
03 Characters |
Should always be “SCR” |
|
2 |
Employer Unique Id |
13 Characters |
The 16 digit unique ID for employers
provided by Labor Regulatory Authority. |
|
3 |
Routing Code of Employer Bank |
09 Digit |
Routing code provided by Central Bank. If the
routing code is invalid then the entire WPS file will be rejected. |
|
4 |
File Creation Date |
10 Characters |
Must be of the form YYYY-MM-DD Shall be the date that is less than or equal to that
of the processing date on WPS |
|
5 |
File Creation Time |
4 Characters |
Must be of the form HHMM |
|
6 |
Salary Months |
6 Characters |
Must be of the form MMYYYY The actual month for which the salary is being paid.
Please note that Labor Authority makes key decisions based on the value
provided in this field. The file will be rejected if the data supplied in
this field is not in the same month & year as that provided in the Pay
Start & End Date of all employees in the EDR records. |
|
7 |
EDR Count |
10 Digit |
Must be the number of Employees in the
EDR record |
|
8 |
Total Salary |
15 Digits |
Valid amount (e.g., 2345.87 / 23.00 /
22). This is the sum of all fixed and variable salary
components of all employees mentioned in the EDR records. |
|
9 |
Payment Currency |
3 Characters |
Should always be “AED” |
|
10 |
Employer Reference |
35 Characters |
Documentary Field (Optional). Please
mention “NONE” if no employer reference is to be provided. |
Key Information
·
Please ensure the
Employee ID and IBAN are correct for all employees. Even if the IBAN or ID is
not correct for single employee the entire file will be rejected within 2
working days which may cause delay in salary processing of your employees.
·
The file name
should be given special consideration specially the Date Time on the File Name,
EDR and SCR record. If any date time mismatch is observed between any of the
record the entire file will be rejected by the bank.
· We are currently not processing any payments for “Bank Sedarat Iran” and “Bank Milli Iran”. If any of these banks IBAN or account number is provided the entire file will be rejected by the bank.