Maintenance Requirement Work Definition

The Maintenance Requirement Work Definition view object contains the work definitions that are used to define work orders for the maintenance program work requirements.

Data Store Key : FscmTopModelAM.ScmExtractAM.MntBiccExtractAM.MntRequirementWorkDefinitionExtractPVO

Primary Keys : RequirementWdId

Initial Extract Date : CreationDate

Incremental Extract Date : LastUpdateDate

Attributes

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

Name Description
CreatedBy User who created the maintenance requirement work definition record.
CreationDate Date and time when the user created the maintenance requirement work definition record.
DueAtCycleInterval Indicates the interval at which this work definition is applied to the forecast on a cycle based work requirement.
JobDefinitionName Indicates the name of the job that created or last updated the row for the maintenance requirement work definition 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 requirement work definition record. This is populated through Enterprise Service Scheduler.
LastUpdateDate Date and time when the user last updated the maintenance requirement work definition record.
LastUpdateLogin Indicates the session login associated with the user who last updated the maintenance requirement work definition record.
LastUpdatedBy Indicates the user who last updated the maintenance requirement work definition record.
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.
RepeatsInCycleFlag Indicates if the work definition usage in the forecast repeats in the cycle.
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 requirement work definition record. This is a foreign key to the Maintenance Requirement Work Definition view object.
RequirementWdId Value that identifies the work definition requirement for the maintenance requirement work definition record.
WorkDefinitionId Value that identifies the work definition that is used to create a work order from the projected forecasts.