Table slot9.WORLD.TSTA.DEL_DISPATCH_EVENTS
This table stores duplicate dispatch events from the PRINTRAK 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
DEL_DE_ID number 38 Unique # assigned
DISPATCH_ID number 38  √  null
DISPATCH_EVENTS.DISPATCH_ID Implied Constraint R
Copy of deleted Unique # assigned
AGENCY varchar2 25  √  null
DISPATCH_DATE date 7  √  null Copy of deleted MM/DD/YYYY - auto completion by system
DISPATCH_TIME date 7  √  null Copy of deleted Military format - auto completion by system
STREET_NUMBER varchar2 10  √  null Copy of deleted Street Name
STREET_DIRECTION varchar2 30  √  null
STREET_NAME varchar2 40  √  null
STREET_CD_STREET_TYPE_CODE varchar2 30  √  null
STREET_DIR_SUFFIX varchar2 30  √  null
SUB_TYPE varchar2 30  √  null
SUB_NUMBER varchar2 40  √  null
CITY varchar2 40  √  null
STATE varchar2 30  √  null
ZIP5_OLD number 5  √  null
ZIP4 number 4  √  null
SUB_BEAT varchar2 30  √  null
BEAT varchar2 30  √  null
CROSS_STREET_NUMBER varchar2 10  √  null
CROSS_STREET_DIRECTION varchar2 30  √  null
CROSS_STREET varchar2 60  √  null Copy of deleted Intersecting Street
CROSS_STREET_TYPE_CODE varchar2 30  √  null
CROSS_STREET_DIR_SUFFIX varchar2 30  √  null
BOUNDARY_STREET varchar2 60  √  null
MILE_POST_NBR varchar2 4  √  null
DISTANCE_FROM varchar2 10  √  null
DISTANCE_UNITS varchar2 2  √  null
DIRECTION_FROM varchar2 30  √  null
LATITUDE varchar2 30  √  null Copy of deleted Latitude of Address
LONGITUDE varchar2 30  √  null Copy of deleted Longitude of Address
DEL_CREATOR_ID varchar2 100  √  null Copy of deleted Person creating the record
DEL_CREATOR_DATE date 7  √  null Copy of deleted Date of record creation
DEL_UPDATOR_ID varchar2 100  √  null Copy of deleted Person who last updated the record
DEL_UPDATOR_DATE date 7  √  null Copy of deleted Date of last update
DISPATCH_USER varchar2 100  √  null
CALL_TYPE varchar2 30  √  null
CALL_DISPOSITION_CODE varchar2 30  √  null
MAP varchar2 5  √  null
CALL_PRIORITY varchar2 30  √  null
CLOSE_DATE date 7  √  null
ONSCENE_DATE date 7  √  null
CALLER_NAME varchar2 50  √  null
CALLER_PHONE varchar2 30  √  null
INCIDENT_NOTE varchar2 2000  √  null
FLX_DATE_1 date 7  √  null
FLX_DATE_2 date 7  √  null
FLX_VCHR_1 varchar2 60  √  null
FLX_VCHR_2 varchar2 60  √  null
FLX_NUMB_1 number 0  √  null
FLX_NUMB_2 number 0  √  null
CALLER_LOCATION varchar2 100  √  null
INCIDENT_LOCATION varchar2 100  √  null
COMMON_PLACE_NAME varchar2 80  √  null
DE_REC_ID number 0  √  null
CALL_DATE date 7  √  null
DISP_STATUS_CODE varchar2 30  √  null
DISP_STATUS_CODE_TYPE varchar2 30  √  null
CALL_PRIORITY_TYPE varchar2 30  √  null
CALL_DISP_CALL_TYPE varchar2 30  √  null
DISPATCH_NUMBER varchar2 30  √  null
EVENT_TYPE_CODE varchar2 30  √  null
DISPATCH_EVENT_TYPES.EVENT_TYPE_CODE Implied Constraint R
CALL_RECEIVED_CODE varchar2 30  √  null
DEL_DATE date 7  √  null
REC_ID number 0  √  null
ZIP5 varchar2 30  √  null

Analyzed at Mon Sep 20 21:05 MDT 2021

Indexes:
Column(s) Type Sort Constraint Name
DEL_DE_ID Primary key Asc DELDE_PK

Close relationships: