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