WORK ORDER TYPE Table
View exposing reference values describing facilities work order types used for maintenance classification and reporting.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
IS_SHUTDOWN_REQUIRED |
Indicator identifying whether shutdown required (Y/N). |
VARCHAR2 |
1 |
IS_SUB_ORDER |
Indicator identifying whether sub order (Y/N). |
VARCHAR2 |
1 |
MAINTENANCE_ACTIVITY_TYPE |
Maintenance activity type associated with the record. |
VARCHAR2 |
30 |
MAINTENANCE_ACTIVITY_TYPE_CODE |
Code identifying maintenance activity type. |
VARCHAR2 |
3 |
PLANT_CODE |
Code identifying plant. |
VARCHAR2 |
4 |
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |
|
WORK_ORDER_SOURCE |
Work order source associated with the record. |
VARCHAR2 |
3 |
WORK_ORDER_TYPE |
Work order type associated with the record. |
VARCHAR2 |
40 |
WORK_ORDER_TYPE_CODE |
Code identifying work order type. |
VARCHAR2 |
4 |
WORK_ORDER_TYPE_KEY |
Surrogate key identifying the work order type. |
VARCHAR2 |
22 |