FINAID OUTSIDE INTEREST 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 |
104 |
FINAID_OUTSIDE_INTEREST_KEY |
XXX |
VARCHAR2 |
8 |
FINAID_YEAR_KEY |
Key identifying an entry in the FINAID YEAR Table. This field should only be used for linking tables together, not for reporting. |
VARCHAR2 |
4 |
LAST_ACTIVITY_DATE |
Date when information in the record was last updated. |
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 |
RECORD_COUNT |
A counter for number of records. |
NUMBER |
|
WAREHOUSE_LOAD_DATE |
The date the record was loaded into the Data Warehouse from the source system. |
DATE |