FINAID AWARD DETAIL Table
This table contains financial aid award packages for each of the financial aid applicant since financial aid year 1994. Data in this table are organized by financial aid terms of an aid year and fund codes -- there is one record for each fund/award an aid applicant receives in a term of an aid year.
Field Name |
Description |
Data Type |
Length |
---|---|---|---|
AID_APPLICANT_KEY |
Key identifying an entry in the Financial Aid Applicant Table. This field should only be used for linking tables together, not for reporting. The field is a concatenation of the fields of MIT ID and Aid Year |
VARCHAR2 |
13 |
AWARD_STATUS_DATE |
The date when the status (eg. ACTL, CANC, KEPT) of the financial aid award was last modified. |
DATE |
8 |
AWARD_STATUS_KEY |
Key identifying an entry in the FINAID AWARD STATUS Table. This field should only be used for linking together the tables of FINAID AWARD STATUS and FINAID AWARD DETAIL, not for reporting. |
VARCHAR2 |
15 |
DISB_SCHEDULE_AMOUNT |
The scheduled amount of an award to be disbursed to the student's bursary account. |
NUMBER |
11 |
DISB_SCHEDULE_DATE |
The date in which a certain amount of the award is scheduled to be disbursed to the student's bursary account. |
DATE |
8 |
EDEXPRESS_LOAN_ID |
Federal Direct Loan Identification number |
VARCHAR2 |
21 |
ENROLLMENT_KEY |
Use this field to join the STUDENT TERM ENROLLMENT table with another student table which contains the same-name KEY field. This field should only be used for joining tables, not for reporting. |
VARCHAR2 |
15 |
FEDERAL_LOAN_FEE |
The amount of fee that the loan recipient must pay for the processing of a federal loan. The fee is usually 3-4% of the offer amount. |
NUMBER |
11 |
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 |
FINAID_TERM_KEY |
Key identifying an entry in the FINAID TERM Table. This field should only be used for linking together the tables of FINAID TERM and FINAID AWARD DETAIL, not for reporting. |
VARCHAR2 |
6 |
FINAID_WORK_STUDENT_KEY |
Use this field to join between the FINAID WORK STUDENT table to a financial aid fact table which contains the same-name field, eg. FINAID WORK EARNINGS DETAIL, FINAID PAYROLL DIST DETAIL. |
VARCHAR2 |
13 |
LOAN_APPLICATION_NO |
A number (eg. 1,2,3, ?) identifies the loan application/note of a Federal Direct Loan, a Federal Perkins Loan, or a Technology Loan. |
VARCHAR2 |
3 |
MEMO_AMOUNT |
The amount of an award posted to the student's bursary account as a "memo" or "expected payment". |
NUMBER |
22 |
MEMO_DATE |
The date when an award was posted to the student's bursary account as a "memo" or "expected payment". |
DATE |
8 |
MEMO_EXPIRATION_DATE |
The date when the "memo" or "expected payment" posted to the student's bursary account expires. |
DATE |
8 |
MIT_ID |
MIT ID number of the person. Use this field to join with other tables containing data about people at MIT. |
VARCHAR2 |
9 |
NOTE_DATE |
The date when the promissory loan note was actually signed -- the date appears on the note. |
DATE |
8 |
NOTE_ESTABLISH_DATE |
The date when the promissory loan note for the award was first established. |
DATE |
8 |
NOTE_STATUS_DATE |
The date when the status (eg. SIGN, RECM) of the promissory loan note was last modified. |
DATE |
8 |
OFFER_AMOUNT |
The amount of the award offered to the student. |
NUMBER |
11 |
OFFER_DATE |
The date when the award was offered to the student. |
DATE |
8 |
OUTSIDE_SCHOL_KEY |
Key identifying an entry in the FINAID OUTSIDE SCHOL table. This field should only be used for linking together the tables FINAID OUTSIDE SCHOL and FINAID AWARD DETAIL, not for reporting. STATUS Table. |
VARCHAR2 |
6 |
PAID_AMOUNT |
In the FINAID AWARD DETAIL Table, this field contains the total amount of the award paid to the student's bursary account. In the GRADUATE AWARD TERM DETAIL Table, this field contains the total amount paid to the student for this account number. |
NUMBER |
11 |
PAID_DATE |
The date when the award was paid to the student's bursary account. |
DATE |
8 |
STUDENT_TERM_ENROLLMENT_KEY |
Use this field to join to the STUDENT TERM ENROLLMENT table |
VARCHAR2 |
15 |
WAREHOUSE_LOAD_DATE |
The date the record was loaded into the Data Warehouse from the source system. |
DATE |
8 |