MEMBER REGISTRATION BULK FILE FORMAT

(FOR EMPLOYERS)

The Member Registration Bulk file should be in txt format only.

File size should not be greater than 2 MB. If file size is greater than 2 MB, single text file in ZIP format will be accepted.
Each line in text file contains details of single member only.
The separator between fields should be #~# ( hash tilda hash).

Is
Sl.No. Column Name Colunm width Remarks
Mandatory

UAN to be provided only if available.

For fresh member registration no need of UAN.
Universal Account
1. Number(12) No Multiple lines with same UAN will not be
Number (UAN) accepted in a single text file .
Already active Member in establishment not
allowed to rejoin.

Previous Member Id will be provided only In

2. Previous Member Id Character (22) No case of Transfer of member.

3. Member Name Character (85) Yes No special characters allowed.

4. Date of Birth Character(10) Yes Valid date in dd/mm/yyyy format.

Valid date in dd/mm/yyyy format.

5. Date of Joining Character(10) Yes It should not be less than Date of Birth. It
should not be future date.

6. Gender Character(1) Yes 'M' (Male) , 'F' (Female) or 'T' (Transgender).

7. Father/Husband Name Character(85) Yes No special characters allowed.

Relationship of the member with column 7

above.
Relationship with the
8. Character(1) Yes Value should be 'F' (for father) or 'H' (for
Member Husband).

9. Mobile Number Number(10) No Valid mobile number.

10. EmailId Character (100) No Valid Email Id.

11. Nationality Number Yes As per Annexure I Nationality.

12. Wages as on Joining Number(10) No Wages as on Joining in .

13. Qualification Character(1) No Qualification as per Annexure I.

Marital Status as on date.

'M'- Married
'U' - Un-Married
14. Marital Status Character(1) Yes 'W' - Widow/Widower
'D' - Divorcee

'Y'- Yes
15. Is International Worker Character(1) No 'N'- No

If Is international worker is Y the country of

16. Country Of Origin Character(128) Yes origin is compulsory.
As per Annexure I.
 Is
Sl.No. Column Name Colunm width Remarks
Mandatory
If Is international worker is 'Y' the Passport
17. Passport Number Character(128) Yes Number is compulsory.

If Is international worker is 'Y' the Passport

Valid From Date is compulsory.
Passport Valid From Enter valid date format(dd/mm/yyyy)
18. Character(10) Yes
Date Date should not be greater than Passport Valid
Till & current date.

If Is international worker is 'Y' the Passport

Valid Till Date is compulsory.
Enter valid date format (dd/mm/yyyy)
19. Passport Valid Till Date Character (10) Yes Date should not be greater than Passport Valid
From Date.

'Y'- Yes
20. Is Physical Handicap Character(1) No 'N'- No

If Physically Handicap Type is ‘L’ it should be

21. Locomotive Character(1) No Locomotive.

If Physically Handicap Type is ‘H’ it should be

22. Hearing Character(1) No Hearing.
If Physically Handicap Type is ‘V’ it should be
23. Visual Character(1) No Visual.

24. Bank Account Number Character(20) No It should be a valid number.

25. Bank IFSC Character(11) No Valid IFSC

Name as per Bank

26. Character (85) No Special characters not allowed.
Details

Valid PAN e.g. ‘XXXPX0000X’.

27. PAN Character(10) No

28. Name as on PAN Character(85) No Special characters not allowed.

29. AADHAAR Number Number(12) No Valid AADHAAR

30. Name as on AADHAAR Character(85) No Special characters not allowed.

Sample text file is as follows for reference:

111111111111#~#ABABC98765430000000009#~#AshaDoshi#~#14/06/1982#~#22/06/2007#~#F#~#PritamDoshi#~#H#~#9
766347345#~#ashad@gmail.
com#~#INDIAN#~#12300#~#G#~#M#~#Y#~#AFGHANISTAN#~#ASDC112334#~#14/11/2004#~#29/11/2022#~#Y#~#L#~#
H#~#V#~#51110110111345#~#BKID0000516#~#AshaDoshi#~#DSTPS0455M#~#Asha
Doshi#~#123402571158#~#AshaDoshi
International Worker Code Information

Sl.No. Value Code

1. YES Y

2. NO N

Disability Code Information

Sl.No. Value Code

1. LOCOMOTIVE L

2. HEARING H

3. VISUAL V

Gender Code Information

Sl.No. Value Code

1. MALE M

2. FEMALE F

3. TRANSGENDER T

Marital Status Code Information

Sl.No. Value Code

1. MARRIED M

2. UN-MARRIED U

3. WIDOW/WIDOWER W

4. DIVORCEE D

KYC Code Information

Sl.No. Value Code

1. Bank B

2. PAN P

3. AADHAAR A

4. Passport T

5. Driving License D

6. Election Card E

7. Ration Card R

8. National Population Register N

Annexure I

Sl.No. Country Nationality

1. AFGHANISTAN Afghan

2. ALBANIA Albanian

3. ALGERIA Algerian

4. ANDORRA Andorran

5. ANGOLA Angolan

6. ANTIGUA AND BARBUDA of Antigua and Barbuda

7. ARGENTINA Argentinian

8. ARMENIA Armenian

9. AUSTRALIA Australian

10. AUSTRIA Austrian

11. AZERBAIJAN Azerbaijani

12. BAHAMAS Bahamian

13. BAHRAIN Bahraini

14. BANGLADESH Bangladeshi

15. BARBADOS Barbadian

16. BELARUS Belarusian¿¿or¿¿Belarusan

17. BELGIUM Belgian

18. BELIZE Belizean

19. BENIN Beninese

20. BHUTAN Bhutanese

21. BOLIVIA Bolivian

22. BOSNIA AND HERZEGOVINA Bosnian

23. BOTSWANA Botswanan

24. BRAZIL Brazilian

25. BRUNEI DARUSSALAM Bruneian

26. BULGARIA Bulgarian

27. BURKINA FASO Burkinese

28. BURUNDI Burundian

29. CAMBODIA Cambodian

30. CAMEROON Cameroonian

31. CANADA Canadian

32. CAPE VERDE Cape Verdean

33. CENTRAL AFRICAN REPUBLIC Central African

34. CHAD Chadian

35. CHILE Chilean

36. CHINA Chinese

37. COLOMBIA Colombian

Annexure I

Sl.No. Country Nationality

38. COMOROS Comorian

39. CONGO Congolese

40. COSTA RICA Costa Rican

41. COTE D'IVOIRE Ivoirian

42. CROATIA Croat¿¿or¿¿Croatian

43. CUBA Cuban

44. CYPRUS Cypriot

45. CZECH REPUBLIC Czech

46. DENMARK Danish

47. DJIBOUTI Djiboutian

48. DOMINICA Dominican

49. DOMINICAN REPUBLIC Dominican

50. ECUADOR Ecuadorean

51. EGYPT Egyptian

52. EL SALVADOR Salvadorean

53. EQUATORIAL GUINEA Equatorial Guinean

54. ERITREA Eritrean

55. ESTONIA Estonian

56. ETHIOPIA Ethiopian

57. FIJI Fijian

58. FINLAND Finnish

59. FRANCE French

60. GABON Gabonese

61. GAMBIA Gambian

62. GEORGIA Georgian

63. GERMANY German

64. GHANA Ghanaian

65. GREECE Greek

66. GRENADA Grenadian

67. GUATEMALA Guatemalan

68. GUINEA Guinean

69. GUINEA BISSAU Guinean

70. GUYANA Guyanese

71. HAITI Haitian

72. HONDURAS Honduran

73. HUNGARY Hungarian

74. ICELAND Icelandic

Annexure I

Sl.No. Country Nationality

75. INDIA Indian

76. INDONESIA Indonesian

77. IRAN (ISLAMIC REPUBLIC OF) Iranian

78. IRAQ Iraqi

79. IRELAND Irish

80. ISRAEL Israeli

81. ITALY Italian

82. JAMAICA Jamaican

83. JAPAN Japanese

84. JORDAN Jordanian

85. KAZAKHSTAN Kazakh

86. KENYA Kenyan

87. KIRIBATI Kiribati

88. KUWAIT Kuwaiti

89. KYRGYZSTAN Kyrgyzstani

90. LATVIA Latvian

91. LEBANON Lebanese

92. LESOTHO Mosotho

93. LIBERIA Liberian

94. LIBYAN ARAB JAMAHIRIYA Libyan

95. LIECHTENSTEIN Liechtensteiner

96. LITHUANIA Lithuanian

97. LUXEMBOURG Luxembourger

98. MADAGASCAR Malagasy¿¿or¿¿Madagascan

99. MALAWI Malawian

100. MALAYSIA Malaysian

101. MALDIVES Maldivian

102. MALI Malian

103. MALTA Maltese

104. MARSHALL ISLANDS Marshallese

105. MAURITANIA Mauritanian

106. MAURITIUS Mauritian

107. MEXICO Mexican

108. MONACO Mon¿¿gasque¿¿or¿¿Monacan

109. MONGOLIA Mongolian

110. MOROCCO Moroccan

111. MOZAMBIQUE Mozambican

Annexure I

Sl.No. Country Nationality

112. MYANMAR (BURMA) Burmese

113. NAMIBIA Namibian

114. NAURU Nauruan

115. NEPAL Nepalese

116. NETHERLANDS Dutch

117. NEW ZEALAND New Zealander

118. NICARAGUA Nicaraguan

119. NIGER Nigerien

120. NIGERIA Nigerian

121. NORWAY Norwegian

122. OMAN Omani

123. PAKISTAN Pakistani

124. PALAU Palauans

125. PANAMA Panamanian

126. PAPUA NEW GUINEA Papua New Guinean¿¿or¿¿Guinean

127. PARAGUAY Paraguayan

128. PERU Peruvian

129. PHILIPPINES Philippine

130. POLAND Polish

131. PORTUGAL Portuguese

132. QATAR Qatari

133. REPUBLIC OF KOREA Korean

134. REPUBLIC OF MOLDOVA Moldovan

135. ROMANIA Romanian

136. RUSSIAN FEDERATION Russian

137. RWANDA Rwandan

138. SAINT KITTS AND NEVIS Nevisian

139. SAINT LUCIA St. Lucian

140. SAMOA SAMOAN

141. SAN MARINO Sammarinese

142. SAO TOME AND PRINCIPE Sao Tomean

143. SAUDI ARABIA Saudi Arabian¿¿or¿¿Saudi

144. SENEGAL Senegalese

145. SERBIA AND MONTENEGRO Serb¿¿or¿¿Serbian

146. SEYCHELLES Seychellois

147. SIERRA LEONE Sierra Leonian

148. SINGAPORE Singaporean

Annexure I

Sl.No. Country Nationality

149. SLOVAKIA Slovak

150. SLOVENIA Slovene¿¿or¿¿Slovenian

151. SOLOMON ISLANDS Solomon Islander

152. SOMALIA Somali

153. SOUTH AFRICA South African

154. SPAIN Spanish

155. SRI LANKA Sri Lankan

156. SUDAN Sudanese

157. SURINAME Surinamese

158. SWAZILAND Swazi

159. SWEDEN Swedish

160. SWITZERLAND Swiss

161. SYRIAN ARAB REPUBLIC Syrian

162. TAJIKISTAN Tajik¿¿or¿¿Tadjik

163. THAILAND Thai

164. TIMOR LESTE Timorese

165. TOGO Togolese

166. TONGA Tongan

167. TRINIDAD AND TOBAGO Trinidadian

168. TUNISIA Tunisian

169. TURKEY Turkish

170. TURKMENISTAN Turkmen¿¿or¿¿Turkoman

171. TUVALU Tuvaluan

172. UGANDA Ugandan

173. UKRAINE Ukrainian

174. UNITED ARAB EMIRATES Emirian

175. UNITED KINGDOM Briton

176. UNITED REPUBLIC OF TANZANIA Tanzanian

177. UNITED STATES OF AMERICA American

178. URUGUAY Uruguayan

179. UZBEKISTAN Uzbek

180. VANUATU Vanuatuan

181. VATICAN Vanticanien.

182. VENEZUELA Venezuelan

183. VIET NAM Vietnamese

184. YEMEN Yemeni

185. ZAMBIA Zambian

Annexure I

Sl.No. Country Nationality

186. ZIMBABWE Zimbabwean

Annexure I

Sl.No. Value Code

1. ILLITERATE I

2. LITERATE L

3. NON-MATRIC N

4. MATRIC M

5. SENIOR-SECONDARY S

6. GRADUATE G

7. POST-GRADUATE P

8. DOCTORATE D

9. TECHNICAL (PROFESSIONAL) T