APHDR Data Sets

---

Overview

1.Cover Letter
2.AWD-USAPHC(Prov) Atr
3.Waiver Codes

---

Sheet 1: 1.Cover Letter

This tab, 1.Cover Letter, descripes the information in the other two tabs of this document.
Tab		Description
2.AWD-USAPHC(Prov) Atr		Report on the attributes available for selection. Explaination of the report column heads appears below, titled Column Definitions.
3.Waiver Codes		Codes supplied by AWD that were copied from the MEPCOM MIRS waiver code list.
	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	NIMH (or USAPHC(Prov)) Approval	User has accepted this as a valid element for their use-drop down list-Yes or No
H	NIMH (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.

---

Sheet 2: 2.AWD-USAPHC(Prov) Atr

Source

Source Tab Ord

Source Table

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

AWD

1

AWD

1

SSN

DI

Yes

varchar2(9)

Social security numbers

AWD

1

AWD

2

FC

Yes

varchar2(3)

Felony waiver codes (see the MEPCOM MIRS waiver code list) either DEA, DEB, DFA, DFB

See waiver codes tab

AWD

1

AWD

3

FELONY_RES

Yes

varchar2(3)

Felony result (either a "conviction" or "other adverse disposition")

AWD

1

AWD

4

PUBLIC_DES

Yes

varchar2

Description of the offense that required the waiver

AWD

1

AWD

5

ADULT_OFFE

Yes

varchar2(8)

Adult offense indicator at the time the offense of concern was committed, concerning the age of the Soldier: either "adult" or "juvenile"

AWD

1

AWD

6

DOD_CODE

Yes

varchar2(3)

USACHPPM-KLCOX: Note: this is not an exhaustive list of the codes for this element. Also, there can be more than one waiver, so we must arrange to receive all codes for a given individual, which may mean separate records, i.e., a one-to-many relationship between individuals and records. DoD Waiver Code, IAW MEPCOM Reg These are listed in the Waiver Codes tab in this spreadsheet.

See waiver codes tab

AWD

1

AWD

9

MOS

Yes

varchar2(3)

USACHPPM-KLCOX: This is the MOS for which the individual is slated to train, i.e., the job the Army expects them to perform. It may differ from ITAPDB, if the individual was unsuccessful and ended up being trained for a different occupation. Military Occupational Specialty

AWD

1

AWD

11

BIRTHDATE

Yes

date

Date of birth

AWD

1

AWD

19

MEDWAV

Yes

number

USACHPPM-KLCOX: Though not listed in this document, it is possible to obtain the ICD code for each waivered medical condition. We would like to receive those data. medical waivers

AWD

1

AWD

20

DATWAV

Yes

varchar2(3)

drug / alcohol test waivers FDA to FDE

See waiver codes tab

AWD

1

AWD

21

CONDWAV

Yes

varchar2(3)

conduct waivers, including misconduct (misdemeanors) and major misconduct (felonies)

See waiver codes tab

AWD

1

AWD

22

ADMINWAV

Yes

number

administrative waivers

AWD

1

AWD

23

ICD-9_CODE

Yes

varchar2(7)

ICD-9 code

ICD-9 Code in the format V123.45

AWD

1

AWD

24

FY

Yes

varchar2(4)

FY09 FY08 FY07 FY06 FY05 FY04 FY03

Fiscal Year

---

Sheet 3: 3.Waiver Codes

	The following codes were copied from the MEPCOM MIRS waiver code list
CODE	EXPLANATION
AYA	Age maximum exceeded for enlistment purposes waiver granted by the highest authority l level.
AYB	Age maximum exceeded for enlistment purposes waiver granted by the Recruiting Command Headquarters level.
AYC	Age maximum exceeded for enlistment purposes waiver granted by the US Marine Corps Command level.
AYD	Age maximum exceeded for enlistment purposes waiver granted by the US Army Brigade, US Marine Corps District, US Navy Area, or US Air Force Group level.
AYE	Age maximum exceeded for enlistment purposes waiver granted by the US Army Battalion, US Navy District, US Air Force Squadron level, or US Marine Corps Recruiting Station.
AYF	Age maximum exceeded for enlistment purposes waiver granted by the US Coast Guard Recruiting Center.
BAA	Dependency of a military spouse waiver granted by the highest authority level.
BAB	Dependency of a military spouse waiver granted by the Recruiting Command Headquarters level.
BAC	Dependency of a military spouse waiver granted by the US Marine Corps Regional Command level.
BAD	Dependency of a military spouse waiver granted by the US Army Brigade, US Marine Corps District, US Navy Area, or US Air Force Group level.
BAE	Dependency of a military spouse waiver granted by the US Army Battalion, US Navy District, US Air Force Squadron level, or US Marine Corps Recruiting Station.
BAF	Dependency of a military spouse waiver granted by the US Coast Guard Recruiting Center.
BBA	Dependency due to number of dependents waiver granted by the highest authority level.
BBB	Dependency due to number of dependents waiver granted by the Recruiting Command Headquarters level.
BBC	Dependency due to number of dependents waiver granted by the US Marine Corps Regional Command level.
BBD	Dependency due to number of dependents waiver granted by the US Army Brigade, US Marine Corps District, US Navy Area, or US Air Force Group level.
BBE	Dependency due to number of dependents waiver granted by the US Army Battalion, US Navy District, US Air Force Squadron level, or US Marine Corps Recruiting Station.
BBF	Dependency due to number of dependents waiver granted by the US Coast Guard Recruiting Center.
CYA	Mental qualification – meets ASVAB testing requirements (AFQT & sub test) waiver granted by the highest authority level.
CYB	Mental qualification – meets ASVAB testing requirements (AFQT & sub test) waiver granted by the Recruiting Command Headquarters level.
CYC	Mental qualification – meets ASVAB testing requirements (AFQT & sub test) waiver granted by the US Marine Corps Regional Command level.
CYD	Mental qualification – meets ASVAB testing requirements (AFQT & sub test) waiver granted by the US Army Brigade, US Marine Corps District, US Navy Area, or US Air Force Group level.
CYE	Mental qualification – meets ASVAB testing requirements (AFQT & sub test) waiver granted by the US Army Battalion, US Navy District, US Marine Corps Recruiting Station, or US Air Force Squadron level.
CYF	Mental qualification – meets ASVAB testing requirements (AFQT & sub test) waiver granted by the US Coast Guard Recruiting Center.
DAA	Law violations of adjudicated minor traffic offense(s) waiver granted by the highest authority level.
DAB	Law violations of adjudicated minor traffic offense(s) waiver granted by the Recruiting Command Headquarters level.
DAC	Law violations of adjudicated minor traffic offense(s) waiver granted by the US Marine Corps Regional Command level.
DAD	Law violations of adjudicated minor traffic offense(s) waiver granted by the US Army Brigade, US Marine Corps District, US Navy Area, or US Air Force Group level.
DAE	Law violations of adjudicated minor traffic offense(s) waiver granted by the US Army Battalion, US Navy District, US Marine Corps Recruiting Station, or US Air Force Squadron level.
DAF	Law violations of adjudicated minor traffic offense(s) waiver granted by the US Coast Guard Recruiting Center.
DBA	Law violations of adjudicated serious traffic offense(s) waiver granted by the highest authority level.
DBB	Law violations of adjudicated serious traffic offense(s) waiver granted by the Recruiting Command Headquarters level.
DBC	Law violations of adjudicated serious traffic offense(s) waiver granted by the US Marine Corps Regional Command level.
DBD	Law violations of adjudicated serious traffic offense(s) waiver granted by the US Army Brigade, US Marine Corps District, US Navy Area, or US Air Force Group level.
DBE	Law violations of adjudicated serious traffic offense(s) waiver granted by the US Army Battalion, US Navy District, US Marine Corps Recruiting Station, or US Air Force Squadron level.
DBF	Law violations of adjudicated serious traffic offense(s) waiver granted by the US Coast Guard Recruiting Center.
DCA	Law violations of adjudicated minor non-traffic offense(s) waiver granted by the highest authority level.
DCB	Law violations of adjudicated minor non-traffic offense(s) waiver granted by the Recruiting Command Headquarters level.
DCC	Law violations of adjudicated minor non-traffic offense(s) waiver granted by the US Marine Corps Regional Command level.
DCD	Law violations of adjudicated minor non-traffic offense(s) waiver granted by the US Army Brigade, US Marine Corps District, US Navy Area, or US Air Force Group level.
DCE	Law violations of adjudicated minor non-traffic offense(s) waiver granted by the US Army Battalion, US Navy District, US Marine Corps Recruiting Station, or US Air Force Squadron level.
DCF	Law violations of adjudicated minor non-traffic offense(s) waiver granted by the US Coast Guard Recruiting Center.
DDA	Law violations of adjudicated serious non-traffic offense(s) waiver granted by the highest authority level.
DDB	Law violations of adjudicated serious non-traffic offense(s) waiver granted by the Recruiting Command Headquarters level.
DDC	Law violations of adjudicated serious non-traffic offense(s) waiver granted by the US Marine Corps Regional Command level.
DDD	Law violations of adjudicated serious non-traffic offense(s) waiver granted by the US Army Brigade, US Marine Corps District, US Navy Area, or US Air Force Group level.
DDE	Law violations of adjudicated serious non-traffic offense(s) waiver granted by the US Army Battalion, US Navy District, US Marine Corps Recruiting Station, or US Air Force Squadron level.
DDF	Law violations of adjudicated serious non-traffic offense(s) waiver granted by the US Coast Guard Recruiting Center.
DEA	Law violations of adjudicated felony offense(s) as an adult waiver granted by the highest authority level.
DEB	Law violations of adjudicated felony offense(s) as an adult waiver granted by the Recruiting Command Headquarters level.
DEC	Law violations of adjudicated felony offense(s) as an adult waiver granted by the US Marine Corps Regional Command level.
DED	Law violations of adjudicated felony offense(s) as an adult waiver granted by the US Army Brigade, US Marine Corps District, US Navy Area, or US Air Force Group level.
DEE	Law violations of adjudicated felony offense(s) as an adult waiver granted by the US Army Battalion, US Navy District, US Marine Corps Recruiting Station, or US Air Force Squadron level.
DEF	Law violations of adjudicated felony offense(s) as an adult waiver granted by the US Coast Guard Recruiting Center.
DFA	Law violations of adjudicated felony offense(s) as a juvenile waiver granted by the highest authority level.
DFB	Law violations of adjudicated felony offense(s) as a juvenile waiver granted by the Recruiting Command Headquarters level.
DFC	Law violations of adjudicated felony offense(s) as a juvenile waiver granted by the US Marine Corps Regional Command level.
DFD	Law violations of adjudicated felony offense(s) as a juvenile waiver granted by the US Army Brigade, US Marine Corps District, US Navy Area, or US Air Force Group level.
DFE	Law violations of adjudicated felony offense(s) as a juvenile waiver granted by the US Army Battalion, US Navy District, US Marine Corps Recruiting Station, or US Air Force Squadron level.
DFF	Law violations of adjudicated felony offense(s) as a juvenile waiver granted by the US Coast Guard Recruiting Center.
EEA	Previous military separation, does not apply to delayed entry program separation, re-enlistment eligibility reason waiver granted by the highest authority level.
EAB	Previous military separation, does not apply to delayed entry program separation, re-enlistment eligibility reason waiver granted by the Recruiting Command Headquarters level.
EAC	Previous military separation, does not apply to delayed entry program separation, re-enlistment eligibility reason waiver granted by the US Marine Corps Regional Command level.
EAD	Previous military separation, does not apply to delayed entry program separation, re-enlistment eligibility reason waiver granted by the US Army Brigade, US Marine Corps District, US Navy Area, or US Air Force Group level.
EAE	Previous military separation, does not apply to delayed entry program separation, re-enlistment eligibility reason waiver granted by the US Army Battalion, US Navy District, US Marine Corps Recruiting Station, or US Air Force Squadron level.
EAF	Previous military separation, does not apply to delayed entry program separation, re-enlistment eligibility reason waiver granted by the US Coast Guard Recruiting Center.
EBA	Previous military separation, does not apply to delayed entry program separation, pay grade waiver granted by the highest authority level.
EBB	Previous military separation, does not apply to delayed entry program separation, pay grade waiver granted by the Recruiting Command Headquarters level.
EBC	Previous military separation, does not apply to delayed entry program separation, pay grade waiver granted by the US Marine Corps Regional Command level.
EBD	Previous military separation, does not apply to delayed entry program separation, pay grade waiver granted by the US Army Brigade, US Marine Corps District, US Navy Area, or US Air Force Group level.
EBE	Previous military separation, does not apply to delayed entry program separation, pay grade waiver granted by the US Army Battalion, US Navy District, US Marine Corps Recruiting Station, or US Air Force Squadron level.
EBF	Previous military separation, does not apply to delayed entry program separation, pay grade waiver granted by the US Coast Guard Recruiting Center.
ECA	Previous military separation, does not apply to delayed entry program separation, lost time waiver granted by the highest authority level.
ECB	Previous military separation, does not apply to delayed entry program separation, lost time waiver granted by the Recruiting Command Headquarters level.
ECC	Previous military separation, does not apply to delayed entry program separation, lost time waiver granted by the US Marine Corps Regional Command level.
ECD	Previous military separation, does not apply to delayed entry program separation, lost time waiver granted by the US Army Brigade, US Marine Corps District, US Navy Area, or US Air Force Group level.
ECE	Previous military separation, does not apply to delayed entry program separation, lost time waiver granted by the US Army Battalion, US Navy District, US Marine Corps Recruiting Station, or US Air Force Squadron level.
ECF	Previous military separation, does not apply to delayed entry program separation, lost time waiver granted by the US Coast Guard Recruiting Center.
EDA	Previous military separation, does not apply to delayed entry program separation, condition that existed prior to service waiver granted by the highest authority level.
EDB	Previous military separation, does not apply to delayed entry program separation, condition that existed prior to service waiver granted by the Recruiting Command Headquarters level.
EDC	Previous military separation, does not apply to delayed entry program separation, condition that existed prior to service waiver granted by the US Marine Corps Regional Command level.
EDD	Previous military separation, does not apply to delayed entry program separation, condition that existed prior to service waiver granted by the US Army Brigade, US Marine Corps District, US Navy Area, or US Air Force Group level.
EDE	Previous military separation, does not apply to delayed entry program separation, condition that existed prior to service waiver granted by the US Army Battalion, US Navy District, US Marine Corps Recruiting Station, or US Air Force Squadron level.
EDF	Previous military separation, does not apply to delayed entry program separation, condition that existed prior to service waiver granted by the US Coast Guard Recruiting Center.
EEA	Previous military separation, does not apply to delayed entry program separation, skill requirement waiver granted by the highest authority level.
EEB	Previous military separation, does not apply to delayed entry program separation, skill requirement waiver granted by the Recruiting Command Headquarters level.
EEC	Previous military separation, does not apply to delayed entry program separation, skill requirement waiver granted by the US Marine Corps Regional Command level.
EED	Previous military separation, does not apply to delayed entry program separation, skill requirement waiver granted by the US Army Brigade, US Marine Corps District, US Navy Area, or US Air Force Group level.
EEE	Previous military separation, does not apply to delayed entry program separation, skill requirement waiver granted by the US Army Battalion, US Navy District, US Marine Corps Recruiting Station, or US Air Force Squadron level.
EEF	Previous military separation, does not apply to delayed entry program separation, skill requirement waiver granted by the US Coast Guard Recruiting Center.
FAA	Drug involvement not considered a law violation with alcohol abuse waiver granted by the highest authority level.
FAB	Drug involvement not considered a law violation with alcohol abuse waiver granted by the Recruiting Command Headquarters level.
FAC	Drug involvement not considered a law violation with alcohol abuse waiver granted by the US Marine Corps Regional Command level.
FAD	Drug involvement not considered a law violation with alcohol abuse waiver granted by the US Army Brigade, US Marine Corps District, US Navy Area, or US Air Force Group level.
FAE	Drug involvement not considered a law violation with alcohol abuse waiver granted by the US Army Battalion, US Navy District, US Marine Corps Recruiting Station, or US Air Force Squadron level.
FAF	Drug involvement not considered a law violation with alcohol abuse waiver granted by the US Coast Guard Recruiting Center.
FBA	Drug involvement not considered a law violation with marijuana usage waiver granted by the highest authority level.
FBB	Drug involvement not considered a law violation with marijuana usage waiver granted by the Recruiting Command Headquarters level.
FBC	Drug involvement not considered a law violation with marijuana usage waiver granted by the US Marine Corps Regional Command level.
FBD	Drug involvement not considered a law violation with marijuana usage waiver granted by the US Army Brigade, US Marine Corps District, US Navy Area, or US Air Force Group level.
FBE	Drug involvement not considered a law violation with marijuana usage waiver granted by the US Army Battalion, US Navy District, US Marine Corps Recruiting Station, or US Air Force Squadron level.
FBF	Drug involvement not considered a law violation with marijuana usage waiver granted by the US Coast Guard Recruiting Center.
FCA	Drug involvement not considered a law violation with other drug usage waiver granted by the highest authority level.
FCB	Drug involvement not considered a law violation with other drug usage waiver granted by the Recruiting Command Headquarters level.
FCC	Drug involvement not considered a law violation with other drug usage waiver granted by the US Marine Corps Regional Command level.
FCD	Drug involvement not considered a law violation with other drug usage waiver granted by the US Army Brigade, US Marine Corps District, US Navy Area, or US Air Force Group level.
FCE	Drug involvement not considered a law violation with other drug usage waiver granted by the US Army Battalion, US Navy District, US Marine Corps Recruiting Station, or US Air Force Squadron level.
FCF	Drug involvement not considered a law violation with other drug usage waiver granted by the US Coast Guard Recruiting Center.
FDA	Drug involvement not considered a law violation with drug and alcohol test positive waiver granted by the highest authority level.
FDB	Drug involvement not considered a law violation with drug and alcohol test positive waiver granted by the Recruiting Command Headquarters level.
FDC	Drug involvement not considered a law violation with drug and alcohol test positive waiver granted by the US Marine Corps Regional Command level.
FDD	Drug involvement not considered a law violation with drug and alcohol test positive waiver granted by the US Army Brigade, US Marine Corps District, US Navy Area, or US Air Force Group level.
FDE	Drug involvement not considered a law violation with drug and alcohol test positive waiver granted by the US Army Battalion, US Navy District, US Marine Corps Recruiting Station, or US Air Force Squadron level.
FDF	Drug involvement not considered a law violation with drug and alcohol test positive waiver granted by the US Coast Guard Recruiting Center.
HAA	Medical disqualification height waiver by the highest authority level.
HAB	Medical disqualification height waiver granted by the Recruiting Command Headquarters level.
HAC	Medical disqualification height waiver granted by the US Marine Corps Regional Command level.
HAD	Medical disqualification height waiver granted by the US Army Brigade, US Marine Corps District, US Navy Area, or US Air Force Group level.
HAE	Medical disqualification height waiver granted by the US Army Battalion, US Navy District, US Marine Corps Recruiting Station, or US Air Force Squadron level.
HAF	Medical disqualification height waiver granted by the US Coast Guard Recruiting Center.
HBA	Medical disqualification weight waiver granted by the highest authority level.
HBB	Medical disqualification weight waiver granted by the Recruiting Command Headquarters level.
HBC	Medical disqualification weight waiver granted by the US Marine Corps Regional Command level.
HBD	Medical disqualification weight waiver granted by the US Army Brigade, US Marine Corps District, US Navy Area, or US Air Force Group level.
HBE	Medical disqualification weight waiver granted by the US Army Battalion, US Navy District, US Marine Corps Recruiting Station, or US Air Force Squadron level.
HBF	Medical disqualification weight waiver granted by the US Coast Guard Recruiting Center.
HCA	Medical disqualification Disease Classification (ICD-9) waiver granted by the highest authority level.
HCB	Medical disqualification Disease Classification (ICD-9) waiver granted by the Recruiting Command Headquarters level.
HCC	Medical disqualification Disease Classification (ICD-9) waiver granted by the US Marine Corps Regional Command level.
HCD	Medical disqualification Disease Classification (ICD-9) waiver granted by the US Army Brigade, US Marine Corps District, US Navy Area, or US Air Force Group level.
HCE	Medical disqualification Disease Classification (ICD-9) waiver granted by the US Army Battalion, US Navy District, US Marine Corps Recruiting Station, or US Air Force Squadron level.
HCF	Medical disqualification Disease Classification (ICD-9) waiver granted by the US Coast Guard Recruiting Center.
JYA	Sole surviving family member waiver granted by the highest authority level.
JYB	Sole surviving family member waiver granted by the Recruiting Command Headquarters level.
JYC	Sole surviving family member waiver granted by the US Marine Corps Regional Command level.
JYD	Sole surviving family member waiver granted by the US Army Brigade, US Marine Corps District, US Navy Area, or US Air Force Group level.
JYE	Sole surviving family member waiver granted by the US Army Battalion, US Navy District, US Marine Corps Recruiting Station, or US Air Force Squadron level.
JYF	Sole surviving family member waiver granted by the US Coast Guard Recruiting Center.
KYA	Minimum education requirement waiver granted by the highest authority level.
KYB	Minimum education requirement waiver granted by the Recruiting Command Headquarters level.
KYC	Minimum education requirement waiver granted by the US Marine Corps Regional Command level.
KYD	Minimum education requirement waiver granted by the US Army Brigade, US Marine Corps District, US Navy Area, or US Air Force Group level.
KYE	Minimum education requirement waiver granted by the US Army Battalion, US Navy District, US Marine Corps Recruiting Station, or US Air Force Squadron level.
KYF	Minimum education requirement waiver granted by the US Coast Guard Recruiting Center.
LYA	Aliens who have traveled or resided in a nation whose interests are inimical to those of the United States (also applies to aliens whose spouse, parent, brother, sister, or children currently reside in such a nation) waiver granted by the highest authority level.
LYB	Aliens who have traveled or resided in a nation whose interests are inimical to those of the United States (also applies to aliens whose spouse, parent, brother, sister, or children currently reside in such a nation) waiver granted by the Recruiting Command Headquarters level.
LYC	Aliens who have traveled or resided in a nation whose interests are inimical to those of the United States (also applies to aliens whose spouse, parent, brother, sister, or children currently reside in such a nation) waiver granted by the US Marine Corps Regional Command level.
LYD	Aliens who have traveled or resided in a nation whose interests are inimical to those of the United States (also applies to aliens whose spouse, parent, brother, sister, or children currently reside in such a nation) waiver granted by the US Army Brigade, US Marine Corps District, US Navy Area, or US Air Force Group level.
LYE	Aliens who have traveled or resided in a nation whose interests are inimical to those of the United States (also applies to aliens whose spouse, parent, brother, sister, or children currently reside in such a nation) waiver granted by the US Army Battalion, US Navy District, US Marine Corps Recruiting Station, or US Air Force Squadron level.
LYF	Aliens who have traveled or resided in a nation whose interests are inimical to those of the United States (also applies to aliens whose spouse, parent, brother, sister, or children currently reside in such a nation) waiver granted by the US Coast Guard Recruiting Center.
MYA	Refusal or failure to complete a loyalty certificate (includes derogatory information entered on a loyalty certificate) waiver granted by the highest authority level.
MYB	Refusal or failure to complete a loyalty certificate (includes derogatory information entered on a loyalty certificate) waiver granted by the Recruiting Command Headquarters level.
MYC	Refusal or failure to complete a loyalty certificate (includes derogatory information entered on a loyalty certificate) waiver granted by the US Marine Corps Regional Command level.
MYD	Refusal or failure to complete a loyalty certificate (includes derogatory information entered on a loyalty certificate) waiver granted by the US Army Brigade, US Marine Corps District, US Navy Area, or US Air Force Group level.
MYE	Refusal or failure to complete a loyalty certificate (includes derogatory information entered on a loyalty certificate) waiver granted by the US Army Battalion, US Navy District, US Marine Corps Recruiting Station, or US Air Force Squadron level.
MYF	Refusal or failure to complete a loyalty certificate (includes derogatory information entered on a loyalty certificate) waiver granted by the US Coast Guard Recruiting Center.
NYA	Conscientious objector waiver granted by the highest authority level.
NYB	Conscientious objector waiver granted by the Recruiting Command Headquarters level.
NYC	Conscientious objector waiver granted by the US Marine Corps Regional Command level.
NYD	Conscientious objector waiver granted by the US Army Brigade, US Marine Corps District, US Navy Area, or US Air Force Group level.
NYE	Conscientious objector waiver granted by the US Army Battalion, US Navy District, US Marine Corps Recruiting Station, or US Air Force Squadron level.
NYF	Conscientious objector waiver granted by the US Coast Guard Recruiting Center.
PYA	Army Service Administrative Waiver – Service unique waiver policy granted at the highest authority level.
PYB	Army Service Administrative Waiver – Service unique waiver policy granted at the Recruiting Headquarters level.
PYD	Army Service Administrative Waiver – Service unique waiver policy granted at the Army Brigade level.
PYE	Army Service Administrative Waiver – Service unique waiver policy granted at the Army Battalion level.
QYA	Air Force Service Administrative Waiver – Service unique waiver policy granted by the highest authority level.
QYB	Air Force Service Administrative Waiver – Service unique waiver policy granted by the Recruiting Headquarters level.
QYD	Air Force Service Administrative Waiver – Service unique waiver policy granted by the U.S. Air Force Group level.
QYE	Air Force Service Administrative Waiver – Service unique waiver policy granted by the USAF Squadron level.
RYA	Navy Service Administrative Waiver – Service unique waiver policy granted at the highest authority level.
RYB	Navy Service Administrative Waiver – Service unique waiver policy granted at the Recruiting Headquarters level.
RYD	Navy Service Administrative Waiver – Service unique waiver policy granted at the Navy Area level.
RYE	Navy Service Administrative Waiver – Service unique waiver policy granted at the Navy district level.
SYA	U.S. Coast Guard Service Administrative Waiver – Service unique waiver policy granted at the Recruiting Center level.
XYA	Marine Corps Service Administrative Waiver – Service unique waiver policy granted at the highest authority level.
XYB	Marine Corps Service Administrative Waiver – Service unique waiver policy granted at the Recruiting Headquarters level.
XYC	Marine Corps Service Administrative Waiver – Service unique waiver policy granted at the Regional Command (USMC only) level.
XYD	Marine Corps Service Administrative Waiver – Service unique waiver policy granted at the USMC District level.
XYE	Marine Corps Service Administrative Waiver – Service unique waiver policy granted at the USMC Recruiting Station level.
XXB	Marine Corps Service Administrative Waiver – USMC Medical Rehabilitation Program (MREP) granted at the Recruiting Headquarters level.
XXE	Marine Corps Service Administrative Waiver – USMC Medical Rehabilitation Program (MREP) granted at the USMC Recruiting Station level.
XXF	Marine Corps Service Administrative Waiver – USMC Medical Rehabilitation Program (MREP) granted at the US Coast Guard Recruiting Center.
YYY	No condition currently exists requiring a waiver; however, there may be administrative conditions that exist.