Defense Sexual Assault Incident Database

DSAID and Air Force System Interface Data Mapping v1.6.3
DRTag

DRName

Victim Last Name
Victim First Name
Victim Middle Name
Victim Number (DSAID Control Number)

AF Source
(UR
Investigative
Agency = "AF
OSI)
SARC
SARC
SARC
DSAID

DR1.1
DR1.2
DR1.3
DR1.4

N/A
N/A
N/A
N/A

N/A
N/A
N/A
N/A

N/A
N/A
N/A
N/A

DR1.5
DR1.6
DR1.7
DR1.8
DR1.9
DR1.10
DR1.11
DR1.12
DR1.13
DR1.14
DR1.16
DR1.17
DR1.18
DR1.19
DR1.20
DR1.21
DR1.22
DR1.24
DR1.25

Victim IdentificationType
Victim Identification Number
Victim Birth Date
Victim Age at the Time of Incident
Victim Gender
Victim Race
Victim Ethnicity
Victim Type
Victim Affiliation
Victim Pay Grade
Victim Pay Plan
Victim Grade
Victim Duty Status
Victim National Guard Service
Victim NG State Affiliation
Victim NG Title 10 Category
Victim NG Title 32 Category
Victim Assigned Location Code
Victim Assigned Location Name

SARC
SARC
SARC
SARC
SARC
SARC
SARC
SARC
SARC
SARC
SARC
SARC
SARC
SARC
SARC
SARC
N/A
SARC
DSAID

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
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
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
N/A
N/A
N/A
N/A
N/A
N/A
N/A
N/A
N/A
N/A
N/A
N/A

DR1.26
DR1.27
DR1.28
DR1.29
DR1.30
DR1.31
DR1.32

Victim Assigned Unit UIC
Victim Assigned Unit Name
Victim Dependent Status
Victim Recruit/Training Status
NG Victim Recruit/Training Status
Date of Report to DoD
Report Type

SARC
SARC
SARC
SARC
SARC
SARC
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
N/A
N/A
N/A
N/A
N/A
N/A

06/24/2011

I2MS Screen/Logical
Name

I2MS - Valid Values

I2MS - Data Type/Data
Format

Victim Case Management

DSAID and I2MS Data Mapping and Translation/Analysis

DSAID will accept the value entered by the SARC.
DSAID will accept the value entered by the SARC.
DSAID will accept the value entered by the SARC.
DSAID (DoD Sexual Assault Incident Database) will generate a Unique DoD Victim
Incident Number.
DSAID will accept the value entered by the SARC.
DSAID will accept the value entered by the SARC.
DSAID will accept the value entered by the SARC.
DSAID will accept the value entered by the SARC.
DSAID will accept the value entered by the SARC.
DSAID will accept the value entered by the SARC.
DSAID will accept the value entered by the SARC.
DSAID will accept the value entered by the SARC.
DSAID will accept the value entered by the SARC.
DSAID will accept the value entered by the SARC.
DSAID will accept the value entered by the SARC.
DSAID will accept the value entered by the SARC.
DSAID will accept the value entered by the SARC.
DSAID will accept the value entered by the SARC.
DSAID will accept the value entered by the SARC.
DSAID will accept the value entered by the SARC.
N/A
DSAID will accept the value entered by the SARC.
DSAID will populate this field based upon the Victim Assigned Location Code as entered
or selected by the user.
DSAID will accept the value entered by the SARC.
DSAID will accept the value entered by the SARC.
DSAID will accept the value entered by the SARC.
DSAID will accept the value entered by the SARC.
DSAID will accept the value entered by the SARC.
DSAID will accept the value entered by the SARC.
DSAID will accept the value entered by the SARC.

1 of 15

DSAID and Air Force System Interface Data Mapping v1.6.3
DRTag

DRName

DR1.33
DR1.34
DR1.35
DR1.36
DR1.37
DR1.38
DR1.39

Date Victim Informed of Options
Date Victim Signed Election Form
Restricted Report Reason
If Other, Explain (Restricted Report Reason)
Restricted Report Exception Applied
Reason for Exception
Date Victim Signed Form Electing to Convert from
Restricted to Unrestricted
Conversion Reason if Known or Available
Victim Transferred to New SARC?
New SARC ID
New SARC Location Name
Relationship to Subject

DR1.40
DR1.41
DR1.42
DR1.43
DR1.44

DR1.45
DR1.46
DR1.47
DR1.48
DR1.49
DR1.50
DR1.51
DR1.52
DR1.53
DR1.54
DR1.55
DR1.56
DR1.57
DR1.58
DR1.59
DR1.60
DR1.61

DR1.62
DR1.63

Commander Name
Command Notification Accomplished within 24 hrs?
If No, Reason (Command Notification Accomplished
within 24 hrs?)
Incident Occurred on Deployment?
Incident Occurred on TDY?
Incident Occurred on Leave?
Was Victim in Military at Time of Assault?
Does location require mandatory reporting for
medical care for a sexual assault?
Assigned SARC Name(s)
VA assigned?
Assigned VA Name
VA Not Assigned Reason
Was Forensic Exam Offered?
If No, Reason (Was forensic exam offered?)
Forensic Exam Completed?
Location of Forensic Exam Conducted
If Forensic Exam not completed, was it because
SAFE Kit and/or other needed supplies not
available?
Date of Forensic Exam
Expiration Date of SAFE Kit
06/24/2011

