Table slot9.WORLD.TSTA.DISPATCH_EVENT_OFFICERS
This table stores the association to an officer added to a dispatch event manually in the application or 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
UNIT_AGENCY varchar2 30  √  null Agency unit is assigned to
DISPATCH_ID number 38
DISPATCH_EVENTS.DISPATCH_ID DSPEO_DISPTCH_FK C
Unique # assigned
CAD_PERSID varchar2 15 Officer Id from the CAD
OFFICER_LNAME varchar2 20  √  null Officer Last Name from the ofiicers table
OFFICER_FNAME varchar2 20  √  null Officer First Name from the officers table
OFFICER_TITLE varchar2 20  √  null Officer Title from the officers table
OFFICER_ID number 0  √  null
OFFICERS.OFFICER_ID Implied Constraint R
Officer ID or Badge Number from the Officers table from the officers table
OFFICER_AGENCY varchar2 30  √  null Officer Agency from the officers table
DISPATCH_DATE date 7  √  null Date/Time unit/officer dispatched
ONSCENE_DATE date 7  √  null Date/Time unit/officer arrived on scene
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
UNIT varchar2 15  √  null Unit identifier
REC_ID number 0  √  null Internal record ID.
CLEAR_DATE date 7  √  null Date/time unit/officer cleared scene
PRIMARY varchar2 1  √  null Y/N flag indicating if officer is Primary
SERVICE_AGENCY varchar2 30  √  null Service request agency
ENROUTE_DATE date 7  √  null Date/time unit/officer first enroute.

Analyzed at Mon Sep 20 21:05 MDT 2021

Requirements (check constraints):
Constraint Constraint Name
"CAD_PERSID" IS NOT NULL DSPEO_CAD_PERSID_NN
DISPATCH_ID IS NOT NULL DSPEO_DISPATCH_ID_NN

Indexes:
Column(s) Type Sort Constraint Name
DISPATCH_ID + CAD_PERSID Primary key Asc/Asc DSPEO_PK
DISPATCH_ID Performance Asc DSPEO_DISPTCH_FK_I
OFFICER_AGENCY Performance Asc DSPEO_OFFICR_AGNCY_I
OFFICER_ID Performance Asc DSPEO_OFFICR_OFF_ID_I
PRIMARY Performance Asc DSPEO_PRIMARY_I
SERVICE_AGENCY Performance Asc DSPEO_SERVICE_AGNCY_I
UNIT_AGENCY Performance Asc DSPEO_UNIT_AGNCY_I

Close relationships  within of separation: