Skip to main content


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

Negotiation outcomes data model

Updated on August 4, 2022

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.

Pega Customer Decision Hub

Properties in the pegadata.cdh_data_negotiation_outcome table

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

PropertyData type and lengthDescription
agent_idcharacter varying (32)The identifier of the agent who conducted the negotiation
agent_interaction_idcharacter varying (255)A unique identifier associated with the negotiation interaction.
Note: This property is used as the primary key to join the negotiation outcome with the related Interaction History record
budget_usednumeric (18,3)The budget that the agent used to acquire or retain the customer
commisionsnumeric (18,3)The commission that the agent accrued
context_namecharacter 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_idcharacter varying (32)The customer identifier
discount_amountnumeric (18,3)The amount of recurring discount offered
maximum_budgetnumeric (18,3)The maximum budget allowed by Pega Customer Decision Hub at the time when the negotiation interaction ends
minimum_budgetnumeric (18,3)The minimum budget allowed by Pega Customer Decision Hub
monthly_recurring_costnumeric (18,3)The recurring monthly cost of the offers for the customer
monthly_recurring_discountnumeric (18,3)The recurring monthly discount of the offers for the customer
one_off_costnumeric (18,3)The one-time cost of the offers for the customer
one_off_discountnumeric (18,3)The one-time discount of the offers for the customer
outcomecharacter varying (16)The outcome of the negotiation interaction
response_timetimestampTime when the outcome was recorded
target_budgetnumeric (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.

PropertyData type and lengthDescription
agent_interaction_idcharacter varying (255)A unique identifier associated with the negotiation interaction.
Note: This property is used as the primary key for the pegadata.cdh_data_negotiation_outcome table.
pxinteractionidnumeric (19,0)Unique 64-bit identifier for all records that belong to the same interaction.
Note: This property is used as the primary key for the pr_data_ih_fact table.
Note: 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.

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