Asset Failure Set Associations

The Asset Failure Set Associations view object contains information about the failure set. Each row of this object stores information about the failure set, the default option, and the set associations. The combination of these attributes forms the unique identifier of the asset failure set association.

Data Store Key : FscmTopModelAM.ScmExtractAM.CseBiccExtractAM.CseAssetFailureSetAssociationExtractPVO

Primary Keys : SetAssociationId

Initial Extract Date : CreationDate

Incremental Extract Date : LastUpdateDate

Attributes

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

Name	Description
ActiveEndDate	End date of the failure set association.
CaptureRequiredFlag	Value that indicates whether capturing failure data is mandatory. This is enforced at work order completion.
CreatedBy	User who created the failure set association for the asset record.
CreationDate	Date and time when the user created the failure set associated for the asset record.
DefaultFlag	Value that identifies if the failure set will apply to any asset for which no other failure set specifically applies.
FailureSetId	Value that identifies the failure set that's associated to either the item, asset, or item category. This is the foreign key to the Failure Sets entity.
LastUpdateDate	Date and time when the user most recently updated the failure set association for the asset record.
LastUpdateLogin	Session login associated with the user who most recently updated the failure set association for asset record.
LastUpdatedBy	User who most recently updated the failure set association for the asset record.
ObjectId	Value that identifies the object primary key when the object type is specified. This object is defined as applicable for the failure set.
ObjectTypeCode	Value that identifies the type of object key that's referenced in this for applicability. It could be either item, asset, or item category. Valid values are drawn from a system lookup.
ObjectVersionNumber	Number of times the object row for the asset failure set 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.
SetAssociationId	Value that identifies the failure set association identifier. This is the primary key of the entity.