Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse Who's Teaching What


Tables are listed by alphabetical order. Clicking on a table name will display the fields/columns found in that table.


Table Name

Description

Type

Primary Provider

Sensitivity

Load Frequency

Last Load Date

WTW_TEACHING_DETAIL

This table contains the detail of the Who-is-Teaching-What data since Fall Term 2009 (ie. 2010FA). Used the "KEY" field in this table to join to the same-name table (eg. Joining from this table to the WTW_SUBJECT_SECTION table using the WTW_SUBJECT_SECTION_KEY field, and joining from this table to the WTW_INSTRUCTOR table using the WTW_INSTRUCTOR_KEY field, and joining from this table to the WTW_INSTRUCTOR_ROLE table using the WTW_INSTRUCTOR_ROLE_KEY, and joining from this table to the WTW_ACADEMIC_TERM table using the WTW_ACADEMIC_TERM_KEY) to get the teaching roles of each of the instructors in the different terms, subjects and sections.

Fact

MIT Student Information System

SENSITIVE

Daily

08-JAN-2020

WTW_SUBJECT_SUMMARY

This is a dimension table used in the Who-is-Teaching-What data model. The table contains information about the subjects for the teaching data. Unlike WTW_SUBJECT_SECTION, this table DOES NOT contain section information of the subjects. There is one subject per term in this table.

Dimension

MIT Student Information System

SENSITIVE

Daily

08-JAN-2020

WTW_INSTRUCTOR_ROLE

This is a dimension table used in the Who-is-Teaching-What data model. It contains all the teaching roles (eg. Lecturer, Recitation Instructor, Teaching Assistant, Writing Instructor, etc.)

Dimension

MIT Student Information System

SENSITIVE

Daily

08-JAN-2020

WTW_SUBJECT_GROUPING

This is a dimension table used in the Who-is-Teaching-What data model. Data in this table are used to identify the cluster subjects for specific academic term by department and school.

Dimension

MIT Student Information System

SENSITIVE

Daily

08-JAN-2020

WTW_INSTRUCTOR

This table includes all instructors in the Who-is-Teaching-What data.

Dimension

MIT Student Information System

SENSITIVE

Daily

08-JAN-2020

WTW_SUBJECT_SECTION

This is a dimension table used in the Who-is-Teaching-What data model. The table contains information about the subjects and sections for the teaching data. There is one record per academic term per subject per section in this table.

Dimension

MIT Student Information System

SENSITIVE

Daily

08-JAN-2020

WTW_ACADEMIC_TERM

Academic term information for the Who-is-Teaching-What data.

Dimension

MIT Student Information System

SENSITIVE

Daily

08-JAN-2020