| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals |
---|
TOP05A: OW HR & PR Foundation |
1 | F060120 | Employee Master Additional Information File | 3 | YA | CTBB | Country - Birth | String | UDC | 3 | 0 |
User Defined Codes are, by design, customisable and thus will differ from system to system depending on the business requirements.
TOPUDC 00 / CN (Country Codes) stock values
| Value | Description | Special Handling Code | Hard Coded |
---|
1 | AE | UNITED ARAB EMIRATES | | N |
2 | AN | NETHERLANDS ANTILLES | | N |
3 | AZ | AZERBAIJAN | | N |
4 | BA | BOSNIA | | N |
5 | BB | BARBADOS | | N |
6 | BD | BANGLADESH | | N |
7 | BE | BELGIUM | | N |
8 | BF | BURKINA FASO | | N |
9 | BG | BULGARIA | | N |
10 | BH | BAHRAIN | | N |
11 | BI | BURUNDI | | N |
12 | BJ | BENIN | | N |
13 | BM | BERMUDA | | N |
14 | BN | BRUNEI | | N |
15 | BO | BOLIVIA | | N |
16 | BR | BRAZIL | | N |
17 | BS | BAHAMAS | | N |
18 | BT | BHUTAN | | N |
19 | BW | BOTSWANA | | N |
20 | BY | BELARUS | | N |
21 | BZ | BELIZE | | N |
22 | CA | CANADA | | N |
23 | CD | CONGO, | | N |
24 | CF | CENTRAL AFRICAN | | N |
25 | CG | CONGO | | N |
26 | CH | SWITZERLAND | | N |
27 | CI | COTE D'IVOIRE | | N |
28 | CK | COOK ISLANDS | | N |
29 | CL | CHILE | | N |
30 | CM | CAMEROON | | N |
31 | CN | CHINA, | | N |
32 | CO | COLOMBIA | | N |
33 | CR | COSTA RICA | | N |
34 | CU | CUBA | | N |
35 | CV | CAPE VERDE | | N |
36 | CY | CYPRUS | | N |
37 | CZ | CZECH REPUBLIC, THE | | N |
38 | DE | GERMANY | | N |
39 | DJ | DJIBOUTI | | N |
40 | DK | DENMARK | | N |
41 | DM | DOMINICA | | N |
42 | DO | DOMINICAN REPUBLIC | | N |
43 | EC | ECUADOR | | N |
44 | EE | ESTONIA | | N |
45 | EG | EGYPT | | N |
46 | ER | ERITREA | | N |
47 | ES | SPAIN | | N |
48 | ET | ETHIOPIA | | N |
49 | FI | FINLAND | | N |
50 | FJ | FIJI | | N |
51 | FK | FALKLAND ISLANDS | | N |
52 | FM | MICRONESIA, | | N |
53 | FO | FAROE ISLANDS | | N |
54 | FR | FRANCE | | N |
55 | GA | GABON | | N |
56 | GB | UNITED KINGDOM | | N |
57 | GD | GRENADA | | N |
58 | GE | GEORGIA | | N |
59 | GF | FRENCH GUYANA | | N |
60 | GG | GUERNSEY | | N |
61 | GH | GHANA | | N |
62 | GI | GIBRALTAR | | N |
63 | GL | GREENLAND | | N |
64 | GM | GAMBIA | | N |
65 | GN | GUINEA REPUBLIC | | N |
66 | GP | GUADELOUPE | | N |
67 | GQ | GUINEA-EQUATORIAL | | N |
68 | GR | GREECE | | N |
69 | GT | GUATEMALA | | N |
70 | GU | GUAM | | N |
71 | GW | GUINEA-BISSAU | | N |
72 | GY | GUYANA (BRITISH) | | N |
73 | HK | HONG KONG | | N |
74 | HN | HONDURAS | | N |
75 | HR | CROATIA | | N |
76 | HT | HAITI | | N |
77 | HU | HUNGARY | | N |
78 | IC | CANARY ISLANDS, THE | | N |
79 | ID | INDONESIA | | N |
80 | IE | IRELAND, REPUBLIC OF | | N |
81 | IL | ISRAEL | | N |
82 | IN | INDIA | | N |
83 | IQ | IRAQ | | N |
84 | IR | IRAN (ISLAMIC REPUBLIC OF) | | N |
85 | IS | ICELAND | | N |
86 | IT | ITALY | | N |
87 | JE | JERSEY | | N |
88 | JM | JAMAICA | | N |
89 | JO | JORDAN | | N |
90 | JP | JAPAN | | N |
91 | KE | KENYA | | N |
92 | KG | KYRGYZSTAN | | N |
93 | KH | CAMBODIA | | N |
94 | KI | KIRIBATI | | N |
95 | KM | COMOROS | | N |
96 | KN | ST. KITTS | | N |
97 | KP | KOREA, THE D.P.R OF | | N |
98 | KR | KOREA, REPUBLIC OF | | N |
99 | KV | KOSOVO | | N |
100 | KW | KUWAIT | | N |
101 | KY | CAYMAN ISLANDS | | N |
102 | KZ | KAZAKHSTAN | | N |
103 | LA | LAO PEOPLE'S | | N |
104 | LB | LEBANON | | N |
105 | LC | ST. LUCIA | | N |
106 | LI | LIECHTENSTEIN | | N |
107 | LK | SRI LANKA | | N |
108 | LR | LIBERIA | | N |
109 | LS | LESOTHO | | N |
110 | LT | LITHUANIA | | N |
111 | LU | LUXEMBOURG | | N |
112 | LV | LATVIA | | N |
113 | LY | LIBYA | | N |
114 | MA | MOROCCO | | N |
115 | MC | MONACO | | N |
116 | MD | MOLDOVA, REPUBLIC OF | | N |
117 | ME | MONTENEGRO, | | N |
118 | MG | MADAGASCAR | | N |
119 | MH | MARSHALL ISLANDS | | N |
120 | MK | MACEDONIA, | | N |
121 | ML | MALI | | N |
122 | MM | MYANMAR | | N |
123 | MN | MONGOLIA | | N |
124 | MO | MACAU | | N |
125 | MP | SAIPAN | | N |
126 | MQ | MARTINIQUE | | N |
127 | MR | MAURITANIA | | N |
128 | MS | MONTSERRAT | | N |
129 | MT | MALTA | | N |
130 | MU | MAURITIUS | | N |
131 | MV | MALDIVES | | N |
132 | MW | MALAWI | | N |
133 | MX | MEXICO | | N |
134 | MY | MALAYSIA | | N |
135 | MZ | MOZAMBIQUE | | N |
136 | NA | NAMIBIA | | N |
137 | NC | NEW CALEDONIA | | N |
138 | NE | NIGER | | N |
139 | NG | NIGERIA | | N |
140 | NI | NICARAGUA | | N |
141 | NL | NETHERLANDS, THE | | N |
142 | NO | NORWAY | | N |
143 | NP | NEPAL | | N |
144 | NR | NAURU, REPUBLIC OF | | N |
145 | NU | NIUE | | N |
146 | NZ | NEW ZEALAND | | N |
147 | OM | OMAN | | N |
148 | PA | PANAMA | | N |
149 | PE | PERU | | N |
150 | PF | TAHITI | | N |
151 | PG | PAPUA NEW GUINEA | | N |
152 | PH | PHILIPPINES, THE | | N |
153 | PK | PAKISTAN | | N |
154 | PL | POLAND | | N |
155 | PR | PUERTO RICO | | N |
156 | PT | PORTUGAL | | N |
157 | PW | PALAU | | N |
158 | PY | PARAGUAY | | N |
159 | QA | QATAR | | N |
160 | RE | REUNION, ISLAND OF | | N |
161 | RO | ROMANIA | | N |
162 | RS | SERBIA, REPUBLIC OF | | N |
163 | RU | RUSSIAN FEDERATION, THE | | N |
164 | RW | RWANDA | | N |
165 | SA | SAUDI ARABIA | | N |
166 | SB | SOLOMON ISLANDS | | N |
167 | SC | SEYCHELLES | | N |
168 | SD | SUDAN | | N |
169 | SE | SWEDEN | | N |
170 | SG | SINGAPORE | | N |
171 | SI | SLOVENIA | | N |
172 | SK | SLOVAKIA | | N |
173 | SL | SIERRA LEONE | | N |
174 | SM | SAN MARINO | | N |
175 | SN | SENEGAL | | N |
176 | SO | SOMALIA | | N |
177 | SR | SURINAME | | N |
178 | ST | SAO TOME AND PRINCIPE | | N |
179 | SV | EL SALVADOR | | N |
180 | SY | SYRIA | | N |
181 | SZ | SWAZILAND | | N |
182 | TC | TURKS AND CAICOS ISLANDS | | N |
183 | TD | CHAD | | N |
184 | TG | TOGO | | N |
185 | TH | THAILAND | | N |
186 | TJ | TAJIKISTAN | | N |
187 | TM | TURKMENISTAN | | N |
188 | TN | TUNISIA | | N |
189 | TO | TONGA | | N |
190 | TP | EAST TIMOR | | N |
191 | TR | TURKEY | | N |
192 | TT | TRINIDAD AND TOBAGO | | N |
193 | TV | TUVALU | | N |
194 | TW | TAIWAN | | N |
195 | TZ | TANZANIA | | N |
196 | UA | UKRAINE | | N |
197 | UG | UGANDA | | N |
198 | US | UNITED STATES OF AMERICA | | N |
199 | UY | URUGUAY | | N |
200 | UZ | UZBEKISTAN | | N |
201 | VC | ST. VINCENT | | N |
202 | VE | VENEZUELA | | N |
203 | VG | VIRGIN ISLANDS (BRITISH) | | N |
204 | VI | VIRGIN ISLANDS (US) | | N |
205 | VN | VIETNAM | | N |
206 | VU | VANUATU | | N |
207 | WS | SAMOA | | N |
208 | XB | BONAIRE | | N |
209 | XC | CURACAO | | N |
210 | XE | ST. EUSTATIUS | | N |
211 | XM | ST. MAARTEN | | N |
212 | XN | NEVIS | | N |
213 | XS | SOMALILAND, | | N |
214 | XY | ST. BARTHELEMY | | N |
215 | YE | YEMEN, REPUBLIC OF | | N |
216 | YT | MAYOTTE | | N |
217 | ZA | SOUTH AFRICA | | N |
218 | ZM | ZAMBIA | | N |
219 | ZW | ZIMBABWE | | N |