Table slot9.WORLD.TSTA.DISPATCH_EVENTS
This table stores dispatch event information (referred to as Calls For Service in the application) as created in the application or loaded through 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
DISPATCH_ID number 38
ACTIVITY_HEADERS.DISPATCH_ID ACTHD_DISPTCH_FK R
ARREST_CFS_SEARCH_VW.DISPATCH_ID Implied Constraint R
ARREST_DISPATCHES.DISPATCH_ID ARRDISP_DISPTCH_FK C
BI_CALLS_FOR_SERVICE_VW.DISPATCH_ID Implied Constraint R
DEL_DISPATCH_EVENT_CASES.DISPATCH_ID Implied Constraint R
DEL_DISPATCH_EVENT_OFFICERS.DISPATCH_ID Implied Constraint R
DEL_DISPATCH_EVENTS.DISPATCH_ID Implied Constraint R
DISPATCH_EVENT_ATTACHMENTS.DISPATCH_ID DISPATT_DISPTCH_FK C
DISPATCH_EVENT_CASES.DISPATCH_ID DSPEC_DISPTCH_FK C
DISPATCH_EVENT_IMAGES.DISPATCH_ID DISPIMA_DISPTCH_FK C
DISPATCH_EVENT_OFFICERS.DISPATCH_ID DSPEO_DISPTCH_FK C
DISPATCH_EVENT_PEOPLE.DISPATCH_ID DEP_DISPTCH_FK C
DISPATCH_EVENT_PEOPLE_VW.DISPATCH_ID Implied Constraint R
DISPATCH_EVENT_VEHICLES.DISPATCH_ID DEV_DISPTCH_FK C
DISPATCH_SEARCH_VW.DISPATCH_ID Implied Constraint R
DISPATCH_VW.DISPATCH_ID Implied Constraint R
FLDINT_DISPATCHES.DISPATCH_ID FIDISP_DISPTCH_FK R
INCIDENT_DELETE_VW.DISPATCH_ID Implied Constraint R
INCIDENT_DISPATCH_VW.DISPATCH_ID Implied Constraint R
JS_BAIR_CFS_VW.DISPATCH_ID Implied Constraint R
JS_CALLS_FOR_SERVICE_VW.DISPATCH_ID Implied Constraint R
JS_OFFICER_DAILY_ACTIVITY_VW.DISPATCH_ID Implied Constraint R
JS_OFFICER_DAILY_VW.DISPATCH_ID Implied Constraint R
USI_DISPATCH_FIELDS.DISPATCH_ID USI_DISPF_DISPTCH_FK R
Unique # assigned to each CFS
AGENCY varchar2 25  √  null Agency that owns/responsible for dispatching the Call for Service
DISPATCH_DATE date 7  √  null Date first dispatched, MM/DD/YYYY - auto completion by system
DISPATCH_TIME date 7  √  null Military format - auto completion by system
STREET_NUMBER varchar2 10  √  null Number portion of street address for event location
STREET_DIRECTION varchar2 30  √  null Direction prefix of street address for event location
STREET_NAME varchar2 40  √  null Street Name for event location
STREET_CD_STREET_TYPE_CODE varchar2 30  √  null Street Type portion of street address (St, Ave, etc.) for event location
STREET_DIR_SUFFIX varchar2 30  √  null Direction suffix of street address for event location
SUB_TYPE varchar2 30  √  null Type of sub address (Apt, Bldg, etc.) for event location
SUB_NUMBER varchar2 40  √  null Sub address number for event location
CITY varchar2 40  √  null City for event location
STATE varchar2 30  √  null State for event location
ZIP5_OLD number 5  √  null TBD-After the 10.27 release successfully installs
ZIP4 number 4  √  null 2nd part of zip code for event location
SUB_BEAT varchar2 30  √  null Sub-beat for event location
BEAT varchar2 30  √  null Beat for event location
CROSS_STREET_NUMBER varchar2 10  √  null Street Number of Cross Street for event location
CROSS_STREET_DIRECTION varchar2 30  √  null Direction prefix of cross street for event location
CROSS_STREET varchar2 60  √  null Name of Cross Street for event location
CROSS_STREET_TYPE_CODE varchar2 30  √  null Street type of Cross Street for event location
CROSS_STREET_DIR_SUFFIX varchar2 30  √  null Direction suffix of Cross Street for event location
BOUNDARY_STREET varchar2 60  √  null Boundary Street
MILE_POST_NBR varchar2 4  √  null Mile Marker Number
DISTANCE_FROM varchar2 10  √  null Number of distance_units
DISTANCE_UNITS varchar2 2  √  null Unit of distance (ft, miles, yards, etc.
DIRECTION_FROM varchar2 30  √  null Direction distance is measured
LATITUDE varchar2 30  √  null Latitude of Address
LONGITUDE varchar2 30  √  null Longitude of Address
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
DISPATCH_USER varchar2 100  √  null Name or ID of Dispatcher
CALL_TYPE varchar2 30  √  null Code for type of Call for Service
CALL_DISPOSITION_CODE varchar2 30  √  null
CALL_DISPOSITION_CODES.CALL_DISPOSITION_CODE DISPTCH_CALLDISPCD_FK R
Code for Disposition of CFS
MAP varchar2 5  √  null
CALL_PRIORITY varchar2 30  √  null
EJS_CODES.CODE DISPTCH_CP_TYPE_CD_FK R
Priority of CFS
CLOSE_DATE date 7  √  null Date/time CFS closed
ONSCENE_DATE date 7  √  null Date/time officer first onscene
CALLER_NAME varchar2 50  √  null Name of Caller
CALLER_PHONE varchar2 30  √  null Phone # of Caller
INCIDENT_NOTE clob 4000  √  null Notes/Remarks/Narrative related to CFS
FLX_DATE_1 date 7  √  null NOT USED
FLX_DATE_2 date 7  √  null NOT USED
FLX_VCHR_1 varchar2 60  √  null NOT USED
FLX_VCHR_2 varchar2 60  √  null NOT USED
FLX_NUMB_1 number 0  √  null NOT USED
FLX_NUMB_2 number 0  √  null NOT USED
CALLER_LOCATION varchar2 100  √  null Location of Caller
INCIDENT_LOCATION varchar2 100  √  null Location of event/incident
COMMON_PLACE_NAME varchar2 80  √  null Common name of event location.
REC_ID number 0  √  null Internal Record ID for this CFS record
CALL_DATE date 7  √  null Date/Time of call
DISP_STATUS_CODE varchar2 30  √  null
EJS_CODES.CODE DISPTCH_STATUS_CODE_FK R
Code for status of CFS
DISP_STATUS_CODE_TYPE varchar2 30  √  null
EJS_CODES.CODE_TYPE DISPTCH_STATUS_CODE_FK R
EJS_CODES code type for call status
CALL_PRIORITY_TYPE varchar2 30  √  null
EJS_CODES.CODE_TYPE DISPTCH_CP_TYPE_CD_FK R
EJS_CODES code type for call priority
CALL_DISP_CALL_TYPE varchar2 30  √  null NOT USED
DISPATCH_NUMBER varchar2 30  √  null Tracking number for Call for Service
EVENT_TYPE_CODE varchar2 30  √  null
CALL_DISPOSITION_CODES.EVENT_TYPE_CODE DISPTCH_CALLDISPCD_FK R
Code for type of event (Police, Fire, EMS)
CALL_RECEIVED_CODE varchar2 30  √  null Code for source of call.
INC_NOTE_COPY varchar2 4000  √  null NOT USED
ENROUTE_DATE date 7  √  null First enroute date/time for event
ZIP5 varchar2 30  √  null First 5 digits of zip code for event location
COUNTY varchar2 30  √  null County of event location.

Analyzed at Mon Sep 20 21:05 MDT 2021

Requirements (check constraints):
Constraint Constraint Name
DISPATCH_ID IS NOT NULL DISPTCH_DISPATCH_ID_NN

Indexes:
Column(s) Type Sort Constraint Name Anomalies
DISPATCH_ID Primary key Asc DISPTCH_PK  
DISPATCH_USER Performance Asc DISEV_DISPATCH_USER_I  
CALL_DATE Performance Asc DISPTCH_CALL_DATE_I  
CALL_TYPE + AGENCY Performance Asc/Asc DISPTCH_CALL_TYPE_AGNCY_I  
CALL_DISPOSITION_CODE + EVENT_TYPE_CODE Performance Asc/Asc DISPTCH_CALLDISPCD_FK_I  
CALL_PRIORITY_TYPE + CALL_PRIORITY Performance Asc/Asc DISPTCH_CP_TYPE_CD_FK_I  
DISPATCH_DATE Performance Asc DISPTCH_DISPATCH_DATE_I  
Performance DISPTCH_DISPNM_FB_I  
INCIDENT_NOTE Performance Asc DISPTCH_INCIDENT_NOTE_I  
DISPATCH_NUMBER + AGENCY Must be unique Asc/Asc DISPTCH_NUM_AGNCY_UK These unique columns are also nullable
DISP_STATUS_CODE_TYPE + DISP_STATUS_CODE Performance Asc/Asc DISPTCH_STATUS_CODE_FK_I  

Close relationships  within of separation: