Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse DAPER ELIG FINAID Table


View exposing athletics financial aid eligibility records used for student-athlete aid administration.


Field Name

Description

Data Type

Length

FINANCIAL_AID_YEAR

Financial aid year as provided by the source.

VARCHAR2

4

FUND_CODE

Code identifying fund.

VARCHAR2

10

FUND_NAME

Fund name as provided by the source.

VARCHAR2

30

FUND_OFFERED_AMOUNT

Fund offered amount as provided by the source.

NUMBER

IS_CURRENT_ACADEMIC_TERM

Indicator identifying whether current academic term (Y/N).

VARCHAR2

1

MIT_ID

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

VARCHAR2

9

TERM_CODE

Code identifying term.

VARCHAR2

6

WAREHOUSE_LOAD_DATE

Date associated with warehouse load.

DATE