Work Requirement Condition Event

The Work Requirement Condition Event view object contains the condition event codes that are used in the work order creation when such conditions are encountered in the third party application such as IoT or other third party applications which feed conditions. The condition even works for asset needing ad-hoc work order in maintenance management rather than forecast program. This is essentially a work requirement definition for such conditions.

Data Store Key : FscmTopModelAM.ScmExtractAM.MntBiccExtractAM.WorkRequirementConditionEventPVO

Primary Keys : RequirementConditionEventId

Initial Extract Date : CreationDate

Incremental Extract Date : LastUpdateDate

Attributes

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

Name Description
ConditionEventCodeId Value that identifies the condition event code. This is a foreign key to the Condition Event Code view object for the work requirement. The value is captured from IoT, and the work definitions associated with this work requirement are used to create the work order.
CreatedBy User who created the work requirement condition event record.
CreationDate Date and time when the user created the work requirement condition event record.
JobDefinitionName Indicates the name of the job that created or last updated the row for the work requirement condition event 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 work requirement condition event record. This is populated through Enterprise Service Scheduler.
LastUpdateDate Date and time when the user last updated the work requirement condition event record.
LastUpdateLogin Indicates the session login associated with the user who last updated the work requirement condition event record.
LastUpdatedBy Indicates the user who last updated the work requirement condition event 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 identify 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 job request that created or last updated the row. This is populated through Enterprise Service Scheduler.
RequirementConditionEventId Value that uniquely identifies the work requirement condition event record.
RequirementId Value that uniquely identifies the work requirement for the condition event code. This is a foreign to the Work Requirement Condition Event view object.