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
ASA Early Return Requests	Requests of early return resources by the ASA (Association of Student Activities) recognized student groups	ASA Early Return Requests tables	ASA Early Return Requests data model
ASA Midway Requests	Requests of midway sapce by the ASA (Association of Student Activities) recognized student groups.	ASA Midway Requests tables	ASA Midway Requests data model
ASA Resource Allocations	Resource allocations of the ASA (Association of Student Activities) recognized student groups	ASA Resource Allocations tables	ASA Resource Allocations data model
ASA Resource Requests	Requests of resource allocations (Locker, bulletin board, office, and mailbox) by the ASA (Association of Student Activities) recognized student groups.	ASA Resource Requests tables	ASA Resource Requests data model
ASA Student Group Officers	Recognized student groups and their officers in the Association of Student Activities.	ASA Student Group Officers tables	ASA Student Group Officers data model
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
Financial Aid Awards	This area contains student financial aid award information. You may find in this area the complete financial aid packages of student financial aid applicants for the financial aid year. Data items included in this area are: the offer amount, offer date, status, and the type and category of each award in the aid package; promissory loan note information; award disbursement information; as well as the biographical and enrollment information of the students for the financial aid year.	Financial Aid Awards tables	Financial Aid Awards data model
Financial Aid Campus Work	This area contains detailed distribution transactions of all student payroll data. The information may be used (1) for Financial Aid College Work Study Program (CWSP) classification and assignment, (2) in payroll verification (ie. so and so did work here from this date to that date), (3) as a record for actual payment to graduate students, and (4) as statistical analysis of student work at MIT.	Financial Aid Campus Work tables	Financial Aid Campus Work data model
Financial Aid Grant Packages	This area contains information about MIT grant assignments (including the specific grant and the awarded amount) for students who are eligible to receive MIT grant. Also included in this area is the Student Financial Aid MIT grant management data.	Financial Aid Grant Packages tables	Financial Aid Grant Packages data model
Financial Aid Work Summary	Financial Aid Student Campus Work Earnings summary data. The total amount of earnings for each student who works on campus in the financial aid year.	Financial Aid Work Summary tables	Financial Aid Work Summary data model
Graduate Awards	This area contains 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, allowing graduate administrators to report on those students who are enrolled in courses in their department.	Graduate Awards tables	Graduate Awards data model
Instructor Roles (WTW)	This area contains the "Who is Teaching What" (WTW) data -- information about the roles (Eg.: Lecturer, Tutor, Grader, Administrator) of instructors in different sections of subjects/courses, by academic terms, as recorded on MITSIS.	Instructor Roles (WTW) tables	Instructor Roles (WTW) 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	Subject Grades data model
UROP Project	Information about UROP (Undergraduate Research Opportunities Program) projects.	UROP Project tables	UROP Project data model