v_nfirs_firefighter_casualty

v_nfirs_firefighter_casualty

Purpose

  1. 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 casualty can have many equipment records

    • Referenced through nfirs_firefighter_casualty_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

injury_date_time

timestamp

Injury time

activity_at_time_of_injury

varchar(3)

Activity code

where_injury_occurred

varchar(2)

Location code

firefighter_casualty_severity

varchar(2)

Severity code

note

text

Additional notes

taken_to

varchar(2)

Treatment location

physical_condition_just_prior_to_injury

varchar(2)

Prior condition

number_of_responses_during_past_24_hours

integer

Recent responses

object_involved_in_injury

varchar(3)

Object code

specific_location_where_injury_occurred

varchar(3)

Specific location

factor_contributing_to_injury

varchar(3)

Contributing factor

primary_area_of_body_injured

varchar(3)

Primary injury site

created_by

integer

Creator reference

created_at

timestamp

Creation time

updated_at

timestamp

Update time




    • Related Articles

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

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

      Purpose EMS medication administration records for NFIRS. Relationships v_nfirs_ems: Many-to-One (N:1) Many medications link to one EMS record Referenced through nfirs_ems_id v_personnel: Many-to-One (N:1) Many medications administered by one provider ...