v_nfirs_civilian_casualty

v_nfirs_civilian_casualty

Purpose

  1. Civilian casualty records for incidents.


Relationships

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

    • Many casualties link to one incident

    • Referenced through incident_report_id

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

    • Many casualties recorded by one personnel

    • Referenced through created_by




Table



Column

Type

Description

id

integer

Primary key

client_code

varchar(28)

Organization ID

incident_report_id

integer

Incident reference

casualty_id

integer

Casualty reference

first_name

varchar(100)

First name

last_name

varchar(100)

Last name

note

text

Additional notes

affiliation

varchar(2)

Affiliation code

injury_date_time

timestamp

Injury time

activity_when_injured

varchar(2)

Activity code

civilian_casualty_cause_of_injury

varchar(2)

Cause code

civilian_casualty_primary_apparent_symptom

varchar(3)

Primary symptom

factors_contributing_to_injury

varchar(200)

Contributing factors

civilian_casualty_severity

varchar(2)

Severity code

created_by

integer

Creator reference

created_at

timestamp

Creation time

updated_at

timestamp

Update time




    • Related Articles

    • v_nfirs_firefighter_casualty

      Purpose Firefighter casualty records for NFIRS reporting. Relationships v_incident_report: Many-to-One (N:1) Many casualties link to one incident Referenced through incident_report_id v_nfirs_firefighter_casualty_equipment: One-to-Many (1:N) One ...
    • v_nfirs_firefighter_casualty_equipment

      Purpose Equipment related to firefighter casualties. Relationships v_nfirs_firefighter_casualty: Many-to-One (N:1) Many equipment records link to one casualty Referenced through nfirs_firefighter_casualty_id Table Column Type Description id integer ...
    • Documenting Civilian Casualties

      Purpose To explain how to document civilian casualties in an incident report. Video Definition From the NFIRS Complete Reference Guide: The Civilian Fire Casualty Module (NFIRS–4) is used to report injuries or deaths to civilians or other emergency ...
    • NFIRS export settings NJ

      Purpose To guide you through NFIRS Export . Background Effective January 1, 2024, for data efficiency and analytical reasons, all Fire Departments will discontinue sending their NFIRS Reports to the NJ Division of Fire Safety, NFIRS Unit. All NFIRS ...
    • v_nfirs_ems

      Purpose EMS incident details for NFIRS reporting. Relationships v_incident_report_people: Many-to-One (N:1) Many EMS records link to one person Referenced through incident_report_people_id v_nfirs_ems_medication: One-to-Many (1:N) One EMS record can ...