Action Plan Action Owners

The ActionPlanActionOwnerExtractPVO view object provides details about owners of the actions of an action plan. Depending on the source object associated with the action, the owner will either be a Service Request assignee or an Activity owner.

Data Store Key : CrmAnalyticsAM.ServiceExtractAM.SvcMgmtBiccExtractAM.ActionPlanActionOwnerExtractPVO

Primary Keys : BIActionPlanActionId

Initial Extract Date : CreationDate

Incremental Extract Date : LastUpdateDate

Attributes

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

Name	Description
ActionObjectDeletedFlag	Flag indicating whether the source owner record has been soft deleted. It should be noted that only Service Requests are soft deleted.
ActionObjectEntityName	The entity type of the object on which the action is based.
ActionOwnerId	The unique identifier for the source owner, either the Service Request assignee or the Activity owner.
ActionOwnerUpdateDate	The date of last updating the source owner record.
ActionPlanActionId	The unique identifier of the action plan action. This is a foreign key to the Action Plan Action view object.
BIActionPlanActionId	The unique identifier of the record. This is the primary key for the view object.
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.
CreatedBy	The user who created the row.
CreationDate	The date and time when the row was created.
LastUpdateDate	The date and time when the row was last updated.
LastUpdateLogin	The session login of the user who last updated the row.
LastUpdatedBy	The user who last updated the row.
ObjectVersionNumber	The number of times the row has been updated.