Condition Event Codes

The Condition Event Codes view object contains information about events that are encountered in third-party applications. Each row of this object stores associated category codes, events codes, condition event codes, and condition event types. The combination of these attributes forms the unique identifier of the condition event codes.

Data Store Key : FscmTopModelAM.ScmExtractAM.CseBiccExtractAM.CseAssetConditionEventCodeExtractPVO

Primary Keys : CondEventCodeTLAnalyticsPEOConditionEventCodeId, CondEventCodeTLAnalyticsPEOLanguage, ConditionEventCodeId

Initial Extract Date : CreationDate

Incremental Extract Date : LastUpdateDate

Attributes

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

Name Description
ActiveEndDate Date and time when the user end dated the condition event record for the asset.
CategoryCode Value that identifies the condition event category code enter by the user.
CondEventCodeTLAnalyticsPEOConditionEventCodeDesc Value that identifies the condition event code description entered by the user.
CondEventCodeTLAnalyticsPEOConditionEventCodeId Value that uniquely identifies the condition event system generator identifier.
CondEventCodeTLAnalyticsPEOConditionEventCodeName Value that identifies the condition event code name.
CondEventCodeTLAnalyticsPEOCreatedBy User who created the condition event code for the asset.
CondEventCodeTLAnalyticsPEOCreationDate Date and time when the condition event code was created for the asset.
CondEventCodeTLAnalyticsPEOLanguage Code of the language into which the condition event codes are translated.
CondEventCodeTLAnalyticsPEOLastUpdateDate Date and time when the user most recently updated the condition event code record.
CondEventCodeTLAnalyticsPEOLastUpdateLogin Session login associated with the user who most recently updated the condition event code record.
CondEventCodeTLAnalyticsPEOLastUpdatedBy User who most recently updated the condition event code record for the asset.
CondEventCodeTLAnalyticsPEOObjectVersionNumber Number of times the condition event code 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.
CondEventCodeTLAnalyticsPEOSourceLang Code of the language in which the contents of the condition event columns were originally created.
ConditionEventCode Value that identifies the condition event code. This is the foreign key to the Condition Event Codes view object. When such condition event codes are raised from IoT, the work definitions associated with this work requirement are used in the creation of the work order.
ConditionEventCodeId Value that identifies the condition event code identifier.
ConditionEventTypeCode Value that identifies the condition event type.
CreatedBy User who create the condition event for the asset.
CreationDate Date and time when user created the condition event for the asset.
JobDefinitionName Value that identifies the package name of the job that created or most recently updated the row for the condition event record for the asset. This is populated through the Enterprise Service Scheduler.
JobDefinitionPackage Value that identifies the package name of the job that created or most recently updated the row for condition event record for the asset. This is populated through the Enterprise Service Scheduler.
Language Code of the language into which the contents of the condition event are translated for the asset.
LastUpdateDate Date and time when the user most recently updated the condition event record for the asset.
LastUpdateLogin Session login associated with the user who most recently updated the condition event record for the asset.
LastUpdatedBy User who most recently updated the condition event record for the asset.
ObjectVersionNumber Number of times the object row for the condition event code 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.
RequestId Value that identifies the request identifier of the job that created or most recently updated the row. This is populated through the Enterprise Service Scheduler.
SourceRefId Value that identifies the source reference identifier of the job that created or most recently updated the row. This is populated through the Enterprise Service Scheduler.