APHDR Data Sets

Army Public Health Data Repository (APHDR)

DMDC_Perstempo-STARRS-USAPHC (19).xlsx

APHDR Data Sets

OMB:

Document [xlsx]
Download: xlsx | pdf

Overview

1.Cover Letter
2.Perstempo-STARRS Atr
Country Codes
US State Alpha Codes
Geolocation Codes


Sheet 1: 1.Cover Letter

This tab, 1.Cover Letter, describes the information in tab 2.



Tab
Description
2.Perstempo_Active-STARRS 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 Army STARRS (or USAPHC(Prov)) Approval User has accepted this as a valid element for their use-drop down list-Yes or No
H Army STARRS (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.

Sheet 2: 2.Perstempo-STARRS Atr

Source Source Tab Ord SourceTable Source Field Ord FieldName PII/HIPAA Sensitive Army STARRRS Approval Army STARRRS SP2Delta FieldType Nullability Primary Key Title Desc Values Notes FDM Comments ADS Comment Code Table Reference
DMDC/Perstempo 1 DMDC/Perstempo 1 PN_SSN_ID DI Yes 7/26/2010 picture numeric(9)

Gain Person Social Security Number Identifier The identifier assigned by the Social Security Administration to a person.

FileStartEndPos(1-9)


DMDC/Perstempo 1 DMDC/Perstempo 4 RSVCC_CD
Yes 7/26/2010 character(2)

Gain Reserve Category/Subcategory Code The code that represents the association of a Reserve component member with a subdivision of the Ready, Standby, or Retired Reserve, based on the member's liability for recall to active duty, and with a further subdivision, based on the member's position requirements, training status, or retirement basis. II = Inactive National Guard, individual
PJ = Ready Reserve member, untrained, officer training prg HPSP
PK = Ready Reserve member, untrained, HPSP
RE = Individual Ready Reserve member, trained
RH = Individual Ready Reserve member, untrained, in DEP
RM = Individual Ready Reserve member, trained, sbj to invol act
RU = Individual Ready Reserve member, untrained, awaiting IADT
SA = Selected Reserve, trained individual in unit, 48+ IDT perds
SG = Selected Reserve, trained individual in unit, AGR
TB = SR, trained indv not in unit, Indv Mobilization Augmentee
UF = Selected Reserve, individual in training pipeline, on IADT
UP = SR, indv in training pipe, awaiting IADT, auth IDT
UQ = SR, indvl in training pipe, awaiting 2nd part of IADT
US = SR, indv in training pipel, AGR on or awaiting IADT
UT = SR, indv in training pipe, Simultaneous Membership Program
UX = SR, indv in training pipe, other training program
V1 = Retired Reserve, Reserve service retiree age 60 or more
V2 = Retired Reserve, Reserve service retiree less than age 60
V3 = Retired Reserve, disability retiree
V4 = Retired Reserve, Active service retiree
V5 = Retired Reserve, other retiree
YD = Standby Reserve member, Active Status List
YL = Sby Rsv, indv: Inact Stat List, 20+yrs Rsv svc & <30% disbl
YN = Standby Reserve, individual on Inactive Status List, other
ZZ = Not Applicable

FileStartEndPos(12-13)


DMDC/Perstempo 1 DMDC/Perstempo 5 VL_ATVN_IND_CD
Yes 7/26/2010 character(1)

Gain Voluntary Activation Indicator Code The code that indicates whether an activation action occurred with or without a member's consent. N = No
Y = Yes
Z = Unknown or Not Applicable

FileStartEndPos(14-14)


DMDC/Perstempo 1 DMDC/Perstempo 7 PERSTEMPO_TXN_TYP_CD
Yes 7/26/2010 character(2)

Gain Personnel Tempo Transaction Type Code The code that represents a type of personnel tempo transaction. BA = Personnel tempo begin and end
CA = Personnel tempo change
GA = Personnel tempo begin
GX = Cancellation of a personnel tempo begin
LA = Personnel tempo end
LX = Cancellation of a personnel tempo end

FileStartEndPos(20-21)


DMDC/Perstempo 1 DMDC/Perstempo 8 MBR_PT_EVNT_BGN_CDT
Yes 7/26/2010 date

Gain Member Personnel Tempo Event Begin Calendar Date The date when a member's participation in or association with a personnel tempo event or activity started.
YYYYMMDD FileStartEndPos(22-29)


DMDC/Perstempo 1 DMDC/Perstempo 9 ADMIN_COND_CD
Yes 7/26/2010 character(1)

Gain Administrative Condition Code The code that represents a status pertaining to the management of human resources. A = Present for duty
B = Casualty status
C = Civil confinement
D = Deserted
H = Leave Status
I = Military confinement
J = Absent without leave
K = Sick in quarters
M = In transit
Z = Unknown or Not Applicable

FileStartEndPos(30-30)


DMDC/Perstempo 1 DMDC/Perstempo 12 UNIT_ID_CD DI Yes 7/26/2010 character(8)

Gain Assigned Unit Identification Code The service unique code that represents the unit to which a member is assigned.
report the unit to which the member is assigned when called to active duty, unless this assignment is permanently changed subsequent to the call to active duty. If unknown, report all Z's. FileStartEndPos(33-40)


DMDC/Perstempo 1 DMDC/Perstempo 13 UNIT_ID_CD_2 DI Yes 7/26/2010 character(8)

Gain Duty Unit Identification Code The service unique code that represents the unit to which a member has reported for duty.
If a value has not been designated, report the Assigned Unit Identification Code value. If unknown, report all Z's. FileStartEndPos(41-48)


DMDC/Perstempo 1 DMDC/Perstempo 14 CTRY_CD
Yes 7/26/2010 character(2)

Gain Duty Unit Location Country Code The code that represents the principle geopolitical entity of the world for the actual shore or port location of the unit to which a member has reported for duty. Country Codes Report US for the 50 states and District of Columbia and the appropriate value for other US and all non-US territory. If afloat at sea or unknown, report ZZ. If classified, report all zeros. FileStartEndPos(49-50)


DMDC/Perstempo 1 DMDC/Perstempo 15 US_ST_A_CD
Yes 7/26/2010 character(2)

Gain Duty Unit Location US State Alpha Code The alphabetic code that represents a principal divisions or outlying and associated area of the US for the actual shore or port location of the unit to which a member has reported for duty. US State Alpha Codes If non-US, afloat at sea, or unknown, report ZZ. If classified, report all zeros. FileStartEndPos(51-52)


DMDC/Perstempo 1 DMDC/Perstempo 17 GEO_CD
Yes 7/26/2010 character(4)

Gain Duty Unit Location Geolocation Code The code that represents a designated place of military interest for the actual shore or port location of the unit to which a member has reported for duty. Geolocation Codes If classified, not applicable, or unknown, report ZZZZ. FileStartEndPos(55-58)


DMDC/Perstempo 1 DMDC/Perstempo 18 PN_INTH_IND_CD
Yes 7/26/2010 character(1)

Gain Person In Theater Indicator Code The code that indicates whether a person is considered to be in a theater. N = No
Y = Yes
Z = Unknown
A member is considered to be in theater if he or she is located within the theater of operations or is in receipt of Special Pay for Duty Subject to Hostile Fire or Imminent Danger for service related to the associated personnel tempo event. Report only if Personnel Tempo Event Category Code (field 17) equals A or B. If unknown, report Z. FileStartEndPos(59-59)


DMDC/Perstempo 1 DMDC/Perstempo 24 PT_EVNT_DPLY_IND_CD
Yes 7/26/2010 character(1)

Gain Deployment Personnel Tempo Event Indicator Code The code that indicates whether or not a personnel tempo event or activity is a deployment. N = No
Y = Yes

FileStartEndPos(73-73)


DMDC/Perstempo 1 DMDC/Perstempo 25 PERSTEMPO_EVNT_CAT_CD
Yes 7/26/2010 character(1)

Gain Personnel Tempo Event Category Code The code that represents a classificiation of a personnel tempo event. A = Operation
B = Exercise
C = Unit Training
D = Mission support TDY
E = Individual Training
F = Home Station Training
G = Duty in Garrison
H = Hospitalization in are of PDS/Homeport
I = Disciplinary Event
J = Inactive Duty Training
K = Muster Duty
L = Funeral Honors Duty
Z = Unknown
Values A - D, F Applicable only if Deployment Personnel Tempo Event Indicator Code (field 16) equals Y.
Values E, G - L Applicable only if Deployment Personnel Tempo Event Indicator Code equals N.
FileStartEndPos(74-74)


DMDC/Perstempo 1 DMDC/Perstempo 26 PERSTEMPO_EVNT_PRPS_CD
Yes 7/26/2010 character(1)

Gain Personnel Tempo Event Purpose Code The code that represents the function or objective of a personnel tempo event or activitiy. A = Contingency Operation
D = Counter-Drug Operation
E = Law Enforcement Operation
F = US Domestic Civil Operation
G = Humanitarian Operation
F = Peace Keeping Operation
G = Surveillance Operation
H = Joint or Combined Exercise
I = Service Exercise
J = NATO Exercise
K = Unit Training at a Combined Training Center
L = Unit Training at a Designated Training Area
M = Forward Presence
N = Hospitalization
Z = Unknown
Applicable only if the Personnel Tempo Event Category Code (field 17) equals A (values A, D - I, O - P), B (values J - L, P), or C ( values M - N, P). FileStartEndPos(75-75)


DMDC/Perstempo 1 DMDC/Perstempo 27 RSV_AD_TYP_CD
Yes 7/26/2010 character(1)

Gain Reserve Active Duty Type Code The code that represents the specific authority under which a Reserve component member is ordered to active duty. A = Active Duty for Special Work
B = Active Duty for Training
C = Annual Training
D = Presidential Reserve Call-up
E = Partial Mobilization
F = Full Mobilization
G = Extended Active Duty
Z = Unknown

FileStartEndPos(76-76)


DMDC/Perstempo 1 DMDC/Perstempo 28 MBR_PT_EVNT_PEND_CDT
Yes 7/26/2010 date

Gain Member Personnel Tempo Event Projected End Calendar Date The date when an association between a member and a personnel tempo event is projected to stop.
YYYYMMDD-If unknown, report all zeros. FileStartEndPos(77-84)


DMDC/Perstempo 1 DMDC/Perstempo 29 MBR_PT_EVNT_END_CDT
Yes 7/26/2010 date

Gain Member Personnel Tempo Event End Calendar Date The date when an association between a member and a personnel tempo event stopped.
YYYYMMDD-If not applicable or unknown, report all zeros. Not applicable if Personnel Tempo Transaction Type Code (field 7) equals CA. FileStartEndPos(85-92)


DMDC/Perstempo 1 DMDC/Perstempo 30 PT_CHNG_TXN_EFF_CDT
Yes 7/26/2010 date

Gain Personnel Tempo Change Transaction Effective Calendar Date The date when a personnel tempo change transaction came into effect.
YYYYMMDD-Applicable only if Personnel Tempo Transaction Type Code (field 7)
equals CA. If not applicable or unknown, report all zeros.
FileStartEndPos(93-100)


DMDC/Perstempo 1 DMDC/Perstempo 118 PN_SSN_ID_L DI Yes 7/26/2010 picture numeric(9)

Loss Person Social Security Number Identifier The identifier assigned by the Social Security Administration to a person.

FileStartEndPos(535-543)


DMDC/Perstempo 1 DMDC/Perstempo 121 RSVCC_CD_L
Yes 7/26/2010 character(2)

Loss Reserve Category/Subcategory Code The code that represents the sponsor's Reserve category and training/retirement category. II = Inactive National Guard, individual
PJ = Ready Reserve member, untrained, officer training prg HPSP
PK = Ready Reserve member, untrained, HPSP
RE = Individual Ready Reserve member, trained
RH = Individual Ready Reserve member, untrained, in DEP
RM = Individual Ready Reserve member, trained, sbj to invol act
RU = Individual Ready Reserve member, untrained, awaiting IADT
SA = Selected Reserve, trained individual in unit, 48+ IDT perds
SG = Selected Reserve, trained individual in unit, AGR
TB = SR, trained indv not in unit, Indv Mobilization Augmentee
UF = Selected Reserve, individual in training pipeline, on IADT
UP = SR, indv in training pipe, awaiting IADT, auth IDT
UQ = SR, indvl in training pipe, awaiting 2nd part of IADT
US = SR, indv in training pipel, AGR on or awaiting IADT
UT = SR, indv in training pipe, Simultaneous Membership Program
UX = SR, indv in training pipe, other training program
V1 = Retired Reserve, Reserve service retiree age 60 or more
V2 = Retired Reserve, Reserve service retiree less than age 60
V3 = Retired Reserve, disability retiree
V4 = Retired Reserve, Active service retiree
V5 = Retired Reserve, other retiree
YD = Standby Reserve member, Active Status List
YL = Sby Rsv, indv: Inact Stat List, 20+yrs Rsv svc & <30% disbl
YN = Standby Reserve, individual on Inactive Status List, other
ZZ = Not Applicable

FileStartEndPos(546-547)


DMDC/Perstempo 1 DMDC/Perstempo 122 VL_ATVN_IND_CD_L
Yes 7/26/2010 character(1)

Loss Voluntary Activation Indicator Code The code that indicates whether an activation action to a specified operation occurred with or without a member's consent. N = No
Y = Yes
Z = Unknown or Not Applicable

FileStartEndPos(548-548)


DMDC/Perstempo 1 DMDC/Perstempo 124 PERSTEMPO_TXN_TYP_CD_L
Yes 7/26/2010 character(2)

Loss Personnel Tempo Transaction Type Code The code that represents a type of personnel tempo transaction. BA = Personnel tempo begin and end
CA = Personnel tempo change
GA = Personnel tempo begin
GX = Cancellation of a personnel tempo begin
LA = Personnel tempo end
LX = Cancellation of a personnel tempo end

FileStartEndPos(554-555)


DMDC/Perstempo 1 DMDC/Perstempo 125 MBR_PT_EVNT_BGN_CDT_L
Yes 7/26/2010 date

Loss Member Personnel Tempo Event Begin Calendar Date The date when a member's participation in or association with a personnel tempo event or activity started.
YYYYMMDD FileStartEndPos(556-563)


DMDC/Perstempo 1 DMDC/Perstempo 126 ADMIN_COND_CD_L
Yes 7/26/2010 character(1)

Loss Administrative Condition Code The code that represents a status pertaining to the management of human resources. A = Present for duty
B = Casualty status
C = Civil confinement
D = Deserted
H = Leave Status
I = Military confinement
J = Absent without leave
K = Sick in quarters
M = In transit
Z = Unknown or Not Applicable

FileStartEndPos(564-564)


DMDC/Perstempo 1 DMDC/Perstempo 129 MIL_UNIT_ID_L DI Yes 7/26/2010 character(8)

Loss Assigned Unit Identification Code The code that represents a unit organization.
Report the unit to which the member is assigned when called to active duty, unless this assignment is permanently changed subsequent to the call to active duty. If unknown, report all Z's. FileStartEndPos(567-574)


DMDC/Perstempo 1 DMDC/Perstempo 130 MIL_UNIT_ID_L2 DI Yes 7/26/2010 character(8)

Loss Duty Unit Identification Code The code that represents a unit organization.
Report the unit to which the member is assigned when called to active duty, unless this assignment is permanently changed subsequent to the call to active duty. If unknown, report all Z's. FileStartEndPos(575-582)


DMDC/Perstempo 1 DMDC/Perstempo 131 CTRY_CD_L
Yes 7/26/2010 character(2)

Loss Duty Unit Location Country Code The code that represents a principle geopolitical entity of the world. Country Codes Report US for the 50 states and District of Columbia and the appropriate value for other US and all non-US territory. If afloat at sea or unknown, report ZZ. If classified, report all zeros. FileStartEndPos(583-584)


DMDC/Perstempo 1 DMDC/Perstempo 132 US_ST_A_CD_L
Yes 7/26/2010 character(2)

Loss Duty Unit Location US State Alpha Code The alphabetic code that represents a principal division or outlying or associated area of the US. US State Alpha Codes If non-US, afloat at sea, or unknown, report ZZ. If classified, report all zeros. FileStartEndPos(585-586)


DMDC/Perstempo 1 DMDC/Perstempo 134 GEO_CD_L
Yes 7/26/2010 character(4)

Loss Duty Unit Location Geolocation Code The code that represents a designated place of military interest. Geolocation Codes If classified, not applicable, or unknown, report ZZZZ. FileStartEndPos(589-592)


DMDC/Perstempo 1 DMDC/Perstempo 135 PN_INTH_IND_CD_L
Yes 7/26/2010 character(1)

Loss Person In Theater Indicator Code The code that identifies whether a person is considered to be in a theater. N = No
Y = Yes
Z = Unknown
A member is considered to be in theater if he or she is located within the theater of operations or is in receipt of Special Pay for Duty Subject to Hostile Fire or Imminent Danger for service related to the associated personnel tempo event. Report only if Personnel Tempo Event Category Code (field 17) equals A or B. If unknown, report Z. FileStartEndPos(593-593)


DMDC/Perstempo 1 DMDC/Perstempo 141 PT_EVNT_DPLY_IND_CD_L
Yes 7/26/2010 character(1)

Loss Deployment Personnel Tempo Event Indicator Code The code that indicates whether or not a personnel tempo event or activity is a deployment. N = No
Y = Yes

FileStartEndPos(607-607)


DMDC/Perstempo 1 DMDC/Perstempo 142 PERSTEMPO_EVNT_CAT_CD_L
Yes 7/26/2010 character(1)

Loss Personnel Tempo Event Category Code The code that represents a classificiation of a personnel tempo event. A = Operation
B = Exercise
C = Unit Training
D = Mission support TDY
E = Individual Training
F = Home Station Training
G = Duty in Garrison
H = Hospitalization in are of PDS/Homeport
I = Disciplinary Event
J = Inactive Duty Training
K = Muster Duty
L = Funeral Honors Duty
Z = Unknown

FileStartEndPos(608-608)


DMDC/Perstempo 1 DMDC/Perstempo 143 PERSTEMPO_EVNT_PRPS_CD_L
Yes 7/26/2010 character(1)

Loss Personnel Tempo Event Purpose Code The code that represents the function or objective of a personnel tempo event or activitiy. A = Contingency Operation
D = Counter-Drug Operation
E = Law Enforcement Operation
F = US Domestic Civil Operation
G = Humanitarian Operation
F = Peace Keeping Operation
G = Surveillance Operation
H = Joint or Combined Exercise
I = Service Exercise
J = NATO Exercise
K = Unit Training at a Combined Training Center
L = Unit Training at a Designated Training Area
M = Forward Presence
N = Hospitalization
Z = Unknown

FileStartEndPos(609-609)


DMDC/Perstempo 1 DMDC/Perstempo 144 RSV_AD_TYP_CD_L
Yes 7/26/2010 character(1)

Loss Reserve Active Duty Type Code The code that represents the specific authority under which a Reserve component member is ordered to active duty. A = Active Duty for Special Work
B = Active Duty for Training
C = Annual Training
D = Presidential Reserve Call-up
E = Partial Mobilization
F = Full Mobilization
G = Extended Active Duty
Z = Unknown

FileStartEndPos(610-610)


DMDC/Perstempo 1 DMDC/Perstempo 145 MBR_PT_EVNT_PEND_CDT_L
Yes 7/26/2010 date

Loss Member Personnel Tempo Event Projected End Calendar Date The date when an association between a member and a personnel tempo event is projected to stop.
YYYYMMDD-If unknown, report all zeros. FileStartEndPos(611-618)


DMDC/Perstempo 1 DMDC/Perstempo 146 MBR_PT_EVNT_END_CDT_L
Yes 7/26/2010 date

Loss Member Personnel Tempo Event End Calendar Date The date when an association between a member and a personnel tempo event stopped.
YYYYMMDD-If not applicable or unknown, report all zeros. Not applicable if Personnel Tempo Transaction Type Code (field 7) equals CA. FileStartEndPos(619-626)


DMDC/Perstempo 1 DMDC/Perstempo 147 PT_CHNG_TXN_EFF_CDT_L
Yes 7/26/2010 date

Loss Personnel Tempo Change Transaction Effective Calendar Date The date when a personnel tempo change transaction came into effect.
YYYYMMDD-Applicable only if Personnel Tempo Transaction Type Code (field 7)
equals CA. If not applicable or unknown, report all zeros.
FileStartEndPos(627-634)


DMDC/Perstempo 1 DMDC/Perstempo 153 PERSTEMPO_TXN_TYP_CD_RS
Yes 7/26/2010 character(2)

Personnel Tempo Current Transaction Status Flag The code that represents a type of personnel tempo transaction. BA = Personnel tempo begin and end
CA = Personnel tempo change
GA = Personnel tempo begin
GX = Cancellation of a personnel tempo begin
LA = Personnel tempo end
LX = Cancellation of a personnel tempo end

FileStartEndPos(701-702)


DMDC/Perstempo 1 DMDC/Perstempo 11 DOD_ORG_CMPNT_CD





Uniformed Service Organization Component Code The code that represents a subdivision of an officially sanctioned organization whose
members wear military attire.
G = Guard
R = Regular
V = Reserve
Z = Unknown or Not Applicable






Sheet 3: Country Codes

Country Code DS A Vrsn 2


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
AQ American Samoa
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
BQ Navassa Island
BR Brazil
BS Bassas da India
BT Bhutan
BU Bulgaria
BV Bouvet Island
BX Brunei
BY Burundi
CA Canada
CB Cambodia
CD Chad
CE Sri Lanka
CF Congo
CG Congo, Democratic Republic of the
CH China
CI Chile
CJ Cayman Islands
CK Cocos (Keeling) Islands
CM Cameroon
CN Comoros
CO Colombia
CQ Northern Mariana Islands
CR Coral Sea Islands
CS Costa Rica
CT Central African Republic
CU Cuba
CV Cape Verde
CW Cook Islands
CY Cyprus
DA Denmark
DJ Djibouti
DO Dominica
DQ Jarvis Island
DR Dominican Republic
EC Ecuador
EG Egypt
EI Ireland
EK Equatorial Guinea
EN Estonia
ER Eritrea
ES El Salvador
ET Ethiopia
EU Europa Island
EZ Czech Republic
FG French Guiana
FI Finland
FJ Fiji
FK Falkland Islands (Islas Malvinas)
FM Federated States of Micronesia
FO Faroe Islands
FP French Polynesia
FQ Baker Island
FR France
FS French Southern and Antarctic Lands
GA Gambia, The
GB Gabon
GG Georgia
GH Ghana
GI Gibraltar
GJ Grenada
GK Guernsey
GL Greenland
GM Germany
GO Glorioso Islands
GP Guadeloupe
GQ Guam
GR Greece
GT Guatemala
GV Guinea
GY Guyana
GZ Gaza Strip
HA Haiti
HK Hong Kong
HM Heard Island and McDonald Islands
HO Honduras
HQ Howland Island
HR Croatia
HU Hungary
IC Iceland
ID Indonesia
IM Man, Isle of
IN India
IO British Indian Ocean Territory
IP Clipperton Island
IR Iran
IS Israel
IT Italy
IV Cote D'Ivoire
IZ Iraq
JA Japan
JE Jersey
JM Jamaica
JN Jan Mayen
JO Jordan
JQ Johnston Atoll
JU Juan de Nova Island
KE Kenya
KG Kyrgyzstan
KN Korea, Democratic People's Republic of
KQ Kingman Reef
KR Kiribati
KS Korea, Republic of
KT Christmas Island
KU Kuwait
KZ Kazakhstan
LA Laos
LE Lebanon
LG Latvia
LH Lithuania
LI Liberia
LO Slovakia
LQ Palmyra Atoll
LS Liechtenstein
LT Lesotho
LU Luxembourg
LY Libya
MA Madagascar
MB Martinique
MC Macau
MD Moldova
MF Mayotte
MG Mongolia
MH Montserrat
MI Malawi
MK Macedonia
ML Mali
MN Monaco
MO Morocco
MP Mauritius
MQ Midway Islands
MR Mauritania
MT Malta
MU Oman
MV Maldives
MW Montenegro
MX Mexico
MY Malaysia
MZ Mozambique
NC New Caledonia
NE Niue
NF Norfolk Island
NG Niger
NH Vanuatu
NI Nigeria
NL Netherlands
NO Norway
NP Nepal
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
PO Portugal
PP Papua New Guinea
PS Palau
PU Guinea-Bissau
QA Qatar
RE Reunion
RH Southern Rhodesia
RM Marshall Islands
RO Romania
RP Philippines
RQ Puerto Rico
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
SL Sierra Leone
SM San Marino
SN Singapore
SO Somalia
SP Spain
SR Serbia
ST St. Lucia
SU Sudan
SV Svalbard
SW Sweden
SX South Georgia and the South Sandwich Islands
SY Syria
SZ Switzerland
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
TS Tunisia
TU Turkey
TV Tuvalu
TW Taiwan
TX Turkmenistan
TZ Tanzania
UG Uganda
UK United Kingdom
UP Ukraine
US United States
UV Burkina Faso
UY Uruguay
UZ Uzbekistan
VC St. Vincent and the Grenadines
VE Venezuela
VI British Virgin Islands
VM Vietnam
VQ Virgin Islands
VT Vatican City
WA Namibia
WE West Bank
WF Wallis and Futuna
WI Western Sahara
WQ Wake Island
WS Samoa
WZ Swaziland
YM Yemen
ZA Zambia
ZI Zimbabwe

Sheet 4: US State Alpha Codes

US State Alpha Code DS A Vrsn 2


Value Description
AK Alaska
AL Alabama
AR Arkansas
AS American Samoa
AZ Arizona
CA California
CM Northern Mariana Islands
CO Colorado
CT Connecticut
CZ Canal Zone
DC District of Columbia
DE Delaware
FL Florida
FM Federated States of Micronesia
GA Georgia
GU Guam
HI Hawaii
IA Iowa
ID Idaho
IL Illinois
IN Indiana
KS Kansas
KY Kentucky
LA Louisiana
MA Massachusetts
MD Maryland
ME Maine
MH Marshall Islands
MI Michigan
MN Minnesota
MO Missouri
MP Northern Mariana Islands
MS Mississippi
MT Montana
NB Nebraska
NC North Carolina
ND North Dakota
NE Nebraska
NH New Hampshire
NJ New Jersey
NM New Mexico
NV Nevada
NY New York
OH Ohio
OK Oklahoma
OR Oregon
PA Pennsylvania
PR Puerto Rico
PW Palau
RI Rhode Island
SA American Samoa
SC South Carolina
SD South Dakota
TN Tennessee
TT Trust Territory of the Pacific Islands
TX Texas
UM US Minor Outlying Islands
UT Utah
VA Virginia
VI Virgin Islands of the US
VT Vermont
WA Washington
WI Wisconsin
WV West Virginia
WY Wyoming
ZZ Unknown or not applicable

Sheet 5: Geolocation Codes

CD NM START_DT STOP_DT FL
1A NORTH ATLANTIC OCEAN
X
1B BAY OF BISCAY
X
1C BRISTOL CHANNEL
X
1D DENMARK STRAIT
X
1E ENGLISH CHANNEL
X
1F BAY OF FUNDY
X
1G GULF OF GUINEA
X
1H HUDSON BAY
X
1J PANAMA CANAL
X
1K INNER SEAS-WEST COAST OF SCOTLAND
X
1L LABRADOR SEA
X
1M GULF OF MEXICO
X
1N NORTH SEA
X
1P BAFFIN BAY
X
1Q ST GEORGES CHANNEL
X
1R IRISH SEA
X
1S SKAGERRAK
X
1T GULF OF ST LAWRENCE
X
1U HUDSON STRAIT
X
1V DAVIS STRAIT
X
1X CARIBBEAN SEA
X
2A SOUTH ATLANTIC OCEAN
X
2D DRAKE PASSAGE
X
2J GULF OF SAN JORGE
X
2M GULF OF SAN MATIAS
X
2R RIO DE LA PLATA
X
2S SCOTIA SEA
X
2W WEDDELL SEA
X
3A NORTH PACIFIC OCEAN
X
3B GULF OF SAKHALIN
X
3C CELEBES SEA
X
3D GULF OF TATARY
X
3E EAST CHINA SEA
X
3F FORMOSA STRAIT
X
3G GULF OF TONKIN
X
3H HALMAHERA SEA
X
3I LUZON STRAIT
X
3J SEA OF JAPAN
X
3K SHELEKOVA GULF
X
3L GULF OF CALIFORNIA
X
3M MOLUCCA SEA
X
3N INLAND SEA
X
3P PHILIPPINE SEA
X
3Q SEA OF OKHOTSK
X
3R KOREA BAY
X
3S SULU SEA

X
3T GULF OF SIAM
X
3U SOUTH CHINA SEA
X
3V GULF OF TOMINI
X
3X GULF OF CHIHLI
X
3Y YELLOW SEA
X
3Z SINGAPORE STRAIT
X
4A SOUTH PACIFIC OCEAN
X
4B BANDA SEA
X
4C CORAL SEA
X
4D AMUNDSEN SEA
X
4E GULF OF BONE
X
4F FLORES SEA
X
4G BELLINGSHAUSEN SEA
X
4J JAVA SEA
X
4K BISMARCK SEA
X
4L BALI SEA
X
4M MAKASSAR STRAIT
X
4P GULF OF CARPENTARIA
X
4Q CEARAM SEA
X
4R ROSS SEA

X
4S SOLOMON SEA
X
4T TASMAN SEA
X
4U ARAFURA SEA
X
5A ARCTIC OCEAN
X
5B BARENTS SEA
X
5C CHUKCHI SEA
X
5D BERING SEA
X
5E ALASKA/BRITISH COLUMBIA COSTAL WATERS
X
5F GULF OF ALASKA
X
5G GREENLAND SEA
X
5K KARA SEA
X
5L LINCOLN SEA
X
5N NORWEGIAN SEA
X
5P LAPTEV SEA
X
5R BERING STRAIT
X
5S EAST SIBERIAN SEA
X
5T NORTHWEST PASSAGE
X
5U BEAUFORT SEA
X
5W WHITE SEA
X
5Y GULF OF ANADYR
X
6A INDIAN OCEAN
X
6B BAY OF BENGAL
X
6C MALACCA STRAIT
X
6D GULF OF ADEN
X
6E RED SEA
X
6F BASS STRAIT
X
6G GREAT AUSTRALIAN BIGHT
X
6L LACCADIVE SEA
X
6M GULF OF OMAN
X
6N ANDAMAN SEA
X
6P PERSIAN GULF
X
6Q GULF OF AQABA
X
6R ARABIAN SEA
X
6S SAVU SEA
X
6T TIMOR SEA

X
6U SUEZ CANAL
X
6W GULF OF SUEZ
X
6Z MOZAMBIQUE CHANNEL
X
7B BALTIC SEA
X
7F GULF OF FINLAND
X
7H GULF OF RIGA
X
7K KATTEGAT
X
7T GULF OF BOTHNIA
X
8B BLACK SEA
X
8C CASPIAN SEA
X
8D ADRIATIC SEA
X
8E EASTERN MEDITERRANEAN SEA
X
8G AEGEAN SEA
X
8J BALEARIC SEA
X
8L LIGURIAN SEA
X
8M SEA OF MARMARA
X
8N IONIAN SEA
X
8P BOSPORUS
X
8R ARAL SEA
X
8S STRAIT OF GIBRALTAR
X
8T TYRRHENIAN SEA
X
8U DARDANELLES
X
8W WESTERN MEDITERRANEAN SEA
X
8X GULF OF LION
X
8Y ALBORAN SEA
X
8Z SEA OF AZOV
X
98 CLASSIFIED LOCATION
X
9E LAKE ERIE
X
9H LAKE HURON
X
9L ST LAWRENCE SEAWAY
X
9M LAKE MICHIGAN
X
9N LAKE ONTARIO
X
9S LAKE SUPERIOR
X
AA ARUBA 19860401
C
AC ANTIGUA AND BARBUDA

C
AE UNITED ARAB EMIRATES

A
AF AFGHANISTAN

A
AG ALGERIA

F
AJ AZERBAIJAN 19920101
A
AL ALBANIA

E
AM ARMENIA 19920101
A
AN ANDORRA

W
AO ANGOLA

F
AR ARGENTINA

S
AS AUSTRALIA

P
AT ASHMORE AND CARTIER ISLANDS 19830601
P
AU AUSTRIA

E
AV ANGUILLA 19740601
C
AY ANTARCTICA

O
BA BAHRAIN

A
BB BARBADOS

C
BC BOTSWANA

F
BD BERMUDA

N
BE BELGIUM

W
BF THE BAHAMAS

C
BG BANGLADESH 19740601
A
BH BELIZE 19740601
S
BK BOSNIA AND HERZEGOVINA 19920801
E
BL BOLIVIA

S
BM BURMA

A
BN BENIN

F
BO BELARUS 19920101
A
BP SOLOMON ISLANDS

P
BR BRAZIL

S
BS BASSAS DA INDIA

I
BT BHUTAN

A
BU BULGARIA

E
BV BOUVET ISLAND 19780601
O
BX BRUNEI

P
BY BURUNDI

F
CA CANADA

N
CB CAMBODIA

A
CD CHAD

F
CE SRI LANKA

A
CF CONGO

F
CG DEMOCRATIC REPUBLIC OF THE CONGO

F
CH CHINA

A
CI CHILE

S
CJ CAYMAN ISLANDS

C
CK COCOS ISLANDS

I
CM CAMEROON

F
CN COMOROS

I
CO COLOMBIA

S
CR CORAL SEA ISLANDS 19830501
P
CS COSTA RICA

S
CT CENTRAL AFRICAN REPUBLIC

F
CU CUBA

C
CV CAPE VERDE

F
CW COOK ISLANDS

P
CY CYPRUS

E
CZ CZECHOSLOVAKIA
19930201 E
DA DENMARK

W
DJ DJIBOUTI 19770701
F
DO DOMINICA

C
DR DOMINICAN REPUBLIC

C
EC ECUADOR

S
EG EGYPT

F
EI IRELAND

W
EK EQUATORIAL GUINEA

S
EN ESTONIA 19910901
E
ER ERITREA 19930501
F
ES EL SALVADOR

S
ET ETHIOPIA

F
EU EUROPA ISLAND 19830501
F
EZ CZECH REPUBLIC 19930201
E
FG FRENCH GUIANA

S
FI FINLAND

E
FJ FIJI

P
FK FALKLAND ISLANDS

I
FM FEDERATED STATES OF MICRONESIA

P
FO FAROE ISLANDS

S
FP FRENCH POLYNESIA

S
FR FRANCE

W
FS FRENCH SOUTHERN AND ANTARCTIC LANDS

P
GA THE GAMBIA

F
GB GABON

I
GC EAST GERMANY
19901001 E
GE WEST GERMANY
19901001 W
GG GEORGIA 19920101
A
GH GHANA

F
GI GIBRALTAR

W
GJ GRENADA

C
GK GUERNSEY 19830501
W
GL GREENLAND

N
GM GERMANY 19901001
W
GO GLORIOSO ISLANDS 19830501
I
GP GUADELOUPE

C
GR GREECE

E
GT GUATEMALA

S
GV GUINEA

F
GY GUYANA

S
GZ GAZA STRIP

F
HA HAITI

C
HK HONG KONG

A
HM HEARD ISLAND AND MCDONALD ISLANDS

I
HO HONDURAS

S
HR CROATIA 19920801
E
HU HUNGARY

E
IC ICELAND

N
ID INDONESIA

A
IM ISLE OF MAN 19830501
W
IN INDIA

A
IO BRITISH INDIAN OCEAN TERRITORY

I
IP CLIPPERTON ISLAND 19830501
P
IR IRAN

A
IS ISRAEL

A
IT ITALY

W
IV COTE DIVOIRE

O
IZ IRAQ

A
JA JAPAN

A
JE JERSEY 19830501
W
JM JAMAICA

C
JN JAN MAYEN

C
JO JORDAN

A
JU JUAN DE NOVA ISLAND

C
KE KENYA

A
KG KYRGYZSTAN 19920101
A
KN DEMOCRATIC PEOPLE IS REPUBLIC OF KOREA

A
KR KOREA (KOREAN WAR)

A
KS REPUBLIC OF KOREA

A
KT CHRISTMAS ISLAND

I
KU KUWAIT

A
KZ KAZAKHSTAN 19920101
I
LA LAOS

A
LE LEBANON

A
LG LATVIA 19910901
E
LH LITHUANIA 19910901
E
LI LIBERIA

F
LO SLOVAKIA 19930201
E
LS LIECHTENSTEIN

W
LT LESOTHO

A
LU LUXEMBOURG

W
LY LIBYA

F
MA MADAGASCAR

F
MB MARTINIQUE

C
MC MACAU

A
MD MOLDOVA

E
MF MAYOTTE 19830501
I
MG MONGOLIA

A
MH MONTSERRAT

C
MI MALAWI

F
MK MACEDONIA 19920801
E
ML MALI

I
MN MONACO

W
MO MOROCCO

F
MP MAURITIUS

F
MR MAURITANIA

C
MT MALTA

F
MU OMAN

A
MV MALDIVES

A
MW MONTENEGRO 19920801
F
MX MEXICO

N
MY MALAYSIA

A
MZ MOZAMBIQUE

F
NC NEW CALEDONIA

C
NE NIUE

P
NF NORFOLK ISLAND

P
NG NIGER

F
NH VANUATU

P
NI NIGERIA

F
NL NETHERLANDS

W
NO NORWAY

E
NP NEPAL

A
NR NAURU

F
NS SURINAME

S
NT NETHERLANDS ANTILLES

C
NU NICARAGUA

S
NZ NEW ZEALAND

P
PA PARAGUAY

S
PC PITCAIRN ISLANDS

P
PE PERU

S
PF PARACEL ISLANDS

P
PG SPRATLY ISLANDS

P
PK PAKISTAN

A
PL POLAND

E
PM PANAMA

S
PO PORTUGAL

W
PP PAPUA NEW GUINEA

P
PS PALAU

P
PU GUINEA-BISSAU

F
QA QATAR

A
RE REUNION

I
RM MARSHALL ISLANDS

P
RO ROMANIA

E
RP PHILIPPINES

P
RS RUSSIA 19920101
A
RW RWANDA

F
SA SAUDI ARABIA

A
SB ST PIERRE AND MIQUELON

N
SC ST KITTS AND NEVIS

O
SE SEYCHELLES

I
SF SOUTH AFRICA

F
SG SENEGAL

F
SH ST HELENA

O
SI SLOVENIA 19920801
E
SL SIERRA LEONE

F
SM SAN MARINO

W
SN SINGAPORE

A
SO SOMALIA

F
SP SPAIN

W
SR SERBIA 19920801
E
ST ST LUCIA

C
SU SUDAN

F
SV SVALBARD

W
SW SWEDEN

E
SX SOUTH GEORGIA AND THE SOUTH SANDWICH ISLANDS

P
SY SYRIA

A
SZ SWITZERLAND

W
TD TRINIDAD AND TOBAGO

C
TE TROMELIN ISLAND

I
TH THAILAND

A
TI TAJIKISTAN 19920101
A
TK TURKS AND CAICOS ISLANDS

C
TL TOKELAU

P
TN TONGA

P
TO TOGO

F
TP SAO TOME AND PRINCIPE

F
TS TUNISIA

F
TT EAST TIMOR

A
TU TURKEY

A
TV TUVALU

P
TW TAIWAN

A
TX TURKMENISTAN 19920101
A
TZ TANZANIA

F
UG UGANDA

F
UK UNITED KINGDOM

W
UP UKRAINE 19920101
E
UR UNION OF SOVIET SOCIALIST REPUBLICS
19911231 A
US UNITED STATES

N
UV BURKINA FASO 19841101
F
UY URUGUAY

S
UZ UZBEKISTAN 19920101
A
VC ST VINCENT AND THE GRENADINES

C
VE VENEZUELA

S
VI BRITISH VIRGIN ISLANDS

C
VM VIETNAM 19760101
A
VN NORTH VIETNAM

A
VS SOUTH VIETNAM

A
VT VATICAN CITY

W
WA NAMIBIA

F
WE WEST BANK

A
WF WALLIS AND FUTUNA

P
WI WESTERN SAHARA

F
WS WESTERN SAMOA

P
WZ SWAZILAND

F
XX UNKNOWN

O
YM YEMEN

A
YO YUGOSLAVIA
19920801 E
ZA ZAMBIA

F
ZI ZIMBABWE

F
File Typeapplication/vnd.openxmlformats-officedocument.spreadsheetml.sheet
File Modified0000-00-00
File Created0000-00-00

© 2025 OMB.report | Privacy Policy