Basic Details

Type PERSON
Client number
Client Guid
External Client Number

Personal Details
Title Mr.
First name Nguyen Van
Last name An
Gender MALE
Date of birth 01/01/1985
Marital Status Married
Country of Birth VIETNAM
Citizenship

Identity
Identity type Identity number
VSS Y141234

Education
Course code
Post Graduate

Address
Type Address Line 1
HOME 123 Le Loi Street

Phone
Type Code ISD
BUSINESS +84

Email
Type Code Email ID
BUSINESS [email protected]
Employment
Employement Type Income
COOK 1000000.00
Address Line 2 Address Line 3 Address Line 4Address Line 5
District 1, Ho Chi Mi Vietnam

STD Contact Num Preferred Flag

912345678 TRUE

Preferred Flag
TRUE
Address Line 6Country co State code
VIETNAM
City code Post code Preferred Flag
1576 TRUE
Personal Details
Title
First name
Last name
Gender
Date of birth

Identity
Identity type Identity number
identityTypeCd identityNum

Education
Course code Education type Status
courseCd educationTypeCd statusCd

Address
Type Address Line 1 Address Line 2Address Line 3
typeCd addressLine1 addressLine2 addressLine3

Phone
Type Code ISD STD Contact Num
typeCd ISD STD contactNum

Email
Type Code Email ID Preferred Flag
typeCd emailId prefferedFl

Identity
Identity type Identity number
identityTypeCd identityNum

Education
Course code
courseCd

Employment
Employement Type Income
occupationCd montlyIncomeAmt
Address Line 4Address Line 5Address Line 6Country codeState code City code
addressLine4 addressLine5 addressLine6 countryCd stateCd cityCd

Preferred Flag
prefferedFl
 Country cState codCity code
countryCd stateCd cityCd

Post code Preferred Flag

postCode prefferedFl
DataSourceTable
DataCondition
FieldName genderCd value
FEMALE Female
MALE Male
OTHERS Others
identityTypeCd value courseCd value addressTypeCd
ARMEDFORCESID Armed Forces ID G Graduate BUSINESS
BIRTHCERTIFICATE Birth Certificate H HSC MAILING
KTP KTP O Post Graduate OTHER
NRIC NRIC Number P Professional HOME
PASSPORT Passport Number S SSC TEMPORARY
VSS VSS T Others
ssTypeCd phoneTypeCd emailTypeCd relatedToInsuredCd
Business BUSINESS Business BUSINESS Business BRTHR
Mailing EMERGENCY Emergency OTHER Other BUSIN
Other HOME Home PERSONAL Personal CHILD
Home MOBILE Mobile DAUGH
Temporary TEMPORARY Temporary ESTA
OTHER FATHR
FRIEN
GFTHR
HUSBD
INSCO
LGRD
MOTHR
OTHER
PAREN
RLAT
SELF
SISTR
SON
SPOUS
TRSTI
TRSTL
TRSTT
nsuredCd maritalStatus values
Brother CIVILUNION Civil Union
Business COMMONLAW Common Law (De facto)
Child DIVORCED Divorced
Daughter DOMESTICPARTNER Domestic Partner
Estate ESTRANGED Estranged
Father HEADOFHOUSEHOLD Head of Household
Friend LEGALLYSEPARATED Legally Separated
Grandfather MARRIED Married
Husband MARRIEDSINGLE Married, withholding single.
Insured's Company OTHER Other
Legal Guardian SINGLE Single
Mother UNKNOWN Unknown
Other WIDOWED Widowed
Parent
Relative
Self
Sister
Son
Spouse
Institutional Trust
Living Trust
Testamentary Trust
CountryCd values
RUSSIA Russia
ISRAEL Israel
IRAN Iran, Islamic Republic Of
KOREA Democratic People's Republic of Korea
SYRIAN_ARAB_REPUBLIC Syrian Arab Republic
ANGOLA Angola
GABON Gabon
EQUATORIAL_GUINEA Equatorial Guinea
COMOROS Comoros
LAOS Lao People's Democratic Republic
LIBERIA Liberia
MADAGASCAR Madagascar
SIERRA_LEONE Sierra Leone
CHAD Chad
TAJIKISTAN Tajikistan
TURKMENISTAN Turkmenistan
AFGHANISTAN Afghanistan
BURUNDI Burundi
BELARUS Belarus
CONGO The Democratic Republic of the Congo
CENTRAL_AFRICAN_REPUBLIC Central African Republic
GUINEA-BISSAU Guinea-Bissau
HAITI Haiti
IRAQ Iraq
LEBANON Lebanon
LIBYA Libya
MALI Mali
MYANMAR Myanmar (Burma)
MOZAMBIQUE Mozambique
NICARAGUA Nicaragua
SUDAN Sudan
SOMALIA Somalia
SOUTH_SUDAN South Sudan
UKRAINE Ukraine
VENEZUELA Bolivarian Republic of Venezuela
YEMEN Yemen
ZIMBABWE Zimbabwe
ALGERIA Algeria
SURINAME Suriname
AZERBAIJAN Azerbaijan
BANGLADESH Bangladesh
BENIN Benin
BOLIVIA Bolivia
CAMEROON Cameroon
DJIBOUTI Djibouti
EGYPT Egypt
ERITREA Eritrea
GUATEMALA Guatemala
HONDURAS Honduras
KENYA Kenya
KYRGYZSTAN Kyrgyzstan
CAMBODIA Cambodia
MAURITANIA Mauritania
NIGER Niger
PAPUA_NEW_GUINEA Papua New Guinea
PAKISTAN Pakistan
PARAGUAY Paraguay
SOLOMON_ISLANDS Solomon Islands
ESWATINI Eswatini
TOGO Togo
TONGA Tonga
UZBEKISTAN Uzbekistan
VIETNAM Vietnam
UNITED_ARAB_EMIRATES United Arab Emirates
ALBANIA Albania
BOSNIA_AND_HERZEGOVINA Bosnia And Herzegovina
BARBADOS Barbados
BURKINA_FASO Burkina Faso
CHINA China
ETHIOPIA Ethiopia
GIBRALTAR Gibraltar
GUINEA Guinea
JAMAICA Jamaica
JORDAN Jordan
CAYMAN_ISLANDS Cayman Islands (The)
SRI_LANKA Sri Lanka
NIGERIA Nigeria
PANAMA Panama
PHILIPPINES Philippines
SENEGAL Senegal
TUNISIA Tunisia
TURKEY Turkey
TANZANIA Tanzania
UGANDA Uganda
SOUTH_AFRICA South Africa
MOROCCO Morocco
BULGARIA Bulgaria
MALTA Malta
CROATIA Croatia
AMERICAN_SAMOA American Samoa
ANGUILLA Anguilla
ANTIGUA_AND_BARBUDA Antigua And Barbuda
ARGENTIINA Argentiina
ARMENIA Armenia
ARUBA Aruba
BAHAMAS Bahamas, The
BAHRAIN Bahrain
BELIZE Belize
BERMUDA Bermuda
BHUTAN Bhutan
BONAIRE Bonaire, Sint Eustatius And Saba
BRAZIL Brazil
BRITISH_VIRGIN_ISLANDS British Virgin Islands
CABO_VERDE Cabo Verde
CHILE Chile
CHRISTMAS_ISLAND Christmas Island (Austrailian Territory)
COCOS__ISLANDS Territory of Cocos (Keeling) Islands
COLOMBIA Colombia
COTE_D'IVOIRE Cote D'Ivoire
CUBA Cuba
CURACAO Curacao
CYPRUS Cyprus
DOMINICAN_REPUBLIC Dominican Republic
ECUADOR Ecuador
EL_SAVADOR El Savador
FALKLAND_ISLANDS Falkland Islands (Malvinas)
FAROE_ISLANDS Faroe Islands
FIJI Fiji
FRENCH_GUIANA French Guiana (France)
FRENCH_POLYNESIA French Polynesia
GAMBIA The Gambia
GEORGIA Georgia
GHANA Ghana
GREENLAND Greenland (Denmark)
GRENADA Grenada
GUADELOPE Guadelope
GUAM Guam
GUERNSEY Guernsey (Channel Island)
GUYANA Guyana
HOLY_SEE Holy See
HONG_KONG Hong Kong
HUNGARY Hungary
INDIA India
INDONESIA Indonesia
ISLE_OF_MAN Isle Of Man
JAPAN Japan
JERSEY Jersey
KAZAKHSTAN Kazakhstan
KIRIBATI Kiribati
KOSOVO Kosovo
KUWAIT Kuwait
LESOTHO Lesotho
LUXEMBOURG Luxembourg
MACAU_SAR_CHINA Macau Sar, China
MACEDONIA The Republic of North Macedonia
MALAWI Malawi
MALDIVES Maldives
MARSHALL_ISLANDS Marshall Islands
MARTINIQUE Martinique
MAURITIUS Mauritius
MEXICO Mexico
MICRONESIA The Federated States of Micronesia
MOLDOVA Moldova
MONACO Monaco
MONGOLIA Mongolia
MONTENEGRO Montenegro
MONTSERRAT Montserrat
NAMIBIA Namibia
NAURU Nauru
NEPAL Nepal
NEW_CALEDONIA New Caledonia
NORFOLK_ISLAND Norfolk Island (Austrailian Territory)
NORTHERN_MARIANA_ISLANDS Northern Mariana Islands
OMAN Oman
PALAU Palau
PERU Peru
RÉUNION Réunion (France)
ROMANIA Romania
SAINT_BARTHELEMY Saint Barthelemy
SAINT_HELENA Saint Helena
SAINT_KITTS_AND_NEVIS Saint Kitts And Nevis
SAINT_LUCIA Saint Lucia
SAINT_PIERRE_AND_MIQUELON Saint Pierre And Miquelon (France)
SAINT_VINCENT_AND_THE_GRENADINESSaint Vincent And The Grenadines
SAMOA Samoa
SAO_TOME_AND_PRINCIPE Sao Tome And Principe
SERBIA Serbia
SEYCHELLES Seychelles
SINT_MAARTEN Sint Maarten (Dutch Part)
THAILAND Thailand
TIMOR-LESTE Timor-Leste
TRINIDAD_AND_TOBAGO Trinidad And Tobago
TURKS_AND_CAICOS_ISLANDS Turks And Caicos Islands
TUVALU Tuvalu
VANUATU Vanuatu
VIRGIN_ISLANDS Virgin Islands (U.S.)
WALLIS_AND_FUTUNA Wallis And Futuna (France)
ZAMBIA Zambia
COSTA_RICA Costa Rica
QATAR Qatar
SAUDI_ARABIA Saudi Arabia
MALAYSIA Malaysia
USA USA
 PROVINCE
countryCd = 'MALAYSIA'
stateCountryCd StateCd values
VIETNAM AN_GIANG An Giang
VIETNAM BA_RIA-VUNG-TAU Bà Ria–Vung Tàu
VIETNAM BAC_GIANG Bac Giang
VIETNAM BAC_KAN Bac Kan
VIETNAM BAC_LIEU Bac Liêu
VIETNAM BAC_NINH Bac Ninh
VIETNAM BEN_TRE Ben Tre
VIETNAM BINH_DINH Bình Ðinh
VIETNAM BINH_DUONG Bình Duong
VIETNAM BINH_PHUOC Bình Phuoc
VIETNAM BINH_THUAN Bình Thuan
VIETNAM CA_MAU Cà Mau
VIETNAM CAO_BANG Cao Bang
VIETNAM DAK_LAK Ðak Lak
VIETNAM DAK_NONG Ðak Nông
VIETNAM DIEN_BIEN Ðien Biên
VIETNAM DONG_NAI Ðong Nai
VIETNAM DONG_THAP Ðong Tháp
VIETNAM GIA_LAI Gia Lai
VIETNAM HA_GIANG Hà Giang
VIETNAM HA_NAM Hà Nam
VIETNAM HA_TINH Hà Tinh
VIETNAM HAI_DUONG Hai Duong
VIETNAM HAU_GIANG Hau Giang
VIETNAM HOA_BINH Hòa Bình
VIETNAM HUNG_YEN Hung Yên
VIETNAM KHANH_HOA Khánh Hòa
VIETNAM KIEN_GIANG Kiên Giang
VIETNAM KON_TUM Kon Tum
VIETNAM LAI_CHAU Lai Châu
VIETNAM LAM_DONG Lâm Ðong
VIETNAM LANG_SON Lang Son
VIETNAM LAO_CAI Lào Cai
VIETNAM LONG_AN Long An
VIETNAM MEKONG_DELTA Mekong Delta
VIETNAM NAM_DINH Nam Ðinh
VIETNAM NGHE_AN Nghe An
VIETNAM NINH_BINH Ninh Bình
VIETNAM NINH_THUAN Ninh Thuan
VIETNAM PHU_THO Phú Tho
VIETNAM PHU_YEN Phú Yên
VIETNAM QUANG_BINH Quang Bình
VIETNAM QUANG_NAM Quang Nam
VIETNAM QUANG_NGAI Quang Ngãi
VIETNAM QUANG_NINH Quang Ninh
VIETNAM QUANG_TRI Quang Tri
VIETNAM RED_RIVER_DELTA Red River Delta
VIETNAM SOC_TRANG Sóc Trang
VIETNAM SON_LA Son La
VIETNAM SOUTH_CENTRAL_COAST South Central Coa
VIETNAM SOUTH_EAST Southeast
VIETNAM TAY_NINH Tây Ninh
VIETNAM THAI_BINH Thái Bình
VIETNAM THAI_NGUYEN Thái Nguyên
VIETNAM THANH_HOA Thanh Hóa
VIETNAM THUA_THIEN_HEU Thua Thiên Hue
VIETNAM TIEN_GIANG Tien Giang
VIETNAM TRA_VINH Trà Vinh
VIETNAM TUYEN_QUANG Tuyên Quang
VIETNAM VINH_LONG Vinh Long
VIETNAM VINH_PHUC Vinh Phúc
VIETNAM YEN_BAI Yên Bái
VIETNAM THANH_PHO_HO_CHI_MINH Thành phố Hồ Chí
VIETNAM TINH_VINH_PHUC Tỉnh Vĩnh Phúc
VIETNAM THANH_PHO_HA_NOI Thành phố Hà Nội
VIETNAM THANH_PHO_HAI_PHONG Thành phố Hải Ph
VIETNAM TINH_DAK_LAK Tỉnh Đắk Lắk
VIETNAM TINH_BINH_DINH Tỉnh Bình Định
VIETNAM TINH_DONG_NAI Tỉnh Đồng Nai
VIETNAM TINH_SON_LA Tỉnh Sơn La
VIETNAM TINH_THUA_THIEN_HUE Tỉnh Thừa Thiên H
VIETNAM TINH_GIA_LAI Tỉnh Gia Lai
VIETNAM TINH_NINH_BINH Tỉnh Ninh Bình
VIETNAM TINH_BIC_NINH T?nh B?c Ninh
VIETNAM TINH_KHANH_HOA Tỉnh Khánh Hòa
VIETNAM TINH_YEN_BAI Tỉnh Yên Bái
VIETNAM TINH_HAI_DUONG Tỉnh Hải Dương
VIETNAM TINH_LAO_CAI Tỉnh Lào Cai
VIETNAM TINH_BAC_GIANG Tỉnh Bắc Giang
VIETNAM TINH_THAI_BINH Tỉnh Thái Bình
VIETNAM TINH_NGHE_AN Tỉnh Nghệ An
VIETNAM THANH_PHO_DA_NANG Thành phố Đà Nẵn
VIETNAM TINH_PHU_YEN Tỉnh Phú Yên
VIETNAM TINH_TIEN_GIANG Tỉnh Tiền Giang
VIETNAM TINH_BINH_DOUNG Tỉnh Bình Dương
VIETNAM TINH_HA_NAM Tỉnh Hà Nam
VIETNAM TINH_BEN_TRE Tỉnh Bến Tre
VIETNAM TINH_CAO_BANG Tỉnh Cao Bằng
VIETNAM TINH_DONG_THAP Tỉnh Đồng Tháp
VIETNAM THANH_PHO_CAN_THO Thành phố Cần Thơ
VIETNAM TINH_QUANG_NGAI Tỉnh Quảng Ngãi
VIETNAM TINH_QUANG_TRI Tỉnh Quảng Trị
VIETNAM TINH_BINH_PHUOC Tỉnh Bình Phước
VIETNAM TINH_TAY_NINH Tỉnh Tây Ninh
VIETNAM TINH_TRA_VINH Tỉnh Trà Vinh
VIETNAM TINH_AN_GIANG Tỉnh An Giang
VIETNAM TINH_NAM_DINH Tỉnh Nam Định
VIETNAM TINH_THAI_NGUYEN Tỉnh Thái Nguyên
VIETNAM TINH_BA_RIA_VUNG_TAU Tỉnh Bà Rịa-Vũng Tàu
VIETNAM TINH_LANG_SON Tỉnh Lạng Sơn
VIETNAM TINH_HUNG_YEN Tỉnh Hưng Yên
VIETNAM TINH_HA_TINH Tỉnh Hà Tĩnh
VIETNAM TINH_HAU_GIANG Tỉnh Hậu Giang
VIETNAM TINH_QUANG_NINH Tỉnh Quảng Ninh
VIETNAM TINH_DIEN_BIEN Tỉnh Điện Biên
VIETNAM TINH_NINH_THUAN Tỉnh Ninh Thuận
VIETNAM TINH_SOC_TRANG Tỉnh Sóc Trăng
VIETNAM TINH_BAC_LIEU Tỉnh Bạc Liêu
VIETNAM TINH_VINH_LONG Tỉnh Vĩnh Long
VIETNAM TINH_QUANG_NAM Tỉnh Quảng Nam
VIETNAM TINH_KIEN_GIANG Tỉnh Kiên Giang
VIETNAM TINH_BINH_THUAN Tỉnh Bình Thuận
VIETNAM TINH_LAI_CHAU Tỉnh Lai Châu
VIETNAM TINH_HOA_BINH Tỉnh Hòa Bình
VIETNAM TINH_BAC_KAN Tỉnh Bắc Kạn
VIETNAM TINH_LONG_AN Tỉnh Long An
VIETNAM TINH_TUYEN_QUANG Tỉnh Tuyên Quang
VIETNAM TINH_HA_GIANG Tỉnh Hà Giang
VIETNAM TINH_PHU_THO Tỉnh Phú Thọ
VIETNAM TINH_CA_MAU Tỉnh Cà Mau
VIETNAM TINH_DAK_NONG Tỉnh Đắk Nông
VIETNAM TINH_KON_TUM Tỉnh Kon Tum
VIETNAM TINH_THANH_HOA Tỉnh Thanh Hóa
VIETNAM TINH_QUANG_BINH Tỉnh Quảng Bình
VIETNAM TINH_LAM_DONG Tỉnh Lâm Đồng
VIETNAM OTHERS Others
VIETNAM AG An Giang
VIETNAM BV Bà Ria–Vung Tàu
VIETNAM BG Bac Giang
VIETNAM BK Bac Kan
VIETNAM BL Bac Liêu
VIETNAM BN Bac Ninh
VIETNAM BTR Ben Tre
VIETNAM BDI Bình Ðinh
VIETNAM BDU Bình Duong
VIETNAM BP Bình Phuoc
VIETNAM BTH Bình Thuan
VIETNAM CM Cà Mau
VIETNAM CB Cao Bang
VIETNAM DAL Ðak Lak
VIETNAM DNO Ðak Nông
VIETNAM DB Ðien Biên
VIETNAM DNA Ðong Nai
VIETNAM DT Ðong Tháp
VIETNAM GL Gia Lai
VIETNAM HG Hà Giang
VIETNAM HN Hà Nam
VIETNAM HT Hà Tinh
VIETNAM HD Hai Duong
VIETNAM HUG Hau Giang
VIETNAM HB Hòa Bình
VIETNAM HY Hung Yên
VIETNAM KH Khánh Hòa
VIETNAM KG Kiên Giang
VIETNAM KT Kon Tum
VIETNAM LCH Lai Châu
VIETNAM LAD Lâm Ðong
VIETNAM LS Lang Son
VIETNAM LCA Lào Cai
VIETNAM LA Long An
VIETNAM MD Mekong Delta
VIETNAM ND Nam Ðinh
VIETNAM NA Nghe An
VIETNAM NB Ninh Bình
VIETNAM NT Ninh Thuan
VIETNAM PT Phú Tho
VIETNAM PYen Phú Yên
VIETNAM QB Quang Bình
VIETNAM QNA Quang Nam
VIETNAM QNG Quang Ngãi
VIETNAM QNI Quang Ninh
VIETNAM QT Quang Tri
VIETNAM RR Red River Delta
VIETNAM ST Sóc Trang
VIETNAM SL Son La
VIETNAM SC South Central Coast
VIETNAM SE Southeast
VIETNAM TNinh Tây Ninh
VIETNAM TB Thái Bình
VIETNAM TNG Thái Nguyên
VIETNAM TH Thanh Hóa
VIETNAM TT Thua Thiên Hue
VIETNAM TG Tien Giang
VIETNAM TV Trà Vinh
VIETNAM TQ Tuyên Quang
VIETNAM VL Vinh Long
VIETNAM VP Vinh Phúc
VIETNAM YB Yên Bái
cityProvince CityCd value CitizenShipCd
AN_GIANG CHAU_DOC Chau Doc INDONESIAN
AN_GIANG LONG_XUYEN Long Xuyên AFGHAN
BA_RIA-VUNG-TAU BA_RIA Ba Ria ALBANIAN
BA_RIA-VUNG-TAU VUNG_TAU Vung Tàu ALGERIAN
BAC_GIANG BAC_GIANG Bac Giang ANDORRAN
BAC_KAN BAC_KAN Bac Kan ANGOLAN
BAC_LIEU BAC_LIEU Bac Lieu ANTIGUANS
BAC_NINH BAC_NINH Bac Ninh ARGENTINEAN
BEN_TRE BEN_TRE Ben Tre ARMENIAN
BINH_DINH QUY_NHAN Quy Nhan AUSTRALIAN
BINH_DUONG TAN_UYEN Tân Uyên AUSTRIAN
BINH_DUONG THU_DAU_MOT Thu Dau Mot AZERBAIJANI
BINH_DUONG THUAN_AN Thuan An BAHAMIAN
BINH_DUONG DI_AN Di An BAHRAINI
BINH_PHUOC DONG_XOAI Dong Xoài BANGLADESHI
BINH_THUAN PHAN_THIET Phan Thiet BARBADIAN
CA_MAU CA_MAU Ca Mau BELARUSIAN
CAO_BANG CAO_BANG Cao Bang BELGIAN
DAK_LAK BUON_MA_THUOT Buon Ma Thuot BELIZEAN
DAK_NONG GIA_NGHIA Gia Nghia BENINESE
DIEN_BIEN DIEN_BIEN_PHU Dien Bien Phu BHUTANESE
DONG_NAI LONG_KHANH Long Khánh BOLIVIAN
DONG_NAI BIEN_HOA Bien Hoa BOSNIAN
DONG_THAP CAO_LANH Cao Lanh BOTSWANA
DONG_THAP SA_DEC Sa Déc BRAZILIAN
GIA_LAI PLEIKU Pleiku BRUNEIAN
HA_GIANG HA_GIANG Hà Giang BULGARIAN
HA_NAM PHU_LY Phu Lý BURKINABE
HA_TINH HA_TINH Hà Tinh BURUNDIAN
HAI_DUONG HAI_DUONG Hai Duong CAMBODIAN
HAI_DUONG CHI_LINH Chi Linh CAMEROONIAN
HAU_GIANG NGA_BAY Ngã Bay CANADIAN
HAU_GIANG VI_THANH Vi Thanh CAPEVERDEAN
HOA_BINH HOA_BINH Hòa Bình CENTRALAFRICAN
HUNG_YEN HUNG_YEN Hung Yên CHADIAN
KHANH_HOA NHA_TRANG Nha Trang CHILEAN
KHANH_HOA CAM_RANH Cam Ranh CHINESE
KIEN_GIANG HA_TIEN Hà Tiên COLOMBIAN
KIEN_GIANG PHU_QUOC Phú Quoc COMORAN
KIEN_GIANG RACH_GIA Rach Giá CONGOLESE
KON_TUM KON_TUM Kon Tum COSTARICAN
LAI_CHAU LAI_CHAU Lai Châu CROATIAN
LAM_DONG DA_LAT Da Lat CROATIAN
LAM_DONG BAO_LOC Bao Loc CUBAN
LANG_SON LANG_SON Lang Son CYPRIOT
 LAO_CAI LAO_CAI Lào Cai CZECH
