Table slot9.WORLD.TSTA.DS_ICR_ARRESTS
This table stores ARRESTS Segment based on a given EXTERNAL_SYSTEM_CODES.CODE populated from DS_ICR Package when Incident is Approved in the application
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
HEADERID number 0
DS_ICR_HEADERS.HEADERID DSICRARR_DSICRHD_FK R
ARRPERSNO number 0 Person ID Number of Arrestee [Foreign Key: Arrests Persons and Arrests]
ARRNO varchar2 255 Data Element 39 (Arrest Number [Part of Primary Key])
ARRCOUNT number 0  √  null Arrest Count [Part of Foreign Key: Arrests]
ARRTYPE varchar2 255  √  null Data Element 40 (Arrest Type)
ARRAGE varchar2 255  √  null Data Element 41 (Arrest Age)
ARRRACE varchar2 255  √  null Data Element 42 (Arrest Race)
ARRSEX varchar2 255  √  null Data Element 43 (Arrest Sex)
ARRETHNIC varchar2 255  √  null Data Element 44 (Arrest Ethnicity)
ARRRESIDEN varchar2 255  √  null Data Element 45 (Arrest Residence)
ARRCHARGE varchar2 255  √  null Data Element 46 (Arrest Charge)
ARRARMED1 varchar2 255  √  null Data Element 47a (Arrest Armed [1])
ARRARMED2 varchar2 255  √  null Data Element 47b (Arrest Armed [2])
ARRDATE date 7  √  null Data Element 48 (Arrest Date)
ARRMAR varchar2 255  √  null Data Element 49 (Multiple Arrest Indicator)
ARR18DISP varchar2 255  √  null Data Element 50 (Dispositin of Arrest Under 18)
ARRCLRIND varchar2 255  √  null Data Element 51 (Clearance Indicator)
CREATOR_ID varchar2 100  √  null Person creating the record
CREATOR_DATE date 7  √  null Date of record creation
UPDATOR_ID varchar2 100  √  null Person who last updated the record
UPDATOR_DATE date 7  √  null Date of last update
REC_ID number 0  √  null
ARRUCR varchar2 255  √  null NIBRS Data Element 45 UCR Arrest Offense Code
ARNUMBER varchar2 255  √  null NIBRS Data Element 41 Arrest Transaction Number
ARRTYPEACTIVITY1 varchar2 255  √  null
ARRTYPEACTIVITY2 varchar2 255  √  null
ARRTYPEACTIVITY3 varchar2 255  √  null
ARRTYPEDRUG1 varchar2 255  √  null
ARRTYPEDRUG2 varchar2 255  √  null
ARRTYPEDRUG3 varchar2 255  √  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
TRACKING_NUMBER varchar2 30  √  null Arrest Tracking Number used for IBR Arrest Number

Analyzed at Mon Sep 20 21:05 MDT 2021

Requirements (check constraints):
Constraint Constraint Name
"ARRNO" IS NOT NULL DSICRARR_ARRNO_NN
"ARRPERSNO" IS NOT NULL DSICRARR_ARRPERSNO_NN
"HEADERID" IS NOT NULL DSICRARR_HEADERID_NN

Indexes:
Column(s) Type Sort Constraint Name
HEADERID + ARRPERSNO + ARRNO Primary key Asc/Asc/Asc DSICRARR_PK
HEADERID Performance Asc DSICRARR_DSICRHD_FK_I

Close relationships  within of separation: