FAID APPLICANT MANUAL BUDGET Table
XXX
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
BUDGET_AMOUNT |
The estimated amount for a budget item (eg. Tuition, Room, Books) in a financial aid year. |
NUMBER |
|
BUDGET_CATEGORY_DESCRIPTION |
XXX |
VARCHAR2 |
20 |
BUDGET_CATEGORY_TOKEN |
XXX |
NUMBER |
|
BUDGET_TYPE |
The budget type codes: FEDR=Federal, INST=Institutional, PELL=Pell. The method applied in calculating the total budget amount (or the total cost of attendance) of the student for an aid year. |
VARCHAR2 |
1 |
FAID_APPLICANT_KEY |
XXX |
VARCHAR2 |
21 |
FAID_TERM |
XXX |
VARCHAR2 |
13 |
FAID_YEAR |
XXX |
NUMBER |
|
FAID_YEAR_DESC |
XXX |
VARCHAR2 |
23 |
MITSIS_TERM_CODE |
XXX |
VARCHAR2 |
42 |
MIT_ID |
MIT ID number of the person. Use this field to join with other tables containing data about people at MIT. |
VARCHAR2 |
10 |
POE_TOKEN |
XXX |
NUMBER |
|
STUDENT_TOKEN |
XXX |
NUMBER |
|
STU_AWARD_YEAR_TOKEN |
XXX |
NUMBER |
|
WAREHOUSE_INSERT_TIMESTAMP |
XXX |
DATE |
|
WAREHOUSE_UPDATE_TIMESTAMP |
XXX |
DATE |