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 |
|---|---|---|---|---|---|---|
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 |
24-APR-2024 |
|
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 |
24-APR-2024 |
|
Academic term information for the Who-is-Teaching-What data. |
Dimension |
MIT Student Information System |
SENSITIVE |
Daily |
24-APR-2024 |
|
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 |
24-APR-2024 |
|
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 |
24-APR-2024 |
|
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 |
24-APR-2024 |
|
This table contains all instructors in the OLD Who-is-Teaching-What data model. |
Dimension |
MIT Student Information System |
SENSITIVE |
Daily |
24-APR-2024 |