Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse EHST CERTIFICATION Table


View exposing Environment, Health, and Safety certification records associated with MIT personnel, training completion, and compliance requirements.


Field Name

Description

Data Type

Length

EHST_CERTIFICATION_CODE

Code identifying ehst certification.

NUMBER

12

EHST_CERTIFICATION_END_DATE

Date associated with ehst certification end.

DATE

EHST_CERTIFICATION_KEY

Surrogate key identifying the ehst certification.

NUMBER

12

EHST_CERTIFICATION_LONG_NAME

Ehst certification long name associated with the record.

VARCHAR2

50

EHST_CERTIFICATION_SHORT_NAME

Ehst certification short name associated with the record.

VARCHAR2

20

EHST_CERTIFICATION_START_DATE

Date associated with ehst certification start.

DATE

WAREHOUSE_LOAD_DATE

Date the record was loaded into the data warehouse.

DATE