APHDR Data Sets

Army Public Health Data Repository (APHDR)

DoDSER-NIMH (32).xlsx

APHDR Data Sets

OMB:

Document [xlsx]
Download: xlsx | pdf

Overview

1.Cover Letter
2.DoDSER-2004 NIMH Atr
3.DoDSER-2005-062009 NIMH Atr
4.DoDSER-072009 NIMH Atr

Sheet 1: 1.Cover Letter
This tab, 1.Cover Letter, descripes the information in the other 3 tabs in this file. These 3 tabs correspond to the 3 timeframes of different DoDSER files that will be provided. Explaination of the report column headings appears below, titled Column Definitions.



Tab
Description
2. DoDSER-2004 NIMH Atr Report on the attributes that NIMH selected from the 2004 DoDSER files .
3. DoDSER-2005-062009 NIMH Atr Report on the attributes that NIMH selected from the 2005-062009 DoDSER files .
4. DoDSER-072009 NIMH Atr Report on the attributes that NIMH selected from the 072009 DoDSER files .




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 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.

Sheet 2: 2.DoDSER-2004 NIMH Atr
Source Source Tab Ord SourceTable Source Field Ord FieldName PII/HIPAA Sensitive NIMH Approval NIMH SP2Delta FieldType Nullability Primary Key Title Desc FDM Comments ADS Comment Code Table Reference
DoDSER-A 1 tbDoDSER_Patient_2004 1 ckid
Yes 9/8/2009 int Not Null PK ckid



DoDSER-A 1 tbDoDSER_Patient_2004 2 LoadDate
Yes 9/8/2009 datetime Null
LoadDate



DoDSER-A 1 tbDoDSER_Patient_2004 3 ckWSSoldierID DI Yes 9/8/2009 int Null
ckWSSoldierID



DoDSER-A 1 tbDoDSER_Patient_2004 4 VERS
Yes 9/8/2009 varchar(255) Null
VERS



DoDSER-A 1 tbDoDSER_Patient_2004 5 VERS_DATE
Yes 9/8/2009 datetime Null
VERS_DATE



DoDSER-A 1 tbDoDSER_Patient_2004 6 EVENT_TYPE_COMPLETED
Yes 9/8/2009 varchar(255) Null
EVENT_TYPE_COMPLETED



DoDSER-A 1 tbDoDSER_Patient_2004 7 EVENT_TYPE_HOSPITALIZED
Yes 9/8/2009 varchar(255) Null
EVENT_TYPE_HOSPITALIZED



DoDSER-A 1 tbDoDSER_Patient_2004 8 EVENT_TYPE_EVACUATED
Yes 9/8/2009 varchar(255) Null
EVENT_TYPE_EVACUATED



DoDSER-A 1 tbDoDSER_Patient_2004 9 EVENT_TYPE_OTHER
Yes 9/8/2009 varchar(255) Null
EVENT_TYPE_OTHER



DoDSER-A 1 tbDoDSER_Patient_2004 11 EVENT_SEVERITY_1
Yes 9/8/2009 varchar(255) Null
EVENT_SEVERITY_1



DoDSER-A 1 tbDoDSER_Patient_2004 12 EVENT_SEVERITY_2
Yes 9/8/2009 varchar(255) Null
EVENT_SEVERITY_2



DoDSER-A 1 tbDoDSER_Patient_2004 13 EVENT_SEVERITY_3
Yes 9/8/2009 varchar(255) Null
EVENT_SEVERITY_3



DoDSER-A 1 tbDoDSER_Patient_2004 14 EVENT_SEVERITY_4
Yes 9/8/2009 varchar(255) Null
EVENT_SEVERITY_4



DoDSER-A 1 tbDoDSER_Patient_2004 15 EVENT_HOSP_Y
Yes 9/8/2009 varchar(255) Null
EVENT_HOSP_Y



DoDSER-A 1 tbDoDSER_Patient_2004 16 EVENT_HOSP_N
Yes 9/8/2009 varchar(255) Null
EVENT_HOSP_N



DoDSER-A 1 tbDoDSER_Patient_2004 17 EVENT_HOSP_X
Yes 9/8/2009 varchar(255) Null
EVENT_HOSP_X



DoDSER-A 1 tbDoDSER_Patient_2004 18 EVENT_HOSP_MTF
Yes 9/8/2009 varchar(255) Null
EVENT_HOSP_MTF



DoDSER-A 1 tbDoDSER_Patient_2004 19 EVENT_HOSP_CIV
Yes 9/8/2009 varchar(255) Null
EVENT_HOSP_CIV



DoDSER-A 1 tbDoDSER_Patient_2004 20 EVENT_HOSP_VA
Yes 9/8/2009 varchar(255) Null
EVENT_HOSP_VA



DoDSER-A 1 tbDoDSER_Patient_2004 21 EVENT_HOSP_NAMES
Yes 9/8/2009 varchar(255) Null
EVENT_HOSP_NAMES



DoDSER-A 1 tbDoDSER_Patient_2004 22 EVENT_DEPLOY_YA
Yes 9/8/2009 varchar(255) Null
EVENT_DEPLOY_YA



DoDSER-A 1 tbDoDSER_Patient_2004 23 EVENT_DEPLOY_YC
Yes 9/8/2009 varchar(255) Null
EVENT_DEPLOY_YC



DoDSER-A 1 tbDoDSER_Patient_2004 24 EVENT_DEPLOY_YP
Yes 9/8/2009 varchar(255) Null
EVENT_DEPLOY_YP



DoDSER-A 1 tbDoDSER_Patient_2004 25 EVENT_DEPLOY_N
Yes 9/8/2009 varchar(255) Null
EVENT_DEPLOY_N



DoDSER-A 1 tbDoDSER_Patient_2004 26 EVENT_DEPLOY_ANT_LOC_AFG
Yes 9/8/2009 varchar(255) Null
EVENT_DEPLOY_ANT_LOC_AFG



DoDSER-A 1 tbDoDSER_Patient_2004 27 EVENT_DEPLOY_ANT_LOC_IRQ
Yes 9/8/2009 varchar(255) Null
EVENT_DEPLOY_ANT_LOC_IRQ



DoDSER-A 1 tbDoDSER_Patient_2004 28 EVENT_DEPLOY_ANT_LOC_KOR
Yes 9/8/2009 varchar(255) Null
EVENT_DEPLOY_ANT_LOC_KOR



DoDSER-A 1 tbDoDSER_Patient_2004 29 EVENT_DEPLOY_ANT_LOC_KOS
Yes 9/8/2009 varchar(255) Null
EVENT_DEPLOY_ANT_LOC_KOS



DoDSER-A 1 tbDoDSER_Patient_2004 30 EVENT_DEPLOY_ANT_LOC_KWT
Yes 9/8/2009 varchar(255) Null
EVENT_DEPLOY_ANT_LOC_KWT



DoDSER-A 1 tbDoDSER_Patient_2004 31 EVENT_DEPLOY_ANT_LOC_OTH
Yes 9/8/2009 varchar(255) Null
EVENT_DEPLOY_ANT_LOC_OTH



DoDSER-A 1 tbDoDSER_Patient_2004 33 EVENT_COMMUN_Y
Yes 9/8/2009 varchar(255) Null
EVENT_COMMUN_Y



DoDSER-A 1 tbDoDSER_Patient_2004 34 EVENT_COMMUN_N
Yes 9/8/2009 varchar(255) Null
EVENT_COMMUN_N



DoDSER-A 1 tbDoDSER_Patient_2004 35 EVENT_COMMUN_SUPER
Yes 9/8/2009 varchar(255) Null
EVENT_COMMUN_SUPER



DoDSER-A 1 tbDoDSER_Patient_2004 36 EVENT_COMMUN_CHAPLAIN
Yes 9/8/2009 varchar(255) Null
EVENT_COMMUN_CHAPLAIN



DoDSER-A 1 tbDoDSER_Patient_2004 37 EVENT_COMMUN_FRIEND
Yes 9/8/2009 varchar(255) Null
EVENT_COMMUN_FRIEND



DoDSER-A 1 tbDoDSER_Patient_2004 38 EVENT_COMMUN_MHSTAFF
Yes 9/8/2009 varchar(255) Null
EVENT_COMMUN_MHSTAFF



DoDSER-A 1 tbDoDSER_Patient_2004 39 EVENT_COMMUN_SPOUSE
Yes 9/8/2009 varchar(255) Null
EVENT_COMMUN_SPOUSE



DoDSER-A 1 tbDoDSER_Patient_2004 40 EVENT_COMMUN_OTHER
Yes 9/8/2009 varchar(255) Null
EVENT_COMMUN_OTHER



DoDSER-A 1 tbDoDSER_Patient_2004 42 EVENT_INTENT_ATTN
Yes 9/8/2009 varchar(255) Null
EVENT_INTENT_ATTN



DoDSER-A 1 tbDoDSER_Patient_2004 43 EVENT_INTENT_KILL
Yes 9/8/2009 varchar(255) Null
EVENT_INTENT_KILL



DoDSER-A 1 tbDoDSER_Patient_2004 44 EVENT_INTENT_NOKILL
Yes 9/8/2009 varchar(255) Null
EVENT_INTENT_NOKILL



DoDSER-A 1 tbDoDSER_Patient_2004 45 EVENT_INTENT_X
Yes 9/8/2009 varchar(255) Null
EVENT_INTENT_X



DoDSER-A 1 tbDoDSER_Patient_2004 46 EVENT_METHOD_OD
Yes 9/8/2009 varchar(255) Null
EVENT_METHOD_OD



DoDSER-A 1 tbDoDSER_Patient_2004 47 EVENT_METHOD_OD_PRE
Yes 9/8/2009 varchar(255) Null
EVENT_METHOD_OD_PRE



DoDSER-A 1 tbDoDSER_Patient_2004 48 EVENT_METHOD_OD_OTC
Yes 9/8/2009 varchar(255) Null
EVENT_METHOD_OD_OTC



DoDSER-A 1 tbDoDSER_Patient_2004 49 EVENT_METHOD_OD_DRG
Yes 9/8/2009 varchar(255) Null
EVENT_METHOD_OD_DRG



DoDSER-A 1 tbDoDSER_Patient_2004 50 EVENT_METHOD_PSN
Yes 9/8/2009 varchar(255) Null
EVENT_METHOD_PSN



DoDSER-A 1 tbDoDSER_Patient_2004 51 EVENT_METHOD_GUN
Yes 9/8/2009 varchar(255) Null
EVENT_METHOD_GUN



DoDSER-A 1 tbDoDSER_Patient_2004 52 EVENT_METHOD_JMP
Yes 9/8/2009 varchar(255) Null
EVENT_METHOD_JMP



DoDSER-A 1 tbDoDSER_Patient_2004 53 EVENT_METHOD_CAR
Yes 9/8/2009 varchar(255) Null
EVENT_METHOD_CAR



DoDSER-A 1 tbDoDSER_Patient_2004 54 EVENT_METHOD_HNG
Yes 9/8/2009 varchar(255) Null
EVENT_METHOD_HNG



DoDSER-A 1 tbDoDSER_Patient_2004 55 EVENT_METHOD_CUT
Yes 9/8/2009 varchar(255) Null
EVENT_METHOD_CUT



DoDSER-A 1 tbDoDSER_Patient_2004 56 EVENT_METHOD_EXH
Yes 9/8/2009 varchar(255) Null
EVENT_METHOD_EXH



DoDSER-A 1 tbDoDSER_Patient_2004 57 EVENT_METHOD_GAS
Yes 9/8/2009 varchar(255) Null
EVENT_METHOD_GAS



DoDSER-A 1 tbDoDSER_Patient_2004 58 EVENT_METHOD_SUB
Yes 9/8/2009 varchar(255) Null
EVENT_METHOD_SUB



DoDSER-A 1 tbDoDSER_Patient_2004 59 EVENT_METHOD_OTH
Yes 9/8/2009 varchar(255) Null
EVENT_METHOD_OTH



DoDSER-A 1 tbDoDSER_Patient_2004 61 EVENT_METHOD_X
Yes 9/8/2009 varchar(255) Null
EVENT_METHOD_X



DoDSER-A 1 tbDoDSER_Patient_2004 62 EVENT_DRUGS_Y
Yes 9/8/2009 varchar(255) Null
EVENT_DRUGS_Y



DoDSER-A 1 tbDoDSER_Patient_2004 63 EVENT_DRUGS_N
Yes 9/8/2009 varchar(255) Null
EVENT_DRUGS_N



DoDSER-A 1 tbDoDSER_Patient_2004 64 EVENT_DRUGS_X
Yes 9/8/2009 varchar(255) Null
EVENT_DRUGS_X



DoDSER-A 1 tbDoDSER_Patient_2004 65 EVENT_ALCOHOL_Y
Yes 9/8/2009 varchar(255) Null
EVENT_ALCOHOL_Y



DoDSER-A 1 tbDoDSER_Patient_2004 66 EVENT_ALCOHOL_N
Yes 9/8/2009 varchar(255) Null
EVENT_ALCOHOL_N



DoDSER-A 1 tbDoDSER_Patient_2004 67 EVENT_ALCOHOL_X
Yes 9/8/2009 varchar(255) Null
EVENT_ALCOHOL_X



DoDSER-A 1 tbDoDSER_Patient_2004 68 EVENT_OBSERVABLE_Y
Yes 9/8/2009 varchar(255) Null
EVENT_OBSERVABLE_Y



DoDSER-A 1 tbDoDSER_Patient_2004 69 EVENT_OBSERVABLE_N
Yes 9/8/2009 varchar(255) Null
EVENT_OBSERVABLE_N



DoDSER-A 1 tbDoDSER_Patient_2004 70 EVENT_OBSERVABLE_X
Yes 9/8/2009 varchar(255) Null
EVENT_OBSERVABLE_X



DoDSER-A 1 tbDoDSER_Patient_2004 71 EVENT_PLAN_PLN
Yes 9/8/2009 varchar(255) Null
EVENT_PLAN_PLN



DoDSER-A 1 tbDoDSER_Patient_2004 72 EVENT_PLAN_IMP
Yes 9/8/2009 varchar(255) Null
EVENT_PLAN_IMP



DoDSER-A 1 tbDoDSER_Patient_2004 73 EVENT_PLAN_X
Yes 9/8/2009 varchar(255) Null
EVENT_PLAN_X



DoDSER-A 1 tbDoDSER_Patient_2004 77 PATIENT_GENDER_M
Yes 9/8/2009 varchar(255) Null
PATIENT_GENDER_M



DoDSER-A 1 tbDoDSER_Patient_2004 78 PATIENT_GENDER_F
Yes 9/8/2009 varchar(255) Null
PATIENT_GENDER_F



DoDSER-A 1 tbDoDSER_Patient_2004 79 PATIENT_RESIDE_BRK
Yes 9/8/2009 varchar(255) Null
PATIENT_RESIDE_BRK



DoDSER-A 1 tbDoDSER_Patient_2004 80 PATIENT_RESIDE_BXQ
Yes 9/8/2009 varchar(255) Null
PATIENT_RESIDE_BXQ



DoDSER-A 1 tbDoDSER_Patient_2004 81 PATIENT_RESIDE_ONP
Yes 9/8/2009 varchar(255) Null
PATIENT_RESIDE_ONP



DoDSER-A 1 tbDoDSER_Patient_2004 82 PATIENT_RESIDE_OFP
Yes 9/8/2009 varchar(255) Null
PATIENT_RESIDE_OFP



DoDSER-A 1 tbDoDSER_Patient_2004 83 PATIENT_RESIDE_ALONE_Y
Yes 9/8/2009 varchar(255) Null
PATIENT_RESIDE_ALONE_Y



DoDSER-A 1 tbDoDSER_Patient_2004 84 PATIENT_RESIDE_ALONE_N
Yes 9/8/2009 varchar(255) Null
PATIENT_RESIDE_ALONE_N



DoDSER-A 1 tbDoDSER_Patient_2004 85 PATIENT_RESIDE_ALONE_X
Yes 9/8/2009 varchar(255) Null
PATIENT_RESIDE_ALONE_X



DoDSER-A 1 tbDoDSER_Patient_2004 86 PATIENT_EDUCATION_NOT
Yes 9/8/2009 varchar(255) Null
PATIENT_EDUCATION_NOT



DoDSER-A 1 tbDoDSER_Patient_2004 87 PATIENT_EDUCATION_GED
Yes 9/8/2009 varchar(255) Null
PATIENT_EDUCATION_GED



DoDSER-A 1 tbDoDSER_Patient_2004 88 PATIENT_EDUCATION_HS
Yes 9/8/2009 varchar(255) Null
PATIENT_EDUCATION_HS



DoDSER-A 1 tbDoDSER_Patient_2004 89 PATIENT_EDUCATION_TWO
Yes 9/8/2009 varchar(255) Null
PATIENT_EDUCATION_TWO



DoDSER-A 1 tbDoDSER_Patient_2004 90 PATIENT_EDUCATION_FOUR
Yes 9/8/2009 varchar(255) Null
PATIENT_EDUCATION_FOUR



DoDSER-A 1 tbDoDSER_Patient_2004 91 PATIENT_RACE_IND
Yes 9/8/2009 varchar(255) Null
PATIENT_RACE_IND



DoDSER-A 1 tbDoDSER_Patient_2004 92 PATIENT_RACE_ASN
Yes 9/8/2009 varchar(255) Null
PATIENT_RACE_ASN



DoDSER-A 1 tbDoDSER_Patient_2004 93 PATIENT_RACE_BLK
Yes 9/8/2009 varchar(255) Null
PATIENT_RACE_BLK



DoDSER-A 1 tbDoDSER_Patient_2004 94 PATIENT_RACE_WHT
Yes 9/8/2009 varchar(255) Null
PATIENT_RACE_WHT



DoDSER-A 1 tbDoDSER_Patient_2004 95 PATIENT_RACE_OTH
Yes 9/8/2009 varchar(255) Null
PATIENT_RACE_OTH



DoDSER-A 1 tbDoDSER_Patient_2004 97 PATIENT_RACE_X
Yes 9/8/2009 varchar(255) Null
PATIENT_RACE_X



DoDSER-A 1 tbDoDSER_Patient_2004 98 PATIENT_ETHNIC_MEX
Yes 9/8/2009 varchar(255) Null
PATIENT_ETHNIC_MEX



DoDSER-A 1 tbDoDSER_Patient_2004 99 PATIENT_ETHNIC_JAP
Yes 9/8/2009 varchar(255) Null
PATIENT_ETHNIC_JAP



DoDSER-A 1 tbDoDSER_Patient_2004 100 PATIENT_ETHNIC_PR
Yes 9/8/2009 varchar(255) Null
PATIENT_ETHNIC_PR



DoDSER-A 1 tbDoDSER_Patient_2004 101 PATIENT_ETHNIC_KOR
Yes 9/8/2009 varchar(255) Null
PATIENT_ETHNIC_KOR



DoDSER-A 1 tbDoDSER_Patient_2004 102 PATIENT_ETHNIC_CUB
Yes 9/8/2009 varchar(255) Null
PATIENT_ETHNIC_CUB



DoDSER-A 1 tbDoDSER_Patient_2004 103 PATIENT_ETHNIC_IND
Yes 9/8/2009 varchar(255) Null
PATIENT_ETHNIC_IND



DoDSER-A 1 tbDoDSER_Patient_2004 104 PATIENT_ETHNIC_LAT
Yes 9/8/2009 varchar(255) Null
PATIENT_ETHNIC_LAT



DoDSER-A 1 tbDoDSER_Patient_2004 105 PATIENT_ETHNIC_FIL
Yes 9/8/2009 varchar(255) Null
PATIENT_ETHNIC_FIL



DoDSER-A 1 tbDoDSER_Patient_2004 106 PATIENT_ETHNIC_SPN
Yes 9/8/2009 varchar(255) Null
PATIENT_ETHNIC_SPN



DoDSER-A 1 tbDoDSER_Patient_2004 107 PATIENT_ETHNIC_VTN
Yes 9/8/2009 varchar(255) Null
PATIENT_ETHNIC_VTN



DoDSER-A 1 tbDoDSER_Patient_2004 108 PATIENT_ETHNIC_ALT
Yes 9/8/2009 varchar(255) Null
PATIENT_ETHNIC_ALT



DoDSER-A 1 tbDoDSER_Patient_2004 109 PATIENT_ETHNIC_ASN
Yes 9/8/2009 varchar(255) Null
PATIENT_ETHNIC_ASN



DoDSER-A 1 tbDoDSER_Patient_2004 110 PATIENT_ETHNIC_ESK
Yes 9/8/2009 varchar(255) Null
PATIENT_ETHNIC_ESK



DoDSER-A 1 tbDoDSER_Patient_2004 111 PATIENT_ETHNIC_MEL
Yes 9/8/2009 varchar(255) Null
PATIENT_ETHNIC_MEL



DoDSER-A 1 tbDoDSER_Patient_2004 112 PATIENT_ETHNIC_AIN
Yes 9/8/2009 varchar(255) Null
PATIENT_ETHNIC_AIN



DoDSER-A 1 tbDoDSER_Patient_2004 113 PATIENT_ETHNIC_POL
Yes 9/8/2009 varchar(255) Null
PATIENT_ETHNIC_POL



DoDSER-A 1 tbDoDSER_Patient_2004 114 PATIENT_ETHNIC_CHN
Yes 9/8/2009 varchar(255) Null
PATIENT_ETHNIC_CHN



DoDSER-A 1 tbDoDSER_Patient_2004 115 PATIENT_ETHNIC_PAC
Yes 9/8/2009 varchar(255) Null
PATIENT_ETHNIC_PAC



DoDSER-A 1 tbDoDSER_Patient_2004 116 PATIENT_ETHNIC_OTH
Yes 9/8/2009 varchar(255) Null
PATIENT_ETHNIC_OTH



DoDSER-A 1 tbDoDSER_Patient_2004 118 PATIENT_ETHNIC_X
Yes 9/8/2009 varchar(255) Null
PATIENT_ETHNIC_X



DoDSER-A 1 tbDoDSER_Patient_2004 119 PATIENT_MARITAL_STATUS_MAR
Yes 9/8/2009 varchar(255) Null
PATIENT_MARITAL_STATUS_MAR



DoDSER-A 1 tbDoDSER_Patient_2004 120 PATIENT_MARITAL_STATUS_MGS
Yes 9/8/2009 varchar(255) Null
PATIENT_MARITAL_STATUS_MGS



DoDSER-A 1 tbDoDSER_Patient_2004 121 PATIENT_MARITAL_STATUS_WID
Yes 9/8/2009 varchar(255) Null
PATIENT_MARITAL_STATUS_WID



DoDSER-A 1 tbDoDSER_Patient_2004 122 PATIENT_MARITAL_STATUS_DIV
Yes 9/8/2009 varchar(255) Null
PATIENT_MARITAL_STATUS_DIV



DoDSER-A 1 tbDoDSER_Patient_2004 123 PATIENT_MARITAL_STATUS_SEP
Yes 9/8/2009 varchar(255) Null
PATIENT_MARITAL_STATUS_SEP



DoDSER-A 1 tbDoDSER_Patient_2004 124 PATIENT_MARITAL_STATUS_X
Yes 9/8/2009 varchar(255) Null
PATIENT_MARITAL_STATUS_X



DoDSER-A 1 tbDoDSER_Patient_2004 125 PATIENT_KIDS_Y
Yes 9/8/2009 varchar(255) Null
PATIENT_KIDS_Y



DoDSER-A 1 tbDoDSER_Patient_2004 126 PATIENT_KIDS_N
Yes 9/8/2009 varchar(255) Null
PATIENT_KIDS_N



DoDSER-A 1 tbDoDSER_Patient_2004 127 PATIENT_KIDS_X
Yes 9/8/2009 varchar(255) Null
PATIENT_KIDS_X



DoDSER-A 1 tbDoDSER_Patient_2004 128 PATIENT_KIDS_WITH_Y
Yes 9/8/2009 varchar(255) Null
PATIENT_KIDS_WITH_Y



DoDSER-A 1 tbDoDSER_Patient_2004 129 PATIENT_KIDS_WITH_N
Yes 9/8/2009 varchar(255) Null
PATIENT_KIDS_WITH_N



DoDSER-A 1 tbDoDSER_Patient_2004 130 PATIENT_KIDS_WITH_X
Yes 9/8/2009 varchar(255) Null
PATIENT_KIDS_WITH_X



DoDSER-A 1 tbDoDSER_Patient_2004 131 SPONSOR_SERVICE_ARM
Yes 9/8/2009 varchar(255) Null
SPONSOR_SERVICE_ARM



DoDSER-A 1 tbDoDSER_Patient_2004 132 SPONSOR_SERVICE_NAV
Yes 9/8/2009 varchar(255) Null
SPONSOR_SERVICE_NAV



DoDSER-A 1 tbDoDSER_Patient_2004 133 SPONSOR_SERVICE_AF
Yes 9/8/2009 varchar(255) Null
SPONSOR_SERVICE_AF



DoDSER-A 1 tbDoDSER_Patient_2004 134 SPONSOR_SERVICE_MAR
Yes 9/8/2009 varchar(255) Null
SPONSOR_SERVICE_MAR



DoDSER-A 1 tbDoDSER_Patient_2004 135 SPONSOR_SERVICE_CG
Yes 9/8/2009 varchar(255) Null
SPONSOR_SERVICE_CG



DoDSER-A 1 tbDoDSER_Patient_2004 136 SPONSOR_SERVICE_OTH
Yes 9/8/2009 varchar(255) Null
SPONSOR_SERVICE_OTH



DoDSER-A 1 tbDoDSER_Patient_2004 138 SPONSOR_COMPONENT_REG
Yes 9/8/2009 varchar(255) Null
SPONSOR_COMPONENT_REG



DoDSER-A 1 tbDoDSER_Patient_2004 139 SPONSOR_COMPONENT_RES
Yes 9/8/2009 varchar(255) Null
SPONSOR_COMPONENT_RES



DoDSER-A 1 tbDoDSER_Patient_2004 140 SPONSOR_COMPONENT_NG
Yes 9/8/2009 varchar(255) Null
SPONSOR_COMPONENT_NG



DoDSER-A 1 tbDoDSER_Patient_2004 141 SPONSOR_COMPONENT_CIV
Yes 9/8/2009 varchar(255) Null
SPONSOR_COMPONENT_CIV



DoDSER-A 1 tbDoDSER_Patient_2004 142 SPONSOR_STATUS_ACTIVE
Yes 9/8/2009 varchar(255) Null
SPONSOR_STATUS_ACTIVE



DoDSER-A 1 tbDoDSER_Patient_2004 143 SPONSOR_STATUS_AGR
Yes 9/8/2009 varchar(255) Null
SPONSOR_STATUS_AGR



DoDSER-A 1 tbDoDSER_Patient_2004 144 SPONSOR_STATUS_IET
Yes 9/8/2009 varchar(255) Null
SPONSOR_STATUS_IET



DoDSER-A 1 tbDoDSER_Patient_2004 145 SPONSOR_STATUS_MOBILIZED
Yes 9/8/2009 varchar(255) Null
SPONSOR_STATUS_MOBILIZED



DoDSER-A 1 tbDoDSER_Patient_2004 146 SPONSOR_STATUS_ADT
Yes 9/8/2009 varchar(255) Null
SPONSOR_STATUS_ADT



DoDSER-A 1 tbDoDSER_Patient_2004 147 SPONSOR_STATUS_IDT
Yes 9/8/2009 varchar(255) Null
SPONSOR_STATUS_IDT



DoDSER-A 1 tbDoDSER_Patient_2004 148 SPONSOR_STATUS_RETIRED
Yes 9/8/2009 varchar(255) Null
SPONSOR_STATUS_RETIRED



DoDSER-A 1 tbDoDSER_Patient_2004 149 SPONSOR_STATUS_OTHER
Yes 9/8/2009 varchar(255) Null
SPONSOR_STATUS_OTHER



DoDSER-A 1 tbDoDSER_Patient_2004 151 SPONSOR_RANK_ENL DI Yes 9/8/2009 varchar(255) Null
SPONSOR_RANK_ENL



DoDSER-A 1 tbDoDSER_Patient_2004 152 SPONSOR_RANK_WAR DI Yes 9/8/2009 varchar(255) Null
SPONSOR_RANK_WAR



DoDSER-A 1 tbDoDSER_Patient_2004 153 SPONSOR_RANK_OFF DI Yes 9/8/2009 varchar(255) Null
SPONSOR_RANK_OFF



DoDSER-A 1 tbDoDSER_Patient_2004 154 SPONSOR_RANK_CAD DI Yes 9/8/2009 varchar(255) Null
SPONSOR_RANK_CAD



DoDSER-A 1 tbDoDSER_Patient_2004 155 SPONSOR_RANK_1 DI Yes 9/8/2009 varchar(255) Null
SPONSOR_RANK_1



DoDSER-A 1 tbDoDSER_Patient_2004 156 SPONSOR_RANK_2 DI Yes 9/8/2009 varchar(255) Null
SPONSOR_RANK_2



DoDSER-A 1 tbDoDSER_Patient_2004 157 SPONSOR_RANK_3 DI Yes 9/8/2009 varchar(255) Null
SPONSOR_RANK_3



DoDSER-A 1 tbDoDSER_Patient_2004 158 SPONSOR_RANK_4 DI Yes 9/8/2009 varchar(255) Null
SPONSOR_RANK_4



DoDSER-A 1 tbDoDSER_Patient_2004 159 SPONSOR_RANK_5 DI Yes 9/8/2009 varchar(255) Null
SPONSOR_RANK_5



DoDSER-A 1 tbDoDSER_Patient_2004 160 SPONSOR_RANK_6 DI Yes 9/8/2009 varchar(255) Null
SPONSOR_RANK_6



DoDSER-A 1 tbDoDSER_Patient_2004 161 SPONSOR_RANK_7 DI Yes 9/8/2009 varchar(255) Null
SPONSOR_RANK_7



DoDSER-A 1 tbDoDSER_Patient_2004 162 SPONSOR_RANK_8 DI Yes 9/8/2009 varchar(255) Null
SPONSOR_RANK_8



DoDSER-A 1 tbDoDSER_Patient_2004 163 SPONSOR_RANK_9 DI Yes 9/8/2009 varchar(255) Null
SPONSOR_RANK_9



DoDSER-A 1 tbDoDSER_Patient_2004 164 SPONSOR_RANK_10 DI Yes 9/8/2009 varchar(255) Null
SPONSOR_RANK_10



DoDSER-A 1 tbDoDSER_Patient_2004 165 PATIENT_SPONSOR_REL_SPN
Yes 9/8/2009 varchar(255) Null
PATIENT_SPONSOR_REL_SPN



DoDSER-A 1 tbDoDSER_Patient_2004 166 PATIENT_SPONSOR_REL_SPS
Yes 9/8/2009 varchar(255) Null
PATIENT_SPONSOR_REL_SPS



DoDSER-A 1 tbDoDSER_Patient_2004 167 PATIENT_SPONSOR_REL_CHI
Yes 9/8/2009 varchar(255) Null
PATIENT_SPONSOR_REL_CHI



DoDSER-A 1 tbDoDSER_Patient_2004 168 PATIENT_SPONSOR_REL_OTH
Yes 9/8/2009 varchar(255) Null
PATIENT_SPONSOR_REL_OTH



DoDSER-A 1 tbDoDSER_Patient_2004 170 SPONSOR_MOS
Yes 9/8/2009 varchar(255) Null
SPONSOR_MOS



DoDSER-A 1 tbDoDSER_Patient_2004 175 SPONSOR_UIC DI Yes 9/8/2009 varchar(255) Null
SPONSOR_UIC



DoDSER-A 1 tbDoDSER_Patient_2004 176 SPONSOR_LOC_STATION
Yes 9/8/2009 varchar(255) Null
SPONSOR_LOC_STATION



DoDSER-A 1 tbDoDSER_Patient_2004 177 SPONSOR_LOC_CITY
Yes 9/8/2009 varchar(255) Null
SPONSOR_LOC_CITY



DoDSER-A 1 tbDoDSER_Patient_2004 178 SPONSOR_LOC_STATE
Yes 9/8/2009 varchar(255) Null
SPONSOR_LOC_STATE



DoDSER-A 1 tbDoDSER_Patient_2004 179 SPONSOR_LOC_COUNTRY
Yes 9/8/2009 varchar(255) Null
SPONSOR_LOC_COUNTRY



DoDSER-A 1 tbDoDSER_Patient_2004 180 SPONSOR_TIME_UNIT_YEARS
Yes 9/8/2009 varchar(255) Null
SPONSOR_TIME_UNIT_YEARS



DoDSER-A 1 tbDoDSER_Patient_2004 181 SPONSOR_TIME_UNIT_MONTHS
Yes 9/8/2009 varchar(255) Null
SPONSOR_TIME_UNIT_MONTHS



DoDSER-A 1 tbDoDSER_Patient_2004 182 SPONSOR_TIME_UNIT_UNKNOWN
Yes 9/8/2009 varchar(255) Null
SPONSOR_TIME_UNIT_UNKNOWN



DoDSER-A 1 tbDoDSER_Patient_2004 183 EVENT_ENV_GARRISON
Yes 9/8/2009 varchar(255) Null
EVENT_ENV_GARRISON



DoDSER-A 1 tbDoDSER_Patient_2004 184 EVENT_ENV_PSYCH
Yes 9/8/2009 varchar(255) Null
EVENT_ENV_PSYCH



DoDSER-A 1 tbDoDSER_Patient_2004 185 EVENT_ENV_LEAVE
Yes 9/8/2009 varchar(255) Null
EVENT_ENV_LEAVE



DoDSER-A 1 tbDoDSER_Patient_2004 186 EVENT_ENV_MEDICAL_HOLD
Yes 9/8/2009 varchar(255) Null
EVENT_ENV_MEDICAL_HOLD



DoDSER-A 1 tbDoDSER_Patient_2004 187 EVENT_ENV_TDY
Yes 9/8/2009 varchar(255) Null
EVENT_ENV_TDY



DoDSER-A 1 tbDoDSER_Patient_2004 188 EVENT_ENV_EVACUATION
Yes 9/8/2009 varchar(255) Null
EVENT_ENV_EVACUATION



DoDSER-A 1 tbDoDSER_Patient_2004 189 EVENT_ENV_AWOL
Yes 9/8/2009 varchar(255) Null
EVENT_ENV_AWOL



DoDSER-A 1 tbDoDSER_Patient_2004 190 EVENT_ENV_COMMAND_OBS
Yes 9/8/2009 varchar(255) Null
EVENT_ENV_COMMAND_OBS



DoDSER-A 1 tbDoDSER_Patient_2004 191 EVENT_ENV_DEPLOYED
Yes 9/8/2009 varchar(255) Null
EVENT_ENV_DEPLOYED



DoDSER-A 1 tbDoDSER_Patient_2004 192 EVENT_ENV_OTH
Yes 9/8/2009 varchar(255) Null
EVENT_ENV_OTH



DoDSER-A 1 tbDoDSER_Patient_2004 194 EVENT_ENV_TRAINING
Yes 9/8/2009 varchar(255) Null
EVENT_ENV_TRAINING



DoDSER-A 1 tbDoDSER_Patient_2004 195 HIST_COMBAT_Y
Yes 9/8/2009 varchar(255) Null
HIST_COMBAT_Y



DoDSER-A 1 tbDoDSER_Patient_2004 196 HIST_COMBAT_N
Yes 9/8/2009 varchar(255) Null
HIST_COMBAT_N



DoDSER-A 1 tbDoDSER_Patient_2004 197 HIST_COMBAT_X
Yes 9/8/2009 varchar(255) Null
HIST_COMBAT_X



DoDSER-A 1 tbDoDSER_Patient_2004 198 HIST_COMBAT_FRIEND_Y
Yes 9/8/2009 varchar(255) Null
HIST_COMBAT_FRIEND_Y



DoDSER-A 1 tbDoDSER_Patient_2004 199 HIST_COMBAT_FRIEND_N
Yes 9/8/2009 varchar(255) Null
HIST_COMBAT_FRIEND_N



DoDSER-A 1 tbDoDSER_Patient_2004 200 HIST_COMBAT_FRIEND_X
Yes 9/8/2009 varchar(255) Null
HIST_COMBAT_FRIEND_X



DoDSER-A 1 tbDoDSER_Patient_2004 201 HIST_COMBAT_WITNESS_Y
Yes 9/8/2009 varchar(255) Null
HIST_COMBAT_WITNESS_Y



DoDSER-A 1 tbDoDSER_Patient_2004 202 HIST_COMBAT_WITNESS_N
Yes 9/8/2009 varchar(255) Null
HIST_COMBAT_WITNESS_N



DoDSER-A 1 tbDoDSER_Patient_2004 203 HIST_COMBAT_WITNESS_X
Yes 9/8/2009 varchar(255) Null
HIST_COMBAT_WITNESS_X



DoDSER-A 1 tbDoDSER_Patient_2004 204 HIST_MTF_YM
Yes 9/8/2009 varchar(255) Null
HIST_MTF_YM



DoDSER-A 1 tbDoDSER_Patient_2004 205 HIST_MTF_YY
Yes 9/8/2009 varchar(255) Null
HIST_MTF_YY



DoDSER-A 1 tbDoDSER_Patient_2004 206 HIST_MTF_N
Yes 9/8/2009 varchar(255) Null
HIST_MTF_N



DoDSER-A 1 tbDoDSER_Patient_2004 207 HIST_MTF_X
Yes 9/8/2009 varchar(255) Null
HIST_MTF_X



DoDSER-A 1 tbDoDSER_Patient_2004 208 HIST_SAS_YM
Yes 9/8/2009 varchar(255) Null
HIST_SAS_YM



DoDSER-A 1 tbDoDSER_Patient_2004 209 HIST_SAS_YY
Yes 9/8/2009 varchar(255) Null
HIST_SAS_YY



DoDSER-A 1 tbDoDSER_Patient_2004 210 HIST_SAS_N
Yes 9/8/2009 varchar(255) Null
HIST_SAS_N



DoDSER-A 1 tbDoDSER_Patient_2004 211 HIST_SAS_X
Yes 9/8/2009 varchar(255) Null
HIST_SAS_X



DoDSER-A 1 tbDoDSER_Patient_2004 212 HIST_FAP_YM
Yes 9/8/2009 varchar(255) Null
HIST_FAP_YM



DoDSER-A 1 tbDoDSER_Patient_2004 213 HIST_FAP_YY
Yes 9/8/2009 varchar(255) Null
HIST_FAP_YY



DoDSER-A 1 tbDoDSER_Patient_2004 214 HIST_FAP_N
Yes 9/8/2009 varchar(255) Null
HIST_FAP_N



DoDSER-A 1 tbDoDSER_Patient_2004 215 HIST_FAP_X
Yes 9/8/2009 varchar(255) Null
HIST_FAP_X



DoDSER-A 1 tbDoDSER_Patient_2004 216 HIST_OUTMH_YM
Yes 9/8/2009 varchar(255) Null
HIST_OUTMH_YM



DoDSER-A 1 tbDoDSER_Patient_2004 217 HIST_OUTMH_YY
Yes 9/8/2009 varchar(255) Null
HIST_OUTMH_YY



DoDSER-A 1 tbDoDSER_Patient_2004 218 HIST_OUTMH_N
Yes 9/8/2009 varchar(255) Null
HIST_OUTMH_N



DoDSER-A 1 tbDoDSER_Patient_2004 219 HIST_OUTMH_X
Yes 9/8/2009 varchar(255) Null
HIST_OUTMH_X



DoDSER-A 1 tbDoDSER_Patient_2004 220 HIST_INMH_YM
Yes 9/8/2009 varchar(255) Null
HIST_INMH_YM



DoDSER-A 1 tbDoDSER_Patient_2004 221 HIST_INMH_YY
Yes 9/8/2009 varchar(255) Null
HIST_INMH_YY



DoDSER-A 1 tbDoDSER_Patient_2004 222 HIST_INMH_N
Yes 9/8/2009 varchar(255) Null
HIST_INMH_N



DoDSER-A 1 tbDoDSER_Patient_2004 223 HIST_INMH_X
Yes 9/8/2009 varchar(255) Null
HIST_INMH_X



DoDSER-A 1 tbDoDSER_Patient_2004 224 RISK_MOOD_Y
Yes 9/8/2009 varchar(255) Null
RISK_MOOD_Y



DoDSER-A 1 tbDoDSER_Patient_2004 225 RISK_MOOD_N
Yes 9/8/2009 varchar(255) Null
RISK_MOOD_N



DoDSER-A 1 tbDoDSER_Patient_2004 226 RISK_MOOD_X
Yes 9/8/2009 varchar(255) Null
RISK_MOOD_X



DoDSER-A 1 tbDoDSER_Patient_2004 227 RISK_MOOD_MEB
Yes 9/8/2009 varchar(255) Null
RISK_MOOD_MEB



DoDSER-A 1 tbDoDSER_Patient_2004 228 RISK_MOOD_ADMIN
Yes 9/8/2009 varchar(255) Null
RISK_MOOD_ADMIN



DoDSER-A 1 tbDoDSER_Patient_2004 229 RISK_BIPOLAR_Y
Yes 9/8/2009 varchar(255) Null
RISK_BIPOLAR_Y



DoDSER-A 1 tbDoDSER_Patient_2004 230 RISK_BIPOLAR_N
Yes 9/8/2009 varchar(255) Null
RISK_BIPOLAR_N



DoDSER-A 1 tbDoDSER_Patient_2004 231 RISK_BIPOLAR_X
Yes 9/8/2009 varchar(255) Null
RISK_BIPOLAR_X



DoDSER-A 1 tbDoDSER_Patient_2004 232 RISK_BIPOLAR_MEB
Yes 9/8/2009 varchar(255) Null
RISK_BIPOLAR_MEB



DoDSER-A 1 tbDoDSER_Patient_2004 233 RISK_BIPOLAR_ADMIN
Yes 9/8/2009 varchar(255) Null
RISK_BIPOLAR_ADMIN



DoDSER-A 1 tbDoDSER_Patient_2004 234 RISK_MAJDEP_Y
Yes 9/8/2009 varchar(255) Null
RISK_MAJDEP_Y



DoDSER-A 1 tbDoDSER_Patient_2004 235 RISK_MAJDEP_N
Yes 9/8/2009 varchar(255) Null
RISK_MAJDEP_N



DoDSER-A 1 tbDoDSER_Patient_2004 236 RISK_MAJDEP_X
Yes 9/8/2009 varchar(255) Null
RISK_MAJDEP_X



DoDSER-A 1 tbDoDSER_Patient_2004 237 RISK_MAJDEP_MEB
Yes 9/8/2009 varchar(255) Null
RISK_MAJDEP_MEB



DoDSER-A 1 tbDoDSER_Patient_2004 238 RISK_MAJDEP_ADMIN
Yes 9/8/2009 varchar(255) Null
RISK_MAJDEP_ADMIN



DoDSER-A 1 tbDoDSER_Patient_2004 239 RISK_PSYCHOTIC_Y
Yes 9/8/2009 varchar(255) Null
RISK_PSYCHOTIC_Y



DoDSER-A 1 tbDoDSER_Patient_2004 240 RISK_PSYCHOTIC_N
Yes 9/8/2009 varchar(255) Null
RISK_PSYCHOTIC_N



DoDSER-A 1 tbDoDSER_Patient_2004 241 RISK_PSYCHOTIC_X
Yes 9/8/2009 varchar(255) Null
RISK_PSYCHOTIC_X



DoDSER-A 1 tbDoDSER_Patient_2004 242 RISK_PSYCHOTIC_MEB
Yes 9/8/2009 varchar(255) Null
RISK_PSYCHOTIC_MEB



DoDSER-A 1 tbDoDSER_Patient_2004 243 RISK_PSYCHOTIC_ADMIN
Yes 9/8/2009 varchar(255) Null
RISK_PSYCHOTIC_ADMIN



DoDSER-A 1 tbDoDSER_Patient_2004 244 RISK_PTSD_Y
Yes 9/8/2009 varchar(255) Null
RISK_PTSD_Y



DoDSER-A 1 tbDoDSER_Patient_2004 245 RISK_PTSD_N
Yes 9/8/2009 varchar(255) Null
RISK_PTSD_N



DoDSER-A 1 tbDoDSER_Patient_2004 246 RISK_PTSD_X
Yes 9/8/2009 varchar(255) Null
RISK_PTSD_X



DoDSER-A 1 tbDoDSER_Patient_2004 247 RISK_PTSD_MEB
Yes 9/8/2009 varchar(255) Null
RISK_PTSD_MEB



DoDSER-A 1 tbDoDSER_Patient_2004 248 RISK_PTSD_ADMIN
Yes 9/8/2009 varchar(255) Null
RISK_PTSD_ADMIN



DoDSER-A 1 tbDoDSER_Patient_2004 249 RISK_ANXIETY_Y
Yes 9/8/2009 varchar(255) Null
RISK_ANXIETY_Y



DoDSER-A 1 tbDoDSER_Patient_2004 250 RISK_ANXIETY_N
Yes 9/8/2009 varchar(255) Null
RISK_ANXIETY_N



DoDSER-A 1 tbDoDSER_Patient_2004 251 RISK_ANXIETY_X
Yes 9/8/2009 varchar(255) Null
RISK_ANXIETY_X



DoDSER-A 1 tbDoDSER_Patient_2004 252 RISK_ANXIETY_MEB
Yes 9/8/2009 varchar(255) Null
RISK_ANXIETY_MEB



DoDSER-A 1 tbDoDSER_Patient_2004 253 RISK_ANXIETY_ADMIN
Yes 9/8/2009 varchar(255) Null
RISK_ANXIETY_ADMIN



DoDSER-A 1 tbDoDSER_Patient_2004 254 RISK_PERSONALITY_Y
Yes 9/8/2009 varchar(255) Null
RISK_PERSONALITY_Y



DoDSER-A 1 tbDoDSER_Patient_2004 255 RISK_PERSONALITY_N
Yes 9/8/2009 varchar(255) Null
RISK_PERSONALITY_N



DoDSER-A 1 tbDoDSER_Patient_2004 256 RISK_PERSONALITY_X
Yes 9/8/2009 varchar(255) Null
RISK_PERSONALITY_X



DoDSER-A 1 tbDoDSER_Patient_2004 257 RISK_PERSONALITY_MEB
Yes 9/8/2009 varchar(255) Null
RISK_PERSONALITY_MEB



DoDSER-A 1 tbDoDSER_Patient_2004 258 RISK_PERSONALITY_ADMIN
Yes 9/8/2009 varchar(255) Null
RISK_PERSONALITY_ADMIN



DoDSER-A 1 tbDoDSER_Patient_2004 259 RISK_SUBST_Y
Yes 9/8/2009 varchar(255) Null
RISK_SUBST_Y



DoDSER-A 1 tbDoDSER_Patient_2004 260 RISK_SUBST_N
Yes 9/8/2009 varchar(255) Null
RISK_SUBST_N



DoDSER-A 1 tbDoDSER_Patient_2004 261 RISK_SUBST_X
Yes 9/8/2009 varchar(255) Null
RISK_SUBST_X



DoDSER-A 1 tbDoDSER_Patient_2004 262 RISK_SUBST_MEB
Yes 9/8/2009 varchar(255) Null
RISK_SUBST_MEB



DoDSER-A 1 tbDoDSER_Patient_2004 263 RISK_SUBST_ADMIN
Yes 9/8/2009 varchar(255) Null
RISK_SUBST_ADMIN



DoDSER-A 1 tbDoDSER_Patient_2004 264 RISK_SUBST_ALC_DEP
Yes 9/8/2009 varchar(255) Null
RISK_SUBST_ALC_DEP



DoDSER-A 1 tbDoDSER_Patient_2004 265 RISK_SUBST_ALC_AB
Yes 9/8/2009 varchar(255) Null
RISK_SUBST_ALC_AB



DoDSER-A 1 tbDoDSER_Patient_2004 266 RISK_SUBST_DRG_DEP
Yes 9/8/2009 varchar(255) Null
RISK_SUBST_DRG_DEP



DoDSER-A 1 tbDoDSER_Patient_2004 267 RISK_SUBST_DRG_AB
Yes 9/8/2009 varchar(255) Null
RISK_SUBST_DRG_AB



DoDSER-A 1 tbDoDSER_Patient_2004 268 RISK_SUBST_PRE_DEP
Yes 9/8/2009 varchar(255) Null
RISK_SUBST_PRE_DEP



DoDSER-A 1 tbDoDSER_Patient_2004 269 RISK_SUBST_PRE_AB
Yes 9/8/2009 varchar(255) Null
RISK_SUBST_PRE_AB



DoDSER-A 1 tbDoDSER_Patient_2004 270 RISK_SUBST_OTC_DEP
Yes 9/8/2009 varchar(255) Null
RISK_SUBST_OTC_DEP



DoDSER-A 1 tbDoDSER_Patient_2004 271 RISK_SUBST_OTC_AB
Yes 9/8/2009 varchar(255) Null
RISK_SUBST_OTC_AB



DoDSER-A 1 tbDoDSER_Patient_2004 272 RISK_PSYCHOTROPIC_Y
Yes 9/8/2009 varchar(255) Null
RISK_PSYCHOTROPIC_Y



DoDSER-A 1 tbDoDSER_Patient_2004 273 RISK_PSYCHOTROPIC_N
Yes 9/8/2009 varchar(255) Null
RISK_PSYCHOTROPIC_N



DoDSER-A 1 tbDoDSER_Patient_2004 274 RISK_PSYCHOTROPIC_X
Yes 9/8/2009 varchar(255) Null
RISK_PSYCHOTROPIC_X



DoDSER-A 1 tbDoDSER_Patient_2004 275 RISK_FAMILY_Y
Yes 9/8/2009 varchar(255) Null
RISK_FAMILY_Y



DoDSER-A 1 tbDoDSER_Patient_2004 276 RISK_FAMILY_N
Yes 9/8/2009 varchar(255) Null
RISK_FAMILY_N



DoDSER-A 1 tbDoDSER_Patient_2004 277 RISK_FAMILY_X
Yes 9/8/2009 varchar(255) Null
RISK_FAMILY_X



DoDSER-A 1 tbDoDSER_Patient_2004 278 RISK_SELFINJ_Y
Yes 9/8/2009 varchar(255) Null
RISK_SELFINJ_Y



DoDSER-A 1 tbDoDSER_Patient_2004 279 RISK_SELFINJ_N
Yes 9/8/2009 varchar(255) Null
RISK_SELFINJ_N



DoDSER-A 1 tbDoDSER_Patient_2004 280 RISK_SELFINJ_X
Yes 9/8/2009 varchar(255) Null
RISK_SELFINJ_X



DoDSER-A 1 tbDoDSER_Patient_2004 281 RISK_SELFINJ_NUM_ONE
Yes 9/8/2009 varchar(255) Null
RISK_SELFINJ_NUM_ONE



DoDSER-A 1 tbDoDSER_Patient_2004 282 RISK_SELFINJ_NUM_MORE
Yes 9/8/2009 varchar(255) Null
RISK_SELFINJ_NUM_MORE



DoDSER-A 1 tbDoDSER_Patient_2004 283 RISK_SELFINJ_SIMILAR_Y
Yes 9/8/2009 varchar(255) Null
RISK_SELFINJ_SIMILAR_Y



DoDSER-A 1 tbDoDSER_Patient_2004 284 RISK_SELFINJ_SIMILAR_N
Yes 9/8/2009 varchar(255) Null
RISK_SELFINJ_SIMILAR_N



DoDSER-A 1 tbDoDSER_Patient_2004 285 RISK_SELFINJ_SIMILAR_X
Yes 9/8/2009 varchar(255) Null
RISK_SELFINJ_SIMILAR_X



DoDSER-A 1 tbDoDSER_Patient_2004 286 RISK_GUN_Y
Yes 9/8/2009 varchar(255) Null
RISK_GUN_Y



DoDSER-A 1 tbDoDSER_Patient_2004 287 RISK_GUN_N
Yes 9/8/2009 varchar(255) Null
RISK_GUN_N



DoDSER-A 1 tbDoDSER_Patient_2004 288 RISK_GUN_X
Yes 9/8/2009 varchar(255) Null
RISK_GUN_X



DoDSER-A 1 tbDoDSER_Patient_2004 289 HIST_RELATION_Y
Yes 9/8/2009 varchar(255) Null
HIST_RELATION_Y



DoDSER-A 1 tbDoDSER_Patient_2004 290 HIST_RELATION_N
Yes 9/8/2009 varchar(255) Null
HIST_RELATION_N



DoDSER-A 1 tbDoDSER_Patient_2004 291 HIST_RELATION_X
Yes 9/8/2009 varchar(255) Null
HIST_RELATION_X



DoDSER-A 1 tbDoDSER_Patient_2004 292 HIST_FAMDEATH_Y
Yes 9/8/2009 varchar(255) Null
HIST_FAMDEATH_Y



DoDSER-A 1 tbDoDSER_Patient_2004 293 HIST_FAMDEATH_N
Yes 9/8/2009 varchar(255) Null
HIST_FAMDEATH_N



DoDSER-A 1 tbDoDSER_Patient_2004 294 HIST_FAMDEATH_X
Yes 9/8/2009 varchar(255) Null
HIST_FAMDEATH_X



DoDSER-A 1 tbDoDSER_Patient_2004 295 HIST_FAMILLNESS_Y
Yes 9/8/2009 varchar(255) Null
HIST_FAMILLNESS_Y



DoDSER-A 1 tbDoDSER_Patient_2004 296 HIST_FAMILLNESS_N
Yes 9/8/2009 varchar(255) Null
HIST_FAMILLNESS_N



DoDSER-A 1 tbDoDSER_Patient_2004 297 HIST_FAMILLNESS_X
Yes 9/8/2009 varchar(255) Null
HIST_FAMILLNESS_X



DoDSER-A 1 tbDoDSER_Patient_2004 298 EVENT_MOTIVATION_ESC
Yes 9/8/2009 varchar(255) Null
EVENT_MOTIVATION_ESC



DoDSER-A 1 tbDoDSER_Patient_2004 299 EVENT_MOTIVATION_RST
Yes 9/8/2009 varchar(255) Null
EVENT_MOTIVATION_RST



DoDSER-A 1 tbDoDSER_Patient_2004 300 EVENT_MOTIVATION_ANG
Yes 9/8/2009 varchar(255) Null
EVENT_MOTIVATION_ANG



DoDSER-A 1 tbDoDSER_Patient_2004 301 EVENT_MOTIVATION_SHM
Yes 9/8/2009 varchar(255) Null
EVENT_MOTIVATION_SHM



DoDSER-A 1 tbDoDSER_Patient_2004 302 EVENT_MOTIVATION_RES
Yes 9/8/2009 varchar(255) Null
EVENT_MOTIVATION_RES



DoDSER-A 1 tbDoDSER_Patient_2004 303 EVENT_MOTIVATION_COM
Yes 9/8/2009 varchar(255) Null
EVENT_MOTIVATION_COM



DoDSER-A 1 tbDoDSER_Patient_2004 304 EVENT_MOTIVATION_OTH
Yes 9/8/2009 varchar(255) Null
EVENT_MOTIVATION_OTH



DoDSER-A 1 tbDoDSER_Patient_2004 306 EVENT_MOTIVATION_X
Yes 9/8/2009 varchar(255) Null
EVENT_MOTIVATION_X



DoDSER-A 1 tbDoDSER_Patient_2004 307 HIST_PHYSABUSE_Y
Yes 9/8/2009 varchar(255) Null
HIST_PHYSABUSE_Y



DoDSER-A 1 tbDoDSER_Patient_2004 308 HIST_PHYSABUSE_N
Yes 9/8/2009 varchar(255) Null
HIST_PHYSABUSE_N



DoDSER-A 1 tbDoDSER_Patient_2004 309 HIST_PHYSABUSE_X
Yes 9/8/2009 varchar(255) Null
HIST_PHYSABUSE_X



DoDSER-A 1 tbDoDSER_Patient_2004 310 HIST_SEXABUSE_Y
Yes 9/8/2009 varchar(255) Null
HIST_SEXABUSE_Y



DoDSER-A 1 tbDoDSER_Patient_2004 311 HIST_SEXABUSE_N
Yes 9/8/2009 varchar(255) Null
HIST_SEXABUSE_N



DoDSER-A 1 tbDoDSER_Patient_2004 312 HIST_SEXABUSE_X
Yes 9/8/2009 varchar(255) Null
HIST_SEXABUSE_X



DoDSER-A 1 tbDoDSER_Patient_2004 313 HIST_EMOTABUSE_Y
Yes 9/8/2009 varchar(255) Null
HIST_EMOTABUSE_Y



DoDSER-A 1 tbDoDSER_Patient_2004 314 HIST_EMOTABUSE_N
Yes 9/8/2009 varchar(255) Null
HIST_EMOTABUSE_N



DoDSER-A 1 tbDoDSER_Patient_2004 315 HIST_EMOTABUSE_X
Yes 9/8/2009 varchar(255) Null
HIST_EMOTABUSE_X



DoDSER-A 1 tbDoDSER_Patient_2004 316 HIST_SEXHARASS_Y
Yes 9/8/2009 varchar(255) Null
HIST_SEXHARASS_Y



DoDSER-A 1 tbDoDSER_Patient_2004 317 HIST_SEXHARASS_N
Yes 9/8/2009 varchar(255) Null
HIST_SEXHARASS_N



DoDSER-A 1 tbDoDSER_Patient_2004 318 HIST_SEXHARASS_X
Yes 9/8/2009 varchar(255) Null
HIST_SEXHARASS_X



DoDSER-A 1 tbDoDSER_Patient_2004 319 HIST_COURTSMARTIAL_Y
Yes 9/8/2009 varchar(255) Null
HIST_COURTSMARTIAL_Y



DoDSER-A 1 tbDoDSER_Patient_2004 320 HIST_COURTSMARTIAL_N
Yes 9/8/2009 varchar(255) Null
HIST_COURTSMARTIAL_N



DoDSER-A 1 tbDoDSER_Patient_2004 321 HIST_COURTSMARTIAL_X
Yes 9/8/2009 varchar(255) Null
HIST_COURTSMARTIAL_X



DoDSER-A 1 tbDoDSER_Patient_2004 322 HIST_ARTICLE15_Y
Yes 9/8/2009 varchar(255) Null
HIST_ARTICLE15_Y



DoDSER-A 1 tbDoDSER_Patient_2004 323 HIST_ARTICLE15_N
Yes 9/8/2009 varchar(255) Null
HIST_ARTICLE15_N



DoDSER-A 1 tbDoDSER_Patient_2004 324 HIST_ARTICLE15_X
Yes 9/8/2009 varchar(255) Null
HIST_ARTICLE15_X



DoDSER-A 1 tbDoDSER_Patient_2004 325 HIST_ADMINSEP_Y
Yes 9/8/2009 varchar(255) Null
HIST_ADMINSEP_Y



DoDSER-A 1 tbDoDSER_Patient_2004 326 HIST_ADMINSEP_N
Yes 9/8/2009 varchar(255) Null
HIST_ADMINSEP_N



DoDSER-A 1 tbDoDSER_Patient_2004 327 HIST_ADMINSEP_X
Yes 9/8/2009 varchar(255) Null
HIST_ADMINSEP_X



DoDSER-A 1 tbDoDSER_Patient_2004 328 HIST_AWOL_Y
Yes 9/8/2009 varchar(255) Null
HIST_AWOL_Y



DoDSER-A 1 tbDoDSER_Patient_2004 329 HIST_AWOL_N
Yes 9/8/2009 varchar(255) Null
HIST_AWOL_N



DoDSER-A 1 tbDoDSER_Patient_2004 330 HIST_AWOL_X
Yes 9/8/2009 varchar(255) Null
HIST_AWOL_X



DoDSER-A 1 tbDoDSER_Patient_2004 331 HIST_NONSELECT_Y
Yes 9/8/2009 varchar(255) Null
HIST_NONSELECT_Y



DoDSER-A 1 tbDoDSER_Patient_2004 332 HIST_NONSELECT_N
Yes 9/8/2009 varchar(255) Null
HIST_NONSELECT_N



DoDSER-A 1 tbDoDSER_Patient_2004 333 HIST_NONSELECT_X
Yes 9/8/2009 varchar(255) Null
HIST_NONSELECT_X



DoDSER-A 1 tbDoDSER_Patient_2004 334 HIST_WORK_Y
Yes 9/8/2009 varchar(255) Null
HIST_WORK_Y



DoDSER-A 1 tbDoDSER_Patient_2004 335 HIST_WORK_N
Yes 9/8/2009 varchar(255) Null
HIST_WORK_N



DoDSER-A 1 tbDoDSER_Patient_2004 336 HIST_WORK_X
Yes 9/8/2009 varchar(255) Null
HIST_WORK_X



DoDSER-A 1 tbDoDSER_Patient_2004 337 HIST_SUPER_Y
Yes 9/8/2009 varchar(255) Null
HIST_SUPER_Y



DoDSER-A 1 tbDoDSER_Patient_2004 338 HIST_SUPER_N
Yes 9/8/2009 varchar(255) Null
HIST_SUPER_N



DoDSER-A 1 tbDoDSER_Patient_2004 339 HIST_SUPER_X
Yes 9/8/2009 varchar(255) Null
HIST_SUPER_X



DoDSER-A 1 tbDoDSER_Patient_2004 340 HIST_PERFORM_Y
Yes 9/8/2009 varchar(255) Null
HIST_PERFORM_Y



DoDSER-A 1 tbDoDSER_Patient_2004 341 HIST_PERFORM_N
Yes 9/8/2009 varchar(255) Null
HIST_PERFORM_N



DoDSER-A 1 tbDoDSER_Patient_2004 342 HIST_PERFORM_X
Yes 9/8/2009 varchar(255) Null
HIST_PERFORM_X



DoDSER-A 1 tbDoDSER_Patient_2004 343 HIST_HAZING_Y
Yes 9/8/2009 varchar(255) Null
HIST_HAZING_Y



DoDSER-A 1 tbDoDSER_Patient_2004 344 HIST_HAZING_N
Yes 9/8/2009 varchar(255) Null
HIST_HAZING_N



DoDSER-A 1 tbDoDSER_Patient_2004 345 HIST_HAZING_X
Yes 9/8/2009 varchar(255) Null
HIST_HAZING_X



DoDSER-A 1 tbDoDSER_Patient_2004 346 HIST_WORK_OTH_Y
Yes 9/8/2009 varchar(255) Null
HIST_WORK_OTH_Y



DoDSER-A 1 tbDoDSER_Patient_2004 347 HIST_WORK_OTH_N
Yes 9/8/2009 varchar(255) Null
HIST_WORK_OTH_N



DoDSER-A 1 tbDoDSER_Patient_2004 348 HIST_WORK_OTH_X
Yes 9/8/2009 varchar(255) Null
HIST_WORK_OTH_X



DoDSER-A 1 tbDoDSER_Patient_2004 350 HIST_DEBT_Y
Yes 9/8/2009 varchar(255) Null
HIST_DEBT_Y



DoDSER-A 1 tbDoDSER_Patient_2004 351 HIST_DEBT_N
Yes 9/8/2009 varchar(255) Null
HIST_DEBT_N



DoDSER-A 1 tbDoDSER_Patient_2004 352 HIST_DEBT_X
Yes 9/8/2009 varchar(255) Null
HIST_DEBT_X



DoDSER-A 1 tbDoDSER_Patient_2004 353 HIST_BANKRUPT_Y
Yes 9/8/2009 varchar(255) Null
HIST_BANKRUPT_Y



DoDSER-A 1 tbDoDSER_Patient_2004 354 HIST_BANKRUPT_N
Yes 9/8/2009 varchar(255) Null
HIST_BANKRUPT_N



DoDSER-A 1 tbDoDSER_Patient_2004 355 HIST_BANKRUPT_X
Yes 9/8/2009 varchar(255) Null
HIST_BANKRUPT_X



DoDSER-A 1 tbDoDSER_Patient_2004 361 SUM_CIRC
Yes 9/8/2009 varchar(255) Null
SUM_CIRC



DoDSER-A 1 tbDoDSER_Patient_2004 362 SUM_BPS
Yes 9/8/2009 varchar(255) Null
SUM_BPS



DoDSER-A 1 tbDoDSER_Patient_2004 363 SUM_RISK
Yes 9/8/2009 varchar(255) Null
SUM_RISK



DoDSER-A 1 tbDoDSER_Patient_2004 364 IMPORT_DATE
Yes 9/8/2009 datetime Null
IMPORT_DATE



DoDSER-A 1 tbDoDSER_Patient_2004 365 RECORDID
Yes 9/8/2009 float Null
RECORDID



DoDSER-A 1 tbDoDSER_Patient_2004 366 EVENT_DATE
Yes 9/8/2009 datetime Null
EVENT_DATE



DoDSER-A 1 tbDoDSER_Patient_2004 367 PATIENT_DOB
Yes 9/8/2009 datetime Null
PATIENT_DOB



DoDSER-A 1 tbDoDSER_Patient_2004 368 EVENT_DEPLOY_START
Yes 9/8/2009 datetime Null
EVENT_DEPLOY_START



DoDSER-A 1 tbDoDSER_Patient_2004 369 EVENT_DEPLOY_END
Yes 9/8/2009 datetime Null
EVENT_DEPLOY_END



DoDSER-A 1 tbDoDSER_Patient_2004 370 EVENT_ADMIT_DATE
Yes 9/8/2009 datetime Null
EVENT_ADMIT_DATE



DoDSER-A 1 tbDoDSER_Patient_2004 371 EVENT_DISCHARGE_DATE
Yes 9/8/2009 datetime Null
EVENT_DISCHARGE_DATE



Sheet 3: 3.DoDSER-2005-062009 NIMH Atr
Source Source Tab Ord SourceTable Source Field Ord FieldName PII/HIPAA Sensitive NIMH Approval NIMH SP2Delta FieldType Nullability Primary Key Title Desc FDM Comments ADS Comment Code Table Reference
DoDSER-A 2 tbDoDSER_Patient 1 ckid
Yes 9/8/2009 int Not Null PK ckid



DoDSER-A 2 tbDoDSER_Patient 2 LoadDate
Yes 9/8/2009 datetime Null
LoadDate



DoDSER-A 2 tbDoDSER_Patient 3 ckWSSoldierID DI Yes 9/8/2009 int Null
ckWSSoldierID



DoDSER-A 2 tbDoDSER_Patient 4 Event_Date
Yes 9/8/2009 datetime Null
Event_Date



DoDSER-A 2 tbDoDSER_Patient 5 VERS
Yes 9/8/2009 varchar(255) Null
VERS



DoDSER-A 2 tbDoDSER_Patient 9 PAT_SSN DI Yes 9/8/2009 varchar(255) Null
PAT_SSN



DoDSER-A 2 tbDoDSER_Patient 10 PAT_DOB
Yes 9/8/2009 datetime Null
PAT_DOB



DoDSER-A 2 tbDoDSER_Patient 11 PAT_SEX
Yes 9/8/2009 varchar(255) Null
PAT_SEX



DoDSER-A 2 tbDoDSER_Patient 12 PAT_SPONSOR_RELATION
Yes 9/8/2009 varchar(255) Null
PAT_SPONSOR_RELATION



DoDSER-A 2 tbDoDSER_Patient 14 PAT_SERVICE
Yes 9/8/2009 varchar(255) Null
PAT_SERVICE



DoDSER-A 2 tbDoDSER_Patient 16 PAT_RACE
Yes 9/8/2009 varchar(255) Null
PAT_RACE



DoDSER-A 2 tbDoDSER_Patient 18 PAT_ETHNIC
Yes 9/8/2009 varchar(255) Null
PAT_ETHNIC



DoDSER-A 2 tbDoDSER_Patient 19 PAT_MARITAL
Yes 9/8/2009 varchar(255) Null
PAT_MARITAL



DoDSER-A 2 tbDoDSER_Patient 20 PAT_MARITAL_RESIDE
Yes 9/8/2009 varchar(255) Null
PAT_MARITAL_RESIDE



DoDSER-A 2 tbDoDSER_Patient 21 PAT_EDUCATION
Yes 9/8/2009 varchar(255) Null
PAT_EDUCATION



DoDSER-A 2 tbDoDSER_Patient 24 PAT_RESIDE_ALONE
Yes 9/8/2009 varchar(255) Null
PAT_RESIDE_ALONE



DoDSER-A 2 tbDoDSER_Patient 25 PAT_CHILDREN
Yes 9/8/2009 varchar(255) Null
PAT_CHILDREN



DoDSER-A 2 tbDoDSER_Patient 26 PAT_CHILDREN_RESIDE_WITH
Yes 9/8/2009 varchar(255) Null
PAT_CHILDREN_RESIDE_WITH



DoDSER-A 3 tbDoDSER_Sponsor 1 ckid
Yes 9/8/2009 int Not Null PK ckid



DoDSER-A 3 tbDoDSER_Sponsor 2 LoadDate
Yes 9/8/2009 datetime Null
LoadDate



DoDSER-A 3 tbDoDSER_Sponsor 3 ckWSSoldierID DI Yes 9/8/2009 int Null
ckWSSoldierID



DoDSER-A 3 tbDoDSER_Sponsor 4 SPONSOR_SERVICE
Yes 9/8/2009 int Null
SPONSOR_SERVICE



DoDSER-A 3 tbDoDSER_Sponsor 6 SPONSOR_COMPONENT
Yes 9/8/2009 int Null
SPONSOR_COMPONENT



DoDSER-A 3 tbDoDSER_Sponsor 8 SPONSOR_JOB_CODE
Yes 9/8/2009 int Null
SPONSOR_JOB_CODE



DoDSER-A 3 tbDoDSER_Sponsor 9 SPONSOR_JOB_CODE_TEXT
Yes 9/8/2009 nvarchar(255) Null
SPONSOR_JOB_CODE_TEXT



DoDSER-A 3 tbDoDSER_Sponsor 10 SPONSOR_JOB_CODE_OTHER
Yes 9/8/2009 nvarchar(255) Null
SPONSOR_JOB_CODE_OTHER



DoDSER-A 3 tbDoDSER_Sponsor 11 SPONSOR_JOB_CODE_NON_ARMY
Yes 9/8/2009 nvarchar(255) Null
SPONSOR_JOB_CODE_NON_ARMY



DoDSER-A 3 tbDoDSER_Sponsor 12 SPONSOR_DUTY_STATUS_ACTIVE
Yes 9/8/2009 int Null
SPONSOR_DUTY_STATUS_ACTIVE



DoDSER-A 3 tbDoDSER_Sponsor 13 SPONSOR_DUTY_STATUS_AGR
Yes 9/8/2009 int Null
SPONSOR_DUTY_STATUS_AGR



DoDSER-A 3 tbDoDSER_Sponsor 14 SPONSOR_DUTY_STATUS_IET
Yes 9/8/2009 int Null
SPONSOR_DUTY_STATUS_IET



DoDSER-A 3 tbDoDSER_Sponsor 15 SPONSOR_DUTY_STATUS_MOBILIZED
Yes 9/8/2009 int Null
SPONSOR_DUTY_STATUS_MOBILIZED



DoDSER-A 3 tbDoDSER_Sponsor 16 SPONSOR_DUTY_STATUS_ADT
Yes 9/8/2009 int Null
SPONSOR_DUTY_STATUS_ADT



DoDSER-A 3 tbDoDSER_Sponsor 17 SPONSOR_DUTY_STATUS_IDT
Yes 9/8/2009 int Null
SPONSOR_DUTY_STATUS_IDT



DoDSER-A 3 tbDoDSER_Sponsor 18 SPONSOR_DUTY_STATUS_RETIRED
Yes 9/8/2009 int Null
SPONSOR_DUTY_STATUS_RETIRED



DoDSER-A 3 tbDoDSER_Sponsor 19 SPONSOR_DUTY_STATUS_RELEASED
Yes 9/8/2009 int Null
SPONSOR_DUTY_STATUS_RELEASED



DoDSER-A 3 tbDoDSER_Sponsor 20 SPONSOR_DUTY_STATUS_OTHER
Yes 9/8/2009 int Null
SPONSOR_DUTY_STATUS_OTHER



DoDSER-A 3 tbDoDSER_Sponsor 22 SPONSOR_DUTY_STATUS_NA
Yes 9/8/2009 nvarchar(255) Null
SPONSOR_DUTY_STATUS_NA



DoDSER-A 3 tbDoDSER_Sponsor 23 SPONSOR_GRADE DI Yes 9/8/2009 int Null
SPONSOR_GRADE



DoDSER-A 3 tbDoDSER_Sponsor 24 SPONSOR_DUTY_STATION_SAME
Yes 9/8/2009 int Null
SPONSOR_DUTY_STATION_SAME



DoDSER-A 3 tbDoDSER_Sponsor 25 SPONSOR_DUTY_STATION_COUNTRY
Yes 9/8/2009 int Null
SPONSOR_DUTY_STATION_COUNTRY



DoDSER-A 3 tbDoDSER_Sponsor 26 SPONSOR_DUTY_STAT_CTRY_NAME
Yes 9/8/2009 nvarchar(255) Null
SPONSOR_DUTY_STAT_CTRY_NAME



DoDSER-A 3 tbDoDSER_Sponsor 27 SPONSOR_DUTY_STAT_CTRY_OTHER
Yes 9/8/2009 nvarchar(255) Null
SPONSOR_DUTY_STAT_CTRY_OTHER



DoDSER-A 3 tbDoDSER_Sponsor 28 SPONSOR_DUTY_STATION_STATE
Yes 9/8/2009 int Null
SPONSOR_DUTY_STATION_STATE



DoDSER-A 3 tbDoDSER_Sponsor 29 SPONSOR_DUTY_STAT_STATE_NAME
Yes 9/8/2009 nvarchar(255) Null
SPONSOR_DUTY_STAT_STATE_NAME



DoDSER-A 3 tbDoDSER_Sponsor 30 SPONSOR_DUTY_STATION_CITY
Yes 9/8/2009 nvarchar(255) Null
SPONSOR_DUTY_STATION_CITY



DoDSER-A 3 tbDoDSER_Sponsor 42 SPONSOR_UIC DI Yes 9/8/2009 nvarchar(255) Null
SPONSOR_UIC



DoDSER-A 3 tbDoDSER_Sponsor 43 SPONSOR_TIME_UNIT_YEARS
Yes 9/8/2009 int Null
SPONSOR_TIME_UNIT_YEARS



DoDSER-A 3 tbDoDSER_Sponsor 44 SPONSOR_TIME_UNIT_MONTHS
Yes 9/8/2009 int Null
SPONSOR_TIME_UNIT_MONTHS



DoDSER-A 3 tbDoDSER_Sponsor 45 SPONSOR_TIME_UNIT_UNKNOWN
Yes 9/8/2009 int Null
SPONSOR_TIME_UNIT_UNKNOWN



DoDSER-A 4 tbDoDSER_Completer 1 ckid
Yes 9/8/2009 int Not Null PK ckid



DoDSER-A 4 tbDoDSER_Completer 2 LoadDate
Yes 9/8/2009 int Null
LoadDate



DoDSER-A 4 tbDoDSER_Completer 3 ckWSSoldierID DI Yes 9/8/2009 int Null
ckWSSoldierID



DoDSER-A 4 tbDoDSER_Completer 4 ASER_LOC_SAME
Yes 9/8/2009 int Null
ASER_LOC_SAME



DoDSER-A 4 tbDoDSER_Completer 5 ASER_LOC_COUNTRY
Yes 9/8/2009 int Null
ASER_LOC_COUNTRY



DoDSER-A 4 tbDoDSER_Completer 6 ASER_LOC_COUNTRY_NAME
Yes 9/8/2009 nvarchar(255) Null
ASER_LOC_COUNTRY_NAME



DoDSER-A 4 tbDoDSER_Completer 7 ASER_LOC_COUNTRY_OTHER
Yes 9/8/2009 nvarchar(255) Null
ASER_LOC_COUNTRY_OTHER



DoDSER-A 4 tbDoDSER_Completer 8 ASER_LOC_STATE
Yes 9/8/2009 int Null
ASER_LOC_STATE



DoDSER-A 4 tbDoDSER_Completer 9 ASER_LOC_STATE_NAME
Yes 9/8/2009 nvarchar(255) Null
ASER_LOC_STATE_NAME



DoDSER-A 4 tbDoDSER_Completer 10 ASER_LOC_CITY
Yes 9/8/2009 nvarchar(255) Null
ASER_LOC_CITY



DoDSER-A 4 tbDoDSER_Completer 11 ASER_LOC_MEDICAL_FACILITY
Yes 9/8/2009 int Null
ASER_LOC_MEDICAL_FACILITY



DoDSER-A 4 tbDoDSER_Completer 12 ASER_LOC_MED_FACILITY_NAME
Yes 9/8/2009 nvarchar(255) Null
ASER_LOC_MED_FACILITY_NAME



DoDSER-A 4 tbDoDSER_Completer 13 ASER_LOC_MED_FACILITY_OTHER
Yes 9/8/2009 nvarchar(255) Null
ASER_LOC_MED_FACILITY_OTHER



DoDSER-A 4 tbDoDSER_Completer 14 DODSER_LOC_MED_FACILITY_AF
Yes 9/8/2009 nvarchar(255) Null
DODSER_LOC_MED_FACILITY_AF



DoDSER-A 4 tbDoDSER_Completer 15 DODSER_LOC_MED_FACILITY_AF_OTH
Yes 9/8/2009 nvarchar(255) Null
DODSER_LOC_MED_FACILITY_AF_OTH



DoDSER-A 4 tbDoDSER_Completer 16 DODSER_LOC_MED_FACILITY_OTHER
Yes 9/8/2009 nvarchar(255) Null
DODSER_LOC_MED_FACILITY_OTHER



DoDSER-A 4 tbDoDSER_Completer 18 ASER_PROVIDER_RANK DI Yes 9/8/2009 nvarchar(255) Null
ASER_PROVIDER_RANK



DoDSER-A 4 tbDoDSER_Completer 19 ASER_PROVIDER_SSN DI Yes 9/8/2009 int Null
ASER_PROVIDER_SSN



DoDSER-A 4 tbDoDSER_Completer 23 ASER_PROVIDER_SPECIALTY_23
Yes 9/8/2009 nvarchar(255) Null
ASER_PROVIDER_SPECIALTY_23



DoDSER-A 4 tbDoDSER_Completer 24 ASER_PROVIDER_SPECIALTY_221
Yes 9/8/2009 nvarchar(255) Null
ASER_PROVIDER_SPECIALTY_221



DoDSER-A 4 tbDoDSER_Completer 25 ASER_PROV_SPEC_LOOKUP
Yes 9/8/2009 nvarchar(255) Null
ASER_PROV_SPEC_LOOKUP



DoDSER-A 4 tbDoDSER_Completer 27 SOURCE_INTERVIEW_PATIENT
Yes 9/8/2009 int Null
SOURCE_INTERVIEW_PATIENT



DoDSER-A 4 tbDoDSER_Completer 28 SOURCE_INTERVIEW_COWORKERS
Yes 9/8/2009 int Null
SOURCE_INTERVIEW_COWORKERS



DoDSER-A 4 tbDoDSER_Completer 29 SOURCE_INTERVIEW_OFFICER
Yes 9/8/2009 int Null
SOURCE_INTERVIEW_OFFICER



DoDSER-A 4 tbDoDSER_Completer 30 SOURCE_INTERVIEW_PROFESSIONALS
Yes 9/8/2009 int Null
SOURCE_INTERVIEW_PROFESSIONALS



DoDSER-A 4 tbDoDSER_Completer 31 SOURCE_INTERVIEW_FAMILY
Yes 9/8/2009 int Null
SOURCE_INTERVIEW_FAMILY



DoDSER-A 4 tbDoDSER_Completer 32 SOURCE_REVIEW_MEDICAL
Yes 9/8/2009 int Null
SOURCE_REVIEW_MEDICAL



DoDSER-A 4 tbDoDSER_Completer 33 SOURCE_REVIEW_ADVOCACY
Yes 9/8/2009 int Null
SOURCE_REVIEW_ADVOCACY



DoDSER-A 4 tbDoDSER_Completer 34 SOURCE_REVIEW_SUBSTANCE
Yes 9/8/2009 int Null
SOURCE_REVIEW_SUBSTANCE



DoDSER-A 4 tbDoDSER_Completer 35 SOURCE_REVIEW_SUB_AB_NOT_ARMY
Yes 9/8/2009 int Null
SOURCE_REVIEW_SUB_AB_NOT_ARMY



DoDSER-A 4 tbDoDSER_Completer 36 SOURCE_REVIEW_PERSONNEL
Yes 9/8/2009 int Null
SOURCE_REVIEW_PERSONNEL



DoDSER-A 4 tbDoDSER_Completer 37 SOURCE_REVIEW_AGENCY
Yes 9/8/2009 int Null
SOURCE_REVIEW_AGENCY



DoDSER-A 4 tbDoDSER_Completer 38 SOURCE_REVIEW_COURTMARTIAL
Yes 9/8/2009 int Null
SOURCE_REVIEW_COURTMARTIAL



DoDSER-A 4 tbDoDSER_Completer 39 SOURCE_REVIEW_MANNER
Yes 9/8/2009 int Null
SOURCE_REVIEW_MANNER



DoDSER-A 4 tbDoDSER_Completer 41 ASER_COMPLETER_RANK DI Yes 9/8/2009 nvarchar(255) Null
ASER_COMPLETER_RANK



DoDSER-A 4 tbDoDSER_Completer 43 ASER_COMPLETER_SSN DI Yes 9/8/2009 int Null
ASER_COMPLETER_SSN



DoDSER-A 4 tbDoDSER_Completer 48 UPDATE_DATE
Yes 9/8/2009 datetime Null
UPDATE_DATE



DoDSER-A 5 tbDoDSER_History 1 ckid
Yes 9/8/2009 int Not Null PK ckid



DoDSER-A 5 tbDoDSER_History 2 LoadDate
Yes 9/8/2009 datetime Null
LoadDate



DoDSER-A 5 tbDoDSER_History 3 ckWSSoldierID DI Yes 9/8/2009 int Null
ckWSSoldierID



DoDSER-A 5 tbDoDSER_History 4 HIST_MTF
Yes 9/8/2009 int Null
HIST_MTF



DoDSER-A 5 tbDoDSER_History 5 HIST_MTF_TIME
Yes 9/8/2009 int Null
HIST_MTF_TIME



DoDSER-A 5 tbDoDSER_History 6 HIST_SAS
Yes 9/8/2009 int Null
HIST_SAS



DoDSER-A 5 tbDoDSER_History 7 HIST_SAS_TIME
Yes 9/8/2009 int Null
HIST_SAS_TIME



DoDSER-A 5 tbDoDSER_History 8 HIST_FAP
Yes 9/8/2009 int Null
HIST_FAP



DoDSER-A 5 tbDoDSER_History 9 HIST_FAP_TIME
Yes 9/8/2009 int Null
HIST_FAP_TIME



DoDSER-A 5 tbDoDSER_History 10 HIST_CHAPLAIN
Yes 9/8/2009 int Null
HIST_CHAPLAIN



DoDSER-A 5 tbDoDSER_History 11 HIST_CHAPLAIN_TIME
Yes 9/8/2009 int Null
HIST_CHAPLAIN_TIME



DoDSER-A 5 tbDoDSER_History 12 HIST_OUTPATIENT_MH
Yes 9/8/2009 int Null
HIST_OUTPATIENT_MH



DoDSER-A 5 tbDoDSER_History 13 HIST_OUTPATIENT_MH_TIME
Yes 9/8/2009 int Null
HIST_OUTPATIENT_MH_TIME



DoDSER-A 5 tbDoDSER_History 14 HIST_INPATIENT_MH
Yes 9/8/2009 int Null
HIST_INPATIENT_MH



DoDSER-A 5 tbDoDSER_History 15 HIST_INPATIENT_MH_TIME
Yes 9/8/2009 int Null
HIST_INPATIENT_MH_TIME



DoDSER-A 5 tbDoDSER_History 16 HIST_MOOD
Yes 9/8/2009 int Null
HIST_MOOD



DoDSER-A 5 tbDoDSER_History 17 HIST_MOOD_TIME
Yes 9/8/2009 int Null
HIST_MOOD_TIME



DoDSER-A 5 tbDoDSER_History 18 HIST_BIPOLAR
Yes 9/8/2009 int Null
HIST_BIPOLAR



DoDSER-A 5 tbDoDSER_History 19 HIST_BIPOLAR_TIME
Yes 9/8/2009 int Null
HIST_BIPOLAR_TIME



DoDSER-A 5 tbDoDSER_History 20 HIST_MAJOR_DEPRESSION
Yes 9/8/2009 int Null
HIST_MAJOR_DEPRESSION



DoDSER-A 5 tbDoDSER_History 21 HIST_MAJOR_DEPRESSION_TIME
Yes 9/8/2009 int Null
HIST_MAJOR_DEPRESSION_TIME



DoDSER-A 5 tbDoDSER_History 22 HIST_DYSTHYMIC
Yes 9/8/2009 int Null
HIST_DYSTHYMIC



