Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse UROP Project


Tables are listed by alphabetical order. Clicking on a table name will display the fields/columns found in that table.


Table Name

Description

Type

Primary Provider

Sensitivity

Load Frequency

Last Load Date

UROP_PROJECT_DETAIL

The fact table which contains one record per UROP (Undergraduate Research Opportunities Program) project. Projects included are applications in UROP Office review, and projects at Approved, Cancelled, Returned/Rejected status. Expired, draft, faculty review, and department review applications/projects are not included.

Fact

MIT Student Information System

SENSITIVE

Daily

08-JAN-2020

UROP_FUNDING_TYPE

A dimension table used in the UROP Project Star. It contains all the possible values for Funding Type (Credit, Direct Funded, Sponsored Research, Volunteer), Special Fund, and Fund Change.

Dimension

MIT Student Information System

SENSITIVE

Daily

08-JAN-2020

UROP_STUDENT

This is a dimension table used in the UROP Project Star. It contains the MIT ID, full name, gender, and enrollment information (year, course of major, home department) of students who have participated in an UROP project. There is one record per student per UROP term. Enrollment information is term based. Enrollment information for special UROP terms, "FJ" and "JS", are retrieved from the academic terms "FA" and "SP" respectively.

Dimension

MIT Student Information System

SENSITIVE

Daily

08-JAN-2020

UROP_DEPARTMENT

A dimension table used in the UROP Project Star. It contains the codes and descriptions of the UROP project departments (the departments that coordinate the projects and the participants) and also the academic departments to which URN credit applied.

Dimension

MIT Student Information System

SENSITIVE

Daily

08-JAN-2020

UROP_TERM

A dimension table used in the UROP Project Star. It contains the UROP term codes and descriptions, as well as the academic year.

Dimension

MIT Student Information System

SENSITIVE

Daily

08-JAN-2020

UROP_INSTRUCTOR

This is a dimension table used in the UROP Project Star. It contains the MIT ID, full name, gender, title, and home department of all faculty supervisors, instructors, mentors, and intellectual guidances who have participated in an UROP Project. There is one record per person per UROP term in this table.

Dimension

MIT Student Information System

SENSITIVE

Daily

08-JAN-2020

UROP_STATUS

A dimension table used in the UROP Project Star. It contains the status of a UROP project, as well as other status fields and flags pertaining to the project (eg. Is Continuing, Is URN Credit Granted, etc.).

Dimension

MIT Student Information System

SENSITIVE

Daily

08-JAN-2020