AF Source
(UR
Investigative
Agency = "AF
OSI)
SARC
SARC
SARC
SARC
SARC
SARC
SARC

I2MS Screen/Logical
Name

I2MS - Valid Values

I2MS - Data Type/Data
Format

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
N/A
N/A
N/A
N/A
N/A
N/A

DSAID will accept the value entered by the SARC.
DSAID will accept the value entered by the SARC.
DSAID will accept the value entered by the SARC.
DSAID will accept the value entered by the SARC.
DSAID will accept the value entered by the SARC.
DSAID will accept the value entered by the SARC.
DSAID will accept the value entered by the SARC.

SARC
SARC
SARC
SARC
R: SARC
UR: I2MS

N/A
N/A
N/A
N/A
Relationship to
Subject

N/A
N/A
N/A
N/A
Drop Down

DSAID will accept the value entered by the SARC.
DSAID will accept the value entered by the SARC.
DSAID will accept the value entered by the SARC.
DSAID will accept the value entered by the SARC.
I2MS "Friend" maps to DSAID "Friend".
I2MS "Neighbor" maps to DSAID "Neighbor".
I2MS "Acquaintance" maps to DSAID "Acquaintance".
I2MS "Employee" maps to DSAID "Employee".
I2MS "Employer" maps to DSAID "Employer".
I2MS "Stranger" maps to DSAID "Stranger".
I2MS "Ex-Spouse" maps to DSAID "Former Spouse".
I2MS "Relationship Unknown" maps to DSAID "Relationship Unknown".
I2MS "Babysittee (the baby)" maps to DSAID "Otherwise Known".
I2MS "Boyfriend/Girlfriend" maps to DSAID "Love Interest".
I2MS "Child of Boyfriend or Girlfriend" maps to DSAID "Otherwise Known".
I2MS "Homosexual Relationship" maps to DSAID "Love Interest".
I2MS "Offender" maps to DSAID "Otherwise Known".

SARC
SARC
SARC

N/A
N/A
N/A

N/A
N/A
N/A
N/A
Acquaintance
Friend
Neighbor
Babysittee (the baby)
Boyfriend/Girlfriend
Child of Boyfriend or
Girlfriend
Homosexual Relationship
Ex-Spouse
Employee
Employer
Relationship Unknown
Stranger
Offender
N/A
N/A
N/A

N/A
N/A
N/A

DSAID will accept the value entered by the SARC.
DSAID will accept the value entered by the SARC.
DSAID will accept the value entered by the SARC.

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

DSAID will accept the value entered by the SARC.
DSAID will accept the value entered by the SARC.
DSAID will accept the value entered by the SARC.
DSAID will accept the value entered by the SARC.
DSAID will accept the value entered by the SARC.

SARC/DSAID
SARC
SARC
SARC
SARC
SARC
SARC
SARC
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
N/A
N/A
N/A

N/A
N/A
N/A
N/A
N/A
N/A
N/A
N/A
N/A

DSAID will populate the fiield or, will accept the value entered by the SARC.
DSAID will accept the value entered by the SARC.
DSAID will accept the value entered by the SARC.
DSAID will accept the value entered by the SARC.
DSAID will accept the value entered by the SARC.
DSAID will accept the value entered by the SARC.
DSAID will accept the value entered by the SARC.
DSAID will accept the value entered by the SARC.
DSAID will accept the value entered by the SARC.

SARC
SARC

N/A
N/A

N/A
N/A

N/A
N/A

DSAID will accept the value entered by the SARC.
DSAID will accept the value entered by the SARC.

Victim Case Management

DSAID and I2MS Data Mapping and Translation/Analysis

2 of 15

DSAID and Air Force System Interface Data Mapping v1.6.3
DRTag

DRName

DR1.64
DR1.65
DR1.66
DR1.67
DR1.68

Storage Location of SAFE Kit
Evidence Identifier
Victim Notified SAFE Kit Due to Expire
Date Victim Notified SAFE Kit Due to Expire
If No, Reason (Victim Notified SAFE Kit Due to
Expire)
Type of Referral Support
If Other, Explain (Type of Referral Support)
Referral Resource Type
Date of Referral
LOD Initiated?
Victim Safety Assessment Completed?
Victim Safety Concern Identified
Victim Safety Concern Note(s)
Safety Concern Note Date
Military Protective Order Offered
Military Protective Order Requested
Effective Date of Military Protective Order
Civilian Protective Order Offered
Civilian Protective Order Requested
Effective Date of Civilian Protective Order
Victim Moved (Local)
Date Victim Moved (Local)
Subject Moved (Local)
Date Subject Moved (Local)
Victim Moved (ie, PCS)
Date Victim Moved (PCS)
Subject Moved (ie, PCS)
Date Subject Moved (PCS)
Are All Referrals Completed?
Is DSAID Case Still Under Case Management
Group Review?
DSAID Case Status

DR1.69
DR1.70
DR1.71
DR1.72
DR1.73
DR1.74
DR1.75
DR1.76
DR1.77
DR1.78
DR1.79
DR1.80
DR1.81
DR1.82
DR1.83
DR1.84
DR1.85
DR1.86
DR1.87
DR1.88
DR1.89
DR1.90
DR1.91
DR1.92
DR1.93
DR1.94
DR1.95
DR1.96
DR1.97
DR1.98
DR1.99
DR1.100
DR1.101
DR1.102
DR1.103
DR1.106
DR1.107

DSAID Case Open Date
DSAID Case Close Date
Victim Informed of Right to Request Installation
Transfer
Victim Requested Installation Transfer
Victim Granted Installation Transfer
DSAID Case SARC Transfer Date
Victim NG State Status
If No, Reason (Victim Safety Assessment
Completed)
If No, Reason (LOD Initiated)
Military Protective Order Violated?
If Yes, Whom? (Military Protective Ordered
Violated)
06/24/2011

AF Source
(UR
Investigative
Agency = "AF
OSI)
SARC
SARC
SARC
SARC
SARC

I2MS Screen/Logical
Name

I2MS - Valid Values

I2MS - Data Type/Data
Format

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

DSAID will accept the value entered by the SARC.
DSAID will accept the value entered by the SARC.
DSAID will accept the value entered by the SARC.
DSAID will accept the value entered by the SARC.
DSAID will accept the value entered by the SARC.

SARC
SARC
SARC
SARC
SARC
SARC
SARC
SARC
DSAID
SARC
SARC
SARC
SARC
SARC
SARC
SARC
SARC
SARC
SARC
SARC
SARC
SARC
SARC
SARC
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
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
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
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
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

DSAID will accept the value entered by the SARC.
DSAID will accept the value entered by the SARC.
DSAID will accept the value entered by the SARC.
DSAID will accept the value entered by the SARC.
DSAID will accept the value entered by the SARC.
DSAID will accept the value entered by the SARC.
DSAID will accept the value entered by the SARC.
DSAID will accept the value entered by the SARC.
DSAID will populate the field based upon SARC data entry.
DSAID will accept the value entered by the SARC.
DSAID will accept the value entered by the SARC.
DSAID will accept the value entered by the SARC.
DSAID will accept the value entered by the SARC.
DSAID will accept the value entered by the SARC.
DSAID will accept the value entered by the SARC.
DSAID will accept the value entered by the SARC.
DSAID will accept the value entered by the SARC.
DSAID will accept the value entered by the SARC.
DSAID will accept the value entered by the SARC.
DSAID will accept the value entered by the SARC.
DSAID will accept the value entered by the SARC.
DSAID will accept the value entered by the SARC.
DSAID will accept the value entered by the SARC.
DSAID will accept the value entered by the SARC.
DSAID will accept the value entered by the SARC.

DSAID

N/A

N/A

N/A

DSAID will generate this value based on SARC action as specified in DSAID use cases .

DSAID
DSAID
SARC

N/A
N/A
N/A

N/A
N/A
N/A

N/A
N/A
N/A

DSAID will populate the field based upon SARC action.
DSAID will populate the field based upon SARC data entry.
DSAID will accept the value entered by the SARC.

SARC
SARC
DSAID
N/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

DSAID will accept the value entered by the SARC.
DSAID will accept the value entered by the SARC.
DSAID will populate the field based upon SARC data entry.
N/A
DSAID will accept the value entered by the SARC.

SARC
SARC
SARC

N/A
N/A
N/A

N/A
N/A
N/A

N/A
N/A
N/A

DSAID will accept the value entered by the SARC.
DSAID will accept the value entered by the SARC.
DSAID will accept the value entered by the SARC.

Victim Case Management

DSAID and I2MS Data Mapping and Translation/Analysis

3 of 15

DSAID and Air Force System Interface Data Mapping v1.6.3
DRTag

DRName

DR1.108

Is Victim Administratively Discharged Within one
year of Reporting?
Victim Dependent Relationship
Explanation for Open with Limited Information
Status
Referral Service Comment

DR1.109
DR1.111
DR 1.112

06/24/2011

AF Source I2MS Screen/Logical
I2MS - Valid Values
(UR
Name
Investigative
Agency = "AF
OSI)
SARC
N/A
N/A

I2MS - Data Type/Data
Format

N/A

DSAID will accept the value entered by the SARC.

SARC
SARC

N/A
N/A

N/A
N/A

N/A
N/A

DSAID will accept the value entered by the SARC.
DSAID will accept the value entered by the SARC.

SARC

N/A

N/A

N/A

DSAID will accept the value entered by the SARC.

Victim Case Management

DSAID and I2MS Data Mapping and Translation/Analysis

4 of 15

DSAID and Air Force System Interface Data Mapping v1.6.3
DRTag

DRName

DR2.1
DR2.2

