UROP DEPARTMENT Table
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.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
UROP_CREDIT_DEPARTMENT |
Name of the academic department to which URN credit applied. |
VARCHAR2 |
30 |
UROP_CREDIT_DEPARTMENT_CODE |
Academic department to which URN credit applied. |
VARCHAR2 |
4 |
UROP_DEPARTMENT |
UROP department which coordinates the UROP project. |
VARCHAR2 |
30 |
UROP_DEPARTMENT_CODE |
Name of the UROP department. |
VARCHAR2 |
4 |
UROP_DEPARTMENT_KEY |
Use this field to join together UROP PROJECT DETAIL and UROP DEPARTMENT tables. |
VARCHAR2 |
9 |
WAREHOUSE_LOAD_DATE |
The date the record was loaded into the Data Warehouse from the source system. |
DATE |
8 |