FINAID GRANT PCKG DETAIL Table
Contains the detail of the current package of "MIT Alumni/ae and Friends" fund assignments for students who have been awarded MIT Grant in a financial aid year. Data since financial aid year 1994 are included in this table.
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 |
ASSIGNED_AMOUNT |
The amount assigned/awarded to a student with MIT Grant. |
NUMBER |
13 |
DATE_ASSIGNED |
Date when the assignment was made. |
DATE |
8 |
DATE_CHARGED |
Date when the assignment was charged to SAP?? |
DATE |
8 |
FINAID_GRANT_KEY |
Key indentifying an entry in the FINAID GRANT Table. This field should only be used for linking tables together, NOT for reporting. |
VARCHAR2 |
10 |
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 |
IS_CHARGED |
Whether the assignment has been charged to SAP?? Y=Yes, N=No |
VARCHAR2 |
1 |
IS_LOCKED |
Whether the assignment is locked, ie. not changeable; Y=Yes, N=No. |
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 |
PACKAGE_SEQ_NO |
The sequence number of the current package of MIT grant assignments. |
NUMBER |
2 |
RECORD_COUNT |
A counter for number of records. |
NUMBER |
1 |
WAREHOUSE_LOAD_DATE |
The date the record was loaded into the Data Warehouse from the source system. |
DATE |
8 |