Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse RR REQ TRAINING QUAL DETAIL Table


View exposing required training qualification detail for rewards-and-recognition trainees including qualification code, qualification name, effective and expiration dates, and audit fields.


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

RR_REQ_QUALIFICATION

Rr req qualification associated with the record.

VARCHAR2

60

RR_REQ_QUALIFICATION_CODE

Code identifying rr req qualification.

VARCHAR2

10

RR_REQ_QUAL_EFFECTIVE_DATE

Date associated with rr req qual effective.

DATE

RR_REQ_QUAL_EXPIRATION_DATE

Date associated with rr req qual expiration.

DATE

RR_TRAINEE_KEY

Surrogate key identifying the rr trainee.

VARCHAR2

10

WAREHOUSE_LOAD_DATE

Date the record was loaded into the data warehouse.

DATE