Table slot9.WORLD.TSTA.DEL_DISPATCH_EVENT_CASES
This table stores duplicate dispatch event case information 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_DEC_ID number 38 Unique # assigned
DISPATCH_ID number 38  √  null
DISPATCH_EVENTS.DISPATCH_ID Implied Constraint R
Copy of deleted Dispatch Event Case Unique # assigned
INC_REPORT_NUMBER varchar2 20  √  null Copy of deleted Dispatch Event Case Incident Report or Case Number
AGENCY varchar2 25  √  null Copy of deleted Dispatch Event Case Agency repsonsible for report
ASSIGNED_TO varchar2 25  √  null Copy of deleted Dispatch Event Case Person or Unit Cas Is assigned to
DEL_CREATOR_ID varchar2 100  √  null Copy of deleted Dispatch Event Case Person creating the record
DEL_CREATOR_DATE date 7  √  null Copy of deleted Dispatch Event Case Date of record creation
DEL_UPDATOR_ID varchar2 100  √  null Copy of deleted Dispatch Event Case Person who last updated the record
DEL_UPDATOR_DATE date 7  √  null Copy of deleted Dispatch Event Case Date of last update
ASSIGNED_INCIDENT varchar2 1  √  null
DEC_REC_ID number 0  √  null
INCIDENT_ID number 0  √  null
INCIDENTS.INCIDENT_ID Implied Constraint R
DEL_DATE date 7  √  null
REC_ID number 0  √  null Copy of deleted Dispatch Event Case Rec ID

Analyzed at Mon Sep 20 21:05 MDT 2021

Indexes:
Column(s) Type Sort Constraint Name
DEL_DEC_ID Primary key Asc DELDEC_PK

Close relationships: