Pega Customer Decision Hub Interaction History data model
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. | 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 |
Previous topic Reference Next topic Extending Interaction History