v_nfirs_firefighter_casualty_equipment

v_nfirs_firefighter_casualty_equipment

Purpose

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

Primary key

client_code

varchar(28)

Organization ID

nfirs_firefighter_casualty_id

integer

Casualty reference

protective_equipment_item

varchar(3)

Equipment code

protective_equipment_problem

varchar(3)

Problem code

equipment_manufacturer

varchar(100)

Manufacturer

equipment_model

varchar(100)

Model

equipment_serial_number

varchar(100)

Serial number




    • 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_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 ...
    • NERIS Documentation - Firefighter Casualty

      Purpose The purpose of this article is to assist with documenting a Firefighter Casualty within a fire incident report. Video Directions 1. You can document Firefighter Injuries or Casualties by navigating to the People Involved section. 2. Select ...
    • 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_equipment

      Purpose Equipment inventory and tracking. Relationships v_work_order: One-to-Many (1:N) One equipment item can have many work orders Referenced through equipment_id v_asset_inspection_completed: One-to-Many (1:N) One equipment item can have many ...