v_life_hazard_use

v_life_hazard_use

Purpose

  1. Life safety hazard classifications.

Relationships

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

    • One hazard classification can apply to many occupancies

    • Referenced through life_hazard_use_id



Table



Column

Type

Description

id

integer

Primary key

client_code

varchar(28)

Organization ID

code

varchar(50)

Hazard code

description

text

Hazard description




    • Related Articles

    • Life Hazard Use - New Jersey

      Purpose The purpose of this Knowledge Base Article is to demonstrate how to enter Life Hazard Use data for New Jersey clients. Video Instructions NOTE: This feature is designed for New Jersey clients to document the Life Hazard Use and Registration ...

    • v_apparatus

      Purpose Apparatus / vehicle information view. Relationships v_incident_report_apparatus: One-to-Many (1:N) One apparatus can be on many incident reports Referenced through apparatus_id v_fire_station: Many-to-One (N:1) Many apparatus belong to one ...

    • v_occupancy

      Purpose Building and occupancy information. Relationships v_occupancy_contact: One-to-Many (1:N) One occupancy can have many contacts Referenced through place_id f_fire_inspection: One-to-Many (1:N) One occupancy can have many inspections Referenced ...

    • v_preplan_expiring_hazmat

      Purpose Expiring hazardous materials in pre-plans. Relationships v_occupancy: Many-to-One (N:1) Many hazmat records link to one location Referenced through address_id v_preplan_hazmat: One-to-One (1:1) Each expiring hazmat links to one hazmat record ...

    • v_preplan_hazmat_history

      Purpose Historical hazardous materials records. Relationships v_preplan_hazmat: Many-to-One (N:1) Many history records link to one current hazmat record Referenced through matching attributes v_occupancy: Many-to-One (N:1) Many hazmat histories link ...