LONG_AN TAN_AN Tân An KOREAN
MEKONG_DELTA CAN_THO Can Tho CONGOLESE
NAM_DINH NAM_DINH Nam Dinh DANISH
NGHE_AN VINH Vinh DJIBOUTI
NINH_BINH TAM_DIEP Tam Diep DOMINICAN
NINH_BINH NINH_BÌNH Ninh Bình DOMINICANS
NINH_THUAN PHAN_RANG_THAP_CHA Phan Rang-Tháp C ECUADOREAN
PHU_THO VINT_TRI Vint Trì EGYPTIAN
PHU_YEN TUY_HOA Tuy Hòa SALVADORANS
QUANG_BINH DONG_HOI Dong Hoi EQUATORIALGUINE
QUANG_NAM HOI_AN Hoi An ERITREAN
QUANG_NAM TAM_KY Tam Ky ESTONIAN
QUANG_NGAI QUANG_NGAI Quang Ngãi ETHIOPIAN
QUANG_NINH HA_LONG Ha Long FIJIAN
QUANG_NINH MONG_CAI Móng Cái FINNISH
QUANG_NINH UONG_BI Uông Bí FRENCH
QUANG_NINH CAM_PHA Cam Pha GABONESE
QUANG_TRI DONG_HA Dong Ha GAMBIAN
RED_RIVER_DELTA HAI_PHONG Hai Phong GEORGIAN
RED_RIVER_DELTA HANOI Hanoi GERMAN
SOC_TRANG SOC_TRANG Sóc Trang GHANAIAN
SON_LA SON_LA Son La GREEK
SOUTH_CENTRAL_CODA_NANG Da Nang GRENADIAN
SOUTH_EAST HO_CHI_MINH_CITY Ho Chi Minh City GUATEMALAN
TAY_NINH TAY_NINH Tây Ninh GUINEAN
THAI_BINH THAI_BINH Thái Bình GUINEABISSAUAN
THAI_NGUYEN THAI_NGUYEN Thái Nguyên GUYANESE
THAI_NGUYEN SONG_CONG Sông Công HAITIAN
THANH_HOA SAM_SON Sam Son HONDURAN
THANH_HOA THANH_HOA Thanh Hóa HUNGARIAN
THUA_THIEN_HEU HUE Hue ICELANDER
TIEN_GIANG MY_THO My Tho INDIAN
TRA_VINH TRA_VINH Trà Vinh IRANIAN
TUYEN_QUANG TUYEN_QUANG Tuyên Quang IRAQI
VINH_LONG VINH_LONG Vinh Long IRISH
VINH_PHUC VINH_YEN Vinh Yên ISRAELI
VINH_PHUC PHUC_YEN Phúc Yên ITALIAN
YEN_BAI YEN_BAI Yên Bái JAMAICAN
JAPANESE
JORDANIAN
KAZAKHSTANI
KENYAN
KIRIBATI
hố Cần Thơ KUWAITI
KYRGYZ
LAOTIAN
LATVIAN
 LEBANESE
LESOTHO
LIBERIAN
LIBYAN
LIECHTENSTEINER
Rịa-Vũng Tàu LITHUANIAN
LUXEMBOURGER
MALAGASY
MALAWIAN
MALAYSIAN
MALDIVAN
MALIAN
MALTESE
MARSHALLESE
MAURITANIAN
MAURITIAN
MEXICAN
MICRONESIAN
MONACAN
MONGOLIAN
MONTENEGRIN
MOROCCAN
MOZAMBICAN
ên Quang MYANMAR
NAMIBIAN
NAURUAN
NEPALESE
DUTCH
NEWZEALANDER
NICARAGUAN
NIGER
NIGERIEN
NORWEGIAN
OMANI
PAKISTANI
PALAUAN
PANAMANIAN
PAPUANEWGUINEA
PARAGUAYAN
PERUVIAN
FILIPINO
POLISH
PORTUGUESE
QATARI
KOREAN
MOLDOVANS
ROMANIAN
RUSSIAN
 RWANDAN
KITTIAN
SAINTLUCIAN
SAINTVINCENTIAN
SAMOAN
SANMARINESE
SAOTOMEAN
SAUDI
SENEGALESE
SERBIAN
SEYCHELLOIS
SIERRALEONEAN
SINGAPOREAN
SLOVAKIAN
SLOVENIAN
SOLOMONISLANDER
SOMALI
SOUTHAFRICAN
SOUTHSUDANESE
SPANISH
SRILANKAN
SUDANESE
SURINAMER
SWAZI
SWISS
SWEDISH
SYRIAN
TAJIK
THAI
MACEDONIAN
TIMORESE
TOGOLESE
TONGAN
TRINIDADIAN
entral Coast TUNISIAN
TURKISH
TURKMEN
TUVALUAN
UGANDAN
UKRAINIAN
EMIRATI
BRITISH
TANZANIAN
AMERICAN
URUGUAYAN
UZBEKISTANI
VANUATU
VENEZUELAN
VIETNAMESE
YEMENITE
ZAMBIAN
ZIMBABWEAN
VATICAN
PALESTINIANS
Value TitleCD value stateHelperCell1
IndonesianADV. ADV. #REF!
Afghan Brig. Brig.
Albanian Capt. Capt.
Algerian CDR. CDR.
Andorran Coln. Coln.
Angolan DATIN DATIN
Antiguans DATUK DATUK
ArgentineaDr. Dr.
Armenian ENCIK ENCIK
Australian Fr. Fr.
Austrian G.CAPT G.CAPT
AzerbaijaniLT. LT.
Bahamian LT.COL LT.COL
Bahraini M/s M/s
BangladeshMAJOR MAJOR
Barbadian Mast. Mast.
Belarusian MD. MD.
Belgian MR MR
Belizean Mr. Mr.
Beninese Mrs. Mrs.
BhutaneseMs. Ms.
Bolivian MST/MS MST/MS
Bosnian Oth. Oth.
Botswana Prof. Prof.
Brazilian PUAN PUAN
Bruneian S. S.
Bulgarian S/M S/M
Burkinabe SISTER SISTER
Burundian SK. SK.
CambodianSR. SR.
CamerooniTANSRI TANSRI
Canadian WNGCOM WNGCOM
Capeverdean
Centralafrican
Chadian
Chilean
Chinese
Colombian
Comoran
Congolese
Costarican
Croatian
Croatian
Cuban
Cypriot
Czech
Korean
Congolese
Danish
Djibouti
Dominican
Dominicans
Ecuadorean
Egyptian
Salvadorans
Equatorialguinean
Eritrean
Estonian
Ethiopian
Fijian
Finnish
French
Gabonese
Gambian
Georgian
German
Ghanaian
Greek
Grenadian
Guatemalan
Guinean
Guineabissauan
Guyanese
Haitian
Honduran
Hungarian
Icelander
Indian
Iranian
Iraqi
Irish
Israeli
Italian
Jamaican
Japanese
Jordanian
Kazakhstani
Kenyan
Kiribati
Kuwaiti
Kyrgyz
Laotian
Latvian
Lebanese
Lesotho
Liberian
Libyan
Liechtensteiner
Lithuanian
Luxembourger
Malagasy
Malawian
Malaysian
Maldivan
Malian
Maltese
Marshallese
Mauritanian
Mauritian
Mexican
Micronesian
Monacan
Mongolian
Montenegrin
Moroccan
Mozambican
Myanmar
Namibian
Nauruan
Nepalese
Dutch
Newzealander
Nicaraguan
Niger
Nigerien
Norwegian
Omani
Pakistani
Palauan
Panamanian
Papuanewguinean
Paraguayan
Peruvian
Filipino
Polish
Portuguese
Qatari
Korean
Moldovans
Romanian
Russian
Rwandan
Kittian
Saintlucian
Saintvincentian
Samoan
Sanmarinese
Saotomean
Saudi
Senegalese
Serbian
Seychellois
Sierraleonean
Singaporean
Slovakian
Slovenian
Solomonislander
Somali
Southafrican
Southsudanese
Spanish
Srilankan
Sudanese
Surinamer
Swazi
Swiss
Swedish
Syrian
Tajik
Thai
Macedonian
Timorese
Togolese
Tongan
Trinidadian
Tunisian
Turkish
Turkmen
Tuvaluan
Ugandan
Ukrainian
Emirati
British
Tanzanian
American
Uruguayan
Uzbekistani
Vanuatu
Venezuelan
Vietnamese
Yemenite
Zambian
Zimbabwean
Vatican
Palestinians
stateHelperCell2 stateHelperCell3 CityHelperCell1
#REF! #REF! #REF!
CityHelperCell2 CityHelperCell3 MasterFlagDataHelper
#REF! #REF! 1
0
Occupation
ARM_FORCES
MONEY_COLLECTOR
MONEY_CHANGER
MONEY_LENDER
ARMS_DEALER
POLITICIAN
Accountant
WORKER
WELDER
WAITER__WAITERESS
UNEMPLOYED
TECHNICIAN
TEACHER_PROFESSOR
STUDENT
SOCIAL
SKILLED_WORKER
SERVANT
SERVICE
SCRAP_DEALER
SALES_REPRESENTATIVE
RETIRED
PROFESSIONAL_OTHERS
PROFESSIONAL_ATHLETES
PROFESSIONAL
POLICE_OFFICER
POLICE_OTHERS
PLUMBER
PHARMACIST_CHEMIST
PETROL_PUMP_ATTENDANT
PAINTER
NURSING
SOCIAL_SERVICE
OTHER
OFFICE_MANAGER
OFFICE_CLERK
TEACHERS
NURSE
GOVT_CLERICAL
GOVT_OFFICE_STAFF
MINORCHILD
MINING_INDUSTRY
MILITARY_OTHERS
MILITARY_OFFICER
MILITARY_NCO
MERCHANT_NAVY_OFFICER
MERCHANT_NAVY_CREW
MECHANIC
MASON
LIQOUR_TRADE
LAWYER
LABOURER
JOCKEY
JEWELLER
HOUSEWIFE
HOTEL_OTHERS
HOTEL_ADMINISTRATION
HELPER
HAZARDOUS_OCCUPATION
GARDNER
G391TRANSPORT_W
G39_TRANSPORT_S
FISHERMAN
FARM_WORKER
FARM_OWNER
F361INDUSTRY_W
F36_INDUSTRY_S
EXECUTIVE
ELECTRICIAN
METAL_W
P_METAL_S
PAPER_W
PAPER_S
WOOD_W
WOOD_S
TEXTILE_W
TEXTILE_S
LEATHER_W
LEATHER_S
RUBBER_W
RUBBER_S
TOBACCO_W
TOBACCO_S
FOODPROD_W
FOODPROD_S
DRILLER
DRAFTSMAN
DOCTOR
DIVER
DELIVERY_COURIER_BOY
MINES_GROUND_W
COOK
CONTRACTOR
CATERER
FOREST_S
BUILDER
BUSINESS_OWNER
BORROWER
BARTENDER
ARMY_NAVY_POLICE
ARMED_FORCES
AIRLINE_CREW
AGRICULTURE
AFFINITY
ACTOR
CLERICAL_STAFF
AGRICULTARIST
MGMT_OFFICE_STAFF