Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse TRAINCASTER COURSE DETAIL Table


View exposing TrainCaster course completion detail including Kerberos username, MIT identifier, course number, date taken, delivery medium, and warehouse load date.


Field Name

Description

Data Type

Length

DATE_TAKEN

Date associated with date taken.

DATE

KERBEROS_NAME

Kerberos name associated with the record.

VARCHAR2

15

MEDIUM

Medium associated with the record.

VARCHAR2

12

MIT_ID

MIT ID number of the person. Use this field to join with other tables containing data about people at MIT.

VARCHAR2

9

TRAINCASTER_COURSE_NUMBER

Traincaster course number associated with the record.

VARCHAR2

4

WAREHOUSE_LOAD_DATE

Date the record was loaded into the data warehouse.

DATE