Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse Financial Aid Grant Packages


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_YEAR

Contains information about financial aid years

Dimension

MIT Student Information System

MIT ONLY

Academic Term

01-SEP-2019

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_GRANT

Contains aid year based rules and management information about the MIT Alumni/ae & Friends Funds (ie. MIT Grants or SubFunds).

Dimension

MIT Student Information System

SENSITIVE

Daily

08-JAN-2020

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_GRANT_PCKG_DETAIL

Contains the detail of the current package of "MIT Alumni/ae and Friends" fund assignments for students who have been awarded MIT Grant in a financial aid year. Data since financial aid year 1994 are included in this table.

Fact

MIT Student Information System

SENSITIVE

Daily

08-JAN-2020