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 |
FINAID_AWARD_STATUS |
Contains all the financial aid award and note statuses. For each award status (eg. ACTL, CANC, ESTI), there exists all the possible loan promissory note status codes (eg. RECM, SIGN) for promissory loan notes of Federal Direct Loans, Perkins Loans, Parent Loans, and Technology Loans; and also the status codes of outside scholarship checks (eg. wether the checks were received or signed for deposit). |
Dimension |
Student Services Information Technology (SSIT) |
SENSITIVE |
Daily |
10-OCT-2008 |
FINAID_AID_APPLICANT |
(Access to this table is restricted to the staff of Student Financial Services. Other authorized users are given access to the FINAID APPLICANT table.) This table contains the yearly status and summary information of all prospective financial aid applicants, including incoming freshmen and applicants, at MIT since financial aid year 1994. Information includes biographical data, financial aid data, enrollment profile data, admissions data, and summary of award data. There is one record per aid applicant per financial aid year. |
Dimension |
Student Services Information Technology (SSIT) |
SENSITIVE |
Daily |
10-OCT-2008 |
FINAID_OUTSIDE_SCHOL |
This table contains outside scholarships information -- such as outside scholarhip codes, outside scholarship names, types, renewable status -- which may be included in a student's financial aid package. |
Dimension |
Student Services Information Technology (SSIT) |
SENSITIVE |
Daily |
10-OCT-2008 |
FINAID_FUND_MANAGEMENT |
This table contains aid year based financial aid fund rules and management information. Funds/awards are grouped by fund source (Federal, Institutional, Other), fund type (loan, grant, outside scholarship, tuition award, stipend, etc.) and fund category (a more detailed subgroup of fund type). |
Dimension |
Student Services Information Technology (SSIT) |
SENSITIVE |
Daily |
10-OCT-2008 |
FINAID_TERM |
Contains information about financial aid terms |
Dimension |
Student Services Information Technology (SSIT) |
MIT ONLY |
Academic Term |
01-SEP-2008 |
FINAID_AWARD_DETAIL |
This table contains financial aid award packages for each of the financial aid applicant since financial aid year 1994. Data in this table are organized by financial aid terms of an aid year and fund codes -- there is one record for each fund/award an aid applicant receives in a term of an aid year. |
Fact |
Student Services Information Technology (SSIT) |
SENSITIVE |
Daily |
10-OCT-2008 |
FINAID_APPLICANT |
This table contains the yearly status and summary information of all prospective financial aid applicants, including incoming freshmen and applicants, at MIT since aid year 1994. Information includes biographical data, financial aid data, enrollment profile data, admissions data, and summary of award data. There is one record per aid applicant per financial aid year. |
Dimension |
Student Services Information Technology (SSIT) |
SENSITIVE |
Daily |
10-OCT-2008 |