FAID NEED ANALYSIS Table
View exposing financial aid need analysis results by applicant and award year including calculated financial need measures, family contribution calculations, unmet need figures, and analysis methodology used for aid eligibility determination and packaging decisions.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
BUDGET_DURATION |
Budget duration associated with the record. |
NUMBER |
4,1 |
FAID_APPLICANT_KEY |
Surrogate key identifying the faid applicant. |
VARCHAR2 |
21 |
FAID_YEAR |
Faid year associated with the record. |
NUMBER |
|
FAID_YEAR_DESC |
Description of faid year. |
VARCHAR2 |
23 |
INAR_FORMULA |
Inar formula associated with the record. |
VARCHAR2 |
1 |
METHODOLOGY_TYPE |
Methodology type associated with the record. |
VARCHAR2 |
2 |
MIT_ID |
MIT ID number of the person. Use this field to join with other tables containing data about people at MIT. |
VARCHAR2 |
10 |
PARENT_AGI |
Parent agi associated with the record. |
NUMBER |
19 |
PARENT_ASSET_CONTRIB |
Parent asset contrib associated with the record. |
NUMBER |
19 |
PARENT_AVAILABLE_INCOME |
Parent available income associated with the record. |
NUMBER |
19 |
PARENT_CASH |
Parent cash associated with the record. |
NUMBER |
19 |
PARENT_CONTRIB |
Parent contrib associated with the record. |
NUMBER |
19 |
PARENT_HOME_EQUITY |
Parent home equity associated with the record. |
NUMBER |
19 |
PARENT_INCOME_CONTRIB |
Parent income contrib associated with the record. |
NUMBER |
19 |
PARENT_MARITAL_STATUS |
Parent marital status associated with the record. |
VARCHAR2 |
1 |
PARENT_NET_WORTH |
Parent net worth associated with the record. |
NUMBER |
19 |
PARENT_NUM_IN_COLLEGE |
Parent num in college associated with the record. |
NUMBER |
|
PARENT_NUM_IN_FAMILY |
Parent num in family associated with the record. |
NUMBER |
|
PARENT_REAL_ESTATE_EQUITY |
Parent real estate equity associated with the record. |
NUMBER |
19 |
PARENT_TOTAL_ALLOWANCE |
Parent total allowance associated with the record. |
NUMBER |
19 |
PARENT_TOTAL_CONTRIB |
Parent total contrib associated with the record. |
NUMBER |
19 |
PARENT_TOTAL_INCOME |
Parent total income associated with the record. |
NUMBER |
19 |
PARENT_UNTAXED_INCOME |
Parent untaxed income associated with the record. |
NUMBER |
19 |
STUDENT_AGI |
Student agi associated with the record. |
NUMBER |
19 |
STUDENT_AVAILABLE_INCOME |
Student available income associated with the record. |
NUMBER |
19 |
STUDENT_CASH |
Student cash associated with the record. |
NUMBER |
19 |
STUDENT_CONTRIB |
Student contrib associated with the record. |
NUMBER |
19 |
STUDENT_DEPENDENCY |
Student dependency associated with the record. |
VARCHAR2 |
1 |
STUDENT_HOME_EQUITY |
Student home equity associated with the record. |
NUMBER |
19 |
STUDENT_INCOME_CONTRIB |
Student income contrib associated with the record. |
NUMBER |
19 |
STUDENT_MARITAL_STATUS |
Student marital status associated with the record. |
VARCHAR2 |
1 |
STUDENT_NET_WORTH |
Student net worth associated with the record. |
NUMBER |
19 |
STUDENT_NUM_IN_COLLEGE |
Student num in college associated with the record. |
NUMBER |
|
STUDENT_NUM_IN_FAMILY |
Student num in family associated with the record. |
NUMBER |
|
STUDENT_REAL_ESTATE_EQUITY |
Student real estate equity associated with the record. |
NUMBER |
19 |
STUDENT_TOKEN |
Student token associated with the record. |
NUMBER |
|
STUDENT_TOTAL_ALLOWANCE |
Student total allowance associated with the record. |
NUMBER |
19 |
STUDENT_TOTAL_CONTRIB |
Student total contrib associated with the record. |
NUMBER |
19 |
STUDENT_TOTAL_INCOME |
Student total income associated with the record. |
NUMBER |
19 |
STUDENT_UNTAXED_INCOME |
Student untaxed income associated with the record. |
NUMBER |
19 |
STU_AWARD_YEAR_TOKEN |
Stu award year token associated with the record. |
NUMBER |
|
STU_GROSSINC |
Stu grossinc associated with the record. |
NUMBER |
|
TOTAL_INCOME |
Total income associated with the record. |
NUMBER |
19 |
WAREHOUSE_INSERT_TIMESTAMP |
Warehouse insert timestamp associated with the warehouse record. |
DATE |
|
WAREHOUSE_UPDATE_TIMESTAMP |
Warehouse update timestamp associated with the warehouse record. |
DATE |