FINAID GRANT Table
Contains aid year based rules and management information about the MIT Alumni/ae & Friends Funds (ie. MIT Grants or SubFunds).
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
ADJUSTMENT_AMOUNT |
Adjusted amount of MIT Grant |
NUMBER |
15 |
AID_YEAR |
Financial aid year. |
VARCHAR2 |
4 |
AMOUNT_TO_SPEND |
Amount available to spend in this subfund. |
NUMBER |
15 |
COST_COLLECTOR_KEY |
Key used to join the Cost Collector to the financial transaction, and to get the master data that were current at the time of the transaction. This field should only be used for joining data, NOT for reporting. |
VARCHAR2 |
12 |
ESTABLISHED_DATE |
Date when the subfund (MIT Grant) was first established/set up. |
DATE |
8 |
FINAID_GRANT_KEY |
Key indentifying an entry in the FINAID GRANT Table. This field should only be used for linking tables together, NOT for reporting. |
VARCHAR2 |
10 |
FUNDS_AMOUNT_AVAILABLE |
Amount available in this subfund. FUNDS_AMOUNT_AVAILABLE=AMOUNT_TO_SPEND+ADJUSTMENT_AMOUNT |
NUMBER |
15 |
GL_ACCOUNT_KEY |
Key used to join the GL_ACCOUNT to the financial transaction, and to get the master data that were current at the time of the transaction. This field should only be used for joining data, NOT for reporting. |
VARCHAR2 |
10 |
IS_EXPENDABLE |
XXX |
VARCHAR2 |
1 |
IS_RENEWABLE |
Whether this fund/award/outside scholarship is renewable for another year; Y=Yes, N=No |
VARCHAR2 |
1 |
IS_REPORTING |
Whether it is required to reporting back to the donor/alumni/friend regarding the assignment of this subfund; Y=Yes, N=No. |
VARCHAR2 |
1 |
LAST_ACTIVITY_DATE |
Date when information in the record was last updated. |
DATE |
8 |
MAX_AMOUNT_TO_AWARD |
The maximum amount to be assigned/awarded. |
NUMBER |
13 |
MIN_AMOUNT_TO_AWARD |
The minimum amount to be assigned/awarded. |
NUMBER |
13 |
NUMBER_OF_ASSIGNMENTS |
The total number of assignments which have been made against this subfund (grant). |
NUMBER |
4 |
NUMBER_OF_CHARGES |
The total number of charges (to SAP) which have been made against this subfund (grant). |
NUMBER |
4 |
REMAINING_AMOUNT_TO_ASSIGN |
Remaining amount in this subfund to assign to students with MIT Grant. |
NUMBER |
15 |
REMAINING_AMOUNT_TO_CHARGE |
The remaining amount of the subfund to be charged to SAP |
NUMBER |
15 |
RESTRICT_CODE |
A code identifying the restrictions tied to the assignment of the subfunds (MIT Grant). The restrictions are: "Unrestricted", "Restrictions", "Hand picked", "Preference". |
VARCHAR2 |
30 |
SELECTION_PRIORITY |
The selection priority of the subfund. Valid values are between 1 and 999, the lower the number, the higher the priority of assigning the subfund to a student with MIT Grant. |
NUMBER |
22 |
SFS_STEWARD_IND |
XXX |
VARCHAR2 |
1 |
SUBFUND_CODE |
A unique subfund code identifying a MIT grant. Eg.: MAC16# for Carl Gilbert Matching Fund for Year 2000, C1956$ for the Class of 1956 Scholarship Fund. |
VARCHAR2 |
6 |
SUBFUND_TITLE |
A descriptive title of the unique Subfund code. |
VARCHAR2 |
30 |
TOTAL_ASSIGNED_AMOUNT |
The total amount of this subfund which have been awarded/assigned to students with MIT Grant. |
NUMBER |
15 |
TOTAL_CHARGED_AMOUNT |
The total available amount of a subfund that has been charged to SAP |
NUMBER |
15 |
WAREHOUSE_LOAD_DATE |
The date the record was loaded into the Data Warehouse from the source system. |
DATE |
8 |