Relationship or spine table included with the Pega Customer Relationship Management suite
In a Pega Customer Relationship Management configuration, a cross-reference table is required to match the contact entity keys from multiple systems of record to a master contact entity key.
Pega Customer Service for Communications is the system of record for customer data, and Pega Sales Automation is the system of record for customer, lead, opportunity, 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 systems of records, a cross-reference table for contact is available.
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_data_contact_xref.
| CRMEntityID | ExternalID | ExternalSystem |
|---|---|---|
| PEGACRM-ENTITY-CONTACT CON-20511 | C1000001 | CSC |
| PEGACRM-ENTITY-CONTACT CON-20510 | C1000002 | CSC |
Relationship management table mappings
The relationship management table, crm_data_contact_xref, is mapped to the PegaCRM-Data-EntityxRef-Contact data class.
All of the above rules, classes, properties, and data pages are available in the PegaCRMBase application.