FINAID NEED ANALYSIS DETAIL Table
View exposing financial aid need analysis detail records used to calculate student aid eligibility.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
AID_APPLICANT_KEY |
Surrogate key identifying the aid applicant. |
VARCHAR2 |
13 |
DEGREE_BY_JULY_INDICATOR |
Degree by july indicator associated with the record. |
VARCHAR2 |
1 |
DEPENDENCY_STATUS |
Dependency status associated with the record. |
VARCHAR2 |
1 |
EFC_OFFICIAL_INDICATOR |
Efc official indicator associated with the record. |
VARCHAR2 |
1 |
ESTIMATED_YEAR |
Estimated year associated with the record. |
VARCHAR2 |
1 |
ESTRANGED_PARENTS_INDICATOR |
Estranged parents indicator associated with the record. |
VARCHAR2 |
1 |
EST_FAMILY_CONTRIB |
Est family contrib associated with the record. |
NUMBER |
11,2 |
EST_FAMILY_CONTRIB_9MTH |
Est family contrib 9mth associated with the record. |
NUMBER |
11,2 |
EXPECTED_GRAD_DATE |
Date associated with expected grad. |
VARCHAR2 |
4 |
EXPECTED_LOAD |
Expected load associated with the record. |
VARCHAR2 |
2 |
FAMILY_INCOME |
Family income associated with the record. |
NUMBER |
11,2 |
FATHER_WAGES |
Father wages associated with the record. |
NUMBER |
11,2 |
FEDERAL_BENEFITS |
Federal benefits associated with the record. |
NUMBER |
11,2 |
FINAID_YEAR_KEY |
Surrogate key identifying the finaid year. |
VARCHAR2 |
4 |
FISAP_ACTIVITY_DATE |
Date associated with fisap activity. |
DATE |
|
FISAP_ISIR_ID |
Business identifier for the fisap isir. |
VARCHAR2 |
10 |
FISAP_ISIR_TRAN_NUMBER |
Fisap isir tran number associated with the record. |
NUMBER |
6 |
FISAP_PTI |
Fisap pti associated with the record. |
NUMBER |
11,2 |
FISAP_STI |
Fisap sti associated with the record. |
NUMBER |
11,2 |
IN_DEFAULT |
In default associated with the record. |
VARCHAR2 |
1 |
LAST_ACTIVITY_DATE |
Date associated with last activity. |
DATE |
|
LAST_ACTIVITY_SOURCE |
Last activity source associated with the record. |
VARCHAR2 |
35 |
METHODOLOGY_TYPE_KEY |
Surrogate key identifying the methodology type. |
VARCHAR2 |
4 |
MIT_ID |
MIT ID number of the person. Use this field to join with other tables containing data about people at MIT. |
VARCHAR2 |
9 |
MIT_INCOME_ADDBACK |
Mit income addback associated with the record. |
NUMBER |
11,2 |
MOTHER_WAGES |
Mother wages associated with the record. |
NUMBER |
11,2 |
NON_TAXABLE_INCOME |
Non taxable income associated with the record. |
NUMBER |
11,2 |
OWES_REFUND |
Owes refund associated with the record. |
VARCHAR2 |
1 |
PARENT_ADJUSTED_GROSS_INCOME |
Parent adjusted gross income associated with the record. |
NUMBER |
11,2 |
PARENT_CONTRIB |
Parent contrib associated with the record. |
NUMBER |
11,2 |
PARENT_CONTRIB_9MTH |
Parent contrib 9mth associated with the record. |
NUMBER |
11,2 |
PARENT_INCOME_EXCLUSION |
Parent income exclusion associated with the record. |
NUMBER |
11,2 |
PARENT_MARITAL_STATUS |
Parent marital status associated with the record. |
VARCHAR2 |
1 |
PARENT_NUMBER_IN_COLLEGE |
Parent number in college associated with the record. |
NUMBER |
2 |
PARENT_NUMBER_IN_FAMILY |
Parent number in family associated with the record. |
NUMBER |
2 |
PARENT_TAX_FILING_STATUS |
Parent tax filing status associated with the record. |
VARCHAR2 |
1 |
PARENT_TOTAL_INCOME |
Parent total income associated with the record. |
NUMBER |
11,2 |
PARENT_UNTAXED_INCOME |
Parent untaxed income associated with the record. |
NUMBER |
11,2 |
REASON_CODE |
Code identifying reason. |
VARCHAR2 |
5 |
SPOUSE_WAGES |
Spouse wages associated with the record. |
NUMBER |
11,2 |
STUDENT_AGI_OR_WAGES |
Student agi or wages associated with the record. |
NUMBER |
11,2 |
STUDENT_CHILD_SUPPORT_RCVD |
Student child support rcvd associated with the record. |
NUMBER |
11,2 |
STUDENT_CONTRIB |
Student contrib associated with the record. |
NUMBER |
11,2 |
STUDENT_CONTRIB_9MTH |
Student contrib 9mth associated with the record. |
NUMBER |
11,2 |
STUDENT_CONTRIB_ASSETS |
Student contrib assets associated with the record. |
NUMBER |
11,2 |
STUDENT_CONTRIB_ASSETS_9MTH |
Student contrib assets 9mth associated with the record. |
NUMBER |
11,2 |
STUDENT_CONTRIB_INCOME |
Student contrib income associated with the record. |
NUMBER |
11,2 |
STUDENT_CONTRIB_INCOME_9MTH |
Student contrib income 9mth associated with the record. |
NUMBER |
11,2 |
STUDENT_EARNED_INCOME_CREDIT |
Student earned income credit associated with the record. |
NUMBER |
11,2 |
STUDENT_INCOME_EXCLUSION |
Student income exclusion associated with the record. |
NUMBER |
11,2 |
STUDENT_MARITAL_STATUS |
Student marital status associated with the record. |
VARCHAR2 |
1 |
STUDENT_NUMBER_IN_COLLEGE |
Student number in college associated with the record. |
NUMBER |
2 |
STUDENT_NUMBER_IN_FAMILY |
Student number in family associated with the record. |
NUMBER |
2 |
STUDENT_OTHER_UNTAXED_INCOME |
Student other untaxed income associated with the record. |
NUMBER |
11,2 |
STUDENT_PJ_ADJUSTMENT |
Student pj adjustment associated with the record. |
NUMBER |
11,2 |
STUDENT_TAX_FILING_STATUS |
Student tax filing status associated with the record. |
VARCHAR2 |
1 |
STUDENT_TOTAL_INCOME |
Student total income associated with the record. |
NUMBER |
11,2 |
STUDENT_WAGES |
Student wages associated with the record. |
NUMBER |
11,2 |
VERIFICATION_MESSAGE |
Verification message associated with the record. |
VARCHAR2 |
1 |
VERIFICATION_PRIORITY |
Verification priority associated with the record. |
VARCHAR2 |
2 |
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |