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

    • Dispatch Incident List: Overview

      Purpose To demonstrate how to create, view, edit and delete Dispatch Incidents. Video Directions 1. Navigate to Response module then select Dispatch Incident List. 2. The default Dispatch Incident List is displayed at the top left. Each list has a ...

    • 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 To explain how to edit or delete Dispatch Units. Video Directions 1. Navigate to Response module then select Dispatch Units. 2. Use the advance search fields to locate certain Units. 3. Select this icon to download a CSV file of all displayed ...

    • 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 ...

    • Using First Due to Dispatch Incidents

      The First Due platform integrated with many different Computer Aided Dispatch (CAD) systems. With the creation of an incident our system matches the address and shows the relevant pre-plan information for that location. There are a numerous ...