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
STUDENT_TERM_ENROLLMENT	Contains data about the student's registration status, by academic term. There is one enrollment record for a student per academic term.	Dimension	Student Services Information Technology (SSIT)	SENSITIVE	Daily	30-NOV-2009
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	30-NOV-2009
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	30-NOV-2009
GRADUATE_AWARD_TERM_DETAIL	Graduate Award Term Detail	Fact	Student Services Information Technology (SSIT)	SENSITIVE	Daily	30-NOV-2009
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