v_preplan_hazmat

v_preplan_hazmat

Purpose

  1. 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_expiring_hazmat: One-to-One (1:1)

    • Each hazmat record may have one expiring record

    • Referenced through matching attributes




Table



Column

Type

Description

id

integer

Primary key

hm_un_code

varchar(25)

UN code

chemical_name

varchar(1000)

Chemical name

health_hazard_code

smallint

Health hazard

fire_hazard_code

smallint

Fire hazard

reactivity_code

smallint

Reactivity

special_hazard_code

varchar(4)

Special hazard

quantity

varchar(64)

Quantity

location

varchar(255)

Storage location

date_verified

date

Verification date

comments

text

Notes

expiration_date

date

Expiry date

expiration_action

varchar(10)

Required action

preplan_id

integer

Pre-plan reference

address_id

integer

Address reference

client_code

varchar(28)

Organization ID

preplan_status_code

varchar(25)

Status code




    • Related Articles

    • 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 ...
    • Pre-Plans: Adding HAZMATs

      Purpose To demonstrate how to add Hazardous Materials into a Pre-Plan. Video Directions 1. Inside of Pre-Plan editor, click on the HAZMAT icon in the Left Slider Menu and then Add New. 2. Look up the UN number by typing the number or search by ...
    • v_preplan_last_completed

      Purpose Last completed pre-plan information. Relationships v_personnel: Many-to-One (N:1) Many completions done by one personnel Referenced through preplan_last_completed_by v_occupancy: One-to-One (1:1) One completion links to one location ...
    • v_preplan_unit

      Purpose Pre-plan unit information. Relationships v_occupancy: Many-to-One (N:1) Many units link to one location Referenced through preplan relationship v_preplan_expiring_unit: One-to-One (1:1) Each unit may have one expiring record Referenced ...