| This tab, 1.Cover Letter, describes the information in the other tab of this document. | ||
| Tab | Description | |
| 2.DMDC_Payroll_Reser-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 (Prov) Approval | USAPHC (Prov) SP2Delta | FieldType | Nullability | Primary Key | Title | Desc | Values | Notes | FDM Comments | ADS Comment | Code Table Reference | STARRS Category |
| DMDC/Payroll-Reserve | 1 | DMDC/Payroll-Reserve | 1 | VCMP | Yes | 7/22/10 | character(1) | Service | The branches of the Armed Forces of the United States established by Congress, in which persons are appointed, enlisted, or inducted for military service and that operates and is administered within a Military or Executive Department. | A = U.S. Army (USA) N = U.S. Navy (USN) M = U.S. Marine Corps (USMC) F = U.S. Air Force (USAF) C= U.S. Coast Guard (USCG) |
FileStartEndPos(1-1) | |||||||
| DMDC/Payroll-Reserve | 1 | DMDC/Payroll-Reserve | 2 | DPT_CMPNT | Yes | 7/22/10 | character(1) | Component | The code which represents an organizational categorization based on subdivisions recognized by the defense community. | G=Guard R=Regular T=Temporary V=Reserve Z=Unknown or Not Applicable |
FileStartEndPos(2-2) | |||||||
| DMDC/Payroll-Reserve | 1 | DMDC/Payroll-Reserve | 3 | SSN | DI | Yes | 7/22/10 | Character(9) | Social Security Number | The identifier assigned by the Social Security Administration to a person. | FileStartEndPos(3-11) | |||||||
| DMDC/Payroll-Reserve | 1 | DMDC/Payroll-Reserve | 4 | NM | Yes | Yes | 7/22/10 | character(27) | Name | The Service member's full legal name. | No Values Associated With This Item | FileStartEndPos(12-38) | ||||||
| DMDC/Payroll-Reserve | 1 | DMDC/Payroll-Reserve | 5 | PG_CD | DI | Yes | 7/22/10 | character(3) | Pay Grade | 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 3 Current grade consisting of personnel class and pay level serial numbers. E01 - E09 = Enlisted W01 - W05 = Warrant O01 - O09 = Officer An E88 = College First Students An 099 = ROTC 099 is ROTC. E88 is for an Army and Navy education program called College First Members who are participating receive a stipend of $150 per month for 2 years. |
FileStartEndPos(39-41) | ||||||
| DMDC/Payroll-Reserve | 1 | DMDC/Payroll-Reserve | 8 | PAY_ENT_BASE_DATE | No | date | Pay Entry Base Date | The constructed date that establishes the beginning of a member's creditable military service for longevity increases to basic pay and other items of military compensation. | If unknown, leave blank. (YYYYMMDD) | FileStartEndPos(51-58) | ||||||||
| DMDC/Payroll-Reserve | 1 | DMDC/Payroll-Reserve | 9 | OFF_SVC_DT | No | date | Officer Service Date | The date a member was first appointed an officer. | If unknown, leave blank. (YYYYMMDD) | FileStartEndPos(59-66) | ||||||||
| DMDC/Payroll-Reserve | 1 | DMDC/Payroll-Reserve | 19 | No | Unit Identification Code (UIC) | |||||||||||||
| DMDC/Payroll-Reserve | 1 | DMDC/Payroll-Reserve | 20 | AUTH_REG | No | zoned decimal | Authorized Regular Drills Current Fiscal | Total regular drills authorized for the current fiscal year. | FileStartEndPos(123-125) | |||||||||
| DMDC/Payroll-Reserve | 1 | DMDC/Payroll-Reserve | 21 | REPT_PTD | No | zoned decimal | Reported Paid Regular Drills Current Month | The total number of drills reported for the current month. | A member of a Reserve component is entitled to one-thirtieth of the monthly basic pay prescribed for grade and years service for the performance of each authorized period of regular inactive duty training (IDT) drill or unit training assembly (UTA). A member of a Reserve component is entitled to one-thirtieth of the monthly basic pay prescribed for grade and years of service for the performance of each authorized period of regular inactive duty training (IDT) drill or unit training assembly (UTA). |
FileStartEndPos(126-128) | ||||||||
| DMDC/Payroll-Reserve | 1 | DMDC/Payroll-Reserve | 22 | OTH_PTD_REG_CURR_MN | No | zoned decimal | All Other Paid Reported Drills Current Month | All drills other than regular drills for which member was paid. | FileStartEndPos(129-131) | |||||||||
| DMDC/Payroll-Reserve | 1 | DMDC/Payroll-Reserve | 23 | REPT_CURR_MN | No | zoned decimal | Unpaid Drills Reported: Current Month | All unpaid drills reported for the current month. | FileStartEndPos(132-134) | |||||||||
| DMDC/Payroll-Reserve | 1 | DMDC/Payroll-Reserve | 25 | AD_TRN_DY_REPT_CURR_MN | No | zoned decimal | Active Duty For Training (ACDUTRA) Days Reported Current Month | Active Duty for Training (ADT), full time training duty (FTTD), annual training (AT), temporary active duty (TAD). | The term "active duty" (AD) includes ACDUTRA, AD for training (ADT), full time training duty (FTTD), annual training (AT), and attendance while in active service at a school designated as a Service school by law, or the Secretary concerned, temporary active duty (TAD), when the pay is chargeable to a Reserve appropriation, or in the case of the National Guard, FTTD, and other full time duty. It does not mean "extended" AD (EAD). | FileStartEndPos(140-142) | ||||||||
| DMDC/Payroll-Reserve | 1 | DMDC/Payroll-Reserve | 28 | BAQ_STAT | Yes | 7/22/10 | number(1) | Basic Allowance for Housing | The code that represents the payment status of Basic Allowance for Housing (Previously | 1=Receiving BAQ with dependents 2=Receiving BAQ without dependents 3=Receiving Partial BAQ 4=Receiving BAQ with dependents living in inadequate Gvt hsg 5=Not receiving BAQ living in adequate quarters 6=Not Applicable 7=Other 9=Unknown |
FileStartEndPos(151-151) | |||||||
| DMDC/Payroll-Reserve | 1 | DMDC/Payroll-Reserve | 34 | DIV_DTY_PAY | Yes | 7/22/10 | pckd decimal(5) | Diving Duty Pay | Additional pay to increase the ability of the Uniformed Services to attract and retain volunteers for diving duty, and to compensate for the more than normally dangerous character of such duty. | Valid Range of Values Low High Description 0 N/A 00001 25000 Valid values |
Armed Forces members are entitled to special pay for diving duty for periods during which they are: Assigned by orders to diving duty; Required to maintain proficiency as a diver by frequent and regular dives; and They are either actually performing diving duty while serving in an assignment for which diving is a primary duty; or meeting the requirements to maintain proficiency while serving in an assignment that includes diving duty other than as a primary duty. Military personnel are entitled to diving duty pay of $240 for officers and $340 for enlisted per month. In time of war, the President may suspend diving duty pay. Qualifications for Diving Duty Army Generally, an Army member must be a rated diver in accordance with AR 611-75 and be assigned to: A Table of Organization and Equipment or Table of Distribution and Allowance position in Skill Classification/Military Occupational Specialty, Special qualification Identifier, or Additional Skill Identifier specified in AR 611-75; or A position designated as diving duty by the Deputy Chief of Staff Personnel. 110202. |
FileStartEndPos(177-181) | ||||||
| DMDC/Payroll-Reserve | 1 | DMDC/Payroll-Reserve | 35 | DTY_PAY | Yes | 7/22/10 | pckd decimal(5) | Hardship Duty Pay | The additional compensation paid to service members during assignment in land areas outside the continental United States where living conditions are substantially below the standard compared to the continental United States. | Valid Range of Values Low High Description 0 N/A 00001 25000 Valid values |
Previously Foreign Duty Pay A token extra payment to either officer or enlisted personnel serving at specific locations outside the United States, both as a morale factor and in recognition of the rigors of service at such locations. HDP-L is compensation paid to members assigned outside the continental United States in Quality of Life (QoL) Hardship locations -- Locations where QoL living conditions are substantially below the standard most members in the continental United States would generally experience. HDP-L is intended to recognize the extraordinary arduous living conditions, excessive physical hardship, and/or unhealthful conditions that exist in a location or assignment. Rates are payable in increments of $50, $100, or $150 a month based on the level of QoL hardship in a given area. Specifics: All members serving on PCS in a designated area, or serving in a temporary duty or deployed status for over 30 consecutive days in the area will receive HDP-L Members on permanent reassignment to the area will be eligible from the day of arrival Members TDY to the area are not eligible during the first 30 days of consecutive service at the designated location. On the 31 st day, HDP-L will be payable retroactive to the date of reporting. Entitlement to HDP-L continues through the date of departure on PCS. Enter the total compensation for the month. The National Defense Authorization Act of Fiscal Year 2006 increases the maximum monthly rate from $300 to $750. |
FileStartEndPos(182-186) | ||||||
| DMDC/Payroll-Reserve | 1 | DMDC/Payroll-Reserve | 36 | FIRE_PAY | Yes | 7/22/10 | pckd decimal(5) | Hostile Fire Pay and/or Imminent Danger Pay Current Month | Additional pay during periods of nominal peace as a token of recognition to personnel serving in a designated hostile fire area, and to personnel of a vessel, aircraft, or unit that engages in hostile action outside a designated hostile fire area. | Valid Range of Values Low High Description 0 N/A 00001 25000 Valid values |
A member of a uniformed service may be entitled to Hostile Fire and Imminent Danger pay at the rate of $225 for any month in which he/she was entitled to basic pay and in which he/she was: Subject to hostile fire or explosion of hostile mines; On duty in an area in which he was in imminent danger of being exposed to hostile fire or explosion of hostile mines and in which, during the period he was on duty in that area, other members of the uniformed services were subject to hostile fire or explosion of hostile mines; Killed, injured, or wounded by hostile fire, explosion of a hostile mine, or any other hostile action; or On duty in a foreign area in which he was subject to the threat of physical harm or imminent danger on the basis of civil insurrection, civil war, terrorism, or wartime conditions. Reserve members are also eligible for Hostile Fire and Imminent Danger Pay. Enter the total amount for the month. |
FileStartEndPos(187-191) | ||||||
| DMDC/Payroll-Reserve | 1 | DMDC/Payroll-Reserve | 38 | FAM_SEP_ALLOW_CD | Yes | 7/22/10 | number(1) | Family Separation Allowance Code | The code used to identify the type of FSA to which a member is entitled. | Servicemembers with dependents may be entitled to a Family Separation Allowance (FSA) of $250 per month. This is in addition to any per diem or other entitlements. 0 = No FSA pay 1 = Type I - equal to w/o deps BAH for a service member's grade. It is intended to defray the cost of 2 residences 2 = Type II (Incidentals away from family ie. Laundry) 3 = Type I & II |
FileStartEndPos(197-197) | |||||||
| DMDC/Payroll-Reserve | 1 | DMDC/Payroll-Reserve | 41 | HAZ_DTY_ID_1 | Yes | 7/22/10 | character(1) | Hazardous Duty Incentive Pay I | This code represents the specific type of hazardous duty pay that a Service member is receiving. |
1=Operational Submarine Duty Pay 2=Continuous Submarine Duty Pay A=Flying Pay (crew member) B=Flying Pay (non-crew member) C=Air Weapons Controller Crew Member Pay D=Operational Submarine Duty Pay E=Continuous Submarine Duty Pay F=Parachute Duty Pay G=Flight Deck Duty Pay H=Demolition Duty Pay I=Experimental Stress Duty Pay J=Leprosarium Duty Pay K=Toxic Fuels (or Propellants) Duty Pay L=Dangerous Viruses (or Bacteria) Lab Duty Pay M=Toxic Pesticides Duty Pay N=HALO (High Altitude Low Opening) O=Chemical Munitions Duty Pay |
FileStartEndPos(208-208) | |||||||
| DMDC/Payroll-Reserve | 1 | DMDC/Payroll-Reserve | 43 | HAZ_DTY_INCN_PAY_2 | Yes | 7/22/10 | character(1) | Hazardous Duty Incentive Pay II | This code represents the specific type of hazardous duty pay that a Service member is receiving. |
1=Operational Submarine Duty Pay 2=Continuous Submarine Duty Pay A=Flying Pay (crew member) B=Flying Pay (non-crew member) C=Air Weapons Controller Crew Member Pay D=Operational Submarine Duty Pay E=Continuous Submarine Duty Pay F=Parachute Duty Pay G=Flight Deck Duty Pay H=Demolition Duty Pay I=Experimental Stress Duty Pay J=Leprosarium Duty Pay K=Toxic Fuels (or Propellants) Duty Pay L=Dangerous Viruses (or Bacteria) Lab Duty Pay M=Toxic Pesticides Duty Pay N=HALO (High Altitude Low Opening) O=Chemical Munitions Duty Pay |
FileStartEndPos(214-214) | |||||||
| DMDC/Payroll-Reserve | 1 | DMDC/Payroll-Reserve | 45 | HAZ_DTY_INCN_PAY_3 | Yes | 7/22/10 | character(1) | Hazardous Duty Incentive Pay III | This code represents the specific type of hazardous duty pay that a Service member is receiving. |
1=Operational Submarine Duty Pay 2=Continuous Submarine Duty Pay A=Flying Pay (crew member) B=Flying Pay (non-crew member) C=Air Weapons Controller Crew Member Pay D=Operational Submarine Duty Pay E=Continuous Submarine Duty Pay F=Parachute Duty Pay G=Flight Deck Duty Pay H=Demolition Duty Pay I=Experimental Stress Duty Pay J=Leprosarium Duty Pay K=Toxic Fuels (or Propellants) Duty Pay L=Dangerous Viruses (or Bacteria) Lab Duty Pay M=Toxic Pesticides Duty Pay N=HALO (High Altitude Low Opening) O=Chemical Munitions Duty Pay |
FileStartEndPos(220-220) | |||||||
| DMDC/Payroll-Reserve | 1 | DMDC/Payroll-Reserve | 47 | VCMP_INCN_PGM_TYP | Yes | 7/22/10 | character(1) | Reserve Component Incentive Program Type | The code which represents the type of bonus or stipend for any member of the Ready Reserve, who is appointed, enlists, reenlists, affiliates, or extends in a Reserve Component Incentive Program. | A = Enlistment bonus (3 year, prior service only). B = Enlistment bonus (6 year, prior service only). C = Enlistment bonus (6-year, non-prior Service only). D = Enlistment bonus (converted from educational assistance). E = Reenlistment bonus (3 year, Selected Reserve). F = Reenlistment bonus (6 year. Selected Reserve). G = Reenlistment bonus (3 year, Individual Ready Reserve (IRR)). H = Reenlistment bonus (6 year, IRR). J = Affiliation bonus (18 month, or less, left on Military Service obligation (MSO)). K = Affiliation bonus (18 months, or more, left on MSO). L = Stipend under Health Professionals Scholarship Program (HPSP). (Health Professionals, officers only). M = HPSP for Selected Reserve Service (Health Professionals Officers only). N = Eligibility suspended ? service member has been granted a period of authorized nonavailability (missionary) O = HPSP for Selected Reserve Service (Health Professionals Enlisted only). P =HPSP for IRR service (Health Professionals Enlisted only) Q=Bonus Test Program for Selected Reserve Health Care Professionals. R = Enlistment Bonus (3year prior service only) $3,000 cap. W=NA Z=Unknown. 1=Incentive Bonus for Transfer Between Armed Forces. 2=Special Pay Enlisted Members of the Selected Reserve Assigned to Certain High Priority Units. 3=Retention Bonus for Members in Qualified Critical Skills or High Priority Units. |
FileStartEndPos(226-226) | |||||||
| DMDC/Payroll-Reserve | 1 | DMDC/Payroll-Reserve | 49 | VCMP_INCN_PGM_EDC_TYP | No | character(1) | Reserve Component Incentive Program Education Type Code | The type of Reserve component educational incentive for any member of the Ready Reserve who is appointed, enlists, reenlist, affiliates, or extends in a Ready Reserve Program. (Does not include the "Montgomery GI Bill") | A = Educational assistance (other than the "Montgomery GI Bill") B = Educational assistance (converted from bonus). C = Educational loan repayment (enlisted only). D = Educational loan repayment (health professionals, officers only). W = Not applicable (not included in current DoDI) Z = Unknown (not included in current DoDI) |
FileStartEndPos(232-232) | ||||||||
| DMDC/Payroll-Reserve | 1 | DMDC/Payroll-Reserve | 53 | SGLI_IND | Yes | 7/22/10 | character(1) | SGLI Full-Time and/or Part-Time Indicator | This code indicates whether a servicemember has full - time SGLI coverage, part - time SGLI coverage, or no SGLI coverage. | F=Full Time N=No Coverage P=Part Time |
FileStartEndPos(249-249) | |||||||
| DMDC/Payroll-Reserve | 1 | DMDC/Payroll-Reserve | 54 | SGLI_CVG_CD | Yes | 7/22/10 | character(1) | Servicemen's Group Life Insurance Coverage Code (SGLI) | The code that identifies the amount of Servicemember's Group Life Insurance Coverage a service member has chosen. | 0=No coverage 1=$10,000 2=$20,000 3=$30,000 4=$40,000 5=$50,000 6=$60,000 7=$70,000 8=$80,000 9=$90,000 A=$100,000 B=$110,000 C=$120,000 D=$130,000 E=$140,000 F=$150,000 G=$160,000 H=$170,000 I=$180,000 J=$190,000 K=$200,000 L=$210,000 M=$220,000 N=$230,000 P=$240,000 Q=$250,000 R=$300,000 S=$350,000 T=$400,000 (All Other Services) U= $400,000 (Marine Corps Code) for the time frame of January 2006 through July 2007 |
SGLI is a VA program that provides low cost group life insurance to members of the Uniformed Services, including commissioned officers of the Public Health Service and the National Oceanic and Atmospheric Administration, cadets and midshipmen of the service academies. Members are automatically insured under Servicemember's Group Life Insurance (SGLI) for the maximum amount of $400,000 unless an election is filed reducing the insurance by $50,000 increments or canceling it entirely. The National Defense Authorization Act for Fiscal Year 2006 requires the Secretary of Defense to pay the premium for a minimum coverage of $150,000 while members who participate in the SGLI program are assigned to the OIF/OEF Operation Iraqi Freedom/Operation Enduring Freedom theater. Also authorizes the Secretary to pay for a larger amount of coverage. |
FileStartEndPos(248-248) | ||||||
| DMDC/Payroll-Reserve | 1 | DMDC/Payroll-Reserve | 55 | INCAP_PAY | Yes | 7/22/10 | pckd decimal(5) | Incapacitation Pay | The total amount a Service member was paid incapacitation pay for the current month. | Valid Range of Values Low High Description 0 N/A 00001 25000 Valid values |
Enter: (1). The amount of the first annual special separation payment for members who have completed at least 20 years of qualifying service (under 10 U.S.C. 1332 reference (f)) and have been transferred to the Retired Reserve, or (2). The amount of the lump sum payment for members who are involuntarily separated and have at least 6 years but less than 15 years of qualifying service (under Section 1332 of reference (f)). Calculation of amount is as follows: a. Special separation pay for members who have completed 20 years of qualifying service shall be paid annually for five years (except no payments are authorized after age 60). The annual amount is determined by multiplying by 12, the products of (1) the monthly basic pay (as of the date transferred to the Retired Reserves) the member would be entitled to if serving on active duty; and (2) a percentage equal to five percent plus one half of one percent for each full year of service calculated under 10 U.S.C. 1332 over twenty years, but not exceeding a maximum total of ten percent. b. Separation pay for the lump sum entitled member is calculated as 15% of the product of the member's years of service, calculated under 10 U.S.C. 1332, and an amount equal to 62 times of the daily equivalent of the monthly basic pay to which the member would be entitled if serving on active duty at the time of discharge or transfer. |
FileStartEndPos(250-254) | ||||||
| DMDC/Payroll-Reserve | 1 | DMDC/Payroll-Reserve | 57 | SEP_DT | Yes | 7/22/10 | date | Separation Date | The actual date of separation for a Service member from the Reserve component. | A date in the format YYYYMMDD. | FileStartEndPos(258-265) | |||||||
| DMDC/Payroll-Reserve | 1 | DMDC/Payroll-Reserve | 59 | SEP_PMT_IND | No | character(2) | Separation Pay Indicator | Code to identify special separation or separation payment. | SS = Special Separation Payment SP = Separation Payment |
FileStartEndPos(271-272) | ||||||||
| DMDC/Payroll-Reserve | 1 | DMDC/Payroll-Reserve | 61 | DT_XFER_RET_RSV | Yes | 7/22/10 | date | Date of Transfer to Retired Reserve or Date | The date the member was assigned to a Reserve Category in the Retired Reserve, or date of member's involuntary transfer from the Selected Reserve or discharge. | A date in the format YYYYMMDD. | FileStartEndPos(278-285) | |||||||
| DMDC/Payroll-Reserve | 1 | DMDC/Payroll-Reserve | 62 | DT_BRTH | No | date | Date of Birth | The date that a person was born. | A date in the format YYYYMMDD. | FileStartEndPos(286-293) | ||||||||
| DMDC/Payroll-Reserve | 1 | DMDC/Payroll-Reserve | 63 | File_Date | Yes | 12/21/10 | date | 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 |