Queue Resource Teams

The QueueResourceTeamExtractPVO view object provides details about resources, either individually or as members of a resource team, that are assigned to queues. It expands on the information provided by the Queue Resource view object, identifying individual members of resource teams.

Data Store Key : CrmAnalyticsAM.ServiceExtractAM.SvcMgmtBiccExtractAM.QueueResourceTeamExtractPVO

Primary Keys : BIQueueResourceId

Initial Extract Date : BiCreationDate

Incremental Extract Date : BiLastUpdateDate

Attributes

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

Name	Description
BIQueueResourceId	The unique identifier of the record. This is the primary key for the view object.
BiCreationDate	The date and time when the row was created.
BiDeletedFlag	Flag indicating whether the record has been logically deleted. When the record is logically deleted, it should be removed from any target table it was loaded to before it's physically deleted.
BiLastUpdateDate	The date and time when the row was last updated.
CreatedBy	The user creating the queue resource row.
CreationDate	The date and time of creating the queue resource row.
DeletedFlag	Flag indicating whether the queue resource row is logically deleted or not.
EnabledFlag	Flag indicating whether the resource is enabled for the queue or not.
LastUpdateDate	The date and time of last updating the queue resource row.
LastUpdateLogin	The session login of the user who last updated the queue resource row.
LastUpdatedBy	The user who last updated the queue resource row.
ObjectId	The unique identifier of the resource. This is a foreign key to either the Party view object for an individual resource, or to JTF_RS_TEAMS for a resource team.
ObjectTypeCd	Identifies the type of resource, either an individual resource, or a resource team.
ObjectVersionNumber	The number of times the queue resource row has been updated.
QueueId	The unique identifier of the assigned queue. This is foreign key to the Queue view object.
QueueResourceId	The unique identifier of the queue resource. This is a foreign key to the Queue Resource view object.
QueueRsTeamMemberId	The unique identifier of the queue resource relationship flattened structure and alternate key for this table.
ResourceId	The unique identifier of the resource individual. This is a foreign key to either the Party view object for an individual resource, or to JTF_RS_TEAM_MEMBERS for a member of a resource team.
RsCreatedBy	The user creating the resource team member row.
RsCreationDate	The date and time of creating the resource team member row.
RsDeleteFlag	Flag indicating whether the resource team member row is logically deleted or not.
RsLastUpdateDate	The date and time of last updating the resource team member row.
RsLastUpdateLogin	The session login of the user updating the resource team member row.
RsLastUpdatedBy	The user who last updated the resource team member row.
RsResourceType	Identifies the type of resource team member, either an individual or a group.
RsTeamId	The unique identifier of the resource team. This is a foreign key to JTF_RS_TEAMS.
RsTeamMemberId	The unique identifier of the resource team member. This is a foreign key to JTF_RS_TEAM_MEMBERS.
RsTeamResourceId	The unique identifier of the resource team member resource. This is a foreign key to the Party view object if the resource is an individual, or HR_ALL_ORGANIZATION_UNITS_F if the resource is a group.
UniqueResourceFlag	Flag indicating whether the resource is assigned to a single queue, either individually or as the member of a team.