Table slot9.WORLD.TSTA.ARREST_CHARGES
This table stores the charge information added to an ARREST 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
AC_ID number 10
ARREST_CHARGE_FLAGS.AC_ID ACF_AC_FK R
ARREST_CHARGE_NARRATIVES.ARREST_CHARGE_ID ARRCHGNR_AC_FK C
ARREST_ID number 0
ARRESTS.ARREST_ID AC_ARR_FK C
Arrest ID number.
CSAU_CODE varchar2 2
CSAU_CODES.CSAU_CODE AC_CSAU_FK R
Type of event
CHARGE_CODE varchar2 30
CHARGE_CODES.CODE AC_CHA_FK R
OFFENSE_DATE date 7 Date that offense occurred
OFFENSE_COUNT number 0 Number of counts.
DISPOSITION_CODE varchar2 24  √  null Code that identifies how the charge was disposed of.
DISPOSITION_DATE date 7  √  null Date that the charge was disposed of.
DESCRIPTION varchar2 50  √  null
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
APPLIED varchar2 1  √  null
COMMISSARY_RESTRICTED_UNTIL date 7  √  null
COMMISSARY_RESTRICTED_HH24 varchar2 2  √  null
RESTRICT_COMMISSARY varchar2 1  √  null
REC_ID number 0  √  null
DOMESTIC_FLAG varchar2 1  √  'N'
BOND_TYPE_CODE varchar2 2  √  null
BOND_TYPE_CODES.BOND_TYPE AC_BTC_FK R
BOND_AMOUNT number 36,2  √  null
CHARGE_CLASS_CODE varchar2 1  √  null
CHARGE_CLASS_CODES.CHARGE_CLASS_CODE AC_CCC1_FK R
CHARGE_CATEGORY_CODE varchar2 2  √  null
CHARGE_CLASS_CODES.CHARGE_CATEGORY_CODE AC_CCC1_FK R

Analyzed at Mon Sep 20 21:05 MDT 2021

Requirements (check constraints):
Constraint Constraint Name
"AC_ID" IS NOT NULL AC_AC_ID_NN
"ARREST_ID" IS NOT NULL AC_ARREST_ID_NN
"CHARGE_CODE" IS NOT NULL AC_CHARGE_CODE_NN
"CSAU_CODE" IS NOT NULL AC_CSAU_CODE_NN
"OFFENSE_COUNT" IS NOT NULL AC_OFFENSE_COUNT_NN
"OFFENSE_DATE" IS NOT NULL AC_OFFENSE_DATE_NN
DOMESTIC_FLAG IN ('Y', 'N') CK_AC_DOM_FLAG

Indexes:
Column(s) Type Sort Constraint Name
AC_ID Primary key Asc AC_PK
APPLIED Performance Asc AC_APPLIED_I
ARREST_ID Performance Asc AC_ARR_FK_I
BOND_TYPE_CODE Performance Asc AC_BTC_FK_I
CHARGE_CLASS_CODE + CHARGE_CATEGORY_CODE Performance Asc/Asc AC_CCC1_FK_I
CHARGE_CODE Performance Asc AC_CHA_FK_I
CSAU_CODE Performance Asc AC_CSAU_FK_I

Close relationships  within of separation: