Asset Failure Symptoms

The Asset Failure Symptoms view object consolidates information that's captured in the diagnostics of the failures. Each row stores the capture object type, object identifier, diagnostic codes, and comments. The combination of these attributes forms the unique identifier of the failure symptoms.

Data Store Key : FscmTopModelAM.ScmExtractAM.CseBiccExtractAM.CseAssetFailureSymptomExtractPVO

Primary Keys : SymptomId

Initial Extract Date : CreationDate

Incremental Extract Date : LastUpdateDate

Attributes

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

Name	Description
CaptureObjectId	Value that identifies the symptom captured in the context of a reference failure object. This is the foreign key reference of what's stored here.
CaptureObjectType	Value that identifies the symptom captured in the context of a reference failure object. The type of symptom reference object is stored here.
Comments	Value that identifies the description of the problem or symptoms.
CreatedBy	User who created the failure symptom for the asset record.
CreationDate	Date and time when the user created the failure symptom for the asset record.
DiagnosticCodeId	Value that identifies the diagnostic code identified for the failure instance. This is the foreign key to condition event codes with the type of diagnostics.
LastUpdateDate	Date and time when the user most recently updated the failure symptom for the asset record.
LastUpdateLogin	Session login associated with the user who most recently updated the failure symptom for the asset record.
LastUpdatedBy	User who most recently updated the failure symptom record for the asset.
ObjectVersionNumber	Number of times the object row for the failure symptom 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.
SymptomId	Value that identifies the failure chain identifier. This is the primary key of the entity.