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. |