Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse STUDENT DEGREE THESIS Table


View exposing student degree thesis data.


Field Name

Description

Data Type

Length

ACTUAL_OR_PROPOSED

Actual or proposed associated with the record.

VARCHAR2

8

COMMENCEMENT_BK_THESIS_INFIELD

Commencement bk thesis infield associated with the record.

VARCHAR2

250

COURSE

Course associated with the record.

VARCHAR2

9

COURSE_LEVEL

Course level associated with the record.

VARCHAR2

2

DEGREE_APPLY_DATE

Date associated with degree apply.

DATE

DEGREE_AWARD_DATE

Date associated with degree award.

DATE

DEGREE_AWARD_TERM

Degree award term associated with the record.

VARCHAR2

6

DEGREE_CODE

Code identifying degree.

VARCHAR2

8

DEGREE_DESC

Description of degree.

VARCHAR2

240

DEGREE_STATUS

Degree status associated with the record.

VARCHAR2

2

DEGREE_STATUS_DATE

Date associated with degree status.

DATE

DEGREE_STATUS_DESC

Description of degree status.

VARCHAR2

100

DEGREE_TYPE

Degree type associated with the record.

VARCHAR2

3

DEGREE_TYPE_DESC

Description of degree type.

VARCHAR2

100

DEPARTMENT

Department associated with the record.

VARCHAR2

4

FULL_NAME

Full name associated with the person or organization.

VARCHAR2

80

FUNKY_THESIS_IND

Funky thesis ind associated with the record.

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

9

OTHER_THESIS_FIELD

Other thesis field associated with the record.

VARCHAR2

100

THESIS_COAUTHOR

Thesis coauthor associated with the record.

VARCHAR2

60

THESIS_FIELD_ID

Business identifier for the thesis field.

NUMBER

THESIS_LAST_ACTIVITY_DATE

Date associated with thesis last activity.

DATE

THESIS_TITLE

Thesis title associated with the record.

VARCHAR2

500

WAREHOUSE_LOAD_DATE

Date the record was loaded into the data warehouse.

DATE