Maintenance Forecast Line
The Maintenance Forecast Line view object contains the forecast lines that are generated for the maintenance program. Forecasts are generated for the schedule pattern specified in the work requirements.
Data Store Key : FscmTopModelAM.ScmExtractAM.MntBiccExtractAM.MntForecastLineExtractPVO
Primary Keys : ForecastLineId
Initial Extract Date : CreationDate
Incremental Extract Date : LastUpdateDate
Attributes
This table provides the list of exposed attributes and their descriptions.
| Name | Description |
|---|---|
| AssetId | Value that uniquely identifies the asset. This is the primary key of the Maintenance Forecast Line view object. |
| ConditionEventCodeId | Value that identifies condition event code. This forecast line is created with this value to establish connection with the work order created. |
| CreatedBy | User who created the maintenance forecast line record. |
| CreationDate | Date and time when the user created the maintenance forecast line record. |
| CycleInterval | The cycle interval in which the forecast is generated. |
| ForecastDate | Date when the work requirement for the asset is scheduled to perform the work based on the schedule pattern and the cycle interval. |
| ForecastId | Value that uniquely identifies the maintenance forecast on the maintenance forecast line. This is the primary key of the Maintenance Forecast Line view object. |
| ForecastLineId | Value that uniquely identifies the maintenance forecast line record. |
| ForecastMtrReadingValue | Indicates the reading value computed for the cycle interval on the maintenance forecast line record. |
| ForecastSequence | Indicates the forecast sequence that is used to internally determine the winner on the maintenance forecast line record. |
| ItemId | Value that uniquely identifies the item that the application has enabled for the maintenance forecast line record. |
| JobDefinitionName | Indicates the name of the job that created or last updated the row for the maintenance forecast line record. This is populated through Enterprise Service Scheduler. |
| JobDefinitionPackage | Indicates the package name of the job that created or last updated the row for the maintenance forecast line record. This is populated through Enterprise Service Scheduler. |
| LastUpdateDate | Date and time when the user last updated the maintenance forecast line record. |
| LastUpdateLogin | Indicates the session login associated with the user who last updated the maintenance forecast line record. |
| LastUpdatedBy | Indicates the user who last updated the maintenance forecast line record. |
| MeterDefinitionId | Value that identifies the meter definition. The forecast is generated because of the meter template that is defined at the item level. |
| MeterId | Value that identifies the meter. The forecast is generated because of the meter that is defined at the item level. |
| NextWorkOrderOnlyFlag | Indicates 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. In addition, the other occurrences of forecasts that are to be converted as work orders are ignored. |
| ObjectVersionNumber | Number of times the object row was updated. This attribute is used to implement optimistic locking. This number is incremented every time 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. |
| OrganizationId | Value that identifies the maintenance organization in which the maintenance program is authored. |
| RequestId | Value that identifies the request job that created or last updated the row. This is populated through Enterprise Service Scheduler. |
| RequirementId | Value the identifies the maintenance requirement for the maintenance forecast line record. This is a foreign key to the Maintenance Requirement Forecast Line view object. |
| RequirementWdId | Value that identifies the work definition requirement for the maintenance forecast line record. |
| SchedulePatternId | Value that identifies the schedule pattern for the maintenance forecast line record. |
| SuppressedFlag | Indicates if the work definition requirement is suppressed for the asset in the creation of the forecast. |
| WorkDefinitionId | This value identifies the work definition identifier associated to the maintenance forecast line record. |
| WorkDefinitionVersionId | This value identifies the work definition version identifier associated to the maintenance forecast line record. |