Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse WORK ORDER TYPE Table


XXX


Field Name

Description

Data Type

Length

IS_SHUTDOWN_REQUIRED

XXX

VARCHAR2

1

IS_SUB_ORDER

XXX

VARCHAR2

1

MAINTENANCE_ACTIVITY_TYPE

XXX

VARCHAR2

30

MAINTENANCE_ACTIVITY_TYPE_CODE

XXX

VARCHAR2

3

PLANT_CODE

XXX

VARCHAR2

4

WAREHOUSE_LOAD_DATE

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

DATE

WORK_ORDER_SOURCE

XXX

VARCHAR2

3

WORK_ORDER_TYPE

XXX

VARCHAR2

40

WORK_ORDER_TYPE_CODE

XXX

VARCHAR2

4

WORK_ORDER_TYPE_KEY

XXX

VARCHAR2

22