Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse EHSTA STATUS Table


View exposing reference values describing status within Environment, Health, and Safety training assignment and reconciliation processes.


Field Name

Description

Data Type

Length

EHSTA_STATUS

Ehsta status associated with the record.

VARCHAR2

9

EHSTA_STATUS_KEY

Surrogate key identifying the ehsta status.

VARCHAR2

6

IS_CURRENT_AFFILIATION_STATUS

Indicator identifying whether current affiliation status (Y/N).

VARCHAR2

1

WAREHOUSE_LOAD_DATE

Date the record was loaded into the data warehouse.

DATE