Skip to main content


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

This content has been archived and is no longer being updated.

Links may not function; however, this content may be relevant to outdated versions of the product.

Relationship or spine table included with the Pega Customer Relationship Management suite

Updated on September 10, 2021

In a Pega Customer Relationship Management configuration, a cross-reference table is required to match the keys of a contact or organization entity from multiple systems of record to a master contact or organization entity key.

Pega Customer Service is the system of record for customer data, and Pega Sales Automation is the system of record for customer and prospect data. It is assumed that Pega Sales Automation is the master system of record for customer and prospect data.

To match these entity keys from the two different system of records, two cross-reference tables are available in the product – one for contacts and one for business units.

The Contact relationship table, crm_data_contact_xref, has CRMEntityId and ExternalSystem as columns. CRMEntityId is the master record key based on the assumption that Pega Sales Automation is the master system of record.

Contact relationship table

The following table shows the contact relationship table structure and sample record pattern. The contact relationship table is crm_entity_contact-xref.

CRMEntityID

ExternalID

ExternalSystem

PEGACRM-ENTITY-CONTACT CON-123

CON-890

CS

Organization relationship table

The following table shows the organization relationship table definition and a sample record pattern. The organization relationship table is crm_data_org-xref.

CRMEntityID

ExternalID

ExternalSystem

PEGACRM-ENTITY-ORG ORG-123

ORG-890

CS

Relationship management table mappings

The relationship management tables are mapped to the following data classes:

  • The PegaCRM-Data-EntityxRef-Contact data class is mapped to the crm_entity_contact-xreftable.
  • The PegaCRM-Data-EntityxRef-Org data class is mapped to the crm_entity_org-xref table.

All of the above rules, classes, properties, and data pages are available in the PegaCRMBase application.

  • Previous topic Data model for the Pega Customer Relationship Management suite
  • Next topic Pega Customer Relationship Management integration with Pega Marketing

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