Investigative Case File Opened?
If No, Reason (Investigative Case File
Opened?)
If Other, Specify (Investigative Case File SARC
Opened?)
Investigative Case Number
SARC
Case transferred between Investigative DSAID
Agencies within Services

DR2.3
DR2.4
DR2.5

AF Source I2MS Screen/Logical
I2MS - Valid Values
(UR
Name
Investigative
Agency = "AF
OSI)
SARC
N/A
N/A
SARC
N/A
N/A

I2MS - Data
Type/Data Format

DSAID and I2MS Data Mapping and Translation/Analysis

N/A
N/A

DSAID will accept the value entered by the SARC.
DSAID will accept the value entered by the SARC.

N/A

N/A

N/A

DSAID will accept the value entered by the SARC.

N/A
N/A

N/A
N/A

N/A
N/A

DSAID will accept the value entered by the SARC.
DSAID will default this field to "Yes" if "Gaining Investigative Agency Location" is populated.
Otherwise DSAID will default to "No".

Unique Installation DSAID will accept the value pushed by I2MS.
Code
Unique Installation DSAID will accept the value pushed by I2MS.
Code
N/A
DSAID will populate this field to "Yes" if "Investigative Agency Case Transfer Date" is populated.
Otherwise DSAID will default to "No".

DR2.27

Gaining Investigative Agency Location

I2MS

Installation UIC

N/A

DR2.28

Initial Investigative Agency Location

I2MS

Installation UIC

N/A

DR2.29

Case transferred Between Investigative DSAID
Agencies across Services

N/A

N/A

DR2.6
DR2.7

SARC
SARC

N/A
N/A

N/A
N/A

DR2.8
DR2.9

Associated Investigative Case Number
Investigative Agency Case Transfer
Date
Agency Conducting Investigation
Date of Incident

DR2.10

Is Date of Incident Estimated?

SARC
R: SARC
UR: I2MS
R: SARC
UR: I2MS

DR2.11

Incident Time of Day

Incident Begin Time ex 15:00

24HR

DR2.12

Incident Day of Week

N/A

N/A

N/A

DR2.13

Incident Location

R: SARC
UR: I2MS
R: SARC
UR: DSAID
R: SARC
UR: I2MS

On Uniformed
Service Installation

Yes
No
Unknown

Checkbox

N/A
N/A

DSAID will accept the value entered by the SARC.
DSAID will accept the value entered by the SARC.

N/A
N/A
Incident Begin Date N/A

N/A
Date

Is Date of Incident
Estimated?

Checkbox

DSAID will accept the value entered by the SARC.
For restricted cases, DSAID will accept the value entered by the SARC.
For unrestricted cases, DSAID will accept the value pushed by I2MS.
For restricted cases, this value has to be input by the SARC based on the victim's responses.
For unrestricted cases, I2MS needs to add this field. Confirmed 9/22/09 - I2MS will add field.
If box is checked, I2MS needs to translate to "Yes". If unchecked, I2MS needs to translate to "No".
DSAID will accept the value pushed by I2MS.
Mapping logic will be put in place to take the 24HR format and map it to the valid values for DSAID.

Yes
No

Calculation logic will be put in place to take the Date of Incident and map it to the valid values for
DSAID.
Per 09/24/10 Meeting: I2MS will not change the value of the field "On Uniformed Service Installation"
but combine with Incident Location Code, which uses the DSAID Location Code configuration file in
I2MS, to provide the mapping.
I2MS "Yes" and Incident Location Code is any code other than Military Service Academy (On
Academy Ground), maps to DSAID "On Military Installation/Ship (Other than academy grounds)".
I2MS "Yes" and Incident Location Code is any code for Military Service Academy (On Academy
Ground), maps to DSAID "On Academy Grounds".
I2MS "No" maps to DSAID "Off Military Installation/Ship/Academy Grounds".
I2MS "Unknown" maps to DSAID "Unidentified".

06/24/2011

Incident

5 of 15

DSAID and Air Force System Interface Data Mapping v1.6.3
DRTag

DRName

AF Source I2MS Screen/Logical
I2MS - Valid Values
I2MS - Data
DSAID and I2MS Data Mapping and Translation/Analysis
(UR
Name
Type/Data Format
Investigative
Agency = "AF
OSI)
R: SARC
Location of Offense Submarine
Drop Down
Per 09/24/10 Meeting: I2MS will add "Submarine" to I2MS data field Location of Offense.
UR: I2MS
Air/Bus/Train Terminal
Bank/Savings and Loan
I2MS and DSAID both have DIBRS values. 1:1 Mapping.
(includes other financial
institutions, credit union)
Bar/Night Club/Officer
Club/NCO 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)
N/A
N/A
N/A
N/A
Per 09/24/10 Meeting: When an incident occurrs at the temporary location overseas, I2MS users will
indicate "Off Installation" and therefore this field does not apply to I2MS.

DR2.14

Type of Location

DR2.32

Country

DR2.15

Incident Location Code

R: SARC
UR: I2MS

Incident Location
Code

DSAID Location Codes

Drop Down

Per 09/24/10 Meeting: For unrestricted reports: I2MS will use DSAID Location Code File to capture
Incident Location Code.
DSAID will accept the value pushed by I2MS.

DR2.16

Incident Location Name

R: DSAID
UR: DSAID

N/A

N/A

N/A

Per 09/24/10 Meeting: For unrestricted reports: DSAID will map to the corresponding Location Name
based on the Location Code pushed by I2MS.
For restricted report, DSAID will populate this field based upon the Incident Location Code as entered
or selected by the user.

06/24/2011

Incident

6 of 15

DSAID and Air Force System Interface Data Mapping v1.6.3
DRTag

DR2.17

DR2.18

DR2.19

DR2.20

DRName

AF Source I2MS Screen/Logical
I2MS - Valid Values
(UR
Name
Investigative
Agency = "AF
OSI)
Was alcohol involved? (Subject/Victim) R: SARC
Alcohol
Yes
UR: I2MS
No
Unknown
Were drugs involved? (Subject/Victim) R: SARC
Drugs
Yes
UR: I2MS
No
Unknown
Weapon Used?
R: SARC
Type of Weapon
Unarmed
UR: I2MS
Used
Firearm (type not stated)
Handgun
Rifle
Shotgun
Lethal Cutting Instrument
Club/Blackjack/Brass
Knuckles
Type of Offense Investigated
I2MS
Offense
Offense:
Offense Result
120-A
120-C
120-E
120-H
120-M
125-A
134-C1

I2MS - Data
Type/Data Format

Drop Down

1:1 Mapping

Drop Down

1:1 Mapping

Drop Down

I2MS captures the type of weapon, not a yes or no. If I2MS pushes a value that signifies a type of
weapon, DSAID will default to "Yes". If no value is sent over, DSAID will default to "No".

Drop Down

If Off_Result equals to "C":
All Offenses that start with 120-A will map to Rape (Art. 120)
All Offenses that start with 120-C will map to Aggravated Sexual Assault (Art. 120)
All Offenses that start with 120-E will map to Aggravated Sexual Contact (Art. 120)
All Offenses that start with 120-H will map to Abusive Sexual Contact (Art. 120)
All Offenses that start with 120-M will map to Wrongful Sexual Contact (Art. 120)
All Offenses that start with 120-A will map to Non-Consensual Sodomy (Art. 125)
All Offenses that start with 134-C1 will map to Indecent Assault (Art. 134)

Offense Result
A - attempted
C - completed
DR2.21
DR2.22
DR2.23

Number of subjects
Number of victims
Date Investigative Activity Opened

DSAID
DSAID
I2MS

DR2.24

Investigative Activity Completed?

DSAID

DR2.25

Date Investigative Activity Completed?

I2MS

DR2.26

Victim Witness Assistance Program
(VWAP) information provided?

I2MS

06/24/2011

DSAID and I2MS Data Mapping and Translation/Analysis

If Off_Result equals to "A":
All Offenses map to DSAID value "Attempts to Commit Offenses (Art.80)

N/A
N/A
Investigation Open
Date
N/A

N/A
N/A
N/A

N/A
N/A
Date

DSAID will count based on number of Subjects associated within an MCIO case.
DSAID will count based on number of victims associated within an MCIO case.
DSAID will accept the value pushed by I2MS.

N/A

N/A

Investigation
Complete Date
Form 2701

N/A

Date

If I2MS Investigation Complete Date is sent, DSAID will default to "Yes". Otherwise, DSAID will
default to "No".
DSAID will accept the value pushed by I2MS.

Accepted
Declined
Previously Accepted

Drop Down

Incident

I2MS "Accepted", "Declined" and "Previously Accepted" map to DSAID "Yes". If no value is sent to
DSAID, DSAID will default it to "No".

7 of 15

DSAID and Air Force System Interface Data Mapping v1.6.3
DRTag

DRName

City

AF Source I2MS Screen/Logical
I2MS - Valid Values
(UR
Name
Investigative
Agency = "AF
OSI)
I2MS
City
DSAID City/State list

DR2.33

DR2.34

Drop Down

State/Country

I2MS

Drop Down

06/24/2011

US State or
Possession
Offense
Location
Country

US 50 states and
possessions

I2MS - Data
Type/Data Format

DSAID and I2MS Data Mapping and Translation/Analysis

Per 04/15/11 Meeting: For off installation incidents, I2MS confirmed to use DSAID
City/State File for capturing City, a new field to be added in I2MS.
DSAID will accept the value pushed by I2MS.
Per 02/18/11 Meeting: For off installation incidents, I2MS currently captures states
(for US) and country where an incident took place. I2MS to provide values other
than 50 US States to DSAID to ensure 1:1 mapping.

I2MS country list
If I2MS sends value in US State or Possession and Offense Location Country is
US, then maps to DSAID US State value.
If I2MS sends value other than "US" in Offense Location Country , then maps to
DSAID Country value.

Incident

8 of 15

DSAID and Air Force System Interface Data Mapping v1.6.3
DRTag

DRName

DR3.1

Subject Last Name

AF Source (UR
I2MS
Investigative Screen/Logical
Agency = "AF
Name
OSI)
I2MS
Last Name
N/A

DR3.2

Subject First Name

I2MS

First Name

DR3.3

Subject Middle Name I2MS

DR3.4

Subject Identification
Type

DR3.5

I2MS

I2MS - Valid Values

I2MS - Data Type/Data
Format

DSAID and I2MS Data Mapping and Translation/Analysis

Characters

For identified subjects DSAID will accept the characters pushed from I2MS.
When the value of this field is "UNKNOWN", DSAID will default to "Unknown" if "Unknown" value is
available for the remaining subject demographic fields. If not, DSAID will leave blank.

N/A

Characters

DSAID will accept the value pushed from I2MS. However, this is not a required field in I2MS.

First Name

N/A

Characters

DSAID will accept the value pushed from I2MS. However, this is not a required field in I2MS.

ID TYPE

Drivers License
Passport
Social Security Number
Alien Registration Number
Foreign ID Number
Position Number
FBI Number
Other ID Number

Drop Down

I2MS captures multiple ID Types per Subject. DSAID to set priority of ID TYPES.
DSAID will map to the matching valid value in DSAID.
I2MS "Drivers License" maps to DSAID "Unknown".
I2MS "Passport" maps to DSAID "Passport Number".
I2MS "Social Security Number" maps to DSAID "SSN".
I2MS "Alien Registration Number" maps to DSAID "Alien Registration".
I2MS "Foreign ID Number" maps to DSAID "Foreign Country Identification Card Number".
I2MS "Position Number" maps to DSAID "Unknown".
I2MS "FBI Number" maps to DSAID "Unknown".
I2MS "Other ID Number" maps to DSAID "Unknown".

Subject Identification
Number
Subject Birth Date

I2MS

Number

Number

Number

DSAID will accept the values pushed by I2MS.

I2MS

Date of Birth

Date /Unknown

Date

DSAID

N/A

N/A

N/A

DR3.8

Subject Age at the
Time of Incident
Subject Gender

I2MS

Sex

Male
Female
Indeterminate

Drop Down

DSAID will populate the values that are pushed from I2MS. If no value is sent over, then DSAID will have
to accommodate for the null value.
Calculation is required based on the I2MS Incident Date and Subject Date of Birth. If the formula cannot
be completed, DSAID will default to null.
I2MS "Male" maps to DSAID "Male".
I2MS "Female" maps to DSAID "Female".
I2MS "Indeterminate" maps to DSAID "Unknown".

DR3.9

Subject Race

I2MS

Race

Drop Down

1:1 Mapping

DR3.10

Subject Ethnicity

I2MS

Ethnicity

DIBRS White
Black
American Indian/Alaskan Native
Asian/Pacific Islander
Unknown
Hispanic
Non-Hispanic

Drop Down

1:1 Mapping

DR3.6
DR3.7

06/24/2011

Subject Demographic

9 of 15

DSAID and Air Force System Interface Data Mapping v1.6.3
DRTag

DRName

DR3.11

Subject Type

AF Source (UR
I2MS
I2MS - Valid Values
Investigative Screen/Logical
Agency = "AF
Name
OSI)
I2MS
Service
Service Affiliation Valid Values:
Affiliation
Member/Employee
Contractor
Service Retiree
Service Dependent

I2MS - Data Type/Data
Format

Drop Down

DSAID and I2MS Data Mapping and Translation/Analysis

Per 09/24/10 Meeting: Member/Employee can be also mapped based upon Pay Plan. AF needs to
provide Foreign Service Affiliation and Nationality values in order to map to DSAID "Foreign Military" and
"Foreign National". Mapping below in red needs confirmation.
Per 02/18/11 Meeting: I2MS clarified and confirmed the mapping.
I2MS "Member/Employee" and Pay Plan is one of the following values: "Enlisted", "Warrant Officer",
"Commissioned officer", then maps to DSAID "Military".
I2MS "Member/Employee" and Pay Plan is one of the following values: "Execustive Schedule", "General
Schedule", "Wage Grade", "NSPS", then maps to DSAID "DoD Civilian".
I2MS "Contractor" maps to DSAID "DoD Contractor".
I2MS "Service Retiree" maps to DSAID "US Civilian".
I2MS "Service Dependent" maps to DSAID "US Civilian".
I2MS any value populated for Subject Foreign Service Affiliation, maps to DSAID "Foreign Military".
I2MS no value populated for Subject Foreign Service Affiliation and any value other than United States for
Citizenship, maps to DSAID "Foreign National".

Pay Plan Valid Values:
Enlisted
Warrant Officer
Commissioned Officer
Executive Schedule
General Schedule
Wage Grade
NSPS
Subject Foreign Service Affiliation Valid
Values:
Army
Navy
Air Force
Marine Corps
Coast Guard
DoD
NOAA
Public Health
Subject Citizenship Valid Values:
List of Countries
DR3.12

Subject Affiliation

06/24/2011

I2MS

Service

Army
Navy
Air Force
Marine Corps
Coast Guard
DoD
NOAA
Public Health

Drop Down

Per 09/24/10 Meeting: AF will need to confirm if this value will be broken into a list of DoD agencies.
Per 02/18/11 Meeting: AF will need to confirm if this value will be broken into a list of DoD agencies.
The rest of the I2MS values has 1:1 Mapping to DSAID values.

Subject Demographic

10 of 15

DSAID and Air Force System Interface Data Mapping v1.6.3
DRTag

DRName

DR3.13

Subject Pay Grade

AF Source (UR
I2MS
I2MS - Valid Values
Investigative Screen/Logical
Agency = "AF
Name
OSI)
I2MS
Pay Plan
Pay Plan Valid Values:
Pay Grade
Enlisted
Warrant Officer
Commissioned Officer
Executive Schedule
General Schedule
Wage Grade
NSPS

I2MS - Data Type/Data
Format

Drop Down

Per 09/24/10 Meeting: "Academy Prep School" value will be removed from DSAID Data Subject Pay
Grade (DR3.13) and added to DSAID Location Code File for each Academy Prep School. The Academy
Prep School related Location Code for Subject Assigned Location Code will be used to differentiate the
category of victims from other types of victims.
The following example is only applicable for the Enlisted, Warrant Officer and Commissioned Officer valid
values. Only these three I2MS values are applicable for this DSAID field.

Pay Grade Valid Values:
Grade 1
Grade 2
Grade 3
Grade 4
Grade 5
Grade 6
Grade 7
Grade 8
Grade 9
Grade 10
Grade 11
Grade 12
Grade 13
Grade 14
Grade 15
Standard Career Group Professional/Analytical Pay Schedule
Standard Career Group Technician/Support Pay Schedule
Standard Career Group Supervisor/Manager Pay Schedule
Scientific & Engineering Career Group -

06/24/2011

DSAID and I2MS Data Mapping and Translation/Analysis

Subject Demographic

Example - I2MS Pay Plan value "Enlisted" and Pay Grade Value "2" will map to DSAID Subject Pay
Grade value "E2". The "2" in this example will also be used to populate the DSAID Subject Grade
element.

11 of 15

DSAID and Air Force System Interface Data Mapping v1.6.3
DRTag

DRName

DR3.15

Subject Pay Plan

AF Source (UR
I2MS
I2MS - Valid Values
Investigative Screen/Logical
Agency = "AF
Name
OSI)
SARC
Pay Plan
Pay Plan Valid Values:
Pay Grade
Enlisted
Warrant Officer
Commissioner Officer
Cadet/Midshipman
Executive Schedule
General Schedule
Wage Grade
National Security Personnel System

I2MS - Data Type/Data
Format

Drop Down

The following example is applicable for I2MS values: Executive Schedule, General Schedule, Wage
Grade and NSPS. These are the only values that will be used to determine the DSAID Subject Pay Plan.
Example - I2MS Pay Plan value "General Schedule" and Pay Grade "Grade 12" will map to DSAID
Subject Pay Plan "General Schedule" and DSAID Subject Grade "12". The "12" in this example will also
be used to populate the DSAID Subject Grade element.
I2MS Pay Grade values with "NSPS" will be captured in DSAID only if NSPS is captured in the I2MS
Subject Pay Grade.
AF Pay Plan
1:1 Mapping for "General Schedule" and "Wage Grade".
1:1 Mapping for AF Pay Grade Values to DSAID Victim Pay Plan.

Pay Grade Valid Values:
NSPS - Standard Career Group Professional/Analytical Pay Schedule
NSPS - Standard Career Group Technician/Support Pay Schedule
NSPS - Standard Career Group Supervisor/Manager Pay Schedule
NSPS - Scientific/Engineering Career
Group - Professional Pay Schedule
NSPS - Scientific/Engineering Career
Group - Technician/Support Pay
Schedule
NSPS - Scientific/Engineering Career
Group - Supervisor/Manager Pay
Schedule
NSPS - Medical Career Group Physician/Dentist Pay Schedule
NSPS - Medical Career Group Professional Pay Schedule
NSPS - Medical Career Group Technician/Support Pay Schedule

06/24/2011

DSAID and I2MS Data Mapping and Translation/Analysis

Subject Demographic

12 of 15

DSAID and Air Force System Interface Data Mapping v1.6.3
DRTag

DRName

DR3.16

Subject Grade

AF Source (UR
I2MS
I2MS - Valid Values
Investigative Screen/Logical
Agency = "AF
Name
OSI)
I2MS
Pay Grade
I2MS Pay Grade valid values:
Pay Band
Grade 1
Grade 2
Grade 3
Grade 4
Grade 5
Grade 6
Grade 7
Grade 8
Grade 9
Grade 10
Grade 11
Grade 12
Grade 13
Grade 14
Grade 15

I2MS - Data Type/Data
Format

Drop Down

DSAID and I2MS Data Mapping and Translation/Analysis

See Subject Pay Plan.
The "Subject Grade" can be mapped in DSAID by using the I2MS values from Pay Grade and Pay Band.
Pay Grade: 1:1 Mapping.
Pay Band: PB1, PB2, PB3, PB4 has a direct mapping to the DSAID values.

DR3.17

Subject Duty Status

I2MS

Component

DR3.18

Subject National
Guard Service
Subject NG State
Affiliation
Subject NG Title 10
Category

DSAID

N/A

I2MS Pay Band valid values:
PB1
PB2
PB3
PB4
Regular
Reserve
National Guard
N/A

N/A

N/A

N/A

I2MS

Subject NG
Title 10
Category

Active Guard and Reserve (AGR)
Subject NG Title 10
Annual Training (OCONUS)
Category
Active Duty Operational Support (ADOS)
30+ days
ADOS less than 30 days

Confirmed 9/22/09 - I2MS will add the field.
DSAID will accept the value pushed by I2MS.

Subject NG Title 32
Category
Subject NG State
Status
Subject Assigned
Location Code

N/A

N/A

N/A

N/A

N/A

N/A

N/A

N/A

N/A

N/A

I2MS

Drop Down

DR3.24

Subject Assigned
Location Name

DSAID

Subject
DSAID Location Codes
Assigned
Location Code
N/A
N/A

Per 09/24/10 Meeting: For unrestricted reports: I2MS will use DSAID Location Code File to capture
Subject Assigned Location Code.
DSAID will accept the value pushed by I2MS.
Per 09/24/10 Meeting: For unrestricted reports: DSAID will map to the corresponding Location Name
based on the Subject Assigned Location Code pushed by I2MS.

DR3.25

Subject Assigned Unit I2MS
UIC

Subject Unit
UIC

Unique Installation Code DSAID will accept the value pushed from I2MS.

DR3.19
DR3.20

DR3.21
DR3.31
DR3.23

06/24/2011

N/A

Drop Down

N/A

I2MS "Regular" maps to DSAID "Active Duty".
I2MS "Reserve" maps to DSAID "Reserve".
I2MS "National Guard" maps to DSAID "National Guard".
If National Guard is selected for Subject Duty Status, DSAID will default to "Title 10".

N/A

N/A

N/A

Subject Demographic

13 of 15

DSAID and Air Force System Interface Data Mapping v1.6.3
DRTag

DR3.26
DR3.27

DR3.28

DR3.29

DR3.30

DRName

AF Source (UR
I2MS
I2MS - Valid Values
Investigative Screen/Logical
Agency = "AF
Name
OSI)
Subject Assigned Unit I2MS
Subject Unit
Name
UIC
Subject Dependent
I2MS
Service
Member/Employee
Status
Affiliation
Contractor
Service Retiree
Service Dependent
NG Subject
N/A
N/A
N/A
Recruit/Training
Status
Subject Duty
I2MS
Subject Duty Recruiter
Assignment
Assignment
Instructor
Drill Sergeant
Drill Instructor
N/A
Subject Type for
SARC
N/A
N/A
Restricted Reports

06/24/2011

I2MS - Data Type/Data
Format

DSAID and I2MS Data Mapping and Translation/Analysis

Name of Unique
Installation Code
Drop Down

DSAID will accept the value pushed from I2MS.

N/A

N/A

Subject Duty
Assignment

Confirmed 9/22/09 - I2MS will add field.

I2MS "Service Dependent" maps to DSAID to "Yes".
I2MS "Contractor", "Service Retiree" and "Member/Employee" map to DSAID "No".

DSAID will accept the value pushed from I2MS.
N/A

Subject Demographic

DSAID will accept the value entered by the SARC.

14 of 15

DSAID and Air Force System Interface Data Mapping v1.6.3
DRTag

DRName

AF Source (UR I2MS Screen/Logical Name
Investigative
Agency = "AF OSI)

DR4.3
DR4.4
DR4.5
DR4.6

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

DSAID will accept the value entered by the SARC.
DSAID will accept the value entered by the SARC.
DSAID will accept the value entered by the SARC.
DSAID will accept the value entered by the SARC.

SARC
SARC
SARC

N/A
N/A
N/A

N/A
N/A
N/A

N/A
N/A
N/A

DSAID will accept the value entered by the SARC.
DSAID will accept the value entered by the SARC.
DSAID will accept the value entered by the SARC.

DR4.1

DoD Action Precluded
DoD Action Precluded Reason
DoD Action Precluded Reason Date
Commander Action Precluded or Declined for
Sexual Assault
Commander Action
Commander Action Date
Commander Action Precluded/Declined Reason
for Sexual Assault
Pre-trial Confinement of Accused Offender

SARC

Action-Ordered into Pretrial Confinement

N/A

N/A

Per 6/22/11 Meeting: This data will be entered by SARC as opposed to via interface.
DSAID will accept the value entered by the SARC.

DR4.2

Date Pre-trial Confinement of Accused Offender

SARC

Action Date

N/A

Date

Per 6/22/11 Meeting: This data will be entered by SARC as opposed to via interface.
DSAID will accept the value entered by the SARC.

DR4.7
DR4.8
DR4.9

06/24/2011

I2MS - Valid
Values

Subject Disposition

I2MS - Data Type/Data
Format

DSAID and I2MS Data Mapping and Translation/Analysis

15 of 15