FINAID WK5 AWARD DETAIL Table
View exposing financial aid award detail records associated with weekly award processing cycles.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
AID_APPLICANT_KEY |
Surrogate key identifying the aid applicant. |
VARCHAR2 |
13 |
AID_YEAR |
Aid year associated with the record. |
VARCHAR2 |
4 |
AWARD_STATUS_DATE |
Date associated with award status. |
DATE |
|
AWARD_STATUS_KEY |
Surrogate key identifying the award status. |
VARCHAR2 |
15 |
DATA_LOAD_TERM |
Data load term associated with the record. |
VARCHAR2 |
6 |
DISB_SCHEDULE_AMOUNT |
Disb schedule amount associated with the record. |
NUMBER |
9,2 |
DISB_SCHEDULE_DATE |
Date associated with disb schedule. |
DATE |
|
EDEXPRESS_LOAN_ID |
Business identifier for the edexpress loan. |
VARCHAR2 |
21 |
FEDERAL_LOAN_FEE |
Federal loan fee associated with the record. |
NUMBER |
9,2 |
FINAID_FUND_KEY |
Surrogate key identifying the finaid fund. |
VARCHAR2 |
10 |
FINAID_TERM_KEY |
Surrogate key identifying the finaid term. |
VARCHAR2 |
6 |
LOAN_APPLICATION_NO |
Loan application no associated with the record. |
VARCHAR2 |
3 |
MEMO_AMOUNT |
Memo amount associated with the record. |
NUMBER |
9,2 |
MEMO_DATE |
Date associated with memo. |
DATE |
|
MEMO_EXPIRATION_DATE |
Date associated with memo expiration. |
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 |
Date associated with note. |
DATE |
|
NOTE_ESTABLISH_DATE |
Date associated with note establish. |
DATE |
|
NOTE_STATUS_DATE |
Date associated with note status. |
DATE |
|
OFFER_AMOUNT |
Offer amount associated with the record. |
NUMBER |
9,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 |
9,2 |
PAID_DATE |
Date associated with paid. |
DATE |
|
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |