UROP STUDENT Table
View exposing UROP student records including student participation attributes in undergraduate research programs.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
ALTERNATE_STUDENT_ID |
Business identifier for the alternate student. |
VARCHAR2 |
9 |
COURSE |
Course associated with the record. |
VARCHAR2 |
12 |
COURSE_2 |
Course 2 associated with the record. |
VARCHAR2 |
12 |
COURSE_3 |
Course 3 associated with the record. |
VARCHAR2 |
12 |
COURSE_DESCRIPTION |
Description of course. |
VARCHAR2 |
30 |
COURSE_DESCRIPTION_2 |
Course description 2 associated with the record. |
VARCHAR2 |
30 |
COURSE_DESCRIPTION_3 |
Course description 3 associated with the record. |
VARCHAR2 |
30 |
ENROLLMENT_KEY |
Surrogate key identifying the enrollment. |
VARCHAR2 |
15 |
FULL_NAME |
Full name associated with the person or organization. |
VARCHAR2 |
100 |
GENDER |
Gender associated with the record. |
VARCHAR2 |
100 |
HOME_DEPARTMENT |
Home department associated with the record. |
VARCHAR2 |
6 |
IS_ATTENDED |
Indicator identifying whether attended (Y/N). |
VARCHAR2 |
1 |
IS_DOUBLE_MAJOR |
Indicator identifying whether double major (Y/N). |
VARCHAR2 |
1 |
IS_ELIGIBLE_TO_REG |
Indicator identifying whether eligible to reg (Y/N). |
VARCHAR2 |
1 |
IS_REGISTERED |
Indicator identifying whether registered (Y/N). |
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 |
SCHOOL_NAME |
School name associated with the record. |
VARCHAR2 |
22 |
STUDENT_YEAR |
Student year associated with the record. |
VARCHAR2 |
1 |
TERM_CODE |
Code identifying term. |
VARCHAR2 |
6 |
UROP_STUDENT_KEY |
Surrogate key identifying the urop student. |
VARCHAR2 |
15 |
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |