Maintenance Work Requirement

The Maintenance Work Requirement view object contains the detailed work requirements of the Maintenance Program view object. Maintenance program is a preventive maintenance plan to be executed at regular schedule and based on asset usage. Maintenance program can also be scheduled based on asset conditions.

Data Store Key : FscmTopModelAM.ScmExtractAM.MntBiccExtractAM.MntWorkRequirementExtractPVO

Primary Keys : MntWorkRequirementTranslatio1Language, MntWorkRequirementTranslatio1RequirementId, RequirementId

Initial Extract Date : CreationDate

Incremental Extract Date : LastUpdateDate

Attributes

This table provides the list of exposed attributes and their descriptions.

Name	Description
ActiveEndDate	The active date and time when the user ended the maintenance work requirement record.
ActiveStartDate	The active date and time when the user created the maintenance work requirement record.
AssetId	Value that uniquely identifies the asset number. This is the primary key of the Maintenance Work Requirement view object.
CalendarBasedFlag	Indicates if this requirement will to be used for a periodic calendar-based forecasting.
ConditionBasedFlag	Indicates if this requirement will 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 ad-hoc work.
CreatedBy	User who created the maintenance work requirement record.
CreationDate	Date and time when the user created the maintenance work requirement record.
ForecastUsingCycleFlag	Indicates if the requirement is to be forecasted using a cycle of patterns either for the schedule or meter-based requirement.
IntervalsInTheCycle	Intervals in the cycle of patterns. Indicates the intervals to be considered in the cycle.
ItemId	Value that uniquely identifies the item that the application has enabled for the maintenance work requirement record.
JobDefinitionName	Indicates the name of the job that created or last updated the row for the maintenance work requirement 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 work requirement record. This is populated through Enterprise Service Scheduler.
Language	Indicates the code of the language into which the contents of the maintenance work requirement are translated.
LastForecastDate	Date when the forecast was run last for this maintenance program.
LastUpdateDate	Date and time when the user last updated the maintenance work requirement record.
LastUpdateLogin	Indicates the session login associated with the user who last updated the maintenance work requirement record.
LastUpdatedBy	Indicates the user who last updated the maintenance work requirement record.
MeterBasedFlag	Indicates if this requirement will be used for a usage-based forecasting. Usage is drawn from the readings on the meter tied to the asset.
MntWorkRequirementTranslatio1CreatedBy	User who created the work requirement for the maintenance work requirement translation record.
MntWorkRequirementTranslatio1CreationDate	Date and time when the user created the work requirement for the maintenance work requirement translation record.
MntWorkRequirementTranslatio1Language	Code of the language into which the work requirement record for the maintenance work requirement translation is translated.
MntWorkRequirementTranslatio1LastUpdateDate	Date and time when the user last updated the work requirement for the maintenance work requirement translation record.
MntWorkRequirementTranslatio1LastUpdateLogin	Session login associated with the user who last updated the work requirement for the maintenance work requirement translation record.
MntWorkRequirementTranslatio1LastUpdatedBy	User who last updated the work requirement for maintenance work requirement translation record.
MntWorkRequirementTranslatio1ObjectVersionNumber	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.
MntWorkRequirementTranslatio1RequirementId	Value that uniquely identifies the work requirement for the maintenance work requirement translation record.
MntWorkRequirementTranslatio1RequirementName	Indicates the work requirement name for the maintenance work requirement translation record.
MntWorkRequirementTranslatio1SourceLang	Code of the language in which the contents of the work requirement for the maintenance work requirement translation record were originally created.
ModifiedFlag	Indicates if the maintenance program is used after a forecast generation was already run. You may choose to run a maintenance forecast which overrides the previous maintenance program.
NextWorkOrderOnlyFlag	Indicates if 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 occurrences of forecasts that are to be converted as work orders will be 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.
ProgramId	Value that identifies the maintenance program for the maintenance work requirement record. This is a foreign key to the Maintenance Work Requirement view object.
RequestId	Value that identifies the job request that created or last updated the row. This is populated through Enterprise Service Scheduler.
RequirementId	Value that uniquely identifies the maintenance work requirement.
RequirementTypeCode	Indicates if the requirement is done at the asset level or item level. The valid values are Asset and Item.
SchedulePatternId	Value that identifies the schedule pattern for the maintenance work requirement record. This is a foreign key to the Maintenance Work Requirement view object.
StatusCode	Indicates the status of the maintenance work requirements. The valid statuses are Draft and Active.
SuppressMergeCode	Indicates whether the work definitions are suppressed or merged when forecasts are generated on the same scheduled date.
SuppressMergeOverrideFlag	Indicates if the program level concurrent requirements are overridden at the work requirement level.