Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse Financial Aid 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

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

MIT Student Information System

SENSITIVE

Daily

08-JAN-2020

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

MIT Student Information System

SENSITIVE

Daily

08-JAN-2020

FINAID_TERM

Contains information about financial aid terms

Dimension

MIT Student Information System

MIT ONLY

Academic Term

01-SEP-2019

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

MIT Student Information System

SENSITIVE

Daily

08-JAN-2020

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

MIT Student Information System

SENSITIVE

Daily

08-JAN-2020

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

MIT Student Information System

SENSITIVE

Daily

08-JAN-2020

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

MIT Student Information System

SENSITIVE

Daily

08-JAN-2020