Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse WORK REQUEST TYPE Table


View exposing reference values describing facilities work request types used for service classification and reporting.


Field Name

Description

Data Type

Length

WAREHOUSE_LOAD_DATE

Date the record was loaded into the data warehouse.

DATE

WORK_REQUEST_PRIORITY

Work request priority associated with the record.

VARCHAR2

20

WORK_REQUEST_TYPE

Work request type associated with the record.

VARCHAR2

40

WORK_REQUEST_TYPE_CODE

Code identifying work request type.

VARCHAR2

2

WORK_REQUEST_TYPE_KEY

Surrogate key identifying the work request type.

VARCHAR2

5