Table slot9.WORLD.TSTA.CHARGE_CATEGORY_CODES
This table defines the valid categories for charges
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
CHARGE_CATEGORY_CODE varchar2 2
CHARGE_CLASS_CODES.CHARGE_CATEGORY_CODE CCC1_CCC_FK R
CHARGE_OFFENSE_VW.CHARGE_CATEGORY_CODE Implied Constraint R
WARRANT_ARREST_CHARGES.CHARGE_CATEGORY_CODE WAC_CCC_FK R
WARRANT_CHARGES.CHARGE_CATEGORY_CODE WCHG_CCC_FK R
WARRANT_FREETEXT_CHARGES.CHARGE_CATEGORY_CODE WFTC_CCC_FK R
ZZ_CHARGE_CODES.CHARGE_CATEGORY_CODE Implied Constraint R
ZZC1_CHARGE_CODES.CHARGE_CATEGORY_CODE Implied Constraint R
ZZV1_CHARGE_CODES.CHARGE_CATEGORY_CODE Implied Constraint R
DESCRIPTION varchar2 30  √  null
RANK number 0  √  null
SEND_LIVESCAN varchar2 1  √  null
REC_ID number 0  √  null
ACTIVE_FLAG varchar2 1  √  'Y'

Analyzed at Mon Sep 20 21:05 MDT 2021

Requirements (check constraints):
Constraint Constraint Name
"CHARGE_CATEGORY_CODE" IS NOT NULL CCC_CHARGE_CATEGORY_CODE_NN

Indexes:
Column(s) Type Sort Constraint Name
CHARGE_CATEGORY_CODE Primary key Asc CCC_PK

Close relationships  within of separation: