| Column Definitions | ||
| Column | Name | Description |
| A | Source | Name of Data Source |
| B | TabOrd | 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 | FieldOrd | 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/HIPPA Sensitive | Please note YES or NO if the element is PII or HIPPA sensitive for de-identification |
| G | NIMH (or CHPPM) Approval | User has accepted this as a valid element for their use-drop down list-Yes or No |
| H | NIMH (or CHPPM) 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 | FDM Comments | Please add any comments that will help us understand the output extract. |
| O | ADS Comment | Please add any comments on authoritativeness |
| P | Code Table Reference | Reference to code table. |
| Source | Source Tab Ord | SourceTable | Source Field Ord | FieldName | PII/HIPAA Sensitive | USAPHC Approval | NIMH SP2Delta | FieldType | Nullability | Primary Key | Title | Desc | FDM Comments | ADS Comment | Code Table Reference |
| DAMIS | 1 | INDIVIDUAL | 1 | ind_sys_seq_nr | DI | Yes | 8/13/2009 | NUMBER(18) | Individual Information System Sequence Number | Primary Key Printed Out - Must be De-Identified | |||||
| DAMIS | 1 | INDIVIDUAL | 2 | da_indiv_id | DI | Yes | 8/13/2009 | VARCHAR2(9) | Individual Identifier | ||||||
| DAMIS | 2 | INTAKE_SCREEN | 1 | pir_seq_nr | DI | Yes | 8/13/2009 | NUMBER(18) | Unique patient intake/screening record number | Primary Key Printed Out - Must be De-Identified | |||||
| DAMIS | 2 | INTAKE_SCREEN | 2 | ind_sys_seq_nr | DI | Yes | 8/13/2009 | NUMBER(18) | Individual Information System Sequence Number | Primary Key Printed Out - Must be De-Identified | |||||
| DAMIS | 2 | INTAKE_SCREEN | 3 | da_enrl_dec_dt | No | Yes | 8/13/2009 | DATE | Drug-Alcohol Enrollment Decision Date | ||||||
| DAMIS | 2 | INTAKE_SCREEN | 4 | da_enrl_sac_cd | No | Yes | 8/13/2009 | VARCHAR2(4) | Drug-Alcohol Enrollment Decision Service Area Code | See Service Area Code Tab | |||||
| DAMIS | 2 | INTAKE_SCREEN | 5 | da_ptnt_sac_cd | No | Yes | 8/13/2009 | VARCHAR2(4) | Drug-Alcohol Patient Service Area Code | See Service Area Code Tab | |||||
| DAMIS | 2 | INTAKE_SCREEN | 7 | da_ind_elig_cd | No | Yes | 8/13/2009 | VARCHAR2(1) | Drug-Alcohol Individual Eligibility Code | A - ACTIVE DUTY B - ACT DUTY TNG C - CADT/MDSHPMN D - INAC DTY TNG E - RETIRED MIL F - FAM MBR-MIL G - US CIV EMPL H - LOCAL NATL I - FAM MBR-CIV J - FAM MBR RETD K - MINR FAM MBR P - FAM MBR DIPL T - FAM MBR CONT X - OTHER |
|||||
| DAMIS | 2 | INTAKE_SCREEN | 8 | case_fnd_mthd_cd | No | Yes | 8/13/2009 | VARCHAR2(2) | Case Finding Method Code. | AR – XX (20 Entries) Defines how Soldier was identified and referred to treatment. Codes are: AT – Applicant Accession Test (Urinalysis) CB – Cdr Directed Breathalyzer CD – Cdr/Supervisor Referral CI – Cdr Directed Individual (Urinalysis) CU – Cdr Directed Unit sweep (Urinalysis) DWI – DWI/DUI FM – Family Member referral IA – Investigation/Apprehension MA – Accident Mishap (urinalysis) MD – Medical Referral PD – Physician Directed (Urinalysis) SC – Security Clearance Check SR – Self Referral VT – Voluntary Test (Urinalysis) XX – Other Source |
|||||
| DAMIS | 2 | INTAKE_SCREEN | 14 | da_enrl_dec_cd | No | Yes | 8/13/2009 | VARCHAR2(1) | Drug-Alcohol Treatment Enrollment Decision Code. | A - ENROLL B - DO NOT ENROL C - NO ASSESSMNT |
|||||
| DAMIS | 2 | INTAKE_SCREEN | 15 | da_enrl_fac_cd | No | Yes | 8/13/2009 | VARCHAR2(1) | Drug-Alcohol Enrollment Facility Type Cod | A - ARMY CCC B - ADOL CSL SVC C - CIV NON-MIL |
|||||
| DAMIS | 2 | INTAKE_SCREEN | 16 | da_nenrl_rsn_cd | No | Yes | 8/13/2009 | VARCHAR2(1) | Drug-Alcohol Individual Non-Enrollment Reason Code | A - REFER TO TNG B - CDR DECISION C - PRSCRBD MED D - PTNT REFUSED E - REFER TO OTH F - NO AL/DR PRB I - REF INPAT TX M - REF MED/PSY N - TX NOT INDIC O - REF OTHER P - PCS R - INAPPR REF S - REF SWSFACMT U - RETURN CONUS |
|||||
| DAMIS | 3 | SCREEN_PROGESS | 1 | ppr_seq_nr | DI | Yes | 8/13/2009 | NUMBER(18) | Patient Progress Report Sequence Number | Primary Key Printed Out - Must be De-Identified | |||||
| DAMIS | 3 | SCREEN_PROGESS | 2 | Pir_seq_nr | DI | Yes | 8/13/2009 | NUMBER(18) | Unique patient intake/screening record number. | Primary Key Printed Out - Must be De-Identified | |||||
| DAMIS | 3 | SCREEN_PROGESS | 3 | da_prog_rpt_dt | No | Yes | 8/13/2009 | DATE | Drug-Alcohol Rehabilitation Progress Report Date | ||||||
| DAMIS | 3 | SCREEN_PROGESS | 4 | da_ppr_rsn_cd | No | Yes | 8/13/2009 | VARCHAR2(1) | Drug-Alcohol Patient Progress Report Reason Code | A - PCS/REASSIGN B - CHG TO DIAG C - CHG ENRL BAS D - RTF ADM/DIS E - PROG EVAL F - RELEASE |
|||||
| DAMIS | 3 | SCREEN_PROGESS | 5 | da_prog_sac_cd | No | Yes | 8/13/2009 | VARCHAR2(4) | Drug-Alcohol Rehabilitation Progress-Report Service Area Code. | See Service Area Code Tab | |||||
| DAMIS | 4 | Progress_Eval | 1 | ppr_seq_nr | DI | Yes | 8/13/2009 | NUMBER(18) | Patient Progress Report Sequence Number | Primary Key Printed Out - Must be De-Identified | |||||
| DAMIS | 4 | Progress_Eval | 2 | csl_prog_asmt_cd | No | Yes | 8/13/2009 | VARCHAR2(1) | Drug-Alcohol Counselor Progress Assessment Code | F - FAIR G - GOOD P - POOR |
|||||
| DAMIS | 4 | Progress_Eval | 3 | da_csl_rcmd_cd | No | Yes | 8/13/2009 | VARCHAR2(1) | Counselor Recommendation Disposition Code | A - CONT TRTMNT B - TERM TRT/RET C - TERM TRT/SEP D - TERM TRT/CIV |
|||||
| DAMIS | 4 | Progress_Eval | 4 | cdr_aprsl_prf_cd | No | Yes | 8/13/2009 | VARCHAR2(1) | Commander Appraisal Performance Code | U-UNSATISFACTORY S-SATISFACTORY |
|||||
| DAMIS | 4 | Progress_Eval | 5 | cdr_aprsl_cdt_cd | No | Yes | 8/13/2009 | VARCHAR2(1) | Commander Appraisal Conduct Code | U-UNSATISFACTORY S-SATISFACTORY |
|||||
| DAMIS | 4 | Progress_Eval | 6 | cdr_dir_dsp_cd | No | Yes | 8/13/2009 | VARCHAR2(1) | Commander Directed Drug-Alcohol Disposition Code | A - CONT TRTMNT B - TERM TRT/RET C - TERM TRT/SEP |
|||||
| DAMIS | 5 | RTF | 1 | ppr_seq_nr | DI | Yes | 8/13/2009 | NUMBER(18) | Patient Progress Report Sequence Number | Primary Key Printed Out - Must be De-Identified | |||||
| DAMIS | 5 | RTF | 3 | da_rtf_admit_dt | No | Yes | 8/13/2009 | DATE | Drug-Alcohol Residential Treatment Admission Date | ||||||
| DAMIS | 5 | RTF | 4 | da_rtf_cd | No | Yes | 8/13/2009 | VARCHAR2(4) | Residential Treatment Facility | Code for the in-patient Treatment Facility where the soldier was treated. Codes are: AFR0 AIR FORCE RESIDENTIAL TREATMENT FACILITY E8R1 BAD CANSTATT MEDDAC E8R2 BERLIN MEDDAC E8R3 FRANKFURT ARMY MEDICAL CENTER E8R4 HEIDELBERG MEDDAC E8R5 LANDSTUHL ARMY MEDICAL CENTER E8R6 NUERNBURG RESIDENTIAL TREATMENT FACILITY E8R6 NUERNBURG RESIDENTIAL TREATMENT FACILITY E8R7 AUGSBURG RESIDENTIAL TREATMENT FACILITY HSR1 WILLIAM BEAUMONT ARMY MEDICAL CENTER HSR2 DWIGHT DAVID EISENHOWER MEDICAL CENTER HSR3 TRIPLER ARMY MEDICAL CENTER NAR0 OTHER RESIDENTIAL TREATMENT FACILITY (NAVY) NAR0 OTHER RESIDENTIAL TREATMENT FACILITY (NAVY) NAR1 TRI-SERVICE ALCOHOL REHABILITATION DEPT P8R1 18TH MED CMD ZZRO OTHER CIVILIAN RESIDENTIAL TREATMENT FACILITY |
|||||
| DAMIS | 5 | RTF | 5 | da_rtf_disc_dt | No | Yes | 8/13/2009 | DATE | Drug-Alcohol Residential Treatment Discharge Date | ||||||
| DAMIS | 6 | PCS | 1 | ppr_seq_nr | DI | Yes | 8/13/2009 | NUMBER(18) | Patient Progress Report Sequence Number | Primary Key Printed Out - Must be De-Identified | |||||
| DAMIS | 6 | PCS | 3 | da_loss_sac_cd | No | Yes | 8/13/2009 | VARCHAR2(4) | Drug-Alcohol Individual Losing Service Area Code | ||||||
| DAMIS | 6 | PCS | 4 | da_gain_sac_cd | No | Yes | 8/13/2009 | VARCHAR2(4) | Drug-Alcohol Individual Gaining Service Area Code | ||||||
| DAMIS | 7 | DIAGNOSIS | 1 | ppr_seq_nr | DI | Yes | 8/13/2009 | NUMBER(18) | Patient Progress Report Sequence Number | Primary Key Printed Out - Must be De-Identified | |||||
| DAMIS | 7 | DIAGNOSIS | 2 | da_pri_diag_cd | No | Yes | 8/13/2009 | VARCHAR2(5) | Drug-Alcohol Primary Diagnosis Code | 30390 - ALC DEPNDENC 30400 - OPI DEPNDENC 30410 - SED DEPNDENC 30420 - COC DEPNDENC 30430 - CAN DEPNDENC 30440 - AMP DEPNDENC 30451 - HAL DEPNDENC 30452 - PCP DEPNDENC 30460 - INH DEPNDENC 30491 - POL DEPNDENC 30499 - PSY DEPNDENC 30500 - ALC ABUSE 30520 - CAN ABUSE 30530 - HAL ABUSE 30540 - SED ABUSE 30550 - OPI ABUSE 30560 - COC ABUSE 30570 - AMP ABUSE 30591 - INH ABUSE 30592 - PCP ABUSE 30599 - PSY ABUSE |
|||||
| DAMIS | 7 | DIAGNOSIS | 3 | da_sec_diag_cd | No | Yes | 8/13/2009 | VARCHAR2(5) | Drug-Alcohol Secondary Diagnosis Code | ||||||
| DAMIS | 7 | DIAGNOSIS | 4 | da_ter_diag_cd | No | Yes | 8/13/2009 | VARCHAR2(5) | Drug-Alcohol Tertiary Diagnosis Code | ||||||
| DAMIS | 8 | BASIS | 1 | ppr_seq_nr | DI | Yes | 8/13/2009 | NUMBER(18) | Patient Progress Report Sequence Number | Primary Key Printed Out - Must be De-Identified | |||||
| DAMIS | 8 | BASIS | 2 | da_pri_enr_bas_cd | No | Yes | 8/13/2009 | VARCHAR2(3) | Drug-Alcohol Primary Enrollment Basis Code | ALC - ALC MISUSE AMP - AMP MISUSE CAN - CAN MISUSE COA - CHILD OF ALC COC - COC MISUSE EAP - EMP ASST PRG HAL - HAL MISUSE INH - INH MISUSE OPI - OPI MISUSE OTH - OTH SUBS MIS PHE - PHE MISUSE PRE - PREVENTION SED - SED MISUSE |
|||||
| DAMIS | 8 | BASIS | 3 | da_sec_enr_bas_cd | No | Yes | 8/13/2009 | VARCHAR2(3) | Drug-Alcohol Secondary Enrollment Basis Code | ||||||
| DAMIS | 8 | BASIS | 4 | da_ter_enr_bas_cd | No | Yes | 8/13/2009 | VARCHAR2(3) | Drug-Alcohol Tertiary Enrollment Basis Code | ||||||
| DAMIS | 9 | RELEASE | 1 | ppr_seq_nr | DI | Yes | 8/13/2009 | NUMBER(18) | Data Element Full Name: Patient Progress Report Sequence Number | Primary Key Printed Out - Must be De-Identified | |||||
| DAMIS | 9 | RELEASE | 2 | da_rels_bas_cd | No | Yes | 8/13/2009 | VARCHAR2(1) | Drug-Alcohol Program Patient Release Basis Code | A - PROGRAM COMPLETED, RETURNED TO DUTY B - COMPLETION OF TOUR OF DUTY/LEAVING ACTIVE FEDERAL C - SEPARATION/TERMINATION AS AN ALCOHOL/DRUG ABUSE REHABILITATIO D - SEPARATION/TERMINATION FOR MISCONDUCT - ABUSE OF ILLEGAL DRU E - SEPARATION/TERMINATION FOR OTHER THAN ALCOHOL/DRUG REASONS F - PATIENT REFUSES FURTHER TREATMENT G - COMMANDER TERMINATED THE ENROLLMENT AGAINST MEDICAL ADVICE H - ERRONEOUS ENROLLMENT, NOT AN ALCOHOL OR DRUG ABUSER I - REFERRED TO INPATIENT TREATMENT N - NONCOMPLIANCE O - REFERRED FOR OTHER MENTAL HEALTH TREATMENT P - PLANNED PERMANENT CHANGE OF STATION T - TREATMENT/PREVENTION COMPLETED U - UNPLANNED PERMANENT CHANGE OF STATION X - OTHER Z - UNKNOWN (ADMINISTRATIVE RELEASE) |
|||||
| DAMIS | 9 | RELEASE | 3 | da_rehb_asmt_cd | No | Yes | 8/13/2009 | VARCHAR2(1) | Drug-Alcohol Commander Rehabilitation Assessment Code | F - FAILED REHAB S - SUCCES REHAB |
|||||
| DAMIS | 10 | SPECIMEN | 1 | da_accsn_nr | DI | Yes | 8/13/2009 | VARCHAR2(11) | Data Element Full Name: Drug-Alcohol Accession Number | Primary Key Printed Out - Must be De-Identified | |||||
| DAMIS | 10 | SPECIMEN | 2 | ind_sys_seq_nr | DI | Yes | 8/13/2009 | NUMBER(18) | Individual Information System Sequence Number | Primary Key Printed Out - Must be De-Identified | |||||
| DAMIS | 10 | SPECIMEN | 3 | da_spec_coll_dt | No | Yes | 8/13/2009 | DATE | Drug-Alcohol Urinalysis Specimen Collection Date | ||||||
| DAMIS | 10 | SPECIMEN | 6 | da_us_spc_sa_cd | No | Yes | 8/13/2009 | VARCHAR2(4) | Drug-Alcohol Urinalysis Specimen Service Area Code | See Service Area Code Tab | |||||
| DAMIS | 10 | SPECIMEN | 7 | da_us_crt_dt | No | Yes | 8/13/2009 | DATE | Drug-Alcohol Urinalysis Specimen Certification date | ||||||
| DAMIS | 10 | SPECIMEN | 8 | da_us_unt_id_cd | Yes | Yes | 8/13/2009 | VARCHAR2(6) | Drug-Alcohol Urinalysis Specimen Unit Identification Code | ||||||
| DAMIS | 10 | SPECIMEN | 13 | da_ml_tst_bs_cd | No | Yes | 8/13/2009 | VARCHAR2(2) | Drug-Alcohol Military Test Basis Code | Test Basis Code – Reason a test was conducted IR: Inspection Random IO: Inspection Other IU: Inspection Unit PO: Probable Cause CO: Competence for Duty RO: Rehabilitation AO: Accident/Mishap or Safety VO: Consent or Volunteer MO: Medical Examination NO: "New Entrant OO: Other |
|||||
| DAMIS | 11 | RESULT | 1 | da_accsn_nr | DI | Yes | 8/13/2009 | VARCHAR2(11) | Data Element Full Name: Drug-Alcohol Accession Number | Primary Key Printed Out - Must be De-Identified | |||||
| DAMIS | 11 | RESULT | 2 | da_urnls_drg_cd | No | Yes | 8/27/2009 | VARCHAR2(1) | Alcohol Urinalysis Drug Type Code | A - AMPHETAMINE B - BARBITURATES C - COCAINE H - HALLUCINOGEN L - LSD M - METH/SED/HYP O - OPIATES P - PHENCYCLDINE S - STEROIDS T - CANNABIS X - NOT SPECFIED Z - UNKNOWN |
|||||
| DAMIS | 11 | RESULT | 3 | da_dtl_rslt_cd | No | Yes | 8/13/2009 | VARCHAR2(1) | Drug-Alcohol Urinalysis Specimen Laboratory Result Code | N - NEGATIVE P - POSITIVE X - NOT TESTED |
|||||
| DAMIS | 12 | DRUG_POSITIVES | 1 | da_accsn_nr | DI | Yes | 8/13/2009 | VARCHAR2(11) | Data Element Full Name: Drug-Alcohol Accession Number | Primary Key Printed Out - Must be De-Identified | |||||
| DAMIS | 12 | DRUG_POSITIVES | 2 | da_urnls_drg_cd | No | Yes | 8/13/2009 | VARCHAR2(1) | Alcohol Urinalysis Drug Type Code | A - AMPHETAMINE B - BARBITURATES C - COCAINE H - HALLUCINOGEN L - LSD M - METH/SED/HYP O - OPIATES P - PHENCYCLDINE S - STEROIDS T - CANNABIS X - NOT SPECFIED Z - UNKNOWN |
|||||
| DAMIS | 12 | DRUG_POSITIVES | 3 | drug_pos_cd | No | Yes | 8/13/2009 | VARCHAR2(5) | Drug Positive Code | 6MAM - HEROIN AMO - AMOBARB AMP - AMPHETAMINE BUT - BUTALBITAL COC - COCAINE COD - CODEINE DMET - DMETH LSD - LSD MDA - MDA MDEA - MDEA MDMA - MDMA MOR - MORPHINE OPI - OPIATE PCP - PCP PEN - PENTOBARB PHE - PHENOBARB SEC - SECOBARB STE - STEROIDS THC - THC |
|||||
| DAMIS | 12 | DRUG_POSITIVES | 7 | da_mro_eval_cd | No | Yes | 8/13/2009 | VARCHAR2(1) | Drug-Alcohol Medical Review-Officer Evaluation-Status Code | A - EVL-AUTH USE N - EVL NOT REQR P - EVAL PENDING S - SLDR NOT AVL U - EV-UNAUT USE Z - EV STAT UNKN |
|||||
| DAMIS | 12 | DRUG_POSITIVES | 8 | da_mro_eval_dt | No | Yes | 8/13/2009 | DATE | Drug-Alcohol Medical Review-Officer Evaluation Date specimen that tested positive for illicit drugs. | ||||||
| DAMIS | 12 | DRUG_POSITIVES | 9 | sldr_nonavl_rsn_cd | No | Yes | 8/13/2009 | VARCHAR2(1) | Soldier Nonavailability Reason Code | A-ETS B-DFR C-AWOL D-PCS E-INCARC' F-DISCH G-DEATH |
|||||
| DAMIS | 12 | DRUG_POSITIVES | 11 | DRUG_PRESCRIBED | No | Yes | 8/27/2009 | VARCHAR2(60) | Drug prescribed | ||||||
| DAMIS | 12 | DRUG_POSITIVES | 12 | PRESCRIPTION_DT | No | Yes | 8/27/2009 | DATE | Prescription Date |
| Service area code describes location where specimen was collected. Note: Prior to 2006 not all specimens collected in theater used CT** SACs; many units shipped specimens back to the rear installation for processing. The codes are: |
| 200M : 200TH MILITARY POLICE COMMAND |
| 364A : 364TH SUSTAINMENT COMMAND (EXPEDITIONARY) |
| 4R41 : 70TH DIVISION (TRAINING) |
| 6399 : 311TH CORPS SUPPORT COMMAND |
| 639A : 63RD REGIONAL SUPPORT COMMAND |
| 639E : 91ST DIVISION (EXERCISE) |
| 652B : 65TH ARMY RESERVE COMMAND |
| 700A : 70TH REGIONAL SUPPORT COMMAND |
| 700F : 104TH DIVISION (TRAINING) |
| 772A : 77TH REGIONAL SUPPORT COMMAND |
| 772E : 78TH DIVISION (EXERCISE) |
| 772F : 98TH DIVISION (TRAINING) |
| 807M : 807TH MEDICAL COMMAND (DEPLOYED SUPPORT) |
| 8145 : 412TH ENGINEER COMMAND |
| 8146 : 143 TRANSPORTATION COMMAND |
| 8147 : 335TH SIGNAL COMMAND |
| 8148 : 3RD MEDICAL COMMAND |
| 814A : 81ST REGIONAL SUPPORT COMMAND |
| 814E : 87TH DIVISION (EXERCISE) |
| 814F : 100TH DIVISION (TRAINING) |
| 814G : 108TH DIVISION (TRAINING) |
| 8855 : 416TH ENGINEER COMMAND (CONSTRUCTION) |
| 8856 : 11TH AVIATION COMMAND |
| 885A : 88TH RESERVE READINESS COMMAND |
| 885E : 85TH DIVISION (EXERCISE) |
| 885G : 84TH DIVISION (TRAINING) |
| 88RC : 88TH REGIONAL SUPPORT COMMAND |
| 8977 : 19TH THEATER ARMY AREA COMMAND |
| 897A : 89TH REGIONAL SUPPORT COMMAND |
| 9066 : 377TH THEATER ARMY AREA COMMAND |
| 906A : 90TH REGIONAL SUPPORT COMMAND |
| 906E : 75TH DIVISION (EXERCISE) |
| 906F : 95TH DIVISION (TRAINING) |
| 941A : 94TH REGIONAL SUPPORT COMMAND |
| 950A : U.S. ARMY RESERVE READINESS COMMAND |
| 968A : 96TH REGIONAL SUPPORT COMMAND |
| 9931 : 311TH SIGNAL COMMAND |
| 9935 : 310TH THEATER ARMY AREA COMMAND |
| 993A : 99TH REGIONAL SUPPORT COMMAND |
| 993F : 80TH DIVISION (TRAINING) |
| 9940 : 103RD EXPEDITIONARY SUSTAINMENT COMMAND |
| 9941 : 316TH EXPEDITIONARY SUPPORT COMMAND |
| 9942 : 310TH EXPEDITIONARY SUSTAINMENT COMMAND |
| AC01 : UNITED STATES ARMY CADET COMMAND |
| AFL1 : AIR FORCE DRUG TESTING LABORATORY |
| AR01 : HUMAN RESOURCES COMMAND - ST. LOUIS |
| AR02 : HEADQUARTERS, U.S. ARMY RESERVE COMMAND |
| AR03 : U.S.A. RESERVE COMMAND AUGMENTATION UNIT |
| AR04 : MILITARY INTELLIGENCE READINESS COMMAND |
| AR05 : U.S. ARMY RESERVE MEDICAL COMMAND |
| AR07 : 7TH ARMY RESERVE COMMAND |
| AR08 : U.S. ARMY HQ COMBAT SUPPORT TRAINING CTR |
| CT01 : COMBINED FORCES COALITION - AFGH -CJTF67 |
| CT02 : COMBINED FORCES COALITION - AFGH -KABUL |
| CT03 : HHC ARMY CENTRAL COMMAND - KUWAIT |
| CT04 : MULTINATIONAL FORCE IRAQ |
| CT05 : MULTINATIONAL CORPS IRAQ |
| CT06 : MULTINATIONAL DIVISION-BAGHDAD-IRAQ |
| CT07 : MULTINATIONAL FORCE WEST IRAQ |
| CT08 : MULTINATIONAL DIVISION NORTH IRAQ |
| CT09 : LOGISTICAL SUPPORT AREA ANACONDA |
| CT10 : AREA SUPPORT GROUP-QATAR |
| CT11 : HHSC STB MND-C |
| DA01 : DEPUTY CHIEF OF STAFF FOR PERSONNEL |
| DA02 : US ARMY DRUG & ALCOHOL OPERATIONS AGENCY |
| DA03 : OFFICE OF THE SURGEON GENERAL |
| DA04 : US DISCIPLINARY BARRACKS |
| DA05 : OFC OF ADMIN. ASST. TO SEC. OF THE ARMY |
| E2B3 : USAG KAISERSLAUTERN |
| E2D1 : USAG MANNHEIM |
| E2G1 : USAG SCHINNEN |
| E2R0 : USAG BENELUX |
| E2R1 : USAG BRUSSELS |
| E301 : USAG VICENZA |
| E302 : USAG LIVORNO |
| E5B1 : USAG BAUMHOLDER |
| E5C1 : USAG DARMSTADT |
| E5G4 : USAG HANAU |
| E5H1 : USAG WIESBADEN |
| E7A1 : USAG ANSBACH |
| E7E1 : USAG BAMBERG |
| E7P1 : USAG SCHWEINFURT |
| E7Q2 : USAG STUTTGART |
| E8R4 : HEIDELBERG MEDDAC |
| E8R5 : LANDSTUHL ARMY REGIONAL MEDICAL CENTER |
| E901 : HHC ARMY CENTRAL COMMAND-KUWAIT |
| E902 : KOSOVO FORCE TASK FORCE FALCON |
| E903 : MULTINATIONAL FORCE AND OBSERVERS, SINAI |
| EE37 : USAG HEIDELBERG |
| EN34 : USAG GRAFENWOHR |
| EN42 : USAG HOHENFELS |
| EN43 : UNITED STATES ARMY GARRISON GARMISCH |
| EN78 : USAG VILSECK |
| ENA0 : USAG GRAFENWOHR |
| FC03 : FT BRAGG |
| FC04 : FT CAMPBELL |
| FC05 : FT CARSON |
| FC06 : FT DIX |
| FC07 : FT DEVENS |
| FC08 : FT DRUM |
| FC10 : FORT BUCHANAN |
| FC11 : FT HOOD |
| FC13 : FT INDIANTOWN GAP |
| FC14 : FT LEWIS |
| FC16 : FT MCCOY |
| FC17 : FT MCPHERSON |
| FC19 : FT RILEY |
| FC22 : FT STEWART |
| FC23 : FT STEWART (HUNTER ARMY AIRFIELD) |
| FC27 : FT POLK |
| FC28 : FT IRWIN |
| FC30 : CAMP ATTERBURY JOINT MANEUVER TNG CENTER |
| FC31 : CAMP SHELBY MOBILIZATION CENTER |
| HS01 : FT DETRICK |
| HS03 : WALTER REED ARMY MEDICAL CENTER |
| HS04 : FT SAM HOUSTON |
| MA01 : WEST POINT, US MILITARY ACADEMY |
| MP01 : EASTERN SECTOR, USMEPCOM |
| MP02 : WESTERN SECTOR, UPMEPCOM |
| MP03 : ALBANY MEPS |
| MP04 : ATLANTA MEPS |
| MP05 : BALTIMORE MEPS |
| MP06 : BECKLEY MEPS |
| MP07 : BOSTON MEPS |
| MP08 : BUFFALO MEPS |
| MP09 : CHARLOTTE MEPS |
| MP10 : CHICAGO MEPS |
| MP11 : CLEVELAND MEPS |
| MP12 : COLUMBUS MEPS |
| MP13 : DETROIT MEPS |
| MP14 : FT JACKSON MEPS |
| MP15 : HARRISBURG MEPS |
| MP16 : INDIANAPOLIS MEPS |
| MP17 : JACKSON MEPS |
| MP18 : JACKSONVILLE MEPS |
| MP19 : KNOXVILLE MEPS |
| MP20 : LANSING MEPS |
| MP21 : LOUISVILLE MEPS |
| MP22 : MEMPHIS MEPS |
| MP23 : MIAMI MEPS |
| MP24 : MONTGOMERY MEPS |
| MP25 : NASHVILLE MEPS |
| MP26 : NEW YORK MEPS |
| MP27 : PHILADELPHIA MEPS |
| MP28 : PITTSBURGH MEPS |
| MP29 : PORTLAND, MAINE MEPS |
| MP30 : RALEIGH MEPS |
| MP31 : RICHMOND MEPS |
| MP32 : SAN JUAN MEPS |
| MP33 : SPRINGFIELD MEPS |
| MP34 : SYRACUSE MEPS |
| MP35 : TAMPA MEPS |
| MP36 : ALBUQUERQUE MEPS |
| MP37 : AMARILLO MEPS |
| MP38 : ANCHORAGE MEPS |
| MP39 : BOISE MEPS |
| MP40 : BUTTE MEPS |
| MP41 : DALLAS MEPS |
| MP42 : DENVER MEPS |
| MP43 : DES MOINES MEPS |
| MP44 : EL PASO MEPS |
| MP45 : FARGO MEPS |
| MP46 : FRESNO MEPS |
| MP47 : HONOLULU MEPS |
| MP48 : HOUSTON MEPS |
| MP49 : KANSAS CITY MEPS |
| MP50 : LITTLE ROCK MEPS |
| MP51 : LOS ANGELES MEPS |
| MP52 : MILWAUKEE MEPS |
| MP53 : MINNEAPOLIS MEPS |
| MP54 : NEW ORLEANS MEPS |
| MP55 : OAKLAND MEPS |
| MP56 : OKLAHOMA CITY MEPS |
| MP57 : OMAHA MEPS |
| MP58 : PHOENIX MEPS |
| MP59 : PORTLAND, OREGON MEPS |
| MP60 : SALT LAKE CITY MEPS |
| MP61 : SAN ANTONIO MEPS |
| MP62 : SAN DIEGO MEPS |
| MP63 : SEATTLE MEPS |
| MP64 : SHREVEPORT MEPS |
| MP65 : SIOUX FALLS MEPS |
| MP66 : SPOKANE MEPS |
| MP67 : ST LOUIS MEPS |
| MP68 : SACRAMENTO MEPS |
| MW03 : FT MYER |
| MW04 : FT BELVOIR |
| MW05 : FT MEADE |
| MW07 : FT HAMILTON |
| NAR1 : TRI-SERVICE ALCOHOL REHABILITATION DEPT |
| NG01 : ALABAMA ARMY NATIONAL GUARD |
| NG02 : ALASKA ARMY NATIONAL GUARD |
| NG03 : ARIZONA ARMY NATIONAL GUARD |
| NG04 : ARKANSAS ARMY NATIONAL GUARD |
| NG05 : CALIFORNIA ARMY NATIONAL GUARD |
| NG06 : COLORADO ARMY NATIONAL GUARD |
| NG07 : CONNECTICUT ARMY NATIONAL GUARD |
| NG08 : DELEWARE ARMY NATIONAL GUARD |
| NG09 : DC ARMY NATIONAL GUARD |
| NG10 : FLORIDA ARMY NATIONAL GUARD |
| NG11 : GEORGIA ARMY NATIONAL GUARD |
| NG12 : GUAM ARMY NATIONAL GUARD |
| NG13 : HAWAII ARMY NATIONAL GUARD |
| NG14 : IDAHO ARMY NATIONAL GUARD |
| NG15 : ILLINOIS ARMY NATIONAL GUARD |
| NG16 : INDIANA ARMY NATIONAL GUARD |
| NG17 : IOWA ARMY NATIONAL GUARD |
| NG18 : KANSAS ARMY NATIONAL GUARD |
| NG19 : KENTUCKY ARMY NATIONAL GUARD |
| NG20 : LOUISIANA ARMY AND AIR NATIONAL GUARD |
| NG21 : MAINE ARMY NATIONAL GUARD |
| NG22 : MARYLAND ARMY NATIONAL GUARD |
| NG23 : MASSACHUSETTS ARMY NATIONAL GUARD |
| NG24 : MICHIGAN ARMY NATIONAL GUARD |
| NG25 : MINNESOTA ARMY NATIONAL GUARD |
| NG26 : MISSISSIPPI ARMY NATIONAL GUARD |
| NG27 : MISSOURI ARMY NATIONAL GUARD |
| NG28 : MONTANA ARMY NATIONAL GUARD |
| NG29 : NEBRASKA NATIONAL GUARD |
| NG30 : NEVADA ARMY NATIONAL GUARD |
| NG31 : NEW HAMPSHIRE ARMY NATIONAL GUARD |
| NG32 : NEW JERSEY ARMY NATIONAL GUARD |
| NG33 : NEW MEXICO ARMY NATIONAL GUARD |
| NG34 : NEW YORK ARMY NATIONAL GUARD |
| NG35 : NORTH CAROLINA ARMY NATIONAL GUARD |
| NG36 : NORTH DAKOTA ARMY NATIONAL GUARD |
| NG37 : OHIO ARMY NATIONAL GUARD |
| NG38 : OKLAHOMA MILITARY DEPARTMENT |
| NG39 : OREGON ARMY NATIONAL GUARD |
| NG40 : PENNSYLVANIA ARMY NATIONAL GUARD |
| NG41 : ADJUTANT GENERAL OF PUERTO_RICO |
| NG42 : RHODE ISLAND NATIONAL GUARD |
| NG43 : ADJUTANT GENERAL OF SOUTH CAROLINA |
| NG44 : SOUTH DAKOTA ARMY NATIONAL GUARD |
| NG45 : TENNESSEE ARMY NATIONAL GUARD |
| NG46 : TEXAS ARMY NATIONAL GUARD |
| NG47 : UTAH NATIONAL GUARD |
| NG48 : VERMONT ARMY NATIONAL GUARD |
| NG49 : THE ADJUTANT GENERAL OF VIRGINIA |
| NG50 : VIRGIN ISLANDS NATIONAL GUARD |
| NG51 : WASHINGTON ARMY NATIONAL GUARD |
| NG52 : WEST VIRGINIA ARMY NATIONAL GUARD |
| NG53 : WISCONSIN ARMY NATIONAL GUARD |
| NG54 : THE ADJUTANT GENERAL, STATE OF WYOMING |
| P103 : FT RICHARDSON |
| P104 : FT WAINWRIGHT |
| P105 : FT. GREELY |
| P106 : SCHOFIELD BARRACKS |
| P107 : USAG-J CAMP ZAMA |
| P108 : USAG-J OKINAWA |
| P109 : 9TH RSC USAR |
| P801 : USAG HUMPHREYS |
| P802 : USAG RED CLOUD/CASEY |
| P807 : USAG YONGSAN |
| P809 : USAG DAEGU |
| P8R1 : 18 MED CMD |
| RC04 : US ARMY RECRUITING COMMAND |
| SA01 : US ARMY SOUTH, G1, WELL BEING |
| SC00 : HDQTRS UNITED STATES SOUTHERN COMMAND |
| SP00 : US ARMY CIVIL AFFAIRS AND PSYCH OPS CMD |
| SP01 : US SPECIAL OPERATIONS COMMAND |
| SU00 : US ARMY, SOUTH |
| SU03 : JOINT INTERAGENCY TASK FORCE SOUTH |
| SU04 : SPECIAL OPERATIONS COMMAND SOUTH |
| SU05 : ARMY SUPPORT ACTIVITY - SOTO CANO |
| TC01 : FT HUACHUCA |
| TC02 : FT BENNING |
| TC03 : FT BLISS |
| TC04 : CARLISLE BARRACKS |
| TC06 : FT EUSTIS |
| TC07 : FT GORDON |
| TC08 : US ARMY SOLDIER SUPPORT CENTER |
| TC11 : FT JACKSON |
| TC12 : FT KNOX |
| TC13 : FT LEAVENWORTH |
| TC14 : FT LEE |
| TC16 : FT MONROE |
| TC21 : FT RUCKER |
| TC22 : FT SILL |
| TC24 : FT LEONARD WOOD |
| TC26 : PRESIDIO OF MONTEREY |
| X100 : US ARMY MATERIEL COMMAND |
| X165 : US ARMY MATERIEL COMMAND |
| XA00 : US ARMY LABORATORIES, HARRY DIAMOND LABS |
| XA12 : ADELPHI LABORATORY CENTER |
| XB67 : US ARMY AVIATION & TROOP COMMAND |
| XM02 : US ARMY ABERDEEN PROVING GROUND |
| XM13 : DUGWAY PROVING GROUND |
| XM19 : JEFFERSON PROVING GROUND |
| XM61 : WHITE SANDS MISSILE RANGE |
| XM63 : YUMA PROVING GROUND |
| XQ35 : PICATINNY ARSENAL |
| XQ36 : PINE BLUFF ARSENAL |
| XQ43 : ROCK ISLAND ARSENAL |
| XQ60 : WATERVLIET ARSENAL |
| XQ69 : MCALESTER ARMY AMMO PLANT |
| XQ70 : US ARMY CHEMICAL BIOLOGICAL DEFENSE CMD |
| XQ71 : ROCKY MOUNTAIN ARSENAL |
| XQ72 : CAMP STANLEY STORAGE ACTIVITY |
| XQ73 : NEWPORT CHEMICAL DEPOT |
| XS00 : US ARMY COMMUNICATIONS & ELECTRONICS CMD |
| XS30 : FORT MONMOUTH |
| XT00 : US ARMY MISSILE COMMAND |
| XT40 : REDSTONE ARSENAL |
| XU10 : US ARMY TANK-AUTOMOTIVE SUPPORT ACTIVITY |
| XU11 : US ARMY TANK-AUTOMOTIVE COMMAND |
| XW00 : US ARMY DEPOT SYSTEM COMMAND |
| XW03 : ANNISTON ARMY DEPOT |
| XW23 : LETTERKENNY ARMY DEPOT |
| XW24 : LEXINGTON-BLUE GRASS ARMY DEPOT |
| XW37 : PUEBLO ARMY DEPOT ACTIVITY |
| XW39 : RED RIVER ARMY DEPOT |
| XW45 : SACRAMENTO ARMY DEPOT |
| XW46 : SENECA ARMY DEPOT |
| XW52 : SIERRA ARMY DEPOT |
| XW55 : TOBYHANNA ARMY DEPOT |
| XW56 : TOOELE ARMY DEPOT |
| XW57 : UMATILLA ARMY DEPOT ACTIVITY |
| XW68 : CORPUS CHRISTI ARMY DEPOT |
| XZ00 : USA SOLDIER SYSTEMS COMMAND |
| File Type | application/vnd.openxmlformats-officedocument.spreadsheetml.sheet |
| File Modified | 0000-00-00 |
| File Created | 0000-00-00 |