Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse FPR SUPERVISED ACTIVITY UROP Table


View exposing supervised UROP activity records associated with Faculty Professional Record reporting and review.


Field Name

Description

Data Type

Length

END_DATE

Date associated with end.

DATE

MIT_ID

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

VARCHAR2

9

START_DATE

Date associated with start.

DATE

STUDENT_FULL_NAME

Student full name associated with the record.

VARCHAR2

93

STUDENT_MIT_ID

Business identifier for the student mit.

VARCHAR2

9

SUPERVISED_ACTIVITY_ID

Business identifier for the supervised activity.

NUMBER

UROP_PROJECT_TITLE

Urop project title associated with the record.

VARCHAR2

400

WAREHOUSE_LOAD_DATE

Date the record was loaded into the data warehouse.

DATE