Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse EHS HAZARD Table


View exposing hazard reference data used to classify Environment, Health, and Safety risks, training requirements, and compliance obligations.


Field Name

Description

Data Type

Length

EHS_HAZARD_GROUP_NAME

Ehs hazard group name associated with the record.

VARCHAR2

50

EHS_HAZARD_GROUP_SORT

Ehs hazard group sort associated with the record.

NUMBER

5

EHS_HAZARD_KEY

Surrogate key identifying the ehs hazard.

NUMBER

12

EHS_HAZARD_NAME

Ehs hazard name associated with the record.

VARCHAR2

50

EHS_HAZARD_SORT

Ehs hazard sort associated with the record.

NUMBER

5

WAREHOUSE_LOAD_DATE

Date the record was loaded into the data warehouse.

DATE