Table slot9.WORLD.TSTA.DS_ICR_ZERO_GTT
This table stores Zero Segment Staging transformation from DS_ICR_ZERO 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
INCDATE date 7  √  null
ZEROYEAR date 7  √  null

Analyzed at Mon Sep 20 21:05 MDT 2021

Requirements (check constraints):
Constraint Constraint Name
"DATASETID" IS NOT NULL DSICRZGTT_DATESETID_NN
"HEADERID" IS NOT NULL DSICRZGTT_HEADERID_NN
"REC_NUM" IS NOT NULL DSICRZGTT_RECNUM_NN
"UNIQUE_KEY" IS NOT NULL DSICRZGTT_UNIQUE_KEY_NN


Close relationships: