v_dispatch

v_dispatch

Purpose

  1. Emergency dispatch records view.

Relationship


  • v_incident_report: One-to-Many (1:N)

    • One dispatch can have many incident reports

    • Referenced through xref_id

  • v_apparatus: Many-to-Many (N:M)

    • Many dispatches can involve many apparatus

    • Referenced through dispatch_unit_codes

  • v_occupancy: Many-to-One (N:1)

    • Many dispatches link to one location

    • Referenced through place_id



Table


Column

Type

Description

id

integer

Primary key

batt_dept_id

integer

Department reference

place_id

integer

Location reference

dispatch_type

varchar(64)

Dispatch type

address

varchar(255)

Incident address

city

varchar(255)

City

message

text

Dispatch message

dispatch_unit_codes

varchar(64)[]

Unit codes

xref_id

varchar(32)

Cross reference

status_code

varchar(20)

Status

create_date

timestamp

Creation date

created_at

timestamp

Creation timestamp

dispatch_incident_type_code

varchar(64)

Incident type

dispatch_incident_type_name

varchar(128)

Incident description

location_cache

text

Location details

client_code

varchar(28)

Organization ID

latitude

numeric(9,7)

GPS latitude

longitude

numeric(10,7)

GPS longitude






    • Related Articles

    • v_incident_report_apparatus

      Purpose Apparatus response details for incidents. Relationships v_incident_report: Many-to-One (N:1) Many apparatus responses link to one incident Referenced through incident_report_id v_apparatus: Many-to-One (N:1) Many responses link to one ...

    • v_incident_report_station_response

      Purpose Station response records for incidents. Relationships v_incident_report: Many-to-One (N:1) Many station responses link to one incident Referenced through incident_report_id v_personnel: Many-to-One (N:1) Many responses link to one personnel ...

    • Dispatch Email Link

      Purpose To provide overview of the Dispatch Email Link interface. Description A notification is generated upon dispatch and is sent to a First Due email address in txt or html format.  In order to ensure we have the necessary information, we require ...

    • Dispatch Units: Create, Edit & Delete

      Purpose Statement Dispatch units within the Responder module represent the operational units that can be alerted and dispatched to emergency incidents. This feature allows administrators to create, configure, and manage dispatch units with specific ...

    • Dispatch Incident Types: Creating and Customizing

      Purpose To demonstrate how to create and customize a Dispatch Incident Type. Video Directions 1. Navigate to Response Module then Click on Dispatch Incident Types. 2. Click on New Dispatch Incident Type. 3. Fill in the following fields. Department ...