Asset Failure Events
The Asset Failure Events view object contains data that's captured for the asset in the context of a maintenance work order.
Data Store Key : FscmTopModelAM.ScmExtractAM.CseBiccExtractAM.CseAssetFailureEventExtractPVO
Primary Keys : FailureEventId
Initial Extract Date : CreationDate
Incremental Extract Date : LastUpdateDate
Attributes
This table provides the list of exposed attributes and their descriptions.
| Name | Description |
|---|---|
| AssetDownFlag | Value that identifies the failure event down identifier for the asset. |
| AssetId | Value that identifies the failure event for the asset. |
| AttributeCategory | Attribute category segment for the Failure Event descriptive flexfield. |
| AttributeChar1 | Character segment for the Failure Event descriptive flexfield. |
| AttributeChar10 | Character segment for the Failure Event descriptive flexfield. |
| AttributeChar11 | Character segment for the Failure Event descriptive flexfield. |
| AttributeChar12 | Character segment for the Failure Event descriptive flexfield. |
| AttributeChar13 | Character segment for the Failure Event descriptive flexfield. |
| AttributeChar14 | Character segment for the Failure Event descriptive flexfield. |
| AttributeChar15 | Character segment for the Failure Event descriptive flexfield. |
| AttributeChar16 | Character segment for the Failure Event descriptive flexfield. |
| AttributeChar17 | Character segment for the Failure Event descriptive flexfield. |
| AttributeChar18 | Character segment for the Failure Event descriptive flexfield. |
| AttributeChar19 | Character segment for the Failure Event descriptive flexfield. |
| AttributeChar2 | Character segment for the Failure Event descriptive flexfield. |
| AttributeChar20 | Character segment for the Failure Event descriptive flexfield. |
| AttributeChar3 | Character segment for the Failure Event descriptive flexfield. |
| AttributeChar4 | Character segment for the Failure Event descriptive flexfield. |
| AttributeChar5 | Character segment for the Failure Event descriptive flexfield. |
| AttributeChar6 | Character segment for the Failure Event descriptive flexfield. |
| AttributeChar7 | Character segment for the Failure Event descriptive flexfield. |
| AttributeChar8 | Character segment for the Failure Event descriptive flexfield. |
| AttributeChar9 | Character segment for the Failure Event descriptive flexfield. |
| AttributeDate1 | Date segment for the Failure Event descriptive flexfield. |
| AttributeDate2 | Date segment for the Failure Event descriptive flexfield. |
| AttributeDate3 | Date segment for the Failure Event descriptive flexfield. |
| AttributeDate4 | Date segment for the Failure Event descriptive flexfield. |
| AttributeDate5 | Date segment for the Failure Event descriptive flexfield. |
| AttributeNumber1 | Number segment for the Failure Event descriptive flexfield. |
| AttributeNumber10 | Number segment for the Failure Event descriptive flexfield. |
| AttributeNumber2 | Number segment for the Failure Event descriptive flexfield. |
| AttributeNumber3 | Number segment for the Failure Event descriptive flexfield. |
| AttributeNumber4 | Number segment for the Failure Event descriptive flexfield. |
| AttributeNumber5 | Number segment for the Failure Event descriptive flexfield. |
| AttributeNumber6 | Number segment for the Failure Event descriptive flexfield. |
| AttributeNumber7 | Number segment for the Failure Event descriptive flexfield. |
| AttributeNumber8 | Number segment for the Failure Event descriptive flexfield. |
| AttributeNumber9 | Number segment for the Failure Event descriptive flexfield. |
| AttributeTimestamp1 | Date and time segment for the Failure Event descriptive flexfield. |
| AttributeTimestamp2 | Date and time segment for the Failure Event descriptive flexfield. |
| AttributeTimestamp3 | Date and time segment for the Failure Event descriptive flexfield. |
| AttributeTimestamp4 | Date and time segment for the Failure Event descriptive flexfield. |
| AttributeTimestamp5 | Date and time segment for the Failure Event descriptive flexfield. |
| AvailableDate | Date and time segment for the Failure Event descriptive flexfield. |
| ConditionalTrackingObjectId | Value that identifies the conditional tracking object identifier for which the failure events are captured on the asset. This conditional tracking object could be either a work order identifier or an asset identifier. |
| CreatedBy | User who created the failure event record for the asset. |
| CreationDate | Date and time when the user created the failure event record for the asset. |
| FailureDate | Date when the failure event was captured for the asset. |
| FailureEventId | Value that identifies the failure event identifier for the asset. |
| FailureFlag | Value that Indicates that the failure event created is truly a failure for the asset. This option is turned off when the event is identified as not a failure. |
| FailureSetId | Value that identifies the failure set used in the failure event capture for the asset. |
| LastUpdateDate | Date and time when the user most recently updated the failure event record. |
| LastUpdateLogin | Session login associated with the user who most recently updated the failure event record. |
| LastUpdatedBy | User who most recently updated the failure event record. |
| ObjectVersionNumber | Number of times the failure event 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. |
| RepairCost | Value that identifies the repair cost captured from the external system for which the failure event is recorded for the asset. |
| SourceDocId | Value that identifies the failure event the source document reference from either a third party external system or from an internal system for the asset. |
| SourceDocTypeCode | Value that identifies the failure event source document type code. This value is captured to identify the type of document in the source document column identifier. |
| SourceSystemId | Value that identifies the identifier of the source system. This value could be from internal application or from external application identifiers. This value is used on the source system as defined in the trading community source systems table. |
| SourceSystemType | Value that identifies the type of source system from which data is being imported. |
| TbfDays | Value that identifies the failure event time between failure in days. This is captured as number of days between the failure events for assets. |
| TbfMeterUnits | Value that identifies the failure event time between failure. This value is captured as number of meter units between the failure events for assets. |
| TbfMeterUnitsUomCode | Value that identifies the units of measure code for the captured meter units between failures for assets. |
| TrackingObjectId | Value that identifies the tracking object key for which the failure events are captured on the asset. This could be the work order identifier or the asset identifier. |
| TrackingObjectType | Value that identifies the object type for which the tracking object key is persisted. The type could be either the work order or asset. |
| WoCompletionDate | Value that identifies the work order completion date for a failure event that's captured from the third-party external system. |