Asset Failure Chains

The Asset Failure Chains view object contains information about the failure, cause, and resolution. Each row of this object stores associated cause codes, failure chains, failure codes, and failure sets. The combination of these attributes forms the unique identifier of the asset failure chains.

Data Store Key : FscmTopModelAM.ScmExtractAM.CseBiccExtractAM.CseAssetFailureChainExtractPVO

Primary Keys : FailureChainId

Initial Extract Date : CreationDate

Incremental Extract Date : LastUpdateDate

Attributes

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

Name	Description
ActiveEndDate	Date when the applicability is no longer active for the failure chain.
CauseCodeId	Value that identifies the cause code that participates in the failure chain. This is the foreign key to the condition event codes with the type of cause.
CreatedBy	User who created the failure chain extract for the asset.
CreationDate	Date and time when the failure chain extract was created for the asset.
FailureChainId	Value that identifies the failure chain. This is the primary key of the failure chain entity.
FailureCodeId	Value that identifies the failure code that participates in the failure chain. This is the foreign key to condition event codes with the type of failure.
FailureSetId	Value that identifies the failure set for which this chain is established. This is the foreign key to the failure sets entity.
LastUpdateDate	Date and time when the user most recently updated the failure change for the asset record.
LastUpdateLogin	Session login associated with the user who most recently updated the failure chain for the asset record.
LastUpdatedBy	User who most recently updated the failure chain record for the asset.
ObjectVersionNumber	Number of times the failure chain 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.
ResolutionCodeId	Value that identifies the resolution code that participates in the failure chain. This is the foreign key to condition event codes with the type of resolution.