FINAID NEED ANALYSIS DETAIL Table
Contains the current set of need analysis records for a student in an aid year. A set of need analysis records for a student in an aid year consists of one to three entries which reflect the two different methodologies used by MIT: Federal Methodology (FM) and Institutional Methodology (IM). IM is divided into 2 categories: IMC for custodial parents and IMN for non-custodial parents. Data since financial aid year 1994 are included in this table.
Field Name |
Description |
Data Type |
Length |
---|---|---|---|
AID_APPLICANT_KEY |
Key identifying an entry in the Financial Aid Applicant Table. This field should only be used for linking tables together, not for reporting. The field is a concatenation of the fields of MIT ID and Aid Year |
VARCHAR2 |
13 |
DEGREE_BY_JULY_INDICATOR |
Whether the student will receive a degree by July (Summer) |
VARCHAR2 |
1 |
DEPENDENCY_STATUS |
The status of dependency of the student: I or D |
VARCHAR2 |
1 |
EFC_OFFICIAL_INDICATOR |
XXX |
VARCHAR2 |
1 |
ESTIMATED_YEAR |
XXX |
VARCHAR2 |
1 |
ESTRANGED_PARENTS_INDICATOR |
Estranged parents indicator |
VARCHAR2 |
1 |
EST_FAMILY_CONTRIB |
Total estimated family contribution; which is the sum of student contribution and parent contribution. |
NUMBER |
13 |
EST_FAMILY_CONTRIB_9MTH |
Total estimated family contribution for the 9-month academic year; which is the sum of student and parent contributions for the 9-month academic year. |
NUMBER |
13 |
EXPECTED_GRAD_DATE |
The month and year the student is expected to graduate |
VARCHAR2 |
4 |
EXPECTED_LOAD |
The expected course load, usually FT (Full Time) |
VARCHAR2 |
2 |
FAMILY_INCOME |
Family income, according to the need analysis methodology method. |
NUMBER |
13 |
FATHER_WAGES |
Father's Wages |
NUMBER |
13 |
FEDERAL_BENEFITS |
Federal benefits ??? |
NUMBER |
13 |
FINAID_YEAR_KEY |
Key identifying an entry in the FINAID YEAR Table. This field should only be used for linking tables together, not for reporting. |
VARCHAR2 |
4 |
FISAP_ACTIVITY_DATE |
FISAP activity date |
DATE |
8 |
FISAP_ISIR_ID |
FISAP/ISIR ID |
VARCHAR2 |
10 |
FISAP_ISIR_TRAN_NUMBER |
XXX |
NUMBER |
22 |
FISAP_PTI |
FISAP data |
NUMBER |
13 |
FISAP_STI |
FISAP data |
NUMBER |
13 |
IN_DEFAULT |
XXX |
VARCHAR2 |
1 |
LAST_ACTIVITY_DATE |
Date when information in the record was last updated. |
DATE |
8 |
LAST_ACTIVITY_SOURCE |
The person/administrator who last updated this record. |
VARCHAR2 |
35 |
METHODOLOGY_TYPE_KEY |
Key indentifying an entry in the Financial Aid Need Analysis Methodology Table. This field should only be used for linking together the tables of FINAID NA METHODOLOGY and FINAID NEED ANALYSIS DETAIL, NOT for reporting. |
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 |
xxx |
NUMBER |
13 |
MOTHER_WAGES |
Mother's Wages |
NUMBER |
13 |
NON_TAXABLE_INCOME |
Non taxable income |
NUMBER |
22 |
OWES_REFUND |
XXX |
VARCHAR2 |
1 |
PARENT_ADJUSTED_GROSS_INCOME |
XXX |
NUMBER |
22 |
PARENT_CONTRIB |
Parent Contribution |
NUMBER |
13 |
PARENT_CONTRIB_9MTH |
Parent Contribution for the 9-month academic year |
NUMBER |
13 |
PARENT_INCOME_EXCLUSION |
Parent's income exclusions |
NUMBER |
13 |
PARENT_MARITAL_STATUS |
Marital status of student/aid_applicant's parent |
VARCHAR2 |
1 |
PARENT_NUMBER_IN_COLLEGE |
xxx |
NUMBER |
2 |
PARENT_NUMBER_IN_FAMILY |
xxx |
NUMBER |
2 |
PARENT_TAX_FILING_STATUS |
Parent's Tax Filing Status |
VARCHAR2 |
1 |
PARENT_TOTAL_INCOME |
Parent Total Income=parent adjusted gross income + parent untaxed income - parent income exclusions + mit add back (parent PJ adjustment) |
NUMBER |
13 |
PARENT_UNTAXED_INCOME |
XXX |
NUMBER |
22 |
REASON_CODE |
Reason code |
VARCHAR2 |
5 |
SPOUSE_WAGES |
Spouse's Wages |
NUMBER |
13 |
STUDENT_AGI_OR_WAGES |
Adjusted Gross Income or wages received by student |
NUMBER |
13 |
STUDENT_CHILD_SUPPORT_RCVD |
Child support received by student |
NUMBER |
13 |
STUDENT_CONTRIB |
Student Contribution |
NUMBER |
13 |
STUDENT_CONTRIB_9MTH |
Student Contribution for the 9-month academic year |
NUMBER |
13 |
STUDENT_CONTRIB_ASSETS |
Student Assets |
NUMBER |
13 |
STUDENT_CONTRIB_ASSETS_9MTH |
Student Assets for the 9-month academic year |
NUMBER |
13 |
STUDENT_CONTRIB_INCOME |
Student Income |
NUMBER |
13 |
STUDENT_CONTRIB_INCOME_9MTH |
Student Income for the 9-month academic year |
NUMBER |
13 |
STUDENT_EARNED_INCOME_CREDIT |
Student earned income credit |
NUMBER |
13 |
STUDENT_INCOME_EXCLUSION |
Student's income exclusion |
NUMBER |
13 |
STUDENT_MARITAL_STATUS |
Marital status of student/aid_applicant |
VARCHAR2 |
1 |
STUDENT_NUMBER_IN_COLLEGE |
XXX |
NUMBER |
2 |
STUDENT_NUMBER_IN_FAMILY |
xxx |
NUMBER |
2 |
STUDENT_OTHER_UNTAXED_INCOME |
Other untaxed income received by student |
NUMBER |
13 |
STUDENT_PJ_ADJUSTMENT |
xxx |
NUMBER |
13 |
STUDENT_TAX_FILING_STATUS |
Student's Tax Filing Status |
VARCHAR2 |
1 |
STUDENT_TOTAL_INCOME |
Student Total Income=student adjusted gross income+student untaxed income - student income exclusions + student PJ adjustment |
NUMBER |
13 |
STUDENT_WAGES |
Student's Wages |
NUMBER |
13 |
VERIFICATION_MESSAGE |
XXX |
VARCHAR2 |
1 |
VERIFICATION_PRIORITY |
XXX |
VARCHAR2 |
2 |
WAREHOUSE_LOAD_DATE |
The date the record was loaded into the Data Warehouse from the source system. |
DATE |
8 |