Relationship or spine table included with the Pega Customer Relationship Management for Healthcare suite
A cross-reference spine table is available for you to match the common data types that exist in both the applications. For example, the Pega® Customer Service for Healthcare application contains customer data and the same customer data is also available in the form of customer, lead, opportunity, or prospect in Pega Sales Automation for Healthcare. You must specify the matching IDs from both systems of record to identify the matching data and display the same data to the end user.
Contact relationship table
The crm_entity_contact-xref table shows the contact relationship table structure and sample record pattern.
| CRMEntityID | ExternalID | ExternalSystem |
|---|---|---|
| PEGACRM-ENTITY-CONTACT CON-1001 | MB201507248 | CSHC |
| PEGACRM-ENTITY-CONTACT CON-1002 | MB201507249 | CSHC |
| PEGACRM-ENTITY-CONTACT CON-1003 | MB201608261512 | CSHC |
| PEGACRM-ENTITY-CONTACT CON-1004 | MB201608261513 | CSHC |
| PEGACRM-ENTITY-CONTACT CON-1005 | CONT-31241 | CSHC |
| PEGACRM-ENTITY-CONTACT CON-1006 | CONT-31228 | CSHC |
| PEGACRM-ENTITY-CONTACT CON-1007 | CONT-31239 | CSHC |
| PEGACRM-ENTITY-CONTACT CON-1008 | CONT-31198 | CSHC |
Relationship management table mappings
The PegaCRM-Data-EntityxRef-Contact data class is mapped to the crm_data_contact_xref table. All of the above rules, classes, and properties are available in the PegaCRMBase application.
Previous topic Sample components included with the Pega Customer Relationship Management for Healthcare suite Next topic Data model for the Pega Customer Relationship Management for Healthcare suite