Table slot9.WORLD.TSTA.ARREST_CHARGE_CODES
This table defines the valid charge codes for ARRESTS
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
ARREST_CHARGE_CODE varchar2 30
ARREST_CHARGE_CODE_MODS.ARREST_CHARGE_CODE ACCMDS_CHA_FK C
ARRESTEES.ARREST_CHARGE_CODE ARR1_ARRCHRGCD_FK R
BI_OFFENSE_VW.ARREST_CHARGE_CODE Implied Constraint R
CHARGE_CODES.ARREST_CHARGE_CODE CHA_ARRCHRGCD_FK R
INC_OFF_LATEST_APPR_VW.ARREST_CHARGE_CODE Implied Constraint R
INCIDENT_CRIME_TARGET_VW.ARREST_CHARGE_CODE Implied Constraint R
JS_INCIDENT_EVIDENCE_VW.ARREST_CHARGE_CODE Implied Constraint R
JS_INCIDENT_OFFNDR_EVIDENCE_VW.ARREST_CHARGE_CODE Implied Constraint R
OFFENSE_SPREADSHEET_VW.ARREST_CHARGE_CODE Implied Constraint R
OFFENSES.ARREST_CHARGE_CODE OFFNSE_ARRCHRGCD_FK R
STAGING_OFFENSES.ARREST_CHARGE_CODE Implied Constraint R
WARRANT_ARREST_CHARGES.ARREST_CHARGE_CODE WAC_ARRCHRGCD_FK R
ZZ_ARREST_CHARGE_CODES.ARREST_CHARGE_CODE Implied Constraint R
ZZ_CHARGE_CODES.ARREST_CHARGE_CODE Implied Constraint R
ZZC1_ARREST_CHARGE_CODES.ARREST_CHARGE_CODE Implied Constraint R
ZZC1_CHARGE_CODES.ARREST_CHARGE_CODE Implied Constraint R
ZZV1_ARREST_CHARGE_CODES.ARREST_CHARGE_CODE Implied Constraint R
ZZV1_CHARGE_CODES.ARREST_CHARGE_CODE Implied Constraint R
ARREST_CHA_DESC varchar2 4000  √  null
OFFENSE_CODE varchar2 30  √  null
OFFENSE_CODES.OFFENSE_CODE ARRCHRGCD_OFFNS_CD_FK R
CREATOR_ID varchar2 100  √  null
CREATOR_DATE date 7  √  null
UPDATOR_ID varchar2 100  √  null
UPDATOR_DATE date 7  √  null
REC_ID number 0  √  null
ACTIVE_FLAG varchar2 1  √  'Y' Flag used to indicate if the code is currently active.

Analyzed at Mon Sep 20 21:05 MDT 2021

Requirements (check constraints):
Constraint Constraint Name
"ARREST_CHARGE_CODE" IS NOT NULL ARREST_CHARGE_CODE_NN

Indexes:
Column(s) Type Sort Constraint Name
ARREST_CHARGE_CODE Primary key Asc ARRCHRGCD_PK
OFFENSE_CODE Performance Asc ARRCHRGCD_OFFNS_CD_FK_I

Close relationships  within of separation: