Service Request Aggregations

The service request aggregations view object provides summarized details for service requests.

Data Store Key : CrmAnalyticsAM.ServiceExtractAM.SvcMgmtBiccExtractAM.SrAggregateExtractPVO

Primary Keys : SrAggId

Initial Extract Date : CreationDate

Incremental Extract Date : LastUpdateDate

Attributes

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

Name	Description
AffectedPartyFlag	Indicates if there is an associated service request contact with a relationship type of affected.
ArticleLinkedFlag	Indicates if there is an associated service request reference of type article.
ArticleResolvedFlag	Indicates if there is an associated service request reference of type article that's resolved.
ClosedAgentId	The owner of the last interaction started before the service request was closed. Only interactions that have been end dated are considered.
ClosedChannelId	The channel of the last interaction started before the service request was closed. Only interactions that have been end dated are considered.
ClosedInteractions	The number of interactions started before the service request was closed. Only interactions that have been end dated are considered.
CreatedBy	The user who created the row.
CreationDate	The date and time when the row was created.
InteractionUpdateDate	The date when the related service request interaction content was last updated.
LastStatusTypeCd	The status type code for the service request when this row was last updated.
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.
MilestoneUpdateDate	The date when the related service request milestone content was last updated.
ObjectVersionNumber	The number of times the row has been updated.
ReferenceUpdateDate	The date when the related service request reference content was last updated.
ResolvedAgentId	The owner of the last interaction started before the service request was resolved. Only interactions that have been end dated are considered.
ResolvedChannelId	The channel of the last interaction started before the service request was resolved. Only interactions that have been end dated are considered.
ResolvedInteractions	The number of interactions started before the service request was resolved. Only interactions that have been end dated are considered.
SrAggId	The unique identifier of the record. This is the primary key for the view object.
SrCompliantFlag	Indicates if the service request is fully compliant. All milestones must be compliant for the service request to be fully compliant. Canceled milestones are excluded from consideration.
SrId	The unique identifier of the associated service request.
SrMilestoneAssignmentFlag	Indicates if there is at least one milestone associated with the service request. This doesn't include canceled milestones.
SrUpdateDate	The date when the service request was last updated.
StripeCd	The lookup code that indicates the stripe code, such as CRM, HCM, or PRM.