Data Warehouse

ADMIT_STATUS

XXX

VARCHAR2

1

APP_COMPLETE_DT

XXX

DATE

AWARD_YEAR_TOKEN

XXX

NUMBER

BUDGET_DURATION

XXX

NUMBER

4,1

CC_TFC

XXX

NUMBER

19

CITIZEN_CODE

XXX

VARCHAR2

1

CURRENT_IDOC

XXX

NUMBER

CUST_TTL_INC

XXX

NUMBER

DATA_VALID

XXX

VARCHAR2

1

DEPENDENCY

XXX

VARCHAR2

1

DT_WITH

XXX

DATE

EFM_TFC

XXX

NUMBER

19

ENR_STAT_FALL

XXX

VARCHAR2

6

ENR_STAT_SPR

XXX

VARCHAR2

6

ENR_STAT_SUM

XXX

VARCHAR2

6

ETHNICITY

Ethnicity

VARCHAR2

6

FAID_APPLICANT_KEY

XXX

VARCHAR2

21

FALL_GRADELVL

XXX

VARCHAR2

6

FED_AID_ONLY

XXX

VARCHAR2

6

FIN_AID_APPL

XXX

VARCHAR2

6

FIRST_BACHELOR_BY_7_1_96

XXX

VARCHAR2

1

FIRST_NAME

The person's first name.

VARCHAR2

15

HOME_PURCH_PRICE

XXX

NUMBER

19

HOUSING_STATUS

XXX

VARCHAR2

1

INAR_FORMULA

XXX

VARCHAR2

1

IPEDS

XXX

NUMBER

I_P_CNTRY_RES

XXX

VARCHAR2

2

I_S_GENDER

XXX

VARCHAR2

1

I_VABENEFITS

XXX

NUMBER

19

LAST_NAME

The person's last name.

VARCHAR2

30

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

MIDDLE_INIT

XXX

VARCHAR2

1

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

NC_INCOME

XXX

NUMBER

NC_WAIVE_STRING

XXX

NUMBER

NUM_IN_COLLEGE

XXX

NUMBER

ORIGINAL_NEED

XXX

NUMBER

27,6

OTHER_TAXABLE

XXX

NUMBER

19

PARENT_1_AGE

XXX

NUMBER

PARENT_2_AGE

XXX

NUMBER

PARENT_AGI

Adjusted Gross Income of parent(s)

NUMBER

19

PARENT_ASSET_CONTRIB

XXX

NUMBER

19

PARENT_CONTRIB

Parent Contribution

NUMBER

19

PARENT_EMAIL

XXX

VARCHAR2

50

PARENT_HOME_DEBT

XXX

NUMBER

19

PARENT_HOME_EQUITY

XXX

NUMBER

19

PARENT_HOME_VALUE

XXX

NUMBER

19

PARENT_INCOME_CONTRIB

XXX

NUMBER

19

PARENT_NET_WORTH

XXX

NUMBER

19

PARENT_NUM_IN_COLLEGE

XXX

NUMBER

PARENT_NUM_IN_FAMILY

XXX

NUMBER

PARENT_TOTAL_INCOME

Parent Total Income=parent adjusted gross income + parent untaxed income - parent income exclusions + mit add back (parent PJ adjustment)

NUMBER

19

PAR_1_LAST_NAME

XXX

VARCHAR2

16

PAR_2_LAST_NAME

XXX

VARCHAR2

16

PAR_CONTRIB

XXX

NUMBER

19

PRIMARY_COUNTRY

XXX

VARCHAR2

25

PRIMARY_STATE

XXX

VARCHAR2

2

P_LEGAL_RES

XXX

VARCHAR2

2

P_LEGAL_RES_D

XXX

DATE

P_LEG_RES_BEF

XXX

VARCHAR2

1

P_NUMCOLLEGE

XXX

NUMBER

P_NUMFAMILY

XXX

NUMBER

RACE

The person's race.

VARCHAR2

1

READER_DATE

XXX

DATE

ROTC_AWARD_AMOUNT

XXX

NUMBER

SAP_FALL

XXX

VARCHAR2

6

SAP_SPRING

XXX

VARCHAR2

6

SAP_SUMMER

XXX

VARCHAR2

6

SAR_C_FLAG

XXX

VARCHAR2

1

SAT_PROG

XXX

NUMBER

SH_75K_OR_LESS

XXX

NUMBER

SNAPSHOT_EVENT

XXX

VARCHAR2

30

SNAPSHOT_KEY

XXX

BLOB

SPR_GRADELVL

XXX

VARCHAR2

6

STUDENT_CONTRIB

Student Contribution

NUMBER

19

STUDENT_MARITAL_STATUS

Marital status of student/aid_applicant

VARCHAR2

1

STUDENT_NET_WORTH

XXX

NUMBER

19

STUDENT_NUM_IN_FAMILY

XXX

NUMBER

STUDENT_SSN

XXX

VARCHAR2

9

STUDENT_TOTAL_INCOME

Student Total Income=student adjusted gross income+student untaxed income - student income exclusions + student PJ adjustment

NUMBER

19

STU_GROSSINC

XXX

NUMBER

SUM_GRADE_LVL

XXX

VARCHAR2

6

S_BKS_SUPP

XXX

NUMBER

S_IGRANTA

XXX

NUMBER

S_IGRANTD

XXX

NUMBER

S_LEGAL_RES

XXX

VARCHAR2

2

S_LEGAL_RES_D

XXX

DATE

S_LEG_RES_BEF

XXX

VARCHAR2

1

S_OTHERBDGT

XXX

NUMBER

S_ROOM_BD

XXX

NUMBER

S_TOTPARCNTR

XXX

NUMBER

S_TRANSPORT

XXX

NUMBER

S_TUITFEES

XXX

NUMBER

TOTAL_BUDGET

XXX

NUMBER

TOTAL_PARENT_INCOME

XXX

NUMBER

19

TRACKING_STATUS

XXX

VARCHAR2

2

TRANSFER_FLAG

XXX

VARCHAR2

1

UNITS_FALL

XXX

NUMBER

UNITS_FALL_F

XXX

NUMBER

UNITS_SPRING

XXX

NUMBER

UNITS_SPRING_F

XXX

NUMBER

WAREHOUSE_INSERT_TIMESTAMP

XXX

DATE

WAREHOUSE_UPDATE_TIMESTAMP

XXX

DATE

YELLOW_RIBBON

XXX

VARCHAR2

6