| This tab, 1.Cover Letter, describes the information in the other tab of this document. | ||
| Tab | Description | |
| 2.DMDC_Payroll_Enl-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. |
| S | STARRS Category | Army STARRS justification of how data element plays a critical role in anticipated future research. This will appear in the Special Project Attachment (SPA) to the Memoradium of Understanding (MOU) between the Defense Manpower Data Center (DMDC) and Army STARRS. |
| Source | Source Tab Ord | SourceTable | Source Field Ord | FieldName | PII/HIPAA Sensitive | USAPHC Approval | USAPHC SP2Delta | FieldType | Nullability | Primary Key | Title | Desc | Values | Notes | FDM Comments | ADS Comment | Code Table Reference | STARRS Category |
| DMDC/Payroll | 1 | DMDC/Payroll-ActiveDuty | 1 | MIL_SVC | Yes | 11/15/10 | character(1) | Military Service | 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 Z= Unknown |
Versions of this format prior to June 2001 have a P for Coast Guard. | FileStartEndPos(1-1) | ||||||
| DMDC/Payroll | 1 | DMDC/Payroll-ActiveDuty | 2 | NM_TX | Yes | Yes | 11/15/10 | character(27) | Name, Individual | The servicemember's name in the format Last, First, Middle initial. | No Values Associated With This Item | Free Text | FileStartEndPos(2-28) | |||||
| DMDC/Payroll | 1 | DMDC/Payroll-ActiveDuty | 3 | SSN_ID | DI | Yes | 11/15/10 | Character(9) | Social Security | The identifier assigned by the Social Security Administration to a person. | No Values Associated With This Item | FileStartEndPos(29-37) | ||||||
| DMDC/Payroll | 1 | DMDC/Payroll-ActiveDuty | 4 | SEX_CD | Yes | 11/15/10 | Char(1) | Sex | The code that represents a classification of a person based on reproductive function. | F=Female, M=Male, Z=Unknown | FileStartEndPos(38-38) | |||||||
| DMDC/Payroll | 1 | DMDC/Payroll-ActiveDuty | 8 | PAY_GRD_USVC_CD | DI | Yes | 11/15/10 | character(3) | Pay Grade, Uniformed Services | The code that represents the level of pay or enumerates a member's status in a pay hierarchy and consists of both a flag denoting officer/enlisted status as well as rank order within that status. | List of Values Located in Appendix A : Pay Plan Grade Code DS D Vrsn 1 | FileStartEndPos(57-59) | ||||||
| DMDC/Payroll | 1 | DMDC/Payroll-ActiveDuty | 12 | PEND_SEP_DT | Yes | 11/15/10 | date(6) | Projected Separation Date | The date that a military member is projected to leave active service. | YYMMDD | FileStartEndPos(73-78) | |||||||
| DMDC/Payroll | 1 | DMDC/Payroll-ActiveDuty | 17 | MIL_UNIT_DSGR | DI | Yes | 11/15/10 | character(8) | Military Unit Designator | Also known as the Unit Identification Code or UIC. A code designed specifically for encoding the designation or identification of units within a military organization. |
No Values Associated With This Item | To crosswalk to personnel Unit Identification Codes (UIC) use the following logic: Navy = N + positions 87 - 91 Army = W + positions 90 - 94 MC = M + positions 87-91 AF = F + positions 91-94 |
FileStartEndPos(87-94) | |||||
| DMDC/Payroll | 1 | DMDC/Payroll-ActiveDuty | 18 | GEO_LOC_CD | Yes | 11/15/10 | character(5) | Geographic Location Code | The code that represents a designated place of military interest. | No Values Associated With This Item | The duty location of a servicemember. Composed of a two-position state code and a three position county code or a two-position country code and three blanks. ZZZZZ - Unknown | FileStartEndPos(95-99) | ||||||
| DMDC/Payroll | 1 | DMDC/Payroll-ActiveDuty | 19 | US_ZIP_CD | Yes | 11/15/10 | number(9) | ZIP Code or APO/FPO Number | This is the duty location ZIP Code. | No Values Associated With This Item | ZIP Code of a members duty location. If only five positions of ZIP Code are available, left justify with trailing blanks. | FileStartEndPos(100-108) | ||||||
| DMDC/Payroll | 1 | DMDC/Payroll-ActiveDuty | 22 | CMBT_ZONE_INDC_CD | Yes | 11/15/10 | number(1) | Combat Zone Tax Exclusion Indicator Code | The code that denotes whether the member is entitled to Combat Zone Tax Exclusion. | 0= Not Entitled 1= Entitled 9= Unknown or not applicable |
Combat Zone Tax Exclusion - Where a member of the U.S. Armed Forces who serves in a combat zone , can exclude certain pay from their income. They do not have to receive the pay while in a combat zone, are hospitalized, or in the same year they have served | FileStartEndPos(113-113) | ||||||
| DMDC/Payroll | 1 | DMDC/Payroll-ActiveDuty | 23 | CMBT_ZONE_INDC_CTRY_CD | Yes | 11/15/10 | character(2) | Combat Zone Tax Exclusion Country Code | The code that denotes the Country which entitles a member to Combat Zone Tax Exclusion (CZTE). | List of Values Located in Appendix C: Country Code DS A (current subset) Vrsn | A combat zone is any area the President of the United States designates by Executive Order as an area in which the U.S. Armed Forces are engaging or have engaged in combat. This data element pertains ony if the CZTE indicator in position 113 equals 1 (entitled to CZTE). Beginning in the April File the Marine Corps began showing numeric state codes for Combat Zone Country Code. They are working to correct this problem. | FileStartEndPos(114-115) | ||||||
| DMDC/Payroll | 1 | DMDC/Payroll-ActiveDuty | 26 | FOR_DTY_PAY | Yes | 11/15/10 | pckd dec(2) | Hardship Duty Pay | Formerly Foreign Duty Pay. An amount payable to servicemembers stationed in certain areas outside CONUS where the location is determined to have difficult living conditions. | DFAS only reports Foreign Duty Pay, cannot change program to report Hardship. Foreign Duty very small number of people. A monthly amount, shown in dollars. Default values are negative nines. (-9) | FileStartEndPos(119-120) | |||||||
| DMDC/Payroll | 1 | DMDC/Payroll-ActiveDuty | 29 | PFNC_PAY | Yes | 11/15/10 | pckd dec(3) | Proficiency Pay | Paid to enlisted members who are proficient in a designated military skill. Proficiency pay status is awarded according to the applicable regulations of each Service. | A monthly amount, shown in dollars. Default values are negative nines. | FileStartEndPos(121-123) | |||||||
| DMDC/Payroll | 1 | DMDC/Payroll-ActiveDuty | 30 | PFNC_PAY_TYP | Yes | 11/15/10 | num(1) | Proficiency Type Pay | A code that designates the type of Proficiency Pay that a member is receiving. | 1=Shortage Specialty, 2=Special Duty Assignment (e.g., Recruiters, Drill Sergeants, Security Guards) | FileStartEndPos(124-124) | |||||||
| DMDC/Payroll | 1 | DMDC/Payroll-ActiveDuty | 32 | OSEA_EXT_PAY | Yes | 11/15/10 | pckd dec(2) | Overseas Extension Pay | An incentive pay offered to enlisted members with specific skills and/or on specific overseas assignments to extend the period of the overseas assignment. Entitlement determined by service regulations and requirements. | A monthly amount, shown in dollars. May be an Overseas Extension Bonus paid in a lump sum. Default values are negative nines. (-9) | FileStartEndPos(125-126) | |||||||
| DMDC/Payroll | 1 | DMDC/Payroll-ActiveDuty | 72 | FIRE_PAY | Yes | 11/15/10 | pckd decimal(2) | Imminent Danger Pay | A pay given to servicemember's on duty in foreign areas who, because of their role and visibility as a uniformed member, are subject to the threat of physical harm or imminent danger because of civil insurrection, civil war, terrorism, or wartime conditio | No Values Associated With This Item | Formerly Hostile Fire Pay. Also known as Imminent Danger/Hostile Fire Pay. This pay is not prorated. The member is paid the full monthly amount even if they serve for only one day of the month. Shown in dollars. Default value is negative nines. (-9) | FileStartEndPos(228-229) | ||||||
| DMDC/Payroll | 1 | DMDC/Payroll-ActiveDuty | 73 | DIV_DTY_PAY | Yes | 11/15/10 | pckd decimal(3) | Diving Duty Pay | A special pay authorized for members assigned to diving duty. | No Values Associated With This Item | A servicemember is authorized this pay if they are: assigned by orders to diving duty; required to maintain proficiency as a diver by frequent and regular dives; and are actually performing diving duty. A monthly amount shown in dollars. Default value is | FileStartEndPos(230-232) | ||||||
| DMDC/Payroll | 1 | DMDC/Payroll-ActiveDuty | 75 | HAZ_DTY_INCN_PAY_ID | Yes | 11/15/10 | Char(1) | Hazardous Duty Incentive Pay I Identifier | This code represents the specific type of hazardous duty pay that a member is receiving. | See pckHaz tab | A servicemember may receive several different types of hazardous duty pay. This code is used to distinguish between the different types. | FileStartEndPos(236-236) | ||||||
| DMDC/Payroll | 1 | DMDC/Payroll-ActiveDuty | 77 | HZD_DTY_PAY_CD | Yes | 11/15/10 | Char(1) | Hazardous Duty Incentive Pay II Identifier | This code represents the specific type of hazardous duty pay that a member is receiving. | See pckHaz tab | A servicemember may receive several different types of hazardous duty pay. This code is used to distinguish between the different types. | FileStartEndPos(240-240) | ||||||
| DMDC/Payroll | 1 | DMDC/Payroll-ActiveDuty | 79 | HZD_DTY_PAY_CD_III | Yes | 11/15/10 | Char(1) | Hazardous Duty Incentive Pay III Identifier | This code represents the specific type of hazardous duty pay that a member is receiving. | See pckHaz tab | A servicemember may receive several different types of hazardous duty pay. This code is used to distinguish between the different types. | FileStartEndPos(244-244) | ||||||
| DMDC/Payroll | 1 | DMDC/Payroll-ActiveDuty | 83 | BAQ_PMT_STAT | Yes | 11/15/10 | number(1) | BAQ Payment Status | The status code that specifies what type of Basic Allowance for Quarters (BAQ) the servicemember is currently receiving. | 1= Receiving BAQ with dependents 2= Receiving BAQ without dependents 3= Receiving Partial BAQ 4= Receiving BAQ with dependents living in inadequate Government Quarters 5= Not receiving BAQ living in adequate quarters |
Values 6,7,9 unavailable. Since the implementation of Basic Allowance for Housing (BAH), this field is less reliable. | FileStartEndPos(262-262) | ||||||
| DMDC/Payroll | 1 | DMDC/Payroll-ActiveDuty | 85 | FSA_TYP_1 | Yes | 11/15/10 | pckd decimal(3) | Family Separation Allowance Type I | Family Separation Housing (formerly FSA Type I) is paid to a member for added housing expenses resulting from enforced separation from dependents. It is payable in a monthly amount equal to Basic Allowance for Housing (BAH) payable to a member without dep | No Values Associated With This Item | A monthly amount, shown in dollars. Default value is negative nines. (-99) | FileStartEndPos(266-268) | ||||||
| DMDC/Payroll | 1 | DMDC/Payroll-ActiveDuty | 86 | FSA_TYP_2 | Yes | 11/15/10 | pckd dec(2) | Family Separation Allowance Type 2 | Also known as FSA II. An allowance paid to personnel who are separated from their families for 30 days or more. | No Values Associated With This Item | Intended to pay for incidental expenses incurred as the result of being away from the family unit. It is a monthly amount, shown in dollars. Default value is negative nines. (-9) | FileStartEndPos(269-270) | ||||||
| DMDC/Payroll | 1 | DMDC/Payroll-ActiveDuty | 89 | OSEA_ALLOW_BAS_ID_1 | Yes | 11/15/10 | Num(1) | Overseas Allowance Basis Identifier I | A code that indicates the servicemembers accompanied status when receiving Cost of Living Allowance (COLA), Overseas Cost of Living Allowance (OCOLA) or Overseas Housing Allowance (OHA). | Report applicable code if member is eligible for either overseas COLA or OHA. 1 = with dependents 2 = without dependents |
FileStartEndPos(277-277) | |||||||
| DMDC/Payroll | 1 | DMDC/Payroll-ActiveDuty | 106 | OSEA_ALLOW_BAS_ID_2 | Yes | 11/15/10 | num(1) | Overseas Allowance Basis Identifier II | A code that indicates the servicemember's accompanied status when receiving Cost of Living Allowance (COLA), Overseas Cost of Living Allowance (OCOLA) or Overseas Housing Allowance (OHA). | Report second applicable code if member is entitled to two overseas COLA and OHA's. 1 = With dependents 2 = Without dependents |
FileStartEndPos(310-310) | |||||||
| DMDC/Payroll | 1 | DMDC/Payroll-ActiveDuty | 126 | VHA_BAS_ID_1 | Yes | 11/15/10 | Num(1) | Variable Housing Allowance Basis Identifier I | Also known as Basic Allowance for Housing (BAH). A code that identifies the type of Variable Housing Allowance (VHA) that a member is receiving. | 1- Duty location, with dependents 2- Duty location, without dependents 3-Residence location, with dependents 4-Residence location, without dependents |
Duty location or residence location with or without dependents. | FileStartEndPos(353-353) | ||||||
| DMDC/Payroll | 1 | DMDC/Payroll-ActiveDuty | 127 | VHA_ZIP_CD_1 | Yes | 11/15/10 | number(5) | Variable Housing Allowance ZIP Code I | The identifier that represents a designated mail service region under the authority of the US Postal Service. | No Values Associated With This Item | The ZIP Code of the location where a servicemember is living, for purposes of determining the VHA. Report the "with dependents" location. | FileStartEndPos(357-361) | ||||||
| DMDC/Payroll | 1 | DMDC/Payroll-ActiveDuty | 128 | VHA_BAS_ID_2 | Yes | 11/15/10 | number(1) | Variable Housing Allowance Basis Identifier II | A code that identifies the type of Variable Housing Allowance (VHA) that a member is receiving. |
1= Duty location, with dependents 2= Duty location, without dependents 3= Residence location, with dependents 4= Residence location, without dependents |
Duty location or residence location with or without dependents. | FileStartEndPos(362-362) | ||||||
| DMDC/Payroll | 1 | DMDC/Payroll-ActiveDuty | 130 | VHA_ZIP_CD_2 | Yes | 11/15/10 | number(5) | Variable Housing Allowance ZIP Code II | The identifier that represents a designated mail service region under the authority of the US Postal Service. | No Values Associated With This Item | The ZIP Code of the location where a servicemember is living, for purposes of determining the Variable Housing Allowance (VHA). Report the "with dependents" location. | FileStartEndPos(366-370) | ||||||
| DMDC/Payroll | 1 | DMDC/Payroll-ActiveDuty | 140 | AM_SGLI_CVG_ELCT | Yes | 11/15/10 | pckd decimal(3) | Amount of SGLI Coverage Elected | The amount of Serviceman's Group Life Insurance (SGLI) coverage that a servicemember has elected to have. | No Values Associated With This Item | A numeric amount, shown in dollars. Rounded to the nearest $1000. The SGLI (Servicemember? Group Life Insurance) program allowed maximum coverage to grow from $250,000 to $400,000. New elections are available for coverage in the amounts of $300,000 or $35 | FileStartEndPos(409-411) | ||||||
| DMDC/Payroll | 1 | DMDC/Payroll-ActiveDuty | 149 | SEP_PGM_DSGR | Yes | 11/15/10 | Char(3) | Separation Program Designator Position Start 447 | Also known as the SPD code. The code which defines the circumstances under which a member ended a period of active service. | No Values Associated With This Item | The code is used to determine the members elegibility for certain services after they have separated from the armed forces. | FileStartEndPos(447-449) | ||||||
| DMDC/Payroll | 1 | DMDC/Payroll-ActiveDuty | 152 | SEP_PMT_ID | Yes | 11/15/10 | Num(1) | Separation Payment Identifier Code | The code that represents the type of separation status. | 1= Separation Pay 2= Readjustment Pay 3= Severance Pay 4= Disability Severance Pay 5= Discharge Gratuity 6= Death Gratuity |
This code represents the type of separation payment that the servicemember has received. | FileStartEndPos(456-456) | ||||||
| DMDC/Payroll | 1 | DMDC/Payroll-ActiveDuty | 154 | PRIOR_SSN | DI | Yes | 11/15/10 | Num(9) | Prior Social Security Number | The servicemember's prior social security number, if one exists. | No Values Associated With This Item | Applicable only if the member's social security number has changed during the reporting period. | FileStartEndPos(460-468) | |||||
| DMDC/Payroll | 1 | DMDC/Payroll-ActiveDuty | 157 | FIRST_LNG_ID | Yes | 11/15/10 | Char(2) | First Language Identitiy | An identifier that specifies the language that a servicemember is proficient in. | List of Values Located in Appendix F: Language Code DS A Vrsn 1 | FileStartEndPos(473-474) | |||||||
| DMDC/Payroll | 1 | DMDC/Payroll-ActiveDuty | 160 | SEC_LNG_ID | Yes | 11/15/10 | Char(2) | Second Language Identity | An identifier that specifies the language that a servicemember is proficient in. | List of Values Located in Appendix G: Language Code DS A Vrsn 2 | FileStartEndPos(481-482) | |||||||
| DMDC/Payroll | 1 | DMDC/Payroll-ActiveDuty | 178 | CMPNT | Yes | 11/15/10 | character(1) | Component | A code that specifies the component (Service) that a servicemember is in. | see pckComp | Marine Corps started submitting a component code in the 200206 data file. Files from 200205 and earlier were blank. DFAS-Denver (Army, Navy, Air Force) submits more codes than other Pay Centers. R- AGR (Activated Guard and Reserve) are included in the act |
FileStartEndPos(550-550) | ||||||
| DMDC/Payroll | 1 | DMDC/Payroll-ActiveDuty | 179 | File_Date | Yes | 12/21/10 | date(6) | File Date | Date of the file the information in the record was pulled from. |
| File Type | application/vnd.openxmlformats-officedocument.spreadsheetml.sheet |
| File Modified | 0000-00-00 |
| File Created | 0000-00-00 |