1. Tables and Views for SCM
  2. MNT_WORK_REQUIREMENTS_INT

MNT_WORK_REQUIREMENTS_INT

The open interface entity that holds all the maintenance program work requirement information.

Details

  • Schema: FUSION

  • Object owner: MNT

  • Object type: TABLE

  • Tablespace: INTERFACE

Primary Key

Name Columns

MNT_WORK_REQUIREMENTS_INT_PK

INTERFACE_ROW_ID

Columns

Name Datatype Length Precision Not-null Comments
INTERFACE_ROW_ID NUMBER 18 Yes Interface Row Identifier. The primary key column of this table.
INTERFACE_STATUS_CODE VARCHAR2 30 The status of the interface row. The processor heavily relies on this column to persist interim status of the row upon processing data in bulk.
INTERFACE_BATCH_ID NUMBER 18 Interface Batch Identifier. This is the foreign key to the Interface Batch entity.
INTERFACE_BATCH_CODE VARCHAR2 30 The interface batch code. The user key to the interface batch entity.
PARTITION_NUMBER NUMBER 18 For parallel processing, the internal logic uses this column to stripe a set of work requirements in to a partition.
HEADER_NUMBER VARCHAR2 18 Interface Record Number. This is the user key to link the child interface entities together.
ACTION_CODE VARCHAR2 30 The various actions that can be performed via the import functionality at the work requirements level.
REQUIREMENT_NAME VARCHAR2 120 The unique name for the maintenance work requiremnt within the maintenance program.
NEW_REQUIREMENT_NAME VARCHAR2 120 The unique name for the maintenance work requiremnt within the maintenance program. Populate this when the requirement name itself must be changed.
REQUIREMENT_ID NUMBER 18 The unique system generated identifier for the work requirement.
ORGANIZATION_ID NUMBER 18 The organization identifier. This is the maintenance organization in which the maintenance program is authored.
PROGRAM_ID NUMBER 18 Foreign key to the maintenance program identifier.
REQUIREMENT_TYPE_CODE VARCHAR2 30 This requirement is done at the asset level or at the item level is designated by this value. The valid values are 'Asset' or 'Item'.
ITEM_NUMBER VARCHAR2 300 Inventory Item Number. The user key to identify the product associated to the asset.
ITEM_ID NUMBER 18 Foreign key to the inventory item.
ASSET_NUMBER VARCHAR2 80 An user identifier for the asset object. This is the user primary key for the asset.
ASSET_ID NUMBER 18 Foreign key reference to the Asset business object.
STATUS_CODE VARCHAR2 30 The status of the maintenance work requirements. The valid statuses are Draft and Active.
FORECAST_USING_CYCLE_FLAG VARCHAR2 1 Flag indicating whether the requirement is to be forecasted using a cycle of patterns either for the schedule or meter based requirement.
INTERVALS_IN_THE_CYCLE NUMBER Intervals in the cycle of patterns. How many intervals are to be considered in the cycle. And varying work definitions can be specified to be picked up in the nth interval.
CALENDAR_BASED_FLAG VARCHAR2 1 Flag indicating whether this requirement is going to be used for a periodic calendar based forecasting.
SCHEDULE_PATTERN_NAME VARCHAR2 120 The name of the schedule pattern.
SCHEDULE_PATTERN_ID NUMBER 18 The foreign key reference to the schedule pattern.
METER_BASED_FLAG VARCHAR2 1 Flag indicating whether this requirement is going to be used for a usage based forecasting. Usage is drawn from the readings on the meter tied to the asset.
CONDITION_BASED_FLAG VARCHAR2 1 Flag indicating whether this requirement is going to be used for a condition based work order creation. A condition of the asset will be used in driving the work definition to be picked up for the creation of the adhoc work.
DAY_BASED_FLAG VARCHAR2 1 Indicates the method to forecast is a Day Interval.
NUMBER_OF_DAYS NUMBER Indicates the number of days between cycle intervals in the forecast. This is used in the day based forecast.
NEXT_FORECAST_DUE_BY_CODE VARCHAR2 30 Indicates if next due uses the Base Interval or the Last Service of a work order.
ASSET_HISTORY_SERVICE_DATE DATE Used for Asset based work requirements to indicate the last date in which the work was accomplished from an external system. This is just captured one time at the setting up of the program for the first time for this asset.
ASSET_HISTORY_SERVICE_INTERVAL NUMBER Used for Asset based work requirements to indicate the last interval in a cycle which the work was accomplished from an external system.
ASSET_INCLUSION_TYPE_CODE VARCHAR2 30 Indicates if the Assets are Implicitly or Explicitly covered by the work requirement. Values are Automatically or Manually.
ACTIVE_START_DATE DATE The effectivity start date of the work requirement.
ACTIVE_END_DATE DATE The effectivity end date of the work requirement.
SUPPRESS_MERGE_CODE VARCHAR2 30 The attribute indicates whether the work definitions are suppressed or merged when forecasts are generated on the same scheduled date.
SUPPRESS_MERGE_OVERRIDE_FLAG VARCHAR2 1 This flag indicates whether the program level concurrent requirements are overriden at the work requirement level.
NEXT_WORK_ORDER_ONLY_FLAG VARCHAR2 1 Flag indicating that the work order generation program only generates the very next work order to the already forecasted and completed work order in the work order creation horizon. The other occurances of forecasts that are to be converted as work orders will be ignored.
REQUIREMENT_REFERENCE VARCHAR2 120 A reference captured from another third party application.
REQUIREMENT_REFERENCE_ID NUMBER 18 A reference identifier captured from another third party application.
FORECAST_WINDOW_IN_DAYS NUMBER 9 The number of days to be considered for the forecast window.
WORK_ORDER_WINDOW_IN_DAYS NUMBER 9 The number of days to be considered for the work order window.
CREATE_WORK_ORDER_OPTION_CODE VARCHAR2 30 The mode in which the work order is created from the forecast. Is it automatically or via a manual process.
WORK_ORDER_STATUS_CODE VARCHAR2 30 Represents the user-key identifier of the work order status.
WORK_ORDER_STATUS_ID NUMBER 18 Represents the internal identifier of the user-defined status of the work order.
WORK_ORDER_PRIORITY NUMBER The priority of the work order that is to be created from this requirement.
FIRM_PLANNED_FLAG VARCHAR2 1 Flag to allow or prevent Planning from suggesting rescheduling and re-planning recommendations with respect to the Work Order. When the flag is on, this work order will not be considered by MRP to reschedule or re-plan.
LOAD_REQUEST_ID NUMBER 18 Load Request Identifier. This is to support the loading of the interface records from the data files using the cloud framework.
CREATED_BY VARCHAR2 64 Who column: indicates the user who created the row.
CREATION_DATE TIMESTAMP Who column: indicates the date and time of the creation of the row.
LAST_UPDATED_BY VARCHAR2 64 Who column: indicates the user who last updated the row.
LAST_UPDATE_DATE TIMESTAMP 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_REQUIREMENTS_INT_N01 Non Unique Default PARTITION_NUMBER
MNT_WORK_REQUIREMENTS_INT_N02 Non Unique Default INTERFACE_BATCH_ID, INTERFACE_STATUS_CODE, HEADER_NUMBER
MNT_WORK_REQUIREMENTS_INT_N03 Non Unique Default REQUIREMENT_NAME
MNT_WORK_REQUIREMENTS_INT_U01 Unique Default INTERFACE_ROW_ID