Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse TEM QUALIFICATION DETAIL Table


View exposing mappings between TEM qualifications and classes including qualification start and end dates, update audit fields, record counter, and warehouse load date.


Field Name

Description

Data Type

Length

LAST_UPDATE_DATE

Date associated with last update.

DATE

LAST_UPDATE_USER

Last update user associated with the record.

VARCHAR2

12

QUALIFICATION_END_DATE

Date associated with qualification end.

DATE

QUALIFICATION_START_DATE

Date associated with qualification start.

DATE

RECORD_COUNTER

Record counter associated with the record.

NUMBER

1

TEM_CLASS_KEY

Surrogate key identifying the tem class.

VARCHAR2

10

TEM_QUALIFICATION_KEY

Surrogate key identifying the tem qualification.

VARCHAR2

9

WAREHOUSE_LOAD_DATE

Date the record was loaded into the data warehouse.

DATE