APHDR Data Sets

Army Public Health Data Repository (APHDR)

MEPCOM layout (26).xlsx

APHDR Data Sets

OMB:

Document [xlsx]
Download: xlsx | pdf

Overview

Acc LAYOUT
Dep LAYOUT
Dep Disch LAYOUT
Data Dictionary
PULHES
Youth Program

Sheet 1: Acc LAYOUT
position Data Element Length Notes
1 SSN 9
10 Prior Military Service 1
11 Sex 1
12 Martial Status 1
13 DOB Year 4
17 Dob Month 2
19 DOB Day 2
21 Education Years Completed 2
23 ASVAB Test Version 3
26 MEPCOM Medical Fail Code 3
29 Medical Waiver? 1 Y/N
30 PULHES P 2 Physical capacity or stamina (see "PULHES" tab)
32 PULHES U 2 Upper extremities (see "PULHES" tab)
34 PULHES L 2 Lower extremities (see "PULHES" tab)
36 PULHES H 2 Hearing (see "PULHES" tab)
38 PULHES E 2 Eyes (see "PULHES" tab)
40 PULHES S 2 Psychiatric (see "PULHES" tab)
42 Drug Test Alcohol 1 See "Drug Codes"
43 Drug Test Marijuana 1 See "Drug Codes"
44 Drug Test Cocaine 1 See "Drug Codes"
45 Date Alcohol Test 6 YYYYMM
51 Date Drug Test 6 YYYYMM
57 Accession Date 8 YYYYMMDD
65 Active Duty Duration 1 IN YEARS
66 Accession Waiver Code 3 see "new Waiver_Codes.doc"
69 Accession Service 2 See "Service"
71 Accession Program Enlistment 5 Service-designated (no definitions @ DMDC)
76 Accession Youth Program 3 See "Youth Program" Tab
79 Accesison Bonus 1
80 Accession Guarantee 1






Sheet 2: Dep LAYOUT
position Data Element Length Notes
1 SSN 9
10 Prior Military Service 1
11 Sex 1
12 Martial Status 1
13 DOB Year 4
17 Dob Month 2
19 DOB Day 2
21 Education Years Completed 2
23 ASVAB Test Version 3
26 MEPCOM Medical Fail Code 3
29 Medical Waiver? 1 Y/N
30 PULHES P 2 Physical capacity or stamina (see "PULHES" tab)
32 PULHES U 2 Upper extremities (see "PULHES" tab)
34 PULHES L 2 Lower extremities (see "PULHES" tab)
36 PULHES H 2 Hearing (see "PULHES" tab)
38 PULHES E 2 Eyes (see "PULHES" tab)
40 PULHES S 2 Psychiatric (see "PULHES" tab)
42 Drug Test Alcohol 1 See "Drug Codes"
43 Drug Test Marijuana 1 See "Drug Codes"
44 Drug Test Cocaine 1 See "Drug Codes"
45 Date Alcohol Test 6 YYYYMM
51 Date Drug Test 6 YYYYMM
57 DEP Date 8 YYYYMMDD
65 DEP Program Code 5 Service-designated (no definitions @ DMDC)
70 DEP Waiver Code 3 see "new Waiver_Codes.doc"
73 DEP service 2 See "Service"



Sheet 3: Dep Disch LAYOUT
position Data Element Length Notes
1 SSN 9
10 Prior Military Service 1
11 Sex 1
12 Martial Status 1
13 DOB Year 4
17 Dob Month 2
19 DOB Day 2
21 Education Years Completed 2
23 ASVAB Test Version 3
26 MEPCOM Medical Fail Code 3
29 Medical Waiver? 1 Y/N
30 PULHES P 2 Physical capacity or stamina (see "PULHES" tab)
32 PULHES U 2 Upper extremities (see "PULHES" tab)
34 PULHES L 2 Lower extremities (see "PULHES" tab)
36 PULHES H 2 Hearing (see "PULHES" tab)
38 PULHES E 2 Eyes (see "PULHES" tab)
40 PULHES S 2 Psychiatric (see "PULHES" tab)
42 Drug Test Alcohol 1 See "Drug Codes"
43 Drug Test Marijuana 1 See "Drug Codes"
44 Drug Test Cocaine 1 See "Drug Codes"
45 Date Alcohol Test 6 YYYYMM
51 Date Drug Test 6 YYYYMM
57 DEP Discharge Date 8 YYYYMMDD
65 DEP Discharge Separation Code 3






