Table slot9.WORLD.TSTA.ARRESTEES
This table stores the MASTER PERSON selected as the arrestee on an INCIDENT report 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
ATC_ARREST_TYPE varchar2 30
EJS_CODES.CODE ARR1_ATC_ARREST_TY_EJS_CODE_FK R
The type of arrest.
A_NUMBER number 7  √  null
ARREST_DATE date 7  √  null
CREATOR_DATE date 7  √  null Date of record creation
CREATOR_ID varchar2 100  √  null Person creating the record
UPDATOR_DATE date 7  √  null Date of last update
UPDATOR_ID varchar2 100  √  null Person who last updated the record
OFFNSE_OFFENSE_NUMBER number 38  √  null
OFFENSES.OFFENSE_NUMBER ARR1_OFFNSE_FK C
Number assigned to track the offense
OFFNSE_INC_INCIDENT_ID number 38  √  null
OFFENSES.INC_INCIDENT_ID ARR1_OFFNSE_FK C
Incident ID number assigned
ARR_DSP_CD_DISPOSITION_CODE number 2  √  null
ARRESTEE_DISPOSITION_CODES.DISPOSITION_CODE ARR1_ARR_DSP_CD_FK R
OFFNSE_SUPP_SEQ number 5  √  null
OFFENSES.SUPP_SEQ ARR1_OFFNSE_FK C
INC_PER_ID number 0
INCIDENT_PEOPLE.INC_PER_ID ARR1_INCPER_FK C
ATC_ARREST_TYPE_TYPE varchar2 30  √  'UCR_ARREST_TYPE_CODES'
EJS_CODES.CODE_TYPE ARR1_ATC_ARREST_TY_EJS_CODE_FK R
REC_ID number 0  √  null
CHA_CODE varchar2 30  √  null
CHARGE_CODES.CODE ARR1_CHA_FK R
ARREST_CHARGE_CODE varchar2 30  √  null
ARREST_CHARGE_CODES.ARREST_CHARGE_CODE ARR1_ARRCHRGCD_FK R
ARRESTEE_ID number 0 Sequence to be used for the primary key.
TRACKING_NUMBER varchar2 30  √  null

Analyzed at Mon Sep 20 21:05 MDT 2021

Requirements (check constraints):
Constraint Constraint Name
"ARRESTEE_ID" IS NOT NULL ARR1_ARRESTEE_ID_NN
"ATC_ARREST_TYPE" IS NOT NULL ARR1_ATC_ARREST_TYPE_NN
"INC_PER_ID" IS NOT NULL ARR1_INC_PER_ID_NN

Indexes:
Column(s) Type Sort Constraint Name
ARRESTEE_ID Primary key Asc ARR1_PK
ARR_DSP_CD_DISPOSITION_CODE Performance Asc ARR1_ARR_DSP_CD_FK_I
ARREST_CHARGE_CODE Performance Asc ARR1_ARRCHRGCD_FK_I
ATC_ARREST_TYPE_TYPE + ATC_ARREST_TYPE Performance Asc/Asc ARR1_ATC_ARREST_TY_EJS_CODE_I
ATC_ARREST_TYPE Performance Asc ARR1_ATC_FK_I
CHA_CODE Performance Asc ARR1_CHA_FK_I
INC_PER_ID Performance Asc ARR1_INCPER_FK_I
OFFNSE_INC_INCIDENT_ID + OFFNSE_OFFENSE_NUMBER + OFFNSE_SUPP_SEQ Performance Asc/Asc/Asc ARR1_OFFNSE_FK_I

Close relationships  within of separation: