| |
Download
PR-02A Soft Data Format (Spread Sheet)
PR-02A is annual return submitted by an
employer by 30th Sep each year giving details of employees who have worked
during the preceding financial year i.e. (July 01- June 30)
INSTRUCTIONS:
PR-02A Data be in
Tab delimited FORMAT
-
Date should be in BRITISH FORMAT
(DD/MM/YYYY)
-
The PR-02A Data file name should be
(registration-NO-MMYY.txt) e.g. ABC-12345-0708.txt
-
Generate MD5 hash and send along with
data file
-
While sending the file the covering
letter must be accompanied stating total number of records being
sent.
|
PR-02A SOFT DATA FORMAT |
|
IMPORTANT NOTES |
|
FIELD NAME |
FIELD DESCRIPTION |
|
FORMAT |
YEAR |
Enter ending year of the
Financial year for which information is being provided.
e.g. 2010 for 2009-2010 |
MANDATORY |
MMMYYYY |
MAIN_CODE |
Employer registration code
allotted by EOBI for Head Office. Use leading zeros if
numeric part is less than five digits |
MANDATORY |
XXX99999 |
SUB_CODE |
Employer registration code
allotted by EOBI for Sub Office. Use leading zeros if
numeric part is less than three digits |
Where applicable |
XX999 |
EOBI_NO |
Registration number allotted
to insured person by EOBI. Fourth character in EOBI number
is always alpha. |
MANDATORY |
9999X999999 |
NIC |
Old NIC number. Use hyphens
as given in the format. Recommended as it would prevent
issuance of duplicate EOBI nos |
Highly Recommended |
999-99-999999 |
CNIC |
New NIC number. Use hyphens
as given in the format. Mandatory |
MANDATORY |
99999-9999999-9 |
NAME |
Name of the insured person
for whom contribution is paid |
MANDATORY |
Alphabets and spaces only |
DOB |
Date of birth of insured
person. e.g. 21/07/1989 |
MANDATORY |
DD/MM/YYYY |
DOJ |
Date of insured person
joining employer. e.g. 21/07/2002 |
MANDATORY |
DD/MM/YYYY |
DOE |
Date of exit (in case
employee has left). e.g. 30/06/2008 |
MANDATORY |
DD/MM/YYYY |
EMP SHARE |
Employer share of
contribution (Rate is 5% of minimum wages for the year) |
MANDATORY |
999 |
IP SHARE |
Employee share of
contribution (Rate is 1% of minimum wages for the year) |
MANDATORY |
99 |
TOKEN NUMBER |
Employee ID, as given by the
employer |
Optional |
Text |
Please note:
-
Cells are
pre-formatted to accept required values
-
Minimum wages are
prescribed by the Government for each year
-
CNIC is mandatory
-
All other fields
are also mandatory, except sub_code and Token_No. Sub code where
applicable should and must be provided.
-
Soft data may be
returned to the employer if found incompatible with the
prescribed format or is incomplete
-
In case soft data
is required to be sent for different years, using separate
spreadsheets for each financial year
-
Date columns are
to be “entered” as MM/DD/YYYY. They would automatically be
converted as “DD/MM/YYYY”
In case of
PR-02A data file
format differ from above mentioned format, the data will be rejected
Upon receiving the file and MD5 hash we
would:
-
Verify the hash for authenticity of
data
-
Verify the file name
-
Verify the total number of records
-
Verify the total number of valid
records
-
Verify the record based on above
criteria and duplication based on NIC & CNIC
For Further
Details Contact:
EOBI IT Department, Head Office,
Karachi
021-9217933, 021-9217934, 021-9217941-43, ext 2030
Last updated as on 28.09.2010 |
|
