Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse 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