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.
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.
| 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. |
| 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. |
| pxinteractionid | numeric (19,0) | Unique 64-bit identifier for all records that belong to the same interaction. |
Previous topic CaptureNegotiationOutcome REST service Next topic Best practices for recording data to facilitate reporting in Agent-Assisted