Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse EHST CERT STATUS Table


View exposing reference values describing certification status used in Environment, Health, and Safety compliance tracking.


Field Name

Description

Data Type

Length

EHST_CERT_STATUS_KEY

Surrogate key identifying the ehst cert status.

VARCHAR2

10

IS_CERT_COMPLETED

Indicator identifying whether cert completed (Y/N).

VARCHAR2

1

IS_CERT_IN_EFFECT

Indicator identifying whether cert in effect (Y/N).

VARCHAR2

1

WAREHOUSE_LOAD_DATE

Date the record was loaded into the data warehouse.

DATE