Skip to main content
LinkedIn
Copied!

Table of Contents

Negotiation outcomes data model

Pega Customer Decision Hub stores all properties related to negotiation outcomes in PegaDATA database tables. The recorded outcomes and associated Interaction History records can then be used to create business intelligence reports.

Properties in the pegadata.cdh_data_negotiation_outcome table

The pegadata.cdh_data_negotiation_outcome table contains basic properties that describe the negotiation outcome.

Property Data type and length Description
agent_id character varying (32) The identifier of the agent who conducted the negotiation
agent_interaction_id character varying (255) A unique identifier associated with the negotiation interaction.
This property is used as the primary key to join the negotiation outcome with the related Interaction History record
budget_used numeric (18,3) The budget that the agent used to acquire or retain the customer
commisions numeric (18,3) The commission that the agent accrued
context_name character varying (16) The context, or level of customer contact for multilevel decisioning. This property can represent, for example, an account, a household, or a policy membership
customer_id character varying (32) The customer identifier
discount_amount numeric (18,3) The amount of recurring discount offered
maximum_budget numeric (18,3) The maximum budget allowed by Pega Customer Decision Hub at the time when the negotiation interaction ends
minimum_budget numeric (18,3) The minimum budget allowed by Pega Customer Decision Hub
monthly_recurring_cost numeric (18,3) The recurring monthly cost of the offers for the customer
monthly_recurring_discount numeric (18,3) The recurring monthly discount of the offers for the customer
one_off_cost numeric (18,3) The one-time cost of the offers for the customer
one_off_discount numeric (18,3) The one-time discount of the offers for the customer
outcome character varying (16) The outcome of the negotiation interaction
response_time timestamp Time when the outcome was recorded
target_budget numeric (18,3) The target budget allowed by Pega Customer Decision Hub

Properties in the pegadata.cdh_negotiation_ih_join table

The pegadata.cdh_negotiation_ih_join table contains the properties that join the pegadata.cdh_data_negotiation_outcome table to the pr_data_ih_fact Interaction History table.

Property Data type and length Description
agent_interaction_id character varying (255) A unique identifier associated with the negotiation interaction.
This property is used as the primary key for the pegadata.cdh_data_negotiation_outcome table.
pxinteractionid numeric (19,0) Unique 64-bit identifier for all records that belong to the same interaction.
This property is used as the primary key for the pr_data_ih_fact table.
For more information about the pr_data_ih_fact database table and other Interaction History tables, see Pega Customer Decision Hub Interaction History data model.
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.

Ready to crush complexity?

Experience the benefits of Pega Community when you log in.

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

Pega Community has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice
Contact us