LinkedIn
Copied!

Table of Contents

Pega Customer Decision Hub Interaction History data model

Version:

Only available versions of this content are shown in the dropdown

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.

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.

Property Data type and length Description Association
pzid numeric (19,0) Unique identifier that is created for each record in the application dimension table pxApplicationDimension
pxcreatedatetime timestamp without time zone Time when the record was created pxApplicationDimension
pyapplication character varying (255) The name of the application that is calling Pega Customer Decision Hub pxApplicationDimension
pyinteraction character varying (255) Name of the Interaction rule.
Interaction rules are considered deprecated in Pega Customer Decision Hub 8.5
pxApplicationDimension
pystrategy character varying (255) Name of the final strategy that triggered the creation of an interaction record pxApplicationDimension
pycomponent character varying (255) Name of the final strategy that triggered the creation of an interaction record pxApplicationDimension
pyapplicationversion character varying (16) Application version pxApplicationDimension

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.

Property Data type and length Description Association
pzid numeric (19,0) Unique identifier that is created for each record in the customer dimension table pxChannelDimension
pxcreatedatetime timestamp without time zone Time when the record was created in the dimension table pxChannelDimension
pydirection character varying (255) Direction of the interaction (inbound or outbound) pxChannelDimension
pychannel character varying (255) Name of interaction channel pxChannelDimension
pytreatment character varying (255) Name of treatment used in the interaction pxChannelDimension
devicetype character varying (255) Type of the device used in the interaction pxChannelDimension
uri character varying (255) The URI used in the interaction pxChannelDimension
useragent character varying (255) Property to hold UserAgent (for example: browser, client) information pxChannelDimension
channelgroup character varying (255) A subdivision of the pychannel pxChannelDimension
channelsubgroup character varying (255) A subdivision of the channel group pxChannelDimension

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.

Property Data type and length Description Association
pzid numeric (19,0) Unique Identifier that is created for each record in the context dimension table pxContextDimension
pxcreatedatetime timestamp without time zone Time when the record was created in the dimension table pxContextDimension
pycategory character varying (255) pxContextDimension
pyreason character varying (255) pxContextDimension
pydisplaycategory character varying (255) pxContextDimension
pytoprank character varying (255) pxContextDimension
controlgroupvaliditystart timestamp without time zone Start date time for a control group validity period pxContextDimension
controlgroupvalidityend timestamp without time zone End date time for the control group validity period pxContextDimension
mkttype character varying (255) Context type pxContextDimension
mktvalue character varying (255) Value associated with the context type pxContextDimension
pycontext character varying (255) pxContextDimension
pycallmode character varying (255) pxContextDimension
cgvaliditystart timestamp without time zone Start date time for the control group validity period pxContextDimension
cgvalidityend timestamp without time zone End date time for the control group validity period pxContextDimension
workid character 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.

Property Data type and length Description Association
pzid numeric (19,0) Unique Identifier that is created for each record in the customer dimension table pxCustomerDimension
pxcreatedatetime timestamp without time zone Time when the record was created in the dimension table pxCustomerDimension
pysubjecttype character varying (255) Class value of the subject pxCustomerDimension
pycustomersegment character varying (255) The segment to which the customer belongs pxCustomerDimension
pycustomersubsegment character varying (255) Subdivision of pyCustomerSegment pxCustomerDimension
pygrouptype character varying (255) pxCustomerDimension
modelcontrolgroup character varying (255) Property holding the control group information for a customer in a given outcome optimization path pxCustomerDimension

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.

Property Data type and length Description Association
pxcreatedatetime timestamp without time zone Time when the record was created in the dimension table pxJourneyDimension
pzid numeric (19,0) Unique identifier that is created for each record in the journey dimension table pxJourneyDimension
pyjourney character varying (255) Name of the customer journey pxJourneyDimension
pystep character varying (255) Step of the customer journey where the interaction was recorded pxJourneyDimension
pystage character 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.

Property Data type and length Description Association
pzid numeric (19,0) Unique identifier that is created for each record in the location dimension table pxLocationDimension
pxcreatedatetime timestamp without time zone Time when the record was created in the dimension table pxLocationDimension

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.

