Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse UROP TERM Table


View exposing UROP term reference records including academic term attributes associated with undergraduate research participation.


Field Name

Description

Data Type

Length

ACADEMIC_YEAR

Academic year associated with the record.

VARCHAR2

4

END_DATE

Date associated with end.

DATE

START_DATE

Date associated with start.

DATE

UROP_TERM_CODE

Code identifying urop term.

VARCHAR2

6

UROP_TERM_DESCRIPTION

Description of urop term.

VARCHAR2

50

UROP_TERM_KEY

Surrogate key identifying the urop term.

VARCHAR2

6

WAREHOUSE_LOAD_DATE

Date the record was loaded into the data warehouse.

DATE