Table slot9.WORLD.TSTA.INCIDENT_SUPPLEMENTS
This tables stores the supplement information for each supplement of an INCIDENT, including supplement 0 - the initial INCIDENT report
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
ACTIVITY_HEADERS.INCIDENT_ID ACTHD_INCSUP_FK R
DV_CRASH_INCIDENTS.INCIDENT_ID CRASHINC_INCSUP_FK R
INC_CASE_INCIDENTS.INCIDENT_ID ICI_INCSUP_FK C
INC_COMMENT_GROUPS.INCIDENT_ID INCCOMGRP_INCSUP_FK C
INC_REVIEW_ROUTE_INSTANCES.INCIDENT_ID INCRVWRTINST_INCSUP_FK R
INC_SUPP_NARRATIVES.INCIDENT_ID INC_SUPP_NARR_SUPP_FK R
INC_USER_RESTORE_POINTS.INCIDENT_ID IURP_INCSUP_FK R
INCIDENT_ARRESTS.INCSUP_INC_INCIDENT_ID IA_INCSUP_FK C
INCIDENT_ATTACHMENTS.INC_INCIDENT_ID INCATT_INCSUP_FK C
INCIDENT_CITATIONS.INC_INCIDENT_ID INC_CIT_INCSUP_FK C
INCIDENT_EMPLOYEES.INCIDENT_ID INC_SUPP_EMP_FK R
INCIDENT_FLDINTS.INC_INCIDENT_ID INCFLD_INCSUP_FK C
INCIDENT_GANGS.INCSUP_INC_INCIDENT_ID INC_GANG_INCSUP_FK C
INCIDENT_IMPOUNDS.INC_INCIDENT_ID INC_IMP_INCSUP_FK C
INCIDENT_LOCATIONS.INCIDENT_ID INC_LOC_INCSUP_FK C
INCIDENT_NOTIFY_HISTORY.INCIDENT_ID INH_INCSUP_FK R
INCIDENT_PEOPLE.INC_INCIDENT_ID INCPER_INCSUP_FK C
INCIDENT_PROPERTIES.INCSUP_INCIDENT_ID INCPRO_INCSUP_FK C
INCIDENT_SUPPLEMENT_DRUGS.INCIDENT_ID INCSUPDG_INCSUP_FK R
INCIDENT_SUPPLEMENT_MARIJ.INCIDENT_ID INCSUPMJ_INCSUP_FK R
INCIDENT_SUPPLEMENT_PRECHEMS.INCIDENT_ID INCSUPPC_INCSUP_FK R
INCIDENT_VEHICLES.INCIDENT_ID INCVEH_INCSUP_FK R
INCIDENT_WARRANTS.INC_INCIDENT_ID INC_WAR_INCSUP_FK C
INCIDENT_WORKGROUPS.INC_INCIDENT_ID INC_INC_WRKGRP_FK R
INCIDENT_XREFS.PARENT_INCIDENT_ID IX_INCSUP_FK C
MODUS_OPERANDI.INCIDENT_ID MO_INCSUP_FK C
OFFICER_INCIDENTS.INC_INCIDENT_ID OFFINC_INCSUP_FK C
USI_INCIDENTS.INCIDENT_ID USI_INC_INCSUP_FK R
INCIDENTS.INCIDENT_ID INCSUP_INC_FK C
Incident ID number assigned
SUPP_SEQ number 0
ACTIVITY_HEADERS.SUPP_SEQ ACTHD_INCSUP_FK R
DV_CRASH_INCIDENTS.SUPP_SEQ CRASHINC_INCSUP_FK R
INC_CASE_INCIDENTS.SUPP_SEQ ICI_INCSUP_FK C
INC_COMMENT_GROUPS.SUPPLEMENT_ID INCCOMGRP_INCSUP_FK C
INC_REVIEW_ROUTE_INSTANCES.SUPP_SEQ INCRVWRTINST_INCSUP_FK R
INC_SUPP_NARRATIVES.SUPP_SEQ INC_SUPP_NARR_SUPP_FK R
INC_USER_RESTORE_POINTS.SUPP_SEQ IURP_INCSUP_FK R
INCIDENT_ARRESTS.INCSUP_SUPP_SEQ IA_INCSUP_FK C
INCIDENT_ATTACHMENTS.SUPP_SEQ INCATT_INCSUP_FK C
INCIDENT_CITATIONS.SUPP_SEQ INC_CIT_INCSUP_FK C
INCIDENT_EMPLOYEES.SUPP_SEQ INC_SUPP_EMP_FK R
INCIDENT_FLDINTS.SUPP_SEQ INCFLD_INCSUP_FK C
INCIDENT_GANGS.INCSUP_SUPP_SEQ INC_GANG_INCSUP_FK C
INCIDENT_IMPOUNDS.SUPP_SEQ INC_IMP_INCSUP_FK C
INCIDENT_LOCATIONS.SUPP_SEQ INC_LOC_INCSUP_FK C
INCIDENT_NOTIFY_HISTORY.SUPP_SEQ INH_INCSUP_FK R
INCIDENT_PEOPLE.SUPP_SEQ INCPER_INCSUP_FK C
INCIDENT_PROPERTIES.INCSUP_SUPP_SEQ INCPRO_INCSUP_FK C
INCIDENT_SUPPLEMENT_DRUGS.SUPP_SEQ INCSUPDG_INCSUP_FK R
INCIDENT_SUPPLEMENT_MARIJ.SUPP_SEQ INCSUPMJ_INCSUP_FK R
INCIDENT_SUPPLEMENT_PRECHEMS.SUPP_SEQ INCSUPPC_INCSUP_FK R
INCIDENT_VEHICLES.SUPP_SEQ INCVEH_INCSUP_FK R
INCIDENT_WARRANTS.SUPP_SEQ INC_WAR_INCSUP_FK C
INCIDENT_WORKGROUPS.SUPP_SEQ INC_INC_WRKGRP_FK R
INCIDENT_XREFS.PARENT_SUPP_SEQ IX_INCSUP_FK C
MODUS_OPERANDI.SUPP_SEQ MO_INCSUP_FK C
OFFICER_INCIDENTS.SUPP_SEQ OFFINC_INCSUP_FK C
USI_INCIDENTS.SUPP_SEQ USI_INC_INCSUP_FK R
Supplement Sequence Number 1 = Original Report
ISC_STATUS_CODE varchar2 30
EJS_CODES.CODE INCSUP_ISC_STATUS__EJS_CODE_FK R
Status Code for Incident (Initial, Pending etc.)
SUPP_REPORT_DATE date 7 Supplemental Report Date
SUPP_REPORT_TIME date 7 Supplemental Report Time
SUPERVISOR_NOTE varchar2 1000  √  null Supervisor Note to Officer
CREATOR_ID varchar2 100  √  null User ID of user Creating Record
CREATOR_DATE date 7  √  null Creation Date of Record
UPDATOR_ID varchar2 100  √  null User ID of user Updating Record
UPDATOR_DATE date 7  √  null Date of Last update of Record
FORWARD_TO_SA varchar2 1  √  null
NOTIFY_CID varchar2 1  √  null
RESPONSIBLE_USER_ID varchar2 100  √  null
APPROVAL_DATE date 7  √  null
APPROVAL_USER_ID varchar2 100  √  null
AGENCY_ONLY varchar2 1  √  'N'
SECURITY_LEVEL number 38  √  null
INCIDENT_SECURITY_LEVEL_CODES.INC_SEC_LEVEL_CODE INCSUP_INC_SEC_LVL_FK R
CID varchar2 1  √  null
NOTIFY_CHILD varchar2 1  √  null
NOTIFY_DV varchar2 1  √  null
SUPP_AGENCY_CODE varchar2 30  √  null
AGENCY_CODES.AGENCY_CODE INCSUP_AGNCY_CD_FK R
ISC_STATUS_CODE_TYPE varchar2 30  √  'INCIDENT_STATUS_CODES'
EJS_CODES.CODE_TYPE INCSUP_ISC_STATUS__EJS_CODE_FK R
REC_ID number 0  √  null
UNK_NO_OFFENDERS varchar2 1  √  'N'
DS_ICR_DATE date 7  √  null Date that determines that this record is ready for State submission. Default date is the approved date.
DS_ICR_SUBMISSION_STATUS varchar2 30  √  null
EJS_CODES.CODE INCSUP_DS_STATUS_EJS_CODE_FK R
DS_ICR_SUBMISSION_STATUS_TYP varchar2 30  √  null
EJS_CODES.CODE_TYPE INCSUP_DS_STATUS_EJS_CODE_FK R
APPROVING_AGENCY_CODE varchar2 30  √  null
AGENCY_CODES.AGENCY_CODE INCSUP_AGNCY_CD_APPR_FK R
RESTRICT_SG_EXCLSV_FLAG varchar2 1 'N'
INC_HRS_WRKD number 5,1  √  null
RESPONSIBLE_AGENCY_CODE varchar2 30  √  null
AGENCY_CODES.AGENCY_CODE INCSUP_RSP_AGNCY_CD_FK R
LOADED_BY varchar2 30  √  null
LAST_LOAD_DATE date 7  √  null
COMMENT_GROUP_ID number 0  √  null
INC_COMMENT_GROUPS.ID INCSUP_INCCOMGRP_FK R
DEFAULT_SECURITY_TEMPLATE varchar2 1  √  'N'

