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


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

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

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