Table slot9.WORLD.TSTA.INCIDENTS
This table stores the INCIDENT header information entered in the application or uploaded from the CAD-RMS interface
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
INCIDENT_ID number 0
BI_INCIDENTS_VW.INCIDENT_ID Implied Constraint R
CASE_SEARCH_INCIDENTS_VW.INCIDENT_ID Implied Constraint R
COURT_APPEARANCE_SEARCH_VW.INCIDENT_ID Implied Constraint R
COURT_CASE_APP_SEARCH_VW.INCIDENT_ID Implied Constraint R
COURT_CASE_INCS.INC_INCIDENT_ID CRTCASEINC_INC_FK R
COURT_CASE_SEARCH_VW.INCIDENT_ID Implied Constraint R
CRIMINAL_COMPLAINT_INCIDENTS.INC_INCIDENT_ID CCINCS_INC_FK R
DATASET_HEADER_VW.INCIDENT_ID Implied Constraint R
DEL_DISPATCH_EVENT_CASES.INCIDENT_ID Implied Constraint R
DISPATCH_EVENT_CASES.INCIDENT_ID DSPEC_INC_FK R
DS_IBR_MIGRATION_ERRORS.INCIDENT_ID Implied Constraint R
DS_IBR_MODIFY_VALUES_VW.INCIDENT_ID Implied Constraint R
DS_ICR_INC_QRY_SEL_TEMP.INCIDENT_ID Implied Constraint R
DS_ICR_INCIDENT_ERRORS.INCIDENT_ID Implied Constraint R
DS_ICR_INSERT_QUEUE.INCIDENT_ID Implied Constraint R
DS_ICR_OFFENSES.INCIDENT_ID Implied Constraint R
DS_ICR_OFFENSES_GTT.INCIDENT_ID Implied Constraint R
DS_ICR_SEGMENTS.INCIDENT_ID Implied Constraint R
DV_CRASH_INCIDENTS.INCIDENT_ID CRASHINC_INC_FK R
EJS_INC_VLDN_ERRORS.INCIDENT_ID Implied Constraint R
EJS_NOTES_FLASHBACK.INCIDENT_ID Implied Constraint R
EVIDENCE_CUSTODY_VW.INCIDENT_ID Implied Constraint R
INC_CASE_INC_STATUS_VW.INCIDENT_ID Implied Constraint R
INC_CASE_INCIDENTS_VW.INCIDENT_ID Implied Constraint R
INC_CASE_OFFICERS_VW.INCIDENT_ID Implied Constraint R
INC_OFF_CRIME_TARGETS_VW.INCIDENT_ID Implied Constraint R
INC_PAGE_VISITS.INCIDENT_ID Implied Constraint R
INC_SUPP_NARR_APPR_UPDATES.INCIDENT_ID Implied Constraint R
INCIDENT_ACTIONS.INCIDENT_ID INCACT_INC_FK R
INCIDENT_ADDRESS_VW.INCIDENT_ID Implied Constraint R
INCIDENT_ADDRESSES.INCIDENT_ID INC_ADDR_INC_FK C
INCIDENT_BAIR_EXTRACT_VW.INCIDENT_ID Implied Constraint R
INCIDENT_BOLO_PEOPLE_VW.INCIDENT_ID Implied Constraint R
INCIDENT_BOLO_VEHICLES_VW.INCIDENT_ID Implied Constraint R
INCIDENT_BUSINESS_VW.INCIDENT_ID Implied Constraint R
INCIDENT_BUSINESSES.INC_INCIDENT_ID IB_INC_FK C
INCIDENT_CASE_OFFICERS_VW.INCIDENT_ID Implied Constraint R
INCIDENT_CASE_SEARCH_VW.INCIDENT_ID Implied Constraint R
INCIDENT_CLASSIFICATION.INCIDENT_ID INCCLS_INC_FK R
INCIDENT_CLEAR_STATUS_HISTORY.INCIDENT_ID ICLRSH_INC_FK C
INCIDENT_CLEARANCE_STATUS.INCIDENT_ID ICLRS_INC_FK C
INCIDENT_COMBO_MO_NARR_VW.INCIDENT_ID Implied Constraint R
INCIDENT_COMBO_MO_VW.INCIDENT_ID Implied Constraint R
INCIDENT_COMBO_OFCR_VW.INCIDENT_ID Implied Constraint R
INCIDENT_COMBO_PER_VW.INCIDENT_ID Implied Constraint R
INCIDENT_COMBO_VEH_VW.INCIDENT_ID Implied Constraint R
INCIDENT_COMBO_VW.INCIDENT_ID Implied Constraint R
INCIDENT_CRIME_TARGET_VW.INCIDENT_ID Implied Constraint R
INCIDENT_DISPATCH_VW.INCIDENT_ID Implied Constraint R
INCIDENT_EVIDENCE_VW.INCIDENT_ID Implied Constraint R
INCIDENT_GIS_VW.INCIDENT_ID Implied Constraint R
INCIDENT_IBR_MAX_DATES_VW.INCIDENT_ID Implied Constraint R
INCIDENT_IMAGES.INC_INCIDENT_ID II_INC_FK C
INCIDENT_OFF_CRIME_TARGETS_VW.INCIDENT_ID Implied Constraint R
INCIDENT_OFFENSE_MO_VW.INCIDENT_ID Implied Constraint R
INCIDENT_OFFENSE_VW.INCIDENT_ID Implied Constraint R
INCIDENT_OFFICER_VW.INCIDENT_ID Implied Constraint R
INCIDENT_PEOPLE_SEARCH_VW.INCIDENT_ID Implied Constraint R
INCIDENT_PEOPLE_VW.INCIDENT_ID Implied Constraint R
INCIDENT_PERSON_OFFENSES_VW.INCIDENT_ID Implied Constraint R
INCIDENT_PROPERTY_VW.INCIDENT_ID Implied Constraint R
INCIDENT_RECOVERY_VW.INCIDENT_ID Implied Constraint R
INCIDENT_SUPP_NARRATIVE_VW.INCIDENT_ID Implied Constraint R
INCIDENT_SUPP_TEMP.INCIDENT_ID Implied Constraint R
INCIDENT_SUPP_VW.INCIDENT_ID Implied Constraint R
INCIDENT_SUPPLEMENTS.INC_INCIDENT_ID INCSUP_INC_FK C
INCIDENT_TYPES.INCIDENT_ID IT_INC_ID_FK R
INCIDENT_VEHICLE_VW.INCIDENT_ID Implied Constraint R
INCIDENT_WARNING_NOTIFY_LOG.INCIDENT_ID INCWARNOTLG_INC_FK R
INCIDENT_XREFS.INCIDENT_ID IX_INC_FK C
INCIDENT_XREFS_VW.INCIDENT_ID Implied Constraint R
JS_DOMESTIC_VIOLENCE_VW.INCIDENT_ID Implied Constraint R
JS_INCIDENT_ADDRESS_VW.INCIDENT_ID Implied Constraint R
JS_INCIDENT_CASE_SUMMARY_VW.INCIDENT_ID Implied Constraint R
JS_INCIDENT_CASE_VW.INCIDENT_ID Implied Constraint R
JS_INCIDENT_EVIDENCE_VW.INCIDENT_ID Implied Constraint R
JS_INCIDENT_OFFENSE_RANK_VW.INCIDENT_ID Implied Constraint R
JS_INCIDENT_OFFENSE_VW.INCIDENT_ID Implied Constraint R
JS_INCIDENT_OFFNDR_EVIDENCE_VW.INCIDENT_ID Implied Constraint R
JS_INCIDENT_PROPERTY_VW.INCIDENT_ID Implied Constraint R
JS_ODU_CLERY_VW.INCIDENT_ID Implied Constraint R
JS_OFFICER_DAILY_ACTIVITY_VW.INCIDENT_ID Implied Constraint R
JS_OFFICER_DAILY_VW.INCIDENT_ID Implied Constraint R
K9_DEPLOYMENT.INCIDENT_ID K9DEP_INC_FK R
MICR_INCIDENT_HEADER_VW.INCIDENT_ID Implied Constraint R
MO_INCIDENT_OFFENSE_VW.INCIDENT_ID Implied Constraint R
N_INCIDENT_PERSON_OFFENSES_VW.INCIDENT_ID Implied Constraint R
OFFENSES.INC_INCIDENT_ID OFFNSE_INC_FK C
PEOPLE_WARRANTS.INC_INCIDENT_ID PEOPLE_WAR_INC_FK R
PW_INCIDENT_ADDRESS_VW.INCIDENT_ID Implied Constraint R
USI_INCIDENT_FIELDS.INCIDENT_ID USI_INCF_INC_FK R
USRSCRN_INCIDENT_VW.INCIDENT_ID Implied Constraint R
VEHICLE_INCIDENT_VW.INCIDENT_ID Implied Constraint R
Incident ID number assigned
AGNCY_CD_AGENCY_CODE varchar2 30
AGENCY_CODES.AGENCY_CODE INC_AGNCY_CD_FK R
Agency involved
REPORT_DATE date 7 Date incident was reported.
START_DATE date 7  √  null Start date or time of the incident
START_TIME date 7  √  null
END_DATE date 7  √  null End date or time of the incident
END_TIME date 7  √  null
REPORT_TIME date 7  √  null
SUMMARY varchar2 1000  √  null
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
ALCOHOL_RELATED varchar2 1  √  null
COMPUTER_RELATED varchar2 1  √  null
DRUG_RELATED varchar2 1  √  null
GANG_RELATED varchar2 1  √  null
INTERNAL_INCIDENT varchar2 1  √  null
INC_REPORT_NUMBER varchar2 20
REC_ID number 0  √  null
INC_DISP_CODE varchar2 30  √  null
EJS_CODES.CODE INC_EJS_CODE_FK R
INC_DISP_CODE_TYPE varchar2 30  √  'INC_CASE_STATUS_CODES'
EJS_CODES.CODE_TYPE INC_EJS_CODE_FK R
DISPATCH_DATE date 7  √  null
ONSCENE_DATE date 7  √  null
CLEAR_DATE date 7  √  null
PUBLIC_FLAG varchar2 1  √  NULL
CASE_RVW_STATUS_CODE varchar2 30  √  null
EJS_CODES.CODE INC_EJS_CODES_RV_ST_FK R
CASE_RVW_STATUS_CODE_TYPE varchar2 30  √  null
EJS_CODES.CODE_TYPE INC_EJS_CODES_RV_ST_FK R
CARGO_THEFT_CODE_TYPE varchar2 30  √  NULL
EJS_CODES.CODE_TYPE INC_EJSCD_CA_TH_FK R
This column is deprecated. Cargo theft is determined at the offense level. See OFFENSES.CARGO_THEFT_CODE_TYPE
CARGO_THEFT_CODE varchar2 30  √  NULL
EJS_CODES.CODE INC_EJSCD_CA_TH_FK R
This column is deprecated. Cargo theft is determined at the offense level. See OFFENSES.CARGO_THEFT_CODE
REPORTING_AGENCY varchar2 30  √  null Agency Code related to the agency under which the incident will be reported when doing State Data Submissions
LOADED_BY varchar2 30  √  null
LAST_LOAD_DATE date 7  √  null
EXPUNGE varchar2 1  √  'N' Y/N flag to mark an incident as expunged.

