f_incident_report

f_incident_report

Purpose

  1. Documents emergency incidents and responses.

Relationships


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

    • One incident can have multiple EPCRs

    • Referenced through incident_report_id

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

    • One incident can have multiple apparatus responses

    • Referenced through incident_report_id

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

    • One incident can have multiple personnel responses

    • Referenced through incident_report_id

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

    • Many incidents can have one officer in charge

    • Referenced through officer_in_charge



Table


Column

Type

Description

id

integer

Primary key

client_code

varchar

Organization identifier

alarm_at

timestamp

Alarm time

created_at

timestamp

Creation time

first_arriving_unit

integer

First unit

shift_name

varchar

Shift reference

incident_reporting_status_code

varchar

Report status

officer_in_charge

integer

Officer ID

incident_type

varchar

Incident type

nfb_incident_number

varchar

Incident number

address

varchar

Incident location

dispatch_type

varchar

Dispatch type

exposure

integer

Exposure value

completed_by

integer

Completing user

incident_number

varchar

Reference number

unit

varchar

Unit reference

location_type

varchar

Location type

officer_in_charge_name

varchar

Officer name

aid_type

integer

Aid type

property_loss

integer

Property loss value

contents_loss

integer

Contents loss value

actual_incident_type

varchar

Verified type

fire_station_id

integer

Station reference

station_num

varchar

Station number





    • Related Articles

    • Completing an Incident Report - 4. Information

      Purpose This article will guide you through the Information section of an Incident Report. Related Articles Completing an Incident Report - 1. Response Completing an Incident Report - 2. Size-up Completing an Incident Report - 3. Operations ...

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

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