Table slot9.WORLD.TSTA.OFFENSES
This table stores offenses added to an INCIDENT supplement 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
INC_INCIDENT_ID number 0
ARRESTEES.OFFNSE_INC_INCIDENT_ID ARR1_OFFNSE_FK C
INC_VEH_OFFENSES.INCIDENT_ID IVO_OFFNSE_FK C
INCIDENT_PEOPLE_OFFENSES.OFFNSE_INC_INCIDENT_ID IPO_OFFNSE_FK C
INCIDENT_PROPERTIES.OFFENSE_INCIDENT_ID INCPRO_OFFNSE_FK C
MODUS_OPERANDI.INCIDENT_ID_OFFENSE MO_OFFNSE_FK C
OFFENDER_SUSPICIONS.OFFNSE_INC_INCIDENT_ID OFF_SUSP_OFFNSE_FK C
OFFENSE_ACTIVITIES.OFFNSE_INC_INCIDENT_ID OA_OFFNSE_FK C
OFFENSE_CIRCUMSTANCES.OFFNSE_INC_INCIDENT_ID OC_OFFNSE_FK C
OFFENSE_GANGS.OFFNSE_INC_INCIDENT_ID OFF_GANG_OFFNSE_FK C
OFFENSE_HOMICIDE_CIRCUMSTANCES.OFFNSE_INC_INCIDENT_ID OH_CIRCUM_OFFNSE_FK C
USI_OFFENSES.INCIDENT_ID USI_OFF_OFFNSE_FK R
VICTIM_ARRESTEES.OFFNSE_INC_INCIDENT_ID VA_OFFNSE_FK C
WEAPONS.OFFNSE_INC_INCIDENT_ID WEA_OFFNSE_FK C
INCIDENTS.INCIDENT_ID OFFNSE_INC_FK C
Incident ID number assigned
OFFENSE_NUMBER number 0
ARRESTEES.OFFNSE_OFFENSE_NUMBER ARR1_OFFNSE_FK C
INC_VEH_OFFENSES.OFFENSE_NUMBER IVO_OFFNSE_FK C
INCIDENT_PEOPLE_OFFENSES.OFFNSE_OFFENSE_NUMBER IPO_OFFNSE_FK C
INCIDENT_PROPERTIES.OFFENSE_NUMBER INCPRO_OFFNSE_FK C
MODUS_OPERANDI.OFFENSE_NUMBER MO_OFFNSE_FK C
OFFENDER_SUSPICIONS.OFFNSE_OFFENSE_NUMBER OFF_SUSP_OFFNSE_FK C
OFFENSE_ACTIVITIES.OFFNSE_OFFENSE_NUMBER OA_OFFNSE_FK C
OFFENSE_CIRCUMSTANCES.OFFNSE_OFFENSE_NUMBER OC_OFFNSE_FK C
OFFENSE_GANGS.OFFNSE_OFFENSE_NUMBER OFF_GANG_OFFNSE_FK C
OFFENSE_HOMICIDE_CIRCUMSTANCES.OFFNSE_OFFENSE_NUMBER OH_CIRCUM_OFFNSE_FK C
USI_OFFENSES.OFFENSE_NUMBER USI_OFF_OFFNSE_FK R
VICTIM_ARRESTEES.OFFNSE_OFFENSE_NUMBER VA_OFFNSE_FK C
WEAPONS.OFFNSE_OFFENSE_NUMBER WEA_OFFNSE_FK C
Number assigned to track the offense
OFFNSE_CD_OFFENSE_STATUS_CODE varchar2 2  √  null
OFFENSE_STATUS_CODES.OFFENSE_STATUS_CODE OFFNSE_OFFNSE_CD_FK R
Status code @ reporting
OFFNS_CD_OFFENSE_CODE varchar2 30
OFFENSE_CODES.OFFENSE_CODE OFFNSE_OFFNS_CD_FK R
PLACE_PLACE_CODE varchar2 30  √  null
EJS_CODES.CODE OFFNSE_PLACE_EJS_CODES_FK R
Specfic Location Code
PRO_PROPERTY_ID number 0  √  null
PROPERTIES.PROPERTY_ID OFFNSE_PROP_FK R
FEC_FORCED_ENTRY_CODE varchar2 30  √  null
EJS_CODES.CODE OFFNSE_FEC_FORCED__EJS_CODE_FK R
Forced Entry - Y, N, or NA
PREMISES number 38  √  null
SUPP_SEQ number 5
ARRESTEES.OFFNSE_SUPP_SEQ ARR1_OFFNSE_FK C
INC_VEH_OFFENSES.SUPP_SEQ IVO_OFFNSE_FK C
INCIDENT_PEOPLE_OFFENSES.OFFNSE_SUPP_SEQ IPO_OFFNSE_FK C
INCIDENT_PROPERTIES.OFFENSE_SUPP_SEQ INCPRO_OFFNSE_FK C
MODUS_OPERANDI.SUPP_SEQ_OFFENSE MO_OFFNSE_FK C
OFFENDER_SUSPICIONS.OFFNSE_SUPP_SEQ OFF_SUSP_OFFNSE_FK C
OFFENSE_ACTIVITIES.OFFNSE_SUPP_SEQ OA_OFFNSE_FK C
OFFENSE_CIRCUMSTANCES.OFFNSE_SUPP_SEQ OC_OFFNSE_FK C
OFFENSE_GANGS.OFFNSE_SUPP_SEQ OFF_GANG_OFFNSE_FK C
OFFENSE_HOMICIDE_CIRCUMSTANCES.OFFNSE_SUPP_SEQ OH_CIRCUM_OFFNSE_FK C
USI_OFFENSES.SUPP_SEQ USI_OFF_OFFNSE_FK R
VICTIM_ARRESTEES.OFFNSE_SUPP_SEQ VA_OFFNSE_FK C
WEAPONS.OFFNSE_SUPP_SEQ WEA_OFFNSE_FK C
REMARKS varchar2 255  √  null Action taked on this offemse
UCR_NUMBER number 0  √  null
OFFENSE_STATUS_DATE date 7  √  null Last status date on this offense
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
DVU varchar2 1  √  null
CAC varchar2 1  √  null
CAMPUS_CODE varchar2 30  √  null
EJS_CODES.CODE OFFNSE_CAMPUS_CODE_EJS_CODE_FK R
CHARGE_CODE varchar2 30  √  null
CHARGE_CODES.CODE OFFNSE_CHA_FK R
The related charge associated with the offense.
CAMPUS_CODE_TYPE varchar2 30  √  null
EJS_CODES.CODE_TYPE OFFNSE_CAMPUS_CODE_EJS_CODE_FK R
FEC_FORCED_ENTRY_CODE_TYPE varchar2 30  √  null
EJS_CODES.CODE_TYPE OFFNSE_FEC_FORCED__EJS_CODE_FK R
BIAS_CODE_TYPE varchar2 30  √  null
EJS_CODES.CODE_TYPE OFFNSE_BIAS_EJS_CODES_FK R
BIAS_CODE varchar2 30  √  null
EJS_CODES.CODE OFFNSE_BIAS_EJS_CODES_FK R
AC_CODE_TYPE varchar2 30  √  null
EJS_CODES.CODE_TYPE OFFNSE_AC_EJS_CODES_FK R
AC_CODE varchar2 30  √  null
EJS_CODES.CODE OFFNSE_AC_EJS_CODES_FK R
PLACE_CODE_TYPE varchar2 30  √  null
EJS_CODES.CODE_TYPE OFFNSE_PLACE_EJS_CODES_FK R
REC_ID number 0  √  null
ARREST_CHARGE_CODE varchar2 30  √  null
ARREST_CHARGE_CODES.ARREST_CHARGE_CODE OFFNSE_ARRCHRGCD_FK R
DV_RELATED_CODE_TYPE varchar2 30  √  'DV_RELATED'
DV_RELATED_CODE varchar2 30  √  'N'
LOADED_BY varchar2 30  √  null
LAST_LOAD_DATE date 7  √  null
CARGO_THEFT_CODE varchar2 30  √  null
EJS_CODES.CODE OFFNSE_CARGO_EJS_CODES_FK R
Whether the offense is cargo theft related or not
CARGO_THEFT_CODE_TYPE varchar2 30  √  null
EJS_CODES.CODE_TYPE OFFNSE_CARGO_EJS_CODES_FK R

Analyzed at Mon Sep 20 21:05 MDT 2021

Requirements (check constraints):
Constraint Constraint Name
"INC_INCIDENT_ID" IS NOT NULL OFFNSE_INC_INCIDENT_ID_NN
"OFFENSE_NUMBER" IS NOT NULL OFFNSE_OFFENSE_NUMBER_NN
"OFFNS_CD_OFFENSE_CODE" IS NOT NULL OFFNSE_OFFNS_CD_OFFENSE_COD_NN

Indexes:
Column(s) Type Sort Constraint Name
INC_INCIDENT_ID + OFFENSE_NUMBER + SUPP_SEQ Primary key Asc/Asc/Asc OFFNSE_PK
AC_CODE_TYPE + AC_CODE Performance Asc/Asc OFFNSE_AC_EJS_CODES_FK_I
ARREST_CHARGE_CODE Performance Asc OFFNSE_ARRCHRGCD_FK_I
BIAS_CODE_TYPE + BIAS_CODE Performance Asc/Asc OFFNSE_BIAS_EJS_CODES_FK_I
CAMPUS_CODE Performance Asc OFFNSE_CAMPCD_FK_I
CAMPUS_CODE_TYPE + CAMPUS_CODE Performance Asc/Asc OFFNSE_CAMPUS_CODE_EJS_CODE_I
CARGO_THEFT_CODE_TYPE + CARGO_THEFT_CODE Performance Asc/Asc OFFNSE_CARGO_EJS_CODES_FK_I
CHARGE_CODE Performance Asc OFFNSE_CHA_FK_I
FEC_FORCED_ENTRY_CODE Performance Asc OFFNSE_FEC_FK_I
FEC_FORCED_ENTRY_CODE_TYPE + FEC_FORCED_ENTRY_CODE Performance Asc/Asc OFFNSE_FEC_FORCED__EJS_CODE_I
INC_INCIDENT_ID Performance Asc OFFNSE_INC_FK_I
OFFNS_CD_OFFENSE_CODE Performance Asc OFFNSE_OFFNS_CD_FK_I
OFFNSE_CD_OFFENSE_STATUS_CODE Performance Asc OFFNSE_OFFNSE_CD_FK_I
PLACE_CODE_TYPE + PLACE_PLACE_CODE Performance Asc/Asc OFFNSE_PLACE_EJS_CODES_FK_I
PRO_PROPERTY_ID Performance Asc OFFNSE_PROP_FK_I

Close relationships  within of separation: