Skip to main content


         This documentation site is for previous versions. Visit our new documentation site for current releases.      
 

Pega Customer Decision Hub Interaction History data model

Updated on September 15, 2022

Pega Customer Decision Hub stores all customer responses to specific actions in Interaction History database tables. The recorded interactions can then be used to train adaptive models through delayed learning, or to create business intelligence reports.

Important: Dimension records are cached in memory on all nodes. The system writes new dimension records only if the dimension record is not in memory and cannot be read from the database. If you need to truncate any dimension tables, after you do this, clear the cache by performing the following actions:
  1. Go to the Declare_DimensionCacheHashMap data page.
  2. On the Load Management tab, click Clear data page button.
  3. Select the Flush All checkbox and click Submit.
Pega Customer Decision Hub

Properties in the pr_data_ih_dim_application table

The pr_data_ih_dim_application table contains properties that describe the decision path which issued the action. Properties in this table are defined in the Data-Decision-IH-Dimension-Application class.

PropertyData type and lengthDescriptionAssociation
pzIDnumeric (19,0)Unique identifier that is created for each record in the application dimension tablepxApplicationDimension
pxCreateDateTimetimestamp without time zoneTime when the record was createdpxApplicationDimension
pyApplicationcharacter varying (255)The name of the application that is calling Pega Customer Decision HubpxApplicationDimension
pyInteractioncharacter varying (255)Name of the Interaction rule.
Note: Interaction rules are considered deprecated in Pega Customer Decision Hub 8.7
pxApplicationDimension
pyStrategycharacter varying (255)Name of the final strategy that triggered the creation of an interaction recordpxApplicationDimension
pyComponentcharacter varying (255)Name of the final strategy that triggered the creation of an interaction recordpxApplicationDimension
pyApplicationVersioncharacter varying (16)Application versionpxApplicationDimension

Properties in the pr_data_ih_dim_channel table

The pr_data_ih_dim_channel table contains properties that describe the channel of the interaction. Properties in this table are defined in the Data-Decision-IH-Dimension-Channel class.

PropertyData type and lengthDescriptionAssociation
pzIDnumeric (19,0)Unique identifier that is created for each record in the customer dimension tablepxChannelDimension
pxCreateDateTimetimestamp without time zoneTime when the record was created in the dimension tablepxChannelDimension
pyDirectioncharacter varying (255)Direction of the interaction (inbound or outbound)pxChannelDimension
pyChannelcharacter varying (255)Name of interaction channelpxChannelDimension
pyTreatmentcharacter varying (255)Name of treatment used in the interactionpxChannelDimension
DeviceTypecharacter varying (255)Type of the device used in the interactionpxChannelDimension
URIcharacter varying (255)The URI used in the interactionpxChannelDimension
UserAgentcharacter varying (255)Property to hold UserAgent (for example: browser, client) informationpxChannelDimension
ChannelGroupcharacter varying (255)A subdivision of the pychannelpxChannelDimension
ChannelSubGroupcharacter varying (255)A subdivision of the channel grouppxChannelDimension

Properties in the pr_data_ih_dim_context table

The pr_data_ih_dim_context table contains properties that describe the decision context of the interaction, that is, the level of customer contact for which the interaction was recorded. Properties in this table are defined in the Data-Decision-IH-Dimension-Context class.

PropertyData type and lengthDescriptionAssociation
pzIDnumeric (19,0)Unique Identifier that is created for each record in the context dimension tablepxContextDimension
pxCreateDateTimetimestamp without time zoneTime when the record was created in the dimension tablepxContextDimension
pyCategorycharacter varying (255)pxContextDimension
pyReasoncharacter varying (255)pxContextDimension
ControlGroupValidityStarttimestamp without time zoneStart date time for a control group validity periodpxContextDimension
ControlGroupValidityEndtimestamp without time zoneEnd date time for the control group validity periodpxContextDimension
MktTypecharacter varying (255)Context typepxContextDimension
MktValuecharacter varying (255)Value associated with the context typepxContextDimension
WorkIDcharacter varying (128)pxContextDimension

Properties in the pr_data_ih_dim_customer table

The pr_data_ih_dim_customer table contains properties that describe the customer for whom the interaction was recorded. Properties in this table are defined in the Data-Decision-IH-Dimension-Customer class.

PropertyData type and lengthDescriptionAssociation
pzIDnumeric (19,0)Unique Identifier that is created for each record in the customer dimension tablepxCustomerDimension
pxCreateDateTimetimestamp without time zoneTime when the record was created in the dimension tablepxCustomerDimension
pySubjectTypecharacter varying (255)Class value of the subjectpxCustomerDimension
pyCustomerSegmentcharacter varying (255)The segment to which the customer belongs pxCustomerDimension
pyCustomerSubSegmentcharacter varying (255)Subdivision of pyCustomerSegmentpxCustomerDimension
ModelControlGroupcharacter varying (255)Property holding the control group information for a customer in a given outcome optimization pathpxCustomerDimension

Properties in the pr_data_ih_dim_journey table

The pr_data_ih_dim_journey table contains properties that describe the customer journey. Properties in this table are defined in the Data-Decision-IH-Dimension-Journey class.

PropertyData type and lengthDescriptionAssociation
pxCreateDateTimetimestamp without time zoneTime when the record was created in the dimension tablepxJourneyDimension
pzIDnumeric (19,0)Unique identifier that is created for each record in the journey dimension tablepxJourneyDimension
pyJourneycharacter varying (255)Name of the customer journeypxJourneyDimension
pyStepcharacter varying (255)Step of the customer journey where the interaction was recordedpxJourneyDimension
pyStagecharacter varying (255)Stage of the customer journey where the interaction was recorded pxJourneyDimension

Properties in the pr_data_ih_dim_location table

The pr_data_ih_dim_location table contains properties that describe the location of the customer when the interaction took place. Properties in this table are defined in the Data-Decision-IH-Dimension-Location class.

PropertyData type and lengthDescriptionAssociation
pzIDnumeric (19,0)Unique identifier that is created for each record in the location dimension tablepxLocationDimension
pxCreateDateTimetimestamp without time zoneTime when the record was created in the dimension tablepxLocationDimension

Properties in the pr_data_ih_dim_operator table

The pr_data_ih_dim_operator table contains properties that describe the operator linked to the interaction. Properties in this table are defined in the Data-Decision-IH-Dimension-Operator class.

PropertyData type and lengthDescriptionAssociation
pzIDnumeric (19,0)Unique Identifier that is created for each record in the operator dimension tablepxOperatorDimension
pxCreateDateTimetimestamp without time zoneTime when the record was created in the dimension tablepxOperatorDimension
pyOrganizationcharacter varying (255)Organization name of the operatorpxOperatorDimension
pyDivisioncharacter varying (255)Division name of the operatorpxOperatorDimension
pyUnitcharacter varying (255)Unit name of the operatorpxOperatorDimension
pyOperatorcharacter varying (255)Operator IDpxOperatorDimension

Properties in the pr_data_ih_dim_outcome table

The pr_data_ih_dim_outcome table contains properties that describe the outcome of the interaction. Properties in this table are defined in the Data-Decision-IH-Dimension-Outcome class.

PropertyData type and lengthDescriptionAssociation
pzIDnumeric (19,0)Unique Identifier that is created for each record in the outcome dimension tablepxOutcomeDimension
pxCreateDateTimetimestamp without time zoneTime when the record was created in the dimension tablepxOutcomeDimension
pyOutcomecharacter varying (255)Deprecated in Pega Customer Decision HubpxOutcomeDimension
pyResponsecharacter varying (255)Response (for example: Accepted, Rejected)pxOutcomeDimension
pyBehaviourcharacter varying (255)Behavior associated with the response (positive, negative, neutral)pxOutcomeDimension

Properties in the pr_data_ih_fact table

The pr_data_ih_fact table contains additional properties that describe the interaction. Properties in this table are defined in the Data-Decision-IH-Fact class.

PropertyData type and lengthDescriptionAssociation
pxFactIDnumeric (19,0)Unique identifier created for each record inserted into the fact tablenone
pySubjectIDcharacter varying (255)Unique identifier for the subject that the decisioning was made for (for example: CustomerID or Account ID, depending on the context of the decision)none
pxOutcomeTimetimestamp without time zoneTimestamp corresponding to when the record was stored in the interaction history tablesnone
pzActionIDnumeric (19,0)Identifier used for joining the action dimensionnone
pzApplicationIDnumeric (19,0)Identifier used for joining the application dimensionnone
pzChannelIDnumeric (19,0)Identifier used for joining the channel dimensionnone
pzContextIDnumeric (19,0)Identifier used for joining the context dimensionnone
pzCustomerIDnumeric (19,0)Identifier used for joining the customer dimensionnone
pzLocationIDnumeric (19,0)Identifier used for joining the location dimensionnone
pzOperatorIDnumeric (19,0)Identifier used for joining the operator dimensionnone
pzOutcomeIDnumeric (19,0)Identifier used for joining the outcome dimensionnone
pyGroupIDcharacter varying (255)In a multi-level configuration, this is the name of the parent context.none
pxDecisionTimetimestamp without time zoneTime stamp corresponding to when the decision was issuednone
pyExternalIDcharacter varying (255)none
pyLatitudenumeric (19,9)Latitudenone
pyLongitudenumeric (19,9)Longitudenone
pxPrioritynumeric (19,9)Priority assigned to the actionnone
pyPropensitynumeric (19,9)Calculated propensity for the actionnone
pxInteractionIDnumeric (19,0)Unique 64-bit identifier for all records that belong to the same interactionnone
pxRanknumeric (18,0)Rank of the actionnone
pyAssociatedID
pyAssociationStrength
pyPartitionKeyintegerPartition key assigned to the factnone
pzJourneyIDnumeric (19,0)Identifier used for joining the journey dimensionnone
pyMaxBudgetnumeric (19,4)Maximum budget assigned to action (used for negotiation)none
pyTargetBudgetnumeric (19,4)Target budget assigned to action (used for negotiation)none
pyWeightnumeric (19,4)Value to increase or decrease propensitynone
pyisfactidnumeric (19,0)none
IPAddresscharacter varying (255)IP addressnone
Revenuenumeric (19,4)Revenue associated with the actionnone
Costnumeric (19,4)Cost associated with the actionnone
Utm_mediumcharacter varying (255)The type of link which was usednone
ReferrerUrlcharacter varying (1024)

The HTTP referrer of the requested website

none
ExternalAudienceIdcharacter varying (255)Paid Media Manager uses this property to associate ads on platforms other than Google Ads and Facebook Ads to specific audiences in Pega Customer Decision Hubnone
FinalPropensity

Properties in the pr_data_ih_association table

The pr_data_ih_association table contains properties that describe the associated data for the interaction. Properties in this table are defined in the Data-Decision-IH-Association class.

PropertyData type and lengthDescriptionAssociation
pySubjectIDcharacter varying (255)Identifier of the subject of the decision (customer or account)none
pyAssociatedIDcharacter varying (255)none
pxCreateDateTimetimestamp without time zoneTimestamp of record creation in the tablenone
pyAssociationStrengthnumeric (19,9)none

Properties in the pr_data_ih_dim_action table

The pr_data_ih_dim_action table contains properties that describe the action associated with the interaction. Properties in this table are defined in the Data-Decision-IH-Dimension-Action class.

PropertyData type and lengthDescriptionAssociation
pzIDnumeric (19,0)Unique Identifier that is created for each record in the association dimension tablepxActionDimension
pxCreateDateTimetimestamp without time zoneTime the record was created in the dimension tablepxActionDimension
ActionContext
pyIssuecharacter varying (255)Issue the action belongs to.pxActionDimension
pyGroupcharacter varying (255)Group the action belongs topxActionDimension
pyNamecharacter varying (255)Action identifierpxActionDimension
pyLabelcharacter varying (255)Action name or labelpxActionDimension
BundleNamecharacter varying (255)Bundle name of the actionpxActionDimension
BundleHeadcharacter varying (8)Bundle head of the actionpxActionDimension
EvaluationCriteria
  • Extending Interaction History

    Learn about the underlying configuration of Interaction History and how to extend it to match your business objectives.

Have a question? Get answers now.

Visit the Support Center to ask questions, engage in discussions, share ideas, and help others.

Did you find this content helpful?

Want to help us improve this content?

We'd prefer it if you saw us at our best.

Pega.com is not optimized for Internet Explorer. For the optimal experience, please use:

Close Deprecation Notice
Contact us