Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse WORK REQUEST STATUS Table


View exposing reference values describing status for facilities work requests and related service processes.


Field Name

Description

Data Type

Length

WAREHOUSE_LOAD_DATE

Date the record was loaded into the data warehouse.

DATE

WORK_REQUEST_STATUS

Work request status associated with the record.

VARCHAR2

100

WORK_REQUEST_STATUS_CODE

Code identifying work request status.

VARCHAR2

100

WORK_REQUEST_STATUS_KEY

Surrogate key identifying the work request status.

VARCHAR2

103