Asset Failure Instances
The Asset Failure Instances view object contains information about multiple failures codes, causes, and resolutions. Each row stores information about the failed asset, item, or serial number. Otherwise, they contain information about failure codes, events, comments, options, and instances. The combination of these attributes forms the unique identifier of the asset failure instance.
Data Store Key : FscmTopModelAM.ScmExtractAM.CseBiccExtractAM.CseAssetFailureInstanceExtractPVO
Primary Keys : FailureInstanceId
Initial Extract Date : CreationDate
Incremental Extract Date : LastUpdateDate
Attributes
This table provides the list of exposed attributes and their descriptions.
| Name | Description |
|---|---|
| AttributeCategory | Context name for the Failure Instance descriptive flexfield. |
| AttributeChar1 | Character segment for the Failure Instance descriptive flexfield. |
| AttributeChar10 | Character segment for the Failure Instance descriptive flexfield. |
| AttributeChar11 | Character segment for the Failure Instance descriptive flexfield. |
| AttributeChar12 | Character segment for the Failure Instance descriptive flexfield. |
| AttributeChar13 | Character segment for the Failure Instance descriptive flexfield. |
| AttributeChar14 | Character segment for the Failure Instance descriptive flexfield. |
| AttributeChar15 | Character segment for the Failure Instance descriptive flexfield. |
| AttributeChar16 | Character segment for the Failure Instance descriptive flexfield. |
| AttributeChar17 | Character segment for the Failure Instance descriptive flexfield. |
| AttributeChar18 | Character segment for the Failure Instance descriptive flexfield. |
| AttributeChar19 | Character segment for the Failure Instance descriptive flexfield. |
| AttributeChar2 | Character segment for the Failure Instance descriptive flexfield. |
| AttributeChar20 | Character segment for the Failure Instance descriptive flexfield. |
| AttributeChar3 | Character segment for the Failure Instance descriptive flexfield. |
| AttributeChar4 | Character segment for the Failure Instance descriptive flexfield. |
| AttributeChar5 | Character segment for the Failure Instance descriptive flexfield. |
| AttributeChar6 | Character segment for the Failure Instance descriptive flexfield. |
| AttributeChar7 | Character segment for the Failure Instance descriptive flexfield. |
| AttributeChar8 | Character segment for the Failure Instance descriptive flexfield. |
| AttributeChar9 | Character segment for the Failure Instance descriptive flexfield. |
| AttributeDate1 | Date segment for the Failure Instance descriptive flexfield. |
| AttributeDate2 | Date segment for the Failure Instance descriptive flexfield. |
| AttributeDate3 | Date segment for the Failure Instance descriptive flexfield. |
| AttributeDate4 | Date segment for the Failure Instance descriptive flexfield. |
| AttributeDate5 | Date segment for the Failure Instance descriptive flexfield. |
| AttributeNumber1 | Number segment for the Failure Instance descriptive flexfield. |
| AttributeNumber10 | Number segment for the Failure Instance descriptive flexfield. |
| AttributeNumber2 | Number segment for the Failure Instance descriptive flexfield. |
| AttributeNumber3 | Number segment for the Failure Instance descriptive flexfield. |
| AttributeNumber4 | Number segment for the Failure Instance descriptive flexfield. |
| AttributeNumber5 | Number segment for the Failure Instance descriptive flexfield. |
| AttributeNumber6 | Number segment for the Failure Instance descriptive flexfield. |
| AttributeNumber7 | Number segment for the Failure Instance descriptive flexfield. |
| AttributeNumber8 | Number segment for the Failure Instance descriptive flexfield. |
| AttributeNumber9 | Number segment for the Failure Instance descriptive flexfield. |
| AttributeTimestamp1 | Date and time segment for the Failure Instance descriptive flexfield. |
| AttributeTimestamp2 | Date and time segment for the Failure Instance descriptive flexfield. |
| AttributeTimestamp3 | Date and time segment for the Failure Instance descriptive flexfield. |
| AttributeTimestamp4 | Date and time segment for the Failure Instance descriptive flexfield. |
| AttributeTimestamp5 | Date and time segment for the Failure Instance descriptive flexfield. |
| CauseCodeId | Value that identifies the cause code that's identified for this failure. This is a foreign key to condition event codes with a type of cause. |
| CreatedBy | User who created the failure instance record. |
| CreationDate | Date and time when the user created the failure instance record. |
| FailedAssetId | Value that identifies the asset reference of the failed item. |
| FailedItemId | Value that identifies the component item that's involved in the failure. |
| FailedSerialNumber | Value that identifies the asset serial number of the component item that's involved in the failure. |
| FailureCodeId | Value that identifies the failure code that caused this failure event. This is a foreign key to the condition event for codes with a type of failure. |
| FailureComments | Value that identifies the descriptive information about the failure, symptoms, cause, or resolution. |
| FailureEventId | Value that identifies the failure event reference. Multiple causes and resolutions can be recorded for the event. |
| FailureFlag | Value that indicates if the failure instance created is truly a failure. When the instance is identified as not a failure, this option is turned off. |
| FailureInstanceId | Value that identifies the failure instance identifier. This is the primary key of the entity. |
| LastUpdateDate | Date and time when the user most recently updated the failure instance record. |
| LastUpdateLogin | Session login associated with the user who most recently updated the failure instance record |
| LastUpdatedBy | User who most recently updated the failure instance record. |
| ObjectVersionNumber | Number of times the failure instance 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 to this failure cause. This is a foreign key to the condition event for codes with a type of resolution. |
| SeverityCode | Value that identifies the perceived risk or impact of the failure. This value populates from an extensible lookup. |
| StatusCode | Value that identifies the lifecycle of the failure. For example, Analysis Required, Analysis in Progress, Analysis Completed, Analysis Not Required, or Unassessed. This attribute isn't visible on the Failure Tracking page, but is used later as part of the Root Cause Analysis process. This value populates from an extensible lookup. |