Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse TEM ATTENDEE QUALIFIC DETAIL Table


View exposing attendee qualification detail in the TEM learning and development model including attendee, qualification, validity dates, update audit fields, and record counter.


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

30

RECORD_COUNTER

Record counter associated with the record.

NUMBER

1

TEM_ATTENDEE_KEY

Surrogate key identifying the tem attendee.

VARCHAR2

9

TEM_QUALIFICATION_KEY

Surrogate key identifying the tem qualification.

VARCHAR2

9

VALIDITY_FROM_DATE

Date associated with validity from.

DATE

VALIDITY_TO_DATE

Date associated with validity to.

DATE

WAREHOUSE_LOAD_DATE

Date the record was loaded into the data warehouse.

DATE