Table slot9.WORLD.TSTA.UCR_OFFENSES_GTT
Temporary table of offense data for UCR reporting
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 38  √  null
DS_ICR_HEADERID number 0  √  null
DS_ICR_UNIQUE_KEY varchar2 255  √  null
DS_ICR_REC_NUM varchar2 255  √  null
IBR_SEGMENT varchar2 100  √  null
DS_IBR_SEGMENTS.IBR_SEGMENT Implied Constraint R
DE_1 varchar2 255  √  null
DE_2 varchar2 255  √  null
DE_6 varchar2 255  √  null
DE_7 varchar2 255  √  null
DE_10 varchar2 255  √  null
DE_11 varchar2 255  √  null
DE_13 varchar2 255  √  null
DE_12 varchar2 255  √  null
DE_3 varchar2 255  √  null Data Element # 3 value
DE_9 varchar2 255  √  null Data Element # 9 value
OFFE_RANK number 0  √  null Ranking of offense based on NIBRS offense hierarchy

Analyzed at Mon Sep 20 21:05 MDT 2021


Close relationships: