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	Student Services Information Technology (SSIT)	SENSITIVE	Daily	30-NOV-2009
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	Student Services Information Technology (SSIT)	SENSITIVE	Daily	30-NOV-2009
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	Student Services Information Technology (SSIT)	SENSITIVE	Daily	30-NOV-2009
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	Student Services Information Technology (SSIT)	SENSITIVE	Daily	30-NOV-2009
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	Student Services Information Technology (SSIT)	SENSITIVE	Daily	30-NOV-2009
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	Student Services Information Technology (SSIT)	SENSITIVE	Daily	30-NOV-2009
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	Student Services Information Technology (SSIT)	SENSITIVE	Daily	30-NOV-2009