Sheet 4: Data Dictionary
Prior Military Service Sex Martial Status ASVAB Test Version MEPCOM Medical Fail Code Drug Test Results Service DEP Discharge Separation Code Accession Bonus Accession Guarantee
N = No F = Female A = Marriage annulled 01C CAT ASVAB Enlistment Valid From 01-Sep-1990 To 28-Feb-1997 15 Administrative/Documentation A Positive Results - Alcohol AR = Army Regular ZAA Medical disqualification - existing prior to service A Combat-Arms-O A Advanced enlistment grade plus training or skill, unit or geographic location and buddy program.
Y = Yes M = Male D = Divorced 01D CAT ASVAB Enlistment Valid From 01-Oct-1996 To 30-Apr-2004 17 Head, Face, Neck And Scalp C Positive Results - Cocaine AV = Army Reserve ZAB Medical disqualification - not existing prior to service B Combat-Arms-1501-3000 B Advanced enlistment grade plus unit or geographic location plus buddy program.

Z = Unknown I = Interlocutory 01E CAT ASVAB Enlistment Valid From 01-May-2004 To 31-Dec-2050 18 Nose D Positive Results - D-Methamphetamine (D-MET) AG = Army Guard ZAC Pregnancy C Combat-Arms-5001-8000 C Advanced enlistment grade plus unit or geographic location.


L = Legally separated 01R ASVAB Enlistment Valid From 01-Jun-2000 To 30-Jun-2002 19 Sinuses E Positive Results - Methylenedioxymethamphetamine (MDMA) AZ = Army, component unknown ZAD Death G Combat-Arms-3001-5000 D Advanced enlistment grade.


M = Married 01S ASVAB Enlistment Valid From 01-Jun-2000 To 30-Jun-2002 20 Mouth And Throat H Positive Results - Methylenedioxyamphetamine (MDA) FR = Air Force Regular ZBA Moral disqualification - existing prior to service H Noncombat-Arms-0-1500 E Advanced enlistment grade plus unit or geographic location and training or skill.


N = Never married 01T ASVAB Enlistment Valid From 01-Jul-2002 To 31-Dec-2050 21 Ears - General (Internal And Ext Canals/Auditory Acuity Under Item 72. L Positive Results –D-Amphetamine (D-AMP) FV = Air Force Reserve ZBB Moral disqualification - not existing prior to service J Noncombat-Arms-1501-3000 F Advanced enlistment grade plus training or skill guarantee.


W = Widowed 01U ASVAB Enlistment Valid From 01-Jul-2002 To 31-Dec-2050 22 Drums (Perforation) M Positive Results - Marijuana FG = Air Guard ZBC Apathy/personal problem K Noncombat-Arms-5001-8000 G Advanced enlistment grade plus buddy program.


Z = Unknown 01V ASVAB Enlistment Valid From 01-Jul-2002 To 31-Dec-2050 23 Eyes - General (Visual Acuity And Refraction Under Items 61-63) N Negative Results FZ = Air Force, component unknown ZBD Refused to enlist - separation action initiated L Noncombat-Arms-3001-5000 H Accelerated promotion plus unit or geographic location unit or geographic location and buddy program.



01W ASVAB Enlistment Valid From 01-Jul-2002 To 31-Dec-2050 24 Ophthalmoscopic T Test Administered: Results Pending MR = Marine Corps Regular ZBE Did not report on date scheduled for active duty - separation action initiated Y None/Not Acceptable J Accelerated promotion plus unit or geographic location and buddy program.



02C CAT ASVAB Enlistment Valid From 01-Sep-1990 To 28-Feb-1997 25 Pupils (Equality And Reaction) V Test Administered Before Date Eligibility: Results Void MV = Marine Corps Reserve ZBF Concealment of prior service

K Accelerated promotion plus unit or geographic location.



02D CAT ASVAB Enlistment Valid From 01-Oct-1996 To 30-Apr-2004 26 Ocular Motility (Associated Parallel Movements, Nystagmus) X Refused Test MZ = Marine Corps, component unknown ZCA Dependency disqualification

L Accelerated promotion.



02E CAT ASVAB Enlistment Valid From 01-May-2004 To 31-Dec-2050 27 Heart (Thrust, Size, Rhythm, Sounds) Z Test Not Administered NR = Navy Regular ZCB Marriage

M Accelerated promotion plus buddy program and training or skill guarantee.



02R ASVAB Enlistment Valid From 01-Jun-2000 To 30-Jun-2002 28 Lungs And Chest (Includes Breasts)

NV = Navy Reserve ZCC Personal hardship

N Accelerated promotion plus training or skill guarantee.



02S ASVAB Enlistment Valid From 01-Jun-2000 To 30-Jun-2002



NZ = Navy, component unknown ZDA Failure to graduate from high school

P Accelerated promotion plus buddy program.



02T ASVAB Enlistment Valid From 01-Jul-2002 To 31-Dec-2050 29 Vascular System (Varicosities, Etc.)

CR = Coast Guard Regular ZDB Pursuit of higher education

Q Training or skill guarantee plus unit or geographic location and buddy program.



02U ASVAB Enlistment Valid From 01-Jul-2002 To 31-Dec-2050 30 Anus And Rectum (Hemorrhoids, Fistulae) (Prostate If Indicated)

CV = Coast Guard Reserve ZDC Religious training or appointment as an ordained minister

R Unit or geographic location plus buddy program.



02V ASVAB Enlistment Valid From 01-Jul-2002 To 31-Dec-2050 31 Abdomen And Viscera (Include Hernia)

CZ = Coast Guard, component unknown ZEA Enlisted in another service

S Unit or geographic location.



02W ASVAB Enlistment Valid From 01-Jul-2002 To 31-Dec-2050 32 External Genitalia (Genitourinary)

ZZ = Unknown service/component ZEB Recruiting error

T Training or skill guarantee plus unit or geographic location.



03D CAT ASVAB Enlistment Valid From 01-Aug-1998 To 30-Apr-2004 33 Upper Extremities


ZEC Enlistment misunderstanding

U Training or skill guarantee plus buddy program.



03E CAT ASVAB Enlistment Valid From 01-May-2004 To 31-Dec-2050 34 Lower Extremities (Except Feet)


ZED No longer qualified for option and declines alternate

V Buddy program.



03R ASVAB Enlistment Valid From 01-Jun-2000 To 30-Jun-2002 35 Feet


ZEE Temporarily disqualified through loss of original and declines alternate

W Training or skill guarantee.



03S ASVAB Enlistment Valid From 01-Jun-2000 To 30-Jun-2002 36 Spine, Other Musculoskeletal


ZFA Other reason

X Other.



03T ASVAB Enlistment Valid From 01-Jul-2002 To 31-Dec-2050 37 Identifying Body Marks, Scars, Tattoos


ZKC Transfer to Person Ready Reserve or enlisted into another component of the same service

Y Not applicable.



03U ASVAB Enlistment Valid From 01-Jul-2002 To 31-Dec-2050 38 Skin, Lymphatic, Allergies


ZZY Drug and Alcohol Testing positive results - enlistment data removed (USMEPCOM use only)






03V ASVAB Enlistment Valid From 01-Jul-2002 To 31-Dec-2050 39 Neurological


ZZZ Exceeded time in Delayed Entry Program (USMEPCOM use only)






03W ASVAB Enlistment Valid From 01-Jul-2002 To 31-Dec-2050 40 Psychiatric











04D CAT ASVAB Enlistment Valid From 01-Aug-1998 To 30-Apr-2004 41 Pelvic (Female Only)











04E CAT ASVAB Enlistment Valid From 01-May-2004 To 31-Dec-2050 42 Endrocrine System











15F ASVAB Enlistment Valid From 01-Apr-1993 To 31-Dec-2050 43 Dental Defects And Disease











15G ASVAB Enlistment Valid From 01-Apr-1993 To 31-Dec-2050 46 Urine - HCG











15H ASVAB Enlistment Valid From 01-Apr-1993 To 31-Dec-2050 47 Hemoglobin/Hematocrit











16F ASVAB Enlistment Valid From 01-Apr-1993 To 31-Dec-2050 48 Blood Type











16G ASVAB Enlistment Valid From 01-Apr-1993 To 31-Dec-2050 49 HIV Test Positive











17F ASVAB Enlistment Valid From 01-Apr-1993 To 31-Dec-2050 50 Drugs











17G ASVAB Enlistment Valid From 01-Apr-1993 To 31-Dec-2050 51 Alcohol Test Positive











18F Student ASVAB Enlistment Valid From 01-Apr-1993 To 30-Jun-2002 52 Other Tests











18G Student ASVAB Enlistment Valid From 01-Apr-1993 To 30-Jun-2002 53 Height











18H Student ASVAB Enlistment Valid From 01-Apr-1993 To 30-Jun-2002 54 Weight, Body Build











18S Student ASVAB Enlistment Valid From 01-Jun-2000 To 30-Jun-2002 55 Body Fat Percentage











19F Student ASVAB Enlistment Valid From 01-Apr-1993 To 30-Jun-2002 56 Temperature











19G Student ASVAB Enlistment Valid From 01-Apr-1993 To 30-Jun-2002 57 Pulse











19R Student ASVAB Enlistment Valid From 01-Jun-2000 To 30-Jun-2002 58 Blood Pressure











20A ASVAB Enlistment Valid From 01-Oct-1993 To 01-Jan-2002 59 Red/Green Test











20B ASVAB Enlistment Valid From 01-Oct-1993 To 01-Jan-2002 60 Other Vision Test











21A ASVAB Enlistment Valid From 01-Oct-1993 To 01-Jan-2002 61 Distant Vision











21B ASVAB Enlistment Valid From 01-Oct-1993 To 01-Jan-2002 62 Refraction











22A ASVAB Enlistment Valid From 01-Oct-1993 To 01-Jan-2002 63 Near Vision











22B ASVAB Enlistment Valid From 01-Oct-1993 To 01-Jan-2002 64 Heterophoria











23A ASVAB Enlistment Valid From 31-Jul-2000 To 31-Dec-2001 65 Accommodation











23A (E) ASVAB Enlistment Valid From 01-Jan-2002 To 30-Jun-2002 66 Color Vision











23A (S) Student ASVAB Enlistment Valid From 01-Jul-2002 To 30-Apr-2004 67 Depth Perception











23B ASVAB Enlistment Valid From 31-Jul-2000 To 31-Dec-2001 68 Field Of Vision











23B (E) ASVAB Enlistment Valid From 01-Jan-2002 To 30-Jun-2002 69 Night Vision











23B (S) Student ASVAB Enlistment Valid From 01-Jul-2002 To 30-Apr-2004 70 Intraocular Tension











23F Student ASVAB Enlistment Valid From 01-May-2004 To 31-Dec-2050 71 Audiometer (Hearing)











23G Student ASVAB Enlistment Valid From 01-May-2004 To 31-Dec-2050













23T Student ASVAB Enlistment Valid From 01-Jul-2002 To 30-Apr-2004













23U Student ASVAB Enlistment Valid From 01-Jul-2002 To 30-Apr-2004













24A ASVAB Enlistment Valid From 31-Jul-2000 To 31-Dec-2001













24A (E) ASVAB Enlistment Valid From 01-Jan-2002 To 30-Jun-2002













24A (S) Student ASVAB Enlistment Valid From 01-Jul-2002 To 30-Apr-2004













24B ASVAB Enlistment Valid From 31-Jul-2000 To 31-Dec-2001













24B (E) ASVAB Enlistment Valid From 01-Jan-2002 To 30-Jun-2002













24B (S) Student ASVAB Enlistment Valid From 01-Jul-2002 To 30-Apr-2004













24F Student ASVAB Enlistment Valid From 01-May-2004 To 31-Dec-2050













24G Student ASVAB Enlistment Valid From 01-May-2004 To 31-Dec-2050













24V Student ASVAB Enlistment Valid From 01-Jul-2002 To 30-Apr-2004













24W Student ASVAB Enlistment Valid From 01-Jul-2002 To 30-Apr-2004













25A ASVAB Enlistment Valid From 31-Jul-2000 To 30-Apr-2004













25B ASVAB Enlistment Valid From 31-Jul-2000 To 30-Apr-2004













25F ASVAB Enlistment Valid From 01-May-2004 To 31-Dec-2050













25G ASVAB Enlistment Valid From 01-May-2004 To 31-Dec-2050













26A ASVAB Enlistment Valid From 31-Jul-2000 To 30-Apr-2004













26B ASVAB Enlistment Valid From 31-Jul-2000 To 30-Apr-2004













26F ASVAB Enlistment Valid From 01-May-2004 To 31-Dec-2050













26G ASVAB Enlistment Valid From 01-May-2004 To 31-Dec-2050













27A ASVAB Enlistment Valid From 31-Jul-2000 To 30-Apr-2004













27B ASVAB Enlistment Valid From 31-Jul-2000 To 30-Apr-2004













27F ASVAB Enlistment Valid From 01-May-2004 To 31-Dec-2050













27G ASVAB Enlistment Valid From 01-May-2004 To 31-Dec-2050













28C ASVAB Enlistment Valid From 31-Jul-2000 To 30-Apr-2004













28I ASVAB Enlistment Valid From 01-May-2004 To 31-Dec-2050










Sheet 5: PULHES
POSITION 1 POSITION 2
Element Name Notes OPTIONAL ALPHA PHYSICAL PROFILE MODIFIER
0 Cannot Be Determined R The condition is considered remediable, the correction or treatment of the condition is medically advisable, and correction usually will result in a higher physical capacity.
1 Possesses A High Level Of Medical Fitness T The condition is temporary and that upon further healing or convalescence a higher physical profile capacity will prevail.
2 Possesses Some Medical Condition Of Physical Defect That May Require Some Activity Limitation P The condition is considered disqualifying and permanent in nature and is assigned upon evaluation in accordance with applicable directives.
3 Has One Or More Medical Conditions Or Physical Defects That May Require Significant Limitations E The initial audiogram is questionable disqualifying of enlistment.

Sheet 6: Youth Program
How to read this 3 byte field


1st byte Youth Program--sponsoring service


2nd byte Youth Program


3rd byte Youth Program--number of years attended


Name Definition Length Codes Code Definition
Youth Program Service youth program Person was affiliated with. 1 A Junior Reserve Officer Training Corps - 3 year program



B Junior Reserve Officer Training Corps - 4 year program



C Reserve Officer Training Corps - 1 year program



D Reserve Officer Training Corps - 2 year program



E Reserve Officer Training Corps - 3 year program



F Reserve Officer Training Corps - 4 year program



G Civil Air Patrol - SPAATZ Award



H Civil Air Patrol - EARHART Award



J Civil Air Patrol - MITCHELL Award



K US Naval Sea Cadet - Recruit



L US Naval Sea Cadet - Apprentice



M US Naval Sea Cadet - Seaman



X Other



Y Not Applicable
Youth Program--sponsoring service Military, security, police, or paramilitary forces, capable of functioning as an offensive or defensive fighting organization sponsoring a youth program. 1 A US Army



F US Air Force



M US Marine Corps



N US Navy



P US Coast Guard
File Typeapplication/vnd.openxmlformats-officedocument.spreadsheetml.sheet
File Modified0000-00-00
File Created0000-00-00
© 2025 OMB.report | Privacy Policy