UROP STATUS Table
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.).
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
IS_CONTINUING |
For UROP Project: Y (Continuing)/N (Not Continuing). Continuing means this student and faculty/instructor worked on the same project in the most recent term. |
VARCHAR2 |
1 |
IS_FACULTY_EVAL_RECV |
Has faculty evaluation been received for a completed UROP project? Values: N=not yet received, Y=received, W=waived, P=problem, Blank=not applicable, ?=other |
VARCHAR2 |
1 |
IS_STUDENT_EVAL_RECV |
Has student evaluation been received for a completed UROP project? Values: N=not yet received, Y=received, W=waived, P=problem, Blank=not applicable, ?=other |
VARCHAR2 |
1 |
IS_URN_CREDIT_GRANTED |
Has URN credit been granted for this UROP project? (Not applicable to for-credit UROP projects.) Values: Y=yes, N=no (URN credit denied), Blan=not applicable, ?=not received. |
VARCHAR2 |
1 |
OFF_CAMPUS_TRAVEL |
Did student travel off-campus for this UROP? Values: Y/N |
VARCHAR2 |
1 |
PROJECT_STATUS |
Status of an UROP project. Examples: Approved, Cancelled, Rejected. |
VARCHAR2 |
30 |
UROP_STATUS_KEY |
Use this field to join together UROP PROJECT DETAIL and UROP STATUS tables. |
VARCHAR2 |
40 |
WAREHOUSE_LOAD_DATE |
The date the record was loaded into the Data Warehouse from the source system. |
DATE |
8 |