DoDSER-A 5 tbDoDSER_History 23 HIST_DYSTHYMIC_TIME
Yes 9/8/2009 int Null
HIST_DYSTHYMIC_TIME



DoDSER-A 5 tbDoDSER_History 24 HIST_OTHERMOOD
Yes 9/8/2009 int Null
HIST_OTHERMOOD



DoDSER-A 5 tbDoDSER_History 25 HIST_OTHERMOOD_TIME
Yes 9/8/2009 int Null
HIST_OTHERMOOD_TIME



DoDSER-A 5 tbDoDSER_History 26 HIST_ANXIETY
Yes 9/8/2009 int Null
HIST_ANXIETY



DoDSER-A 5 tbDoDSER_History 27 HIST_ANXIETY_TIME
Yes 9/8/2009 int Null
HIST_ANXIETY_TIME



DoDSER-A 5 tbDoDSER_History 28 HIST_PTSD
Yes 9/8/2009 int Null
HIST_PTSD



DoDSER-A 5 tbDoDSER_History 29 HIST_PTSD_TIME
Yes 9/8/2009 int Null
HIST_PTSD_TIME



DoDSER-A 5 tbDoDSER_History 30 HIST_PANIC
Yes 9/8/2009 int Null
HIST_PANIC



DoDSER-A 5 tbDoDSER_History 31 HIST_PANIC_TIME
Yes 9/8/2009 int Null
HIST_PANIC_TIME



DoDSER-A 5 tbDoDSER_History 32 HIST_GENANXIETY
Yes 9/8/2009 int Null
HIST_GENANXIETY



DoDSER-A 5 tbDoDSER_History 33 HIST_GENANXIETY_TIME
Yes 9/8/2009 int Null
HIST_GENANXIETY_TIME



DoDSER-A 5 tbDoDSER_History 34 HIST_STRESS
Yes 9/8/2009 int Null
HIST_STRESS



DoDSER-A 5 tbDoDSER_History 35 HIST_STRESS_TIME
Yes 9/8/2009 int Null
HIST_STRESS_TIME



DoDSER-A 5 tbDoDSER_History 36 HIST_OTHERANXIETY
Yes 9/8/2009 int Null
HIST_OTHERANXIETY



DoDSER-A 5 tbDoDSER_History 37 HIST_OTHERANXIETY_TIME
Yes 9/8/2009 int Null
HIST_OTHERANXIETY_TIME



DoDSER-A 5 tbDoDSER_History 38 HIST_PERSONALITY
Yes 9/8/2009 int Null
HIST_PERSONALITY



DoDSER-A 5 tbDoDSER_History 39 HIST_PERSONALITY_TIME
Yes 9/8/2009 int Null
HIST_PERSONALITY_TIME



DoDSER-A 5 tbDoDSER_History 40 HIST_PSYCHOTIC
Yes 9/8/2009 int Null
HIST_PSYCHOTIC



DoDSER-A 5 tbDoDSER_History 41 HIST_PSYCHOTIC_TIME
Yes 9/8/2009 int Null
HIST_PSYCHOTIC_TIME



DoDSER-A 5 tbDoDSER_History 42 HIST_SUBSTANCE_ABUSE
Yes 9/8/2009 int Null
HIST_SUBSTANCE_ABUSE



DoDSER-A 5 tbDoDSER_History 43 HIST_SUBSTANCE_ABUSE_TIME
Yes 9/8/2009 int Null
HIST_SUBSTANCE_ABUSE_TIME



DoDSER-A 5 tbDoDSER_History 44 HIST_SUBSTANCE_ALCOHOL_DEP
Yes 9/8/2009 int Null
HIST_SUBSTANCE_ALCOHOL_DEP



DoDSER-A 5 tbDoDSER_History 45 HIST_SUBSTANCE_ALCOHOL_ABUSE
Yes 9/8/2009 int Null
HIST_SUBSTANCE_ALCOHOL_ABUSE



DoDSER-A 5 tbDoDSER_History 46 HIST_SUBSTANCE_DRUGS_DEP
Yes 9/8/2009 int Null
HIST_SUBSTANCE_DRUGS_DEP



DoDSER-A 5 tbDoDSER_History 47 HIST_SUBSTANCE_DRUGS_ABUSE
Yes 9/8/2009 int Null
HIST_SUBSTANCE_DRUGS_ABUSE



DoDSER-A 5 tbDoDSER_History 48 HIST_SUBSTANCE_PRESCRIP_DEP
Yes 9/8/2009 int Null
HIST_SUBSTANCE_PRESCRIP_DEP



DoDSER-A 5 tbDoDSER_History 49 HIST_SUBSTANCE_PRESCRIP_ABUSE
Yes 9/8/2009 int Null
HIST_SUBSTANCE_PRESCRIP_ABUSE



DoDSER-A 5 tbDoDSER_History 50 HIST_SUBSTANCE_OTC_DEP
Yes 9/8/2009 int Null
HIST_SUBSTANCE_OTC_DEP



DoDSER-A 5 tbDoDSER_History 51 HIST_SUBSTANCE_OTC_ABUSE
Yes 9/8/2009 int Null
HIST_SUBSTANCE_OTC_ABUSE



DoDSER-A 5 tbDoDSER_History 52 HIST_PSYCHOTROPIC_MEDS
Yes 9/8/2009 int Null
HIST_PSYCHOTROPIC_MEDS



DoDSER-A 5 tbDoDSER_History 53 HIST_PSYCHOTROPIC_MEDS_TIME
Yes 9/8/2009 int Null
HIST_PSYCHOTROPIC_MEDS_TIME



DoDSER-A 5 tbDoDSER_History 54 HIST_ANTIDEPRESSANTS
Yes 9/8/2009 int Null
HIST_ANTIDEPRESSANTS



DoDSER-A 5 tbDoDSER_History 55 HIST_ANTIDEPRESSANTS_TIME
Yes 9/8/2009 int Null
HIST_ANTIDEPRESSANTS_TIME



DoDSER-A 5 tbDoDSER_History 56 HIST_ANTIANXIETY
Yes 9/8/2009 int Null
HIST_ANTIANXIETY



DoDSER-A 5 tbDoDSER_History 57 HIST_ANTIANXIETY_TIME
Yes 9/8/2009 int Null
HIST_ANTIANXIETY_TIME



DoDSER-A 5 tbDoDSER_History 58 HIST_ANTIMANICS
Yes 9/8/2009 int Null
HIST_ANTIMANICS



DoDSER-A 5 tbDoDSER_History 59 HIST_ANTIMANICS_TIME
Yes 9/8/2009 int Null
HIST_ANTIMANICS_TIME



DoDSER-A 5 tbDoDSER_History 60 HIST_ANTICONVULSANTS
Yes 9/8/2009 int Null
HIST_ANTICONVULSANTS



DoDSER-A 5 tbDoDSER_History 61 HIST_ANTICONVULSANTS_TIME
Yes 9/8/2009 int Null
HIST_ANTICONVULSANTS_TIME



DoDSER-A 5 tbDoDSER_History 62 HIST_ANTIPSYCHOTICS
Yes 9/8/2009 int Null
HIST_ANTIPSYCHOTICS



DoDSER-A 5 tbDoDSER_History 63 HIST_ANTIPSYCHOTICS_TIME
Yes 9/8/2009 int Null
HIST_ANTIPSYCHOTICS_TIME



DoDSER-A 5 tbDoDSER_History 64 HIST_PRIOR_SELF_INJURY
Yes 9/8/2009 int Null
HIST_PRIOR_SELF_INJURY



DoDSER-A 5 tbDoDSER_History 66 HIST_PRIOR_SELF_INJURY_TIME
Yes 9/8/2009 int Null
HIST_PRIOR_SELF_INJURY_TIME



DoDSER-A 5 tbDoDSER_History 67 HIST_PRIOR_SELF_INJURY_ONE
Yes 9/8/2009 int Null
HIST_PRIOR_SELF_INJURY_ONE



DoDSER-A 5 tbDoDSER_History 68 HIST_PRIOR_SELF_INJURY_SIM
Yes 9/8/2009 int Null
HIST_PRIOR_SELF_INJURY_SIM



DoDSER-A 5 tbDoDSER_History 69 HIST_PRIOR_SELF_INJURY_AGE
Yes 9/8/2009 int Null
HIST_PRIOR_SELF_INJURY_AGE



DoDSER-A 5 tbDoDSER_History 70 HIST_RECEIVE_TRAINING
Yes 9/8/2009 int Null
HIST_RECEIVE_TRAINING



DoDSER-A 5 tbDoDSER_History 71 HIST_RECEIVE_TRAINING_TIME
Yes 9/8/2009 int Null
HIST_RECEIVE_TRAINING_TIME



DoDSER-A 5 tbDoDSER_History 72 HIST_COURTS_MARTIAL
Yes 9/8/2009 int Null
HIST_COURTS_MARTIAL



DoDSER-A 5 tbDoDSER_History 73 HIST_COURTS_MARTIAL_TIME
Yes 9/8/2009 int Null
HIST_COURTS_MARTIAL_TIME



DoDSER-A 5 tbDoDSER_History 74 HIST_ARTICLE15
Yes 9/8/2009 int Null
HIST_ARTICLE15



DoDSER-A 5 tbDoDSER_History 75 HIST_ARTICLE15_TIME
Yes 9/8/2009 int Null
HIST_ARTICLE15_TIME



DoDSER-A 5 tbDoDSER_History 76 HIST_ADMIN_SEPARATION
Yes 9/8/2009 int Null
HIST_ADMIN_SEPARATION



DoDSER-A 5 tbDoDSER_History 77 HIST_ADMIN_SEPARATION_TIME
Yes 9/8/2009 int Null
HIST_ADMIN_SEPARATION_TIME



DoDSER-A 5 tbDoDSER_History 78 HIST_AWOL
Yes 9/8/2009 int Null
HIST_AWOL



DoDSER-A 5 tbDoDSER_History 79 HIST_AWOL_TIME
Yes 9/8/2009 int Null
HIST_AWOL_TIME



DoDSER-A 5 tbDoDSER_History 80 HIST_MEDICAL_BOARD
Yes 9/8/2009 int Null
HIST_MEDICAL_BOARD



DoDSER-A 5 tbDoDSER_History 81 HIST_MEDICAL_BOARD_TIME
Yes 9/8/2009 int Null
HIST_MEDICAL_BOARD_TIME



DoDSER-A 5 tbDoDSER_History 82 HIST_CIVIL_LEGAL
Yes 9/8/2009 int Null
HIST_CIVIL_LEGAL



DoDSER-A 5 tbDoDSER_History 83 HIST_CIVIL_LEGAL_TIME
Yes 9/8/2009 int Null
HIST_CIVIL_LEGAL_TIME



DoDSER-A 5 tbDoDSER_History 84 HIST_NON_SELECTION
Yes 9/8/2009 int Null
HIST_NON_SELECTION



DoDSER-A 5 tbDoDSER_History 85 HIST_NON_SELECTION_TIME
Yes 9/8/2009 int Null
HIST_NON_SELECTION_TIME



DoDSER-A 5 tbDoDSER_History 87 HIST_VICT_PHYS_ABUSE
Yes 9/8/2009 int Null
HIST_VICT_PHYS_ABUSE



DoDSER-A 5 tbDoDSER_History 88 HIST_VICT_PHYS_ABUSE_TIME
Yes 9/8/2009 int Null
HIST_VICT_PHYS_ABUSE_TIME



DoDSER-A 5 tbDoDSER_History 89 HIST_VICT_SEXUAL_ABUSE
Yes 9/8/2009 int Null
HIST_VICT_SEXUAL_ABUSE



DoDSER-A 5 tbDoDSER_History 90 HIST_VICT_SEXUAL_ABUSE_TIME
Yes 9/8/2009 int Null
HIST_VICT_SEXUAL_ABUSE_TIME



DoDSER-A 5 tbDoDSER_History 91 HIST_VICT_EMOT_ABUSE
Yes 9/8/2009 int Null
HIST_VICT_EMOT_ABUSE



DoDSER-A 5 tbDoDSER_History 92 HIST_VICT_EMOT_ABUSE_TIME
Yes 9/8/2009 int Null
HIST_VICT_EMOT_ABUSE_TIME



DoDSER-A 5 tbDoDSER_History 93 HIST_VICT_SEX_HARASS
Yes 9/8/2009 int Null
HIST_VICT_SEX_HARASS



DoDSER-A 5 tbDoDSER_History 94 HIST_VICT_SEX_HARASS_TIME
Yes 9/8/2009 int Null
HIST_VICT_SEX_HARASS_TIME



DoDSER-A 5 tbDoDSER_History 95 HIST_PERP_PHYS_ABUSE
Yes 9/8/2009 int Null
HIST_PERP_PHYS_ABUSE



DoDSER-A 5 tbDoDSER_History 96 HIST_PERP_PHYS_ABUSE_TIME
Yes 9/8/2009 int Null
HIST_PERP_PHYS_ABUSE_TIME



DoDSER-A 5 tbDoDSER_History 97 HIST_PERP_SEXUAL_ABUSE
Yes 9/8/2009 int Null
HIST_PERP_SEXUAL_ABUSE



DoDSER-A 5 tbDoDSER_History 98 HIST_PERP_SEXUAL_ABUSE_TIME
Yes 9/8/2009 int Null
HIST_PERP_SEXUAL_ABUSE_TIME



DoDSER-A 5 tbDoDSER_History 99 HIST_PERP_EMOT_ABUSE
Yes 9/8/2009 int Null
HIST_PERP_EMOT_ABUSE



DoDSER-A 5 tbDoDSER_History 100 HIST_PERP_EMOT_ABUSE_TIME
Yes 9/8/2009 int Null
HIST_PERP_EMOT_ABUSE_TIME



DoDSER-A 5 tbDoDSER_History 101 HIST_PERP_SEX_HARASS
Yes 9/8/2009 int Null
HIST_PERP_SEX_HARASS



DoDSER-A 5 tbDoDSER_History 102 HIST_PERP_SEX_HARASS_TIME
Yes 9/8/2009 int Null
HIST_PERP_SEX_HARASS_TIME



DoDSER-A 5 tbDoDSER_History 104 HIST_DEPLOY_COUNT
Yes 9/8/2009 int Null
HIST_DEPLOY_COUNT



DoDSER-A 5 tbDoDSER_History 105 HIST_DEPLOY1_LOC_23
Yes 9/8/2009 int Null
HIST_DEPLOY1_LOC_23



DoDSER-A 5 tbDoDSER_History 106 HIST_DEPLOY1_LOC_221
Yes 9/8/2009 int Null
HIST_DEPLOY1_LOC_221



DoDSER-A 5 tbDoDSER_History 107 HIST_DEPLOY1_LOC_LOOKUP
Yes 9/8/2009 nvarchar(255) Null
HIST_DEPLOY1_LOC_LOOKUP



DoDSER-A 5 tbDoDSER_History 109 HIST_DEPLOY1_START_DATE
Yes 9/8/2009 datetime Null
HIST_DEPLOY1_START_DATE



DoDSER-A 5 tbDoDSER_History 110 HIST_DEPLOY1_END_DATE
Yes 9/8/2009 datetime Null
HIST_DEPLOY1_END_DATE



DoDSER-A 5 tbDoDSER_History 111 HIST_DEPLOY1_RR_START_DATE
Yes 9/8/2009 datetime Null
HIST_DEPLOY1_RR_START_DATE



DoDSER-A 5 tbDoDSER_History 112 HIST_DEPLOY1_RR_END_DATE
Yes 9/8/2009 datetime Null
HIST_DEPLOY1_RR_END_DATE



DoDSER-A 5 tbDoDSER_History 113 HIST_DEPLOY2_LOC_23
Yes 9/8/2009 int Null
HIST_DEPLOY2_LOC_23



DoDSER-A 5 tbDoDSER_History 114 HIST_DEPLOY2_LOC_221
Yes 9/8/2009 int Null
HIST_DEPLOY2_LOC_221



DoDSER-A 5 tbDoDSER_History 115 HIST_DEPLOY2_LOC_LOOKUP
Yes 9/8/2009 nvarchar(255) Null
HIST_DEPLOY2_LOC_LOOKUP



DoDSER-A 5 tbDoDSER_History 117 HIST_DEPLOY2_START_DATE
Yes 9/8/2009 datetime Null
HIST_DEPLOY2_START_DATE



DoDSER-A 5 tbDoDSER_History 118 HIST_DEPLOY2_END_DATE
Yes 9/8/2009 datetime Null
HIST_DEPLOY2_END_DATE



DoDSER-A 5 tbDoDSER_History 119 HIST_DEPLOY3_LOC_23
Yes 9/8/2009 int Null
HIST_DEPLOY3_LOC_23



DoDSER-A 5 tbDoDSER_History 120 HIST_DEPLOY3_LOC_221
Yes 9/8/2009 int Null
HIST_DEPLOY3_LOC_221



DoDSER-A 5 tbDoDSER_History 121 HIST_DEPLOY3_LOC_LOOKUP
Yes 9/8/2009 nvarchar(255) Null
HIST_DEPLOY3_LOC_LOOKUP



DoDSER-A 5 tbDoDSER_History 123 HIST_DEPLOY3_START_DATE
Yes 9/8/2009 datetime Null
HIST_DEPLOY3_START_DATE



DoDSER-A 5 tbDoDSER_History 124 HIST_DEPLOY3_END_DATE
Yes 9/8/2009 datetime Null
HIST_DEPLOY3_END_DATE



DoDSER-A 5 tbDoDSER_History 125 HIST_DIRECT_COMBAT
Yes 9/8/2009 int Null
HIST_DIRECT_COMBAT



DoDSER-A 5 tbDoDSER_History 126 HIST_DIRECT_COMBAT_DEP1
Yes 9/8/2009 int Null
HIST_DIRECT_COMBAT_DEP1



DoDSER-A 5 tbDoDSER_History 127 HIST_DIRECT_COMBAT_DEP1_TIME
Yes 9/8/2009 int Null
HIST_DIRECT_COMBAT_DEP1_TIME



DoDSER-A 5 tbDoDSER_History 128 HIST_DIRECT_COMBAT_DEP2
Yes 9/8/2009 int Null
HIST_DIRECT_COMBAT_DEP2



DoDSER-A 5 tbDoDSER_History 129 HIST_DIRECT_COMBAT_DEP3
Yes 9/8/2009 int Null
HIST_DIRECT_COMBAT_DEP3



DoDSER-A 5 tbDoDSER_History 130 HIST_COMBAT_CASUALTIES_DEP1
Yes 9/8/2009 int Null
HIST_COMBAT_CASUALTIES_DEP1



DoDSER-A 5 tbDoDSER_History 131 HIST_COMBAT_CASUALTIES_DEP2
Yes 9/8/2009 int Null
HIST_COMBAT_CASUALTIES_DEP2



DoDSER-A 5 tbDoDSER_History 132 HIST_COMBAT_CASUALTIES_DEP3
Yes 9/8/2009 int Null
HIST_COMBAT_CASUALTIES_DEP3



DoDSER-A 5 tbDoDSER_History 133 HIST_COMBAT_INJURED_DEP1
Yes 9/8/2009 int Null
HIST_COMBAT_INJURED_DEP1



DoDSER-A 5 tbDoDSER_History 134 HIST_COMBAT_INJURED_DEP2
Yes 9/8/2009 int Null
HIST_COMBAT_INJURED_DEP2



DoDSER-A 5 tbDoDSER_History 135 HIST_COMBAT_INJURED_DEP3
Yes 9/8/2009 int Null
HIST_COMBAT_INJURED_DEP3



DoDSER-A 5 tbDoDSER_History 136 HIST_COMBAT_WITNESS_DEP1
Yes 9/8/2009 int Null
HIST_COMBAT_WITNESS_DEP1



DoDSER-A 5 tbDoDSER_History 137 HIST_COMBAT_WITNESS_DEP2
Yes 9/8/2009 int Null
HIST_COMBAT_WITNESS_DEP2



DoDSER-A 5 tbDoDSER_History 138 HIST_COMBAT_WITNESS_DEP3
Yes 9/8/2009 int Null
HIST_COMBAT_WITNESS_DEP3



DoDSER-A 5 tbDoDSER_History 139 HIST_COMBAT_SAW_BODIES_DEP1
Yes 9/8/2009 int Null
HIST_COMBAT_SAW_BODIES_DEP1



DoDSER-A 5 tbDoDSER_History 140 HIST_COMBAT_SAW_BODIES_DEP2
Yes 9/8/2009 int Null
HIST_COMBAT_SAW_BODIES_DEP2



DoDSER-A 5 tbDoDSER_History 141 HIST_COMBAT_SAW_BODIES_DEP3
Yes 9/8/2009 int Null
HIST_COMBAT_SAW_BODIES_DEP3



DoDSER-A 5 tbDoDSER_History 142 HIST_COMBAT_KILL_DEP1
Yes 9/8/2009 int Null
HIST_COMBAT_KILL_DEP1



DoDSER-A 5 tbDoDSER_History 143 HIST_COMBAT_KILL_DEP2
Yes 9/8/2009 int Null
HIST_COMBAT_KILL_DEP2



DoDSER-A 5 tbDoDSER_History 144 HIST_COMBAT_KILL_DEP3
Yes 9/8/2009 int Null
HIST_COMBAT_KILL_DEP3



DoDSER-A 5 tbDoDSER_History 146 HIST_DIRECT_COMBAT_TIME
Yes 9/8/2009 int Null
HIST_DIRECT_COMBAT_TIME



DoDSER-A 5 tbDoDSER_History 147 HIST_COMBAT_CASUALTIES
Yes 9/8/2009 int Null
HIST_COMBAT_CASUALTIES



DoDSER-A 5 tbDoDSER_History 148 HIST_COMBAT_CASUALTIES_TIME
Yes 9/8/2009 int Null
HIST_COMBAT_CASUALTIES_TIME



DoDSER-A 5 tbDoDSER_History 149 HIST_COMBAT_INJURED
Yes 9/8/2009 int Null
HIST_COMBAT_INJURED



DoDSER-A 5 tbDoDSER_History 150 HIST_COMBAT_INJURED_TIME
Yes 9/8/2009 int Null
HIST_COMBAT_INJURED_TIME



DoDSER-A 5 tbDoDSER_History 151 HIST_COMBAT_WITNESS
Yes 9/8/2009 int Null
HIST_COMBAT_WITNESS



DoDSER-A 5 tbDoDSER_History 152 HIST_COMBAT_WITNESS_TIME
Yes 9/8/2009 int Null
HIST_COMBAT_WITNESS_TIME



DoDSER-A 5 tbDoDSER_History 153 HIST_COMBAT_SAW_BODIES
Yes 9/8/2009 int Null
HIST_COMBAT_SAW_BODIES



DoDSER-A 5 tbDoDSER_History 154 HIST_COMBAT_SAW_BODIES_TIME
Yes 9/8/2009 int Null
HIST_COMBAT_SAW_BODIES_TIME



DoDSER-A 5 tbDoDSER_History 155 HIST_COMBAT_KILL
Yes 9/8/2009 int Null
HIST_COMBAT_KILL



DoDSER-A 5 tbDoDSER_History 156 HIST_COMBAT_KILL_TIME
Yes 9/8/2009 int Null
HIST_COMBAT_KILL_TIME



DoDSER-A 5 tbDoDSER_History 157 HIST_FAILED_REL_SPOUSE
Yes 9/8/2009 int Null
HIST_FAILED_REL_SPOUSE



DoDSER-A 5 tbDoDSER_History 158 HIST_FAILED_REL_SPOUSE_TIME
Yes 9/8/2009 int Null
HIST_FAILED_REL_SPOUSE_TIME



DoDSER-A 5 tbDoDSER_History 159 HIST_FAILED_REL_OTHER
Yes 9/8/2009 int Null
HIST_FAILED_REL_OTHER



DoDSER-A 5 tbDoDSER_History 160 HIST_FAILED_REL_OTHER_TIME
Yes 9/8/2009 int Null
HIST_FAILED_REL_OTHER_TIME



DoDSER-A 5 tbDoDSER_History 161 HIST_SPOUSE_SUICIDE
Yes 9/8/2009 int Null
HIST_SPOUSE_SUICIDE



DoDSER-A 5 tbDoDSER_History 162 HIST_SPOUSE_SUICIDE_TIME
Yes 9/8/2009 int Null
HIST_SPOUSE_SUICIDE_TIME



DoDSER-A 5 tbDoDSER_History 163 HIST_FAMILY_SUICIDE
Yes 9/8/2009 int Null
HIST_FAMILY_SUICIDE



DoDSER-A 5 tbDoDSER_History 164 HIST_FAMILY_SUICIDE_TIME
Yes 9/8/2009 int Null
HIST_FAMILY_SUICIDE_TIME



DoDSER-A 5 tbDoDSER_History 165 HIST_FRIEND_SUICIDE
Yes 9/8/2009 int Null
HIST_FRIEND_SUICIDE



DoDSER-A 5 tbDoDSER_History 166 HIST_FRIEND_SUICIDE_TIME
Yes 9/8/2009 int Null
HIST_FRIEND_SUICIDE_TIME



DoDSER-A 5 tbDoDSER_History 167 HIST_FAMILY_DEATH
Yes 9/8/2009 int Null
HIST_FAMILY_DEATH



DoDSER-A 5 tbDoDSER_History 168 HIST_FAMILY_DEATH_TIME
Yes 9/8/2009 int Null
HIST_FAMILY_DEATH_TIME



DoDSER-A 5 tbDoDSER_History 169 HIST_FRIEND_DEATH
Yes 9/8/2009 int Null
HIST_FRIEND_DEATH



DoDSER-A 5 tbDoDSER_History 170 HIST_FRIEND_DEATH_TIME
Yes 9/8/2009 int Null
HIST_FRIEND_DEATH_TIME



DoDSER-A 5 tbDoDSER_History 171 HIST_PHYSICAL_HEALTH
Yes 9/8/2009 int Null
HIST_PHYSICAL_HEALTH



DoDSER-A 5 tbDoDSER_History 172 HIST_PHYSICAL_HEALTH_TIME
Yes 9/8/2009 int Null
HIST_PHYSICAL_HEALTH_TIME



DoDSER-A 5 tbDoDSER_History 173 HIST_FAMILY_ILLNESS
Yes 9/8/2009 int Null
HIST_FAMILY_ILLNESS



DoDSER-A 5 tbDoDSER_History 174 HIST_FAMILY_ILLNESS_TIME
Yes 9/8/2009 int Null
HIST_FAMILY_ILLNESS_TIME



DoDSER-A 5 tbDoDSER_History 175 HIST_DEBT_BANKRUPTCY
Yes 9/8/2009 int Null
HIST_DEBT_BANKRUPTCY



DoDSER-A 5 tbDoDSER_History 176 HIST_DEBT_BANKRUPTCY_TIME
Yes 9/8/2009 int Null
HIST_DEBT_BANKRUPTCY_TIME



DoDSER-A 5 tbDoDSER_History 177 HIST_JOB_PROBLEMS
Yes 9/8/2009 int Null
HIST_JOB_PROBLEMS



DoDSER-A 5 tbDoDSER_History 178 HIST_JOB_PROBLEMS_TIME
Yes 9/8/2009 int Null
HIST_JOB_PROBLEMS_TIME



DoDSER-A 5 tbDoDSER_History 179 HIST_COWORKER_ISSUES
Yes 9/8/2009 int Null
HIST_COWORKER_ISSUES



DoDSER-A 5 tbDoDSER_History 180 HIST_COWORKER_ISSUES_TIME
Yes 9/8/2009 int Null
HIST_COWORKER_ISSUES_TIME



DoDSER-A 5 tbDoDSER_History 181 HIST_POOR_PERFORMANCE
Yes 9/8/2009 int Null
HIST_POOR_PERFORMANCE



DoDSER-A 5 tbDoDSER_History 182 HIST_POOR_PERFORMANCE_TIME
Yes 9/8/2009 int Null
HIST_POOR_PERFORMANCE_TIME



DoDSER-A 5 tbDoDSER_History 183 HIST_WORKPLACE_HAZING
Yes 9/8/2009 int Null
HIST_WORKPLACE_HAZING



DoDSER-A 5 tbDoDSER_History 184 HIST_WORKPLACE_HAZING_TIME
Yes 9/8/2009 int Null
HIST_WORKPLACE_HAZING_TIME



DoDSER-A 5 tbDoDSER_History 185 HIST_FAMILY_MENTAL
Yes 9/8/2009 int Null
HIST_FAMILY_MENTAL



DoDSER-A 5 tbDoDSER_History 186 HIST_GUN_IN_HOME
Yes 9/8/2009 int Null
HIST_GUN_IN_HOME



DoDSER-A 6 tbDoDSER_Patient_Master 1 ckid
Yes 9/8/2009 int Not Null PK ckid



DoDSER-A 6 tbDoDSER_Patient_Master 2 LoadDate
Yes 9/8/2009 datetime Null
LoadDate



DoDSER-A 6 tbDoDSER_Patient_Master 3 ckWSSoldierID DI Yes 9/8/2009 int Null
ckWSSoldierID



DoDSER-A 6 tbDoDSER_Patient_Master 4 Event_Date
Yes 9/8/2009 datetime Null
Event_Date



DoDSER-A 6 tbDoDSER_Patient_Master 5 Event_Type
Yes 9/8/2009 datetime Null
Event_Type



DoDSER-A 6 tbDoDSER_Patient_Master 6 PAT_SSN DI Yes 9/8/2009 nvarchar(11) Null
PAT_SSN



DoDSER-A 6 tbDoDSER_Patient_Master 7 ckEventID
Yes 9/8/2009 int Null
ckEventID



DoDSER-A 6 tbDoDSER_Patient_Master 8 ckHistoryID
Yes 9/8/2009 int Null
ckHistoryID



DoDSER-A 6 tbDoDSER_Patient_Master 9 ckCompleterID
Yes 9/8/2009 int Null
ckCompleterID



DoDSER-A 6 tbDoDSER_Patient_Master 10 ckPatientID
Yes 9/8/2009 int Null
ckPatientID



DoDSER-A 6 tbDoDSER_Patient_Master 11 ckSponserID
Yes 9/8/2009 int Null
ckSponserID



DoDSER-A 7 tbDoDSER_Event 1 ckid
Yes 9/8/2009 int Not Null PK ckid



DoDSER-A 7 tbDoDSER_Event 2 LoadDate
Yes 9/8/2009 datetime Null
LoadDate



DoDSER-A 7 tbDoDSER_Event 3 ckWSSoldierID DI Yes 9/8/2009 int Null
ckWSSoldierID



DoDSER-A 7 tbDoDSER_Event 4 EVENT_DATE
Yes 9/8/2009 datetime Null
EVENT_DATE



DoDSER-A 7 tbDoDSER_Event 5 EVENT_TIME
Yes 9/8/2009 int Null
EVENT_TIME



DoDSER-A 7 tbDoDSER_Event 6 EVENT_LOCATION_COUNTRY
Yes 9/8/2009 int Null
EVENT_LOCATION_COUNTRY



DoDSER-A 7 tbDoDSER_Event 9 EVENT_LOCATION_STATE
Yes 9/8/2009 int Null
EVENT_LOCATION_STATE



DoDSER-A 7 tbDoDSER_Event 10 EVENT_LOCATION_STATE_NAME
Yes 9/8/2009 nvarchar(255) Null
EVENT_LOCATION_STATE_NAME



DoDSER-A 7 tbDoDSER_Event 11 EVENT_LOCATION_CITY
Yes 9/8/2009 nvarchar(255) Null
EVENT_LOCATION_CITY



DoDSER-A 7 tbDoDSER_Event 12 EVENT_TYPE
Yes 9/8/2009 int Null
EVENT_TYPE



DoDSER-A 7 tbDoDSER_Event 13 EVENT_TEST
Yes 9/8/2009 nvarchar(255) Null
EVENT_TEST



DoDSER-A 7 tbDoDSER_Event 14 EVENT_SETTING
Yes 9/8/2009 int Null
EVENT_SETTING



DoDSER-A 7 tbDoDSER_Event 16 EVENT_ACTION_HOSPITALIZED
Yes 9/8/2009 int Null
EVENT_ACTION_HOSPITALIZED



DoDSER-A 7 tbDoDSER_Event 17 EVENT_ACTION_OUTPATIENT
Yes 9/8/2009 int Null
EVENT_ACTION_OUTPATIENT



DoDSER-A 7 tbDoDSER_Event 18 EVENT_ACTION_EVACUATED
Yes 9/8/2009 int Null
EVENT_ACTION_EVACUATED



DoDSER-A 7 tbDoDSER_Event 19 EVENT_ACTION_OTHER
Yes 9/8/2009 int Null
EVENT_ACTION_OTHER



DoDSER-A 7 tbDoDSER_Event 21 EVENT_TYPE_COMPLETED
Yes 9/8/2009 int Null
EVENT_TYPE_COMPLETED



DoDSER-A 7 tbDoDSER_Event 22 EVENT_TYPE_HOSPITALIZED
Yes 9/8/2009 int Null
EVENT_TYPE_HOSPITALIZED



DoDSER-A 7 tbDoDSER_Event 23 EVENT_TYPE_EVACUATED
Yes 9/8/2009 int Null
EVENT_TYPE_EVACUATED



DoDSER-A 7 tbDoDSER_Event 24 EVENT_TYPE_OTHER
Yes 9/8/2009 int Null
EVENT_TYPE_OTHER



DoDSER-A 7 tbDoDSER_Event 26 EVENT_TYPE_STUDY
Yes 9/8/2009 int Null
EVENT_TYPE_STUDY



DoDSER-A 7 tbDoDSER_Event 27 EVENT_TYPE_STUDYCODE
Yes 9/8/2009 int Null
EVENT_TYPE_STUDYCODE



DoDSER-A 7 tbDoDSER_Event 28 EVENT_HOSP_MTF
Yes 9/8/2009 int Null
EVENT_HOSP_MTF



DoDSER-A 7 tbDoDSER_Event 29 EVENT_HOSP_CIV
Yes 9/8/2009 int Null
EVENT_HOSP_CIV



DoDSER-A 7 tbDoDSER_Event 30 EVENT_HOSP_VA
Yes 9/8/2009 int Null
EVENT_HOSP_VA



DoDSER-A 7 tbDoDSER_Event 31 EVENT_HOSP_X
Yes 9/8/2009 int Null
EVENT_HOSP_X



DoDSER-A 7 tbDoDSER_Event 32 EVENT_HOSP_NAMES
Yes 9/8/2009 nvarchar(255) Null
EVENT_HOSP_NAMES



DoDSER-A 7 tbDoDSER_Event 33 EVENT_HOSP_START_DATE
Yes 9/8/2009 datetime Null
EVENT_HOSP_START_DATE



DoDSER-A 7 tbDoDSER_Event 34 EVENT_HOSP_START_UNKNOWN
Yes 9/8/2009 int Null
EVENT_HOSP_START_UNKNOWN



DoDSER-A 7 tbDoDSER_Event 35 EVENT_HOSP_END_DATE
Yes 9/8/2009 datetime Null
EVENT_HOSP_END_DATE



DoDSER-A 7 tbDoDSER_Event 36 EVENT_HOSP_END_UNKNOWN
Yes 9/8/2009 int Null
EVENT_HOSP_END_UNKNOWN



DoDSER-A 7 tbDoDSER_Event 37 EVENT_HOSP_END_STILL
Yes 9/8/2009 int Null
EVENT_HOSP_END_STILL



DoDSER-A 7 tbDoDSER_Event 38 EVENT_METHOD_23
Yes 9/8/2009 int Null
EVENT_METHOD_23



DoDSER-A 7 tbDoDSER_Event 39 EVENT_METHOD_221
Yes 9/8/2009 int Null
EVENT_METHOD_221



DoDSER-A 7 tbDoDSER_Event 40 EVENT_METHOD_LOOKUP
Yes 9/8/2009 nvarchar(255) Null
EVENT_METHOD_LOOKUP



DoDSER-A 7 tbDoDSER_Event 42 EVENT_ALCOHOL
Yes 9/8/2009 int Null
EVENT_ALCOHOL



DoDSER-A 7 tbDoDSER_Event 43 EVENT_DRUGS
Yes 9/8/2009 int Null
EVENT_DRUGS



DoDSER-A 7 tbDoDSER_Event 44 EVENT_DRUGS_ILLEGAL
Yes 9/8/2009 int Null
EVENT_DRUGS_ILLEGAL



DoDSER-A 7 tbDoDSER_Event 45 EVENT_DRUGS_PRESCRIPTION
Yes 9/8/2009 int Null
EVENT_DRUGS_PRESCRIPTION



DoDSER-A 7 tbDoDSER_Event 46 EVENT_DRUGS_OTC
Yes 9/8/2009 int Null
EVENT_DRUGS_OTC



DoDSER-A 7 tbDoDSER_Event 47 EVENT_INTENT_DIE
Yes 9/8/2009 int Null
EVENT_INTENT_DIE



DoDSER-A 7 tbDoDSER_Event 48 EVENT_EXPERIENCE_PHYSICAL_HARM
Yes 9/8/2009 int Null
EVENT_EXPERIENCE_PHYSICAL_HARM



DoDSER-A 7 tbDoDSER_Event 49 EVENT_SELF_INFLICTED_INJURIES
Yes 9/8/2009 int Null
EVENT_SELF_INFLICTED_INJURIES



DoDSER-A 7 tbDoDSER_Event 50 EVENT_METHOD_LETHAL
Yes 9/8/2009 int Null
EVENT_METHOD_LETHAL



DoDSER-A 7 tbDoDSER_Event 51 EVENT_DEATH_RISK_GAMBLING
Yes 9/8/2009 int Null
EVENT_DEATH_RISK_GAMBLING



DoDSER-A 7 tbDoDSER_Event 52 EVENT_PLANNED
Yes 9/8/2009 int Null
EVENT_PLANNED



DoDSER-A 7 tbDoDSER_Event 53 EVENT_OBSERVABLE
Yes 9/8/2009 int Null
EVENT_OBSERVABLE



DoDSER-A 7 tbDoDSER_Event 54 EVENT_SUICIDE_NOTE
Yes 9/8/2009 int Null
EVENT_SUICIDE_NOTE



DoDSER-A 7 tbDoDSER_Event 55 EVENT_COMMUNICATE
Yes 9/8/2009 int Null
EVENT_COMMUNICATE



DoDSER-A 7 tbDoDSER_Event 56 EVENT_COMMUNICATE_HOW_WRITTEN
Yes 9/8/2009 int Null
EVENT_COMMUNICATE_HOW_WRITTEN



DoDSER-A 7 tbDoDSER_Event 57 EVENT_COMMUNICATE_HOW_VERBAL
Yes 9/8/2009 int Null
EVENT_COMMUNICATE_HOW_VERBAL



DoDSER-A 7 tbDoDSER_Event 58 EVENT_COMMUNICATE_HOW_OTHER
Yes 9/8/2009 int Null
EVENT_COMMUNICATE_HOW_OTHER



DoDSER-A 7 tbDoDSER_Event 60 EVENT_COMMUNICATE_WHO_SUPER
Yes 9/8/2009 int Null
EVENT_COMMUNICATE_WHO_SUPER



DoDSER-A 7 tbDoDSER_Event 61 EVENT_COMMUNICATE_WHO_CHAP
Yes 9/8/2009 int Null
EVENT_COMMUNICATE_WHO_CHAP



DoDSER-A 7 tbDoDSER_Event 62 EVENT_COMMUNICATE_WHO_MHSTAFF
Yes 9/8/2009 int Null
EVENT_COMMUNICATE_WHO_MHSTAFF



DoDSER-A 7 tbDoDSER_Event 63 EVENT_COMMUNICATE_WHO_FRIEND
Yes 9/8/2009 int Null
EVENT_COMMUNICATE_WHO_FRIEND



DoDSER-A 7 tbDoDSER_Event 64 EVENT_COMMUNICATE_WHO_SPOUSE
Yes 9/8/2009 int Null
EVENT_COMMUNICATE_WHO_SPOUSE



DoDSER-A 7 tbDoDSER_Event 65 EVENT_COMMUNICATE_WHO_OTHER
Yes 9/8/2009 int Null
EVENT_COMMUNICATE_WHO_OTHER



DoDSER-A 7 tbDoDSER_Event 67 EVENT_MOTIVATION
Yes 9/8/2009 int Null
EVENT_MOTIVATION



DoDSER-A 7 tbDoDSER_Event 69 EVENT_DUTY_ENV_GARRISON
Yes 9/8/2009 int Null
EVENT_DUTY_ENV_GARRISON



DoDSER-A 7 tbDoDSER_Event 70 EVENT_DUTY_ENV_PERMCOMM
Yes 9/8/2009 int Null
EVENT_DUTY_ENV_PERMCOMM



DoDSER-A 7 tbDoDSER_Event 71 EVENT_DUTY_ENV_PSYCH
Yes 9/8/2009 int Null
EVENT_DUTY_ENV_PSYCH



DoDSER-A 7 tbDoDSER_Event 72 EVENT_DUTY_ENV_LEAVE
Yes 9/8/2009 int Null
EVENT_DUTY_ENV_LEAVE



DoDSER-A 7 tbDoDSER_Event 73 EVENT_DUTY_ENV_MEDICAL_HOLD
Yes 9/8/2009 int Null
EVENT_DUTY_ENV_MEDICAL_HOLD



DoDSER-A 7 tbDoDSER_Event 74 EVENT_DUTY_ENV_TDY
Yes 9/8/2009 int Null
EVENT_DUTY_ENV_TDY



DoDSER-A 7 tbDoDSER_Event 75 EVENT_DUTY_ENV_EVACUATION
Yes 9/8/2009 int Null
EVENT_DUTY_ENV_EVACUATION



DoDSER-A 7 tbDoDSER_Event 76 EVENT_DUTY_ENV_AWOL
Yes 9/8/2009 int Null
EVENT_DUTY_ENV_AWOL



DoDSER-A 7 tbDoDSER_Event 77 EVENT_DUTY_ENV_COMMAND_OBS
Yes 9/8/2009 int Null
EVENT_DUTY_ENV_COMMAND_OBS



DoDSER-A 7 tbDoDSER_Event 78 EVENT_DUTY_ENV_CORR_FACILITY
Yes 9/8/2009 int Null
EVENT_DUTY_ENV_CORR_FACILITY



DoDSER-A 7 tbDoDSER_Event 79 EVENT_DUTY_ENV_DEPLOYED
Yes 9/8/2009 int Null
EVENT_DUTY_ENV_DEPLOYED



DoDSER-A 7 tbDoDSER_Event 80 EVENT_DUTY_ENV_OTHER
Yes 9/8/2009 int Null
EVENT_DUTY_ENV_OTHER



DoDSER-A 7 tbDoDSER_Event 82 EVENT_DUTY_ENV_TRAINING
Yes 9/8/2009 int Null
EVENT_DUTY_ENV_TRAINING



DoDSER-A 7 tbDoDSER_Event 83 EVENT_ORDERS_DEPLOY
Yes 9/8/2009 int Null
EVENT_ORDERS_DEPLOY



DoDSER-A 7 tbDoDSER_Event 84 EVENT_RELATED_DEPLOYMENT
Yes 9/8/2009 int Null
EVENT_RELATED_DEPLOYMENT



DoDSER-A 7 tbDoDSER_Event 85 EVENT_RELATED_DEPLOYMENT_ANT
Yes 9/8/2009 int Null
EVENT_RELATED_DEPLOYMENT_ANT



DoDSER-A 7 tbDoDSER_Event 86 EVENT_RELATED_DEPLOYMENT_CUR
Yes 9/8/2009 int Null
EVENT_RELATED_DEPLOYMENT_CUR



DoDSER-A 7 tbDoDSER_Event 87 EVENT_RELATED_DEPLOYMENT_PRI
Yes 9/8/2009 int Null
EVENT_RELATED_DEPLOYMENT_PRI



Sheet 4: 4.DoDSER-072009 NIMH Atr
Source Source Tab Ord SourceTable Source Field Ord FieldName PII/HIPAA Sensitive NIMH Approval NIMH SP2Delta FieldType Nullability Primary Key Title Desc FDM Comments ADS Comment Code Table Reference
DoDSER-A 8 tbDoDSER 1 ckID
Yes 9/24/2009 int Not Null PK ckID



DoDSER-A 8 tbDoDSER 2 LoadDate
Yes 9/24/2009 datetime Null
LoadDate



DoDSER-A 8 tbDoDSER 3 ckWSSoldierID DI Yes 9/24/2009 int Null
ckWSSoldierID



DoDSER-A 8 tbDoDSER 4 reportStatus
Yes 9/24/2009 varchar(255) Null
reportStatus



DoDSER-A 8 tbDoDSER 5 eventType
Yes 9/24/2009 varchar(255) Null
eventType



DoDSER-A 8 tbDoDSER 6 eventDateTime
Yes 9/24/2009 datetime Null
eventDateTime



DoDSER-A 8 tbDoDSER 10 patSsn DI Yes 9/24/2009 varchar(11) Null
patSsn



DoDSER-A 8 tbDoDSER 11 patDob
Yes 9/24/2009 datetime Null
patDob



DoDSER-A 8 tbDoDSER 12 patSex
Yes 9/24/2009 varchar(255) Null
patSex



DoDSER-A 8 tbDoDSER 13 patSponsorRelation
Yes 9/24/2009 varchar(255) Null
patSponsorRelation



DoDSER-A 8 tbDoDSER 15 patService
Yes 9/24/2009 varchar(255) Null
patService



DoDSER-A 8 tbDoDSER 17 patRace
Yes 9/24/2009 varchar(255) Null
patRace



DoDSER-A 8 tbDoDSER 19 patEthnic
Yes 9/24/2009 varchar(255) Null
patEthnic



DoDSER-A 8 tbDoDSER 20 patMarital
Yes 9/24/2009 varchar(255) Null
patMarital



DoDSER-A 8 tbDoDSER 21 patMaritalReside
Yes 9/24/2009 varchar(255) Null
patMaritalReside



DoDSER-A 8 tbDoDSER 22 patEducation
Yes 9/24/2009 varchar(255) Null
patEducation



DoDSER-A 8 tbDoDSER 25 patResideAlone
Yes 9/24/2009 varchar(255) Null
patResideAlone



DoDSER-A 8 tbDoDSER 26 patChildren
Yes 9/24/2009 varchar(255) Null
patChildren



DoDSER-A 8 tbDoDSER 27 patChildrenResideWith
Yes 9/24/2009 varchar(255) Null
patChildrenResideWith



DoDSER-A 8 tbDoDSER 28 sponsorComponent
Yes 9/24/2009 varchar(255) Null
sponsorComponent



DoDSER-A 8 tbDoDSER 30 sponsorJobCode
Yes 9/24/2009 varchar(255) Null
sponsorJobCode



DoDSER-A 8 tbDoDSER 32 sponsorJobCodeNonArmy
Yes 9/24/2009 varchar(255) Null
sponsorJobCodeNonArmy



DoDSER-A 8 tbDoDSER 33 sponsorDutyStatusActive
Yes 9/24/2009 varchar(255) Null
sponsorDutyStatusActive



DoDSER-A 8 tbDoDSER 34 sponsorDutyStatusAgr
Yes 9/24/2009 varchar(255) Null
sponsorDutyStatusAgr



DoDSER-A 8 tbDoDSER 35 sponsorDutyStatusIet
Yes 9/24/2009 varchar(255) Null
sponsorDutyStatusIet



DoDSER-A 8 tbDoDSER 36 sponsorDutyStatusAit
Yes 9/24/2009 varchar(255) Null
sponsorDutyStatusAit



DoDSER-A 8 tbDoDSER 37 sponsorDutyStatusMobilized
Yes 9/24/2009 varchar(255) Null
sponsorDutyStatusMobilized



DoDSER-A 8 tbDoDSER 38 sponsorDutyStatusAdt
Yes 9/24/2009 varchar(255) Null
sponsorDutyStatusAdt



DoDSER-A 8 tbDoDSER 39 sponsorDutyStatusIdt
Yes 9/24/2009 varchar(255) Null
sponsorDutyStatusIdt



DoDSER-A 8 tbDoDSER 40 sponsorDutyStatusRetired
Yes 9/24/2009 varchar(255) Null
sponsorDutyStatusRetired



DoDSER-A 8 tbDoDSER 41 sponsorDutyStatusReleased
Yes 9/24/2009 varchar(255) Null
sponsorDutyStatusReleased



DoDSER-A 8 tbDoDSER 42 sponsorDutyStatusNotActive
Yes 9/24/2009 varchar(255) Null
sponsorDutyStatusNotActive



DoDSER-A 8 tbDoDSER 43 sponsorDutyStatusOther
Yes 9/24/2009 varchar(255) Null
sponsorDutyStatusOther



DoDSER-A 8 tbDoDSER 45 sponsorDutyStatusNa
Yes 9/24/2009 varchar(255) Null
sponsorDutyStatusNa



DoDSER-A 8 tbDoDSER 46 sponsorGrade DI Yes 9/24/2009 varchar(255) Null
sponsorGrade



DoDSER-A 8 tbDoDSER 47 sponsorDutyStationSame
Yes 9/24/2009 varchar(255) Null
sponsorDutyStationSame



DoDSER-A 8 tbDoDSER 48 sponsorDutyStationCountry
Yes 9/24/2009 varchar(255) Null
sponsorDutyStationCountry



DoDSER-A 8 tbDoDSER 50 sponsorDutyStationState
Yes 9/24/2009 varchar(255) Null
sponsorDutyStationState



DoDSER-A 8 tbDoDSER 51 sponsorDutyStationCity
Yes 9/24/2009 varchar(255) Null
sponsorDutyStationCity



DoDSER-A 8 tbDoDSER 63 sponsorUic DI Yes 9/24/2009 varchar(255) Null
sponsorUic



DoDSER-A 8 tbDoDSER 64 sponsorWtu DI Yes 9/24/2009 varchar(255) Null
sponsorWtu



DoDSER-A 8 tbDoDSER 65 sponsorTimeUnitYears
Yes 9/24/2009 float Null
sponsorTimeUnitYears



DoDSER-A 8 tbDoDSER 66 sponsorTimeUnitMonths
Yes 9/24/2009 float Null
sponsorTimeUnitMonths



DoDSER-A 8 tbDoDSER 67 eventLocationCountry
Yes 9/24/2009 varchar(255) Null
eventLocationCountry



DoDSER-A 8 tbDoDSER 69 eventLocationState
Yes 9/24/2009 varchar(255) Null
eventLocationState



DoDSER-A 8 tbDoDSER 70 eventLocationCity
Yes 9/24/2009 varchar(255) Null
eventLocationCity



DoDSER-A 8 tbDoDSER 71 eventSetting
Yes 9/24/2009 varchar(255) Null
eventSetting



DoDSER-A 8 tbDoDSER 73 eventActionHospitalized
Yes 9/24/2009 varchar(255) Null
eventActionHospitalized



DoDSER-A 8 tbDoDSER 74 eventHospStartDate
Yes 9/24/2009 varchar(255) Null
eventHospStartDate



DoDSER-A 8 tbDoDSER 75 eventHospStartUnknown
Yes 9/24/2009 varchar(255) Null
eventHospStartUnknown



DoDSER-A 8 tbDoDSER 76 eventHospEndDate
Yes 9/24/2009 varchar(255) Null
eventHospEndDate



DoDSER-A 8 tbDoDSER 77 eventHospEndUnknown
Yes 9/24/2009 varchar(255) Null
eventHospEndUnknown



DoDSER-A 8 tbDoDSER 78 eventHospEndStill
Yes 9/24/2009 varchar(255) Null
eventHospEndStill



DoDSER-A 8 tbDoDSER 79 eventActionOutpatient
Yes 9/24/2009 varchar(255) Null
eventActionOutpatient



DoDSER-A 8 tbDoDSER 80 eventActionEvacuated
Yes 9/24/2009 varchar(255) Null
eventActionEvacuated



DoDSER-A 8 tbDoDSER 81 eventActionOther
Yes 9/24/2009 varchar(255) Null
eventActionOther



DoDSER-A 8 tbDoDSER 83 eventMethod
Yes 9/24/2009 varchar(255) Null
eventMethod



DoDSER-A 8 tbDoDSER 85 eventAlcohol
Yes 9/24/2009 varchar(255) Null
eventAlcohol



DoDSER-A 8 tbDoDSER 86 eventDrugs
Yes 9/24/2009 varchar(255) Null
eventDrugs



DoDSER-A 8 tbDoDSER 87 eventDrugsIllegal
Yes 9/24/2009 varchar(255) Null
eventDrugsIllegal



DoDSER-A 8 tbDoDSER 88 eventDrugsPrescription
Yes 9/24/2009 varchar(255) Null
eventDrugsPrescription



DoDSER-A 8 tbDoDSER 89 eventDrugsOtc
Yes 9/24/2009 varchar(255) Null
eventDrugsOtc



DoDSER-A 8 tbDoDSER 90 eventIntentDie
Yes 9/24/2009 varchar(255) Null
eventIntentDie



DoDSER-A 8 tbDoDSER 91 eventSelfInflictedInjuries
Yes 9/24/2009 varchar(255) Null
eventSelfInflictedInjuries



DoDSER-A 8 tbDoDSER 92 eventDeathRiskGambling
Yes 9/24/2009 varchar(255) Null
eventDeathRiskGambling



DoDSER-A 8 tbDoDSER 93 eventPlanned
Yes 9/24/2009 varchar(255) Null
eventPlanned



DoDSER-A 8 tbDoDSER 94 eventObservable
Yes 9/24/2009 varchar(255) Null
eventObservable



DoDSER-A 8 tbDoDSER 95 eventSuicideNote
Yes 9/24/2009 varchar(255) Null
eventSuicideNote



DoDSER-A 8 tbDoDSER 96 eventCommunicate
Yes 9/24/2009 varchar(255) Null
eventCommunicate



DoDSER-A 8 tbDoDSER 97 eventCommunicateHowWritten
Yes 9/24/2009 varchar(255) Null
eventCommunicateHowWritten



DoDSER-A 8 tbDoDSER 98 eventCommunicateHowVerbal
Yes 9/24/2009 varchar(255) Null
eventCommunicateHowVerbal



DoDSER-A 8 tbDoDSER 99 eventCommunicateHowOther
Yes 9/24/2009 varchar(255) Null
eventCommunicateHowOther



DoDSER-A 8 tbDoDSER 101 eventCommunicateWhoSuper
Yes 9/24/2009 varchar(255) Null
eventCommunicateWhoSuper



DoDSER-A 8 tbDoDSER 102 eventCommunicateWhoChap
Yes 9/24/2009 varchar(255) Null
eventCommunicateWhoChap



DoDSER-A 8 tbDoDSER 103 eventCommunicateWhoMhstaff
Yes 9/24/2009 varchar(255) Null
eventCommunicateWhoMhstaff



DoDSER-A 8 tbDoDSER 104 eventCommunicateWhoFriend
Yes 9/24/2009 varchar(255) Null
eventCommunicateWhoFriend



DoDSER-A 8 tbDoDSER 105 eventCommunicateWhoSpouse
Yes 9/24/2009 varchar(255) Null
eventCommunicateWhoSpouse



DoDSER-A 8 tbDoDSER 106 eventCommunicateWhoOther
Yes 9/24/2009 varchar(255) Null
eventCommunicateWhoOther



DoDSER-A 8 tbDoDSER 108 eventMotivation
Yes 9/24/2009 varchar(255) Null
eventMotivation



DoDSER-A 8 tbDoDSER 110 eventDutyEnvPermcomm
Yes 9/24/2009 varchar(255) Null
eventDutyEnvPermcomm



DoDSER-A 8 tbDoDSER 111 eventDutyEnvGarrison
Yes 9/24/2009 varchar(255) Null
eventDutyEnvGarrison



DoDSER-A 8 tbDoDSER 112 eventDutyEnvLeave
Yes 9/24/2009 varchar(255) Null
eventDutyEnvLeave



DoDSER-A 8 tbDoDSER 113 eventDutyEnvTdy
Yes 9/24/2009 varchar(255) Null
eventDutyEnvTdy



DoDSER-A 8 tbDoDSER 114 eventDutyEnvAwol
Yes 9/24/2009 varchar(255) Null
eventDutyEnvAwol



DoDSER-A 8 tbDoDSER 115 eventDutyEnvDeployed
Yes 9/24/2009 varchar(255) Null
eventDutyEnvDeployed



DoDSER-A 8 tbDoDSER 116 eventDutyEnvTraining
Yes 9/24/2009 varchar(255) Null
eventDutyEnvTraining



DoDSER-A 8 tbDoDSER 117 eventDutyEnvPsych
Yes 9/24/2009 varchar(255) Null
eventDutyEnvPsych



DoDSER-A 8 tbDoDSER 118 eventDutyEnvMedicalHold
Yes 9/24/2009 varchar(255) Null
eventDutyEnvMedicalHold



DoDSER-A 8 tbDoDSER 119 eventDutyEnvEvacuation
Yes 9/24/2009 varchar(255) Null
eventDutyEnvEvacuation



DoDSER-A 8 tbDoDSER 120 eventDutyEnvCommandObs
Yes 9/24/2009 varchar(255) Null
eventDutyEnvCommandObs



DoDSER-A 8 tbDoDSER 121 eventDutyEnvCorrFacility
Yes 9/24/2009 varchar(255) Null
eventDutyEnvCorrFacility



DoDSER-A 8 tbDoDSER 122 eventDutyEnvOther
Yes 9/24/2009 varchar(255) Null
eventDutyEnvOther



DoDSER-A 8 tbDoDSER 125 histMtf
Yes 9/24/2009 varchar(255) Null
histMtf



DoDSER-A 8 tbDoDSER 126 histMtfTime
Yes 9/24/2009 varchar(255) Null
histMtfTime



DoDSER-A 8 tbDoDSER 127 histSas
Yes 9/24/2009 varchar(255) Null
histSas



DoDSER-A 8 tbDoDSER 128 histSasTime
Yes 9/24/2009 varchar(255) Null
histSasTime



DoDSER-A 8 tbDoDSER 129 histFap
Yes 9/24/2009 varchar(255) Null
histFap



DoDSER-A 8 tbDoDSER 130 histFapTime
Yes 9/24/2009 varchar(255) Null
histFapTime



DoDSER-A 8 tbDoDSER 131 histChaplain
Yes 9/24/2009 varchar(255) Null
histChaplain



DoDSER-A 8 tbDoDSER 132 histChaplainTime
Yes 9/24/2009 varchar(255) Null
histChaplainTime



DoDSER-A 8 tbDoDSER 133 histOutpatientMh
Yes 9/24/2009 varchar(255) Null
histOutpatientMh



DoDSER-A 8 tbDoDSER 134 histOutpatientMhTime
Yes 9/24/2009 varchar(255) Null
histOutpatientMhTime



DoDSER-A 8 tbDoDSER 135 histInpatientMh
Yes 9/24/2009 varchar(255) Null
histInpatientMh



DoDSER-A 8 tbDoDSER 136 histInpatientMhTime
Yes 9/24/2009 varchar(255) Null
histInpatientMhTime



DoDSER-A 8 tbDoDSER 137 histMood
Yes 9/24/2009 varchar(255) Null
histMood



DoDSER-A 8 tbDoDSER 138 histBipolar
Yes 9/24/2009 varchar(255) Null
histBipolar



DoDSER-A 8 tbDoDSER 139 histBipolarTime
Yes 9/24/2009 varchar(255) Null
histBipolarTime



DoDSER-A 8 tbDoDSER 140 histMajorDepression
Yes 9/24/2009 varchar(255) Null
histMajorDepression



DoDSER-A 8 tbDoDSER 141 histMajorDepressionTime
Yes 9/24/2009 varchar(255) Null
histMajorDepressionTime



DoDSER-A 8 tbDoDSER 142 histDysthymic
Yes 9/24/2009 varchar(255) Null
histDysthymic



DoDSER-A 8 tbDoDSER 143 histDysthymicTime
Yes 9/24/2009 varchar(255) Null
histDysthymicTime



DoDSER-A 8 tbDoDSER 144 histOtherMood
Yes 9/24/2009 varchar(255) Null
histOtherMood



DoDSER-A 8 tbDoDSER 145 histOtherMoodTime
Yes 9/24/2009 varchar(255) Null
histOtherMoodTime



DoDSER-A 8 tbDoDSER 146 histAnxiety
Yes 9/24/2009 varchar(255) Null
histAnxiety



DoDSER-A 8 tbDoDSER 147 histPtsd
Yes 9/24/2009 varchar(255) Null
histPtsd



DoDSER-A 8 tbDoDSER 148 histPtsdTime
Yes 9/24/2009 varchar(255) Null
histPtsdTime



DoDSER-A 8 tbDoDSER 149 histPanic
Yes 9/24/2009 varchar(255) Null
histPanic



DoDSER-A 8 tbDoDSER 150 histPanicTime
Yes 9/24/2009 varchar(255) Null
histPanicTime



DoDSER-A 8 tbDoDSER 151 histGenAnxiety
Yes 9/24/2009 varchar(255) Null
histGenAnxiety



DoDSER-A 8 tbDoDSER 152 histGenAnxietyTime
Yes 9/24/2009 varchar(255) Null
histGenAnxietyTime



DoDSER-A 8 tbDoDSER 153 histStress
Yes 9/24/2009 varchar(255) Null
histStress



DoDSER-A 8 tbDoDSER 154 histStressTime
Yes 9/24/2009 varchar(255) Null
histStressTime



DoDSER-A 8 tbDoDSER 155 histOtherAnxiety
Yes 9/24/2009 varchar(255) Null
histOtherAnxiety



DoDSER-A 8 tbDoDSER 156 histOtherAnxietyTime
Yes 9/24/2009 varchar(255) Null
histOtherAnxietyTime



DoDSER-A 8 tbDoDSER 157 histPersonality
Yes 9/24/2009 varchar(255) Null
histPersonality



DoDSER-A 8 tbDoDSER 158 histPersonalityTime
Yes 9/24/2009 varchar(255) Null
histPersonalityTime



DoDSER-A 8 tbDoDSER 159 histPsychotic
Yes 9/24/2009 varchar(255) Null
histPsychotic



DoDSER-A 8 tbDoDSER 160 histPsychoticTime
Yes 9/24/2009 varchar(255) Null
histPsychoticTime



DoDSER-A 8 tbDoDSER 161 histTbi
Yes 9/24/2009 varchar(255) Null
histTbi



DoDSER-A 8 tbDoDSER 162 histTbiTime
Yes 9/24/2009 varchar(255) Null
histTbiTime



DoDSER-A 8 tbDoDSER 163 histSubstanceAbuse
Yes 9/24/2009 varchar(255) Null
histSubstanceAbuse



DoDSER-A 8 tbDoDSER 164 histSubstanceAbuseTime
Yes 9/24/2009 varchar(255) Null
histSubstanceAbuseTime



DoDSER-A 8 tbDoDSER 165 histSubstanceAlcoholDep
Yes 9/24/2009 varchar(255) Null
histSubstanceAlcoholDep



DoDSER-A 8 tbDoDSER 166 histSubstanceAlcoholAbuse
Yes 9/24/2009 varchar(255) Null
histSubstanceAlcoholAbuse



DoDSER-A 8 tbDoDSER 167 histSubstanceDrugsDep
Yes 9/24/2009 varchar(255) Null
histSubstanceDrugsDep



DoDSER-A 8 tbDoDSER 168 histSubstanceDrugsAbuse
Yes 9/24/2009 varchar(255) Null
histSubstanceDrugsAbuse



DoDSER-A 8 tbDoDSER 169 histSubstancePrescripDep
Yes 9/24/2009 varchar(255) Null
histSubstancePrescripDep



DoDSER-A 8 tbDoDSER 170 histSubstancePrescripAbuse
Yes 9/24/2009 varchar(255) Null
histSubstancePrescripAbuse



DoDSER-A 8 tbDoDSER 171 histSubstanceOtcDep
Yes 9/24/2009 varchar(255) Null
histSubstanceOtcDep



DoDSER-A 8 tbDoDSER 172 histSubstanceOtcAbuse
Yes 9/24/2009 varchar(255) Null
histSubstanceOtcAbuse



DoDSER-A 8 tbDoDSER 173 histPsychotropicMeds
Yes 9/24/2009 varchar(255) Null
histPsychotropicMeds



DoDSER-A 8 tbDoDSER 174 histAntidepressants
Yes 9/24/2009 varchar(255) Null
histAntidepressants



DoDSER-A 8 tbDoDSER 175 histAntidepressantsTime
Yes 9/24/2009 varchar(255) Null
histAntidepressantsTime



DoDSER-A 8 tbDoDSER 176 histAntianxiety
Yes 9/24/2009 varchar(255) Null
histAntianxiety



DoDSER-A 8 tbDoDSER 177 histAntianxietyTime
Yes 9/24/2009 varchar(255) Null
histAntianxietyTime



DoDSER-A 8 tbDoDSER 178 histAntimanics
Yes 9/24/2009 varchar(255) Null
histAntimanics



DoDSER-A 8 tbDoDSER 179 histAntimanicsTime
Yes 9/24/2009 varchar(255) Null
histAntimanicsTime



DoDSER-A 8 tbDoDSER 180 histAnticonvulsants
Yes 9/24/2009 varchar(255) Null
histAnticonvulsants



DoDSER-A 8 tbDoDSER 181 histAnticonvulsantsTime
Yes 9/24/2009 varchar(255) Null
histAnticonvulsantsTime



DoDSER-A 8 tbDoDSER 182 histAntipsychotics
Yes 9/24/2009 varchar(255) Null
histAntipsychotics



DoDSER-A 8 tbDoDSER 183 histAntipsychoticsTime
Yes 9/24/2009 varchar(255) Null
histAntipsychoticsTime



DoDSER-A 8 tbDoDSER 184 histPriorSelfInjury
Yes 9/24/2009 varchar(255) Null
histPriorSelfInjury



DoDSER-A 8 tbDoDSER 185 histPriorSelfInjuryTime
Yes 9/24/2009 varchar(255) Null
histPriorSelfInjuryTime



DoDSER-A 8 tbDoDSER 186 histPriorSelfInjuryOne
Yes 9/24/2009 varchar(255) Null
histPriorSelfInjuryOne



DoDSER-A 8 tbDoDSER 187 histPriorSelfInjurySim
Yes 9/24/2009 varchar(255) Null
histPriorSelfInjurySim



DoDSER-A 8 tbDoDSER 188 histPriorSelfInjuryAge
Yes 9/24/2009 float Null
histPriorSelfInjuryAge



DoDSER-A 8 tbDoDSER 189 histReceiveTraining
Yes 9/24/2009 varchar(255) Null
histReceiveTraining



DoDSER-A 8 tbDoDSER 190 histReceiveTrainingTime
Yes 9/24/2009 varchar(255) Null
histReceiveTrainingTime



DoDSER-A 8 tbDoDSER 192 histCourtsMartial
Yes 9/24/2009 varchar(255) Null
histCourtsMartial



DoDSER-A 8 tbDoDSER 193 histCourtsMartialTime
Yes 9/24/2009 varchar(255) Null
histCourtsMartialTime



DoDSER-A 8 tbDoDSER 194 histArticle15
Yes 9/24/2009 varchar(255) Null
histArticle15



DoDSER-A 8 tbDoDSER 195 histArticle15Time
Yes 9/24/2009 varchar(255) Null
histArticle15Time



DoDSER-A 8 tbDoDSER 196 histAdminSeparation
Yes 9/24/2009 varchar(255) Null
histAdminSeparation



DoDSER-A 8 tbDoDSER 197 histAdminSeparationTime
Yes 9/24/2009 varchar(255) Null
histAdminSeparationTime



DoDSER-A 8 tbDoDSER 198 histAwol
Yes 9/24/2009 varchar(255) Null
histAwol



DoDSER-A 8 tbDoDSER 199 histAwolTime
Yes 9/24/2009 varchar(255) Null
histAwolTime



DoDSER-A 8 tbDoDSER 200 histMedicalBoard
Yes 9/24/2009 varchar(255) Null
histMedicalBoard



DoDSER-A 8 tbDoDSER 201 histMedicalBoardTime
Yes 9/24/2009 varchar(255) Null
histMedicalBoardTime



DoDSER-A 8 tbDoDSER 202 histCivilLegal
Yes 9/24/2009 varchar(255) Null
histCivilLegal



DoDSER-A 8 tbDoDSER 203 histCivilLegalTime
Yes 9/24/2009 varchar(255) Null
histCivilLegalTime



DoDSER-A 8 tbDoDSER 204 histNonSelection
Yes 9/24/2009 varchar(255) Null
histNonSelection



DoDSER-A 8 tbDoDSER 205 histNonSelectionTime
Yes 9/24/2009 varchar(255) Null
histNonSelectionTime



DoDSER-A 8 tbDoDSER 207 histVictPhysAbuse
Yes 9/24/2009 varchar(255) Null
histVictPhysAbuse



DoDSER-A 8 tbDoDSER 208 histVictPhysAbuseTime
Yes 9/24/2009 varchar(255) Null
histVictPhysAbuseTime



DoDSER-A 8 tbDoDSER 209 histVictSexualAbuse
Yes 9/24/2009 varchar(255) Null
histVictSexualAbuse



DoDSER-A 8 tbDoDSER 210 histVictSexualAbuseTime
Yes 9/24/2009 varchar(255) Null
histVictSexualAbuseTime



DoDSER-A 8 tbDoDSER 211 histVictEmotAbuse
Yes 9/24/2009 varchar(255) Null
histVictEmotAbuse



DoDSER-A 8 tbDoDSER 212 histVictEmotAbuseTime
Yes 9/24/2009 varchar(255) Null
histVictEmotAbuseTime



DoDSER-A 8 tbDoDSER 213 histVictSexHarass
Yes 9/24/2009 varchar(255) Null
histVictSexHarass



DoDSER-A 8 tbDoDSER 214 histVictSexHarassTime
Yes 9/24/2009 varchar(255) Null
histVictSexHarassTime



DoDSER-A 8 tbDoDSER 215 histPerpPhysAbuse
Yes 9/24/2009 varchar(255) Null
histPerpPhysAbuse



DoDSER-A 8 tbDoDSER 216 histPerpPhysAbuseTime
Yes 9/24/2009 varchar(255) Null
histPerpPhysAbuseTime



DoDSER-A 8 tbDoDSER 217 histPerpSexualAbuse
Yes 9/24/2009 varchar(255) Null
histPerpSexualAbuse



DoDSER-A 8 tbDoDSER 218 histPerpSexualAbuseTime
Yes 9/24/2009 varchar(255) Null
histPerpSexualAbuseTime



DoDSER-A 8 tbDoDSER 219 histPerpEmotAbuse
Yes 9/24/2009 varchar(255) Null
histPerpEmotAbuse



DoDSER-A 8 tbDoDSER 220 histPerpEmotAbuseTime
Yes 9/24/2009 varchar(255) Null
histPerpEmotAbuseTime



DoDSER-A 8 tbDoDSER 221 histPerpSexHarass
Yes 9/24/2009 varchar(255) Null
histPerpSexHarass



DoDSER-A 8 tbDoDSER 222 histPerpSexHarassTime
Yes 9/24/2009 varchar(255) Null
histPerpSexHarassTime



DoDSER-A 8 tbDoDSER 224 histDeployCount
Yes 9/24/2009 varchar(255) Null
histDeployCount



DoDSER-A 8 tbDoDSER 225 histDeploy1Loc
Yes 9/24/2009 varchar(255) Null
histDeploy1Loc



DoDSER-A 8 tbDoDSER 228 histDeploy1StartDate
Yes 9/24/2009 datetime Null
histDeploy1StartDate



DoDSER-A 8 tbDoDSER 229 histDeploy1EndDate
Yes 9/24/2009 datetime Null
histDeploy1EndDate



DoDSER-A 8 tbDoDSER 230 histDeploy1RrStartDate
Yes 9/24/2009 datetime Null
histDeploy1RrStartDate



DoDSER-A 8 tbDoDSER 231 histDeploy1RrEndDate
Yes 9/24/2009 datetime Null
histDeploy1RrEndDate



DoDSER-A 8 tbDoDSER 232 histDeploy2Loc
Yes 9/24/2009 varchar(255) Null
histDeploy2Loc



DoDSER-A 8 tbDoDSER 235 histDeploy2StartDate
Yes 9/24/2009 datetime Null
histDeploy2StartDate



DoDSER-A 8 tbDoDSER 236 histDeploy2EndDate
Yes 9/24/2009 datetime Null
histDeploy2EndDate



DoDSER-A 8 tbDoDSER 237 histDeploy3Loc
Yes 9/24/2009 varchar(255) Null
histDeploy3Loc



DoDSER-A 8 tbDoDSER 240 histDeploy3StartDate
Yes 9/24/2009 datetime Null
histDeploy3StartDate



DoDSER-A 8 tbDoDSER 241 histDeploy3EndDate
Yes 9/24/2009 datetime Null
histDeploy3EndDate



DoDSER-A 8 tbDoDSER 242 histDeployWaiver
Yes 9/24/2009 varchar(255) Null
histDeployWaiver



DoDSER-A 8 tbDoDSER 243 histDirectCombat
Yes 9/24/2009 varchar(255) Null
histDirectCombat



DoDSER-A 8 tbDoDSER 244 histDirectCombatDep1
Yes 9/24/2009 varchar(255) Null
histDirectCombatDep1



DoDSER-A 8 tbDoDSER 245 histDirectCombatDep1Time
Yes 9/24/2009 varchar(255) Null
histDirectCombatDep1Time



DoDSER-A 8 tbDoDSER 246 histDirectCombatDep2
Yes 9/24/2009 varchar(255) Null
histDirectCombatDep2



DoDSER-A 8 tbDoDSER 247 histDirectCombatDep3
Yes 9/24/2009 varchar(255) Null
histDirectCombatDep3



DoDSER-A 8 tbDoDSER 248 histCombatCasualtiesDep1
Yes 9/24/2009 varchar(255) Null
histCombatCasualtiesDep1



DoDSER-A 8 tbDoDSER 249 histCombatCasualtiesDep2
Yes 9/24/2009 varchar(255) Null
histCombatCasualtiesDep2



DoDSER-A 8 tbDoDSER 250 histCombatCasualtiesDep3
Yes 9/24/2009 varchar(255) Null
histCombatCasualtiesDep3



DoDSER-A 8 tbDoDSER 251 histCombatInjuredDep1
Yes 9/24/2009 varchar(255) Null
histCombatInjuredDep1



DoDSER-A 8 tbDoDSER 252 histCombatInjuredDep2
Yes 9/24/2009 varchar(255) Null
histCombatInjuredDep2



DoDSER-A 8 tbDoDSER 253 histCombatInjuredDep3
Yes 9/24/2009 varchar(255) Null
histCombatInjuredDep3



DoDSER-A 8 tbDoDSER 254 histCombatWitnessDep1
Yes 9/24/2009 varchar(255) Null
histCombatWitnessDep1



DoDSER-A 8 tbDoDSER 255 histCombatWitnessDep2
Yes 9/24/2009 varchar(255) Null
histCombatWitnessDep2



DoDSER-A 8 tbDoDSER 256 histCombatWitnessDep3
Yes 9/24/2009 varchar(255) Null
histCombatWitnessDep3



DoDSER-A 8 tbDoDSER 257 histCombatSawBodiesDep1
Yes 9/24/2009 varchar(255) Null
histCombatSawBodiesDep1



DoDSER-A 8 tbDoDSER 258 histCombatSawBodiesDep2
Yes 9/24/2009 varchar(255) Null
histCombatSawBodiesDep2



DoDSER-A 8 tbDoDSER 259 histCombatSawBodiesDep3
Yes 9/24/2009 varchar(255) Null
histCombatSawBodiesDep3



DoDSER-A 8 tbDoDSER 260 histCombatKillDep1
Yes 9/24/2009 varchar(255) Null
histCombatKillDep1



DoDSER-A 8 tbDoDSER 261 histCombatKillDep2
Yes 9/24/2009 varchar(255) Null
histCombatKillDep2



DoDSER-A 8 tbDoDSER 262 histCombatKillDep3
Yes 9/24/2009 varchar(255) Null
histCombatKillDep3



DoDSER-A 8 tbDoDSER 263 eventOrdersDeploy
Yes 9/24/2009 varchar(255) Null
eventOrdersDeploy



DoDSER-A 8 tbDoDSER 264 eventRelatedDeployment
Yes 9/24/2009 varchar(255) Null
eventRelatedDeployment



DoDSER-A 8 tbDoDSER 265 eventRelatedDeploymentAnt
Yes 9/24/2009 varchar(255) Null
eventRelatedDeploymentAnt



DoDSER-A 8 tbDoDSER 266 eventRelatedDeploymentCur
Yes 9/24/2009 varchar(255) Null
eventRelatedDeploymentCur



DoDSER-A 8 tbDoDSER 267 eventRelatedDeploymentPri
Yes 9/24/2009 varchar(255) Null
eventRelatedDeploymentPri



DoDSER-A 8 tbDoDSER 269 histFailedRelSpouse
Yes 9/24/2009 varchar(255) Null
histFailedRelSpouse



DoDSER-A 8 tbDoDSER 270 histFailedRelSpouseTime
Yes 9/24/2009 varchar(255) Null
histFailedRelSpouseTime



DoDSER-A 8 tbDoDSER 271 histFailedRelOther
Yes 9/24/2009 varchar(255) Null
histFailedRelOther



DoDSER-A 8 tbDoDSER 272 histFailedRelOtherTime
Yes 9/24/2009 varchar(255) Null
histFailedRelOtherTime



DoDSER-A 8 tbDoDSER 273 histSpouseSuicide
Yes 9/24/2009 varchar(255) Null
histSpouseSuicide



DoDSER-A 8 tbDoDSER 274 histSpouseSuicideTime
Yes 9/24/2009 varchar(255) Null
histSpouseSuicideTime



DoDSER-A 8 tbDoDSER 275 histFamilySuicide
Yes 9/24/2009 varchar(255) Null
histFamilySuicide



DoDSER-A 8 tbDoDSER 276 histFamilySuicideTime
Yes 9/24/2009 varchar(255) Null
histFamilySuicideTime



DoDSER-A 8 tbDoDSER 277 histFriendSuicide
Yes 9/24/2009 varchar(255) Null
histFriendSuicide



DoDSER-A 8 tbDoDSER 278 histFriendSuicideTime
Yes 9/24/2009 varchar(255) Null
histFriendSuicideTime



DoDSER-A 8 tbDoDSER 279 histFamilyDeath
Yes 9/24/2009 varchar(255) Null
histFamilyDeath



DoDSER-A 8 tbDoDSER 280 histFamilyDeathTime
Yes 9/24/2009 varchar(255) Null
histFamilyDeathTime



DoDSER-A 8 tbDoDSER 281 histFriendDeath
Yes 9/24/2009 varchar(255) Null
histFriendDeath



DoDSER-A 8 tbDoDSER 282 histFriendDeathTime
Yes 9/24/2009 varchar(255) Null
histFriendDeathTime



DoDSER-A 8 tbDoDSER 283 histPhysicalHealth
Yes 9/24/2009 varchar(255) Null
histPhysicalHealth



DoDSER-A 8 tbDoDSER 284 histPhysicalHealthTime
Yes 9/24/2009 varchar(255) Null
histPhysicalHealthTime



DoDSER-A 8 tbDoDSER 285 histFamilyIllness
Yes 9/24/2009 varchar(255) Null
histFamilyIllness



DoDSER-A 8 tbDoDSER 286 histFamilyIllnessTime
Yes 9/24/2009 varchar(255) Null
histFamilyIllnessTime



DoDSER-A 8 tbDoDSER 287 histDebtBankruptcy
Yes 9/24/2009 varchar(255) Null
histDebtBankruptcy



DoDSER-A 8 tbDoDSER 288 histDebtBankruptcyTime
Yes 9/24/2009 varchar(255) Null
histDebtBankruptcyTime



DoDSER-A 8 tbDoDSER 289 histJobProblems
Yes 9/24/2009 varchar(255) Null
histJobProblems



DoDSER-A 8 tbDoDSER 290 histJobProblemsTime
Yes 9/24/2009 varchar(255) Null
histJobProblemsTime



DoDSER-A 8 tbDoDSER 291 histCoworkerIssues
Yes 9/24/2009 varchar(255) Null
histCoworkerIssues



DoDSER-A 8 tbDoDSER 292 histCoworkerIssuesTime
Yes 9/24/2009 varchar(255) Null
histCoworkerIssuesTime



DoDSER-A 8 tbDoDSER 293 histPoorPerformance
Yes 9/24/2009 varchar(255) Null
histPoorPerformance



DoDSER-A 8 tbDoDSER 294 histPoorPerformanceTime
Yes 9/24/2009 varchar(255) Null
histPoorPerformanceTime



DoDSER-A 8 tbDoDSER 295 histWorkplaceHazing
Yes 9/24/2009 varchar(255) Null
histWorkplaceHazing



DoDSER-A 8 tbDoDSER 296 histWorkplaceHazingTime
Yes 9/24/2009 varchar(255) Null
histWorkplaceHazingTime



DoDSER-A 8 tbDoDSER 297 histFamilyMental
Yes 9/24/2009 varchar(255) Null
histFamilyMental



DoDSER-A 8 tbDoDSER 298 histGunInHome
Yes 9/24/2009 varchar(255) Null
histGunInHome



DoDSER-A 8 tbDoDSER 302 aserLocSame
Yes 9/24/2009 varchar(255) Null
aserLocSame



DoDSER-A 8 tbDoDSER 303 aserLocCountry
Yes 9/24/2009 varchar(255) Null
aserLocCountry



DoDSER-A 8 tbDoDSER 305 aserLocState
Yes 9/24/2009 varchar(255) Null
aserLocState



DoDSER-A 8 tbDoDSER 306 aserLocCity
Yes 9/24/2009 varchar(255) Null
aserLocCity



DoDSER-A 8 tbDoDSER 307 aserLocMedicalFacility
Yes 9/24/2009 varchar(255) Null
aserLocMedicalFacility



DoDSER-A 8 tbDoDSER 309 dodserLocMedFacilityAf
Yes 9/24/2009 varchar(255) Null
dodserLocMedFacilityAf



DoDSER-A 8 tbDoDSER 311 dodserLocMedFacilityOther
Yes 9/24/2009 varchar(255) Null
dodserLocMedFacilityOther



DoDSER-A 8 tbDoDSER 313 aserProviderRank DI Yes 9/24/2009 varchar(255) Null
aserProviderRank



DoDSER-A 8 tbDoDSER 317 aserProviderSpecialty
Yes 9/24/2009 varchar(255) Null
aserProviderSpecialty



DoDSER-A 8 tbDoDSER 320 aserCompleterRank DI Yes 9/24/2009 varchar(255) Null
aserCompleterRank



DoDSER-A 8 tbDoDSER 321 aserCompleterCommand
Yes 9/24/2009 varchar(255) Null
aserCompleterCommand



DoDSER-A 8 tbDoDSER 325 sourceInterviewPatient
Yes 9/24/2009 varchar(255) Null
sourceInterviewPatient



DoDSER-A 8 tbDoDSER 326 sourceInterviewCoworkers
Yes 9/24/2009 varchar(255) Null
sourceInterviewCoworkers



DoDSER-A 8 tbDoDSER 327 sourceInterviewOfficer
Yes 9/24/2009 varchar(255) Null
sourceInterviewOfficer



DoDSER-A 8 tbDoDSER 328 sourceInterviewProfessionals
Yes 9/24/2009 varchar(255) Null
sourceInterviewProfessionals



DoDSER-A 8 tbDoDSER 329 sourceInterviewFamily
Yes 9/24/2009 varchar(255) Null
sourceInterviewFamily



DoDSER-A 8 tbDoDSER 330 sourceReviewMedical
Yes 9/24/2009 varchar(255) Null
sourceReviewMedical



DoDSER-A 8 tbDoDSER 331 sourceReviewAdvocacy
Yes 9/24/2009 varchar(255) Null
sourceReviewAdvocacy



DoDSER-A 8 tbDoDSER 332 sourceReviewSubstanceAbuse
Yes 9/24/2009 varchar(255) Null
sourceReviewSubstanceAbuse



DoDSER-A 8 tbDoDSER 333 sourceReviewSubAbNotArmy
Yes 9/24/2009 varchar(255) Null
sourceReviewSubAbNotArmy



DoDSER-A 8 tbDoDSER 334 sourceReviewPersonnel
Yes 9/24/2009 varchar(255) Null
sourceReviewPersonnel



DoDSER-A 8 tbDoDSER 335 sourceReviewAgency
Yes 9/24/2009 varchar(255) Null
sourceReviewAgency



DoDSER-A 8 tbDoDSER 336 sourceReviewCourtmartial
Yes 9/24/2009 varchar(255) Null
sourceReviewCourtmartial



DoDSER-A 8 tbDoDSER 337 sourceReviewManner
Yes 9/24/2009 varchar(255) Null
sourceReviewManner



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