Download:
pdf |
pdfDSAID Data Requirements v1.6.3
DRTag
DRName
DR_Text
UR/R
Only
Required For
Closure (AF)
From "Open"
Status
UR Only Y
UR Only Y
UR Only N
Y
DR1.1
DR1.2
DR1.3
DR1.4
Victim Last Name
Victim First Name
Victim Middle Name
Victim Number (DSAID Control
Number)
DR1.5
Victim Identification Type
The Last Name of a victim involved in a sexual assault incident.
The First Name of a victim involved in a sexual assault incident.
The Middle Name of a victim involved in a sexual assault incident.
This is the DSAID (Defense Sexual Assault Incident Database)
generated unique DoD Victim Incident Number, also called the DSAID
Control Number. This number may change when converting a DSAID
case from restricted to unrestricted, or transferring a DSAID case to
another SARC.
The type of identification number that a victim provides when reporting UR Only Y
a sexual assault incident.
Required DR_Format
For Closure
(NG)
DBR_Tag DBR_Text
NG_Source
Y
Y
N
Y
Free Text
Free Text
Free Text
SARC
SARC
SARC
DSAID
Y
Standard List
SARC
Y
Number
DBR2
If SSN is selected, the format of Victim
Identification Number follows NNN-NN-NNNN.
Y
Y
Date Format
Free Text
DBR3
Victim Age at the time of incident has to be
between number 0 and 99 or Unknown.
DR1.6
Victim Identification Number
DR1.7
DR1.8
Victim Birth Date
Victim Age at the Time of
Incident
The standard valid values are:
SSN
Passport Number
Alien Registration
Foreign Country ID
Unknown
The identification number of a victim based upon the identification type UR Only Y
that a victim provides.
The birth date of a victim involved in a sexual assault incident.
UR Only Y
The age of a victim at the time of incident, when the sexual assault
Y
incident occurred.
Victim Gender
The valid values are:
Number (0-99)
Unknown (DIBRS July 2003)
The gender of a victim involved in a sexual assault incident.
Y
Y
Standard List
SARC
Victim Race
The standard valid values are:
Male
Female
The race of a victim involved in a sexual assault incident.
Y
Y
Standard List
SARC
Victim Ethnicity
The standard valid values are:
(DIBRS July 2003)
American Indian
Asian/Pacific Islander
Black
White
Mixed
Unknown
The ethnicity of a victim involved in a sexual assault incident.
Y
Y
Standard List
SARC
DR1.9
DR1.10
DR1.11
SARC
SARC
SARC
The standard valid values are:
(DIBRS July 2003)
Hispanic
Not Hispanic
Unknown
06/24/2011
Victim Case Management
1 of 36
DSAID Data Requirements v1.6.3
DRTag
DRName
DR_Text
DR1.12
Victim Type
The type of a victim involved in a sexual assault incident indicating
whether the victim is military or any type of civilians.
DR1.13
Victim Affiliation
UR/R
Only
The standard valid values are:
Military
DoD Civilian
DoD Contractor
Other Government Civilian
US Civilian
Foreign National
Foreign Military
The military service or DoD agency that a victim is affiliated with based
upon the Victim Type.
The respective service for a Military Service Academy (MSA) and
National Guard victim should be used for this data element.
Required For
Closure (AF)
From "Open"
Status
Y
Required DR_Format
For Closure
(NG)
DBR_Tag DBR_Text
NG_Source
Y
Standard List
DBR152
Victim Type values "Foreign National" and
"Foreign Military" are only applicable if Report
Type is "Unrestricted".
SARC
Y
Y
Standard List
DBR4
If Victim Type is "Military," Only Affiliations
SARC
applicable are Service related.
If Victim Type is "DoD Civilian," all Affiliations are
applicable.
Other Victim Types will not have Victim Affiliation.
The standard valid values are:
(DIBRS July 2003):
Army
Navy
Air Force
Marine Corps
Coast Guard
DARPA
DCM
DCAA
DCMA
DFAS
DISA
DIA
DLSA
DLA
DSCA
DSS
DTRA
MDA
NIMA
NSA/CCS
PPA
NOAA
Public Health
06/24/2011
Victim Case Management
2 of 36
DSAID Data Requirements v1.6.3
DRTag
DRName
DR_Text
DR1.14
Victim Pay Grade
The military Pay Grade of a victim involved in a sexual assault incident
and also indicates whether the victim is a prep school student.
DR1.16
Victim Pay Plan
UR/R
Only
The Valid Values are:
E-1 through E-9
W-1 through W-5
O-1 through O-10
C-1 through C-4 (for Cadet)
M-1 through M-4 (for Midshipman)
Prep School Student
Note: Each value should be listed separately as valid values for user to
select.
The US Government Pay Plan of a victim involved in a sexual assault
incident when the victim is civilian and is affiliated with any DoD or US
government agencies.
Required For
Closure (AF)
From "Open"
Status
Y
Required DR_Format
For Closure
(NG)
DBR_Tag DBR_Text
NG_Source
Y
Standard List
DBR5
Victim Pay Grade will only be required when
Victim Type is "Military".
SARC
Y
Y
Standard List
DBR6
Victim Pay Plan of a Victim is required only when SARC
Victim Type is "DoD Civilian" or "Other
Government Civilian".
The standard valid values are:
General Schedule
NSPS
Wage Grade
Non-appropriate Fund
Senior Executive Service
Other
Unknown
06/24/2011
Victim Case Management
3 of 36
DSAID Data Requirements v1.6.3
DRTag
DRName
DR_Text
DR1.17
Victim Grade
The US Government Pay Grade of a victim involved in a sexual assault
incident when the victim is civilian and affiliated with any DoD or US
government agencies.
DR1.18
DR1.19
Victim Duty Status
Victim National Guard Service
UR/R
Only
The standard valid values are:
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
I
II
III
IV
V
VI
PB1
PB2
PB3
PB4
Unknown
The
military Duty Status of a victim. Note: For active duty National
Guard members, Duty Status should be "National Guard" instead of
"Active Duty".
The standard valid values are:
Active Duty
Reserve
National Guard
The National Guard Service category of a victim involved in a sexual
assault incident.
Required For
Closure (AF)
From "Open"
Status
Y
Required DR_Format
For Closure
(NG)
DBR_Tag DBR_Text
NG_Source
Y
Standard List
DBR7
Victim Grade is only captured when Victim Type SARC
is DoD Civilian or Other Government Civilian.
If Victim Pay Plan is "Unknown", then Victim
Grade is defaulted to "Unknown"
Y
Y
Standard List
DBR8
Victim Duty Status is only required when Victim
Type is "Military".
SARC
Y
Y
Standard List
DBR9
Victim National Guard Service is only required
when Victim Duty Status is "National Guard".
SARC
The standard valid values are:
Title 10
Title 32
State
06/24/2011
Victim Case Management
4 of 36
DSAID Data Requirements v1.6.3
DRTag
DRName
DR_Text
DR1.20
Victim NG State Affiliation
The State of a National Guard as a victim involved in a sexual assault
incident.
DR1.21
DR1.22
Victim NG Title 10 Category
Victim NG Title 32 Category
UR/R
Only
The standard valid values are:
50 States
District of Columbia
Puerto Rico
Guam
Virgin Islands
Note: 50 states shall be listed separately as valid values for user to
choose.
A subcategory that further defines a National Guard Service as a victim
of a sexual assault incident when the person's National Guard Service
is "Title 10".
The standard valid values are:
Mobilized
Active Guard and Reserve (AGR)
Annual Training (OCONUS)
Active Duty Operational Support (ADOS)30+ days
ADOS less than 30 days
A subcategory that further defines a National Guard Service as a victim
of a sexual assault incident when the person's National Guard Service
is "Title 32".
The standard valid values are:
Active Duty Operational Support (ADOS) 30+ days
Active Guard and Reserve (AGR)
Annual Training
Inactive Duty for Training (Traditional Drilling Status)
Full time National Guard Duty
Not in Duty Status
DSAID Location Code of a permanent duty station that a victim is
physically assigned to.
Required For
Closure (AF)
From "Open"
Status
N
Required DR_Format
For Closure
(NG)
DBR_Tag DBR_Text
NG_Source
N
Standard List
DBR10
Victim NG State Affiliation is only required when SARC
Victim Duty Status is "National Guard".
N
Y
Standard List
DBR11
Victim NG Title 10 Category is only required
SARC
when Victim National Guard Service is "Title 10".
N
Y
Standard List
DBR12
Victim NG Title 32 Category is only required
SARC
when Victim National Guard Service is "Title 32".
Y
N
Standard List
DBR122
Victim Assigned Location Code is only required SARC
when the Victim Type is "Military", "DoD Civilian",
"DoD Contractor" or "Other Government Civilian.
Y
N
Text
DBR123
Victim Assigned Location Name is only required DSAID
when the Victim Type is "Military", "DoD Civilian",
"DoD Contractor" or "Other Government Civilian.
DR1.24
Victim Assigned Location Code
DR1.25
Victim Assigned Location Name The DSAID Location Description of the installation based on the victim's
Assigned Location Code entered by SARC or through search Location
Code function.
DR1.26
Victim Assigned Unit UIC
The Unit Identification Code (UIC) of a unit that a victim is affiliated
within the service.
UR Only Y
Y
Free Text
DBR124
Victim Assigned Unit UIC is only required when SARC
the Victim Type is "Military", "DoD Civilian", "DoD
Contractor" or "Other Government Civilian.
DR1.27
Victim Assigned Unit Name
The Unit Name for the victim's Assigned Unit UIC entered by SARC.
UR Only Y
Y
Free Text
DBR125
Victim Assigned Unit Name is only required when SARC
the Victim Type is "Military", "DoD Civilian", "DoD
Contractor" or "Other Government Civilian.
06/24/2011
Victim Case Management
5 of 36
DSAID Data Requirements v1.6.3
DRTag
DRName
DR_Text
DR1.28
Victim Dependent Status
The indicator of whether a victim involved in a sexual assault incident is
a military dependent or DoD Civilian (OCONUS) dependent.
DR1.29
DR1.30
Victim Recruit/Training Status
NG Victim Recruit/Training
Status
UR/R
Only
The standard valid values are:
Yes - Military Dependent
Yes - DoD Civilian (OCONUS) Dependent
No
The indicator of whether a victim involved in a sexual assault incident is
in Recruit /Training status or not.
The standard valid values are:
Yes
No
A subcategory that further defines the program that a National Guard
Member with Recruit/Training status as a victim is associated with.
The standard valid values are:
NG Pre-accession recruit sustainment program (RSP)
Pre-recruit General Education Development (GED) program
Basic Training
AIT (Annual Individual Training)
The date provided by SARC indicating that a victim involved in a sexual
assault incident first reported to any of the DoD facilities.
DR1.31
Date of Report to DoD
DR1.32
Report Type
DR1.33
The standard valid values are:
Restricted
Unrestricted
Date Victim Informed of Options The date that a victim involved in a sexual assault incident was
informed of reporting options.
Date Victim Signed Election
The date that a victim involved in a sexual assault incident signed the
Form
reporting option election form (DD Form 2910).
DR1.34
06/24/2011
The type of reporting option with which a victim involved in a sexual
assault incident wishes to open a DSAID case.
Required For
Closure (AF)
From "Open"
Status
Y
Required DR_Format
For Closure
(NG)
Y
Standard List
Y
Y
Standard List
DBR80
Victim Recruit/Training Status is only required
when Victim Type is "Military"
SARC
N
Y
Standard List
DBR14
NG Victim Recruit/Training Status is only
required when Victim National Guard Service is
"Title 32" or "State" and Victim Recruit/Training
Status of the victim is "Yes".
SARC
Y
Y
Date Format
DBR15
Y
Y
Standard List
Date of Report to DoD is required to open a case SARC
in DSAID and must be less than or equal to
today's date.
SARC
Y
Y
Date Format
DBR16
Y
Y
Date Format
DBR17
Date Victim informed of Options must be less
than or equal to today's date.
Date Victim Signed Election Form must be less
than or equal to today's date.
Victim Case Management
DBR_Tag DBR_Text
NG_Source
SARC
SARC
SARC
6 of 36
DSAID Data Requirements v1.6.3
DRTag
DRName
DR_Text
DR1.35
Restricted Report Reason
The reason that a victim involved in a sexual assault incident opted the
"Restricted" reporting option.
DR1.36
DR1.37
DR1.38
If Other, Explain (Restricted
Report Reason)
Restricted Report Exception
Applied
Reason for Exception
UR/R
Only
The standard valid values are:
Desire to avoid retelling story
Thought the matter was not important enough to report to law
enforcement
Feared some kind of retaliation from the offender or the offender's
friends
Thought he/she would be blamed or labeled a troublemaker
Feared he/she or friends would be punished for a collateral offense,
such as underage drinking or curfew violation
Feared being the target of gossip or his/her reputation being damaged
in eyes of commander or unit members
Thought he/she would not be believed
Was concerned that reporting would prevent finishing training or
completing an operational mission
Was concerned that reporting would delay returning home from a
deployment
Was concerned that reporting would impact security clearance
Was concerned that reporting would negatively impact career
Did not want to hurt the offender's career
Was concerned that reporting would result in being sent home from a
deployment early
Declined to specify a reason
Other
The explanation when "Other" is selected for the Restricted Report
reason by the victim.
The indicator of whether prohibition on disclosing covered
communications to the persons or entities is suspended.
The standard valid values are:
Yes
No
The reason as to why prohibition on disclosing covered communications
to the persons or entities is suspended for a Restricted reporting option.
Required For
Closure (AF)
From "Open"
Status
Y
Required DR_Format
For Closure
(NG)
DBR_Tag DBR_Text
NG_Source
Y
Standard List
DBR18
Restricted Report Reason is only required when SARC
Report Type is "Restricted".
Y
Y
Free Text
DBR19
Y
Y
Standard List
If Other, Explain is only required when Restricted SARC
Report Reason is "Other".
SARC
Y
Y
Standard List
DBR20
Reason for Exception is only required when
Restricted Report Exception Applied is "Yes".
SARC
The standard valid values are:
Disclosure is authorized by victim in writing
Disclosure is necessary to prevent or lessen a serious and imminent
threat to health or safety of the victim or another person
Disclosure by a HCP is required for fitness or duty for disability
retirement determinations
Disclosure is required for SARC, VA or HCP to provide supervision
and/or coordination of direct victim treatment or services
Communicate when disclosure is ordered by a judge, or other officials
or entities as required by a Federal or State statute or applicable U.S.
international agreement
06/24/2011
Victim Case Management
7 of 36
DSAID Data Requirements v1.6.3
DRTag
DRName
DR_Text
DR1.39
Date Victim Signed Form
Electing to Convert from
Restricted to Unrestricted
Conversion Reason if Known or
Available
The date a victim involved in a sexual assault incident elected to
convert from Restricted to Unrestricted Report.
Required For
Closure (AF)
From "Open"
Status
Y
Required DR_Format
For Closure
(NG)
DBR_Tag DBR_Text
Y
Date Format
DBR21
The reason that a victim involved in a sexual assault incident converted
the reporting option from Restricted to Unrestricted, if known.
N
Y
Free Text
DBR130
Victim Transferred to New
SARC?
The indicator of whether a victim involved in a sexual assault incident
was transferred to a new SARC or not.
Y
Y
Standard List
DR1.42
DR1.43
New SARC ID
New SARC Location Name
Y
Y
Y
Y
Text
DSAID
SARC
DR1.44
Relationship to Subject
The standard valid values are:
Yes
No
The ID of the SARC that a victim is transferred to.
The Location Name of the new SARC that a victim is transferred and is
based upon the New SARC ID.
The relationship of a victim to each subject that is involved in the sexual
assault incident.
Y
Y
Standard List
SARC
UR Only Y
Y
Y
Y
Free Text
Standard List
SARC
SARC
Y
Y
Free Text
DR1.40
DR1.41
DR1.45
DR1.46
DR1.47
Commander Name
Command Notification
Accomplished within 24 hrs?
The standard valid values are:
Friend
Neighbor
Acquaintance
Love Interest
Former Spouse
Extended Family Member
Employee
Employer
Stranger
Otherwise Known
Relationship Unknown
Supervisor/Command
Recruiter
Coworker
The victim's contact commander name.
The indicator of whether the commander of a victim is notified of the
sexual assault within 24 hours from the "Date of Report to DoD". For
restricted report, commander is only notified of environmental
information only without victim specifics.
The standard valid values are:
Yes
No
If No, Reason (Command
The reason as to why the commander is not notified of the sexual
Notification Accomplished within assault within 24 hours from the "Date of Report to DoD".
24 hrs?)
06/24/2011
UR/R
Only
Victim Case Management
DBR22
NG_Source
Date Victim Signed Form Electing to Convert
SARC
from Restricted to Unrestricted must be less than
or equal to today's date.
Conversion Reason if known or Available is only SARC
applicable when Date Victim Signed Form
Electing to Convert from Restricted to
Unrestricted is populated.
DSAID
If No, Reason is only required when Command SARC
Notification Accomplished within 24 hrs? is "No".
8 of 36
DSAID Data Requirements v1.6.3
DRTag
DRName
DR_Text
DR1.48
Incident Occurred on
Deployment?
The indicator entered by SARC as to whether an incident is occurred
while the victim is in combat area of interest.
DR1.49
DR1.50
DR1.51
DR1.52
DR1.53
DR1.54
Incident Occurred on TDY?
Incident Occurred on Leave?
UR/R
Only
The standard valid values are:
Yes
No
The indicator entered by SARC as to whether an incident is occurred
while the victim is on Temporary Duty (TDY).
The standard valid values are:
Yes
No
The indicator entered by SARC as to whether an incident is occurred
while the victim is on leave.
The standard valid values are:
Yes
No
Was Victim in Military at Time of The indicator of whether the sexual assault incident occurred when the
Assault?
victim was in the military service.
The standard valid values are:
Yes
No
Does location require mandatory The indicator of whether the location, by state law, requires medical
reporting for medical care for a providers to report sexual assaults to law enforcements.
sexual assault?
The standard valid values are:
Yes
No
Assigned SARC Name(s)
The name(s) of the SARC who are assigned or are responsible for the
DSAID victim incident record. The Assigned SARC Name(s) are based
on the SARC ID(s) and are populated from SARC information
maintained in DSAID for each service.
VA assigned?
The indicator of whether Victim Advocate (VA) is assigned to a victim or
not.
DR1.55
Assigned VA Name
DR1.56
VA Not Assigned Reason
DR1.57
Was Forensic Exam Offered?
The standard valid values are:
Yes
No
The name of the VA that is assigned to a victim involved in a sexual
assault incident. The Assigned VA name is from the VA information
maintained in DSAID for each location.
The reason as to why VA is not assigned to a victim involved in a
sexual assault incident.
The indicator of whether or not a forensic exam was offered to a victim
involved in a sexual assault incident.
Required For
Closure (AF)
From "Open"
Status
Y
Required DR_Format
For Closure
(NG)
DBR_Tag DBR_Text
Y
Standard List
SARC
Y
Y
Standard List
SARC
Y
Y
Standard List
SARC
Y
Y
Standard List
Y
Y
Standard List
Y
Y
Free Text
Y
Y
Standard List
Y
Y
Free Text
DBR23
Assigned VA Name is only required when VA
assigned? is "Yes".
SARC
Y
Y
Free Text
DBR24
VA not assigned reason is only required when
VA assigned? is "No".
SARC
Y
Y
Standard List
DBR114
NG_Source
Did assault occur when the victim was in
SARC
military? is only required when the Victim Type is
"Military", " DoD Civilian", "DoD Contractor", "US
Civilian", or "Other Government Civilian".
SARC
DBR119
There can be more than one SARC that is
assigned to a DSAID victim case.
SARC/DSAID
SARC
SARC
The standard valid values are:
Yes
No
06/24/2011
Victim Case Management
9 of 36
DSAID Data Requirements v1.6.3
DRTag
DRName
DR_Text
DR1.58
If No, Reason (Was forensic
exam offered?)
Forensic Exam Completed?
The reason why forensic exam was not offered to a victim involved in a
sexual assault incident.
The indicator of whether forensic exam was completed for a victim
involved in a sexual assault incident or not.
DR1.59
DR1.60
DR1.61
DR1.62
DR1.63
DR1.64
DR1.65
DR1.66
Location of Forensic Exam
Conducted
UR/R
Only
Required For
Closure (AF)
From "Open"
Status
Y
Required DR_Format
For Closure
(NG)
DBR_Tag DBR_Text
NG_Source
Y
Free Text
DBR25
SARC
Y
Y
Standard List
Y
Y
Standard List
DBR26
Location of Forensic Exam Conducted is only
required when Forensic Exam Completed? is
"Yes".
Y
Y
Standard List
DBR27
If Forensic Exam not completed, was it because SARC
SAFE Kit and/or other needed supplies not
available? is only required when Forensic Exam
Completed is "No".
Y
Y
Date Format
DBR28
Y
Y
Date Format
DBR29
Date of Forensic Exam is only required when
Forensic Exam Completed is "Yes".
Expiration Date of SAFE Kit is always one year
from Date of Forensic Exam and populated by
DSAID.
Y
Y
Free Text
Y
Y
Free Text
Y
Y
Standard List
R Only
Y
Y
Date Format
DBR31
R Only
Y
Y
Standard List
DBR32
The standard valid values are:
Yes
No
The location that forensic exam was conducted for a victim involved in a
sexual assault incident.
The standard valid values are:
On Base/Post
Off Base/Post
If Forensic Exam not completed, Indicates whether the Sexual Assault Forensic Exam (SAFE) not
was it because SAFE Kit and/or completed is due to either unavailability of SAFE Kit or other needed
other needed supplies not
supplies to a victim at the time of the exam.
available?
The standard valid values are:
Yes
No
Date of Forensic Exam
The date when Forensic Exam was performed to the victim involved in
a sexual assault incident.
Expiration Date of SAFE Kit
The expiration date of the SAFE kit containing the forensic evidence of
a victim involved in a sexual assault incident.
Storage Location of SAFE Kit
The location where the SAFE Kit is stored for a victim involved in a
sexual assault incident.
Evidence Identifier
An unique identifier associated with the sexual assault forensic
R Only
evidence provided by the victim.
Victim Notified SAFE Kit Due to The indicator of whether a victim involved in a sexual assault incident R Only
Expire
with Restricted reporting has been notified that his/her SAFE Kit is due
to expire in 60 days.
DR1.67
Date Victim Notified SAFE Kit
Due to Expire
The standard valid values are:
Yes
No
The date that a victim involved in a sexual assault incident with
Restricted reporting was notified of SAFE Kit expiration.
DR1.68
If No, Reason (Victim Notified
SAFE Kit Due to Expire)
The reason why a victim involved in a sexual assault incident with
Restricted reporting was not notified of SAFE Kit expiration."
If No, Reason is only required when Was
forensic exam offered? is "No".
SARC
SARC
SARC
DSAID
SARC
DBR30
Evidence Identifier is only required when the
victim reports the incident as "Restricted".
SARC
SARC
Date Victim Notified SAFE Kit Due to Expire is
SARC
only required when Victim Notified SAFE Kit Due
to Expire is "Yes".
If No, Reason is only required when Victim
SARC
Notified SAFE Kit Due to Expire is "No".
The standard valid values are:
Victim has died
Victim has ETS/Retired
Unable to contact Victim
06/24/2011
Victim Case Management
10 of 36
DSAID Data Requirements v1.6.3
DRTag
DRName
DR_Text
DR1.69
Type of Referral Support
The type(s) of referral support that is offered to a victim involved in a
sexual assault incident.
DR1.70
DR1.71
DR1.72
DR1.73
DR1.74
DR1.75
If Other, Explain (Type of
Referral Support)
Referral Resource Type
Date of Referral
LOD Initiated?
Victim Safety Assessment
Completed?
UR/R
Only
The standard valid values are:
Medical
Mental Health
Legal
Chaplain/Spiritual Support
Rape Crisis Center
Other
Victim Advocate/Uniformed Victim Advocate
DoD Safe Helpline
The explanation when "Other" is selected for the "Type of Referral
Support".
Indicates the type of referral resource provided to the victim.
The standard valid values are:
Military
Civilian
The date each referral is made regardless of On or Off installation.
The indicator of whether LOD is initiated for National Guard or Reserve
member.
The standard valid values are:
Yes
No
The indicator of whether safety assessment for a victim is completed or
not.
The standard valid values are:
Yes
No
Victim Safety Concern Identified The indicator of whether safety assessment for a victim is identified or
not.
DR1.76
Victim Safety Concern Note(s)
DR1.77
Safety Concern Note Date
06/24/2011
The standard valid values are:
Yes
No
Note(s) that a SARC can enter regarding safety concern of a victim.
A date stamp by DSAID when a Victim Safety Concern Note is created
by a SARC.
Required For
Closure (AF)
From "Open"
Status
Y
Required DR_Format
For Closure
(NG)
Y
Standard List
Y
Y
Free Text
Y
Y
Standard List
Y
Y
Y
Y
Date Format
Standard List
Y
Y
Standard List
Y
Y
Standard List
DBR36
Victim Safety Concern Identified is only required SARC
when Victim Safety Assessment Completed is
"Yes".
Y
Y
Free Text
DBR37
Y
Y
Date Format
DBR98
Victim Safety Concern Note(s) is only required SARC
when Victim Safety Concern Identified is "Yes".
At least one note has to be entered, if Victim
Safety Assessment Completed is "Yes". SARCs
are allowed to enter up to 6 Note entries.
Safety Concern Note Date is populated by
DSAID
DSAID when a Safety Concern Note is entered
by SARC.
Victim Case Management
DBR_Tag DBR_Text
NG_Source
SARC
DBR34
If Other, Explain is only required when Type of
Referral Support is "Other".
SARC
SARC
DBR35
SARC
LOD Initiated? is only required when Victim Duty SARC
Status is "National Guard" or "Reserve".
SARC
11 of 36
DSAID Data Requirements v1.6.3
DRTag
DRName
DR1.78
Military Protective Order Offered The indicator of whether Military Protective Order is offered to a victim
involved in a sexual assault incident or not.
DR1.79
DR1.80
DR1.81
Military Protective Order
Requested
DR_Text
UR/R
Only
Required For
Closure (AF)
From "Open"
Status
UR Only Y
Required DR_Format
For Closure
(NG)
Y
Standard List
SARC
UR Only Y
Y
Standard List
SARC
UR Only Y
Y
Date Format
SARC
UR Only Y
Y
Standard List
SARC
UR Only Y
Y
Standard List
SARC
UR Only Y
Y
Date Format
The indicator of whether a victim involved in a sexual assault incident is UR Only Y
moved by command or not. "Local" is defined as another physical
location or unit within the same Installation.
Y
Standard List
Y
Date Format
Y
Standard List
Y
Date Format
The standard valid values are:
Yes
No
The indicator of whether Military Protective Order is requested by a
victim involved in a sexual assault incident or not.
The standard valid values are:
Yes
No
Effective Date of Military
The effective date of when a Military Protective Order for a victim
Protective Order
involved in a sexual assault incident.
Civilian Protective Order Offered The indicator of whether Civilian Protective Order is offered to a victim
involved in a sexual assault incident or not.
Civilian Protective Order
Requested
The standard valid values are:
Yes
No
The indicator of whether Civilian Protective Order is requested by a
victim involved in a sexual assault incident or not.
DR1.83
Effective Date of Civilian
Protective Order
The standard valid values are:
Yes
No
The Effective Date of when a Civilian Protective Order for a victim
involved in a sexual assault incident.
DR1.84
Victim Moved (Local)
DR1.82
DR1.85
Date Victim Moved (Local)
DR1.86
Subject Moved (Local)
DR1.87
Date Subject Moved (Local)
06/24/2011
The standard valid values are:
Yes
No
The date that a victim involved in a sexual assault incident is moved by UR Only Y
command.
The indicator of whether a subject involved in a sexual assault incident UR Only Y
is moved by command or not. "Local" is defined as another physical
location or unit within the same Installation.
The standard valid values are:
Yes
No
The date that a subject involved in a sexual assault incident is moved
by command.
UR Only Y
Victim Case Management
DBR_Tag DBR_Text
NG_Source
DBR39
Effective Date of Civilian Protective Order is only SARC
required when Civilian Protective Order
Requested is "Yes".
SARC
DBR40
Date Victim Moved (Local) is only required when SARC
Victim Moved (Local) is "Yes".
SARC
DBR41
Date Subject Moved (Local) is only required
when Subject Moved (Local) is "Yes".
SARC
12 of 36
DSAID Data Requirements v1.6.3
DRTag
DRName
DR1.88
Victim Moved (ie, PCS)
DR1.89
Date Victim Moved (PCS)
DR1.90
Subject Moved (ie, PCS)
DR1.91
Date Subject Moved (PCS)
DR1.92
Are All Referrals Completed?
DR_Text
UR/R
Only
Required For
Closure (AF)
From "Open"
Status
The indicator of whether a victim involved in a sexual assault incident is UR Only Y
moved away from assigned local installation, for example, by command
for Permanent Change of Station (PCS) or not.
Y
Standard List
Y
Date Format
Y
Standard List
UR Only Y
Y
Date Format
Y
Y
Y
The standard valid values are:
Yes
No
The date that a victim involved in a sexual assault incident is moved by UR Only Y
command for Permanent Change of Station (PCS).
The indicator of whether a subject involved in a sexual assault incident UR Only Y
is moved away from assigned local installation, for example, by
command for Permanent Change of Station (PCS) or not.
The standard valid values are:
Yes
No
The date that a subject involved in a sexual assault incident is moved
by command for Permanent Change of Station (PCS).
The indicator of whether all referrals for a victim are completed or not.
Required DR_Format
For Closure
(NG)
DBR_Tag DBR_Text
NG_Source
SARC
DBR42
Date Victim Moved (PCS) is only required when SARC
Victim Moved (PCS) is "Yes".
SARC
DBR43
Standard List
Date Subject Moved (PCS) is only required when SARC
Subject Moved (PCS) is "Yes".
SARC
Y
Standard List
SARC
Y
Y
Standard List
DSAID
Y
Y
Date Format
DBR100
The standard valid values are:
Yes
No
DR1.93
DR1.94
Is DSAID Case Still Under Case The indicator of whether the DSAID victim is still under case
Management Group Review?
management group review or not.
DSAID Case Status
The standard valid values are:
Yes
No
The status indicating whether the DSAID victim file is open or closed.
The standard valid values are:
Open
Open with Limited Information
Closed
The date when a victim case is opened in DSAID. This is a date stamp
by DSAID when DSAID Case Status is updated to "Open".
DR1.95
DSAID Case Open Date
DR1.96
DSAID Case Close Date
The date when a victim case is closed in DSAID. This is a date stamp
by DSAID when DSAID Case Status is changed to "Closed".
Y
Y
Date Format
DBR99
DR1.97
Victim Informed of Right to
Request Installation Transfer
The indicator whether the victim of a sexual assault incident has been
informed of right to request installation transfer or not.
UR Only Y
Y
Standard List
DBR83
The system shall update DSAID Case Open Date DSAID
with the system date when DSAID Case Status is
updated to "Open".
The system shall update DSAID Case Close
DSAID
Date with the system date when DSAID Case
Status is changed to "Closed".
Victim Informed of Right to Request Installation SARC
Transfer is only required when Victim Type is
"Military".
The valid values are:
Yes
No
06/24/2011
Victim Case Management
13 of 36
DSAID Data Requirements v1.6.3
DRTag
DRName
DR_Text
DR1.98
Victim Requested Installation
Transfer
The indicator whether the victim of a sexual assault incident has
requested installation transfer or not.
Victim Granted Installation
Transfer
The valid values are:
Yes
No
The indicator whether the victim of a sexual assault incident has been
granted installation transfer or not.
DR1.99
DR1.100 DSAID Case SARC Transfer
Date
DR1.101 Victim NG State Status
DR1.102 If No, Reason (Victim Safety
Assessment Completed)
DR1.103 If No, Reason (LOD Initiated)
DR1.106 Military Protective Order
Violated?
UR/R
Only
The valid values are:
Yes
No
This is the date the DSAID Case was transferred to another SARC.
Victim NG State Status indicates whether the NG member is in state
active duty under Governor Control (which means for a specific mission
called by Governor).
The valid values are:
Yes
No
The reason indicating why the Victim Safety Assessment is not
completed.
The reason as to why LOD was not initiated for "National Guard" and
"Reserve" victims only.
Required For
Closure (AF)
From "Open"
Status
UR Only Y
Required DR_Format
For Closure
(NG)
DBR_Tag DBR_Text
NG_Source
Y
Standard List
DBR84
Victim Requested Installation Transfer is only
required when Victim Type is "Military".
SARC
UR Only Y
Y
Standard List
DBR85
Victim Requested Installation Transfer is only
required when Victim Type is "Military".
SARC
N
N
Date Format
N
Y
Standard List
DBR92
Victim NG State Status is only required when
Victim NG Service is "State".
SARC
Y
Y
Free Text
DBR88
SARC
N
Y
Standard List
DBR91
If No, Reason is only required if Victim Safety
Assessment Completed is "No".
If No, Reason is only required if LOD Initiated is
"No".
Y
Standard List
DBR136
Military Protective Order Violated? is only
required when Effective Date of Military
Protective Order is populated.
SARC
The valid values are:
Victim did not want LOD initiated
No information available from active duty SARC
LOD not offered
Assault did not occur in duty status
Other
The indicator of whether the Military Protective Ordered has been
UR Only Y
violated. Violations of Military Protection Orders should be drawn from
documented incidents (DA Form 3975 or similar LE documentation,
reports of investigation, or electronic records such as COPS or NCIC).
Violations of an MPO are usually covered by Article 92, UCMJ, and
should be reported whether or not disciplinary action was taken on the
violation. From the FY10 NDAA: "...information shall be collected
on...whether military protective orders involving members of the Armed
Forces were violated in the course of substantiated incidents of sexual
assaults against members of the Armed Forces.
DSAID
SARC
The standard valid values are:
Yes
No
06/24/2011
Victim Case Management
14 of 36
DSAID Data Requirements v1.6.3
DRTag
DRName
DR1.107 If Yes, Whom? (Military
Protective Ordered Violated)
DR1.108 Is Victim Administratively
Discharged Within one year of
Reporting?
DR1.109 Victim Dependent Relationship
DR1.111 Explanation for Open with
Limited Information Status
DR1.112 Referral Service Comment
06/24/2011
DR_Text
UR/R
Only
This element identifies the party that violated the Military Protective
Order.
The standard valid values are:
Victim
Subject
Both
The indicator of whether the Victim has been administratively
discharged within one year of Reporting?
The standard valid values are:
Yes
No
The Victim Dependent Relationship identifies the relationship of the
dependent to a military service member or DoD Civilian (OCONUS).
Required For
Closure (AF)
From "Open"
Status
UR Only Y
Required DR_Format
For Closure
(NG)
DBR_Tag DBR_Text
NG_Source
Y
Standard List
DBR111
If Yes, Whom? is only required if Military
Protective Order Violated? is "Yes".
SARC
UR Only Y
Y
Standard List
DBR117
Is Victim Administratively Discharged Within one SARC
year of Reporting is only required when Victim
Type is "Military".
Y
Y
Standard List
DBR113
Victim Dependent Relationship is only required
when Victim Dependent Status is "Yes - Military
Dependent" or "Yes - DoD Civilian (OCONUS)
Dependent".
N
Standard List
DBR116
Explanation for Open with Limited Information
SARC
Status is required when "Open with Limited
Information" is selected for DSAID Case Status.
N
Free Text
The standard valid values:
Spouse
Adult Child
Parent
The reason the SARC must choose to explain when "Open with Limited UR Only N
Information" Status is selected for a DSAID case.
The valid values are:
Victim refused/declined services
Victim opt-out of participating in investigative process
Local jurisdiction refused to provide victim information
Comments or notes associated with each referral service offered to a
victim.
N
Victim Case Management
SARC
SARC
15 of 36
DSAID Data Requirements v1.6.3
DRTag DRName
DR_Text
DR2.1
DR2.2
Investigative Case File Opened?
If No, Reason (Investigative Case
File Opened?)
DR2.3
If Other, Specify (Investigative
Case File Opened?)
DR2.4
Investigative Case Number
DR2.5
Case transferred between
Investigative Agencies within
Services
UR/R
Only
Required DR_Format DBR_Tag DBR_Text
For Closure
(NG)
NG_Source
Indicator of whether an investigative case file is opened in Investigative system or not.
Required For
Closure (AF)
From "Open"
Status
UR Only Y
Y
Standard
List
SARC
The standard valid values are:
Yes
No
The reason why an investigative case file is not opened for an Unrestricted report.
UR Only Y
Y
Standard
List
DBR45
If No, Reason is only required when Investigative
Case File Opened? is "No".
UR Only Y
Y
Free Text
DBR46
If Other, Specify is only required when If No, Reason SARC
is "Other".
The number that is used to track a case in services' Investigating systems. A case in an
UR Only Y
investigating system can have more than one victim or subject associated with it. DSAID Victim
Number (aka DSAID Control Number) will be associated with an investigative case number in
order to identify incident specific and subject information. This also applies to MCIO Monitor Case
Number when the case is being investigated by civilian law enforcement.
The indicator of whether a case that is investigated by one agency is transferred to a new
UR Only N
investigative agency for investigation within the same service."
N
DBR47
Investigative Case Number is only required when
Investigative Case File Opened? is "Yes".
The standard valid values are:
Incident occurred prior to victim's military service
Alleged perpetrator not subject to the UCMJ
Incident does not rise to MCIO threshold to open an investigation
Incident beyond statute of limitations
Other
The text indicating a reason that investigative case file is not opened for an unrestricted report,
other than the reasons listed in "If No, Reason (Investigative Case File Opened?)" data element.
The standard valid values are:
Yes
No
The new Investigative Case Number when a case is transferred.
DR2.6
Associated Investigative Case
Number
DR2.7
Investigative Agency Case Transfer The date that a case is transferred to another investigative agency, either across or within the
Date
Services.
Agency Conducting Investigation The agency that is conducting investigation for the incident.
DR2.8
DR2.9
Date of Incident
DR2.10 Is Date of Incident Estimated?
N
Standard
List
SARC
SARC
DSAID
UR Only N
N
DBR48
Associated Investigative Case Number is only
required when Case transferred between
investigative agencies is "Yes".
SARC
UR Only N
N
Date Format
SARC
UR Only Y
Y
Standard
List
SARC
The standard valid values are:
NCIS
AF OSI
ARMY CID
Navy/Marine Corp CID
Navy/Marine Corp Law Enforcement
Civilian Law Enforcement
Air Force Security Forces
None
The date the incident occurred.
Y
Y
Date Format DBR153
The indicator of whether the Date of Incident is estimated or not.
Y
Y
Standard
List
If filled, this date must be less than or equal to Date SARC
of Report to DoD.
SARC
The standard valid values are:
Yes
No
06/24/2011
Incident
16 of 36
DSAID Data Requirements v1.6.3
DRTag DRName
DR_Text
DR2.11 Incident Time of Day
UR/R
Only
Required DR_Format DBR_Tag DBR_Text
For Closure
(NG)
NG_Source
The time of day when a sexual assault incident occurred.
Required For
Closure (AF)
From "Open"
Status
Y
Y
Standard
List
SARC
DR2.12 Incident Day of Week
The standard valid values are:
Midnight to 6 am
6 am to 6 pm
6 pm to Midnight
Unknown
The day of week when a sexual assault incident occurred.
Y
Y
Standard
List
SARC
DR2.13 Incident Location
The standard valid values are:
Sunday
Monday
Tuesday
Wednesday
Thursday
Friday
Saturday
Unknown
The location of a sexual assault incident occurred.
Y
Y
Standard
List
SARC
The standard valid values are:
On Military Installation/Ship (Other than academy grounds)
On Academy Grounds
Off Military Installation/Ship/Academy Grounds
Unidentified
06/24/2011
Incident
17 of 36
DSAID Data Requirements v1.6.3
DRTag DRName
DR_Text
DR2.14 Type of Location
DR2.15 Incident Location Code
DR2.16 Incident Location Name
UR/R
Only
Required DR_Format DBR_Tag DBR_Text
For Closure
(NG)
NG_Source
The type of the location for a sexual assault incident occurred.
Required For
Closure (AF)
From "Open"
Status
Y
Y
Standard
List
SARC
The standard valid values are:
Submarine
Air/Bus/Train Terminal
Bank/Savings and Loan (includes other financial institutions, credit union)
Bar/Night Club/Officer Club/NONCOMMISSIONED OFFICER Club
Church/Synagogue/Temple (includes other religious buildings)
Commercial/Office Building
Construction Site
Convenience Store, Shoppette
Department/Discount Store, Exchange
Drug Store/Doctor's Office/Hospital, Clinic (includes medical supply building)
Field/Woods, Training Area
Government/Public Building
Grocery/Supermarket, Commissary
Highway/Road/Alley (includes street)
Hotel/Motel/Etc. (Includes other temporary military lodging)
Jail/Prison/Corrections Facility (includes penitentiary)
Lake/Waterway/Ocean
Liquor Store, Class VI
Parking Lot/Garage, Motor Pool
Rental Storage Facility (includes "Mini-Storage" and "Self-Storage" buildings)
Residence/Home (includes apartment, condominium, and nursing home, Quarters, Barracks,
BOQ/BEQ)
Restaurant, Dining Facility (includes cafeteria)
School/College (includes university)
Service/Gas Station
Concessionaire/Specialty Store
Child Care Center
Recreation Area/Park
Training
Center/Service
The Location
Code of theSchool
location where a sexual assault incident occurred.
Y
Y
Standard
List
Y
Y
Text
Y
Y
Standard
List
SARC
Y
Y
Standard
List
SARC
DR2.17 Was alcohol involved?
(Subject/Victim)
The Incident Location Name of the location based on the Incident Location Code entered by
SARC or through search Location Code function.
The indicator of whether alcohol was involved by subject(s) or victim(s) in a sexual assault
incident or not.
DR2.18 Were drugs involved?
(Subject/Victim)
The standard valid values are:
Yes
No
Unknown
The indicator of whether drugs were involved by subject(s) or victim(s) in a sexual assault incident
or not.
DBR49
Incident Location Code is only required when
Incident Location is "On Military Installation/Ship
(Other than academy grounds)" or "On Academy
Grounds".
SARC
DSAID
The standard valid values are:
Yes
No
Unknown
06/24/2011
Incident
18 of 36
DSAID Data Requirements v1.6.3
DRTag DRName
DR_Text
DR2.19 Weapon Used?
The indicator of whether weapon was used in a sexual assault incident or not.
Required DR_Format DBR_Tag DBR_Text
For Closure
(NG)
NG_Source
Y
Standard
List
SARC
UR Only Y
Y
Standard
List
DBR145
The standard valid values are:
Rape (Art.120)
Aggravated Sexual Assault (Art.120)
Aggravated Sexual Contact (Art.120)
Abusive Sexual Contact (Art.120)
Wrongful Sexual Contact (Art.120)
Indecent Assault (Art. 134)
Non-Consensual Sodomy (Art.125)
Attempts to Commit Offenses (Art. 80)
Unknown (NG Only)
Prosecuted by State Law (NG Only)
DR2.21 Number of subjects
System Calculated Information based upon Subject and Incident association.
DR2.22 Number of victims
System Calculated Information based upon Victim and Incident association.
DR2.23 Date Investigative Activity Opened The date that the investigative activity of a case is opened.
Type of Offense Investigated value "Indecent Assault SARC
(Art. 134)" is only applicable when Date of Incident is
prior to October, 1, 2007.
Type of Offense Investigated values "Aggravated
Sexual Assault (Art.120), Aggravated Sexual Contact
(Art.120), Abusive Sexual Contact (Art.120),
Wrongful Sexual Contact (Art.120)" are only
applicable when Date of Incident is after October, 1,
2007.
UR Only Y
UR Only Y
UR Only Y
Y
Y
N
Number
Number
Date Format DBR151
DR2.24 Investigative Activity Completed?
The indicator of whether Investigation activity of a case is completed or not.
UR Only Y
N
Standard
List
DSAID
DSAID
Date Investigative Activity Opened is only required if SARC
"Agency Conducting Investigation" is not "None".
SARC
The standard valid values are:
Yes
No
Date when the Investigative activity is completed.
UR Only Y
N
Date Format DBR50
DR2.26 Victim Witness Assistance Program The indicator of whether VWAP program information is provided to a victim by MCIO case.
UR Only Y
(VWAP) information provided?
The standard valid values are:
Yes
No
DR2.27 Gaining Investigative Agency
The Location of the new investigation office when the originating investigation office transfers the UR Only N
Location
case within the same service.
N
Standard
List
N
Free Text
DBR86
DR2.28 Initial Investigative Agency Location The location of the initial investigating Agency.
UR Only Y
N
Free Text
DBR154
DR2.29 Case transferred Between
Investigative Agencies across
Services
UR Only N
N
Standard
List
DR2.32 Country
The Valid Values are:
Yes
No
The Country where the incident took place and Incident Location Code is "Temporary Location".
Y
Y
DR2.33 City
The city where the incident took place off installation.
Y
Y
Standard
List
Standard
List
DR2.20 Type of Offense Investigated
DR2.25 Date Investigative Activity
Completed
06/24/2011
UR/R
Only
The standard valid values are:
Yes
No
Unknown
The type of offense or matter investigated and reported on ROI for a sexual assault incident by
Investigating Agency."
The indicator of whether a case that is investigated by one agency is transferred to a new
investigative agency across Services.
Incident
Required For
Closure (AF)
From "Open"
Status
Y
Date Investigative Activity Completed is only required SARC
when Investigative Activity Completed? is "Yes."
SARC
Gaining Investigative Agency Location is only
SARC
required when a Case is transferred between
Investigative agencies within Services is "Yes" and
Associated Investigative Case Number is the same
as the original Investigative Case Number.
The Initial Investigative Agency Location is only
SARC
required if "Investigative Case File Opened" is "Yes".
DSAID
DBR118
DBR120
Country is only required when Incident Location
Code is "Temporary Location".
City is only required only Incident Location is "Off
Military Installation/Ship/Academy Grounds".
SARC
SARC
19 of 36
DSAID Data Requirements v1.6.3
DRTag DRName
DR_Text
DR2.34 State/Country
The state (for US only) or the country where the incident took place off installation.
06/24/2011
UR/R
Only
Incident
Required For
Closure (AF)
From "Open"
Status
Y
Required DR_Format DBR_Tag DBR_Text
For Closure
(NG)
Y
Standard
List
DBR121
NG_Source
State/Country is only required only Incident Location SARC
is "Off Military Installation/Ship/Academy Grounds".
20 of 36
DSAID Data Requirements v1.6.3
DRTag DRName
DR_Text
UR/R
Only
DR3.1
Subject Last Name
UR Only
DR3.2
Subject First Name
DR3.3
Subject Middle Name
DR3.4
Subject Identification Type
The Last Name of a subject involved in a sexual assault
incident.
The First Name of a subject involved in a sexual assault
incident.
The Middle Name of a subject involved in a sexual assault
incident.
The type of identification number that a subject provides when
investigated by a sexual assault incident.
DR3.5
The standard valid values are:
SSN
Alien Registration
Foreign Country Identification Card Number
Non-Existent/Unknown
Subject Identification Number
The identification number of a subject based upon the
identification type that a subject provides.
Subject Birth Date
The Birth Date of a subject involved in a sexual assault
incident.
Subject Age at the Time of Incident The age of a subject when the sexual assault incident
occurred.
DR3.6
DR3.7
DR3.8
Subject Gender
The valid values are:
(DIBRS July 2003)
Number (0-99)
Unknown
The gender of a subject involved in a sexual assault incident.
Required For
Required
Closure (AF) From For
"Open" Status
Closure
(NG)
Y only if Subject is N
known
Y only if Subject is N
known
Y only if Subject is N
known
Y only if Subject is N
known
DR_Format DBR_Tag DBR_Text
NG_Source
Free Text
SARC
Free Text
SARC
Free Text
SARC
Standard List
SARC
Y only if Subject is
known
Y only if Subject is
known
Y only if Subject is
known
N
Number
N
Date Format
N
Free Text
UR Only
Y only if Subject is
known
N
Standard List
SARC
UR Only
Y only if Subject is
known
N
Standard List
SARC
UR Only
UR Only
UR Only
UR Only
UR Only
UR Only
DBR51
If SSN is selected, the format of Identification number SARC
follows NNN-NN-NNNN.
SARC
DBR52
Subject Age at the Time of Incident has to be between SARC
number 0 and 99.
The standard valid values are:
Male
Female
Unknown
DR3.9
Subject Race
The race of a subject involved in a sexual assault incident.
The standard valid values are:
(DIBRS July 2003)
American Indian
Asian/Pacific Islander
Black
White
Mixed
Unknown
06/24/2011
Subject Demographic
21 of 36
DSAID Data Requirements v1.6.3
DRTag DRName
DR_Text
UR/R
Only
DR3.10 Subject Ethnicity
The ethnicity of a subject involved in a sexual assault incident. UR Only
Required For
Required DR_Format DBR_Tag DBR_Text
Closure (AF) From For
"Open" Status
Closure
(NG)
Y only if Subject is N
Standard List
known
NG_Source
Y only if Subject is
known
SARC
SARC
The standard valid values are:
(DIBRS July 2003)
Hispanic
Not Hispanic
Unknown
DR3.11 Subject Type
The type of a subject involved in a sexual assault incident
indicating whether the subject is military or any type of
civilians.
UR Only
N
Standard List
The standard valid values are:
Military
DoD Civilian
DoD Contractor
Other Government Civilian
US Civilian
Foreign National
Foreign Military
Unknown
06/24/2011
Subject Demographic
22 of 36
DSAID Data Requirements v1.6.3
DRTag DRName
DR_Text
UR/R
Only
DR3.12 Subject Affiliation
The military service or DoD agency that a subject is affiliated
with based upon the Subject Type.
The respective service for a Military Service Academy (MSA)
and National Guard subject should be used for this data
element.
UR Only
DR3.13 Subject Pay Grade
The standard valid values are:
Army
Navy
Air Force
Marine Corps
Coast Guard
DARPA
DCM
DCAA
DCMA
DFAS
DISA
DIA
DLSA
DLA
DSCA
DSS
DTRA
MDA
NIMA
NSA/CCS
PPA
NOAA
Public
HealthPay Grade of a subject involved in a sexual
The military
assault incident and also indicates whether the subject is a
prep school student.
UR Only
Required For
Required DR_Format DBR_Tag DBR_Text
NG_Source
Closure (AF) From For
"Open" Status
Closure
(NG)
Y only if Subject is N
Standard List DBR53
If Subject Type is "Military", Only Affiliations applicable SARC
known
are service related.
If Subject Type is "DoD Civilian", All Affiliations are
applicable.
Other Subject Types will not have Subject Affiliation.
Y only if Subject is
known
N
Standard List DBR54
Subject Pay Grade will only be required when Subject SARC
Type is "Military".
The standard valid values are:
E-1 through E-9
W-1 through W-5
O-1 through O-10
C-1 through C-4 (for Cadet)
M-1 through M-4 (for Midshipman)
Prep School Student
Note: Each value should be listed separately as valid values
for user to select.
06/24/2011
Subject Demographic
23 of 36
DSAID Data Requirements v1.6.3
DRTag DRName
DR_Text
DR3.15 Subject Pay Plan
The US Government Pay Plan of a subject involved in a sexual UR Only
assault incident when the subject is civilian and affiliated with
any DoD or US government agencies.
DR3.16 Subject Grade
The standard valid values are:
General Schedule
NSPS
Wage Grade
Non-appropriate Fund
Senior Executive Service
Other
Unknown
The US Government Grade of a subject involved in a sexual
assault incident when the subject is civilian and affiliated with
any DoD or US government agencies.
UR/R
Only
UR Only
Required For
Required DR_Format DBR_Tag DBR_Text
NG_Source
Closure (AF) From For
"Open" Status
Closure
(NG)
Y only if Subject is N
Standard List DBR55
Subject Pay Plan of a Subject is required only when SARC
known
Subject Type is "DoD Civilian" or "Other Government
Civilian".
Y only if Subject is
known
N
Standard List DBR56
Subject Grade is only captured when Subject Type is SARC
"DoD Civilian" or "Other Government Civilian".
If Subject Pay Plan is "Unknown", then Subject Grade
is defaulted to "Unknown".
The standard valid values are:
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
I
II
III
IV
V
VI
PB1
PB2
PB3
PB4
Unknown
06/24/2011
Subject Demographic
24 of 36
DSAID Data Requirements v1.6.3
DRTag DRName
DR_Text
UR/R
Only
DR3.17 Subject Duty Status
The military Duty Status of a subject. Note: For active duty
National Guard members, Duty Status should be "National
Guard" instead of "Active Duty".
UR Only
DR3.18 Subject National Guard Service
DR3.19 Subject NG State Affiliation
DR3.20 Subject NG Title 10 Category
DR3.21 Subject NG Title 32 Category
DR3.23 Subject Assigned Location Code
06/24/2011
The standard valid values are:
Active Duty
Reserve
National Guard
The National Guard Service category of a subject involved in a UR Only
sexual assault incident.
The standard valid values are:
Title 10
Title 32
State
The state of a National Guard as a subject involved in a sexual UR Only
assault incident.
The standard valid values are:
50 States
District of Columbia
Puerto Rico
Guam
Virgin Islands
Note: 50 states shall be listed separately as valid values for
user to choose.
A subcategory that further defines a National Guard Service as UR Only
a subject of a sexual assault incident when the person's
National Guard Service is "Title 10".
The standard valid values are:
Active Guard and Reserve (AGR)
Annual Training (OCONUS)
Active Duty Operational Support (ADOS) 30+ days
ADOS less than 30 days
A subcategory that further defines a National Guard Service as UR Only
a subject of a sexual assault incident when the person's
National Guard Service is "Title 32".
The standard valid values are:
Active Duty Operational Support (ADOS) 30+ days
Active Guard and Reserve (AGR)
Annual Training
Inactive Duty for Training (Traditional Drilling Status)
Full time National Guard Duty
Not in Duty Status
DSAID Location Code of a permanent duty station that a
subject is physically assigned to.
UR Only
Required For
Required DR_Format DBR_Tag DBR_Text
Closure (AF) From For
"Open" Status
Closure
(NG)
Y only if Subject is N
Standard List DBR57
Subject Duty Status is only required when Subject
known
Type is "Military".
NG_Source
SARC
Y only if Subject is
known
N
Standard List DBR58
Subject National Guard Service is only required when SARC
Subject Duty Status is "National Guard".
N
N
Standard List DBR59
Subject NG State Affiliation is only required when
Subject Duty Status is "National Guard".
SARC
Y only if Subject is
known
N
Standard List DBR60
Subject NG Title 10 Category is only required when
Subject National Guard Service is "Title 10".
SARC
N
N
Standard List DBR61
Subject NG Title 32 Category is only required when
Subject National Guard Service is "Title 32".
SARC
Y only if Subject is
known
N
Standard List DBR126
Subject Assigned Location Code is only required when SARC
the Subject Type is "Military", "DoD Civilian", "DoD
Contractor" or "Other Government Civilian.
Subject Demographic
25 of 36
DSAID Data Requirements v1.6.3
DRTag DRName
DR_Text
UR/R
Only
DR3.24 Subject Assigned Location Name
The DSAID Location Description of the installation based on
the subject's Assigned Location Code entered by SARC or
through search Location Code function.
The Unit Identification Code (UIC) of an unit that subject is
affiliated with the service.
UR Only
DR3.26 Subject Assigned Unit Name
The Unit Name for the Subject's Assigned Unit UIC.
UR Only
DR3.27 Subject Dependent Status
The indicator of whether a subject involved in a sexual assault UR Only
incident is a military dependent or not.
DR3.25 Subject Assigned Unit UIC
UR Only
The standard valid values are:
Yes
No
DR3.28 NG Subject Recruit/Training Status The indicator of whether a subject involved in a sexual assault UR Only
incident is in Recruit /Training status or not.
Required For
Required DR_Format DBR_Tag DBR_Text
Closure (AF) From For
"Open" Status
Closure
(NG)
Y only if Subject is N
Text
DBR127 Subject Assigned Location Name is only required
known
when the Subject Type is "Military","DoD Civilian",
"DoD Contractor" or "Other Government Civilian.
Y only if Subject is N
Free Text
DBR128 Subject Assigned Unit UIC is only required when the
known
Subject Type is "Military", "DoD Civilian", "DoD
Contractor" or "Other Government Civilian.
Y only if Subject is N
Free Text
DBR129 Subject Assigned Unit Name is only required when the
known
Subject Type is "Military", "DoD Civilian", "DoD
Contractor" or "Other Government Civilian.
Y only if Subject is N
Standard List
known
The Duty Assignment of a subject involved in a sexual assault UR Only
incident. This element is to reflect the position of power of the
Subject.
The standard valid values are:
Recruiter
Instructor
Drill Sergeant
Drill Instructor
N/A
DR3.30 Subject Type for Restricted Reports The type of subject who is reported by victim as involved in a
sexual assault incident. It is for restricted report only and is
indicated for each subject in the incident.
DR3.31 Subject NG State Status
R Only
The standard valid values are:
Military
Non Military
Unknown
Subject NG State Status indicates whether the NG member is UR Only
in state active duty under Governor Control.
DSAID
SARC
SARC
SARC
N
N
Standard List DBR63
NG Subject Recruit/Training Status is only required
SARC
when Duty Status of a subject is "National Guard",
National Guard Service is "Title 32" or "State" and
Subject Recruit/Training Status of the victim is "Yes".
Y only if Subject is
known
N
Standard List DBR82
Subject Duty Assignment is only required when
Subject Type is "Military".
SARC
Y
N
Standard List DBR64
Subject Type for Restricted Reports is only required
when Subject Report Type is "Restricted".
SARC
N
Y
Standard List DBR89
Subject NG State Status is only required when
Subject NG Service is "State".
SARC
The standard valid values are:
NG Pre-accession recruit sustainment program (RSP)
Pre-recruit General Education Development (GED) program
Basic Training
AIT (Annual Individual Training)
DR3.29 Subject Duty Assignment
NG_Source
The valid values are:
Yes
No
06/24/2011
Subject Demographic
26 of 36
DSAID Data Requirements v1.6.3
DRTag DRName
DR_Text
Required For
Required DR_Format DBR_Tag
Closure (AF) From For
"Open" Status
Closure
(NG)
UR Only Y only if Subject is Y
Standard List
known
DBR_Text
The standard valid values are:
Yes
No
Unknown (NG only)
The date that pre-trial confinement is applied to the accused
offender.
UR Only Y only if Subject is Y
known
Date Format DBR44
Date Pre-trial Confinement of Accused Offender is only
required when Pre-trial Confinement of Accused Offender is
"Yes".
The indicator of whether DoD action is precluded for a subject
involved in a sexual assault incident.
UR Only Y only if Subject is N
known
Standard List
DR4.1 Pre-trial Confinement of The indicator of whether pre-trial confinement is applied to the
Accused Offender
accused offender or not.
DR4.2 Date Pre-trial
Confinement of
Accused Offender
DR4.3 DoD Action Precluded
DR4.4 DoD Action Precluded
Reason
DR4.5 DoD Action Precluded
Reason Date
DR4.6 Commander Action
Precluded or Declined
for Sexual Assault
DR4.7 Commander Action
DR4.8 Commander Action
Date
06/24/2011
UR/R
Only
The standard valid values are:
Yes
No
The reasons as to why DoD action is precluded for a subject
UR Only Y only if Subject is N
involved in a sexual assault incident. It may capture members that
known
have not been brought back for prosecution.
NG_Source
SARC
SARC
SARC
Standard List DBR65
DoD Action Precluded Reason is only required When DoD
Action Precluded is "Yes".
SARC
DoD Action Precluded Reason Date is only required when DoD SARC
Action Precluded is "Yes".
If DoD Action Precluded Reason is "Unknown Subject", then
the date must be defaulted to Date Investigation Activity
Completed.
Command Action Precluded or Declined for Sexual Assault is SARC
only required when DoD Action Precluded is "No".
The standard valid values are:
Civilian/Foreign Authority - Person Subject to UCMJ
Civilian/Foreign Authority - Person Not Subject to UCMJ
Unknown Subject
Unfounded by Investigative Agency
The date when the decision for DoD Action Precluded was made
and the reason is identified.
UR Only Y only if Subject is N
known
Date Format DBR66
The indicator of whether Commander Action is precluded or
declined for a subject involved in a sexual assault incident.
UR Only Y only if Subject is N
known
Standard List DBR67
The standard valid values are:
Yes
No
The commander action that is taken for a subject involved in a
sexual assault incident.
UR Only Y only if Subject is N
known
Standard List DBR68
Commander Action is only required when Command Action
SARC
Precluded or Declined for Sexual Assault is "No". "Honor
Board Actions (Initiated)" is only applicable when Subject Pay
Grade is one of the following values: "C1", "C2", "C3", "C4" (for
Cadet) or "M1", "M2", "M3" or "M4" (for Midshipman)".
Date Format DBR69
Commander Action Date is only required when Command
Action Precluded or Declined for Sexual Assault is "No".
The standard valid values are:
Court-Martial Charge Preferred (Initiated)
Nonjudicial Punishment (Article 15, UCMJ)
Administrative Discharge
Other Administrative Action
Cadet Disciplinary System Action
The date when commander action is taken for a subject involved in UR Only Y only if Subject is N
a sexual assault incident.
known
Subject Disposition
SARC
27 of 36
DSAID Data Requirements v1.6.3
DRTag DRName
DR4.9 Commander Action
Precluded/Declined
Reason for Sexual
Assault
06/24/2011
DR_Text
UR/R
Only
Required For
Required DR_Format DBR_Tag
Closure (AF) From For
"Open" Status
Closure
(NG)
The reason as to why commander action for a subject involved in a UR Only Y only if Subject is N
Standard List DBR70
sexual assault incident is precluded or declined.
known
DBR_Text
NG_Source
Command Action Precluded/Declined Reason for Sexual
Assault is only required when Command Action Precluded or
Declined for Sexual Assault is "Yes".
SARC
The standard valid values are:
Probable Cause for Only Non-Sexual Assault Offense
Subject Deceased or Deserted
Victim Deceased
Victim Declined to Participate in Military Justice Action
Insufficient Evidence of Any offense
Statue of Limitations Had Expired
Unfounded
Commander Declined Action Pursuant to UCMJ Rules of CourtsMartial 306(c)(1)
Subject Disposition
28 of 36
DSAID Data Requirements v1.6.3
DRTag DRName
DR_Text
DR5.1
SARC ID
DR5.2
SARC Status
The unique DSAID identification number for a Sexual Assault Response Coordinator
(SARC).
The status of a SARC whether the person is active or inactive in the SARC role.
DR5.3
DR5.4
DR5.5
DR5.6
DR5.7
DR5.8
DR5.9
UR/R Required For
Required DR_Format DBR_Tag DBR_Text
Only Closure (AF) From For
"Open" Status
Closure
(NG)
N/A N/A
N/A
NG_Source
N/A
N/A
N/A
Standard List
SAPR PM
SARC Status Date
SARC Last Name
SARC First Name
SARC Middle Name
SARC Gender
The standard valid values are:
Active
Inactive
The date when a SARC status is updated to "Active" or "Inactive".
The Last Name of a SARC.
The First Name of a SARC.
The Middle Name of a SARC.
The gender of a SARC.
N/A
N/A
N/A
N/A
N/A
N/A
N/A
N/A
N/A
N/A
N/A
N/A
N/A
N/A
N/A
Date Format
Free Text
Free Text
Free Text
Standard List
DSAID
SAPR PM
SAPR PM
SAPR PM
SAPR PM
SARC Type
The standard valid values are:
Male
Female
The type of a person in his/her SARC Profile.
N/A
N/A
N/A
Standard List
SAPR PM
N/A
N/A
N/A
Standard List DBR71
SARC Affiliation is only required when SARC Type is
"Military", "DoD Civilian", "DoD Contractor or "NG
Technician Dual Status (NG Only)".
SAPR PM
N/A
N/A
N/A
Standard List DBR72
SARC Duty Status is only required when SARC Type is
"Military".
SAPR PM
N/A
N/A
N/A
Standard List DBR73
SARC Reserve Service is only required when SARC Duty
Status is "Reserve".
SAPR PM
SARC Affiliation
DR5.10 SARC Duty Status
DR5.11 SARC Reserve
Service
The standard valid values are:
Military
DoD Civilian
DoD Contractor
NG Technician Dual Status (NG Only)
NG Technician Non-Dual Status (NG Only)
NG Contractor (NG Only)
State Employee (NG Only)
'The military service or DoD SAPRO that a SARC is affiliated with based upon the
SARC Type.
The standard valid values are:
Army
Navy
Air Force
Marine Corps
Coast Guard
DoD SAPRO
The military Duty Status of a SARC. Note: For active duty National Guard members,
Duty Status should be "National Guard" instead of "Active Duty".
The standard valid values are:
Active Duty
Reserve
National Guard
The reserve service category of a SARC.
DSAID
The standard valid values are:
Active
Inactive
06/24/2011
SAPR Program Admin (AF NG Only)
29 of 36
DSAID Data Requirements v1.6.3
DRTag DRName
DR_Text
UR/R Required For
Required DR_Format DBR_Tag DBR_Text
Only Closure (AF) From For
"Open" Status
Closure
(NG)
N/A N/A
N/A
Standard List DBR74
SARC Pay Grade is only required when SARC Type is
"Military".
NG_Source
DR5.12 SARC Pay Grade
The military Pay Grade of a SARC.
N/A
N/A
N/A
SAPR PM
DR5.14 SARC Location Code The DSAID Location Code of a location that a Field Level SARC or a
N/A
MAJCOM/Supervisory SARC is physically assigned to or responsible for. There can be
more than one Location Code that a Field Level SARC or a MAJCOM/Supervisory
SARC is assigned to or responsible for.
N/A
N/A
Phone
Number
Standard List DBR108
DR5.15 SARC Location Name The DSAID Location Description of the location based on the Field Level SARC or
MAJCOM/Supervisory SARC's Assigned Location Code through manual entry or
through search Location Code function.
DR5.16 SARC Assigned Unit The Unit Identification Code (UIC) of an unit that a SARC is affiliated with within the
UIC
service.
DR5.17 SARC Assigned Unit The Unit Name for the SARC's Assigned Unit UIC .
Name
DR5.18 SARC Background
The indicator of whether background check is performed for a SARC or not.
Check Performed
The standard valid values are:
Yes
No
DR5.19 SARC Background
The date when the background check is performed for a SARC.
Check Date
DR5.20 Required Initial SARC The indicator of whether a SARC has completed required initial SARC training or not.
Training Completed?
The standard valid values are:
Yes
No
N/A
N/A
N/A
Text
DSAID
N/A
N/A
N/A
Free Text
SAPR PM
N/A
N/A
N/A
Free Text
SAPR PM
N/A
N/A
N/A
Standard List
SAPR PM
N/A
N/A
N/A
Date Format DBR137
N/A
N/A
N/A
Standard List
DR5.21 Required Initial SARC The date when a SARC has completed required initial SARC training.
Training Completion
Date
DR5.22 SARC
The indicator of whether a SARC has completed annual/refresher training or not.
Annual/Refresher
Training Completed? The standard valid values are:
Yes
No
DR5.23 SARC
The date when a SARC has completed required annual/refresher training.
Annual/Refresher
Training Completion
Date
DR5.24 VA ID
The unique DSAID identification number for a Victim Advocate (VA).
DR5.25 VA Status
The status of a VA whether the person is active or inactive in the VA role.
N/A
N/A
N/A
Date Format DBR138
N/A
N/A
N/A
Standard List
N/A
N/A
N/A
Date Format DBR139
N/A
N/A
N/A
N/A
N/A
N/A
Standard List
The standard valid values are:
E-1 thru E-9
W-1 thru W-5
O-1 thru O-10
Note: Each value should be listed separately as valid values for user to select.
DR5.13 SARC Phone Number The Phone Number for SARC office at an installation.
SAPR PM
If a user manually enters the Location Code, it must be one SAPR PM
of the Location Codes maintained in DSAID.
There can be more than one Location Code associated with
a Field Level SARC or a MAJCOM/Supervisory SARC.
SARC Background Check Date is only required when
SARC Background Check Performed is "Yes".
SAPR PM
SAPR PM
Required SARC Training Completion Date is only required SAPR PM
when Required SARC Training Completed? is "Yes".
SAPR PM
SARC Annual/Refresher Training Completion Date is only
required when SARC Annual/Refresher Training
Completed? is "Yes" for each instance.
SAPR PM
DSAID
DSAID
The standard valid values are:
Active
Inactive
06/24/2011
SAPR Program Admin (AF NG Only)
30 of 36
DSAID Data Requirements v1.6.3
DRTag DRName
DR_Text
DR_Format DBR_Tag DBR_Text
NG_Source
The date when a VA status is updated to "Active" or "Inactive".
The Last Name of a VA.
The First Name of a VA.
The Middle Name of a VA.
The Gender of a VA.
UR/R Required For
Required
Only Closure (AF) From For
"Open" Status
Closure
(NG)
N/A N/A
N/A
N/A N/A
N/A
N/A N/A
N/A
N/A N/A
N/A
N/A N/A
N/A
DR5.26
DR5.27
DR5.28
DR5.29
DR5.30
Date Format
Free Text
Free Text
Free Text
Standard List
DSAID
SARC
SARC
SARC
SARC
DR5.31 VA Type
The standard valid values are:
Male
Female
The type of a VA indicating whether the VA is military or DoD civilians/contractors.
N/A
N/A
N/A
Standard List
SARC
DR5.32 VA Affiliation
The standard valid values are:
Military
DoD Civilian
DoD Contractor
The military service that a VA is affiliated with based upon the VA Type.
N/A
N/A
N/A
Standard List DBR75
If VA Type is "Military", Only Affiliations applicable are
SARC
Service related.
If VA Type is "DoD Civilian", all Affiliations are applicable.
If VA Type is "DoD Contractor", Affiliation is not applicable.
N/A
N/A
N/A
Standard List DBR76
VA Duty Status is only required when VA Type is "Military". SARC
The standard valid values are:
Active Duty
Reserve
National Guard
The National Guard Service category of a VA .
N/A
N/A
N/A
Standard List DBR77
VA National Guard Service is only required when VA Duty
Status is "National Guard".
SARC
DR5.35 VA Reserve Service
The standard valid values are:
Title 10
Title 32
State
The reserve service category of a VA.
N/A
N/A
N/A
Standard List DBR78
Victim Reserve Service is only required when Victim Duty
Status is "Reserve".
SARC
DR5.36 VA Pay grade
The standard valid values are:
Active
Inactive
The military Pay Grade of a VA.
N/A
N/A
N/A
Standard List DBR79
VA Pay Grade is only required when VA Type is "Military".
SARC
VA Status Date
VA Last Name
VA First Name
VA Middle Name
VA Gender
DR5.33 VA Duty Status
DR5.34 VA National Guard
Service
The standard valid values are:
Army
Navy
Air Force
Marine Corps
Coast Guard
The military Duty Status of a VA. Note: For active duty National Guard members, Duty
Status should be "National Guard" instead of "Active Duty".
The standard valid values are:
E-1 thru E-9
W-1 thru W-5
O-1 thru O-10
C-1 thru C-4 (for Cadet)
M-1 thru M-4 (for Midshipman)
Note: Each value should be listed separately as valid values for user to select.
06/24/2011
SAPR Program Admin (AF NG Only)
31 of 36
DSAID Data Requirements v1.6.3
DRTag DRName
DR_Text
DR5.37 VA is Volunteer?
The indicator of whether a VA is a volunteer or not.
UR/R Required For
Required DR_Format DBR_Tag DBR_Text
Only Closure (AF) From For
"Open" Status
Closure
(NG)
N/A N/A
N/A
Standard List
DR5.38 VA Location Code
The standard valid values are:
Yes
No
The DSAID Location Code of a location that a VA is physically assigned to.
N/A
N/A
N/A
Standard List DBR109
The DSAID Location Description of the location based on the VA's Assigned Location N/A
Code through manual entry or through search Location Code function.
DR5.40 VA Assigned Unit UIC The Unit Identification Code (UIC) of a unit that a VA is affiliated with within the service. N/A
N/A
N/A
Text
N/A
N/A
Free Text
SARC
DR5.41 VA Assigned Unit
Name
DR5.42 VA Phone Number
The Unit Name for the VA's Assigned Unit UIC .
N/A
N/A
N/A
Free Text
SARC
The office phone number of a VA.
N/A
N/A
N/A
SARC
DR5.43 VA Cell Number
The cell phone number of a VA.
N/A
N/A
N/A
DR5.44 VA Background Check The indicator of whether background check is performed for a VA or not.
Performed
The standard valid values are:
Yes
No
DR5.45 VA Background Check The date when the background check is performed for a VA.
Date
DR5.46 Required VA Training The indicator of whether a VA has completed required VA training or not.
Completed?
The standard valid values are:
Yes
No
DR5.47 Required VA Training The date when a VA has completed required VA training.
Completion Date
N/A
N/A
N/A
Phone
Number
Phone
Number
Standard List
N/A
N/A
N/A
Date Format DBR140
N/A
N/A
N/A
Standard List
N/A
N/A
N/A
Date Format DBR141
DR5.48 VA Annual/Refresher The indicator of whether a VA has completed annual/refresher training or not.
Training Completed?
The standard valid values are:
Yes
No
DR5.49 VA Annual/Refresher The date when a VA has completed required annual/refresher training.
Training Completion
Date
DR5.50 Meeting Minutes ID
The unique DSAID identification number for a meeting minutes.
DR5.51 Meeting Date
The date of a case review board meeting for a DSAID victim incident.
DR5.52 Meeting Attendance The attendance of a case review board meeting for a DSAID victim incident.
DR5.53 Meeting Minutes
The minutes of a case review board meeting for a DSAID victim incident.
DR5.54 Provider ID
The unique DSAID identification number for an off-base provider that has a
Memorandum of Understanding (MOU) with the military service regarding sexual
assault incident victim support.
DR5.55 Provider Organization The name of the organization for a provider.
N/A
N/A
N/A
Standard List
N/A
N/A
N/A
Date Format DBR142
N/A
N/A
N/A
N/A
N/A
N/A
N/A
N/A
N/A
N/A
N/A
N/A
N/A
N/A
N/A
Date Format
Free Text
Free Text
DSAID
SARC
SARC
SARC
DSAID
N/A
N/A
N/A
Free Text
SARC
DR5.56 Type of Service
N/A
N/A
N/A
Free Text
SARC
DR5.39 VA Location Name
06/24/2011
The type of service that the organization provides.
SAPR Program Admin (AF NG Only)
NG_Source
SARC
If a user manually enters a Location Code, it must be one of SARC
the Location Codes maintained in DSAID.
DSAID
SARC
SARC
VA Background Check Date is only required when VA
Background Check Performed is "Yes".
SARC
SARC
Required VA Training Completion Date is only required
when Required VA Training Completed? is "Yes".
SARC
SARC
VA Annual/Refresher Training Completion Date is only
required when VA Annual/Refresher Training Completed?
for each instance.
SARC
32 of 36
DSAID Data Requirements v1.6.3
DRTag DRName
DR_Text
UR/R Required For
Required DR_Format DBR_Tag DBR_Text
Only Closure (AF) From For
"Open" Status
Closure
(NG)
N/A N/A
N/A
Standard List
NG_Source
DR5.57 MOU in place?
The indicator of whether a provider has MOU in place with military services regarding
sexual assault incident victim support.
DR5.58 MOU Date
The standard valid values are:
Yes
No
The date when the MOU is recorded.
N/A
N/A
N/A
Date Format DBR143
MOU Date is only required when MOU in place? is "Yes".
SARC
DR5.59 MOU Status
The status of a MOU whether it is active or not.
N/A
N/A
N/A
Standard List DBR144
MOU Status is only required when MOU in place? is "Yes". SARC
The standard valid values are:
Active
Inactive
The unique DSAID identification number for a SAPR Program related training provided N/A
by a SARC, or any other individual or organization other than a SARC.
The name of an individual or organization who provided SAPR related training. This can N/A
be a SARC, or any other individual or organization other than a SARC.
N/A
N/A
N/A
N/A
Free Text
SARC
N/A
N/A
N/A
Standard List
SARC
N/A
N/A
N/A
Date Format
SARC
N/A
N/A
N/A
Free Text
SARC
N/A
N/A
N/A
Standard List DBR90
SARC NG State Affiliation is only required when SARC
Duty Status is "National Guard" or SARC Type is "NG
Technician Dual Status (NG Only)", "NG Technician NonDual Status (NG Only)", "NG Contractor (NG Only)" or
"State Employee (NG Only)".
SAPR PM
N/A
N/A
N/A
Standard List DBR93
VA NG State Affiliation is only required when SARC Duty
Status is "National Guard".
SAPR PM
DR5.60 SAPR Related
Training ID
DR5.61 SAPR Related
Training Provider
Name
DR5.62 SAPR Related
Training Type
DR5.63 SAPR Related
Training Date
DR5.64 SAPR Related
Training Receiving
Organization Name
DR5.65 SARC NG State
Affiliation
The type of a SAPR Program related training that a SARC, or any other individual or
organization other than a SARC provided.
The standard valid values are:
VA Training
Unit or Organization Training
Annual Training
Off-Installation Training for Community Organizations
Special Event Training
The date of a SAPR Program related training that a SARC, or any other individual or
organization other than a SARC provided.
The name of the organization that a SAPR Program related training is provided to.
SARC NG State Affiliation indicates whether the NG member is in state active duty
under Governor Control.
The Valid Values are:
50 States
District of Columbia
Puerto Rico
Guam
Virgin Islands
Note: 50 states shall be listed separately as valid values for user to choose.
DR5.66 VA NG State Affiliation VA NG State Affiliation indicates whether the NG member is instate active duty under
Governor Control.
SARC
DSAID
The valid values are:
50 States
District of Columbia
Puerto Rico
Guam
Virgin Islands
Note: 50 states shall be listed separately as valid values for user to choose.
06/24/2011
SAPR Program Admin (AF NG Only)
33 of 36
DSAID Data Requirements v1.6.3
DRTag DRName
DR_Text
UR/R
Only
Required For
Closure (AF) From
"Open" Status
Required
DR_Format
For Closure
(NG)
DR6.1
The period in a fiscal year that a Standard Reports set is run for.
N/A
N/A
N/A
Standard List DBR112
N/A
N/A
N/A
Number
N/A
Period
The valid values are:
Q1
Q2
Q3
Annual
The fiscal year that a Standard Reports set is run for. For Standard Service Reports, it
refers to military fiscal year (Oct 1 through Sept 30). For Standard Military Service
Academy Reports (MSA), it refers to academic program year (June 1 through May 31)
DBR_Tag DBR_Text
NG_Source
Quarter is only applicable when standard Service
Reports are requested.
N/A
DR6.2
Year
DR6.3
Reporting Level
The reporting level that a Standard Reports set is run for.
N/A
N/A
N/A
Standard List
N/A
DR6.4
Combat Zones Fiscal Year
The valid values are:
Service Report - DoD wide
Service Report - ARMY
Service Report - NAVY
Service Report - Marine Corps
Service Report - Air Force
Service Report - National Guard
MSA Report - DoD wide
MSA Report - ARMY
MSA Report - NAVY
MSA Report - Air Force
The military fiscal year that DoD SAPRO Analyst defines the countries of combat zone for. N/A
N/A
N/A
Number
N/A
DR6.5
DR6.6
Run Date and Time
End Strength Fiscal Year
N/A
N/A
N/A
N/A
N/A
N/A
Date Format
Number
N/A
N/A
N/A
N/A
N/A
Number
N/A
N/A
N/A
N/A
N/A
N/A
N/A
Number
Number
N/A
N/A
N/A
N/A
N/A
Number
N/A
Run Date and Time that a standard reports set is prescheduled or was created.
The military fiscal year for which the End Strength data is entered by DoD SAPRO
Analyst.
DR6.7 End Strength Data by Service Affiliation End Strength data that is categorized into: Army, Navy, Air Force, Marine Corps and
National Guard.
DR6.8 End Strength Data by Gender
Gender for End Strength data is categorized into Male and Female.
DR6.9 End Strength Data by Age Range
Age Range for End Strength data shall be categorized into ranges between number 0 and
99 as follows:
16-19
20-24
25-34
35-49
50-64
65 and older
DR6.10 End Strength Data by Pay Grade
Pay Grade Range for End Strength data shall be categorized into:
Range
E-1 thru E-9
W-1 thru W-5
O-1 thru O-10
C-1 thru C-4 (for Cadet)
M-1 thru M-4 (for Midshipman)
06/24/2011
DOD Reporting
34 of 36
DSAID Data Requirements v1.6.3
DRTag
DRName
DR_Text
UR/R
Only
Required For
Required DR_Format DBR_Tag DBR_Text
Closure (AF) From For
"Open" Status
Closure
(NG)
N/A
N/A
Standard List
NG_Source
DR27.1
Requestor Role
The permission role name for each user requesting access to DSAID. Each role has permission N/A
control enforced by DSAID based upon the functional accessibility business rules.
N/A
N/A
N/A
Standard List
DSAID
N/A
The standard values are:
SARC
MAJCOM/Supervisory SARC
Service SAPR Program Manager
Service System Manager
SAPRO Analyst
DR27.2
Requestor Status
DR27.3
N/A
N/A
N/A
Date Format
DSAID
DR27.4
DR27.5
DR27.6
The standard valid values are:
Pending Approval
Disapproved
Approved
Requestor Status Date The date when a requestor status is initially set and updated. All the dates for user account
status history are captured by DSAID.
Requestor Last Name The Last Name of a requestor.
Requestor First Name The First Name of a requestor.
Requestor Middle Name The Middle Name of a requestor.
N/A
N/A
N/A
N/A
N/A
N/A
N/A
N/A
N/A
Free Text
Free Text
Free Text
N/A
N/A
N/A
DR27.7
Requestor Gender
The gender of a requestor.
N/A
N/A
N/A
Standard List
N/A
Requestor Type
The standard valid values are:
Male
Female
The type of a person in his/her Requester Profile.
N/A
N/A
N/A
Standard List
N/A
N/A
N/A
Standard List DBR146
Requestor Affiliation is only required when Requestor Type is "Military",
"DoD Civilian", "DoD Contractor or "NG Technician Dual Status (NG
Only)".
N/A
N/A
N/A
Standard List DBR147
Requestor Duty Status is only required when Requestor Type is
"Military".
N/A
DR27.8
DR27.9
Requestor Affiliation
The status of a requestor whether the requested user registration is approved or not.
The standard valid values are:
Military
DoD Civilian
DoD Contractor
NG Technician Dual Status (NG Only)
NG Technician Non-Dual Status (NG Only)
NG Contractor (NG Only)
State Employee (NG Only)
The military service or DoD SAPRO that a requestor is affiliated with based upon the Requestor N/A
Type.
The standard valid values are:
Army
Navy
Air Force
Marine Corps
Coast Guard
DoD SAPRO
DR27.10 Requestor Duty Status The military Duty Status of a Requestor. Note: For active duty National Guard members, Duty
Status should be "National Guard" instead of "Active Duty".
N/A
The standard valid values are:
Active Duty
Reserve
National Guard
06/24/2011
User Account
35 of 36
DSAID Data Requirements v1.6.3
DRTag
DRName
DR27.11 Requestor NG State
Affiliation
DR27.12 Requestor Reserve
Service
DR27.13 Requestor Pay Grade
DR27.14 Requestor Phone
Number
DR27.15 Requestor Assigned
Unit UIC
DR27.16 Requestor Assigned
Unit Name
06/24/2011
DR_Text
UR/R
Only
Requestor NG State Affiliation indicates whether the National Guard member is in state active
duty under Governor Control.
N/A
Required For
Required DR_Format DBR_Tag DBR_Text
Closure (AF) From For
"Open" Status
Closure
(NG)
N/A
N/A
Standard List DBR148 Requestor NG State Affiliation is only required when Requestor Duty
Status is "National Guard" or, Requestor Type is "NG Technician Dual
Status (NG Only)", "NG Technician Non-Dual Status (NG Only)", "NG
Contractor (NG Only)" or "State Employee (NG Only)".
NG_Source
N/A
The Valid Values are:
50 States
District of Columbia
Puerto Rico
Guam
Virgin Islands
Note: 50 states shall be listed separately as valid values for user to choose.
The reserve service category of a requestor.
N/A
N/A
N/A
Standard List DBR149
Requestor Reserve Service is only required when Requestor Duty Status N/A
is "Reserve".
The standard valid values are:
Active
Inactive
The military Pay Grade of a requestor.
N/A
N/A
N/A
Standard List DBR150
Requestor Pay Grade is only required when Requestor Type is "Military". N/A
The standard valid values are:
E-1 thru E-9
W-1 thru W-5
O-1 thru O-10
Note: Each value should be listed separately as valid values for user to select.
The Phone Number for a requestor during normal business hours.
N/A
N/A
N/A
Free Text
N/A
The Unit Identification Code (UIC) of a unit that a requestor is affiliated with within the service.
N/A
N/A
N/A
Free Text
N/A
The Unit Name for the requestor's Assigned Unit UIC .
N/A
N/A
N/A
Free Text
N/A
User Account
36 of 36
| File Type | application/pdf |
| Author | Wang, Katherine [USA] |
| File Modified | 2011-09-16 |
| File Created | 2011-09-16 |