FAID APPLICANT BUDGET ITEMS Table
View exposing financial-aid applicant budget-item detail by applicant, award year, term, and budget category including base and adjustment amounts and budget-item descriptions.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
BASE_BUDGET_AMOUNT |
Base budget amount associated with the record. |
NUMBER |
|
BUDCAT_ITEM_TOKEN |
Budcat item token associated with the record. |
NUMBER |
|
BUDGET_ADJUSTMENT_AMOUNT |
Budget adjustment amount associated with the record. |
NUMBER |
|
BUDGET_CATEGORY_DESC |
Description of budget category. |
VARCHAR2 |
20 |
BUDGET_CATEGORY_ITEM_DESC |
Description of budget category item. |
VARCHAR2 |
40 |
BUDGET_CATEGORY_TOKEN |
Budget category token associated with the record. |
NUMBER |
|
FAID_APPLICANT_KEY |
Surrogate key identifying the faid applicant. |
VARCHAR2 |
21 |
FAID_TERM |
Faid term associated with the record. |
VARCHAR2 |
13 |
FAID_YEAR |
Faid year associated with the record. |
NUMBER |
|
FAID_YEAR_DESC |
Description of faid year. |
VARCHAR2 |
23 |
MITSIS_TERM_CODE |
Code identifying mitsis term. |
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 |
SBI_DT_TOKEN |
Sbi dt token associated with the record. |
NUMBER |
|
STUDENT_TOKEN |
Student token associated with the record. |
NUMBER |
|
STU_AWARD_YEAR_TOKEN |
Stu award year token associated with the record. |
NUMBER |
|
WAREHOUSE_INSERT_TIMESTAMP |
Warehouse insert timestamp associated with the warehouse record. |
DATE |
|
WAREHOUSE_UPDATE_TIMESTAMP |
Warehouse update timestamp associated with the warehouse record. |
DATE |