Table slot9.WORLD.TSTA.DEL_DISPATCH_EVENT_OFFICERS
This table stores duplicate dispatch event officer 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_DEO_ID number 38 Unique # assigned
UNIT_AGENCY varchar2 15  √  null Copy of deleted Ageency unit is assigned to
DISPATCH_ID number 38  √  null
DISPATCH_EVENTS.DISPATCH_ID Implied Constraint R
Copy of deleted Unique # assigned
CAD_PERSID varchar2 15  √  null Copy of deleted Officer Id from the CAD
OFFICER_LNAME varchar2 20  √  null Copy of deleted Officer Last Name from the ofiicers table
OFFICER_FNAME varchar2 20  √  null Copy of deleted Officer First Name from the officers table
OFFICER_TITLE varchar2 15  √  null Copy of deleted Officer Title from the officers table
OFFICER_ID number 0  √  null
OFFICERS.OFFICER_ID Implied Constraint R
Copy of deleted Officer ID or Badge Number from the Officers table from the officers table
OFFICER_AGENCY varchar2 25  √  null Copy of deleted Officer Agency from the officers table
DISPATCH_DATE date 7  √  null
ONSCENE_DATE date 7  √  null Copy of deleted Date Unit arrived on scene
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
UNIT varchar2 15  √  null Copy of deleted Unit identifier
DEO_REC_ID number 0  √  null
CLEAR_DATE date 7  √  null
PRIMARY varchar2 1  √  null
DEL_DATE date 7  √  null
REC_ID number 0  √  null

Analyzed at Mon Sep 20 21:05 MDT 2021

Indexes:
Column(s) Type Sort Constraint Name
DEL_DEO_ID Primary key Asc DELDEO_PK

Close relationships: