Table slot9.WORLD.TSTA.STAGING_OFFENSES
This table serves as a staging area for the offense management/mass update functions
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
OFFENSE_CODE varchar2 30  √  null
OFFENSE_CODES.OFFENSE_CODE Implied Constraint R
The offense code
OFFENSE_DESC_SHORT varchar2 255  √  null Short description for the offense code
OFFENSE_DESC_LONG varchar2 4000  √  null Long description for the offense code
CHARGE_CODE varchar2 30  √  null The charge code
CHARGE_DESC varchar2 255  √  null Description for the charge code
ARREST_CHARGE_CODE varchar2 30  √  null
ARREST_CHARGE_CODES.ARREST_CHARGE_CODE Implied Constraint R
The arrest charge code
ARREST_CHARGE_DESC varchar2 4000  √  null Description for the arrest charge code
PARENT_NIBRS_CODE varchar2 255  √  null Parent NIBRS code used for offenses codes
IBR_REPORTING_CODE varchar2 255  √  null IBR Reporting code - alternative offense code used for submission
STATUTE varchar2 30  √  null The charge statute code
CLASS_CODE varchar2 2  √  null The charge class code
CATEGORY_CODE varchar2 2  √  null The charge category code
CHARGE_EXPIRE_DATE varchar2 30  √  null Expire date for charge code
NOTES varchar2 255  √  null Customer notes about the requested change to the offense code
ACTION varchar2 30  √  null Describes what action is needed for the offense code (ADD/UPDATE/DEACTIVATE/CORRECT)
DEACTIVATE_OFFENSE_CODE varchar2 1  √  null Y/N flag to deactivate the offense code (when action is DEACTIVATE)
DEACTIVATE_CHARGE_FLAG varchar2 1  √  null Y/N flag to deactivate the charge code (when action is DEACTIVATE)
DEACTIVATE_ARREST_FLAG varchar2 1  √  null Y/N flag to deactivate the arrest charge code (when action is DEACTIVATE)
CHARGE_EFFECTIVE_DATE varchar2 30  √  null Effective date for charge code
ACTIVE_FLAG varchar2 1  √  null Y/N flag if the offense code is active

Analyzed at Mon Sep 20 21:05 MDT 2021


Close relationships: