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 |
|---|---|---|---|---|---|---|
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 |
06-FEB-2025 |
|
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 |
06-FEB-2025 |
|
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 |
06-FEB-2025 |
|
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 |
06-FEB-2025 |
|
This table includes all instructors in the Who-is-Teaching-What data. |
Dimension |
MIT Student Information System |
SENSITIVE |
Daily |
06-FEB-2025 |
|
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 |
06-FEB-2025 |
|
Academic term information for the Who-is-Teaching-What data. |
Dimension |
MIT Student Information System |
SENSITIVE |
Daily |
06-FEB-2025 |