Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse EL QUAL COURSE MAP Table


View exposing mappings between qualifications and courses used to satisfy EHS training requirements.


Field Name

Description

Data Type

Length

LSO_COURSE_KEY

Surrogate key identifying the lso course.

VARCHAR2

47

LSO_QUALIFICATION_KEY

Surrogate key identifying the lso qualification.

VARCHAR2

10

VALID_FROM_DATE

Date associated with valid from.

DATE

VALID_TO_DATE

Date associated with valid to.

DATE

WAREHOUSE_LOAD_DATE

Date the record was loaded into the data warehouse.

DATE