Asset Group Members

The Asset Group Members view object contains information about the list of assets assigned to a group.

Data Store Key : FscmTopModelAM.ScmExtractAM.CseBiccExtractAM.GroupRuleMemberExtractPVO

Primary Keys : GroupId, GroupMemberId

Initial Extract Date : CreatedBy

Incremental Extract Date : LastUpdateDate

Attributes

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

Name	Description
ActiveEndDate	Date when the asset membership is retired. This could be done by integrations that move the asset outside of the asset grouping criteria or manually retired also.
AssetId	Value that uniquely identifies the asset number. This is the primary key of the Asset Number business object in the Asset Group Members view object.
CreatedBy	User who created the group rule member record.
CreationDate	Date and time when the user created the group rule member record.
GroupId	Value that identifies the asset group. This is a foreign key to the groups Asset Group view object.
GroupMemberId	Value that identifies the asset group member. This is the primary key of the Asset Group Members view object.
JobDefinitionName	Name of the job that created or most recently updated the row for the group rule member record. This is populated through Enterprise Service Scheduler.
JobDefinitionPackage	Package name of the job that created or most recently updated the row for the group rule member record. This is populated through Enterprise Service Scheduler.
LastUpdateDate	Date and time when the user most recently updated the group rule member record.
LastUpdateLogin	Session login associated with the user who most recently updated the group rule member record.
LastUpdatedBy	User who most recently updated the group rule member record.
ObjectVersionNumber	Number of times the 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.
RequestId	Request identifier of the job that created or most recently updated the row. This is populated through Enterprise Service Scheduler.