Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse WTW OLD TEACHING DETAIL Table


View exposing detailed teaching assignment records from the old Who's Teaching What teaching data model, including academic term, subject, section, instructor, and instructor role.


Field Name

Description

Data Type

Length

LAST_ACTIVITY_DATE

Date associated with last activity.

DATE

SLOT_INDEX

Slot index associated with the record.

NUMBER

3

WAREHOUSE_LOAD_DATE

Date the record was loaded into the data warehouse.

DATE

WTW_ACADEMIC_TERM_KEY

Surrogate key identifying the wtw academic term.

VARCHAR2

6

WTW_OLD_INSTRUCTOR_KEY

Surrogate key identifying the wtw old instructor.

VARCHAR2

15

WTW_OLD_INSTRUCTOR_ROLE_KEY

Surrogate key identifying the wtw old instructor role.

VARCHAR2

24

WTW_OLD_SUBJECT_SECTION_KEY

Surrogate key identifying the wtw old subject section.

VARCHAR2

16