Table slot9.WORLD.TSTA.DS_ICR_VICTIMS_GTT
This table stores Victims Segment Staging transformation from DS_ICR_VICTIMS into its Final (or close to) NIBRS (or given EXTERNAL_SYSTEM_CODES.CODE) Format
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
DATASETID number 0
DS_ICR_DATA_SETS.DATASETID Implied Constraint R
HEADERID number 0
DS_ICR_HEADERS.HEADERID Implied Constraint R
UNIQUE_KEY varchar2 255
REC_NUM varchar2 255
SEGMENT_LENGTH varchar2 2000  √  null
SEGMENT_LEVEL varchar2 2000  √  null
ACTION varchar2 2000  √  null
MONTH date 7  √  null
ORIGYEAR date 7  √  null
CITYINDICATOR varchar2 2000  √  null
ORIGORI varchar2 2000  √  null
INCIDENTNO varchar2 2000  √  null
VICNO varchar2 2000  √  null
VIC1FILECL varchar2 2000  √  null
VIC2FILECL varchar2 2000  √  null
VIC3FILECL varchar2 2000  √  null
VIC4FILECL varchar2 2000  √  null
VIC5FILECL varchar2 2000  √  null
VIC6FILECL varchar2 2000  √  null
VIC7FILECL varchar2 2000  √  null
VIC8FILECL varchar2 2000  √  null
VIC9FILECL varchar2 2000  √  null
VIC10FILECL varchar2 2000  √  null
VICTYPE varchar2 2000  √  null
VICAGE varchar2 2000  √  null
VICSEX varchar2 2000  √  null
VICRACE varchar2 2000  √  null
VICETHNIC varchar2 2000  √  null
VICRESIDEN varchar2 2000  √  null
VICCIRCUM varchar2 2000  √  null
VICCIRCUM2 varchar2 2000  √  null
VICJUSTHOM varchar2 2000  √  null
VICINJURY varchar2 2000  √  null
VICINJURY2 varchar2 2000  √  null
VICINJURY3 varchar2 2000  √  null
VICINJURY4 varchar2 2000  √  null
VICINJURY5 varchar2 2000  √  null
VICORN1 varchar2 2000  √  null
VICTOR1 varchar2 2000  √  null
VICORN2 varchar2 2000  √  null
VICTOR2 varchar2 2000  √  null
VICORN3 varchar2 2000  √  null
VICTOR3 varchar2 2000  √  null
VICORN4 varchar2 2000  √  null
VICTOR4 varchar2 2000  √  null
VICORN5 varchar2 2000  √  null
VICTOR5 varchar2 2000  √  null
VICORN6 varchar2 2000  √  null
VICTOR6 varchar2 2000  √  null
VICORN7 varchar2 2000  √  null
VICTOR7 varchar2 2000  √  null
VICORN8 varchar2 2000  √  null
VICTOR8 varchar2 2000  √  null
VICORN9 varchar2 2000  √  null
VICTOR9 varchar2 2000  √  null
VICORN10 varchar2 2000  √  null
VICTOR10 varchar2 2000  √  null
VICACTIV varchar2 2000  √  null
VICASSIGN varchar2 2000  √  null
VICORI varchar2 2000  √  null
VICASSAULTSTATUS varchar2 2000  √  null
VICOFFARR1 varchar2 2000  √  null
VICOFFARR2 varchar2 2000  √  null
VICOFFARR3 varchar2 2000  √  null
VICOFFARR4 varchar2 2000  √  null
VICOFFARR5 varchar2 2000  √  null
VICOFFARR6 varchar2 2000  √  null
VICOFFARR7 varchar2 2000  √  null
VICOFFARR8 varchar2 2000  √  null
VICOFFARR9 varchar2 2000  √  null
VICOFFARR10 varchar2 2000  √  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
ENTITYIDNUMBER number 0  √  null Entity Identification Number - Unique to each Victim, Offender, Arrestee and GroupB in the Incident
VICLNAME varchar2 2000  √  null Last Name of victim based on inc_per_id
VICFNAME varchar2 2000  √  null First Name of victim based on inc_per_id
VICMNAME varchar2 2000  √  null Middle Name of victim based on inc_per_id

Analyzed at Mon Sep 20 21:05 MDT 2021

Requirements (check constraints):
Constraint Constraint Name
"DATASETID" IS NOT NULL DSICRVICGTT_DATESETID_NN
"HEADERID" IS NOT NULL DSICRVICGTT_HEADERID_NN
"REC_NUM" IS NOT NULL DSICRVICGTT_RECNUMNN
"UNIQUE_KEY" IS NOT NULL DSICRVICGTT_UNIQUE_KEY_NN


Close relationships: