Subscription Relationships

The relationships view object stores information about the subscription product relationships, such as the relationship type, source subscription product PUID, and target subscription product PUID.

Data Store Key : CrmAnalyticsAM.CrmExtractAM.OssBiccExtractAM.SubscriptionRelationshipExtractPVO

Primary Keys : OperationId

Initial Extract Date : CreationDate

Incremental Extract Date : LastUpdateDate

Attributes

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

Name	Description
CreatedBy	The user who created this subscription relationship record.
CreationDate	The date on which the subscription relationship record was created.
LastUpdateDate	The date on which the subscription relationship record was last updated.
LastUpdateLogin	The session login of the user who last updated the subscription relationship record.
LastUpdatedBy	The user who last updated the subscription relationship record.
ObjectVersionNumber	The object version number of the subscription relationship record.
OperationCode	The code of the operation that resulted in this relationship record, such as Renew, Amend and so on.
OperationId	The unique identifier of the operation associated with the relation.
OperationLinksPuid	The unique identifier of the relationship record.
RequestId	The unique identifier of the request.
SourceAltSubscriptionId	The alternate source subscription identifier.
SourceAssetKey	The source asset key associated with the relationship.
SourceProdAssociationId	The source covered level identifier associated with the relationship.
SourceProdAssociationPuid	The public unique identifier of the source covered level associated with the relationship.
SourceProductPuid	The public unique identifier of the source product associated with the relationship.
SourceRootAssetKey	The source root asset key.
SourceSubscriptionId	The unique identifier of the source subscription associated with the relationship.
SourceSubscriptionProductId	The unique identifier of the source subscription product associated with the relationship
TargetAltSubscriptionId	The alternate identifier of the target subscription associated with the relationship.
TargetProdAssociationId	The unique identifier of the target product associated with the relationship
TargetProdAssociationPuid	The public unique identifier of the target covered level associated with the relationship.
TargetProductPuid	The public unique identifier of the target product associated with the relationship.
TargetSubscriptionId	The unique identifier of the target subscription associated with the relationship.
TargetSubscriptionProductId	The unique identifier of the target subscription product associated with the relationship.