Data Warehouse

ACADEMIC_YEAR_BEGIN_DATE

XXX

DATE

ACADEMIC_YEAR_END_DATE

XXX

DATE

ADDRESS_END_DT

XXX

DATE

ADDRESS_START_DT

XXX

DATE

ADMSTAT

XXX

VARCHAR2

1

ALIEN_NUM

XXX

VARCHAR2

9

ALT_LOAN_DEBT

XXX

NUMBER

12,2

APP_COMPLETE_DT

XXX

DATE

CELLULAR_TELEPHONE

XXX

VARCHAR2

10

COLLEGE_GPA

XXX

NUMBER

3,2

COMPLETE_LETTER_SENT

XXX

VARCHAR2

1

CREATED_DT

XXX

DATE

CREATED_HOW

XXX

NUMBER

CURRENT_IDOC

XXX

NUMBER

DATE_AWARD_LETTER_PRINTED

XXX

DATE

DATE_OFFER_ACCEPTED

XXX

DATE

DRIVERS_LICENSE_NUM

XXX

VARCHAR2

20

DRIVERS_LICENSE_STATE

XXX

VARCHAR2

2

DT_LAST_APPLICATION_UPDATE

XXX

DATE

DT_WITH

XXX

DATE

EARLY_ADMIT

XXX

VARCHAR2

6

EMAIL_ADDRESS

A person's complete electronic mail address including user name and node name, for example, username@school.edu.

VARCHAR2

50

EMAIL_ADDRESS_2

XXX

VARCHAR2

50

ENROLLMENT_DATE

XXX

DATE

ENR_STAT_FALL

XXX

VARCHAR2

6

ENR_STAT_SPR

XXX

VARCHAR2

6

ENR_STAT_SUM

XXX

VARCHAR2

6

ENTRANCE_IV_BY

XXX

NUMBER

ENTRANCE_IV_BY_GRAD_PLUS

XXX

NUMBER

ENTRANCE_IV_DT

XXX

DATE

ENTRANCE_IV_DT_GRAD_PLUS

XXX

DATE

ETHNICITY

Ethnicity

VARCHAR2

6

EXIT_IV_BY

XXX

NUMBER

EXIT_IV_DT

XXX

DATE

EXPECTED_GRADUATION_DATE

XXX

DATE

FAID_APPLICANT_KEY

XXX

VARCHAR2

21

FAID_APPLICANT_UNIQUE_KEY

XXX

VARCHAR2

32

FAID_YEAR

XXX

NUMBER

FAID_YEAR_DESC

XXX

VARCHAR2

23

FAILED_CHALLENGE_RESPONSE

XXX

NUMBER

FAILED_LOGINS

XXX

NUMBER

FALL_GRADELVL

XXX

VARCHAR2

6

FED_AID_ONLY

XXX

VARCHAR2

6

FIN_AID_APPL

XXX

VARCHAR2

6

FIRST_NAME

The person's first name.

VARCHAR2

15

FM_NEED_BASED_AMOUNT

XXX

NUMBER

FOREIGN_ADDRESS_INDICATOR

XXX

VARCHAR2

1

FOREIGN_COUNTRY_CODE

XXX

VARCHAR2

3

FOREIGN_POSTAL_CODE

XXX

VARCHAR2

17

GPA_HIGHSCHOOL

XXX

NUMBER

3,2

GRADPLUS_MPN_EXPIRATION_DATE

XXX

DATE

GRADUATE_STIPEND_AWARD_FALL

XXX

NUMBER

GRADUATE_STIPEND_AWARD_SPRING

XXX

NUMBER

GRADUATE_STIPEND_AWARD_SUMMER

XXX

NUMBER

GRADUATE_TEACHING_ASSISTANT

XXX

VARCHAR2

6

GRADUATE_TUITION_AWARD_FALL

XXX

NUMBER

GRADUATE_TUITION_AWARD_SPRING

XXX

NUMBER

GRADUATE_TUITION_AWARD_SUMMER

XXX

NUMBER

GRADUATE_YEAR

XXX

VARCHAR2

1

GRAD_SCHOOL_ENROLLED

XXX

VARCHAR2

6

HAS_PERKINS

XXX

NUMBER

HEAL_LIMIT_FLAG

XXX

VARCHAR2

1

HISPANIC

XXX

VARCHAR2

1

IM_NEED_BASED_AMOUNT

XXX

NUMBER

IPEDS

XXX

NUMBER

IPEDS_DESCRIPTION

XXX

VARCHAR2

50

ISIR_DATA_VALID

XXX

VARCHAR2

1

I_P_CTRY_RES

XXX

VARCHAR2

2

I_S_GENDER

XXX

VARCHAR2

1

LAST_NAME

The person's last name.

VARCHAR2

25

LIFETIME_CREDITS

XXX

NUMBER

6,2

MIDDLE_INIT

XXX

VARCHAR2

1

MITSIS_GRAD_PROGRAM_ON_RECORD

XXX

VARCHAR2

6

MIT_ID

MIT ID number of the person. Use this field to join with other tables containing data about people at MIT.

VARCHAR2

10

MODIFIED_BY

XXX

NUMBER

MODIFIED_DT

XXX

DATE

MPN_EXPIRATION_DATE

XXX

DATE

NAME_MID

XXX

VARCHAR2

12

NAME_PREF

XXX

VARCHAR2

12

NC_INCOME

XXX

NUMBER

NC_WAIVE_STRING

XXX

NUMBER

NETPARTNER_LOCKED

XXX

VARCHAR2

1

NETPARTNER_LOCKED_BY

XXX

VARCHAR2

25

NETPARTNER_LOCKED_DATE

XXX

DATE

NETPARTNER_LOCKED_TIME

XXX

DATE

NUMBER_AWARD_LETTERS

XXX

NUMBER

OLD_SSN

XXX

VARCHAR2

9

ORIG_EPS

XXX

VARCHAR2

5

PARENT_MARITAL_STATUS

Marital status of student/aid_applicant's parent

VARCHAR2

6

PIN

XXX

VARCHAR2

57

PRIMARY_CITY

XXX

VARCHAR2

20

PRIMARY_COUNTRY

XXX

VARCHAR2

25

PRIMARY_PHONE_NUMBER

XXX

VARCHAR2

20

PRIMARY_PHONE_NUMBER_INTL

XXX

VARCHAR2

20

PRIMARY_STATE

XXX

VARCHAR2

2

PRIMARY_STREET1

XXX

VARCHAR2

40

PRIMARY_STREET2

XXX

VARCHAR2

40

PRIMARY_STREET3

XXX

VARCHAR2

40

PRIMARY_ZIPCODE

XXX

VARCHAR2

9

PRIOR_NAME

The person's prior name, for example, maiden name.

VARCHAR2

25

PROFILE_DATA_VA

XXX

VARCHAR2

1

QA_REVIEW_DATE

XXX

DATE

RACE

The person's race.

VARCHAR2

1

RACE_DESCRIPTION

XXX

VARCHAR2

50

READER_DATE

XXX

DATE

REQUIRE_PIN_RESET

XXX

VARCHAR2

1

ROTC_AWARD_AMOUNT

XXX

NUMBER

SAP_FALL

XXX

VARCHAR2

6

SAP_SPRING

XXX

VARCHAR2

6

SAP_SUMMER

XXX

VARCHAR2

6

SAT_PROG

XXX

NUMBER

SECURITY_VERSION

XXX

NUMBER

SH_75K_OR_LESS

XXX

NUMBER

SPR_GRADELVL

XXX

VARCHAR2

6

STUDENT_SSN

XXX

VARCHAR2

9

STUDENT_TOKEN

XXX

NUMBER

SUM_GRADE_LVL

XXX

VARCHAR2

6

S_BKS_SUPP

XXX

NUMBER

S_FM_FINSTAT

XXX

VARCHAR2

1

S_FNAR_FINSTAT

XXX

VARCHAR2

1

S_IGRANTA

XXX

NUMBER

S_IGRANTD

XXX

NUMBER

S_OTHERBDGT

XXX

NUMBER

S_ROOM_BD

XXX

NUMBER

S_TOTALBUDGET

XXX

NUMBER

S_TRANSPORT

XXX

NUMBER

S_TUITFEES

XXX

NUMBER

TOTAL_AID

XXX

NUMBER

TOTAL_AWARD_MARKED_NEED_BASED

XXX

NUMBER

TOTAL_DEPT_GRADUATE_AWARD

XXX

NUMBER

TOTAL_EXTERNAL_AID

XXX

NUMBER

TOTAL_EXTERNAL_DISBURSE

XXX

NUMBER

TOTAL_FEDERAL_FUND_AWARD

XXX

NUMBER

TOTAL_FEDERAL_FUND_DISBURSE

XXX

NUMBER

TOTAL_FFELP_AWARD

XXX

NUMBER

TOTAL_GRANT_AWARD

XXX

NUMBER

TOTAL_GRANT_DISBURSE

XXX

NUMBER

TOTAL_INSTITUTE_FUND_AWARD

XXX

NUMBER

TOTAL_INSTITUTE_FUND_DISBURSE

XXX

NUMBER

TOTAL_JOBS_FUND_AWARD

XXX

NUMBER

TOTAL_JOBS_FUND_DISBURSE

XXX

NUMBER

TOTAL_LOANS_AWARD

XXX

NUMBER

TOTAL_LOANS_DISBURSE

XXX

NUMBER

TOTAL_OTHER_AID

XXX

NUMBER

TOTAL_PACKAGE_AWARD

XXX

NUMBER

TOTAL_PARENT_INCOME

XXX

NUMBER

TOTAL_PARENT_NET_WORTH

XXX

NUMBER

TOTAL_PFELP_DISBURSE

XXX

NUMBER

TOTAL_PRIVATE_FUND_AWARD

XXX

NUMBER

TOTAL_PRIVATE_FUND_DISBURSE

XXX

NUMBER

TOTAL_PRIVATE_GRANT_AWARD

XXX

NUMBER

TOTAL_PRIVATE_GRANT_DISBURSE

XXX

NUMBER

TOTAL_STATE_FUND_AWARD

XXX

NUMBER

TOTAL_STATE_FUND_DISBURSE

XXX

NUMBER

TOTAL_STUDY_ABROAD

XXX

NUMBER

TOT_PRIV_OUTSIDE_SCHOLARSHIP

XXX

NUMBER

TRACKING_STATUS

XXX

VARCHAR2

2

TRANSFER_FLAG

XXX

VARCHAR2

1

TUITION_CHARGE_FALL

XXX

NUMBER

TUITION_CHARGE_SPRING

XXX

NUMBER

TUITION_CHARGE_SUMMER

XXX

NUMBER

UNITS_FALL

XXX

NUMBER

UNITS_FALL_F

XXX

NUMBER

UNITS_SPRING

XXX

NUMBER

UNITS_SPRING_F

XXX

NUMBER

VETERAN_STATUS

XXX

VARCHAR2

6

WAREHOUSE_INSERT_TIMESTAMP

XXX

DATE

WAREHOUSE_UPDATE_TIMESTAMP

XXX

DATE

WEB_ID

XXX

VARCHAR2

9

WEB_LAST_LOGIN

XXX

DATE

WEB_ROLE

XXX

VARCHAR2

8

YELLOW_RIBBON

XXX

VARCHAR2

6