MNT_PROGRAMS_EXT
This table stages the maintenance program or maintenance schedule data to be transferred to the machine learning data lake.
Details
-
Schema: FUSION
-
Object owner: MNT
-
Object type: TABLE
-
Tablespace: Default
Primary Key
| Name | Columns |
|---|---|
|
MNT_PROGRAMS_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. This is the maintenance organization in which the maintenance program is authored. | ||
| ORGANIZATION_CODE | VARCHAR2 | 18 | The organization code of the operating organization that is associated to the asset. | ||
| PROGRAM_ID | NUMBER | 18 | The maintenance program unique identifier. This is a system generated primary key. | ||
| PROGRAM_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. | ||
| 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. | ||
| LAST_FORECAST_DATE | DATE | The date when the forecast was run last for this maintenance program. | |||
| REQUIREMENT_ID | NUMBER | 18 | The unique system generated identifier for the work requirement. | ||
| REQUIREMENT_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. | ||
| REQUIREMENT_NAME | VARCHAR2 | 120 | The unique name for the maintenance work requiremnt within the maintenance program. | ||
| ASSET_ITEM_ID | NUMBER | 18 | Foreign key to the inventory item. | ||
| ASSET_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. | ||
| RELIABILITY_RATE | NUMBER | The reliability rate for the asset. | |||
| 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. | ||
| 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. | ||
| SCHEDULE_PATTERN_ID | NUMBER | 18 | The foreign key reference to the schedule pattern. | ||
| SCHEDULE_PATTERN_NAME | VARCHAR2 | 120 | The name of the schedule pattern. | ||
| SCHEDULE_DURATION | NUMBER | The calendar duration between the scheduled maintenance. | |||
| SCHEDULE_DURATION_UOM_CODE | VARCHAR2 | 3 | The unit of measure code in which the schedule duration is persisted. | ||
| REQUIREMENT_METER_ID | NUMBER | 18 | The unique system generated system identifier. | ||
| 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. | ||
| BASE_INTERVAL | NUMBER | The base inteval at which the readings are to be used for this requirement. | |||
| BASE_INTERVAL_UOM_CODE | VARCHAR2 | 3 | The unit of measure code for the meter usage base interval. | ||
| NEXT_FORECAST_DUE_BY_CODE | VARCHAR2 | 30 | Whether the next forecast is to be generated based on "Base Interval" specified in the requirement or "Reading History". | ||
| REQUIREMENT_WD_ID | NUMBER | 18 | The unique system generated system identifier. | ||
| DUE_AT_CYCLE_INTERVAL | NUMBER | The interval at which this work definition is applied to the forecast on a cycle based work requirement. | |||
| REPEATS_IN_CYCLE_FLAG | VARCHAR2 | 1 | Denotes whether the work definition usage in the forecast repeats in the cycle when the due at cycle interval specified at the work definition is arrived. | ||
| WORK_DEFINITION_ID | NUMBER | 18 | The work definition identifier. This is what is finally going to be used in the creation of the work order from the projected forecasts. | ||
| 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. | ||
| WD_OPERATION_ID | NUMBER | 18 | The unique identifier of a work definition operation. Its value is an application generated unique id. | ||
| WD_OPERATION_NAME | VARCHAR2 | 120 | Indicates the name of the work definition operation. | ||
| WD_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. | ||
| WD_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. | ||
| UTILIZATION_RATE | NUMBER | The utilization rate of the material item that will be used in the learning algorithm. | |||
| MP_CREATION_DATE | TIMESTAMP | Indicates the date and time of the creation of the Maintenance Program. | |||
| MP_LAST_UPDATE_DATE | TIMESTAMP | Indicates the date and time of the last update of the Maintenance Program. | |||
| 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_PROGRAMS_EXT_U1 | Unique | Default | DATA_ROW_ID |