| This tab, 1.Cover Letter, descripes the information in tab 2 of this document. |
|
|
|
| Tab |
|
Description |
| 2.DMDC-CTS-USAPHC(Prov) Atr |
Report on the attributes available for selection. Explaination of the report column heads appears below, titled Column Definitions. |
|
|
|
|
Column Definitions |
|
|
|
| Column |
Name |
Description |
| A |
Source |
Name of Data Source |
| B |
SourceTabOrd |
Ordinal Position of Table in Data Dictionary received from Source System-used internally |
| C |
SourceTable |
Name of the Table from which the data element is extracted from Source System |
| D |
SourceFieldOrd |
Ordinal Position of the data element in a Table in the Source System Data Dictionary-used internally |
| E |
FieldName |
Name of the data element (please use the literal format as in the column) |
| F |
PII/HIPAA Sensitive |
Please note YES, NO or DI (De-Identification)for the element PII or HIPAA sensitivity. If the element is PII or HIPAA sensitive and it will be de-identified, enter DI. A blank enter will be considered the same as a NO. |
| G |
NIMH (or USAPHC(Prov)) Approval |
User has accepted this as a valid element for their use-drop down list-Yes or No |
| H |
NIMH (or USAPHC(Prov)) SP2Delta |
Date the data element requested in Spiral-2. This will help in revising your existing extract routines |
| I |
FieldType |
This is the data type. |
| J |
Nullability |
This is the Nullability condition |
| K |
Primary Key |
Indicator if data element is a primary key (PK) or foreign key (FK) in this table |
| L |
Title |
Data Element Name |
| M |
Desc |
Dictionary meaning of the data element and enumerated values if applicable |
| N |
Values |
Information on values the element may have |
| O |
Notes |
Notes concerning the element |
| P |
FDM Comments |
Please add any comments that will help us understand the output extract. |
| Q |
ADS Comment |
Please add any comments on authoritativeness |
| R |
Code Table Reference |
Reference to code table. |
| Source |
Source Tab Ord |
SourceTable |
Source Field Ord |
FieldName |
PII/HIPAA Sensitive |
USAPHC (Prov) Approval |
NIMH Approval |
USAPHC (Prov) SP2Delta |
FieldType |
Nullability |
Primary Key |
Title |
Desc |
Values |
Notes |
FDM Comments |
ADS Comment |
Code Table Reference |
| DMDC/CTS |
1 |
DMDC/CTS |
1 |
EVN_TYP_CD |
|
Yes |
Yes |
1/12/2010 |
varchar(1) |
|
|
Event Type Code |
The code which determines if the event is an activation or deployment |
|
|
|
|
waiting for reference code table |
| DMDC/CTS |
1 |
DMDC/CTS |
2 |
PN_SSN_ID |
DI |
Yes |
Yes |
1/12/2010 |
number |
|
|
Person SSN Identifier |
The identifier assigned by the Social Security Administration to a person. |
|
|
|
|
|
| DMDC/CTS |
1 |
DMDC/CTS |
3 |
PN_SRNM_TX |
Yes |
Yes |
No |
1/12/2010 |
char(26) |
|
|
Person Surname Text |
The text of a designation applied to a person, generally referred to as the last or family name |
|
|
ADC-F will drop this field from the NIMH extract. |
|
|
| DMDC/CTS |
1 |
DMDC/CTS |
4 |
PN_FRNM_TX |
Yes |
Yes |
No |
1/12/2010 |
char(20) |
|
|
Person Forename Text |
The text of a designation applied to a person, generally referred to as the first name. |
|
|
ADC-F will drop this field from the NIMH extract. |
|
|
| DMDC/CTS |
1 |
DMDC/CTS |
5 |
PN_BRTH_CDT |
Yes |
Yes |
Yes |
1/12/2010 |
number |
|
|
Person Birth Calendar Date |
The date when a person was born. |
|
|
ADC-F will drop this field from the NIMH extract. |
|
|
| DMDC/CTS |
1 |
DMDC/CTS |
6 |
SVC_BR_CFN_CD |
|
Yes |
Yes |
1/12/2010 |
char(1) |
|
|
Service Branch Classification Code |
The code that represents an organizational categorization based on subdivisions recognized
by the defense community. |
|
|
|
|
waiting for reference code table |
| DMDC/CTS |
1 |
DMDC/CTS |
7 |
USVC_ORG_CMPNT_CD |
|
Yes |
Yes |
1/12/2010 |
char(1) |
|
|
Uniformed Service Organization Component Code |
The code that represents a subdivision of an officially sanctioned organization whose
members wear military attire. |
|
|
|
|
waiting for reference code table |
| DMDC/CTS |
1 |
DMDC/CTS |
8 |
STR_ACCT_CD |
|
Yes |
Yes |
1/12/2010 |
char(3) |
|
|
Stength Accounting Code |
The code that represents an accounting and programming category used by DoD to classify
personnel. |
|
|
|
|
waiting for reference code table |
| DMDC/CTS |
1 |
DMDC/CTS |
9 |
AGN_UIC |
DI |
Yes |
Yes |
1/12/2010 |
char(8) |
|
|
Assigned Unit Identification Code |
The Servide unique code that represents the unit to which a member is assigned. If unknown, report all Z's |
|
|
|
|
waiting for reference code table |
| DMDC/CTS |
1 |
DMDC/CTS |
10 |
ATC_UIC |
DI |
Yes |
Yes |
1/12/2010 |
char(8) |
|
|
Attached Unit Identification Code |
The service unique code that represents the unit to which a member has reported for duty. If unknown, report all Z's. |
|
|
|
|
waiting for reference code table |
| DMDC/CTS |
1 |
DMDC/CTS |
11 |
DEP_ARMY_MSC_CD |
Yes |
Yes |
No |
1/12/2010 |
char(30) |
|
|
Deployed Army Major Support Commend Text |
no definition supplied |
|
|
ADC-F will drop this field from the NIMH extract. |
|
|
| DMDC/CTS |
1 |
DMDC/CTS |
12 |
LOC_CTRY_CD |
|
Yes |
Yes |
1/12/2010 |
char(2) |
|
|
Location Country Code |
The code that represents a principle geopolitical entity of the world. |
|
|
|
|
waiting for reference code table |
| DMDC/CTS |
1 |
DMDC/CTS |
14 |
ACT_BGN_CDT |
|
Yes |
Yes |
1/12/2010 |
date |
|
|
Activation Begin Date |
no definition supplied |
|
|
|
|
|
| DMDC/CTS |
1 |
DMDC/CTS |
15 |
ACT_END_CDT |
|
Yes |
Yes |
1/12/2010 |
date |
|
|
Activation End Date |
no definition supplied |
|
|
|
|
|
| DMDC/CTS |
1 |
DMDC/CTS |
16 |
DEP_BGN_CDT |
|
Yes |
Yes |
1/12/2010 |
date |
|
|
Deployment Begin Date |
no definition supplied |
|
|
|
|
|
| DMDC/CTS |
1 |
DMDC/CTS |
17 |
DEP_END_CDT |
|
Yes |
Yes |
1/12/2010 |
date |
|
|
Deployment End Date |
no definition supplied |
|
|
|
|
|
| DMDC/CTS |
1 |
DMDC/CTS |
18 |
DEP_NM |
|
Yes |
Yes |
1/12/2010 |
char(4) |
|
|
Event Name Identifier |
The generic text title of an actiavtion, mobilization or deployment |
|
|
|
|
waiting for reference code table |
| DMDC/CTS |
1 |
DMDC/CTS |
19 |
LOC_BGN_CDT |
|
Yes |
Yes |
1/12/2010 |
date |
|
|
Location Event Begin Date |
The calendar date that a Service Member began a deployment or activation event at a
specific location. A single deployment or activation may include multiple location events. |
|
|
|
|
|
| DMDC/CTS |
1 |
DMDC/CTS |
20 |
LOC_END_CDT |
|
Yes |
Yes |
1/12/2010 |
date |
|
|
Location Event End Date |
The calendar date that a Service Member completed a deployment or activation event at a specific location. A single deployment or activation may include multiple location events. |
|
|
|
|
|
| DMDC/CTS |
1 |
DMDC/CTS |
21 |
LOC_ST_CD |
|
|
|
|
|
|
|
Location State Code |
The alphabetic code that represents a principal division or outlying or associated area of the |
|
|
|
|
|
| Strength Accounting Code |
|
| Value |
Description |
| A00 |
Active component military strength, personnel unit status unknown |
| A10 |
Active component military strength, force structure unit, personnel availability unknown |
| A11 |
Active component military strength, force structure unit, available personnel |
| A12 |
Active component military strength, force structure unit, nonavailable personnel (Personnel absent without leave, and personnel who have been diverted to tasks other than their primary duties but whose availability for duty is effectively controllable, directly or indirectly, by a unit, installation, or senior local commander. The latter category includes personnel on leave, on additional duties or details, on temporary duty for training or education, or on sick call or short-term hospitalization.) |
| A20 |
Active component military strength, individuals account, personnel account type unknown |
| A21 |
Active component military strength, individuals account, cadets and midshipmen |
| A22 |
Active component military strength, individuals account, enlisted trainees |
| A23 |
Active component military strength, individuals account, officer accession students |
| A24 |
Active component military strength, individuals account, students |
| A25 |
Active component military strength, individuals account, transients |
| A26 |
Active component military strength, individuals account, holdees (Includes patients, prisoners, and separatees.) |
| B00 |
Excluded from military strength, personnel status unknown |
| B10 |
Excluded from military strength, prisoners of war |
| B20 |
Excluded from military strength, missing personnel |
| B30 |
Excluded from military strength, deserters |
| B40 |
Excluded from military strength, prisoners in civil confinement for 6 or more months (or otherwise detained in a foreign country) |
| B50 |
Excluded from military strength, prisoners in military confinement for 6 or more months |
| B60 |
Excluded from military strength, prisoners in confinement for 6 or more months (or otherwise detained in a foreign country), confinement type unknown (Obsolete value.) |
| B70 |
Excluded from military strength, personnel on appellate leave following sentence to confinement by a courts martial |
| C00 |
Reserve mil strength, personnel operational status unk |
| C10 |
Reserve mil strength, contingency operatn, legal auth unk |
| C11 |
Reserve mil strength, contingency operatn, Act Grd personnel |
| C12 |
Reserve mil strength, contingency operatn, Act Rsv personnel |
| C14 |
Reserve mil strength, contngncy operatn, activated Grd prsnl |
| C15 |
Reserve mil strength, contngncy operatn, activated Rsv prsnl |
| C20 |
Reserve mil strength, personnel legal authority unknown |
| C21 |
Reserve mil strength, Active Guard personnel (Title 10 USC) |
| C22 |
Reserve mil strength, Active Reserve personnel |
| C23 |
Reserve mil strength, Active Guard personnel (Title 32 USC) |
| C24 |
Reserve mil strength, Grd prsnl on AT, ADT, or othr AD<180dy |
| C25 |
Reserve mil strength, Rsv prsnl on AT, ADT, or othr AD<180dy |
| Location State/Country Code |
|
|
| State Code |
Country Code |
Country |
| ZZ |
AA |
ARUBA |
| ZZ |
AC |
ANTIGUA AND BARBUDA |
| ZZ |
AE |
UNITED ARAB EMIRATES |
| ZZ |
AF |
AFGHANISTAN |
| ZZ |
AG |
ALGERIA |
| ZZ |
AJ |
AZERBAIJAN |
| ZZ |
AL |
ALBANIA |
| ZZ |
AM |
ARMENIA |
| ZZ |
AN |
ANDORRA |
| ZZ |
AO |
ANGOLA |
| ZZ |
AR |
ARGENTINA |
| ZZ |
AS |
AUSTRALIA |
| ZZ |
AT |
ASHMORE AND CARTIER ISLANDS |
| ZZ |
AU |
AUSTRIA |
| ZZ |
AV |
ANGUILLA |
| ZZ |
AY |
ANTARCTICA |
| ZZ |
BA |
BAHRAIN |
| ZZ |
BB |
BARBADOS |
| ZZ |
BC |
BOTSWANA |
| ZZ |
BD |
BERMUDA |
| ZZ |
BE |
BELGIUM |
| ZZ |
BF |
BAHAMAS, THE |
| ZZ |
BG |
BANGLADESH |
| ZZ |
BH |
BELIZE |
| ZZ |
BK |
BOSNIA AND HERZEGOVINA |
| ZZ |
BL |
BOLIVIA |
| ZZ |
BM |
BURMA |
| ZZ |
BN |
BENIN |
| ZZ |
BO |
BELARUS |
| ZZ |
BP |
SOLOMON ISLANDS |
| ZZ |
BR |
BRAZIL |
| ZZ |
BS |
BASSAS DA INDIA |
| ZZ |
BT |
BHUTAN |
| ZZ |
BU |
BULGARIA |
| ZZ |
BV |
BOUVET ISLAND |
| ZZ |
BX |
BRUNEI |
| ZZ |
BY |
BURUNDI |
| ZZ |
BZ |
GERMANY, BERLIN |
| ZZ |
CA |
CANADA |
| ZZ |
CB |
CAMBODIA |
| ZZ |
CD |
CHAD |
| ZZ |
CE |
SRI LANKA |
| ZZ |
CF |
CONGO |
| ZZ |
CG |
ZAIRE |
| ZZ |
CH |
CHINA |
| ZZ |
CI |
CHILE |
| ZZ |
CJ |
CAYMAN ISLANDS |
| ZZ |
CK |
COCOS (KEELING) ISLANDS |
| ZZ |
CL |
CENTRAL AND SOUTHERN LINE ISLANDS |
| ZZ |
CM |
CAMEROON |
| ZZ |
CN |
COMOROS |
| ZZ |
CO |
COLUMBIA |
| ZZ |
CR |
CORAL SEA ISLANDS |
| ZZ |
CS |
COSTA RICA |
| ZZ |
CT |
CENTRAL AFRICAN REPUBLIC |
| ZZ |
CU |
CUBA |
| ZZ |
CV |
CAPE VERDE |
| ZZ |
CW |
COOK ISLANDS |
| ZZ |
CY |
CYPRUS |
| ZZ |
CZ |
CZECHOSLOVAKIA |
| ZZ |
DA |
DENMARK |
| ZZ |
DJ |
DJIBOUTI |
| ZZ |
DM |
BENIN |
| ZZ |
DO |
DOMINICA |
| ZZ |
DR |
DOMINICAN REPUBLIC |
| ZZ |
EC |
ECUADOR |
| ZZ |
EG |
EGYPT |
| ZZ |
EI |
IRELAND |
| ZZ |
EK |
EQUATORIAL GUINEA |
| ZZ |
EN |
ESTONIA |
| ZZ |
EQ |
CANTON AND ENDERBURY ISLANDS |
| ZZ |
ER |
ERITREA |
| ZZ |
ES |
EL SALVADOR |
| ZZ |
ET |
ETHIOPIA |
| ZZ |
EU |
EUROPA ISLAND |
| ZZ |
EZ |
CZECH REPUBLIC |
| ZZ |
FA |
FALKLAND ISLANDS (ISLAS MALVINAS) |
| ZZ |
FG |
FRENCH GUIANA |
| ZZ |
FI |
FINLAND |
| ZZ |
FJ |
FIJI |
| ZZ |
FK |
FALKLAND ISLANDS (ISLAS MALVINAS) |
| ZZ |
FO |
FAROE ISLANDS |
| ZZ |
FP |
FRENCH POLYNESIA |
| ZZ |
FR |
FRANCE |
| ZZ |
FS |
FRENCH SOUTHERN AND ANTARCTIC LANDS |
| ZZ |
FT |
FRENCH TERRITORY OF THE AFARS AND I |
| ZZ |
GA |
GAMBIA, THE |
| ZZ |
GB |
GABON |
| ZZ |
GC |
GERMAN DEMOCRATIC REPUBLIC |
| ZZ |
GE |
GERMANY, FEDERAL REPUBLIC OF |
| ZZ |
GG |
GEORGIA |
| ZZ |
GH |
GHANA |
| ZZ |
GI |
GIBRALTAR |
| ZZ |
GJ |
GRENADA |
| ZZ |
GK |
GUERNSEY |
| ZZ |
GL |
GREENLAND |
| ZZ |
GM |
GERMANY |
| ZZ |
GN |
GILBERT AND ELLICE ISLANDS |
| ZZ |
GO |
GLORIOSO ISLANDS |
| ZZ |
GP |
GUADELOUPE |
| ZZ |
GR |
GREECE |
| ZZ |
GS |
GILBERT ISLANDS |
| ZZ |
GT |
GUATEMALA |
| ZZ |
GV |
GUINEA |
| ZZ |
GY |
GUYANA |
| ZZ |
GZ |
GAZA STRIP |
| ZZ |
HA |
HAITI |
| ZZ |
HK |
HONG KONG |
| ZZ |
HM |
HEARD ISLANDS AND MCDONALD ISLANDS |
| ZZ |
HO |
HONDURAS |
| ZZ |
HR |
CROATIA |
| ZZ |
HU |
HUNGARY |
| ZZ |
IC |
ICELAND |
| ZZ |
ID |
INDONESIA |
| ZZ |
IM |
MAN, ISLE OF |
| ZZ |
IN |
INDIA |
| ZZ |
IO |
BRITISH INDIAN OCEAN TERRITORY |
| ZZ |
IP |
CLIPPERTON ISLAND |
| ZZ |
IQ |
US MISCELLANEOUS PACIFIC ISLANDS |
| ZZ |
IR |
IRAN |
| ZZ |
IS |
ISRAEL |
| ZZ |
IT |
ITALY |
| ZZ |
IU |
ISRAEL-SYRIA DEMILITARIZED ZONE |
| ZZ |
IV |
COTE D'IVOIRE |
| ZZ |
IW |
ISRAEL-JORDAN DEMILITARIZED ZONE |
| ZZ |
IY |
IRAQ-SAUDI ARABIA NEUTRAL ZONE |
| ZZ |
IZ |
IRAQ |
| ZZ |
JA |
JAPAN |
| ZZ |
JE |
JERSEY |
| ZZ |
JM |
JAMAICA |
| ZZ |
JN |
JAN MAYEN |
| ZZ |
JO |
JORDAN |
| ZZ |
JS |
SVALBARD AND JAN MAYEN |
| ZZ |
JU |
JUAN DE NOVA ISLAND |
| ZZ |
KE |
KENYA |
| ZZ |
KG |
KYRGYZSTAN |
| ZZ |
KN |
KOREA, DEMOCRATIC PEOPLE'S REPUBLIC |
| ZZ |
KR |
KIRIBATI |
| ZZ |
KS |
KOREA, REPUBLIC OF |
| ZZ |
KT |
CHRISTMAS ISLAND |
| ZZ |
KU |
KUWAIT |
| ZZ |
KV |
KOSOVO |
| ZZ |
KZ |
KAZAKHSTAN |
| ZZ |
LA |
LAOS |
| ZZ |
LE |
LEBANON |
| ZZ |
LG |
LATVIA |
| ZZ |
LH |
LITHUANIA |
| ZZ |
LI |
LIBERIA |
| ZZ |
LO |
SLOVAKIA |
| ZZ |
LS |
LIECHTENSTEIN |
| ZZ |
LT |
LESOTHO |
| ZZ |
LU |
LUXEMBOURG |
| ZZ |
LY |
LIBYA |
| ZZ |
MA |
MADAGASCAR |
| ZZ |
MB |
MARTINIQUE |
| ZZ |
MC |
MACAU |
| ZZ |
MD |
MOLDOVA |
| ZZ |
ME |
SPANISH TERRITORIES IN NORTHERN MOR |
| ZZ |
MF |
MAYOTTE |
| ZZ |
MG |
MONGOLIA |
| ZZ |
MH |
MONTSERRAT |
| ZZ |
MI |
MALAWI |
| ZZ |
MJ |
MONTENEGRO |
| ZZ |
MK |
MACEDONIA |
| ZZ |
ML |
MALI |
| ZZ |
MN |
MONACO |
| ZZ |
MO |
MOROCCO |
| ZZ |
MP |
MAURITIUS |
| ZZ |
MR |
MAURITANIA |
| ZZ |
MT |
MALTA |
| ZZ |
MU |
OMAN |
| ZZ |
MV |
MALDIVES |
| ZZ |
MW |
MONTENEGRO |
| ZZ |
MX |
MEXICO |
| ZZ |
MY |
MAYLAYSIA |
| ZZ |
MZ |
MOZAMBIQUE |
| ZZ |
NA |
NETHERLANDS ANTILLES |
| ZZ |
NC |
NEW CALDEDONIA |
| ZZ |
NE |
NIUE |
| ZZ |
NF |
NORFOLK ISLAND |
| ZZ |
NG |
NIGER |
| ZZ |
NH |
VANUATU |
| ZZ |
NI |
NIGERIA |
| ZZ |
NL |
NETHERLANDS |
| ZZ |
NO |
NORWAY |
| ZZ |
NP |
NEPAL |
| ZZ |
NQ |
TRUST TERRITORY OF THE PACIFIC ISLA |
| ZZ |
NR |
NAURU |
| ZZ |
NS |
SURINAME |
| ZZ |
NT |
NETHERLANDS ANTILLES |
| ZZ |
NU |
NICARAGUA |
| ZZ |
NZ |
NEW ZEALAND |
| ZZ |
PA |
PARAGUAY |
| ZZ |
PC |
PITCAIRN ISLANDS |
| ZZ |
PE |
PERU |
| ZZ |
PF |
PARACEL ISLANDS |
| ZZ |
PG |
SPRATLY ISLANDS |
| ZZ |
PK |
PAKISTAN |
| ZZ |
PL |
POLAND |
| ZZ |
PM |
PANAMA |
| ZZ |
PN |
PANAMA |
| ZZ |
PO |
PORTUGAL |
| ZZ |
PP |
PAPUA NEW GUINEA |
| ZZ |
PQ |
CANAL ZONE |
| ZZ |
PT |
PORTUGUESE TIMOR |
| ZZ |
PU |
GUINEA-BISSAU |
| ZZ |
QA |
QATAR |
| ZZ |
RB |
SERBIA |
| ZZ |
RE |
REUNION |
| ZZ |
RH |
SOUTHERN RHODESIA |
| ZZ |
RO |
ROMANIA |
| ZZ |
RP |
PHILIPPINES |
| ZZ |
RS |
RUSSIA |
| ZZ |
RW |
RWANDA |
| ZZ |
SA |
SAUDI ARABIA |
| ZZ |
SB |
ST PIERRE AND MIQUELON |
| ZZ |
SC |
ST. KITTS AND NEVIS |
| ZZ |
SE |
SEYCHELLES |
| ZZ |
SF |
SOUTH AFRICA |
| ZZ |
SG |
SENEGAL |
| ZZ |
SH |
ST. HELENA |
| ZZ |
SI |
SLOVENIA |
| ZZ |
SK |
SIKKIM |
| ZZ |
SL |
SIERRA LEONE |
| ZZ |
SM |
SAN MARINO |
| ZZ |
SN |
SINGAPORE |
| ZZ |
SO |
SOMALIA |
| ZZ |
SP |
SPAIN |
| ZZ |
SQ |
SWAN ISLANDS |
| ZZ |
SR |
SERBIA |
| ZZ |
SS |
SPANISH SAHARA |
| ZZ |
ST |
ST. LUCIA |
| ZZ |
SU |
SUDAN |
| ZZ |
SV |
SVALDBARD |
| ZZ |
SW |
SWEDEN |
| ZZ |
SX |
SOUTH GEORGIA AND THE SOUTH SANDWIC |
| ZZ |
SY |
SYRIA |
| ZZ |
SZ |
SWITZERLAND |
| ZZ |
TC |
UNITED ARAB EMIRATES |
| ZZ |
TD |
TRINIDAD AND TOBAGO |
| ZZ |
TE |
TROMELIN ISLAND |
| ZZ |
TH |
THAILAND |
| ZZ |
TI |
TAJIKISTAN |
| ZZ |
TK |
TURKS AND CAICOS ISLANDS |
| ZZ |
TL |
TOKELAU |
| ZZ |
TN |
TONGA |
| ZZ |
TO |
TOGO |
| ZZ |
TP |
SAO TOME AND PRINCIPE |
| ZZ |
TQ |
TRUST TERRITORY OF THE PACIFIC ISLA |
| ZZ |
TS |
TUNISIA |
| ZZ |
TT |
EAST TIMOR |
| ZZ |
TU |
TURKEY |
| ZZ |
TV |
TUVALU |
| ZZ |
TW |
TAIWAN |
| ZZ |
TX |
TURKMENISTAN |
| ZZ |
TZ |
TANZANIA, UNITED REPUBLIC OF |
| ZZ |
UG |
UGANDA |
| ZZ |
UK |
UNITED KINGDOM |
| ZZ |
UM |
US MINOR OUTLYING ISLANDS |
| ZZ |
UP |
UKRAINE |
| ZZ |
UR |
UNION OF SOVIET SOCIALIST REPUBLICS |
| ZZ |
US |
UNITED STATES |
| ZZ |
UV |
BURKINA |
| ZZ |
UY |
URUGUAY |
| ZZ |
UZ |
UZBEKISTAN |
| ZZ |
VC |
ST. VINCENT AND THE GRENADINES |
| ZZ |
VE |
VENEZUELA |
| ZZ |
VI |
BRITISH VIRGIN ISLANDS |
| ZZ |
VM |
VIETNAM |
| ZZ |
VN |
VIET-NAM NORTH |
| ZZ |
VS |
VIETNAM, REPUBLIC OF |
| ZZ |
VT |
VATICAN CITY |
| ZZ |
WA |
NAMIBIA |
| ZZ |
WB |
WEST BERLIN |
| ZZ |
WE |
WEST BANK |
| ZZ |
WF |
WALLIS AND FUTUNA |
| ZZ |
WI |
WESTERN SAHARA |
| ZZ |
WS |
WESTERN SAMOA |
| ZZ |
WZ |
SWAZILAND |
| ZZ |
XX |
OVERSEAS |
| ZZ |
YE |
YEMEN |
| ZZ |
YI |
YUGOSLAVIA |
| ZZ |
YM |
YEMEN |
| ZZ |
YO |
YUGOSLAVIA |
| ZZ |
YQ |
RYUKYU ISLANDS |
| ZZ |
YS |
SOUTHERN YEMEN |
| ZZ |
ZA |
ZAMBIA |
| ZZ |
ZI |
ZIMBABWE |
| ZZ |
ZZ |
UNKNOWN |
| WY |
US |
WYOMING |
| WV |
US |
WEST VIRGINIA |
| WI |
US |
WISCONSIN |
| WA |
US |
WASHINGTON |
| VT |
US |
VERMONT |
| VI |
VQ |
VIRGIN ISLANDS |
| VA |
US |
VIRGINIA |
| UT |
US |
UTAH |
| UM |
BQ |
NAVASSA ISLAND |
| UM |
DQ |
JARVIS ISLAND |
| UM |
FQ |
BAKER ISLAND |
| UM |
HQ |
HOWLAND ISLAND |
| UM |
JQ |
JOHNSTON ATOLL |
| UM |
KQ |
KINGMAN REEF |
| UM |
LQ |
PALMYRA ATOLL |
| UM |
MQ |
MIDWAY ISLANDS |
| UM |
US |
US MINOR OUTLYING ISLANDS |
| UM |
WQ |
WAKE ISLAND |
| TX |
US |
TEXAS |
| TN |
US |
TENNESSEE |
| SD |
US |
SOUTH DAKOTA |
| SC |
US |
SOUTH CAROLINA |
| RI |
US |
RHODE ISLAND |
| PW |
PS |
PALAU |
| PW |
PS |
TRUST TERR OF PAC ISL PALAU |
| PR |
RQ |
PUERTO RICO |
| PA |
US |
PENNSYLVANIA |
| OR |
US |
OREGON |
| OK |
US |
OKLAHOMA |
| OH |
US |
OHIO |
| NY |
US |
NEW YORK |
| NV |
US |
NEVADA |
| NM |
US |
NEW MEXICO |
| NJ |
US |
NEW JERSEY |
| NH |
US |
NEW HAMPSHIRE |
| NE |
US |
NEBRASKA |
| ND |
US |
NORTH DAKOTA |
| NC |
US |
NORTH CAROLINA |
| MT |
US |
MONTANA |
| MS |
US |
MISSISSIPPI |
| MP |
CQ |
NORTHERN MARIANA ISLANDS |
| MO |
US |
MISSOURI |
| MN |
US |
MINNESOTA |
| MI |
US |
MICHIGAN |
| MH |
RM |
MARSHALL ISLANDS |
| ME |
US |
MAINE |
| MD |
US |
MARYLAND |
| MA |
US |
MASSACHUSETTS |
| LA |
US |
LOUISIANA |
| KY |
US |
KENTUCKY |
| KS |
US |
KANSAS |
| IN |
US |
INDIANA |
| IL |
US |
ILLINOIS |
| ID |
US |
IDAHO |
| IA |
US |
IOWA |
| HI |
US |
HAWAII |
| GU |
GQ |
GUAM |
| GA |
US |
GEORGIA |
| FM |
FM |
FEDERATED STATES OF MICRONESIA |
| FL |
US |
FLORIDA |
| DE |
US |
DELAWARE |
| DC |
US |
DISTRICT OF COLUMBIA |
| CT |
US |
CONNECTICUT |
| CO |
US |
COLORADO |
| CA |
US |
CALIFORNIA |
| AZ |
US |
ARIZONA |
| AS |
AQ |
AMERICAN SAMOA |
| AR |
US |
ARKANSAS |
| AP |
US |
ARMED FORCES PACIFIC |
| AL |
US |
ALABAMA |
| AK |
US |
ALASKA |
| AE |
US |
ARMED FORCES EUROPE |
| AA |
US |
ARMED FORCES THE AMERICAS |
| Location Country Code |
|
| Value |
Description |
| AA |
ARUBA |
| AC |
ANTIGUA AND BARBUDA |
| AE |
UNITED ARAB EMIRATES |
| AF |
AFGHANISTAN |
| AG |
ALGERIA |
| AJ |
AZERBAIJAN |
| AL |
ALBANIA |
| AM |
ARMENIA |
| AN |
ANDORRA |
| AO |
ANGOLA |
| AR |
ARGENTINA |
| AS |
AUSTRALIA |
| AT |
ASHMORE AND CARTIER ISLANDS |
| AU |
AUSTRIA |
| AV |
ANGUILLA |
| AY |
ANTARCTICA |
| BA |
BAHRAIN |
| BB |
BARBADOS |
| BC |
BOTSWANA |
| BD |
BERMUDA |
| BE |
BELGIUM |
| BF |
BAHAMAS, THE |
| BG |
BANGLADESH |
| BH |
BELIZE |
| BK |
BOSNIA AND HERZEGOVINA |
| BL |
BOLIVIA |
| BM |
BURMA |
| BN |
BENIN |
| BO |
BELARUS |
| BP |
SOLOMON ISLANDS |
| BR |
BRAZIL |
| BS |
BASSAS DA INDIA |
| BT |
BHUTAN |
| BU |
BULGARIA |
| BV |
BOUVET ISLAND |
| BX |
BRUNEI |
| BY |
BURUNDI |
| BZ |
GERMANY, BERLIN |
| CA |
CANADA |
| CB |
CAMBODIA |
| CD |
CHAD |
| CE |
SRI LANKA |
| CF |
CONGO |
| CG |
ZAIRE |
| CH |
CHINA |
| CI |
CHILE |
| CJ |
CAYMAN ISLANDS |
| CK |
COCOS (KEELING) ISLANDS |
| CL |
CENTRAL AND SOUTHERN LINE ISLANDS |
| CM |
CAMEROON |
| CN |
COMOROS |
| CO |
COLUMBIA |
| CR |
CORAL SEA ISLANDS |
| CS |
COSTA RICA |
| CT |
CENTRAL AFRICAN REPUBLIC |
| CU |
CUBA |
| CV |
CAPE VERDE |
| CW |
COOK ISLANDS |
| CY |
CYPRUS |
| CZ |
CZECHOSLOVAKIA |
| DA |
DENMARK |
| DJ |
DJIBOUTI |
| DM |
BENIN |
| DO |
DOMINICA |
| DR |
DOMINICAN REPUBLIC |
| EC |
ECUADOR |
| EG |
EGYPT |
| EI |
IRELAND |
| EK |
EQUATORIAL GUINEA |
| EN |
ESTONIA |
| EQ |
CANTON AND ENDERBURY ISLANDS |
| ER |
ERITREA |
| ES |
EL SALVADOR |
| ET |
ETHIOPIA |
| EU |
EUROPA ISLAND |
| EZ |
CZECH REPUBLIC |
| FA |
FALKLAND ISLANDS (ISLAS MALVINAS) |
| FG |
FRENCH GUIANA |
| FI |
FINLAND |
| FJ |
FIJI |
| FK |
FALKLAND ISLANDS (ISLAS MALVINAS) |
| FO |
FAROE ISLANDS |
| FP |
FRENCH POLYNESIA |
| FR |
FRANCE |
| FS |
FRENCH SOUTHERN AND ANTARCTIC LANDS |
| FT |
FRENCH TERRITORY OF THE AFARS AND I |
| GA |
GAMBIA, THE |
| GB |
GABON |
| GC |
GERMAN DEMOCRATIC REPUBLIC |
| GE |
GERMANY, FEDERAL REPUBLIC OF |
| GG |
GEORGIA |
| GH |
GHANA |
| GI |
GIBRALTAR |
| GJ |
GRENADA |
| GK |
GUERNSEY |
| GL |
GREENLAND |
| GM |
GERMANY |
| GN |
GILBERT AND ELLICE ISLANDS |
| GO |
GLORIOSO ISLANDS |
| GP |
GUADELOUPE |
| GR |
GREECE |
| GS |
GILBERT ISLANDS |
| GT |
GUATEMALA |
| GV |
GUINEA |
| GY |
GUYANA |
| GZ |
GAZA STRIP |
| HA |
HAITI |
| HK |
HONG KONG |
| HM |
HEARD ISLANDS AND MCDONALD ISLANDS |
| HO |
HONDURAS |
| HR |
CROATIA |
| HU |
HUNGARY |
| IC |
ICELAND |
| ID |
INDONESIA |
| IM |
MAN, ISLE OF |
| IN |
INDIA |
| IO |
BRITISH INDIAN OCEAN TERRITORY |
| IP |
CLIPPERTON ISLAND |
| IQ |
US MISCELLANEOUS PACIFIC ISLANDS |
| IR |
IRAN |
| IS |
ISRAEL |
| IT |
ITALY |
| IU |
ISRAEL-SYRIA DEMILITARIZED ZONE |
| IV |
COTE D'IVOIRE |
| IW |
ISRAEL-JORDAN DEMILITARIZED ZONE |
| IY |
IRAQ-SAUDI ARABIA NEUTRAL ZONE |
| IZ |
IRAQ |
| JA |
JAPAN |
| JE |
JERSEY |
| JM |
JAMAICA |
| JN |
JAN MAYEN |
| JO |
JORDAN |
| JS |
SVALBARD AND JAN MAYEN |
| JU |
JUAN DE NOVA ISLAND |
| KE |
KENYA |
| KG |
KYRGYZSTAN |
| KN |
KOREA, DEMOCRATIC PEOPLE'S REPUBLIC |
| KR |
KIRIBATI |
| KS |
KOREA, REPUBLIC OF |
| KT |
CHRISTMAS ISLAND |
| KU |
KUWAIT |
| KV |
KOSOVO |
| KZ |
KAZAKHSTAN |
| LA |
LAOS |
| LE |
LEBANON |
| LG |
LATVIA |
| LH |
LITHUANIA |
| LI |
LIBERIA |
| LO |
SLOVAKIA |
| LS |
LIECHTENSTEIN |
| LT |
LESOTHO |
| LU |
LUXEMBOURG |
| LY |
LIBYA |
| MA |
MADAGASCAR |
| MB |
MARTINIQUE |
| MC |
MACAU |
| MD |
MOLDOVA |
| ME |
SPANISH TERRITORIES IN NORTHERN MOR |
| MF |
MAYOTTE |
| MG |
MONGOLIA |
| MH |
MONTSERRAT |
| MI |
MALAWI |
| MJ |
MONTENEGRO |
| MK |
MACEDONIA |
| ML |
MALI |
| MN |
MONACO |
| MO |
MOROCCO |
| MP |
MAURITIUS |
| MR |
MAURITANIA |
| MT |
MALTA |
| MU |
OMAN |
| MV |
MALDIVES |
| MW |
MONTENEGRO |
| MX |
MEXICO |
| MY |
MAYLAYSIA |
| MZ |
MOZAMBIQUE |
| NA |
NETHERLANDS ANTILLES |
| NC |
NEW CALDEDONIA |
| NE |
NIUE |
| NF |
NORFOLK ISLAND |
| NG |
NIGER |
| NH |
VANUATU |
| NI |
NIGERIA |
| NL |
NETHERLANDS |
| NO |
NORWAY |
| NP |
NEPAL |
| NQ |
TRUST TERRITORY OF THE PACIFIC ISLA |
| NR |
NAURU |
| NS |
SURINAME |
| NT |
NETHERLANDS ANTILLES |
| NU |
NICARAGUA |
| NZ |
NEW ZEALAND |
| PA |
PARAGUAY |
| PC |
PITCAIRN ISLANDS |
| PE |
PERU |
| PF |
PARACEL ISLANDS |
| PG |
SPRATLY ISLANDS |
| PK |
PAKISTAN |
| PL |
POLAND |
| PM |
PANAMA |
| PN |
PANAMA |
| PO |
PORTUGAL |
| PP |
PAPUA NEW GUINEA |
| PQ |
CANAL ZONE |
| PT |
PORTUGUESE TIMOR |
| PU |
GUINEA-BISSAU |
| QA |
QATAR |
| RB |
SERBIA |
| RE |
REUNION |
| RH |
SOUTHERN RHODESIA |
| RO |
ROMANIA |
| RP |
PHILIPPINES |
| RS |
RUSSIA |
| RW |
RWANDA |
| SA |
SAUDI ARABIA |
| SB |
ST PIERRE AND MIQUELON |
| SC |
ST. KITTS AND NEVIS |
| SE |
SEYCHELLES |
| SF |
SOUTH AFRICA |
| SG |
SENEGAL |
| SH |
ST. HELENA |
| SI |
SLOVENIA |
| SK |
SIKKIM |
| SL |
SIERRA LEONE |
| SM |
SAN MARINO |
| SN |
SINGAPORE |
| SO |
SOMALIA |
| SP |
SPAIN |
| SQ |
SWAN ISLANDS |
| SR |
SERBIA |
| SS |
SPANISH SAHARA |
| ST |
ST. LUCIA |
| SU |
SUDAN |
| SV |
SVALDBARD |
| SW |
SWEDEN |
| SX |
SOUTH GEORGIA AND THE SOUTH SANDWIC |
| SY |
SYRIA |
| SZ |
SWITZERLAND |
| TC |
UNITED ARAB EMIRATES |
| TD |
TRINIDAD AND TOBAGO |
| TE |
TROMELIN ISLAND |
| TH |
THAILAND |
| TI |
TAJIKISTAN |
| TK |
TURKS AND CAICOS ISLANDS |
| TL |
TOKELAU |
| TN |
TONGA |
| TO |
TOGO |
| TP |
SAO TOME AND PRINCIPE |
| TQ |
TRUST TERRITORY OF THE PACIFIC ISLA |
| TS |
TUNISIA |
| TT |
EAST TIMOR |
| TU |
TURKEY |
| TV |
TUVALU |
| TW |
TAIWAN |
| TX |
TURKMENISTAN |
| TZ |
TANZANIA, UNITED REPUBLIC OF |
| UG |
UGANDA |
| UK |
UNITED KINGDOM |
| UM |
US MINOR OUTLYING ISLANDS |
| UP |
UKRAINE |
| UR |
UNION OF SOVIET SOCIALIST REPUBLICS |
| US |
UNITED STATES |
| UV |
BURKINA |
| UY |
URUGUAY |
| UZ |
UZBEKISTAN |
| VC |
ST. VINCENT AND THE GRENADINES |
| VE |
VENEZUELA |
| VI |
BRITISH VIRGIN ISLANDS |
| VM |
VIETNAM |
| VN |
VIET-NAM NORTH |
| VS |
VIETNAM, REPUBLIC OF |
| VT |
VATICAN CITY |
| WA |
NAMIBIA |
| WB |
WEST BERLIN |
| WE |
WEST BANK |
| WF |
WALLIS AND FUTUNA |
| WI |
WESTERN SAHARA |
| WS |
WESTERN SAMOA |
| WZ |
SWAZILAND |
| XX |
OVERSEAS |
| YE |
YEMEN |
| YI |
YUGOSLAVIA |
| YM |
YEMEN |
| YO |
YUGOSLAVIA |
| YQ |
RYUKYU ISLANDS |
| YS |
SOUTHERN YEMEN |
| ZA |
ZAMBIA |
| ZI |
ZIMBABWE |
| ZZ |
UNKNOWN |