Table slot9.WORLD.TSTA.DS_ICR_GROUPB_GTT
This table stores Group B Arrestee Segment Staging transformation from DS_ICR_ARRESTS (Group B Only) 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
ARNUMBER varchar2 2000  √  null
ARRCOUNT varchar2 2000  √  null
ARRNO varchar2 2000  √  null
ARRDATE date 7  √  null
ARRTYPE varchar2 2000  √  null
ARRMAR varchar2 2000  √  null
ARRUCR varchar2 2000  √  null
ARRARMED1 varchar2 2000  √  null
ARRARMED2 varchar2 2000  √  null
ARRAGE varchar2 2000  √  null
ARRSEX varchar2 2000  √  null
ARRRACE varchar2 2000  √  null
ARRETHNIC varchar2 2000  √  null
ARRRESIDEN varchar2 2000  √  null
ARR18DISP varchar2 2000  √  null
ARRTYPEACTIVITY1 varchar2 2000  √  null
ARRTYPEDRUG1 varchar2 2000  √  null
ARRTYPEACTIVITY2 varchar2 2000  √  null
ARRTYPEDRUG2 varchar2 2000  √  null
ARRTYPEACTIVITY3 varchar2 2000  √  null
ARRTYPEDRUG3 varchar2 2000  √  null
ARRUCR2 varchar2 2000  √  null
ARRUCR3 varchar2 2000  √  null
ARREST_ID number 0  √  null
ARRESTS.ARREST_ID Implied Constraint R
ARRESTS.ARREST_ID - PK back to Original Arrest
INC_PER_ID number 0  √  null
INCIDENT_PEOPLE.INC_PER_ID Implied Constraint R
INCIDENT_PEOPLE.INC_PER_ID - PK back to Incident Person
ENTITYIDNUMBER number 0  √  null Entity Identification Number - Unique to each Victim, Offender, Arrestee and GroupB in the Incident
INCIDENTNO varchar2 255  √  null Incident No

Analyzed at Mon Sep 20 21:05 MDT 2021

Requirements (check constraints):
Constraint Constraint Name
"DATASETID" IS NOT NULL DSICRGRPBGTT_DATESETID_NN
"HEADERID" IS NOT NULL DSICRGRPBGTT_HEADERID_NN
"REC_NUM" IS NOT NULL DSICRGRPBGTT_REC_NUM_NN
"UNIQUE_KEY" IS NOT NULL DSICRGRPBGTT_UNIQUE_KEY_NN


Close relationships: