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