Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse FINAID OUTSIDE INTEREST DETAIL Table


View exposing detailed records of outside scholarships or funding sources associated with student financial aid.


Field Name

Description

Data Type

Length

AID_APPLICANT_KEY

Surrogate key identifying the aid applicant.

VARCHAR2

104

FINAID_OUTSIDE_INTEREST_KEY

Surrogate key identifying the finaid outside interest.

VARCHAR2

8

FINAID_YEAR_KEY

Surrogate key identifying the finaid year.

VARCHAR2

4

LAST_ACTIVITY_DATE

Date associated with last activity.

DATE

MIT_ID

MIT ID number of the person. Use this field to join with other tables containing data about people at MIT.

VARCHAR2

9

RECORD_COUNT

Record count associated with the record.

NUMBER

WAREHOUSE_LOAD_DATE

Date the record was loaded into the data warehouse.

DATE