FINAID FUND MANAGEMENT Table
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).
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
AID_YEAR |
Financial aid year. |
VARCHAR2 |
4 |
DISBURSE_DETAIL_CODE |
The detail code for disbursing the fund to the student's account. |
VARCHAR2 |
4 |
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 |
FINAID_FUND_MANAGEMENT_KEY |
XXX |
VARCHAR2 |
10 |
FUND_CATEGORY |
Categories of the financial aid funds (which can be considered as "subdivisions" of FUND_TYPE). Values include: MIT grant, PELL grant, SEOG grant, Federal Direct Loan, Federal Parent Loan, Technology Loan, Other Institutional Loan, Outside Scholarship, College Work Study, Stipend, Tuition, etc. |
VARCHAR2 |
30 |
FUND_CODE |
Financial aid fund code. Examples: PERKNL, STADFL, TLFXXL, C1950$ |
VARCHAR2 |
6 |
FUND_ORIGINATING_DEPT |
The department code (eg. SFAO=Student Financial Aid Office, 15=Sloan School of Management) of the department which enters/awards the fund. |
VARCHAR2 |
4 |
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 |
4 |
IS_AUTO_PACKAGE |
Whether this fund/award is automatically assigned to a financial aid applicant's award package. |
VARCHAR2 |
1 |
IS_DISBURSABLE |
Whether the fund awarded can be disbursed to the student's bursary account. Y=Yes, N=No |
VARCHAR2 |
1 |
IS_REDUCING_NEED |
Whether this fund/award will reduce the amount of financial aid need of the aid applicant. |
VARCHAR2 |
1 |
IS_REPLACING_TFC |
XXX |
VARCHAR2 |
1 |
NEED_COMAKER |
Whether the fund requires a co-maker. Y=Yes, N=No, Blank=not applicable. |
VARCHAR2 |
1 |
REDUCE_SELF_HELP_PERCENT |
XXX |
VARCHAR2 |
4 |
USE_FED_LOAN_PROCESS |
Whether this fund/award is processed using the federal loan procedure |
VARCHAR2 |
1 |
USE_MIT_LOAN_PROCESS |
Whether this fund/award is processed using the MIT loan procedure |
VARCHAR2 |
1 |
WAREHOUSE_LOAD_DATE |
The date the record was loaded into the Data Warehouse from the source system. |
DATE |
8 |