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 |
|---|---|---|---|---|---|---|
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 |
26-APR-2024 |
|
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 |
26-APR-2024 |
|
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 |
26-APR-2024 |
|
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 |
26-APR-2024 |
|
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 |
26-APR-2024 |
|
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 |
26-APR-2024 |
|
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 |
26-APR-2024 |