Table slot9.WORLD.TSTA.CHARGE_CODES
This table defines the valid charge codes
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
CODE varchar2 30
ARREST_CHARGES.CHARGE_CODE AC_CHA_FK R
ARRESTEES.CHA_CODE ARR1_CHA_FK R
CHARGE_CODE_MODULES.CHARGE_CODE CHGCDMOD_CHA_FK C
CHARGE_CODE_TOKENS.CHARGE_CODE CHRGTOK_CHA_FK R
CHARGE_TEMPLATES.CHARGE_CODE CHRGTEMP_CHA_FK C
CITATION_VIOLATIONS.CHARGE_CODE CITVIO_CHA_FK R
CRIMINAL_COMPLAINT_CHARGES.CHARGE_CODE CCCRG_CHA_FK R
OFFENSES.CHARGE_CODE OFFNSE_CHA_FK R
USER_FIELD_CHARGE_VALUES.CHARGE_CODE UFCHV_CHA_FK R
WARRANT_CHARGES.CHA_CODE WCHG_CHA_FK R
BLOOD_TYPE_CODES.CODE Implied Constraint R
STATUTE varchar2 20  √  null State statutue
CHARGE_CLASS_CODE varchar2 1
CHARGE_CLASS_CODES.CHARGE_CLASS_CODE CHA_CCC1_FK R
CHARGE_CATEGORY_CODE varchar2 2
CHARGE_CLASS_CODES.CHARGE_CATEGORY_CODE CHA_CCC1_FK R
CHA_DESC varchar2 255  √  null Description of charge.
ADDCHG varchar2 1  √  null
APR varchar2 1  √  null
AOSEQ number 6  √  null
ACT number 5  √  null
EFFDATE date 7  √  null
INADATE date 7  √  null
SOS varchar2 1  √  null
BOI varchar2 1  √  null
REMARKS varchar2 30  √  null
INA varchar2 1  √  null
LUPDATE date 7  √  null
SUFFCK number 0  √  null
CHAPTER number 4  √  null
SECTION varchar2 25  √  null
MVRDATE date 7  √  null
STATUTE_NEW varchar2 60  √  null
SHORT_LIST varchar2 1  √  null
OFFNS_CD_OFFENSE_CODE varchar2 30  √  null
OFFENSE_CODES.OFFENSE_CODE CHA_OFFNS_CD_FK R
DISPLAY_FLAG varchar2 1
SPEEDING_FLAG varchar2 1  √  null Determines if the charge is speeding
SUSPEND_FLAG varchar2 1  √  null Used in suspension processing to determine reinstatement fees and which charges are reported to the DMV.
VARIABLE_FINE_FLAG varchar2 1  √  null Determines if the charge carries a variable fine
FINE number 9,2  √  null The fine amount associated with the charge.
STATE_CODE varchar2 3  √  null The 3 digit code used to transmit abstracts of conviction to the state.
FINGERPRINT_FLG varchar2 1  √  null Used to identify charges that need to be transmitted to the KBI/FBI or defendants who need to be fingerprinted.
ADMIN_CRT varchar2 1  √  'N'
COMMISSARY_RESTRICTED_HOURS number 0  √  null
RESTRICT_COMMISSARY varchar2 1  √  null
REC_ID number 0  √  null
ARREST_CHARGE_CODE varchar2 30  √  null
ARREST_CHARGE_CODES.ARREST_CHARGE_CODE CHA_ARRCHRGCD_FK R
DV_FLAG varchar2 1  √  'N'
REQUIRE_TYPE_FLAG varchar2 1  √  'N'
REQUIRE_CLASS_FLAG varchar2 1  √  'N'
DEFAULT_ON_ENTRY_FLAG varchar2 1  √  'N'
CHARGING_TITLE varchar2 2000  √  null
CHARGE_DETAILS varchar2 500  √  null
DEFAULT_BOND_ON_ENTRY varchar2 1  √  null
BOND_TYPE varchar2 2  √  null
BOND_TYPE_CODES.BOND_TYPE Implied Constraint R
BOND_AMOUNT number 9,2  √  null

Analyzed at Mon Sep 20 21:05 MDT 2021

Requirements (check constraints):
Constraint Constraint Name
"CHARGE_CATEGORY_CODE" IS NOT NULL CHA_CHARGE_CATEGORY_CODE_NN
"CHARGE_CLASS_CODE" IS NOT NULL CHA_CHARGE_CLASS_CODE_NN
"CODE" IS NOT NULL CHA_CODE_NN
DEFAULT_ON_ENTRY_FLAG IN ( 'Y' , 'N' ) CHA_DEF_ENTRY_FLAG_CK
"DISPLAY_FLAG" IS NOT NULL CHA_DISPLAY_FLAG_NN
DV_FLAG IN ( 'Y' , 'N' ) CHA_DV_FLAG_CK
REQUIRE_CLASS_FLAG IN ( 'Y' , 'N' ) CHA_REQ_CLASS_FLAG_CK
REQUIRE_TYPE_FLAG IN ( 'Y' , 'N' ) CHA_REQ_TYPE_FLAG_CK

Indexes:
Column(s) Type Sort Constraint Name
CODE Primary key Asc CHA_PK
ACT Performance Asc CHA_ACT_I
ARREST_CHARGE_CODE Performance Asc CHA_ARRCHRGCD_FK_I
CHARGE_CLASS_CODE + CHARGE_CATEGORY_CODE Performance Asc/Asc CHA_CCC1_FK_I
CHAPTER Performance Asc CHA_CHAPTER_I
CHA_DESC + CODE + STATUTE_NEW Performance Asc/Asc/Asc CHA_CODE_I
CHA_DESC + CODE + STATUTE Performance Asc/Asc/Asc CHA_DESC_I
OFFNS_CD_OFFENSE_CODE Performance Asc CHA_OFFNS_CD_FK_I
SECTION Performance Asc CHA_SECTION_I

Close relationships  within of separation: