Table slot9.WORLD.TSTA.DS_ICR_HEADERS_GTT
This table stores Administrative Segment Staging transformation from DS_ICR_HEADERS 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
DATEIND varchar2 2000  √  null
HOUROCC date 7  √  null
EXCCLEAR varchar2 2000  √  null
EXCCLEARDT date 7  √  null
NIBRSOFFCD1 varchar2 2000  √  null
NIBRSOFFCD2 varchar2 2000  √  null
NIBRSOFFCD3 varchar2 2000  √  null
NIBRSOFFCD4 varchar2 2000  √  null
NIBRSOFFCD5 varchar2 2000  √  null
NIBRSOFFCD6 varchar2 2000  √  null
NIBRSOFFCD7 varchar2 2000  √  null
NIBRSOFFCD8 varchar2 2000  √  null
NIBRSOFFCD9 varchar2 2000  √  null
NIBRSOFFCD10 varchar2 2000  √  null
CARGOTHEFT varchar2 2000  √  null
TRACT varchar2 2000  √  null
STATUSINDICATOR varchar2 2000  √  null
STATUSCHANGEDATE varchar2 2000  √  null
ENDDATE date 7  √  null
ENDTIME date 7  √  null
NUMOFOFFENSES varchar2 2000  √  null
NUMOFPROPERTIES varchar2 2000  √  null
NUMOFVICTIMS varchar2 2000  √  null
NUMOFOFFENDERS varchar2 2000  √  null
NUMBEROFARRESTEES varchar2 2000  √  null
HOUROCC_HH24 varchar2 2000  √  null
DOMESTICVIOLENCERELATEDINC varchar2 2000  √  null Domestic Violence Related Incident
DOMESTICVIOLENCERELATIONSHIP varchar2 2000  √  null Domestic Violence Relationship
INCIDENTLATITUDE varchar2 2000  √  null Incident Latitude
INCIDENTLONGITUDE varchar2 2000  √  null Incident Longitude
INCSUPP_CREATOR_ID varchar2 2000  √  null Incident Supplement Initial Approved Creator ID
INCSUPP_CREATOR_DATE date 7  √  null Incident Supplement Initial Approved Create Date
INCSUPP_UPDATOR_ID varchar2 2000  √  null Incident Supplement Most Recent Approved Updator ID
INCSUPP_UPDATOR_DATE date 7  √  null Incident Supplement Most Recent Approved Updator ID
INCINSTRUMENTENT varchar2 2000  √  null Incident Instrument Used For Entry
INCACTIVITYCODE varchar2 2000  √  null Incident Activity Code
TRANSACTION_CONTROL_NUM_INC varchar2 2000  √  null Transaction Control Number Incident - created for KIBRS
TRANSACTION_CONTROL_NUM_ARR varchar2 2000  √  null Transaction Control Number Arrest - created for KIBRS

Analyzed at Mon Sep 20 21:05 MDT 2021

Requirements (check constraints):
Constraint Constraint Name
"DATASETID" IS NOT NULL DSICRHDGTT_DATESETID_NN
"HEADERID" IS NOT NULL DSICRHDGTT_HEADERID_NN
"REC_NUM" IS NOT NULL DSICRHDGTT_RECNUM_NN
"UNIQUE_KEY" IS NOT NULL DSICRHDGTT_UNIQUE_KEY_NN


Close relationships: