FAID NEED ANALYSIS Table
XXX
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
BUDGET_DURATION |
XXX |
NUMBER |
4,1 |
FAID_APPLICANT_KEY |
XXX |
VARCHAR2 |
21 |
FAID_YEAR |
XXX |
NUMBER |
|
FAID_YEAR_DESC |
XXX |
VARCHAR2 |
23 |
INAR_FORMULA |
XXX |
VARCHAR2 |
1 |
METHODOLOGY_TYPE |
Codes for the different types of methodology: FM (Federal Methodology), IMC (Institutional Methodology for Custodial Parents), and IMN (Instituional Methodology for Non-custodial parents) |
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 |
Adjusted Gross Income of parent(s) |
NUMBER |
19 |
PARENT_ASSET_CONTRIB |
XXX |
NUMBER |
19 |
PARENT_AVAILABLE_INCOME |
XXX |
NUMBER |
19 |
PARENT_CASH |
XXX |
NUMBER |
19 |
PARENT_CONTRIB |
Parent Contribution |
NUMBER |
19 |
PARENT_HOME_EQUITY |
XXX |
NUMBER |
19 |
PARENT_INCOME_CONTRIB |
XXX |
NUMBER |
19 |
PARENT_MARITAL_STATUS |
Marital status of student/aid_applicant's parent |
VARCHAR2 |
1 |
PARENT_NET_WORTH |
XXX |
NUMBER |
19 |
PARENT_NUM_IN_COLLEGE |
XXX |
NUMBER |
|
PARENT_NUM_IN_FAMILY |
XXX |
NUMBER |
|
PARENT_REAL_ESTATE_EQUITY |
XXX |
NUMBER |
19 |
PARENT_TOTAL_ALLOWANCE |
XXX |
NUMBER |
19 |
PARENT_TOTAL_CONTRIB |
XXX |
NUMBER |
19 |
PARENT_TOTAL_INCOME |
Parent Total Income=parent adjusted gross income + parent untaxed income - parent income exclusions + mit add back (parent PJ adjustment) |
NUMBER |
19 |
PARENT_UNTAXED_INCOME |
XXX |
NUMBER |
19 |
STUDENT_AGI |
XXX |
NUMBER |
19 |
STUDENT_AVAILABLE_INCOME |
XXX |
NUMBER |
19 |
STUDENT_CASH |
XXX |
NUMBER |
19 |
STUDENT_CONTRIB |
Student Contribution |
NUMBER |
19 |
STUDENT_DEPENDENCY |
XXX |
VARCHAR2 |
1 |
STUDENT_HOME_EQUITY |
XXX |
NUMBER |
19 |
STUDENT_INCOME_CONTRIB |
XXX |
NUMBER |
19 |
STUDENT_MARITAL_STATUS |
Marital status of student/aid_applicant |
VARCHAR2 |
1 |
STUDENT_NET_WORTH |
XXX |
NUMBER |
19 |
STUDENT_NUM_IN_COLLEGE |
XXX |
NUMBER |
|
STUDENT_NUM_IN_FAMILY |
XXX |
NUMBER |
|
STUDENT_REAL_ESTATE_EQUITY |
XXX |
NUMBER |
19 |
STUDENT_TOKEN |
XXX |
NUMBER |
|
STUDENT_TOTAL_ALLOWANCE |
XXX |
NUMBER |
19 |
STUDENT_TOTAL_CONTRIB |
XXX |
NUMBER |
19 |
STUDENT_TOTAL_INCOME |
Student Total Income=student adjusted gross income+student untaxed income - student income exclusions + student PJ adjustment |
NUMBER |
19 |
STUDENT_UNTAXED_INCOME |
XXX |
NUMBER |
19 |
STU_AWARD_YEAR_TOKEN |
XXX |
NUMBER |
|
STU_GROSSINC |
XXX |
NUMBER |
|
TOTAL_INCOME |
XXX |
NUMBER |
19 |
WAREHOUSE_INSERT_TIMESTAMP |
XXX |
DATE |
|
WAREHOUSE_UPDATE_TIMESTAMP |
XXX |
DATE |