Table slot9.WORLD.TSTA.DS_ICR_ARRESTS_GTT
This table stores ARRESTS (Group A) Segment Staging Table. Stores transformation from DS_ICR_ARRESTS 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
ARRCOUNT varchar2 2000  √  null
ARRNO varchar2 2000  √  null
ARRDATE date 7  √  null
ARRTYPE varchar2 2000  √  null
ARRMAR varchar2 2000  √  null
ARRCLIND varchar2 1  √  null Arrest Clearance Indicator
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
NIBRSOFFCD1 varchar2 2000  √  null Clearance Offense Code #1
NIBRSOFFCD2 varchar2 2000  √  null Clearance Offense Code #2
NIBRSOFFCD3 varchar2 2000  √  null Clearance Offense Code #3
NIBRSOFFCD4 varchar2 2000  √  null Clearance Offense Code #4
NIBRSOFFCD5 varchar2 2000  √  null Clearance Offense Code #5
NIBRSOFFCD6 varchar2 2000  √  null Clearance Offense Code #6
NIBRSOFFCD7 varchar2 2000  √  null Clearance Offense Code #7
NIBRSOFFCD8 varchar2 2000  √  null Clearance Offense Code #8
NIBRSOFFCD9 varchar2 2000  √  null Clearance Offense Code #9
NIBRSOFFCD10 varchar2 2000  √  null Clearance Offense Code #10
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
TCA varchar2 2000  √  null
DRUGTYPE varchar2 2000  √  null
ARREST_ID number 0  √  null
ARRESTS.ARREST_ID Implied Constraint R
ARRESTS.ARREST_ID - PK back to Original Arrest
ARRESTEENIBRSOFFCD1 varchar2 2000  √  null Arrestee Associated Offense #1
ARRESTEENIBRSOFFCD2 varchar2 2000  √  null Arrestee Associated Offense #2
ARRESTEENIBRSOFFCD3 varchar2 2000  √  null Arrestee Associated Offense #3
ARRESTEENIBRSOFFCD4 varchar2 2000  √  null Arrestee Associated Offense #4
ARRESTEENIBRSOFFCD5 varchar2 2000  √  null Arrestee Associated Offense #5
ARRESTEENIBRSOFFCD6 varchar2 2000  √  null Arrestee Associated Offense #6
ARRESTEENIBRSOFFCD7 varchar2 2000  √  null Arrestee Associated Offense #7
ARRESTEENIBRSOFFCD8 varchar2 2000  √  null Arrestee Associated Offense #8
ARRESTEENIBRSOFFCD9 varchar2 2000  √  null Arrestee Associated Offense #9
ARRESTEENIBRSOFFCD10 varchar2 2000  √  null Arrestee Associated Offense #10
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
STATUTE varchar2 2000  √  null Statute from charge_codes table, based on arrest_charge_code
DOM_VIOLENCE varchar2 2000  √  null Flag indicating whether domestic violence involved for this arrestee.
OFFENSE_NUM number 0  √  null Offense number of offense in ds_icr_offenses_gtt related to this arrestee.
LOCATION_HOUSE_NUMBER varchar2 2000  √  null Location House Number
LOCATION_STRUCTURE_NUMBER varchar2 2000  √  null Location Structure Number
LOCATION_PRIMARY_ST_DIR varchar2 2000  √  null Location Primary Street Directional
LOCATION_STREET_NAME varchar2 2000  √  null Location Street Name
LOCATION_STREET_TYPE varchar2 2000  √  null Location Street Type
LOCATION_SECONDARY_ST_DIR varchar2 2000  √  null Location Secondary Street Directional
LOCATION_OCCUPANCY_CODE varchar2 2000  √  null Location Occupancy Code
LOCATION_OCCUPANCY_NUMBER varchar2 2000  √  null Location Occupancy Number
LOCATION_CITY_NAME varchar2 2000  √  null Location City Name
LOCATION_STATE varchar2 2000  √  null Location State
LOCATION_POSTAL_CODE varchar2 2000  √  null Location Postal Code
ARRLNAME varchar2 2000  √  null Last Name of arrestee based on inc_per_id
ARRFNAME varchar2 2000  √  null First Name of arrestee based on inc_per_id
ARRMNAME varchar2 2000  √  null Middle Name of arrestee based on inc_per_id

Analyzed at Mon Sep 20 21:05 MDT 2021

Requirements (check constraints):
Constraint Constraint Name
"DATASETID" IS NOT NULL DSICRARRGTT_DATESETID_NN
"HEADERID" IS NOT NULL DSICRARRGTT_HEADERID_NN
"REC_NUM" IS NOT NULL DSICRARRGTT_RECNUM_NN
"UNIQUE_KEY" IS NOT NULL DSICRARRGTT_UNIQUE_KEY_NN


Close relationships: