Public Safety Officer Suicide Module

Attachment 6
NVDRS Web-based Data Entry (Sample Screenshots of System)
Introduction
This document displays the screens that abstractors used to enter required data elements. The variable name associated with each
data entry field is provided to help user interpret and analyze data. Any new variables on the righthand side are flagged in red with
additional numbers, and the corresponding variable names given below.
I.

Landing Page: Displays once securely logged on to Secure Access Managemt Services (SAMS) and granted entry into the
application.

II.

Demographic Variables for Victims:
Sex dropdown menu:

1
2
3
4
5
6
7
8
9
10
11
12

PersonType
BirthDayofMonth
LastNameFirstInitial
CMENumberLastFour
DCNumberLastFour
Sex
Age
AgeUnit
HeightFeet
HeightInches
Weight
MaritalStatus

13
14
15
16
17
18
19
20
21
22
23
24

RelationshipStatus
SexofPartner
Pregnant
SexualOrientation
Military
RaceWhite
RaceBlack
RaceAsian
RaceAsianIndian
RaceChinese
RaceFilipino
RaceJapanese

25

RaceKorean

26

RaceVietnamese

27
28
29
30
31
32
33
34
35
36

RaceOtherAsian
RacePacificIslander
RaceHawaiian
RaceGuamanian
RaceSamoan
RaceOtherPacIslander
RaceAmericanIndian
RaceOther
RaceUnspecified
Ethnicity

III. Place of Residence, Birthplace, Industry, Occupation, and Education

1
2
3
4
5
6
7
8
9

Country
ResidenceState
ResidenceCounty
ResidenceCity
ResidenceZip
ResidenceCensusTract
ResidenceCensusBlock
Industry
IndustryText

10
11
12
13
14
15
16
17

BirthPlace
BirthCountryOther
UsualOccupation
OccupationText
OccupationCurrentText
Homeless
EducationLevel
EducationYears

3

IV.

1
2
3
4
5
6
7

Injury and Death

DeathMannerAbstractor
DeathMannerDC
DeathMannerCME
DeathMannerLE
InjuryState
InjuryCounty
InjuryCity

8 InjuryZip

9
10
11
12
13
14
15

InjuryLocationType
CensusTract
CensusBlock
InjuryDate
InjuryTime
InjuredAtWork
InjuredAtVictimHome

16 EMSPresent

17
18
19
20
21

VictimInCustody
RecentRelease
AlcoholUseSuspected
SurvivalTime
SurvivalTimeUnit

V.

Hospital Codes

1
2
3
4
5
6

EmergencyDepartment
HospitalAdmit
ExternalCause1ICD9
ExternalCause2ICD9
ExternalCause1ICD10
ExternalCause2ICD10

5

VI.

Wounds and Death Certificate: Part 1: Underlying Cause of Death & Location of Death

1
2
3
4
5
6
7

UnderlyingCauseCode
UnderlyingCauseCode4thDigit
UnderlyingCauseCode5thDigit
DeathPlace
DeathPlaceText
AutopsyPerformed
DeathState

8
9
10
11
12
13

DatePronouncedDate
DeathDate
DeathCause1
DeathCause2
DeathCause3
DeathCause4

VII.

Wounds and Death Certificate: Part 2: Wounds and Multiple Conditions

14 NumberWounds

21 WoundToSpine

28 MultiCondition06ICD10

15 WoundToFace

22 WoundToHead

29 MultiCondition10ICD10

16 WoundToThorax

23 WoundToAbdomen

30 MultiCondition03ICD10

17 NumberBullets

24 MultiCondition01ICD10 31 MultiCondition07ICD10

18 WoundToUpperExtremity 25 MultiCondition05ICD10 32 MultiCondition04ICD10
19 WoundToLowerExtremity 26 MultiCondition09ICD10 33 MultiCondition08ICD10
20 WoundToNeck

27 MultiCondition02ICD10

7

VIII. Circumstances: Mental, Health, Substance Abuse, and Other Addiction & Relationship and Life Stressors
CIRCUMSTANCE VARIABLE
NAMES BY DATA SOURCE
(CME AND LE)
Variables abstracted from
both the CME and the LE
reports are exported into two
variables. If the CME report is
the source, the variable name
is preceded by “CME_” (e.g.,
“CME_VariableName”). If the
LE report is the source, the
variable name is preceded by
“LE_” (e.g.,
“LE_VariableName”). For
instance, information on the
“Argument” variable will be
stored in “CME_Argument”
and “LE_Argument”

1
2
3
4
5
6
7
8

MentalHealthProblem
DepressedMood
MentalIllnessTreatmentCurrent
HistoryMentalIllnessTreatment
AlcoholProblem
SubstanceAbuseOther
OtherAddiction
LE_MentalHealthDiagnosis1

CRISIS VARIABLE NAMES
Whether a circumstance was a crisis
(i.e., checking the “LE Crisis” or “CME
Crisis” checkbox) is stored in a
separate variable from the
circumstance in the export file.
Specifically, crisis variables will have
the word “crisis” inserted between the
data source (i.e., LE and CME) and the
circumstance name in the variable
label variable (e.g.,
CME_CrisisVariableName,
LE_CrisisVariableName). For example,
the crisis variables for “Stalking” will
be CME_CrisisStalking and
LE_CrisisStalking.

9
10
11
12
13
14
15
16

LE_MentalHealthDiagnosis2
LE_MentalHealthDiagnosisOther
CME_MentalHealthDiagnosis1
CME_MentalHealthDiagnosis2
CME_MentalHealthDiagnosisOther
IntimatePartnerViolence
IntimatePartnerProblem
FamilyStressors

8

17
18
19
20
21
22
23
24
25

RelationshipProblemOther
26 LE_CircumstancesKnown
27 CME_CircumstancesKnown
DeathAbuse
AbusedAsChild
InterpersonalViolencePerpetrator
InterpersonalViolenceVictim
FightBetweenTwoPeople
Argument
LE_ArgumentTiming
CME_ArgumentTiming

IX. Circumstances: Mental, Health, Substance Abuse, and Other Addiction & Relationship and Life Stressors

1
2
3
4
5
6

PrecipitatedByOtherCrime
OtherCrimeinProgress
Stalking
Prostitution
TerroristAttack
WalkByAssault

7
8
9
10
11
12

9

LE_GangType
CME_GangType
LE_NatureOtherCrime1
LE_NatureOtherCrime2
CME_NatureOtherCrime1
CME_NatureOtherCrime2

X.

1
2
3
4
5
6
7

Circumstances: Manner Specific Circumstances for Homicide and Suicide Deaths

JustifiableSelfDefense
VictimPoliceOfficeOnDuty
Bystander
RandomViolence
IntervenerAssistingVictim
VictimUsedWeapon
MercyKilling

8
9
10
11
12
13
14

HateCrime
Jealousy
Brawl
DriveByShooting
DrugInvolvement
SuicideAttemptHistory
SuicideIntentDisclosed

15 LE_DisclosedIntentToWhom
16 CME_DisclosedIntentToWhom
17 SuicideNote
18 SuicideThoughtHistory
19 RecentCriminalLegalProblem
20 LegalProblemOther
21 PhysicalHealthProblem

10

22
23
24
25
26
27
28

JobProblem
FinancialProblem
SchoolProblem
EvictionorLossofHome
RecentSuicideFriendFamily
DeathFriendorFamilyOther
TraumaticAnniversary

XI.

Circumstances: Manner Specific Circumstances for Unintentional Firearm Deaths

1 Hunting
2 TargetShooting
3 SelfDefense
4 CelebratoryFiring
5 GunFiredLoadingUnloading
6 GunCleaning
7 GunShowing
8 GunPlaying
9 OtherContextInjury

10
11
12
13
14
15
16
17
18
19

GunThoughtSafetyEngaged
GunThoughtUnloadedMagazineDisengaged
GunThoughtUnloadedOther
GunUnintentionallyPulledTrigger
BulletRicochet
GunDefectMalfunction
GunFiredHolstering
GunDropped
GunFiredOperatingSafetyLock
GunThoughtToy

20 OtherMechanismInjury

11

XII.

Circumstances: Manner Specific Circumstances for Unintentional Firearm Deaths

1
2
3

CrisisRecent
LE_CircumstancesOtherText
CME_CircumstancesOtherText

12

XIII. Weapons

1
2
3
4
5
6
7
8
9

WeaponType
WeaponOther
FirearmType
FirearmCaliber
FirearmGauge
FirearmMake
FirearmMakeText
FirearmModel
FirearmModelText

10
11
12
13
14

GunLoaded
FirearmStolen
GunOwner
GunStoredLocked
YouthGunAccessNarrative

13

XIV. Suspects:

5

1

15

6

16

7

2

17

8

18

9

3

19

10
11

4

20

12

21

13
14

1
2
3
4

AgeYears
Sex
VictimSuspectRelationship1
VictimSuspectRelationship2

5
6
7
8
9
10
11
12
13
14

AbuseHistory
CareGiver
AttemptedSuicide
SuspectAlsoVictim
SuspectMentallyIll
SuspectDisabilityDevelopmental
SuspectAlcoholUseSuspected
SuspectSubstanceUseSuspected
SuspectRecentRelease
SuspectContactPolice

14

15
16
17
18
19
20
21

RaceWhite
RaceBlack
RaceAsian
RacePacificIslander
RaceAmericanIndian
RaceUnspecified
SuspectEthnicity

XV.

Toxicology: Toxicology Specimen Date & Toxicology Findings

1
2
3
4
5
6

No Toxicology Available
SpecimensTime
Comments
SubstanceName
SubstanceTested
SubstanceResult

7
8
9

SubstanceCausedDeath
DrugObtainedFor
SubstanceClass

15

XVI. Toxicology Templates: new addition to the software
There is now a “templates” feature that may assist in entering tox data that comes to abstractors in standardized formats. State
administrators can create toxicology templates, and then abstractors can add a template to a victim record by clicking the “apply template”
button on the toxicology tab.

16

XVII. Toxicology: Toxicology Summary:

1
2
3
4
5
6
7
8

AlcoholTested
AlcoholResult
AlcoholLevel
CarbonMonoxideTested
CarbonMonoxideResult
CarbonMonoxideSource
AmphetamineTested
AmphetamineResult

9
AnticonvulsantsTested
10 AnticonvulsantsResult
11 AntiDepressantTested
12 AntiDepressantResult
13 AntipsychoticTested
14 AntipsychoticResult
15 BarbituratesTested
16 BarbituratesResult

17

17 BenzodiazepinesTested
18 BenzodiazepinesResult
19 CocaineTested
20 Cocaine test result
21 MarijuanaTested
22 MarijuanaResult
23 MuscleRelaxantTested
24 MuscleRelaxantResult

25
26

OpiateTested
OpiateResult

XVIII. Documents Page

1 DocumentUnavailable
2 DocumentType
3 AgencySource
4 Date record requested

5
6
7
8
9

18

Date record re-requested
Date record received
AbstractedDate
Date entered data checked
DocumentNotes

XIX. Incident Overview Page: Acts as a home page for the incident, it displays when and incident is first created

1
2
3
4
5
6
7

IncidentType
NumberOfDocuments
NumberofVictims
NumberNonfatallyShot
FollowUp
CompleteDC
CompleteCME

8
9
10
11
12
13
14

CompleteToxicology
CompleteLE
AbstractorName
SupervisorCheckedDate
SupervisorRecheckedDate
CompleteIncident
CreateDate

19

15 LastUpdateDate
16 DateDeleted
17 DateMerged
18 NumberOfWeapons
19 NumberOfSuspects

XX.

CME and LE Incident Narratives

1 NarrativeLE
2 NarrativeCME

20

XXI. Import Page: Available to states to import information from death certificates, including ICD-10 and Coroner/Medical Examiner
records. One new option added, the ability to identify the incident types for casing being imported.

21

XXII. The Dashboard: Displays on the Home Page, tool for each state to monitor and evaluate perform

22

XXIII. Incident Validation: this is a new addition to the software
The new software architecture has allowed us to pull together all of the validation rules on the various data elements into a single screen.
Now, you can click the “validate” button next to the “save” button and receive a report on all validation rules for the incident, like this:

In addition to the errors and warnings that have always been in the software, we have added about two dozen “data quality checks” that we
have been running in SAS as part of the data closeout process. We plan to add more checks in the future.

23

XXIV. Related Incidents: this is a new addition to the software
We have added a panel to the Incident screen that allows users to create links between incidents. Each link has a description field and
allows users to click through to see the related incident. The panel looks like this:

States will have a lot of freedom in determining what constitutes a “related” incident in NVDRS. Related incidents might include multiple
homicides taking place outside of our 24-hour case definition criterion, unintentional drug overdoses with related suicides or homicides,
and so on. In the future, we may add a drop down with relationship categories, based on how this feature is used in practice.

24

XXV. Overdose Module: An optional module added to NVDRS web-based system for the State Unintentional Drug Overdose Reporting
System (SUDORS). The existence of NVDRS and its web-system made rapid scale-up of SUDORS to respond to the increase in
overdose deaths possible. NVDRS does not collect these data elements.

25