v_preplan_expiring_hazmat
Purpose
- Expiring hazardous materials in pre-plans.
Relationships
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
|
Related Articles
v_preplan_hazmat
Purpose 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 ...
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 ...
v_preplan_expiring_unit
Purpose Expiring pre-plan unit information. Relationships v_occupancy: Many-to-One (N:1) Many units link to one location Referenced through preplan relationship v_preplan_unit: One-to-One (1:1) Each expiring unit links to one unit record Referenced ...
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_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 ...