Analyzed at Mon Sep 20 21:05 MDT 2021

Requirements (check constraints):
Constraint Constraint Name
RESTRICT_SG_EXCLSV_FLAG IN('Y','N') CK_INCSUP_RSTRCT_SG_EXCL_FLG
"INC_INCIDENT_ID" IS NOT NULL INCSUP_INC_INCIDENT_ID_NN
"ISC_STATUS_CODE" IS NOT NULL INCSUP_ISC_STATUS_CODE_NN
"RESTRICT_SG_EXCLSV_FLAG" IS NOT NULL INCSUP_RESTRCT_SG_EXCL_FLG_NN
"SUPP_REPORT_DATE" IS NOT NULL INCSUP_SUPP_REPORT_DATE_NN
"SUPP_REPORT_TIME" IS NOT NULL INCSUP_SUPP_REPORT_TIME_NN
"SUPP_SEQ" IS NOT NULL INCSUP_SUPP_SEQ_NN

Indexes:
Column(s) Type Sort Constraint Name
INC_INCIDENT_ID + SUPP_SEQ Primary key Asc/Asc INCSUP_PK
INC_INCIDENT_ID + ISC_STATUS_CODE + APPROVAL_DATE Performance Asc/Asc/Asc ICS_ID_STATUS_DATE_I
APPROVING_AGENCY_CODE Performance Asc INCSUP_AGNCY_CD_APPR_FK_I
SUPP_AGENCY_CODE Performance Asc INCSUP_AGNCY_CD_FK_I
RESPONSIBLE_AGENCY_CODE Performance Asc INCSUP_AGNCY_CD_RESP_FK_I
DS_ICR_SUBMISSION_STATUS_TYP + DS_ICR_SUBMISSION_STATUS Performance Asc/Asc INCSUP_DS_STATUS_EJS_CODE_FK_I
INC_INCIDENT_ID Performance Asc INCSUP_INC_FK_I
SECURITY_LEVEL Performance Asc INCSUP_INC_SEC_LVL_FK_I
COMMENT_GROUP_ID Performance Asc INCSUP_INCCOMGRP_FK_I
ISC_STATUS_CODE Performance Asc INCSUP_ISC_FK_I
ISC_STATUS_CODE_TYPE + ISC_STATUS_CODE Performance Asc/Asc INCSUP_ISC_STATUS__EJS_CODE_I
INC_INCIDENT_ID + ISC_STATUS_CODE + SUPP_REPORT_DATE Performance Asc/Asc/Asc INCSUP_REPORT_DATE_I
RESPONSIBLE_USER_ID Performance Asc INCSUP_RESP_USR_I

Close relationships  within of separation: