Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse FINAID FUND Table


XXX


Field Name

Description

Data Type

Length

FINAID_FUND_KEY

Key identifying an entry in the FINAID FUND MANAGEMENT Table. This field should only be used for linking together the tables of FINAID FUND MANAGEMENT and FINAID AWARD DETAIL, not for reporting.

VARCHAR2

10

FUND_CODE

Financial aid fund code. Examples: PERKNL, STADFL, TLFXXL, C1950$

VARCHAR2

10

FUND_SOURCE

Sources of the financial aid funds: FEDR=Federal, INST=Institution, OTHR=Other source.

VARCHAR2

4

FUND_TITLE

The descriptive title of financial aid fund. Examples: "Federal Perkins Loan" for PERKNL, "Federal Direct Loan Subsidized" for STADFL, "MIT Uncosigned Technology Loan" for TLFXXL, "Class of 1950 Fund" for C1950$.

VARCHAR2

30

FUND_TYPE

Types of financial aid fund: Grant, Loan, Outside Scholarship, Parent Loan, Work; and applicable for Graduate Awards only: Stipend (STIP), Medical Insurance (INS), Tuition (TUIT), and Subsidy (SUBS). INS=Medical Insurance portion

VARCHAR2

30

WAREHOUSE_LOAD_DATE

The date the record was loaded into the Data Warehouse from the source system.

DATE