Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse Student


Business area which contains information about students, including RA/TA and Fellowship information for graduate students, student financial aid information, student biographical information, student term enrollment information, and student subject enrollment information.


Follow the links in the Tables in Group column to see a list of all the tables used in the star/group, together with information on how to combine the tables in a query.

Follow the links in the Data Model Diagram column (if available) to see a pictorial representation of the star.

Star/Table Group

Description

Tables in Group

Data Model Diagram

Degrees

Student Degree Information

Degrees tables


External Test Credit Results

This area contains the credit results (both generated and applied credits) associated with the external test scores (submitted by freshmen and transfer students) that are maintained by the Registrar's Office. Such tests and test scores include: AP (Advanced Placement), GCE (GCE A-Level Exams), International Baccalaureate Exams, Transfer Credit, Advanced Standing, and Freshman Essay Evaluation. Students whose undergraduate entrance term is in Summer 2003 (2003SU) or later are included in the tables.

External Test Credit Results tables

External Test Credit Results data model

External Test Scores

This area contains the external test score information for freshmen and transfer students. The test scores contain all tests and test scores maintained by the Registrar's Office for: Advanced Placement, International Baccalaureate Exams, GCE A-Level Exams, Transfer Credit, Advanced Standing, and Freshman Essay Evaluation. Students whose undergraduate entrance term is in Summer 2003 (2003SU) or later are included in the tables.

External Test Scores tables

External Test Scores data model

Graduate Awards

This area contains graduate award/appointment (ie. RA, TA and Fellowship) information for graduate students. The dollar amounts for tuition and stipends awarded to the students in each academic term are shown along with account and department information. Student enrollment information is also included.

Graduate Awards tables

Graduate Awards data model

IAP Non-Credit Activities

IAP non-credit activities for the current/upcoming IAP period. Data items include the activity title, description, enrollment & attendance, prerequisites, fee, and pre registration deadline. There is one record per activity as it is offered during IAP.

IAP Non-Credit Activities tables

IAP Non-Credit Activities data model

Pre Registration

This area contains pre-registration information of students for the upcoming academic term.

Pre Registration tables

Pre Registration data model

Student Minors

This area contains the proposed and completed minors of the students.

Student Minors tables

Student Minors data model

Subject Enrollment

This area contains student subject enrollment/registration information.

Subject Enrollment tables

Subject Enrollment data model

Subject Enrollment with Grades

Subject enrollment/registration records ("Class Lists") with grades

Subject Enrollment with Grades tables

Subject Enrollment with Grades data model

Subject Grades

This area contains student grade data, by academic terms and subjects

Subject Grades tables


UROP Project

Information about UROP (Undergraduate Research Opportunities Program) projects.

UROP Project tables

UROP Project data model