Defense Sexual Assault Incident Database

Upload Air Force I2MS Interface Data

DSAID Use Case Specification
Version 1.6.3

Table of Contents
1

Description

3

2

Actors

3

3

Pre-Conditions

3

4

Triggers

3

5

Basic Flow – Upload Air Force Subject and Incident Information

3

6

Alternative Flows

9

7

Exception Flows

9

8

Post Conditions

9

9

Extension Points

9

10 Special Requirements

9

11 Activity Diagram

9

12 References

10

Upload Air Force I2MS Interface Data
1

Description

This use case describes how the Defense Sexual Assault Incident Database (DSAID)
sends a outbound file and uploads victim, subject and incident data from the Air Force
Office of Special Investigations (AF OSI) Investigative Information Management System
(I2MS) based on the Investigative Case Number, Victim Identification Type and Victim
Identification Number entered by a Sexual Assault Response Coordinator (SARC) in
DSAID. Both the DSAID and I2MS outbound and inbound interface files are in flat text
file format and transmitted via Secure File Transmission Protocol (FTP).

2

Actors

DSAID

3

Pre-Conditions

UC5.1.1 Victim Case Profile (DSAID case), Victim Identification Type, Victim
Identification Number and Investigative Case Number are available in DSAID.
UC5.1.2 Status of at least one Victim Case Profile in DSAID that is associated to the
Investigative Case Number has to be in open status

4

Triggers

UC5.2.1Investigative Case Number is entered by SARC in DSAID for initial load.

5

Basic Flow – Upload Air Force Subject and Incident Information

UC5.3.1 The use case begins when DSAID sends the list of Investigative Case Numbers
to I2MS.
SYS175 The system shall send a list of Investigative Case Numbers to I2MS
when Agency Conducting Investigation is "AF OSI".
DR2.4 Investigative Case Number
DBR47 Investigative Case Number is only required when
Investigative Case File Opened? is "Yes".
DR2.8 Agency Conducting Investigation
SYS176 The system shall only send the Investigative Case Numbers when at least
one of the victim profiles associated with the incident is in "Open" or "Open With
Limited Information" status.
UC5.3.2 The Air Force system sends the victim, subject and incident data to DSAID
based upon the Investigative Case Numbers.

06/24/2011

Page 3 of 10

SYS177 I2MS shall send the following victim, subject and incident data to
DSAID based upon the Investigative case number.
DR1.44 Relationship to Subject
DR2.4 Investigative Case Number
DBR47 Investigative Case Number is only required when
Investigative Case File Opened? is "Yes".
DR2.9 Date of Incident
DBR153 If filled, this date must be less than or equal to Date of
Report to DoD.
DR2.10 Is Date of Incident Estimated?
DR2.11 Incident Time of Day
DR2.12 Incident Day of Week
DR2.13 Incident Location
DR2.14 Type of Location
DR2.15 Incident Location Code
DBR49 Incident Location Code is only required when Incident
Location is "On Military Installation/Ship (Other than academy
grounds)" or "On Academy Grounds".
DR2.16 Incident Location Name
DR2.17 Was alcohol involved? (Subject/Victim)
DR2.18 Were drugs involved? (Subject/Victim)
DR2.19 Weapon Used?
DR2.20 Type of Offense Investigated
DBR145 Type of Offense Investigated value "Indecent Assault
(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.
DR2.23 Date Investigative Activity Opened
DBR151 Date Investigative Activity Opened is only required if
"Agency Conducting Investigation" is not "None".
DR2.25 Date Investigative Activity Completed
DBR50 Date Investigative Activity Completed is only required
when Investigative Activity Completed? is "Yes."
DR2.26 Victim Witness Assistance Program (VWAP) information
provided?
DR2.27 Gaining Investigative Agency Location
DBR86 Gaining Investigative Agency Location is only 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.
DR2.28 Initial Investigative Agency Location
DBR154 The Initial Investigative Agency Location is only
required if "Investigative Case File Opened" is "Yes".

06/24/2011

Page 4 of 10

DR2.32 Country
DBR118 Country is only required when Incident Location Code is
"Temporary Location".
DR3.1 Subject Last Name
DR3.2 Subject First Name
DR3.3 Subject Middle Name
DR3.4 Subject Identification Type
DR3.5 Subject Identification Number
DBR51 If SSN is selected, the format of Identification number
follows NNN-NN-NNNN.
DR3.6 Subject Birth Date
DR3.8 Subject Gender
DR3.9 Subject Race
DR3.10 Subject Ethnicity
DR3.11 Subject Type
DR3.12 Subject Affiliation
DBR53 If Subject Type is "Military", Only Affiliations applicable
are Service related.
If Subject Type is "DoD Civilian", All Affiliations are applicable.
Other Subject Types will not have Subject Affiliation.
DR3.13 Subject Pay Grade
DBR54 Subject Pay Grade will only be required when Subject
Type is "Military".
DR3.16 Subject Grade
DBR56 Subject Grade is only captured when Subject Type is
"DoD Civilian" or "Other Government Civilian".
If Subject Pay Plan is "Unknown", then Subject Grade is defaulted
to "Unknown".
DR3.17 Subject Duty Status
DBR57 Subject Duty Status is only required when Subject Type is
"Military".
DR3.20 Subject NG Title 10 Category
DBR60 Subject NG Title 10 Category is only required when
Subject National Guard Service is "Title 10".
DR3.23 Subject Assigned Location Code
DBR126 Subject Assigned Location Code is only required when
the Subject Type is "Military", "DoD Civilian", "DoD Contractor"
or "Other Government Civilian.
DR3.24 Subject Assigned Location Name
DBR127 Subject Assigned Location Name is only required when
the Subject Type is "Military","DoD Civilian", "DoD Contractor"
or "Other Government Civilian.
DR3.25 Subject Assigned Unit UIC
DBR128 Subject Assigned Unit UIC is only required when the
Subject Type is "Military", "DoD Civilian", "DoD Contractor" or
"Other Government Civilian.

06/24/2011

Page 5 of 10

DR3.26 Subject Assigned Unit Name
DBR129 Subject Assigned Unit Name is only required when the
Subject Type is "Military", "DoD Civilian", "DoD Contractor" or
"Other Government Civilian.
DR3.27 Subject Dependent Status
DR3.29 Subject Duty Assignment
DBR82 Subject Duty Assignment is only required when Subject
Type is "Military".
SYS462 I2MS shall send the Victim Identification Type and Victim Identification
Number for each victim record.
UC5.3.3 DSAID validates victim, subject and incident data
SYS178 The system shall validate the victim, subject and incident data sent by the
Air Force systems before it is uploaded into DSAID.
UC5.3.4 If validation rules are met then, DSAID uploads Air Force victim, subject and
incident data based on the investigative case number, Victim Identification Type and
Victim Identification Number, populates all necessary victim, subject and incident data
from I2MS based upon the interface files from Air Force and saves the information in
DSAID.
Otherwise, DSAID requests correct victim, incident and subject data from I2MS.
SYS180 If the data sent by I2MS passes the validation rules in DSAID, the
system shall upload the victim, subject and incident data.
SYS186 The system shall upload the following victim, subject and incident data
from I2MS interface file only for unrestricted DSAID cases with "Open" or
"Open With Limited Information" status.
DR1.44 Relationship to Subject
DR2.4 Investigative Case Number
DBR47 Investigative Case Number is only required when
Investigative Case File Opened? is "Yes".
DR2.9 Date of Incident
DBR153 If filled, this date must be less than or equal to Date of
Report to DoD.
DR2.10 Is Date of Incident Estimated?
DR2.11 Incident Time of Day
DR2.12 Incident Day of Week
DR2.13 Incident Location
DR2.14 Type of Location
DR2.15 Incident Location Code
DBR49 Incident Location Code is only required when Incident
Location is "On Military Installation/Ship (Other than academy
grounds)" or "On Academy Grounds".
DR2.16 Incident Location Name
DR2.17 Was alcohol involved? (Subject/Victim)
DR2.18 Were drugs involved? (Subject/Victim)

06/24/2011

Page 6 of 10

DR2.19 Weapon Used?
DR2.20 Type of Offense Investigated
DBR145 Type of Offense Investigated value "Indecent Assault
(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.
DR2.23 Date Investigative Activity Opened
DBR151 Date Investigative Activity Opened is only required if
"Agency Conducting Investigation" is not "None".
DR2.25 Date Investigative Activity Completed
DBR50 Date Investigative Activity Completed is only required
when Investigative Activity Completed? is "Yes."
DR2.26 Victim Witness Assistance Program (VWAP) information
provided?
DR2.27 Gaining Investigative Agency Location
DBR86 Gaining Investigative Agency Location is only 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.
DR2.28 Initial Investigative Agency Location
DBR154 The Initial Investigative Agency Location is only
required if "Investigative Case File Opened" is "Yes".
DR2.32 Country
DBR118 Country is only required when Incident Location Code is
"Temporary Location".
DR3.1 Subject Last Name
DR3.2 Subject First Name
DR3.3 Subject Middle Name
DR3.4 Subject Identification Type
DR3.5 Subject Identification Number
DBR51 If SSN is selected, the format of Identification number
follows NNN-NN-NNNN.
DR3.6 Subject Birth Date
DR3.8 Subject Gender
DR3.9 Subject Race
DR3.10 Subject Ethnicity
DR3.11 Subject Type
DR3.12 Subject Affiliation
DBR53 If Subject Type is "Military", Only Affiliations applicable
are Service related.
If Subject Type is "DoD Civilian", All Affiliations are applicable.
Other Subject Types will not have Subject Affiliation.
DR3.13 Subject Pay Grade

06/24/2011

Page 7 of 10

DBR54 Subject Pay Grade will only be required when Subject
Type is "Military".
DR3.16 Subject Grade
DBR56 Subject Grade is only captured when Subject Type is
"DoD Civilian" or "Other Government Civilian".
If Subject Pay Plan is "Unknown", then Subject Grade is defaulted
to "Unknown".
DR3.17 Subject Duty Status
DBR57 Subject Duty Status is only required when Subject Type is
"Military".
DR3.20 Subject NG Title 10 Category
DBR60 Subject NG Title 10 Category is only required when
Subject National Guard Service is "Title 10".
DR3.23 Subject Assigned Location Code
DBR126 Subject Assigned Location Code is only required when
the Subject Type is "Military", "DoD Civilian", "DoD Contractor"
or "Other Government Civilian.
DR3.24 Subject Assigned Location Name
DBR127 Subject Assigned Location Name is only required when
the Subject Type is "Military","DoD Civilian", "DoD Contractor"
or "Other Government Civilian.
DR3.25 Subject Assigned Unit UIC
DBR128 Subject Assigned Unit UIC is only required when the
Subject Type is "Military", "DoD Civilian", "DoD Contractor" or
"Other Government Civilian.
DR3.26 Subject Assigned Unit Name
DBR129 Subject Assigned Unit Name is only required when the
Subject Type is "Military", "DoD Civilian", "DoD Contractor" or
"Other Government Civilian.
DR3.27 Subject Dependent Status
DR3.29 Subject Duty Assignment
DBR82 Subject Duty Assignment is only required when Subject
Type is "Military".
SYS187 The system shall only upload subject and incident information for
DSAID cases based upon combination of Investigative Case Number, Victim
Identification Type and Victim Identification Number that have exact match in
DSAID.
SYS193 If there is more than one subject associated to an Investigative Case
Number, the system shall upload the information of all the subjects' involved in
the case.
SYS196 If there is more than one victim associated to an Investigative Case
Number, the system shall upload the victim, subject and incident data for all
relevant victims.
SYS198 The system shall only upload victim data based upon the combination of
Investigative Case Number, Victim Identification Type and Victim Identification
Number that has exact match in DSAID .

06/24/2011

Page 8 of 10

SYS202 The system shall save the uploaded data in DSAID.
SYS204 If the data sent by I2MS fails the validation rules in DSAID, the system
shall reject the data that failed, and request for correct victim, incident and subject
data from I2MS.
SYS405 If there is more than one subject involved in an incident, the system shall
allow uploading more than one value for "Type of Offense Investigated".
SYS406 If there is more than one subject involved in an incident, the system shall
allow uploading more than one value for "Relationship to Subject".
SYS461 The system shall overwrite the existing victim, incident and subject
information with the data received through I2MS interface.
UC5.3.5 The use case ends.

6

Alternative Flows
N/A

7

Exception Flows
N/A

8

Post Conditions
UC5.4.1 Air Force victim, subject and incident information sourced from I2MS is
uploaded into DSAID successfully.

9

Extension Points
N/A

10 Special Requirements
N/A

11 Activity Diagram

06/24/2011

Page 9 of 10

DS AID

Yes

Air Force I2MS

Send investigat iv e c ase
number to I2MS

Receive investigative case number

Receive victim, incident
and subject information

Send victim, incident and
subject information

Valid
Information?
No

Request correct victim, incident
and sub ject information
Upload victim, incident
an d s ubject information
Saves victim, incident and
subject information

12 References
REF7 DoD SAPR Data Collection & Reporting System Concept Design Report

06/24/2011

Page 10 of 10