Graduate Awards
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 |
|---|---|---|---|---|---|---|
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 |
MIT Student Information System |
SENSITIVE |
Daily |
17-APR-2024 |
|
This table contains information about graduate awards and appointments, ie. RA (Research Assistant), TA (Teaching Assistant), and FE (Fellowship). Each graduate appointment/award includes information about the student, the amount, the status of the award, the fund type (Tuition, Stipend, Insurance), the cost object and GL which the award is charged to, and the awarding department. Each of the graduate award/appointment is set up by academic terms (Summer, Fall, Spring) for the financial aid year. This table may be joined together with the GRADUATE_AWARD_WORK_AREA table to get more information about the supervisor for which the graduate student is a TA or RA. |
Fact |
MIT Student Information System |
SENSITIVE |
Daily |
17-APR-2024 |
|
This table contains work area information (such as the the supervisor/faculty for which the graduate student is a TA or RA) about a graudate award. |
Dimension |
MIT Student Information System |
SENSITIVE |
Daily |
17-APR-2024 |
|
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 |
MIT Student Information System |
SENSITIVE |
As Needed |
28-MAR-2002 |
|
Contains data about the student's registration status, by academic term. There is one enrollment record for a student per academic term. |
Dimension |
MIT Student Information System |
SENSITIVE |
Daily |
17-APR-2024 |
|
This dimension table consists of all the graduate appointments/awards, ie. RA (Research Assistant), TA (Teaching Assistant), and FE (Fellowship) created for the graduate students. There is one record per appointment. |
Dimension |
MIT Student Information System |
SENSITIVE |
Daily |
17-APR-2024 |