Skip to content Accesskey=4Skip to sub-navigation Accesskey=3View our Accessibility Options MIT Information Services and Technology Home About IS&T Contact IS&T Site Map Search Advanced Search
Getting StartedGetting Services by Topic or Alphabetically Getting Help

data warehouse logo

 
Related Links:
 

Data and Reporting Services


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

Subject Enrollment

This area contains student subject enrollment/registration information.

Subject Enrollment tables

Subject Enrollment data model

UROP Project

Information about UROP (Undergraduate Research Opportunities Program) projects.

UROP Project tables

UROP Project data model

MIT Home | Getting Started | Getting Services | Getting Help | About IS&T | Accessibility
Ask a technology question or send a comment about this web page.