Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse EHST CERTIFICATION Table


EHS Training certification data


Field Name

Description

Data Type

Length

EHST_CERTIFICATION_CODE

Code number for the Certification Type.

NUMBER

12

EHST_CERTIFICATION_END_DATE

If the Certification Type is scheduled to be retired, this is the date on which it will be retired.

DATE

8

EHST_CERTIFICATION_KEY

Internal key for a Certification Type to be used when joining tables. (A Certification Type is a group of training or other requirements).

NUMBER

12

EHST_CERTIFICATION_LONG_NAME

The name of the Certification Type.

VARCHAR2

50

EHST_CERTIFICATION_SHORT_NAME

A short or abbreviated name for the Certification Type--may be useful in reports where you want to keep the columns narrow.

VARCHAR2

20

EHST_CERTIFICATION_START_DATE

The date that the Certification Type went into service.

DATE

8

WAREHOUSE_LOAD_DATE

The date the record was loaded into the Data Warehouse from the source system.

DATE

8