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. |
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 |
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 |
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 |
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 Type | application/vnd.openxmlformats-officedocument.spreadsheetml.sheet |
File Modified | 0000-00-00 |
File Created | 0000-00-00 |