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 |