Table slot9.WORLD.TSTA.DS_ICR_OFFENSES_GTT
This table stores Offenses Segment Staging transformation from DS_ICR_OFFENSES 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
NIBRSOFFCD varchar2 2000  √  null
OFFATT varchar2 2000  √  null
OFFSOU1 varchar2 2000  √  null
OFFSOU2 varchar2 2000  √  null
OFFSOU3 varchar2 2000  √  null
SITE varchar2 2000  √  null
PREMISES varchar2 2000  √  null
METHODOE varchar2 2000  √  null
ACTTYPE1 varchar2 2000  √  null
ACTTYPE2 varchar2 2000  √  null
ACTTYPE3 varchar2 2000  √  null
WEAPON varchar2 2000  √  null
WEAPON2 varchar2 2000  √  null
WEAPON3 varchar2 2000  √  null
BIAS varchar2 2000  √  null
TYPESECURITY1 varchar2 2000  √  null
TYPESECURITY2 varchar2 2000  √  null
ENTRY1 varchar2 2000  √  null
ENTRY2 varchar2 2000  √  null
EXIT1 varchar2 2000  √  null
EXIT2 varchar2 2000  √  null
OFFDATE date 7  √  null
VICTIMUSE1 varchar2 2000  √  null Victim is suspected of using tracked at the Offense Level. SCIBRS
VICTIMUSE2 varchar2 2000  √  null Victim is suspected of using tracked at the Offense Level. SCIBRS
VICTIMUSE3 varchar2 2000  √  null Victim is suspected of using tracked at the Offense Level. SCIBRS
SPECIALCIRCUMSTANCE varchar2 2000  √  null Special Circumstance. SCIBRS
INCIDENT_ID number 0  √  null
INCIDENTS.INCIDENT_ID Implied Constraint R
INCIDENTS.INCIDENT_ID - Part of PK back to Original Offense
SUPP_SEQ number 0  √  null INCIDENT_SUPPLEMENTS.SUPP_SEQ - Part of PK back to Original Offense
OFFENSE_NUMBER number 0  √  null OFFENSES.OFFENSE_NUMBER - Part of PK back to Original Offense
STATUTE varchar2 2000  √  null
UCR_NUMBER number 0  √  null UCR Number
ORECNO number 0  √  null Offense Number

Analyzed at Mon Sep 20 21:05 MDT 2021

Requirements (check constraints):
Constraint Constraint Name
"DATASETID" IS NOT NULL DSICROFFGTT_DATESETID_NN
"HEADERID" IS NOT NULL DSICROFFGTT_HEADERID_NN
"REC_NUM" IS NOT NULL DSICROFFGTT_RECNUM_NN
"UNIQUE_KEY" IS NOT NULL DSICROFFGTT_UNIQUEKEY_NN


Close relationships: