Data Warehouse

AID_PERIOD

The period of which the student is eligible for financial aid. Values are: Full Academic Year, Fall Term Only, Spring Term Only, Summer Term Only, Summer/Fall (7.5 Month), and Twelve-Month.

VARCHAR2

6

AID_PERIOD_DESC

XXX

VARCHAR2

30

AID_YEAR

Financial aid year.

VARCHAR2

4

ESTIMATED_FM_NEED

XXX

NUMBER

9,2

FALL_ENROLL_STATUS_CODE

XXX

VARCHAR2

2

FALL_ENROLL_STATUS_DESC

XXX

VARCHAR2

50

FALL_LOAD_LEVEL_CODE

XXX

VARCHAR2

2

FALL_LOAD_LEVEL_DESC

XXX

VARCHAR2

50

FALL_STUDENT_YEAR

XXX

VARCHAR2

1

FALL_UNITS_OF_LOAD

XXX

NUMBER

3

FA_APPLICANT_KEY

XXX

VARCHAR2

13

FA_CLASS_CODE

XXX

VARCHAR2

1

FA_CLASS_CODE_DESC

XXX

VARCHAR2

30

FM_NEED

XXX

NUMBER

9,2

FM_PARENT_CONTRIBUTION

XXX

NUMBER

9,2

FM_STUDENT_CONTRIBUTION

XXX

NUMBER

9,2

FM_UNMET_NEED

XXX

NUMBER

9,2

IM_NEED

XXX

NUMBER

9,2

IM_PARENT_CONTRIBUTION

XXX

NUMBER

9,2

IM_STUDENT_CONTRIBUTION

XXX

NUMBER

9,2

MIT_ID

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

VARCHAR2

9

SPRING_ENROLL_STATUS_CODE

XXX

VARCHAR2

2

SPRING_ENROLL_STATUS_DESC

XXX

VARCHAR2

50

SPRING_LOAD_LEVEL_CODE

XXX

VARCHAR2

2

SPRING_LOAD_LEVEL_DESC

XXX

VARCHAR2

50

SPRING_STUDENT_YEAR

XXX

VARCHAR2

1

SPRING_UNITS_OF_LOAD

XXX

NUMBER

3

SUMMER_ENROLL_STATUS_CODE

XXX

VARCHAR2

2

SUMMER_ENROLL_STATUS_DESC

XXX

VARCHAR2

50

SUMMER_LOAD_LEVEL_CODE

XXX

VARCHAR2

2

SUMMER_LOAD_LEVEL_DESC

XXX

VARCHAR2

50

SUMMER_STUDENT_YEAR

XXX

VARCHAR2

1

SUMMER_UNITS_OF_LOAD

XXX

NUMBER

3

WAREHOUSE_LOAD_DATE

The date the record was loaded into the Data Warehouse from the source system.

DATE