Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse UROP DEPARTMENT Table


View exposing UROP department reference records including departments participating in undergraduate research programs.


Field Name

Description

Data Type

Length

UROP_CREDIT_DEPARTMENT

Urop credit department associated with the record.

VARCHAR2

30

UROP_CREDIT_DEPARTMENT_CODE

Code identifying urop credit department.

VARCHAR2

4

UROP_DEPARTMENT

Urop department associated with the record.

VARCHAR2

30

UROP_DEPARTMENT_CODE

Code identifying urop department.

VARCHAR2

4

UROP_DEPARTMENT_KEY

Surrogate key identifying the urop department.

VARCHAR2

9

WAREHOUSE_LOAD_DATE

Date the record was loaded into the data warehouse.

DATE