v_incident_report_apparatus

v_incident_report_apparatus

Purpose

  1. 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 apparatus

    • Referenced through apparatus_id

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

    • One apparatus response can have many personnel

    • Referenced through incident_report_apparatus_id



Table



Column

Type

Description

id

integer

Primary key

client_code

varchar(28)

Organization ID

incident_report_id

integer

Incident reference

apparatus_id

integer

Apparatus reference

name

varchar(100)

Apparatus name

aid

boolean

Mutual aid flag

type_of_apparatus_or_resource

varchar(3)

Resource type

number_of_people

integer

Personnel count

location_flag

boolean

Location marker

dispatch_time

time

Dispatch time

arrive_time

time

Arrival time

clear_time

time

Clear time

back_in_service_time

time

Service return time

dispatch_to_enroute

interval

Response interval

enroute_to_scene

interval

Travel interval

scene_to_clear

interval

Scene interval

created_by

integer

Creator reference

created_at

timestamp

Creation time

department_name

varchar(100)

Department name

is_canceled

boolean

Cancellation flag

is_first_arriving_unit

boolean

First arrival flag


    • Related Articles

    • Concurrent Data Entry of Apparatus within Incident Documentation

      Purpose To explain how users may access the apparatus details modal to enter all information while someone else is completing the fire report. Heads Up! We are enhancing the way agencies can manage and enter Apparatus details in a fire report! This ...

    • Incident Documentation: Completing a Narrative Outside an Incident Report

      Purpose To explain how multiple users can complete narratives simultaneously. Background When multiple units are assigned to an incident, a narrative section is available for each unit. Only one user can be in the report at a single time. However, ...

    • v_incident_report_question

      Purpose Incident report question responses. Relationships v_incident_report: Many-to-One (N:1) Many questions link to one incident Referenced through incident_report_id v_incident_report_apparatus: Many-to-One (N:1) Many questions link to one ...

    • v_incident_report_personnel

      Purpose Personnel response records for incidents. Relationships v_incident_report_apparatus: Many-to-One (N:1) Many personnel link to one apparatus response Referenced through incident_report_apparatus_id v_personnel: Many-to-One (N:1) Many responses ...

    • v_apparatus

      Purpose Apparatus / vehicle information view. Relationships v_incident_report_apparatus: One-to-Many (1:N) One apparatus can be on many incident reports Referenced through apparatus_id v_fire_station: Many-to-One (N:1) Many apparatus belong to one ...