Table slot9.WORLD.TSTA.DS_ICR_VICTIMS
This table stores Victims Segment based on a given EXTERNAL_SYSTEM_CODES.CODE populated from DS_ICR Package when Incident is Approved in the application
Legend:
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
HEADERID number 0
DS_ICR_HEADERS.HEADERID DSICRVIC_DSICRHD_FK R
VICPERSNO number 0 Person ID Number of Victim [Foreign Key: Persons]
VICNO varchar2 255 Data Element 26 (Victim Number [Part of Primary Key])
VIC1FILECL varchar2 255  √  null Data Element 27a (Victim connected Offense File Class [1])
VIC2FILECL varchar2 255  √  null Data Element 27b (Victim connected Offense File Class [2])
VIC3FILECL varchar2 255  √  null Data Element 27c (Victim connected Offense File Class [3])
VIC4FILECL varchar2 255  √  null Data Element 27d (Victim connected Offense File Class [4])
VICTYPE varchar2 255  √  null Data Element 28 (Victim Type)
VICACTIV varchar2 255  √  null Data Element 28a (Victim Activity [LEOKA])
VICASSIGN varchar2 255  √  null Data Element 28b (Victim Assignment [LEOKA])
VICORI varchar2 255  √  null Data Element 28b (Victim Agency ORI [LEOKA])
VICAGE varchar2 255  √  null Data Element 29 (Victim Age)
VICRACE varchar2 255  √  null Data Element 30 (Victim Race)
VICSEX varchar2 255  √  null Data Element 31 (Victim Sex)
VICETHNIC varchar2 255  √  null Data Element 32 (Victim Ethnicity)
VICRESIDEN varchar2 255  √  null Data Element 33 (Victim Residence)
VICINJURY varchar2 255  √  null Data Element 34 (Victim Injury)
VICCIRCUM varchar2 255  √  null Data Element 35 (Victim Circumstances)
VICJUSTHOM varchar2 255  √  null Data Element 36 (Justifiable Homicide Circumstance)
VICORN1 varchar2 255  √  null Data Element 37a (Offender Related Number [1])
VICTOR1 varchar2 255  √  null Data Element 38a (Victim to Offender [1])
VICORN2 varchar2 255  √  null Data Element 37b (Offender Related Number [2])
VICTOR2 varchar2 255  √  null Data Element 38b (Victim to Offender [2])
VICORN3 varchar2 255  √  null Data Element 37c (Offender Related Number [3])
VICTOR3 varchar2 255  √  null Data Element 38c (Victim to Offender [3])
VICORN4 varchar2 255  √  null Data Element 37d (Offender Related Number [4])
VICTOR4 varchar2 255  √  null Data Element 38d (Victim to Offender [4])
VICORN5 varchar2 255  √  null Data Element 37e (Offender Related Number [5])
VICTOR5 varchar2 255  √  null Data Element 38e (Victim to Offender [5])
CREATOR_ID varchar2 100  √  null Person creating the record
CREATOR_DATE date 7  √  null Date of record creation
UPDATOR_ID varchar2 100  √  null Person who last updated the record
UPDATOR_DATE date 7  √  null Date of last update
REC_ID number 0  √  null
VIC5FILECL varchar2 255  √  null NIBR Data Element 24
VIC6FILECL varchar2 255  √  null NIBR Data Element 24
VIC7FILECL varchar2 255  √  null NIBR Data Element 24
VIC8FILECL varchar2 255  √  null NIBR Data Element 24
VIC9FILECL varchar2 255  √  null NIBR Data Element 24
VIC10FILECL varchar2 255  √  null NIBR Data Element 24
VICCIRCUM2 varchar2 255  √  null NIBR Data Element 31
VICINJURY2 varchar2 255  √  null NIBRS Data Element 33
VICINJURY3 varchar2 255  √  null NIBRS Data Element 33
VICINJURY4 varchar2 255  √  null NIBRS Data Element 33
VICINJURY5 varchar2 255  √  null NIBRS Data Element 33
VICORN6 varchar2 255  √  null NIBRS Data Element 34 (Offender Related Number [6])
VICTOR6 varchar2 255  √  null NIBRS Data Element 35 (Victim to Offender [6])
VICORN7 varchar2 255  √  null NIBRS Data Element 34 (Offender Related Number [7])
VICTOR7 varchar2 255  √  null NIBRS Data Element 35 (Victim to Offender [7])
VICORN8 varchar2 255  √  null NIBRS Data Element 34 (Offender Related Number [8])
VICTOR8 varchar2 255  √  null NIBRS Data Element 35 (Victim to Offender [8])
VICORN9 varchar2 255  √  null NIBRS Data Element 34 (Offender Related Number [9])
VICTOR9 varchar2 255  √  null NIBRS Data Element 35 (Victim to Offender [9])
VICORN10 varchar2 255  √  null NIBRS Data Element 34 (Offender Related Number [10])
VICTOR10 varchar2 255  √  null NIBRS Data Element 35 (Victim to Offender [10])
DOMESTIC_VIOLENCE_FLAG varchar2 255  √  null
INC_PER_ID number 0  √  null
INCIDENT_PEOPLE.INC_PER_ID Implied Constraint R
INCIDENT_PEOPLE.INC_PER_ID - PK back to Original Incident Person

Analyzed at Mon Sep 20 21:05 MDT 2021

Requirements (check constraints):
Constraint Constraint Name
"HEADERID" IS NOT NULL DSICRVIC_HEADERID_NN
"VICNO" IS NOT NULL DSICRVIC_VICNO_NN
"VICPERSNO" IS NOT NULL DSICRVIC_VICPERSNO_NN

Indexes:
Column(s) Type Sort Constraint Name
HEADERID + VICPERSNO + VICNO Primary key Asc/Asc/Asc DSICRVIC_PK
HEADERID Performance Asc DSICRVIC_DSICRHD_FK_I

Close relationships  within of separation: