UROP PROJECT DETAIL Table
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.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
CREATE_DATE |
Date when UROP applicatioan initiated. |
DATE |
8 |
CREDIT_SUBJECT |
Subject number (examples: 6.UR, 18.URG, SP.4UR) of an credit UROP project. |
VARCHAR2 |
8 |
CREDIT_UNITS |
Units of credit for Credit UROP project. |
NUMBER |
2 |
FAC_COUNT_BY_TERM |
Used to uniquely count the number of instructors by UROP term. Always contains a value of 0 or 1. |
NUMBER |
1 |
FAC_COUNT_BY_TERM_DEPT |
Used to uniquely count the number of instructors by UROP term and by UROP Department. Always contains a value of 0 or 1. |
NUMBER |
1 |
FAC_COUNT_BY_TERM_FUND |
Used to uniquely count the number of instructors by UROP term and by funding type. Contains a value of 1 or 0. |
NUMBER |
1 |
LAST_ACTIVITY_DATE |
Date when information in the record was last updated. |
DATE |
8 |
LAST_UPDATED_USER_ID |
Kerberos ID of user last updating an UROP project. |
VARCHAR2 |
8 |
LOCATION_OF_UROP |
MIT building/lab where UROP takes place. |
VARCHAR2 |
120 |
PROJECT_COUNT |
A counter for number of UROP projects. Always contains a value of 1 or 0. |
NUMBER |
1 |
PROJECT_ID |
Project ID, may or may not be the same as the Project WBS ID (will be different if there is a hierarchy). |
VARCHAR2 |
7 |
PROJECT_TITLE |
UROP project title. |
VARCHAR2 |
240 |
SPON_RES_ACCOUNT1 |
For Sponsored Research UROP projects, the primary account number. |
VARCHAR2 |
7 |
SPON_RES_ACCOUNT2 |
For Sponsored Research UROP projects, the secondary account number. |
VARCHAR2 |
7 |
SPON_RES_AMOUNT |
For Sponsored Research UROP projects, total compensation. |
NUMBER |
7.2 |
SPON_RES_HOURLY_RATE |
For Sponsored Research UROP projects, hourly rate |
NUMBER |
5.2 |
SPON_RES_PCT1 |
For Sponsored Research UROP projects, percent allocated to primary account. |
NUMBER |
3 |
SPON_RES_PCT2 |
For Sponsored Research UROP projects, percent allocated to secondary account. |
NUMBER |
3 |
STATUS_DATE |
In Urop Project Detail: this is the date when current project status achieved. |
DATE |
8 |
STU_COUNT_BY_TERM |
Used to uniquely count the number of students by UROP term. Always contains a value of 0 or 1. |
NUMBER |
1 |
STU_COUNT_BY_TERM_DEPT |
Used to uniquely count the number of students by UROP term and by UROP Department. Always contains a value of 0 or 1. |
NUMBER |
1 |
STU_COUNT_BY_TERM_FUND |
Used to uniquely count the number of students by UROP term and by funding type. Always contains a value of 0 or 1. |
NUMBER |
1 |
UROP_ACCOUNT |
Account number for an UROP direct funded project. Each department has one account per academic year. |
VARCHAR2 |
7 |
UROP_AMOUNT |
For UROP direct funded projects, total compensation. |
NUMBER |
7.2 |
UROP_CONTINUING_BY_YEAR_KEY |
XXX |
VARCHAR2 |
25 |
UROP_DEPARTMENT_KEY |
Use this field to join together UROP PROJECT DETAIL and UROP DEPARTMENT tables. |
VARCHAR2 |
9 |
UROP_FUNDING_TYPE_KEY |
Use this field to join together UROP PROJECT DETAIL and UROP FUNDING TYPE tables. |
VARCHAR2 |
70 |
UROP_INSTRUCTOR_KEY |
Use this field to join together UROP PROJECT DETAIL and UROP INSTRUCTOR tables. |
VARCHAR2 |
9 |
UROP_MAT_AMOUNT |
For UROP direct funded projects, total amount granted for materials and services. |
NUMBER |
7.2 |
UROP_STATUS_KEY |
Use this field to join together UROP PROJECT DETAIL and UROP STATUS tables. |
VARCHAR2 |
40 |
UROP_STUDENT_KEY |
Use this field to join together UROP PROJECT DETAIL and UROP STUDENT tables. |
VARCHAR2 |
15 |
UROP_TERM_KEY |
Use this field to join together UROP PROJECT DETAIL and UROP TERM tables. |
VARCHAR2 |
6 |
WAREHOUSE_LOAD_DATE |
The date the record was loaded into the Data Warehouse from the source system. |
DATE |
8 |