FINAID AWARD DETAIL Table
View exposing detailed financial aid award records associated with student financial aid packages and award allocations.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
AID_APPLICANT_KEY |
Surrogate key identifying the aid applicant. |
VARCHAR2 |
13 |
AWARD_STATUS_DATE |
Date associated with award status. |
DATE |
|
AWARD_STATUS_KEY |
Surrogate key identifying the award status. |
VARCHAR2 |
4 |
DISB_SCHEDULE_AMOUNT |
Disb schedule amount associated with the record. |
VARCHAR2 |
1 |
DISB_SCHEDULE_DATE |
Date associated with disb schedule. |
VARCHAR2 |
1 |
EDEXPRESS_LOAN_ID |
Business identifier for the edexpress loan. |
VARCHAR2 |
1 |
ENROLLMENT_KEY |
Surrogate key identifying the enrollment. |
VARCHAR2 |
15 |
FEDERAL_LOAN_FEE |
Federal loan fee associated with the record. |
NUMBER |
|
FINAID_FUND_KEY |
Surrogate key identifying the finaid fund. |
VARCHAR2 |
10 |
FINAID_FUND_MANAGEMENT_KEY |
Surrogate key identifying the finaid fund management. |
VARCHAR2 |
10 |
FINAID_TERM_KEY |
Surrogate key identifying the finaid term. |
VARCHAR2 |
6 |
FINAID_WORK_STUDENT_KEY |
Surrogate key identifying the finaid work student. |
VARCHAR2 |
13 |
LOAN_APPLICATION_NO |
Loan application no associated with the record. |
VARCHAR2 |
1 |
MEMO_AMOUNT |
Memo amount associated with the record. |
VARCHAR2 |
1 |
MEMO_DATE |
Date associated with memo. |
VARCHAR2 |
1 |
MEMO_EXPIRATION_DATE |
Date associated with memo expiration. |
VARCHAR2 |
1 |
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 |
Date associated with note. |
VARCHAR2 |
1 |
NOTE_ESTABLISH_DATE |
Date associated with note establish. |
VARCHAR2 |
1 |
NOTE_STATUS_DATE |
Date associated with note status. |
VARCHAR2 |
1 |
OFFER_AMOUNT |
Offer amount associated with the record. |
NUMBER |
11,2 |
OFFER_DATE |
Date associated with offer. |
DATE |
|
OUTSIDE_SCHOL_KEY |
Surrogate key identifying the outside schol. |
VARCHAR2 |
6 |
PAID_AMOUNT |
Paid amount associated with the record. |
NUMBER |
21,2 |
PAID_DATE |
Date associated with paid. |
DATE |
|
STUDENT_TERM_ENROLLMENT_KEY |
Surrogate key identifying the student term enrollment. |
VARCHAR2 |
15 |
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |