Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse Who's Teaching What - Old WTW


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_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_OLD_SUBJECT_SECTION

This is a dimension table used in the OLD 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

WTW_OLD_INSTRUCTOR_ROLE

This is a dimension table used in the OLD Who-is-Teaching-What data model. The table contains all the instructor roles -- example: Lecturer, Administration, Recitation Instructor, Lab Instructor, etc.

Dimension

MIT Student Information System

SENSITIVE

Daily

08-JAN-2020

WTW_OLD_TEACHING_DETAIL

This table contains the detail of the OLD Who-is-Teaching-What data, from Fall 1999 ("2000FA") through Spring 2009 ("2009SP"). Used the "KEY" field in this table to join to the same-name tables (ie. Joining from this table to the WTW_OLD_SUBJECT_SECTION table using the WTW_OLD_SUBJECT_SECTION_KEY field, and joining from this table to the WTW_OLD_INSTRUCTOR table using the WTW_OLD_INSTRUCTOR_KEY field, and joining from this table to the WTW_OLD_INSTRUCTOR_ROLE table using the WTW_OLD_INSTRUCTOR_ROLE_KEY, and joining from this table to the WTW_ACADEMIC_TERM table using the WTW_ACADEMIC_TERM_KEY) to get the instructor 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_OLD_INSTRUCTOR

This table contains all instructors in the OLD Who-is-Teaching-What data model.

Dimension

MIT Student Information System

SENSITIVE

Daily

08-JAN-2020