MNT_FORECAST_LINES
This table stores the forecast lines that are generated for the maintenance program. Forecasts are generated for the schedule pattern specified in the work requirements.
Details
-
Schema: FUSION
-
Object owner: MNT
-
Object type: TABLE
-
Tablespace: Default
Primary Key
| Name | Columns |
|---|---|
|
MNT_FORECAST_LINES_PK |
FORECAST_LINE_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| FORECAST_LINE_ID | NUMBER | 18 | Yes | The unique system generated system identifier. | |
| OBJECT_VERSION_NUMBER | NUMBER | 9 | Yes | 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_ID | NUMBER | 18 | Yes | Foreign key reference to the work requirement. | |
| ORGANIZATION_ID | NUMBER | 18 | Yes | The organization identifier. This is the maintenance organization in which the maintenance program is authored. | |
| SCHEDULE_PATTERN_ID | NUMBER | 18 | Foreign key to the schedule pattern business object. | ||
| METER_DEFINITION_ID | NUMBER | 18 | Meter Definition Identifier. The forecast that is generated because of the meter template that is defined at the item level. | ||
| METER_ID | NUMBER | 18 | Meter Identifier. The forecast that is generated because of the meter that is defined at the item level. | ||
| CYCLE_INTERVAL | NUMBER | The cycle interval in which the forecast is generated. | |||
| DAY_INTERVAL_VALUE | NUMBER | The day interval value for which this forecast line is created. | |||
| METER_INTERVAL_VALUE | NUMBER | The interval value of the meter that triggered the forecast for meter based requirements. | |||
| FORECAST_MTR_READING_VALUE | NUMBER | The reading value computed for the cycle interval. | |||
| METER_UTILIZATION_RATE | NUMBER | The meter utilization rate used in the computation of this forecast. | |||
| FORECAST_SEQUENCE | NUMBER | The forecast sequence that is used to internally figure out the winner. | |||
| FORECAST_DATE | DATE | Yes | Date when the work requirement for the asset is scheduled to perform the work based on the schedule pattern and the cycle interval. | ||
| ITEM_ID | NUMBER | 18 | Yes | The foreign key to the inventory item identifier. | |
| ASSET_ID | NUMBER | 18 | Yes | The foreign key reference to the asset business object. | |
| REQUIREMENT_WD_ID | NUMBER | 18 | The foreign key to the mnt_wr_work_definitions table. to uniquely identify the row from the forecast lines scratch pad to the consumed work definition due_in_cycle combo. | ||
| WORK_DEFINITION_ID | NUMBER | 18 | Yes | The work definitions used in the generated forecast. | |
| WORK_DEFINITION_VERSION_ID | NUMBER | 18 | The version of the work definition updated in the forecast lines when work orders are created for this specific forecast. | ||
| CONDITION_EVENT_CODE_ID | NUMBER | 18 | Condition Event Code reference. This forecast line is created with this value to establish connection with the work order created. | ||
| SUPPRESSED_FLAG | VARCHAR2 | 1 | Yes | Flag to indicate whether the work definition requirenment is suppressed for the asset in the creation of the forecast. | |
| FORECAST_ID | NUMBER | 18 | Foreign key to the generated forecasts. | ||
| 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. | ||
| 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_FORECAST_LINES_N01 | Non Unique | Default | FORECAST_ID |
| MNT_FORECAST_LINES_N02 | Non Unique | Default | FORECAST_DATE |
| MNT_FORECAST_LINES_N03 | Non Unique | Default | REQUIREMENT_ID, ASSET_ID, WORK_DEFINITION_ID |
| MNT_FORECAST_LINES_U01 | Unique | Default | FORECAST_LINE_ID |