| This tab, 1.Cover Letter, describes the information in the other tabs of this file. | ||
| Tab | Description | |
| 2.DMDC_Payroll_Ret-USAPHC Atr | Report on the attributes available for selection. Explaination of the report column heads appears below, titled Column Definitions. | |
| The following 4 tabs contain the 4 appendices supplied in the "Retired Military Pay Edit File (940 bytes") and referenced in tab 2 | ||
| 3.Appendix C | NS State Code DS A Vrsn 2 | |
| 4.Appendix D | Uniformed Service Rank Code DS B Vrsn 1 | |
| 5.Appendix E | US State Code DS A Vrsn 1 | |
| 6.Appendix F | Country Code DS A Vrsn 1 | |
| 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 | USAPHC (Prov) Approval | USAPHC (Prov) SP2Delta | FieldType | Nullability | Primary Key | Title | Desc | Values | Notes | FDM Comments | ADS Comment | Code Table Reference |
| DMDC/Payroll-Retired | 1 | DMDC/Payroll-Retired | 1 | SVC | Yes | 09/10/10 | character(1) | Service Branch Classification Code | The code which represents an organizational categorization based on subdivisions recognized by the defense community. | A=Army C=Coast Guard F=Air Force H=Public Health Service M=Marine Corps N=Navy O=National Oceanic and Atmospheric Administration |
no issues | ||||||
| DMDC/Payroll-Retired | 1 | DMDC/Payroll-Retired | 2 | SCRSSN | DI | Yes | 09/10/10 | character(9) | Member Social Security Number Identifier | The identifier assigned by the Social Security Administration to a person. | no issues | ||||||
| DMDC/Payroll-Retired | 1 | DMDC/Payroll-Retired | 3 | SCRPSSN | DI | Yes | 09/10/10 | character(9) | Member Prior Social Security Number Identifier | The identifier assigned by the Social Security Administration to a person. | will only be reported in the month it changed - nearly all records will show zeroes | ||||||
| DMDC/Payroll-Retired | 1 | DMDC/Payroll-Retired | 4 | LNAME | YES | Yes | 09/10/10 | character(26) | Member Surname Text | The text of a designation applied to a member generally referred to as the last or family name. | no issues | ||||||
| DMDC/Payroll-Retired | 1 | DMDC/Payroll-Retired | 5 | FNAME | YES | Yes | 09/10/10 | character(20) | Member Forename Text | The text of a designation applied to a member generally referred to as the first name. | no issues | ||||||
| DMDC/Payroll-Retired | 1 | DMDC/Payroll-Retired | 8 | DOB_DT | Yes | 09/10/10 | date(8) | Member Birth Calendar Date | The date that a person was born. | no issues- nearly every record populated | |||||||
| DMDC/Payroll-Retired | 1 | DMDC/Payroll-Retired | 9 | SEX | Yes | 09/10/10 | character(1) | Member Sex Code | The code that represents a classification of a person based on reproductive function. | F=Female M=Male Z=Unknown |
Army reports abt 7K Unknown | ||||||
| DMDC/Payroll-Retired | 1 | DMDC/Payroll-Retired | 10 | INL_ENT_DT | Yes | 09/10/10 | date(8) | Uniformed Service Initial Entry Calendar Date | The date an individual was first appointed, enlisted, or conscripted into a Uniformed Service. | no issues - well-populated | |||||||
| DMDC/Payroll-Retired | 1 | DMDC/Payroll-Retired | 11 | ENT_EFF_DT | Yes | 09/10/10 | date(8) | Military Retired Pay Entitlement Effective Calendar Date | The date the member became entitled to military retired pay. | the date the member was paid under the current FAN code - well populated. Army shows no records as zero filled | |||||||
| DMDC/Payroll-Retired | 1 | DMDC/Payroll-Retired | 12 | ORG_RET_DT | Yes | 09/10/10 | date(8) | Original Retirement Calendar Date | The date the member initially became entitled to military retired pay. | check date conflicts when member moves between TDRLs and PDRLs for this time period | |||||||
| DMDC/Payroll-Retired | 1 | DMDC/Payroll-Retired | 13 | CATCODE | Yes | 09/10/10 | character(1) | Original Retirement Personnel Category Code | The code that represents how the DoD personnel and/or finance center views the sponsor based on accountability and reporting strengths. The code represents a type of active, reserve, or retired personnel status of the member. | E=ENLISTED O=OFFICER W=WARRANT OFFICER |
no issues - well reported | ||||||
| DMDC/Payroll-Retired | 1 | DMDC/Payroll-Retired | 14 | AUTH_CD | Yes | 09/10/10 | character(1) | Military Retirement Authority Code | The code the represents the authority for military retirement. | A=Mandatory B=Voluntary C=Transfer to Fleet Reserve / Fleet Marine Corps Reserve D=Temporary Disability Retirement List E=Permanent Disability Retirement List F=Reserve (Title III) G=Reserve (Former Member) H=Reserve (Guard) |
some disconnects between this field and the FAN Code. | ||||||
| DMDC/Payroll-Retired | 1 | DMDC/Payroll-Retired | 15 | FANCODE | Yes | 09/10/10 | character(2) | Functional Account Number Code (FAN) | The code that represents the entitlement basis for military retired pay. | 01=Active Service, Regular Officer 02=Active Service, Regular Enlisted 03=Active Service, Nonregular Officer 04=Active Service, Nonregular Enlisted 07=Reserve Service, Officer 08=Reserve Service, Enlisted 11=TDRL, Regular Officer 12=TDRL, Regular Enlisted 13=TDRL, Nonregular Officer 14=TDRL, Nonregular Enlisted 21=PDRL, Regular Officer 22=PDRL, Regular Enlisted 23=PDRL, Nonregular Officer 24=PDRL, Nonregular Enlisted 31=Active Service, Trans to FR/FMCR, Regular Enlisted 32=Active Service, Trans to FR/FMCR, Nonregular Enlisted |
since this is the entitlement basis, this designator takes precedence over the retirement authority code | ||||||
| DMDC/Payroll-Retired | 1 | DMDC/Payroll-Retired | 16 | DOD_DISB | Yes | 09/10/10 | character(3) | DoD Disability Rating Percent Quantity | The member's degree of disability at retirement as determined by DoD, expressed as a percent. | Valid values are 010, 020, 030, 040, 050, 060, 070, 075, 080, 090, 099 and 100. If unknown or not applicable all zeros are reported. | no issues | ||||||
| DMDC/Payroll-Retired | 1 | DMDC/Payroll-Retired | 17 | CMBTFLAG | Yes | 09/10/10 | character(1) | DoD Combat Related Disability Indicator Code | The code that represents whether the retiree has a DoD related disability that has been designated by DoD as combat related. This code applies to only those retirees who were on active duty from Sep 24, 1978. | N=No Y=Yes Z=Unknown or Not Applicable |
no issues | ||||||
| DMDC/Payroll-Retired | 1 | DMDC/Payroll-Retired | 27 | TERA_FLG | Yes | 09/10/10 | character(1) | TERA Program Code | The code that represents whether the member's retirement was authorized under the temporary early retirement provisions of Public Law 102-484 (1992). | 0=Unknown or not applicable 1=retired from Active Duty with 15-19 years for percentage 2=retired from Active Duty with 20 or more years for percent 3=retired from Reserve Service 4=age 62 recomputation for Public Service |
Does this overlap with #15? - no this refers to the TERA program only | ||||||
| DMDC/Payroll-Retired | 1 | DMDC/Payroll-Retired | 33 | CPS | Yes | 09/10/10 | character(1) | Military Retired Pay Payment Status Code | The code that represents the status of the member to be paid military retired pay. | 1=receiving pay 2=eligible but not receiving 3=eligible but not receiving, direct remittance for SBP 4=pay terminated 5=pay suspended |
no issues | ||||||
| DMDC/Payroll-Retired | 1 | DMDC/Payroll-Retired | 34 | RETSTP | Yes | 09/10/10 | character(1) | Military Retired Pay Payment Stop Reason Code | The code that represents the reason paygrade was terminated | A=Member died B=recalled to active duty C=removed from TDRL & returned to active duty D=removed from TDRL & returned to civilian status E=TDRL payE suspended for failure to report for physical F=waiver in favor of civil service retired pay G=waiver in favor of VA award H=dual comp/pay cap offset J=pay refused K=pay suspended, whereabouts unknown L=pay suspended, suspected death M=pay suspended, miscellaneous reasons Z=Not applicable |
no issues | ||||||
| DMDC/Payroll-Retired | 1 | DMDC/Payroll-Retired | 35 | STOP_PAY_DT | Yes | 09/10/10 | date(8) | Military Retired Pay Payment Stop Calendar Date | The date of suspension or termination of military retired pay. | no issues | |||||||
| DMDC/Payroll-Retired | 1 | DMDC/Payroll-Retired | 36 | DOD_DT | Yes | 09/10/10 | date(8) | Member Death Calendar Date | The date when the person died (if applicable). | no issues | |||||||
| DMDC/Payroll-Retired | 1 | DMDC/Payroll-Retired | 40 | VACLMNB | DI | Yes | 09/10/10 | character(9) | VA Claim Number Identifier | The identifier assigned by the Department of Veterans Affairs. | In case we get the opportunity to link with VA records. | ||||||
| DMDC/Payroll-Retired | 1 | DMDC/Payroll-Retired | 41 | VA_CHGDOL_DT | Yes | 09/10/10 | date(8) | Veterans Disability Compensation Award Effective Calendar Date | The date the monthly amount of the member's award of veterans disability compensation was effective | for those members with a VA identifier, this element appears well-populated | |||||||
| DMDC/Payroll-Retired | 1 | DMDC/Payroll-Retired | 53 | LGL_ST | Yes | 09/10/10 | character(2) | Legal Residence US Alpha State Code | The alphabetic code that represents a principal division or outlying or associated area of the US. | List of Values Located in Appendix C : US State Code DS A Vrsn 2 | this is the state to which the member has designated his state tax should be withheld. Withholding from Ret pay is voluntary, so this is not always populated. Member could pay taxes without withholding | ||||||
| DMDC/Payroll-Retired | 1 | DMDC/Payroll-Retired | 79 | CHLDNCP | Yes | 09/10/10 | character(1) | SBP/RCSBP Incapacitated Child Exception Code | The Code that indicates if the retiree's coverage includes an incapacitated child. | 0=No incapacitated children 1=Youngest child is incapacitated 2=Non-youngest child is incapacitated 3=Both youngest and non-youngest children are incapacitated 4=RCSPB child is still eligible 5=RCSPB child is no longer eligible |
most are '0', but there is data under all domain values | ||||||
| DMDC/Payroll-Retired | 1 | DMDC/Payroll-Retired | 101 | STATE | Yes | 09/10/10 | character(2) | State Alpha Code | The text of a line of the detailed portion of a mailing address. | List of Values Located in Appendix E : US State Code DS A Vrsn 1 | Could compare with state of legal residence. | ||||||
| DMDC/Payroll-Retired | 1 | DMDC/Payroll-Retired | 102 | ZIP9 | Yes | 09/10/10 | character(9) | ZIP Code | The text of a line of the detailed portion of a mailing address. | ||||||||
| DMDC/Payroll-Retired | 1 | DMDC/Payroll-Retired | 103 | CTRY | Yes | 09/10/10 | character(2) | Country Code | The text of a line of the detailed portion of a mailing address. | List of Values Located in Appendix F : Country Code DS A Vrsn 1 | |||||||
| DMDC/Payroll-Retired | 1 | DMDC/Payroll-Retired | 112 | DISBRATG | Yes | 09/10/10 | number(3) | VA Disability Rating (total) | Disability percentage assigned by the Veteran's Administration for CRDP or CRSC participants | well populated for members with a VA ID | |||||||
| DMDC/Payroll-Retired | 1 | DMDC/Payroll-Retired | 113 | VAEMPL | Yes | 09/10/10 | number(1) | VA Employability Indicator | This is the DVA employability code and represents the member's employability code as assigned by the DVA. It will be used to determine a member's eligibility for CRDP and the CRDP pay amount. | 0=Unknown 1=Employable 2=Unemployable |
well populated for members with a VA ID | ||||||
| DMDC/Payroll-Retired | 1 | DMDC/Payroll-Retired | 114 | CRDP_ID | Yes | 09/10/10 | character(1) | CRDP CRSC Indicator | Indicates a member's eligibility for CRDP or CRSC. Not while some members might be Definition eligible for both CRDP and CRSC, they may receive only one of these. P=CRDP, C=CRSC | C = CRSC, P = CRDP, Any Other Value = Not Enrolled in any Program | CRDP=Concurrent Retirement and Disability Pay CRSC=Combat-Related Special Compensation |
||||||
| DMDC/Payroll-Retired | 1 | DMDC/Payroll-Retired | 115 | CRDPSC_DT | Yes | 09/10/10 | date(8) | CRDP or CRSC Start Date | Effective date for eligibility for the applied CRDP or CRSC indicator YYYYMMDD | ||||||||
| DMDC/Payroll-Retired | 1 | DMDC/Payroll-Retired | 119 | CRSCRATE | Yes | 09/10/10 | number(3) | CRSC Rating From VA | The Disability rating that has been approved for CRSC payment. May or may not match the DVA rating. For example, if a member has four disabilities that the DVA is paying for and they have a combined rating of 60%, and only two of those are CRSC approved with a combined rating of 20%, then this position will contain the 20%. | well populated for members with a VA ID | |||||||
| DMDC/Payroll-Retired | 1 | DMDC/Payroll-Retired | 123 | RETGRP | Yes | 09/10/10 | character(1) | Retirement Group | 1=Active Duty service 2=Disability 3=Reserve (title III) |
this is a derived field based on the FAN code. | |||||||
| DMDC/Payroll-Retired | 1 | DMDC/Payroll-Retired | 130 | COUNTY | Yes | 09/10/10 | character(25) | USPS County Name | A derived field based on the member's address that indicates the county of residence | ||||||||
| DMDC/Payroll-Retired | 1 | DMDC/Payroll-Retired | 131 | FIPS_STATE | Yes | 09/10/10 | character(2) | USPS FIPS State Code | A derived field based on the member's address that indicates the state of residence | ||||||||
| DMDC/Payroll-Retired | 1 | DMDC/Payroll-Retired | 132 | FIPS_CNTY | Yes | 09/10/10 | number(3) | USPS FIPS County Code | A derived field based on the member's address that indicates the county of residence | FIPS=Federal Information Processing Standard | |||||||
| DMDC/Payroll-Retired | 1 | DMDC/Payroll-Retired | 133 | FILE_PDT | Yes | 01/06/11 | date(6) | File Date | Date of the file the information in the record was pulled from. | ||||||||
| Will not be sent by DMDC due to wording of ABHIDE SORN. |
| Appendix C - US State 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 |
| Appendix D - Uniformed Service Rank Code DS B Vrsn 1 | |
| Value | Description |
| 1 | Admiral |
| 2 | Airman |
| 3 | Airman Basic |
| 4 | Airman First Class |
| 5 | Brigadier General |
| 6 | Captain |
| 7 | Chief Master Sergeant |
| 8 | Chief Master Sergeant of the Air Force |
| 9 | Chief Petty Officer |
| 10 | Chief Warrant Officer Five |
| 11 | Chief Warrant Officer Four |
| 12 | Chief Warrant Officer Three |
| 13 | Chief Warrant Officer Two |
| 14 | Colonel |
| 15 | Command Sergeant Major |
| 16 | Commader |
| 17 | Corporal |
| 18 | Ensign |
| 19 | First Lieutenant |
| 20 | First Sergeant |
| 21 | Fleet Admiral |
| 22 | General |
| 23 | General of the Air Force |
| 24 | General of the Army |
| 25 | Gunnery Sergeant |
| 66 | Cadet |
| 69 | Airman Apprentice |
| 70 | Airman Recruit |
| 71 | Fireman |
| 72 | Fireman Apprentice |
| 73 | Fireman Recruit |
| 74 | Aviation Cadet |
| 75 | Aircraftsman |
| 76 | Air Chief Marshal |
| 77 | Air Commodore |
| 78 | Air Marshal |
| 79 | Air Vice Marshal |
| 80 | Colour Sergeant |
| 81 | Flight Lieutenant |
| 82 | Flight Sergeant |
| 83 | Flying Officer |
| 84 | Group Captain |
| Appendix E - US State Code DS A Vrsn 1 | |
| 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 |
| WW | Foreign countries |
| WY | Wyoming |
| ZZ | Unknown or not applicable |
| Appendix F - Country Code DS A Vrsn 1 | |
| 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 |
| BZ | Germany, Berlin |
| 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 |
| CL | Central and Southern Line 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 |
| CZ | Czechoslovakia |
| DA | Denmark |
| DJ | Djibouti |
| DM | Benin |
| DO | Dominica |
| DQ | Jarvis Island |
| 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) |
| FM | Federated States of Micronesia |
| FO | Faroe Islands |
| FP | French Polynesia |
| FQ | Baker Island |
| FR | France |
| FS | French Southern and Antarctic Lands |
| FT | French Territory of the Afars and Issas |
| 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 |
| GQ | Guam |
| GR | Greece |
| GS | Gilbert Islands |
| 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 |
| 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 |
| JQ | Johnston Atoll |
| JS | Svalbard and Jan Mayen |
| 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 |
| ME | Spanish North Africa |
| 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 |
| NA | Netherlands Antilles |
| NC | New Caledonia |
| NE | Niue |
| NF | Norfolk Island |
| NG | Niger |
| NH | Vanuatu |
| NI | Nigeria |
| NL | Netherlands |
| NO | Norway |
| NP | Nepal |
| NQ | Trust Territory of the Pacific Islands |
| 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 |
| PS | Palau |
| PT | Portuguese Timor |
| 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 |
| 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 | Svalbard |
| SW | Sweden |
| SX | South Georgia and the South Sandwich Islands |
| 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 Islands |
| TS | Tunisia |
| TU | Turkey |
| TV | Tuvalu |
| TW | Taiwan |
| TX | Turkmenistan |
| TZ | Tanzania |
| UG | Uganda |
| UK | United Kingdom |
| UP | Ukraine |
| UR | Union of Soviet Socialist Republics |
| US | United States |
| UV | Burkina Faso |
| UY | Uruguay |
| UZ | Uzbekistan |
| VC | St. Vincent and the Grenadines |
| VE | Venezuela |
| VI | British Virgin Islands |
| VM | Vietnam |
| VN | Viet-nam, North |
| VQ | Virgin Islands |
| VS | Vietnam, Republic of |
| VT | Vatican City |
| WA | Namibia |
| WB | Germany, Berlin |
| WE | West Bank |
| WF | Wallis and Futuna |
| WI | Western Sahara |
| WQ | Wake Island |
| WS | Samoa |
| WZ | Swaziland |
| YE | Yemen (Sanaa) |
| YM | Yemen |
| YO | Yugoslavia |
| YQ | Ryukyu Islands |
| YS | Yemen (Aden) |
| ZA | Zambia |
| ZI | Zimbabwe |
| sample | FieldName | FieldName | PII/HIPAA Sensitive | USAPHC (Prov) Approval |
| SVC | SVC | EDT_MR_SVC | Yes | |
| SCRSSN | SCRSSN | EDT_MR_SSN | DI | Yes |
| SCRPSSN | SCRPSSN | EDT_MR_PRIORSSN | DI | Yes |
| LNAME | LNAME | EDT_MR_LNAME | YES | Yes |
| FNAME | FNAME | EDT_MR_FNAME | YES | Yes |
| DOB_DT | DOB_DT | EDT_MR_DOT_DT | Yes | |
| SEX | SEX | EDT_MR_SEX | Yes | |
| INL_ENT_DT | INL_ENT_DT | EDT_MR_INL_ENT_DT | Yes | |
| ENT_EFF_DT | ENT_EFF_DT | EDT_MR_ENT_EFF_DT | Yes | |
| ORG_RET_DT | ORG_RET_DT | EDT_MR_ORG_RET_DT | Yes | |
| CATCODE | CATCODE | EDT_MR_CATCODE | Yes | |
| AUTH_CD | AUTH_CD | EDT_MR_AUTH_CD | Yes | |
| FANCODE | FANCODE | EDT_MR_FANCODE | Yes | |
| DOD_DISB | DOD_DISB | EDT_MR_DOD_DISB | Yes | |
| CMBTFLAG | CMBTFLAG | EDT_MR_CMBTFLAG | Yes | |
| TERA_FLG | TERA_FLG | EDT_MR_TERA_FLG | Yes | |
| CPS | CPS | EDT_MR_CPS | Yes | |
| RETSTP | RETSTP | EDT_MR_RETSTP | Yes | |
| STOP_PAY_DT | STOP_PAY_DT | EDT_MR_STOP_PAY_DT | Yes | |
| DOD_DT | DOD_DT | EDT_MR_DOD_DT | Yes | |
| VACLMNB | VACLMNB | EDT_MR_VACLMNB | DI | Yes |
| VA_CHGDOL_DT | VA_CHGDOL_DT | EDT_MR_VA_CHGDOL_DT | Yes | |
| LGL_ST | LGL_ST | EDT_MR_LGL_ST | Yes | |
| CHLDNCP | CHLDNCP | EDT_MR_CHLDNCP | Yes | |
| STATE | STATE | EDT_MR_STATE | Yes | |
| ZIP9 | ZIP9 | EDT_MR_ZIP9 | Yes | |
| CTRY | CTRY | EDT_MR_CTRY | Yes | |
| DISBRATG | DISBRATG | EDT_MR_DISBRATG | Yes | |
| VAEMPL | VAEMPL | EDT_MR_VAEMPL | Yes | |
| CRDP_ID | CRDP_ID | EDT_MR_CRDP_ID | Yes | |
| CRDPSC_DT | CRDPSC_DT | EDT_MR_CRDPPSC_DT | Yes | |
| CRSCRATE | CRSCRATE | EDT_MR_CRSCRATE | Yes | |
| RETGRP | RETGRP | EDT_MR_RETGRP | Yes | |
| COUNTY | COUNTY | EDT_MR_COUNTY | Yes | |
| FIPS_STATE | FIPS_STATE | EDT_MR_FIPS_STATE | Yes | |
| FIPS_CNTY | FIPS_CNTY | EDT_MR_FIPS_CNTY | Yes | |
| FILE_PDT | FILE_PDT | File_Date | Yes |
| File Type | application/vnd.openxmlformats-officedocument.spreadsheetml.sheet |
| File Modified | 0000-00-00 |
| File Created | 0000-00-00 |