Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse WORK ORDER CATEGORY Table


XXX


Field Name

Description

Data Type

Length

WAREHOUSE_LOAD_DATE

The date the record was loaded into the Data Warehouse from the source system.

DATE

WORK_ORDER_CATEGORY_CODE

XXX

VARCHAR2

20

WORK_ORDER_CATEGORY_DESC

XXX

VARCHAR2

40

WORK_ORDER_CATEGORY_KEY

XXX

VARCHAR2

7

WORK_ORDER_SUBCATEGORY_CODE

XXX

VARCHAR2

20

WORK_ORDER_SUBCATEGORY_DESC

XXX

VARCHAR2

40

WORK_ORDER_TYPE

XXX

VARCHAR2

4

WORK_REQUEST_TYPE

XXX

VARCHAR2

2