Table slot9.WORLD.TSTA.INCIDENT_ROUTES
This table stores the notification route template information for routing INCIDENTS based on agency and offenses
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
ROUTE_ID number 0
INC_CASE_ROUTING.ROUTE_ID Implied Constraint R
INC_REVIEW_TYPES.ROUTE_ID Implied Constraint R
INCIDENT_ROUTE_ORIG_AGENCIES.ROUTE_ID INCRTEOA_INCRTE_FK R
INCIDENT_ROUTE_STATUSES.ROUTE_ID INCRS_INCRTE_FK R
INCIDENT_ROUTE_VW.ROUTE_ID Implied Constraint R
OFFENSE_CODE varchar2 30  √  null
OFFENSE_CODES.OFFENSE_CODE INCRTE_OFFNS_CD_FK R
OFFENSE_CODE
STATUS_CODE varchar2 30  √  null
EJS_CODES.CODE INCRTE_EJS_CODES_STATUS_FK R
STATUS_CODE
STATUS_CODE_TYPE varchar2 30  √  null
EJS_CODES.CODE_TYPE INCRTE_EJS_CODES_STATUS_FK R
STATUS_CODE_TYPE
DEST_AGENCY_CODE varchar2 100  √  null
AGENCY_CODES.AGENCY_CODE INCRTE_AGNCY_CD_FK R
DEST_AGENCY_CODE
NOTIFY_TYPE_CODE number 8  √  null
NOTIFICATION_DEF_MASTERS.NOTIFY_TYPE_CD INCRTE_NDM_FK R
NOTIFY_TYPE_CODE
REQUIRED_FLAG varchar2 1  √  null REQUIRED_FLAG
CREATOR_ID varchar2 100  √  null CREATOR_ID
CREATOR_DATE date 7  √  null CREATOR_DATE
UPDATOR_ID varchar2 100  √  null UPDATOR_ID
UPDATOR_DATE date 7  √  null UPDATOR_DATE
ANY_SUPP_FLAG varchar2 1  √  'N' If Y, then this route will be applied to all offenses in the incident regardless of the supplement approved

Analyzed at Mon Sep 20 21:05 MDT 2021

Requirements (check constraints):
Constraint Constraint Name
ANY_SUPP_FLAG IN ('Y', 'N') CK_INCRTE_ANY_SUPP_FLAG
REQUIRED_FLAG IN ('Y', 'N') CK_INCRTE_REQUIRED_FLAG
"ROUTE_ID" IS NOT NULL INCRTE_ROUTE_ID_NN

Indexes:
Column(s) Type Sort Constraint Name
ROUTE_ID Primary key Asc INCRTE_PK
DEST_AGENCY_CODE Performance Asc INCRTE_AGNCY_CD_FK_I
STATUS_CODE_TYPE + STATUS_CODE Performance Asc/Asc INCRTE_EJS_CODES_STATUS_FK_I
NOTIFY_TYPE_CODE Performance Asc INCRTE_NDM_FK_I
OFFENSE_CODE Performance Asc INCRTE_OFFNS_CD_FK_I

Close relationships  within of separation: