Data Warehouse

LOAD_SEQUENCE

XXX

VARCHAR2

20

MIT_ID

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

VARCHAR2

9

PROGRAM_1_BEGIN_DATE

XXX

VARCHAR2

8

PROGRAM_1_CIP_CODE

XXX

VARCHAR2

6

PROGRAM_1_CIP_YEAR

XXX

VARCHAR2

4

PROGRAM_1_CREDENTIAL

XXX

VARCHAR2

2

PROGRAM_1_ENROLLMENT_STATUS

XXX

VARCHAR2

8

PROGRAM_1_LENGTH

XXX

VARCHAR2

6

PROGRAM_1_LENGTH_MEASUREMENT

XXX

VARCHAR2

1

PROGRAM_1_SPECIAL_INDICATOR

XXX

VARCHAR2

1

PROGRAM_1_STATUS_DATE

XXX

VARCHAR2

8

PROGRAM_1_TITLE_IV_YEAR

XXX

VARCHAR2

6

PROGRAM_2_BEGIN_DATE

XXX

VARCHAR2

8

PROGRAM_2_CIP_CODE

XXX

VARCHAR2

6

PROGRAM_2_CIP_YEAR

XXX

VARCHAR2

4

PROGRAM_2_CREDENTIAL

XXX

VARCHAR2

2

PROGRAM_2_ENROLLMENT_STATUS

XXX

VARCHAR2

8

PROGRAM_2_LENGTH

XXX

VARCHAR2

6

PROGRAM_2_LENGTH_MEASUREMENT

XXX

VARCHAR2

1

PROGRAM_2_SPECIAL_INDICATOR

XXX

VARCHAR2

1

PROGRAM_2_STATUS_DATE

XXX

VARCHAR2

8

PROGRAM_2_TITLE_IV_YEAR

XXX

VARCHAR2

6

PROGRAM_3_BEGIN_DATE

XXX

VARCHAR2

8

PROGRAM_3_CIP_CODE

XXX

VARCHAR2

6

PROGRAM_3_CIP_YEAR

XXX

VARCHAR2

4

PROGRAM_3_CREDENTIAL

XXX

VARCHAR2

2

PROGRAM_3_ENROLLMENT_STATUS

XXX

VARCHAR2

8

PROGRAM_3_LENGTH

XXX

VARCHAR2

6

PROGRAM_3_LENGTH_MEASUREMENT

XXX

VARCHAR2

1

PROGRAM_3_SPECIAL_INDICATOR

XXX

VARCHAR2

1

PROGRAM_3_STATUS_DATE

XXX

VARCHAR2

8

PROGRAM_3_TITLE_IV_YEAR

XXX

VARCHAR2

6

PROGRAM_4_BEGIN_DATE

XXX

VARCHAR2

8

PROGRAM_4_CIP_CODE

XXX

VARCHAR2

6

PROGRAM_4_CIP_YEAR

XXX

VARCHAR2

4

PROGRAM_4_CREDENTIAL

XXX

VARCHAR2

2

PROGRAM_4_ENROLLMENT_STATUS

XXX

VARCHAR2

8

PROGRAM_4_LENGTH

XXX

VARCHAR2

6

PROGRAM_4_LENGTH_MEASUREMENT

XXX

VARCHAR2

1

PROGRAM_4_SPECIAL_INDICATOR

XXX

VARCHAR2

1

PROGRAM_4_STATUS_DATE

XXX

VARCHAR2

8

PROGRAM_4_TITLE_IV_YEAR

XXX

VARCHAR2

6

PROGRAM_5_BEGIN_DATE

XXX

VARCHAR2

8

PROGRAM_5_CIP_CODE

XXX

VARCHAR2

6

PROGRAM_5_CIP_YEAR

XXX

VARCHAR2

4

PROGRAM_5_CREDENTIAL

XXX

VARCHAR2

2

PROGRAM_5_ENROLLMENT_STATUS

XXX

VARCHAR2

8

PROGRAM_5_LENGTH

XXX

VARCHAR2

6

PROGRAM_5_LENGTH_MEASUREMENT

XXX

VARCHAR2

1

PROGRAM_5_SPECIAL_INDICATOR

XXX

VARCHAR2

1

PROGRAM_5_STATUS_DATE

XXX

VARCHAR2

8

PROGRAM_5_TITLE_IV_YEAR

XXX

VARCHAR2

6

PROGRAM_6_BEGIN_DATE

XXX

VARCHAR2

8

PROGRAM_6_CIP_CODE

XXX

VARCHAR2

6

PROGRAM_6_CIP_YEAR

XXX

VARCHAR2

4

PROGRAM_6_CREDENTIAL

XXX

VARCHAR2

2

PROGRAM_6_ENROLLMENT_STATUS

XXX

VARCHAR2

8

PROGRAM_6_LENGTH

XXX

VARCHAR2

6

PROGRAM_6_LENGTH_MEASUREMENT

XXX

VARCHAR2

1

PROGRAM_6_SPECIAL_INDICATOR

XXX

VARCHAR2

1

PROGRAM_6_STATUS_DATE

XXX

VARCHAR2

8

PROGRAM_6_TITLE_IV_YEAR

XXX

VARCHAR2

6

TERM_CODE

** For FINANCIAL DATA: the Term Code identifies the status of the cost collector. Blank - open for charges between start and end dates. Term Code = 1 - Closed. Pre-end date charges allowed. Term Code = 2 - No longer in use. Term Code = 3 - Terminated. Charges not allowed. ** For STUDENT DATA: the Term Code identifies one of the terms in an academic year; for example: 1999FA==>Fall Term of the 1998-99 academic year, and 1999SP==>Spring Term of the 1998-99 academic year.

VARCHAR2

6

WAREHOUSE_LOAD_DATE

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

DATE