1. Tables and Views for SCM
  2. MNT_WORK_ORDERS_EXT

MNT_WORK_ORDERS_EXT

The table stages the maintenance work order data that are to be passed on to machine learning data lake.

Details

  • Schema: FUSION

  • Object owner: MNT

  • Object type: TABLE

  • Tablespace: Default

Primary Key

Name Columns

MNT_WORK_ORDERS_EXT_PK

DATA_ROW_ID

Columns

Name Datatype Length Precision Not-null Comments
DATA_ROW_ID NUMBER 18 Yes The primary key of the data extraction. System generated.
RUN_ID NUMBER 18 Yes Data gathered for a specific run will have this foreign key reference to the MNT_LEARNING_RUNS table.
ORGANIZATION_ID NUMBER 18 The organization identifier that represents the manufacturing plant to which this work order belongs.
ORGANIZATION_CODE VARCHAR2 18 The organization code of the operating organization that is associated to the asset.
WORK_ORDER_ID NUMBER 18 The unique identifier of work order record. Its value is an application generated unique id.
WORK_ORDER_OVN NUMBER 9 Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried.
WORK_ORDER_NUMBER VARCHAR2 120 Represents the user-facing identifier of the work order.
WORK_ORDER_TYPE VARCHAR2 30 Indicates the type of this work order. Values are contained within the ORA_WIE_WO_TYPE lookup if this work order is a manufacturing work order. If this is a maintenance work order, valid values are contained within the ORA_MNT_WO_TYPE lookup.
WORK_ORDER_SUB_TYPE VARCHAR2 30 The subtype specifically will be populated for non-standard work. This is used to derive the appropriate costing account for non-standard work. Values are contained in the ORA_WIE_WO_SUB_TYPE lookup if this work order is a manufacturing work order. If this is a maintenance work order, valid values are contained within the ORA_MNT_WO_SUB_TYPE lookup.
UNPLANNED_WO_FLAG VARCHAR2 1 Flag indicating whether the work order was created from a planned maintenance program.
WO_ITEM_ID NUMBER 18 Refers to the top level, final assembly, subassembly, or model item which belongs to the given organization.
WO_ITEM_NUMBER VARCHAR2 300 User identifier of the item/product.
ASSET_ID NUMBER 18 Foreign key reference to the Asset business object.
ASSET_NUMBER VARCHAR2 80 An user identifier for the asset object. This is the user primary key for the asset. If user does not enter a value then it is system generated using the Asset Document Number Sequence.
ASSET_FAILURE_FLAG VARCHAR2 1 Flag indicating that the work order was created to fix an asset failure.
ASSET_TBF NUMBER The time between failure for the asset.
ASSET_UBF NUMBER The usage between failure of the asset.
WORK_DEFINITION_ID NUMBER 18 The foreign key reference to the work definition.
WORK_DEFINITION_VERSION_ID NUMBER 18 The version of the work definition.
WORK_DEFINITION_CODE VARCHAR2 30 The unique user defined code for the maintenance work definition.
WORK_DEFINITION_NAME VARCHAR2 120 The user defined name for the maintenance work definition.
WORK_ORDER_STATUS_ID NUMBER 18 Represents the internal identifier of the user-defined status of the work order.
WORK_ORDER_COST NUMBER The cost of performing the work on the asset using this particular work order.
PLANNED_START_DATE TIMESTAMP Planned start date of the work order.
PLANNED_COMPLETION_DATE TIMESTAMP Planned completion date of the work order.
ACTUAL_START_DATE TIMESTAMP Actual start date of the work order.
ACTUAL_COMPLETION_DATE TIMESTAMP Actual completion date of the work order.
RELEASED_DATE TIMESTAMP Date when the work order is released.
CLOSED_DATE TIMESTAMP Date when the work order is closed.
CANCELED_DATE TIMESTAMP Date when the work order is canceled.
CANCELED_REASON VARCHAR2 240 Reason for which the work order is canceled. This is a free format text.
MNT_FORECAST_ID NUMBER 18 Reference to the maintenance forecast that created the work order. Foreign key to MNT_FORECASTS.FORECAST_ID.
METER_ID NUMBER 18 Asset Meter Identifier. The meter id of the asset for which readings are to be used in the usage based requirement.
METER_NAME VARCHAR2 120 The name of the meter. Because this is a transalatable attribute, this cannot be used as an alternate key.
METER_DEFINITION_ID NUMBER 18 The meter template identifier. This column will be populated instead of the meter id, when the requirement type is of the item. So meter templates applicable for the item, can be used in the computation of forecasts for assets that belong to the item.
METER_UOM_CODE VARCHAR2 3 The unit of measure in which meter readings should be captured.
DAILY_UTILIZATION_RATE NUMBER Daily utilization rate for the meter. Default value at the template level.
READING_DATE TIMESTAMP The date when the reading is captured.
READING_VALUE NUMBER The numeric reading value that is captured for the meter.
NET_VALUE NUMBER Computed programmatically. Typically it will be = new reading + net of last reading, but there are some different formulas involved.
PROGRAM_ID NUMBER 18 The maintenance program unique identifier. This is a system generated primary key.
PROGRAM_CODE VARCHAR2 30 The user key to the maintenance program. The code is more commonly understood by the maintenance supervisor or planner that is defining and referencing them.
PROGRAM_NAME VARCHAR2 120 The unique name for the maintenance program.
REQUIREMENT_ID NUMBER 18 The unique system generated identifier for the work requirement.
REQUIREMENT_NAME VARCHAR2 120 The unique name for the maintenance work requiremnt within the maintenance program.
WO_OPERATION_ID NUMBER 18 The unique identifier of a work definition operation. Its value is an application generated unique id.
WO_OPERATION_NAME VARCHAR2 120 Indicates the name of the work definition operation.
WO_OPERATION_SEQ_NUMBER NUMBER Indicates the execution sequence of the operation.
WORK_CENTER_ID NUMBER 18 Indicates the work center where this operation is executed.
WORK_CENTER_CODE VARCHAR2 30 A code that represents the user key to the work center.
WORK_CENTER_NAME VARCHAR2 120 This field represents the name of the work center.
WO_OPERATION_MATERIAL_ID NUMBER 18 The unique identifier of a work definition operation material. Its value is an application generated unique id.
MATERIAL_SEQ_NUMBER NUMBER Indicates the sequence of this material line within this operation.
MATERIAL_ITEM_ID NUMBER 18 Represents the unique identifier of the item for this material line.
MATERIAL_ITEM_NUMBER VARCHAR2 300 User identifier of the material item.
MATERIAL_QUANTITY NUMBER This is the quantity required to produce one unit of finished goods. In the case of an ATO model, this field will not be populated and instead fetched directly from PIM.
MATERIAL_UOM_CODE VARCHAR2 3 Represents the unit of measure code of the material quantity.
PART_FAILURE_FLAG VARCHAR2 1 Flag indicating wheter the part (or the material) on the asset failed and was either fixed or replaced.
MATERIAL_TTF NUMBER The time to failure of the part item. This is computed by the machine learning algorithm.
MATERIAL_UTF NUMBER The usage to failure of the part item. This is computed by the machine learning algorithm.
WO_CREATION_DATE TIMESTAMP Indicates the date and time of the creation of the Work Order.
WO_LAST_UPDATE_DATE TIMESTAMP Indicates the date and time of the last update of the Work Order.
CREATED_BY VARCHAR2 64 Yes Who column: indicates the user who created the row.
CREATION_DATE TIMESTAMP Yes Who column: indicates the date and time of the creation of the row.
LAST_UPDATED_BY VARCHAR2 64 Yes Who column: indicates the user who last updated the row.
LAST_UPDATE_DATE TIMESTAMP Yes Who column: indicates the date and time of the last update of the row.
LAST_UPDATE_LOGIN VARCHAR2 32 Who column: indicates the session login associated to the user who last updated the row.
REQUEST_ID NUMBER 18 Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row.
JOB_DEFINITION_NAME VARCHAR2 100 Enterprise Service Scheduler: indicates the name of the job that created or last updated the row.
JOB_DEFINITION_PACKAGE VARCHAR2 900 Enterprise Service Scheduler: indicates the package name of the job that created or last updated the row.

Indexes

Index Uniqueness Tablespace Columns
MNT_WORK_ORDERS_EXT_U01 Unique Default DATA_ROW_ID