Wages Protection System
File formats
General Notes
1.
a.
b.
All Employers have to send 2 types of files:
Salary Information File (SIF) For sending salary payment requests
Request for refund File (RFR) For initiating any refund request (Only in case of refund)
2.
3.
4.
All file contents will be in ASCII
Record formats will be COMMA SEPERATED VALUES (CSV)
Files that do not comply with the formatting standards will be rejected in its entirety
1. a. Salary Information File (SIF)
a. The SIF must be provided by the employer to their banker.
b. The SIF File comprises of 2 records:
Employee Detail Record (EDR)
Salary Control Record (SCR)
c. Each EDR must be for a unique employee
d. Not more than one EDR is permitted for each employee in a SIF File.
EDR
,10001016594125
,640110101
,4551902459
,2009-06-01
,2009-06-30
,30
,1221.92
,0
,0
EDR
,30305106000500
,640110101
,155481121
,2009-06-01
,2009-06-30
,30
,1000
,0
,0
SCR
,0000000009103
,302210101
,2009-07-16
,1107
,062009
,2
,2221.92
,AED
,1141
A = Alphabetic
(O) = Optional
MOL - Ministry of Labour
(M) = Mandatory
AN = Alphanumeric
B = Blank
N = Numeric
D = Date YYYY-MM-DD
EDR (Employee Detail Record)
Size/length
03
14
09
16
10
10
04
15
15
04
Field
Labels
Record
Type
Employee
ID
Agent ID
Employee
A/c with
agent
Pay
Start
Date
Pay
End
Date
Days in
Period
Income
Fixed
Income
Variable
Days on
Leave
Character
Type/Use
A/(M)
AN/(M)
N/(M)
AN/(M)
D/(M)
D/(M)
N/(M)
N/(M)
N/(M)
N/(M)
Must
be EDR
Unique as
provided
by MOL.
This field
will have
to be
padded
with
leading
zeros if
the length
is less
than the
max
length 14.
Valid
amount (e.g
2345.87 /
23.00 / 22. If
no
contribution
from the
component
then send
0.00
Days that
the
employee
has
availed of
leave
without
pay in the
pay
period. If
no leave
has been
availed
off, then
indicate
with zero
"0"
Remarks
The 9
digit head
office
routing
code as
assigned
to the
agent by
CB-UAE
The
employer
must
provide
the
account
number of
the
employee
as
provided
by the
agent.
YYYYMMDD
YYYYMMDD
Number
of
calendar
days for
which
the
salary is
being
paid
Valid
amount (e.g
2345.87 /
23.00 / 22. If
no
contribution
from the
component
then send
0.00
SCR (Salary Control Record)
Size/lengt
03
13
h
09
10
04
06
10
15
03
35
Field
Labels
Recor
d
Type
Employ
er ID
Bank Code
of
Employer
File
Creation
Date
File
Creatio
n Time
Salary
Month
EDR
Count
Total
Salary
Paymen
t
Currenc
y
EMR
Reference
Character
Type/Use
A/(M)
N/(M)
N/(M)
D/(M)
N/(M)
N/(M)
N/(M)
N/(M)
A/(M)
AN/(O)
Must
be
SCR
Unique
ID as
provided
by MOL.
This
field will
have to
be
padded
with
leading
zeros if
the
length is
less
than the
max
length
14.
HHMM
MMYYYY
. Shall be
validated
to be a
month +
year that
is either
equal to
or 1 more
than the
that of
the
processin
g month
+ year on
WPS
Numbe
r of
EDR
record
s in the
file
Valid
amount
(e.g
(2345.87 /
23.00 / 22)
will be
validated
to be equal
to the sum
of all the
fixed &
variable
component
s indicated
in all the
EDR
Records in
the file.
Currenc
y (AED)
only
Documentar
y field
Remarks
802420101
YYYYMM-DD.
Shall be
validate
d to be
a date
that is
less
than or
equal to
that of
the
processi
ng date
on WPS
1. b. Request for Refund File (RFR)
a. The RFR must be provided by the employer to their banker.
b. Only banks are allowed to transfer the RFR into WPS.
c. The RFR File comprises of 2 records:
reFund Details Record (FDR)
reFund Control Record (FCR)
FDR (reFund Details Record)
Size/length
03
50
50
09
14
15
03
Field
Labels
Reco
rd
Type
SIF File
Name
AC
K
file
na
me
Agent
Routing
Code
Employe
e ID
Refund
amount
Requested
Refund
Request
Code
Charcater
Type/Use
A/(M)
AN/(M)
N/(M)
AN/(M)
N/(M)
N/(M)
Must
be
FDR
SIF file name
in which the
salary
information
provided for
specific
employee.
Separate FDR
must be used
for each
SIF+Employee
combination
Lea
ve
Bla
nk
The 9 digit
routing
code as
assigned to
the agent
by CBUAE.
Validated
against the
master
database
help in
WPS
Unique as
provided
by MOL.
This field
will have
to be
padded
with
leading
zeros if
the length
is less
than 14.
Remarks
Valid amount
(eg: 2345.87
/ 23.00 / 22).
Shall be
equal to or
less than the
sum of fixed
& variable
income
A valid
refund
request
code as
provided by
CBUAE
(mentioned
below)
16
Emplo
yee
A/c
with
Agent
AN/(M
)
Employ
er must
provide
the a/c
no. of
the
employ
ee as
provide
d by
the
agent.
01
05
Future
Use
Future
Use
A/(M)
A/(M)
Leave
Blank. A
space
has to
be sent
in as the
data.
Must be
"EWPM
S"
Valid Refund Request codes
001 Errors in computation of fixed wages
002 Errors in computation of variable
003 Errors in computation of wages
004 Same data sent through multiple banks
005 Same data sent through another bank
FCR (reFund Control Record)
Size/length
03
13
35
Field
Labels
Record
Type
Employer
ID
Employer
Reference
Character
Type/Use
A/(M)
N/(M)
AN/(O)
Must
be
FCR
Unique
ID as
provided
by MOL.
This field
will have
to be
padded
with
leading
zeros if
the
length is
less than
the max
length of
13.
Remarks
Documentary
Field
09
Bank Code
of the
Employer
20
A/c of
employer
with Bank
15
Total
Refund
Claimed
N/(M)
AN/(M)
N/(M)
802420101
A/c no.
where the
monies
will need
to be
credited of
the refund
request is
accepted
by the
agent.
File Naming Convention
SIF File:
Prefix
EEEEEEEEEEEEEYYMMDDHHMMSS
Save as type
Extension
EEEEEEEEEEEEE : Employer unique ID
YYMMDD
: File Creation Date
HHMMSS
: File Creation Time
CSV (Comma delimited)
.SIF
RFR File:
Prefix
EEEEEEEEEEEEEYYMMDDHHMMSS
Save as type
Extension
EEEEEEEEEEEEE : Employer unique ID
YYMMDD
: File Creation Date
HHMMSS
: File Creation Time
CSV (Comma delimited)
.RFR
Valid
amount
(e.g.
2345.87
/ 23.00 /
22)
10
01
01
05
FDR
Count
Future
Use
Future
Use
Future
Use
N/(M)
A/(M)
A/(M)
A/(M)
Total
number
of FDR
in this
file
Leave
Blank.
A
space
has to
be
sent
in as
the
data.
Leave
Blank.
A
space
has to
be
sent
in as
the
data.
Must be
"EWPMS"
