Table slot9.WORLD.TSTA.OFFENSE_STATUS_CODES
This table defines offense statuses and NIBRS clearance information to be used on offenses on an INCIDENT 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
OFFENSE_STATUS_CODE varchar2 2
INCIDENT_CASE_STATUS_HISTORY.UCR_STATUS ICS_HSTRY_OFFNSE_CD_FK R
INCIDENT_CLEAR_STATUS_HISTORY.OFFENSE_STATUS_CODE ICLRSH_OFFNSE_CD_FK C
INCIDENT_CLEARANCE_STATUS.OFFENSE_STATUS_CODE ICLRS_OFFNSE_CD_FK C
INCIDENT_COMBO_MO_NARR_VW.OFFENSE_STATUS_CODE Implied Constraint R
INCIDENT_COMBO_MO_VW.OFFENSE_STATUS_CODE Implied Constraint R
INCIDENT_CRIME_TARGET_VW.OFFENSE_STATUS_CODE Implied Constraint R
INCIDENT_PERSON_OFFENSES_VW.OFFENSE_STATUS_CODE Implied Constraint R
JS_INCIDENT_EVIDENCE_VW.OFFENSE_STATUS_CODE Implied Constraint R
JS_INCIDENT_OFFENSE_RANK_VW.OFFENSE_STATUS_CODE Implied Constraint R
JS_INCIDENT_OFFENSE_VW.OFFENSE_STATUS_CODE Implied Constraint R
JS_INCIDENT_OFFNDR_EVIDENCE_VW.OFFENSE_STATUS_CODE Implied Constraint R
N_INCIDENT_PERSON_OFFENSES_VW.OFFENSE_STATUS_CODE Implied Constraint R
OFFENSES.OFFNSE_CD_OFFENSE_STATUS_CODE OFFNSE_OFFNSE_CD_FK R
Status code @ reporting
OFFENSE_STATUS_DESC varchar2 80  √  null Status Description
ENIBR_EXCEPTION_CLEARANCE_CODE varchar2 30  √  null
EJS_CODES.CODE OFFNSE_CD_ENIBR_EX_EJS_CODE_FK R
ENIBR_EXCEPTION_CLEARANCE_TYPE varchar2 30  √  null
EJS_CODES.CODE_TYPE OFFNSE_CD_ENIBR_EX_EJS_CODE_FK R
REC_ID number 0  √  null

Analyzed at Mon Sep 20 21:05 MDT 2021

Requirements (check constraints):
Constraint Constraint Name
"OFFENSE_STATUS_CODE" IS NOT NULL OFFNSE_CD_OFFENSE_STATUS_CO_NN

Indexes:
Column(s) Type Sort Constraint Name
OFFENSE_STATUS_CODE Primary key Asc OFFNSE_CD_PK
ENIBR_EXCEPTION_CLEARANCE_TYPE + ENIBR_EXCEPTION_CLEARANCE_CODE Performance Asc/Asc OFFNSE_CD_ENIBR_EX_EJS_CODE_I
ENIBR_EXCEPTION_CLEARANCE_CODE Performance Asc OFFNSE_CD_EXCP_CLR_C_FK_I

Close relationships  within of separation: