Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse EECS DEGREE AWARDED Table


View exposing EECS student degree-awarded detail including up to five awarded MIT degrees, associated departments, options, award terms, award dates, and confidentiality indicator.


Field Name

Description

Data Type

Length

IS_DEGREE_CONFIDENTIAL

Indicator identifying whether degree confidential (Y/N).

VARCHAR2

1

MIT_DEGREE_AWARDED_DATE_1

Mit degree awarded date 1 associated with the record.

DATE

MIT_DEGREE_AWARDED_DATE_2

Mit degree awarded date 2 associated with the record.

DATE

MIT_DEGREE_AWARDED_DATE_3

Mit degree awarded date 3 associated with the record.

DATE

MIT_DEGREE_AWARDED_DATE_4

Mit degree awarded date 4 associated with the record.

DATE

MIT_DEGREE_AWARDED_DATE_5

Mit degree awarded date 5 associated with the record.

DATE

MIT_DEGREE_AWARDED_DEPT_1

Mit degree awarded dept 1 associated with the record.

VARCHAR2

4

MIT_DEGREE_AWARDED_DEPT_2

Mit degree awarded dept 2 associated with the record.

VARCHAR2

4

MIT_DEGREE_AWARDED_DEPT_3

Mit degree awarded dept 3 associated with the record.

VARCHAR2

4

MIT_DEGREE_AWARDED_DEPT_4

Mit degree awarded dept 4 associated with the record.

VARCHAR2

4

MIT_DEGREE_AWARDED_DEPT_5

Mit degree awarded dept 5 associated with the record.

VARCHAR2

4

MIT_DEGREE_AWARDED_OPTION_1

Mit degree awarded option 1 associated with the record.

VARCHAR2

4

MIT_DEGREE_AWARDED_OPTION_2

Mit degree awarded option 2 associated with the record.

VARCHAR2

4

MIT_DEGREE_AWARDED_OPTION_3

Mit degree awarded option 3 associated with the record.

VARCHAR2

4

MIT_DEGREE_AWARDED_OPTION_4

Mit degree awarded option 4 associated with the record.

VARCHAR2

4

MIT_DEGREE_AWARDED_OPTION_5

Mit degree awarded option 5 associated with the record.

VARCHAR2

4

MIT_DEGREE_AWARDED_TERM_1

Mit degree awarded term 1 associated with the record.

VARCHAR2

6

MIT_DEGREE_AWARDED_TERM_2

Mit degree awarded term 2 associated with the record.

VARCHAR2

6

MIT_DEGREE_AWARDED_TERM_3

Mit degree awarded term 3 associated with the record.

VARCHAR2

6

MIT_DEGREE_AWARDED_TERM_4

Mit degree awarded term 4 associated with the record.

VARCHAR2

6

MIT_DEGREE_AWARDED_TERM_5

Mit degree awarded term 5 associated with the record.

VARCHAR2

6

MIT_DEGREE_AWARDED_TYPE_1

Mit degree awarded type 1 associated with the record.

VARCHAR2

3

MIT_DEGREE_AWARDED_TYPE_2

Mit degree awarded type 2 associated with the record.

VARCHAR2

3

MIT_DEGREE_AWARDED_TYPE_3

Mit degree awarded type 3 associated with the record.

VARCHAR2

3

MIT_DEGREE_AWARDED_TYPE_4

Mit degree awarded type 4 associated with the record.

VARCHAR2

3

MIT_DEGREE_AWARDED_TYPE_5

Mit degree awarded type 5 associated with the record.

VARCHAR2

3

MIT_ID

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

VARCHAR2

9

WAREHOUSE_LOAD_DATE

Date the record was loaded into the data warehouse.

DATE