v_incident_report_station_response

v_incident_report_station_response

Purpose

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

    • Referenced through personnel_id

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

    • Many responses link to one station

    • Referenced through station name matching




Table



Column

Type

Description

id

integer

Primary key

personnel_id

integer

Personnel reference

is_canceled

boolean

Cancellation flag

incident_report_id

integer

Incident reference

client_code

varchar(28)

Organization ID

user_id

integer

User reference

nfb_incident_number

varchar(32)

Incident number

station_name

varchar(64)

Station name

personnel_full_name

text

Personnel name

dispatch_date_time

timestamp

Dispatch time

dispatch_acknowledge_date_time

timestamp

Acknowledgment time

arrived_station_date_time

timestamp

Arrival time

enroute_station_date_time

timestamp

Enroute time

canceled_station_date_time

timestamp

Cancellation time

left_station_date_time

timestamp

Departure time

duration

varchar(10)

Response duration




    • Related Articles

    • 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 ...
    • Completing an Incident Report - Response

      Purpose To explain how to complete the Response section of an Incident Report. Related Articles Completing an Incident Report - Response (this article) Completing an Incident Report - Size-up Completing an Incident Report - Operations Completing an ...
    • Completing an Incident Report - Completing and Authorizing

      Purpose This article will guide you through Completing and Authorizing an Incident Report. Related Articles Completing an Incident Report - Response Completing an Incident Report - Size-up Completing an Incident Report - People Involved Completing an ...
    • Completing an Incident Report - Size Up

      Purpose This article will guide you through the Size-up section of an Incident Report. Related Articles Completing an Incident Report - Response Completing an Incident Report - People Involved Completing an Incident Report - Operations Completing an ...
    • Fire Incident Setup - Response

      Purpose To guide you through Fire Incident Response setup. Video Directions Navigate to Incident Documentation > Fire Incident Set up. Once on the landing page select Response tab on the left-hand side. Decide whether or not you want the Actual ...