Asset Failure Sets

The Asset Failure Sets view object contains information that holds the definition of the failure set . Each row stores the associated failure chain enforced flag, failure set codes and failure sets. The combination of these attributes forms the unique identifier of the asset failure set.

Data Store Key : FscmTopModelAM.ScmExtractAM.CseBiccExtractAM.CseAssetFailureSetExtractPVO

Primary Keys : FailureSetTLAnalyticsPEOFailureSetId, FailureSetTLAnalyticsPEOLanguage, FailureSetId

Initial Extract Date : CreationDate

Incremental Extract Date : LastUpdateDate

Attributes

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

Name Description
ActiveEndDate End date of the failure set.
CreatedBy User who created the failure set for the asset record.
CreationDate Date and time when the user created the failure set for the asset record.
FailureChainsEnforcedFlag Value that indicates if failures for assets associated to this failure set must be validated and enforced. The captured failure-cause-resolution combinations are defined as active failure chains in the failure set.
FailureSetCode Value that uniquely identifies the code for the failure set. This is the user key for the failure set.
FailureSetId Value that uniquely identifies the primary key for the failure set. This is a system generated using the Global Unique Identifier generator.
FailureSetTLAnalyticsPEOCreatedBy User who created the failure set for the asset record.
FailureSetTLAnalyticsPEOCreationDate Date and time when the user created the failure set for the asset record.
FailureSetTLAnalyticsPEOFailureSetDesc Value that identifies the failure set description for the asset record.
FailureSetTLAnalyticsPEOFailureSetId Value that uniquely identifies the primary key for the failure set. This is system generated using the Global Unique Identifier generator.
FailureSetTLAnalyticsPEOFailureSetName Value that identifies the failure set name for the asset record.
FailureSetTLAnalyticsPEOLanguage Code of the language into which the failure sets are translated for the asset record.
FailureSetTLAnalyticsPEOLastUpdateDate Date and time when the user most recently updated the failure set for the asset record.
FailureSetTLAnalyticsPEOLastUpdateLogin Session login associated with the user who most recently updated the failure set for the asset record.
FailureSetTLAnalyticsPEOLastUpdatedBy User who most recently updated the failure set for the asset record.
FailureSetTLAnalyticsPEOObjectVersionNumber Number of times the object row for the failure set analytics 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.
FailureSetTLAnalyticsPEOSourceLang Code of the language in which the contents of the failure set columns were originally created.
Language Code of the language into which the failure set is translated for the asset record.
LastUpdateDate Date and time when the user most recently updated the failure set for the asset record.
LastUpdateLogin Session login associated with the user who most recently updated the failure set for the asset record.
LastUpdatedBy User who most recently updated the failure set record for the asset.
ObjectVersionNumber Number of times the object row for the failure set 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.