Property Data type and length Description Association
pzid numeric (19,0) Unique Identifier that is created for each record in the operator dimension table pxOperatorDimension
pxcreatedatetime timestamp without time zone Time when the record was created in the dimension table pxOperatorDimension
pyorganization character varying (255) Organization name of the operator pxOperatorDimension
pydivision character varying (255) Division name of the operator pxOperatorDimension
pyunit character varying (255) Unit name of the operator pxOperatorDimension
pyoperator character varying (255) Operator ID pxOperatorDimension

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.

Property Data type and length Description Association
pzid numeric (19,0) Unique Identifier that is created for each record in the outcome dimension table pxOutcomeDimension
pxcreatedatetime timestamp without time zone Time when the record was created in the dimension table pxOutcomeDimension
pyoutcome character varying (255) Deprecated in Pega Customer Decision Hub pxOutcomeDimension
pyResponse character varying (255) Response (for example: Accepted, Rejected) pxOutcomeDimension
pybehaviour character 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.

Property Data type and length Description Association
pxfactid numeric (19,0) Unique identifier created for each record inserted into the fact table none
pysubjectid character 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
pxoutcometime timestamp without time zone Timestamp corresponding to when the record was stored in the interaction history tables none
pzactionid numeric (19,0) Identifier used for joining the action dimension none
pzapplicationid numeric (19,0) Identifier used for joining the application dimension none
pzchannelid numeric (19,0) Identifier used for joining the channel dimension none
pzcontextid numeric (19,0) Identifier used for joining the context dimension none
pzcustomerid numeric (19,0) Identifier used for joining the customer dimension none
pzlocationid numeric (19,0) Identifier used for joining the location dimension none
pzoperatorid numeric (19,0) Identifier used for joining the operator dimension none
pzoutcomeid numeric (19,0) Identifier used for joining the outcome dimension none
pygroupid character varying (255) In a multi-level configuration, this is the name of the parent context. none
<context key> character varying (255) For multilevel configurations, on save of context dictionary, properties are added to the table that correspond to each context.
pxdecisiontime timestamp without time zone Time stamp corresponding to when the decision was issued none
pyexternalid character varying (255) none
pylatitude numeric (19,9) Latitude none
pylongitude numeric (19,9) Longitude none
pxpriority numeric (19,9) Priority assigned to the action none
pypropensity numeric (19,9) Calculated propensity for the action none
pxinteractionid numeric (19,0) Unique 64-bit identifier for all records that belong to the same interaction none
pxrank numeric (18,0) Rank of the action none
pypartitionkey integer Partition key assigned to the fact none
pzjourneyid numeric (19,0) Identifier used for joining the journey dimension none
pyrevenue numeric (19,4) none
pymaxbudget numeric (19,4) Maximum budget assigned to action (used for negotiation) none
pytargetbudget numeric (19,4) Target budget assigned to action (used for negotiation) none
pyfulfilled numeric (19,4) none
pyweight numeric (19,4) Value to increase or decrease propensity none
pyisfactid numeric (19,0) none
pxdecisionreference character varying (255) none
pyreason character varying (255) none
ipaddress character varying (255) IP address none
revenue numeric (19,4) Revenue associated with the action none
cost numeric (19,4) Cost associated with the action none
urlid numeric (19,0) none
utm_medium character varying (255) The type of link which was used none
referrerurl character varying (1024)

The HTTP referrer of the requested website

none
externalaudienceid character 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 Hub none

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.

Property Data type and length Description Association
pysubjectid character varying (255) Identifier of the subject of the decision (customer or account) none
pyassociatedid character varying (255) none
pxcreatedatetime timestamp without time zone Timestamp of record creation in the table none
pyassociationstrength numeric (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.

Property Data type and length Description Association
pzid numeric (19,0) Unique Identifier that is created for each record in the association dimension table pxActionDimension
pxcreatedatetime timestamp without time zone Time the record was created in the dimension table pxActionDimension
pyissue character varying (255) Issue the action belongs to. pxActionDimension
pygroup character varying (255) Group the action belongs to pxActionDimension
pyname character varying (255) Action identifier pxActionDimension
pylabel character varying (255) Action name or label pxActionDimension
bundlename character varying (255) Bundle name of the action pxActionDimension
bundlehead character varying (8) Bundle head of the action pxActionDimension
Did you find this content helpful?

Have a question? Get answers now.

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