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 |
STUDENT_TERM_ENROLLMENT |
Contains data on the student's registration status, by academic term, as maintained by the Registrar's Office on MITSIS. There is one enrollment record for a student per term. |
Dimension |
Student Services Information Technology (SSIT) |
SENSITIVE |
Daily |
11-OCT-2008 |
GRADUATE_AWARD_WORK_AREA |
This table contains work area information (such as the subject/course as well as the supervisor/faculty in which the graduate student is a TA or RA) about a graudate award. |
Fact |
Student Services Information Technology (SSIT) |
SENSITIVE |
Daily |
10-OCT-2008 |
GRADUATE_AWARDING_DEPARTMENT |
The dimension table consists of all the academic departments and their schools at MIT. Limit on the awarding department fields in this table, and join it to the GRADUATE AWARD TERM DETAIL table for graduate awards that are awarded by the specific department. |
Dimension |
Student Services Information Technology (SSIT) |
MIT ONLY |
Daily |
11-OCT-2008 |
GRADUATE_AWARD_TERM_DETAIL |
Graduate Award Term Detail |
Fact |
Student Services Information Technology (SSIT) |
SENSITIVE |
Daily |
10-OCT-2008 |
GRADUATE_APPOINTMENT_TYPE |
This dimension table contains the definitions for the various types of graduate student appointment (e.g. Fellowship, Reseach Assistant, Teaching Assistant) and the associated fund type (Tuition, Stipend, Insurance) and fund/award status (Actual, Cancelled, etc.) |
Dimension |
Student Services Information Technology (SSIT) |
MIT ONLY |
As Needed |
28-MAR-2002 |