v_preplan_hazmat_history
Table Name: v_preplan_hazmat_history
Last Updated: June 01, 2026 at 01:22 AM
Columns
| Column Name | Data Type | Nullable | Default |
|---|---|---|---|
| id | integer | Yes | - |
| hm_un_code | character | Yes | - |
| chemical_name | character | Yes | - |
| health_hazard_code | smallint | Yes | - |
| fire_hazard_code | smallint | Yes | - |
| reactivity_code | smallint | Yes | - |
| special_hazard_code | character | Yes | - |
| quantity | character | Yes | - |
| location | character | Yes | - |
| date_verified | date | Yes | - |
| comments | text | Yes | - |
| expiration_date | date | Yes | - |
| expiration_action | character | Yes | - |
| preplan_id | integer | Yes | - |
| address_id | integer | Yes | - |
| client_code | character | Yes | - |
| preplan_status_code | character | Yes | - |
This documentation is automatically generated from the ODBC Data Warehouse schema.