How Siebel CRM Desktop Uses Natural Keys to Identify Duplicate Activities

Siebel CRM Desktop uses natural keys to detect a duplicate between Microsoft Outlook data and Siebel CRM data. It uses the following natural keys for an activity:

  • Activity Owner and CRMD Integration Id. These items match the GlobalObjectId of a calendar entry.

  • Activity Owner and Description. These items match the subject of the calendar entry and the Start Date.

Siebel CRM Desktop uses these keys to query the Siebel database. This query determines if a duplicate exists for this activity in the Siebel database. The following code is an example of the natural keys that Siebel CRM Desktop might use in the first twenty-two bytes of the PR_CONVERSATION_INDEX email messageconnector_configuration.xml file:

<natural_keys>
 <natural_key>
  <field>CRMD Integration Id</field>
  <field>Primary Owner Id</field>
 </natural_key>
 <natural_key>
  <field>Description</field>
  <field>Planned</field>
  <field>Primary Owner Id</field>
 </natural_key>
</natural_keys>

For more information, see Files That the Customization Package Contains.