Contextual Data Readiness

Schema crosswalk and join-key reference for ANAM × DD2795 × DD2796
Primary Join Key:  DODID (DD2795 / DD2796)    DOD_id (ANAM) — 9-digit DoD Electronic Data Interchange Personal Identifier (EDIPI).
Secondary Join Key:  SSN / SSN_flag — Use when EDIPI is missing.  |  Composite fallback: LNAME + FNAME + DOB + SEX  (lower confidence — use only if DODID unavailable and SSN not permitted).
Note: DD2795/DD2796 cover all deployers (pre/post); ANAM covers the cognitive-testing subset. Not every DD2795 record will have an ANAM record, and vice versa.
DD2795

DD2795 – Pre-Deployment Health Assessment

251
Total Fields
115
Sections
12
Domains
Browse Schema
DD2796

DD2796 – Post-Deployment Health Assessment

402
Total Fields
182
Sections
13
Domains
Browse Schema
ANAM

ANAM – Automated Neuropsychological Assessment Metrics

534
Total Fields
17
Sections
8
Domains
Browse Schema
DD2900

DD2900 - Post-Deployment Health Re-Assessment

331
Total Fields
165
Sections
12
Domains
Browse Schema
Match Type Breakdown
Match TypeFields%
Primary Join Key 1 0.1%
Secondary Join Key 1 0.1%
Exact Match (all same field name) 174 17.3%
Semantic Match – All 3 Schemas 9 0.9%
Semantic Match – DD2795 & DD2796 1 0.1%
Semantic Match – DD2796 & ANAM 11 1.1%
Unique to DD2795 66 6.6%
Unique to DD2796 209 20.8%
Unique to ANAM 528 52.5%
Unique to DD2900 6 0.6%
Domain Coverage Matrix
Show columns:
Domain DD2795 DD2796 ANAM DD2900 Shared
ADMIN 19 19 7 19 19
COGNITIVE 1 1 392 1 1
DEMOGRAPHICS 16 16 9 16 16
DEPLOYMENT 24 36 11 20 21
EXPOSURE_ENVIRONMENT 1 58 – 37 37
IDENTITY 1 1 6 1 1
MENTAL_HEALTH 57 60 34 60 60
OTHER 59 90 33 75 72
PHYSICAL_SYMPTOMS 7 24 6 23 23
PROVIDER 14 14 – 14 14
REFERRAL_ACTION 26 41 – 40 40
STRESSORS 17 17 – 17 17
SUBSTANCE_USE 10 10 – 10 10
TBI_BLAST – 19 59 – 5
Fields Shared Across Schemas (2+ schemas) – Quick View  View All Shared
Concept Match Type DD2795 Field DD2796 Field ANAM Field DD2900 Field Domain
DoD/EDIPI ID (Primary Join Key) Primary Join Key DODID DODID DOD_id DODID IDENTITY
Last Name Exact Match (all same field name) LNAME LNAME sub_tbdFirstName LNAME DEMOGRAPHICS
First Name Exact Match (all same field name) FNAME FNAME sub_tbdFirstName FNAME DEMOGRAPHICS
Middle Initial Exact Match (all same field name) MI MI sub_tbdMiddleName MI DEMOGRAPHICS
Date of Birth Exact Match (all same field name) DOB DOB sub_tbdDOB DOB DEMOGRAPHICS
Sex / Gender Semantic Match – All 3 Schemas SEX SEX sub Sex SEX DEMOGRAPHICS
Pay Grade / Rank Semantic Match – All 3 Schemas GRADE GRADE sub tbdPayGrade GRADE DEMOGRAPHICS
Military Service Branch Semantic Match – All 3 Schemas FORM_SERVICE FORM_SERVICE Service FORM_SERVICE DEPLOYMENT
Reserve/Guard/Active Component Exact Match (all same field name) FORM_COMPONENT FORM_COMPONENT FORM_COMPONENT DEPLOYMENT
Unit Name Exact Match (all same field name) UNIT_NAME UNIT_NAME sub_tbdUIC UNIT_NAME DEMOGRAPHICS
Unit Location Exact Match (all same field name) UNIT_LOC UNIT_LOC sub_tbdOperation UNIT_LOC DEMOGRAPHICS
Phone Number Semantic Match – All 3 Schemas PHONE PHONE sub tbdPhone1 PHONE DEMOGRAPHICS
Assessment/Event Date Semantic Match – All 3 Schemas D_EVENT D_EVENT Overall_assessment_date D_EVENT DEPLOYMENT
Post-Deployment Arrival Date Semantic Match – DD2796 & ANAM D_ARRIVAL Overall_assessment_date DEPLOYMENT
Operation Name Semantic Match – All 3 Schemas OPERATION_NAME OPERATION_NAME sub tbdOperation DEPLOYMENT
Country of Deployment Semantic Match – DD2795 & DD2796 COUNTRY COUNTRY1 sub_tbdOperation DEPLOYMENT
PCL-C / PTSD Screen – Total Severity Score Semantic Match – All 3 Schemas PCLC_SCORE PCLC_SCORE pcc_PCLSum PCLC_SCORE MENTAL_HEALTH
PCL-C / Post-Traumatic Stress – Symptom Cluster Q1-5 Semantic Match – All 3 Schemas PCLC_MATRIX PCLC_MATRIX pcc_Set1 PCLC_MATRIX MENTAL_HEALTH
Depression Score (PHQ-8 vs ANAM Mood Scale) Semantic Match – All 3 Schemas PHQ8_SCORE PHQ8_SCORE moo_DEPRESSION_PercAdjCat PHQ8_SCORE MENTAL_HEALTH
PHQ-8 Item-Level Matrix Exact Match (all same field name) PHQ8_MATRIX PHQ8_MATRIX PHQ8_MATRIX MENTAL_HEALTH
Anger Score (ANAM Mood Scale) Unique to ANAM ANGRY_OUTBURSTS ANGRY_OUTBURSTS moo_ANGER_PercAdjCat ANGRY_OUTBURSTS COGNITIVE
Sleep Disturbance / Sleepiness Scale Semantic Match – DD2796 & ANAM TROUBLE_SLEEPING slp_SubjResp TROUBLE_SLEEPING PHYSICAL_SYMPTOMS
Headache / Total NSI Symptom Severity (DD vs ANAM) Semantic Match – DD2796 & ANAM HEADACHES nsi_SymptomSeverity HEADACHES PHYSICAL_SYMPTOMS
Memory / Cognitive NSI Symptom Severity Semantic Match – DD2796 & ANAM MEMORY_PROBLEMS nsi_COGNITIVE_SymptomSeverity MEMORY_PROBLEMS OTHER
Concentration / Cognitive NSI Symptom Severity Semantic Match – DD2796 & ANAM TROUBLE_CONCENTRATING nsi_COGNITIVE_SymptomSeverity TROUBLE_CONCENTRATING OTHER
Referred for PTSD Exact Match (all same field name) REF_PTSD REF_PTSD REF_PTSD MENTAL_HEALTH
Referred for Depression Exact Match (all same field name) REF_DEPRESSION REF_DEPRESSION REF_DEPRESSION MENTAL_HEALTH
Suicide Risk Assessment Exact Match (all same field name) SUICIDE_RISK SUICIDE_RISK SUICIDE_RISK MENTAL_HEALTH
Violence Risk Assessment Exact Match (all same field name) VIOLENCE_RISK VIOLENCE_RISK VIOLENCE_RISK OTHER
PTSD – Nightmares Exact Match (all same field name) NIGHTMARES NIGHTMARES NIGHTMARES MENTAL_HEALTH
PTSD – Intrusive Memories Exact Match (all same field name) MEMORIES MEMORIES MEMORIES MENTAL_HEALTH
PTSD – Avoidance of Situations Exact Match (all same field name) AVOID_SITUATIONS AVOID_SITUATIONS AVOID_SITUATIONS MENTAL_HEALTH
PTSD – Hypervigilance Exact Match (all same field name) ON_GUARD ON_GUARD ON_GUARD OTHER
PHQ – Depressed mood weeks Exact Match (all same field name) WEEKS_DEPRESSED WEEKS_DEPRESSED WEEKS_DEPRESSED MENTAL_HEALTH
PHQ – Anhedonia weeks Exact Match (all same field name) WEEKS_LITTLE_INTEREST WEEKS_LITTLE_INTEREST WEEKS_LITTLE_INTEREST MENTAL_HEALTH
Blast Exposure Semantic Match – DD2796 & ANAM EXP_BLAST tbq BLAST_NumEvents TBI_BLAST
Immediate LOC after blast Semantic Match – DD2796 & ANAM IMMED_LOC tbq Unc1min TBI_BLAST
Immediate Memory Loss Semantic Match – DD2796 & ANAM IMMED_MEMORY tbq NotRemembering TBI_BLAST
Dazed / Confused after event Semantic Match – DD2796 & ANAM IMMED_DAZED tbq Dazed TBI_BLAST
Number of blast/jolt events Semantic Match – DD2796 & ANAM NUM_JOLT tbq BLAST_NumEvents TBI_BLAST