Asset Failure Root Causes
The Asset Failure Root Causes view object contains a record of various root causes. Each row of this object stores information about cause codes, failure instances, and root causes. The combination of these attributes forms the unique identifier of the asset failure root cause.
Data Store Key : FscmTopModelAM.ScmExtractAM.CseBiccExtractAM.CseAssetFailureRootCauseExtractPVO
Primary Keys : RootCauseId
Initial Extract Date : CreationDate
Incremental Extract Date : LastUpdateDate
Attributes
This table provides the list of exposed attributes and their descriptions.
| Name | Description |
|---|---|
| AttributeCategory | Character segment for the Failure Root Cause Analysis descriptive flexfield. |
| AttributeChar1 | Character segment for Failure Root Cause Analysis descriptive flexfield. |
| AttributeChar10 | Character segment for the Failure Root Cause Analysis descriptive flexfield. |
| AttributeChar11 | Character segment of the Failure Root Cause Analysis descriptive flexfield. |
| AttributeChar12 | Character segment for the Failure Root Cause Analysis Descriptive flexfield. |
| AttributeChar13 | Character segment for the Failure Root Cause Analysis descriptive flexfield. |
| AttributeChar14 | Character segment for the Failure Root Cause Analysis descriptive flexfield. |
| AttributeChar15 | Character segment for the Failure Root Cause Analysis descriptive flexfield. |
| AttributeChar16 | Character segment for the Failure Root Cause Analysis descriptive flexfield. |
| AttributeChar17 | Character segment for the Failure Root Cause Analysis descriptive flexfield. |
| AttributeChar18 | Character segment for the Failure Root Cause Analysis descriptive flexfield. |
| AttributeChar19 | Character segment for the Failure Root Cause Analysis descriptive flexfield. |
| AttributeChar2 | Character segment for the Failure Root Cause Analysis descriptive flexfield. |
| AttributeChar20 | Character segment for the Failure Root Cause Analysis descriptive flexfield. |
| AttributeChar3 | Character segment for the Failure Root Cause Analysis descriptive flexfield. |
| AttributeChar4 | Character segment for the Failure Root Cause Analysis descriptive flexfield. |
| AttributeChar5 | Character segment for the Failure Root Cause Analysis descriptive flexfield. |
| AttributeChar6 | Character segment for the Failure Root Cause Analysis descriptive flexfield. |
| AttributeChar7 | Character segment for the Failure Root Cause Analysis descriptive flexfield. |
| AttributeChar8 | Character segment for the Failure Root Cause Analysis descriptive flexfield. |
| AttributeChar9 | Date segment for the Failure Root Cause Analysis descriptive flexfield. |
| AttributeDate1 | Date segment for the Failure Root Cause Analysis descriptive flexfield. |
| AttributeDate2 | Date segment for the Failure Root Cause Analysis descriptive flexfield. |
| AttributeDate3 | Date segment for the Failure Root Cause Analysis descriptive flexfield. |
| AttributeDate4 | Date segment for the Failure Root Cause Analysis descriptive flexfield. |
| AttributeDate5 | Date segment for the Failure Root Cause Analysis descriptive flexfield. |
| AttributeNumber1 | Number segment for the Failure Root Cause Analysis descriptive flexfield. |
| AttributeNumber10 | Number segment for the Failure Root Cause Analysis descriptive flexfield. |
| AttributeNumber2 | Number segment for the Failure Root Cause Analysis descriptive flexfield. |
| AttributeNumber3 | Number segment for the Failure Root Cause Analysis descriptive flexfield. |
| AttributeNumber4 | Number segment for the Failure Root Cause Analysis descriptive flexfield. |
| AttributeNumber5 | Number segment for the Failure Root Cause Analysis descriptive flexfield. |
| AttributeNumber6 | Number segment for the Failure Root Cause Analysis descriptive flexfield. |
| AttributeNumber7 | Number segment for the Failure Root Cause Analysis descriptive flexfield. |
| AttributeNumber8 | Number segment for the Failure Root Cause Analysis descriptive flexfield. |
| AttributeNumber9 | Number segment for the Failure Root Cause Analysis descriptive flexfield. |
| AttributeTimestamp1 | Date and time segment for the Failure Root Cause Analysis descriptive flexfield. |
| AttributeTimestamp2 | Date and time segment for the Failure Root Cause Analysis descriptive flexfield. |
| AttributeTimestamp3 | Date and time segment for the Failure Root Cause Analysis descriptive flexfield. |
| AttributeTimestamp4 | Date and time segment for the Failure Root Cause Analysis descriptive flexfield. |
| AttributeTimestamp5 | Date and time segment for the Failure Root Cause Analysis descriptive flexfield. |
| CauseCodeId | Value that identifies the root causes that are identified for the failure. This is a foreign key to the condition event for codes with a type of cause. |
| Comments | Value that identifies the comments of the root cause analysis step. |
| CreatedBy | User who created the root cause analysis record for the asset. |
| CreationDate | Date and time when the user created the root cause analysis record for the asset. |
| FailureInstanceId | Value that identifies the failure root cause analysis captured in the context of the failure instance. |
| LastUpdateDate | Date and time when the user most recently updated the root cause analysis record. |
| LastUpdateLogin | Session login associated with the user who most recently updated the root cause analysis record. |
| LastUpdatedBy | User who most recently updated the root cause analysis record. |
| ObjectVersionNumber | Number of times the failure root cause 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. |
| RootCauseId | Value that identifies the failure root cause. This is the primary key of the entity. |