WORK ORDER OPERATION DETAIL Table
View exposing detailed operation records associated with facilities work orders and maintenance activities.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
ACTIVITY_NUMBER |
Activity number associated with the record. |
VARCHAR2 |
4 |
ACTUAL_WORK |
Actual work associated with the record. |
VARCHAR2 |
17 |
CAPACITIES |
Capacities associated with the record. |
VARCHAR2 |
4 |
CONFIRMATION_NUMBER |
Confirmation number associated with the record. |
VARCHAR2 |
10 |
CONTROL_KEY |
Surrogate key identifying the control. |
VARCHAR2 |
4 |
COUNTER |
Counter associated with the record. |
VARCHAR2 |
8 |
DELETION_FLAG |
Indicator identifying whether deletion (Y/N). |
VARCHAR2 |
1 |
DURATION |
Duration associated with the record. |
VARCHAR2 |
7 |
GOODS_RECIPIENT |
Goods recipient associated with the record. |
VARCHAR2 |
12 |
OBJECT_ID_RESOURCE |
Object id resource associated with the record. |
VARCHAR2 |
8 |
OBJECT_NUMBER |
Object number associated with the record. |
VARCHAR2 |
22 |
OBJECT_STATUS |
Object status associated with the record. |
VARCHAR2 |
40 |
OPERATION_TEXT |
Operation text associated with the record. |
VARCHAR2 |
80 |
ROUTING_NUMBER |
Routing number associated with the record. |
VARCHAR2 |
10 |
SEQUENCE |
Sequence associated with the record. |
VARCHAR2 |
20 |
TASK_LIST_TYPE |
Task list type associated with the record. |
VARCHAR2 |
1 |
UNIT_FOR_WORK |
Unit for work associated with the record. |
VARCHAR2 |
3 |
USER_STATUS |
User status associated with the record. |
VARCHAR2 |
4 |
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |
|
WORK_CENTER_KEY |
Surrogate key identifying the work center. |
VARCHAR2 |
8 |
WORK_INVOLVED |
Work involved associated with the record. |
VARCHAR2 |
9 |
WORK_ORDER_CONFRM_ACTIVITY_KEY |
Surrogate key identifying the work order confrm activity. |
VARCHAR2 |
6 |
WORK_ORDER_KEY |
Surrogate key identifying the work order. |
VARCHAR2 |
7 |
WORK_ORDER_PLANNER_GROUP_KEY |
Surrogate key identifying the work order planner group. |
VARCHAR2 |
20 |