Analyzed at Mon Sep 20 21:05 MDT 2021

Requirements (check constraints):
Constraint Constraint Name
"AGNCY_CD_AGENCY_CODE" IS NOT NULL INC_AGNCY_CD_AGENCY_CODE_NN
"INC_REPORT_NUMBER" IS NOT NULL INC_INC_REPORT_NUMBER_NN
"INCIDENT_ID" IS NOT NULL INC_INCIDENT_ID_NN
PUBLIC_FLAG IN ( 'Y','N') INC_PUBLIC_FLAG_CK
"REPORT_DATE" IS NOT NULL INC_REPORT_DATE_NN

Indexes:
Column(s) Type Sort Constraint Name
INCIDENT_ID Primary key Asc INC_PK
AGNCY_CD_AGENCY_CODE Performance Asc INC_AGNCY_CD_FK_I
INC_DISP_CODE_TYPE + INC_DISP_CODE Performance Asc/Asc INC_EJS_CODE_FK_I
CASE_RVW_STATUS_CODE_TYPE + CASE_RVW_STATUS_CODE Performance Asc/Asc INC_EJS_CODES_RV_ST_FK_I
CARGO_THEFT_CODE_TYPE + CARGO_THEFT_CODE Performance Asc/Asc INC_EJSCD_CA_TH_FK_I
PUBLIC_FLAG Performance Asc INC_PUBLIC_FLAG_I
REPORT_DATE Performance Asc INC_REPORT_DATE_I
INC_REPORT_NUMBER + AGNCY_CD_AGENCY_CODE Must be unique Asc/Asc INC_REPORT_NUM_AGENCY_I
REPORTING_AGENCY Performance Asc INC_REPORTING_AGENCY_I

Close relationships  within of separation: