Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse WTW TEACHING DETAIL Table


View exposing detailed teaching assignment records from the 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

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_INSTRUCTOR_KEY

Surrogate key identifying the wtw instructor.

VARCHAR2

15

WTW_INSTRUCTOR_ROLE_KEY

Surrogate key identifying the wtw instructor role.

VARCHAR2

24

WTW_SUBJECT_SECTION_KEY

Surrogate key identifying the wtw subject section.

VARCHAR2

16