Table slot9.WORLD.TSTA.CALL_TYPE_CODES
This table defines the valid types of CALLS FOR SERVICE (e.g. Burglary, Battery, Car Jacking)
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
CALL_TYPE_CODE varchar2 30
BI_CALLS_FOR_SERVICE_VW.CALL_TYPE_CODE Implied Constraint R
DISPATCH_SEARCH_VW.CALL_TYPE_CODE Implied Constraint R
JS_CALLS_FOR_SERVICE_VW.CALL_TYPE_CODE Implied Constraint R
AGENCY_CODE varchar2 30
AGENCY_CODES.AGENCY_CODE CALLTYPECD_AGNCY_CD_FK R
CALL_TYPE_DESC varchar2 4000  √  null
ACTIVE varchar2 1  √  'Y'
EVENT_TYPE_CODE varchar2 30  √  null
DISPATCH_EVENT_TYPES.EVENT_TYPE_CODE CALLTYPECD_DISET_FK R
CALL_PRIORITY varchar2 30  √  null
EJS_CODES.CODE CALLTYPECD_EJS_CODES_FK R
CALL_PRIORITY_TYPE varchar2 30  √  null
EJS_CODES.CODE_TYPE CALLTYPECD_EJS_CODES_FK R
CREATE_INCIDENT_FLAG varchar2 1  √  'Y' Y/N flag indicating if incident should be created for this call type. Used by CAD interface.
SHARE_EXTERNAL varchar2 1  √  'N' Y/N flag indicating if the dispatch event should be shared externally for this call type.

Analyzed at Mon Sep 20 21:05 MDT 2021

Requirements (check constraints):
Constraint Constraint Name
"AGENCY_CODE" IS NOT NULL CALLTYPECD_AGENCY_CODE_NN
"CALL_TYPE_CODE" IS NOT NULL CALLTYPECD_CALL_TYPE_CD_NN
CREATE_INCIDENT_FLAG IN ( 'Y','N') CK_CALLTYPECD_CREATE_INCIDENT

Indexes:
Column(s) Type Sort Constraint Name
CALL_TYPE_CODE Primary key Asc CALLTYPECD_PK
AGENCY_CODE Performance Asc CALLTYPECD_AGNCY_CD_FK_I
EVENT_TYPE_CODE Performance Asc CALLTYPECD_DISET_FK_I
CALL_PRIORITY_TYPE + CALL_PRIORITY Performance Asc/Asc CALLTYPECD_EJS_CODES_FK_I

Close relationships  within of separation: