Table slot9.WORLD.TSTA.DS_ICR_OFFENSES
This table stores Offenses Segment based on a given EXTERNAL_SYSTEM_CODES.CODE populated from DS_ICR Package when Incident is Approved 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
HEADERID number 0
DS_ICR_HEADERS.HEADERID DSICROFF_DSICRHD_FK R
ORECNO number 0 Offense Counter [Part of Primary Key]
FILECL varchar2 255  √  null Data Element 14 (Offense File Class)
SITE varchar2 255  √  null Data Element 15 (Location Site)
OFFATT varchar2 255  √  null Data Element 16 (Offense Attempted/Completed)
OFFSOU1 varchar2 255  √  null Data Element 17a (Offender Suspected of Using)
OFFSOU2 varchar2 255  √  null Data Element 17b (Offender Suspected of Using)
OFFSOU3 varchar2 255  √  null Data Element 17c (Offender Suspected of Using)
BIAS varchar2 255  √  null Data Element 18 (Suspected bias Motivation)
WEAPON varchar2 255  √  null Data Element 19 (Weapon Type)
ACTTYPE1 varchar2 255  √  null Data Element 20a (Activity Type [1])
ACTTYPE2 varchar2 255  √  null Data Element 20b (Activity Type [2])
ACTTYPE3 varchar2 255  √  null Data Element 20c (Activity Type [3])
PREMISES varchar2 255  √  null Data Element 21 (Number of Premises Entered)
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
REC_ID number 0  √  null
WEAPON2 varchar2 255  √  null NIBR Data Element 13 (Weapon Type)
WEAPON3 varchar2 255  √  null NIBR Data Element 13 (Weapon Type)
METHODOE varchar2 255  √  null NIBR Data Element 11 (Method of Entry)
OFFGRPCD varchar2 255  √  null NIBR Offense Group Code
NIBRSOFFCD varchar2 255  √  null NIBRS Offense Code
INCIDENT_ID number 0  √  null
INCIDENTS.INCIDENT_ID Implied Constraint R
INCIDENTS.INCIDENT_ID - Part of PK back to Original Offense
SUPP_SEQ number 0  √  null INCIDENT_SUPPLEMENTS.SUPP_SEQ - Part of PK back to Original Offense
OFFENSE_NUMBER number 0  √  null OFFENSES.OFFENSE_NUMBER - Part of PK back to Original Offense
UCR_NUMBER number 0  √  null

Analyzed at Mon Sep 20 21:05 MDT 2021

Requirements (check constraints):
Constraint Constraint Name
"HEADERID" IS NOT NULL DSICROFF_HEADERID_NN
"ORECNO" IS NOT NULL DSICROFF_ORECNO_NN

Indexes:
Column(s) Type Sort Constraint Name
HEADERID + ORECNO Primary key Asc/Asc DSICROFF_PK
HEADERID Performance Asc DSICROFF_DSICRHD_FK_I

Close relationships  within of separation: