Data Warehouse

ANNUAL_PARENT_DEBT_INCOME

XXX

NUMBER

19

CC_TFC

XXX

NUMBER

19

CITIZEN_CODE

XXX

VARCHAR2

1

CUST_TTL_INC

XXX

NUMBER

EFM_TFC

XXX

NUMBER

19

FAID_APPLICANT_KEY

XXX

VARCHAR2

21

FAID_YEAR

XXX

NUMBER

FAID_YEAR_DESC

XXX

VARCHAR2

23

FIRST_BACHELOR_BY_7_1_96

XXX

VARCHAR2

1

HIGH_SCHOOL_NAME

XXX

VARCHAR2

50

HOME_PURCH_PRICE

XXX

NUMBER

19

HOUSING_STATUS

XXX

VARCHAR2

1

I_S_GENDER

XXX

VARCHAR2

1

I_VABENEIFITS

XXX

NUMBER

19

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

NATURAL_STAT

XXX

VARCHAR2

1

ORIGINAL_NEED

XXX

NUMBER

27,6

OTHER_NONREPORTED_ASSETS

XXX

NUMBER

19

OTHER_TAXABLE

XXX

NUMBER

19

OWED_TO_PARENT_BY_OTHER

XXX

NUMBER

19

PARENT1_INCOME_WORK

XXX

NUMBER

19

PARENT1_NAME

XXX

VARCHAR2

20

PARENT2_INCOME_WORK

XXX

NUMBER

19

PARENT2_NAME

XXX

VARCHAR2

20

PARENT_1_AGE

XXX

NUMBER

PARENT_2_AGE

XXX

NUMBER

PARENT_AGI

Adjusted Gross Income of parent(s)

NUMBER

19

PARENT_AMOUNT_OWED_TO_OTHER

XXX

NUMBER

19

PARENT_ANNUAL_DEBT_PAYMENT

XXX

NUMBER

19

PARENT_ANNUAL_UTILITY_EXPENSE

XXX

NUMBER

19

PARENT_BUSINESS_DEBT

XXX

NUMBER

19

PARENT_BUSINESS_VALUE

XXX

NUMBER

19

PARENT_CASH_HOLD

XXX

NUMBER

19

PARENT_CNTRY_RESIDENCE_INTL

XXX

VARCHAR2

2

PARENT_CONTRIB

Parent Contribution

NUMBER

19

PARENT_EMAIL

XXX

VARCHAR2

50

PARENT_HOME_DEBT

XXX

NUMBER

19

PARENT_HOME_VALUE

XXX

NUMBER

19

PARENT_INVESTMENT_DEBT

XXX

NUMBER

19

PARENT_INVESTMENT_VALUE

XXX

NUMBER

19

PARENT_ITEMIZED_DEDUCTION

XXX

NUMBER

19

PARENT_LAST_YEAR_INCOME

XXX

NUMBER

19

PARENT_MARITAL_STATUS

Marital status of student/aid_applicant's parent

VARCHAR2

1

PARENT_MEDICAL_DENTAL_EXPENSE

XXX

NUMBER

19

PARENT_MONTHLY_MORTGAGE

XXX

NUMBER

19

PARENT_NUM_IN_COLLEGE

XXX

NUMBER

PARENT_NUM_IN_FAMILY

XXX

NUMBER

PARENT_OTHER_NON_RPT_EXPENSE

XXX

NUMBER

19

PARENT_PRIOR_UNTAX_INCOME

XXX

NUMBER

19

PARENT_REAL_ESTATE_DEBT

XXX

NUMBER

19

PARENT_REAL_ESTATE_VALUE

XXX

NUMBER

19

PARENT_TAX_FILING_STATUS

Parent's Tax Filing Status

VARCHAR2

1

PARENT_TUITION_PAID

XXX

NUMBER

19

PAR_1_LAST_NAME

XXX

VARCHAR2

16

PAR_2_LAST_NAME

XXX

VARCHAR2

16

P_LEGAL_RES

XXX

VARCHAR2

2

P_LEGAL_RES_D

XXX

DATE

P_LEG_RES_BEF

XXX

VARCHAR2

1

SAR_C_FLAG

XXX

VARCHAR2

1

STUDENT_ACADEMIC_WAGES

XXX

NUMBER

19

STUDENT_AGI

XXX

NUMBER

19

STUDENT_AID_STATUS

XXX

VARCHAR2

10

STUDENT_APPLICATION_RECD_DT

XXX

DATE

STUDENT_APPLICATION_TYPE

XXX

VARCHAR2

1

STUDENT_BIRTHDATE

XXX

DATE

STUDENT_CASH_HOLD

XXX

NUMBER

19

STUDENT_CITIZEN_COUNTRY

XXX

VARCHAR2

25

STUDENT_CONTRIB

Student Contribution

NUMBER

19

STUDENT_DEPENDENCY

XXX

NUMBER

STUDENT_HOME_DEBT

XXX

NUMBER

19

STUDENT_HOME_VALUE

XXX

NUMBER

19

STUDENT_INCOME

XXX

NUMBER

19

STUDENT_INTEREST_EMPLOYMENT

XXX

VARCHAR2

1

STUDENT_INTEREST_LOAN

XXX

VARCHAR2

1

STUDENT_INTEREST_PAR_LOAN

XXX

VARCHAR2

1

STUDENT_INVESTMENT_DEBT

XXX

NUMBER

19

STUDENT_INVESTMENT_VALUE

XXX

NUMBER

19

STUDENT_ITEMIZED_DEDUCTION

XXX

NUMBER

19

STUDENT_MARITAL_STATUS

Marital status of student/aid_applicant

VARCHAR2

1

STUDENT_MEDICAL_DENTAL_EXPENSE

XXX

NUMBER

19

STUDENT_NUM_IN_COLLEGE

XXX

NUMBER

STUDENT_NUM_IN_FAMILY

XXX

NUMBER

STUDENT_PROFILE_REG_RECD_DT

XXX

DATE

STUDENT_REG_TYPE

XXX

VARCHAR2

1

STUDENT_SUMMER_WAGES

XXX

NUMBER

19

STUDENT_TAX_FILING_STATUS

Student's Tax Filing Status

VARCHAR2

2

STUDENT_TOKEN

XXX

NUMBER

STUDENT_YEAR_IN_SCHOOL

XXX

NUMBER

STU_AWARD_YEAR_TOKEN

XXX

NUMBER

S_LEGAL_RES

XXX

VARCHAR2

2

S_LEGAL_RES_D

XXX

DATE

S_LEG_RES_BEF

XXX

VARCHAR2

1

TOTAL_PAR_CONTRIB

XXX

NUMBER

WAREHOUSE_INSERT_TIMESTAMP

XXX

DATE

WAREHOUSE_UPDATE_TIMESTAMP

XXX

DATE