FINAID WK5 AWARD DETAIL Table
XXX
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 |
AID_YEAR |
Financial aid year. |
VARCHAR2 |
4 |
AWARD_STATUS_DATE |
The date when the status (eg. ACTL, CANC, KEPT) of the financial aid award was last modified. |
DATE |
|
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 |
DATA_LOAD_TERM |
XXX |
VARCHAR2 |
6 |
DISB_SCHEDULE_AMOUNT |
The scheduled amount of an award to be disbursed to the student's bursary account. |
NUMBER |
9,2 |
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 |
|
EDEXPRESS_LOAN_ID |
Federal Direct Loan Identification number |
VARCHAR2 |
21 |
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 |
9,2 |
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_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 |
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 |
9,2 |
MEMO_DATE |
The date when an award was posted to the student's bursary account as a "memo" or "expected payment". |
DATE |
|
MEMO_EXPIRATION_DATE |
The date when the "memo" or "expected payment" posted to the student's bursary account expires. |
DATE |
|
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 |
|
NOTE_ESTABLISH_DATE |
The date when the promissory loan note for the award was first established. |
DATE |
|
NOTE_STATUS_DATE |
The date when the status (eg. SIGN, RECM) of the promissory loan note was last modified. |
DATE |
|
OFFER_AMOUNT |
The amount of the award offered to the student. |
NUMBER |
9,2 |
OFFER_DATE |
The date when the award was offered to the student. |
DATE |
|
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 |
9,2 |
PAID_DATE |
The date when the award was paid to the student's bursary account. |
DATE |
|
WAREHOUSE_LOAD_DATE |
The date the record was loaded into the Data Warehouse from the source system. |
DATE |