As we have informed you that EPF department has started the process of Implementation of UAN(universal account number ) for epf members. F...
As we have informed you that EPF department has started the process of Implementation of UAN(universal account number ) for epf members. Further issued a letter to all employer regarding their responsibility in implementation of UAN.Main responsibility of employer is KYC of Employer.
As per new process ,UAN will be allotted /Has been allotted to person who are contributing to EPF in last one year.Employer has to upload KYC of existing as well as new employees through Bulk Upload file.
In first process employer has to upload only information of KYC through text file and required to upload proofs later on.
This UAN/KYC Text file is required to be uploaded OTCP (Online Transfer Claim Portal).ID & Password at OTCP is same as of ECR portal.
Download Link for Excel based Software is given below
S.
No. |
Field Name
|
Type
|
Size
|
Validation
|
Remark
|
1
|
UAN
|
Number
|
12
|
i. Mandatory
ii. Number should be as per verhoeff algorithm iii. UAN should present in database iv. Atleast one member id linked with UAN should be of the same establishment who is uploading the file |
|
2
|
Document Type
|
Character
|
1
|
i. Mandatory
ii. Valid Values in {‘N’, ‘A’, ‘P’, ‘B’, ‘T’, ‘D’, ‘E’,’R’} |
N- National Population
Register A- AADHAR P- Permanent Account Number B- Bank Account Number T- Passport D- Driving License E- Election Card R- Ration Card |
3
|
Document
Number |
Character
|
30
|
i. Mandatory
ii. Other Validations should according to document type |
|
4
|
IFSC Code
|
Character
|
11
|
If value at serial number 2 is ‘B’ then
not null otherwise blank |
|
5
|
Name
|
Character
|
85
|
i. Mandatory
ii. Special Characters are not allowed |
Name should be
as, as
appear in KYC document |
6
|
Expiry Date
|
Date
|
i. If at serial number
2 value is ‘D’
or ‘T’ then not null otherwise blank ii. If not null should be greater than system date |
Date format should
be
dd/mm/YYYY |
|
7
|
Educational
Qualifications |
Character
|
1
|
i. Optional
ii. Valid Values in {‘I’, ‘N’, ‘M’, ‘S’, ‘G’, ‘P’, ‘D’} or blank |
I - Illiterate
N – Non Matric M - Matric S - Senior Secondary G - Graduate P - Post Graduate D - Doctorate |
8
|
Physically
Handicap |
Character
|
1
|
i. Optional
ii. Valid Values in {‘Y’,’N’} or blank |
Y - Yes
N – No |
9
|
Physically
Handicap Category |
Character
|
1
|
i. If value at Serial
No.8 is Y than
mandatory ii. Valid Values in {‘L’, ‘V’, ‘H’} or blank |
L - Locomotive disability
V - Visual H - Hearing |
10
|
Gender
|
Character
|
1
|
i. Optional
ii. Valid Values {‘M’,‘F’,‘T’} or blank |
M - Male
F - Female T - Trans Gender |
11
|
International
Worker |
Character
|
1
|
i. Optional
ii. Valid Values {‘Y’,‘N’} or blank |
Y - Yes
N - No |
12
|
Marital Status
|
Character
|
1
|
i. Optional
ii. Valid Values {‘M’,‘U’,‘W’,’D’} or blank |
M - Married
U - Un-Married W - Widow/Widower D - Divorcee |
13
|
Est ID
|
Character
|
15
|
i. Mandatory
ii. This establishment should match with establishment login. |
This establishment code should match with establishment login.
Steps to create Bulk KYC Text File :
1) Create Excel File with 13 columns as described in above table.
2) Save excel file as CSV (Comma Separated Value MS-DOS)
3) Open CSV in text editor like Notepad / Wordpad etc
4) Replace comma(,) with ‘#~#’
5) Save as <filename>.txt
6) This txt file has to be uploaded under KYC – Upload Bulk KYC Text File
Screenshots for creating bulk KYC text file are shown hereunder :
Sample Excel File
Now Save As: CSV(MS-DOS) as shown below:
Open this CSV File with Notepad/WordPad:
IMP: Remove the very first line containing headers. Then Go To Edit Option and select Replace. Now replace comma (,) with #~#.
Place your cursor at the end of the row and press delete to remove the blank lines. Then save this file as filename.txt. Your bulk KYC text file is ready to be uploaded.
KYC Error codes and their Description
S.No.
|
Error Code
|
Description
|
1
|
Error Code 001
|
Data is not as per KYC
format. (Has control characters)
|
2
|
Error Code 002
|
Data is not as per KYC
format. (Has non-print characters)
|
3
|
Error Code 003
|
The file encoding
should be ANSI.
|
4
|
Error Code 004
|
UAN 100015374649
(Field-1) is blank or length is less than 12 or alpha-numeric on line number
1.
|
5
|
Error Code 005
|
UAN 100015374649
(Field-1) does not follow the defined algorithm,
hence invalid, on line number 1. |
6
|
Error Code 006
|
UAN 100015374649
(Field-1) is not found in UAN master table or
not associated with your establishment on line number 1. |
7
|
Error Code 007
|
UAN 100015374649
(Field-1) is not found in member master
database on line number 1. |
8
|
Error Code 008
|
Document Type E
(Field-2) is incorrect on line number 1. It should
be one of N, A, P, B, T, D or E. |
9
|
Error Code 009
|
Document Number
ALJPS3474B (Field-3) value is blank or length
is greater than 30 on line number 1. |
10
|
Error Code 010
|
Document Number
ALJPS3474B (Field-3) is invalid on line number
2. |
11
|
Error Code 011
|
IFSC Code
IOBN0111111111 (Field-4) is blank or length is less than 11 or not alpha
numeric on line number 1.
|
12
|
Error Code 012
|
Employee Name Devendra
(Field-5) is incorrect on line number 3.
(either length more than 85 character or has special characters.) |
13
|
Error Code 013
|
Expiry Date 10-11-2014
(Field-6) of document type is invalid on line
number 4. (dd/mm/yyyy format, mandatory for passport and driving license) |
14
|
Error Code 014
|
Expiry Date 10-11-2014
(Field-6) of document type is greater than
system date on line number 4. |
15
|
Error Code 015
|
Education
Qualification Flag T (Field-7) is invalid on line number 4.
|
16
|
Error Code 016
|
Physically Handicap
Flag H (Field-8) is invalid on line
number 4
|
17
|
Error Code 017
|
Physically Handicap
Category Flag B (Field-9) is invalid
on line number 4
|
18
|
Error Code 018
|
Gender Flag L
(Field-10) is invalid on line number 4
|
19
|
Error Code 019
|
International Worker
Flag D (Field-11) is invalid on line
number 4
|
20
|
Error Code 020
|
Marital Status Flag J
(Field-12) is invalid on line number 4
|
21
|
Error Code 021
|
Establishment ID
DSSHD0015477000 (Field-13) is invalid on line
number 4. (Blank or not 15 character or defined format.) |
22
|
Error Code 022
|
Establishment ID
DSSHD0015477000 (Field-13) and login establishment id is not same on line
number 4.
|
23
|
Error Code 023
|
Line is not as per UAN
KYC format (13 Fields separated by #~# not
found) on line number 1. |
Common errors observed while uploading Bulk KYC Text file
1. Error due to Uploading of UAN Text file instead of Bulk KYC Text file:
There is a link given to Download PDF/Text File of UAN List in the Sub Menu ‘Download UAN List’ of ‘UAN’ Menu. The file being downloaded from this link is not the text file required for uploading Bulk KYC Text File by the employer. Bulk KYC Text File is to be made separately as per the revised format given in User Manual for Employers Version 1.2.
The text file being made available as part of UAN downloads is only for use internally by the employer and should not be uploaded as KYC text file.
2. Blank rows at the end of text file:
Your text file must not have any blank row. The most recurring error is to leave blank row in your text file. User must place the cursor at the end of the last row and press ‘delete’ button to remove the blank rows and save it for uploading the same.
If on uploading a text file, we are getting a message which says that error on line number X which is one more than no of records in KYC text file, it implies that we have left a blank row at the end of the text file. Placing the cursor at the end of the penultimate row and pressing delete button to remove any blank row and saving the text file will solve this error.
3. Header row uploaded at start of the text file:
Header row has to be deleted before saving csv file as text file. Uploading txt file with header row gives error of various types.
Hope You have gone through the Process. Very Lengthy .We have made it simple .Dathathri M has prepared a file to create UAN Text file at OTCP.Dathathri M has also created a ECR (Epf Challan Cum return software) which can be downloaded from Link.
Software Created By
Dathathri M
+919480797570
Thank you sir, Suresh kumar, Coimbatore R.O EPFO
ReplyDeleteThank you very much Sir
ReplyDelete