Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse TEM QUALIFICATION Table


View exposing TEM qualification reference data including qualification identifiers, codes, names, qualification group identifiers and names, update audit fields, 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

TEM_QUALIFICATION

Tem qualification associated with the record.

VARCHAR2

41

TEM_QUALIFICATION_CODE

Code identifying tem qualification.

VARCHAR2

10

TEM_QUALIFICATION_GROUP

Tem qualification group associated with the record.

VARCHAR2

40

TEM_QUALIFICATION_GROUP_CODE

Code identifying tem qualification group.

VARCHAR2

10

TEM_QUALIFICATION_GROUP_ID

Business identifier for the tem qualification group.

VARCHAR2

12

TEM_QUALIFICATION_ID

Business identifier for the tem qualification.

VARCHAR2

12

TEM_QUALIFICATION_KEY

Surrogate key identifying the tem qualification.

VARCHAR2

9

WAREHOUSE_LOAD_DATE

Date the record was loaded into the data warehouse.

DATE