FAID APPLICATION INFO Table
View exposing financial-aid application detail including residency, family, income, asset, tax, citizenship, dependency, and application-processing attributes used for need analysis and reporting.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
ANNUAL_PARENT_DEBT_INCOME |
Annual parent debt income associated with the record. |
NUMBER |
19 |
CC_TFC |
Cc tfc associated with the record. |
NUMBER |
19 |
CITIZEN_CODE |
Code identifying citizen. |
VARCHAR2 |
1 |
CUST_TTL_INC |
Cust ttl inc associated with the record. |
NUMBER |
|
EFM_TFC |
Efm tfc associated with the record. |
NUMBER |
19 |
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 |
FIRST_BACHELOR_BY_7_1_96 |
First bachelor by 7 1 96 associated with the record. |
VARCHAR2 |
1 |
HIGH_SCHOOL_NAME |
High school name associated with the record. |
VARCHAR2 |
50 |
HOME_PURCH_PRICE |
Home purch price associated with the record. |
NUMBER |
19 |
HOUSING_STATUS |
Housing status associated with the record. |
VARCHAR2 |
1 |
I_S_GENDER |
I s gender associated with the record. |
VARCHAR2 |
1 |
I_VABENEIFITS |
I vabeneifits associated with the record. |
NUMBER |
19 |
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 |
NATURAL_STAT |
Natural stat associated with the record. |
VARCHAR2 |
1 |
ORIGINAL_NEED |
Original need associated with the record. |
NUMBER |
27,6 |
OTHER_NONREPORTED_ASSETS |
Other nonreported assets associated with the record. |
NUMBER |
19 |
OTHER_TAXABLE |
Other taxable associated with the record. |
NUMBER |
19 |
OWED_TO_PARENT_BY_OTHER |
Owed to parent by other associated with the record. |
NUMBER |
19 |
PARENT1_INCOME_WORK |
Parent1 income work associated with the record. |
NUMBER |
19 |
PARENT1_NAME |
Parent1 name associated with the person. |
VARCHAR2 |
20 |
PARENT2_INCOME_WORK |
Parent2 income work associated with the record. |
NUMBER |
19 |
PARENT2_NAME |
Parent2 name associated with the person. |
VARCHAR2 |
20 |
PARENT_1_AGE |
Parent 1 age associated with the record. |
NUMBER |
|
PARENT_2_AGE |
Parent 2 age associated with the record. |
NUMBER |
|
PARENT_AGI |
Parent agi associated with the record. |
NUMBER |
19 |
PARENT_AMOUNT_OWED_TO_OTHER |
Parent amount owed to other associated with the record. |
NUMBER |
19 |
PARENT_ANNUAL_DEBT_PAYMENT |
Parent annual debt payment associated with the record. |
NUMBER |
19 |
PARENT_ANNUAL_UTILITY_EXPENSE |
Parent annual utility expense associated with the record. |
NUMBER |
19 |
PARENT_BUSINESS_DEBT |
Parent business debt associated with the record. |
NUMBER |
19 |
PARENT_BUSINESS_VALUE |
Parent business value associated with the record. |
NUMBER |
19 |
PARENT_CASH_HOLD |
Parent cash hold associated with the record. |
NUMBER |
19 |
PARENT_CNTRY_RESIDENCE_INTL |
Parent cntry residence intl associated with the record. |
VARCHAR2 |
2 |
PARENT_CONTRIB |
Parent contrib associated with the record. |
NUMBER |
19 |
PARENT_EMAIL |
Parent email associated with the record. |
VARCHAR2 |
50 |
PARENT_HOME_DEBT |
Parent home debt associated with the record. |
NUMBER |
19 |
PARENT_HOME_VALUE |
Parent home value associated with the record. |
NUMBER |
19 |
PARENT_INVESTMENT_DEBT |
Parent investment debt associated with the record. |
NUMBER |
19 |
PARENT_INVESTMENT_VALUE |
Parent investment value associated with the record. |
NUMBER |
19 |
PARENT_ITEMIZED_DEDUCTION |
Parent itemized deduction associated with the record. |
NUMBER |
19 |
PARENT_LAST_YEAR_INCOME |
Parent last year income associated with the record. |
NUMBER |
19 |
PARENT_MARITAL_STATUS |
Parent marital status associated with the record. |
VARCHAR2 |
1 |
PARENT_MEDICAL_DENTAL_EXPENSE |
Parent medical dental expense associated with the record. |
NUMBER |
19 |
PARENT_MONTHLY_MORTGAGE |
Parent monthly mortgage 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_OTHER_NON_RPT_EXPENSE |
Parent other non rpt expense associated with the record. |
NUMBER |
19 |
PARENT_PRIOR_UNTAX_INCOME |
Parent prior untax income associated with the record. |
NUMBER |
19 |
PARENT_REAL_ESTATE_DEBT |
Parent real estate debt associated with the record. |
NUMBER |
19 |
PARENT_REAL_ESTATE_VALUE |
Parent real estate value associated with the record. |
NUMBER |
19 |
PARENT_TAX_FILING_STATUS |
Parent tax filing status associated with the record. |
VARCHAR2 |
1 |
PARENT_TUITION_PAID |
Parent tuition paid associated with the record. |
NUMBER |
19 |
PAR_1_LAST_NAME |
Par 1 last name associated with the person. |
VARCHAR2 |
16 |
PAR_2_LAST_NAME |
Par 2 last name associated with the person. |
VARCHAR2 |
16 |
P_LEGAL_RES |
P legal res associated with the record. |
VARCHAR2 |
2 |
P_LEGAL_RES_D |
P legal res d associated with the record. |
DATE |
|
P_LEG_RES_BEF |
P leg res bef associated with the record. |
VARCHAR2 |
1 |
SAR_C_FLAG |
Sar c flag associated with the record. |
VARCHAR2 |
1 |
STUDENT_ACADEMIC_WAGES |
Student academic wages associated with the record. |
NUMBER |
19 |
STUDENT_AGI |
Student agi associated with the record. |
NUMBER |
19 |
STUDENT_AID_STATUS |
Student aid status associated with the record. |
VARCHAR2 |
10 |
STUDENT_APPLICATION_RECD_DT |
Student application recd dt associated with the record. |
DATE |
|
STUDENT_APPLICATION_TYPE |
Student application type associated with the record. |
VARCHAR2 |
1 |
STUDENT_BIRTHDATE |
Date of birth associated with the person. |
DATE |
|
STUDENT_CASH_HOLD |
Student cash hold associated with the record. |
NUMBER |
19 |
STUDENT_CITIZEN_COUNTRY |
Student citizen country associated with the record. |
VARCHAR2 |
25 |
STUDENT_CONTRIB |
Student contrib associated with the record. |
NUMBER |
19 |
STUDENT_DEPENDENCY |
Student dependency associated with the record. |
NUMBER |
|
STUDENT_HOME_DEBT |
Student home debt associated with the record. |
NUMBER |
19 |
STUDENT_HOME_VALUE |
Student home value associated with the record. |
NUMBER |
19 |
STUDENT_INCOME |
Student income associated with the record. |
NUMBER |
19 |
STUDENT_INTEREST_EMPLOYMENT |
Student interest employment associated with the record. |
VARCHAR2 |
1 |
STUDENT_INTEREST_LOAN |
Student interest loan associated with the record. |
VARCHAR2 |
1 |
STUDENT_INTEREST_PAR_LOAN |
Student interest par loan associated with the record. |
VARCHAR2 |
1 |
STUDENT_INVESTMENT_DEBT |
Student investment debt associated with the record. |
NUMBER |
19 |
STUDENT_INVESTMENT_VALUE |
Student investment value associated with the record. |
NUMBER |
19 |
STUDENT_ITEMIZED_DEDUCTION |
Student itemized deduction associated with the record. |
NUMBER |
19 |
STUDENT_MARITAL_STATUS |
Student marital status associated with the record. |
VARCHAR2 |
1 |
STUDENT_MEDICAL_DENTAL_EXPENSE |
Student medical dental expense 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_PROFILE_REG_RECD_DT |
Student profile reg recd dt associated with the record. |
DATE |
|
STUDENT_REG_TYPE |
Student reg type associated with the record. |
VARCHAR2 |
1 |
STUDENT_SUMMER_WAGES |
Student summer wages associated with the record. |
NUMBER |
19 |
STUDENT_TAX_FILING_STATUS |
Student tax filing status associated with the record. |
VARCHAR2 |
2 |
STUDENT_TOKEN |
Student token associated with the record. |
NUMBER |
|
STUDENT_YEAR_IN_SCHOOL |
Student year in school associated with the record. |
NUMBER |
|
STU_AWARD_YEAR_TOKEN |
Stu award year token associated with the record. |
NUMBER |
|
S_LEGAL_RES |
S legal res associated with the record. |
VARCHAR2 |
2 |
S_LEGAL_RES_D |
S legal res d associated with the record. |
DATE |
|
S_LEG_RES_BEF |
S leg res bef associated with the record. |
VARCHAR2 |
1 |
TOTAL_PAR_CONTRIB |
Total par contrib 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 |