Account Object Data Modeling Requirements

Map the following fields during data modeling to prepare data about your accounts for the identity resolution process.

Required Mappings and Relationships

Required relationships for Contact Point Email, Contact Point Phone, Contact Point Address, and Party Identifier objects are always Many:1 relationships in the data model because many contact points can belong to one account.

Required relationships for the Account object are always 1:Many relationships in the data model because one account can have multiple contact points.

Object Name Object API Name Field Labels Field API Names Required Mapping
Account ssot__Account__dlm
  1. Account Id (primary key)
  2. Account Name
  1. ssot__Id__c
  2. ssot__Name__c
  1. Account.ID → ContactPointAddress.Party
  2. Account.ID → ContactPointApp.Party
  3. Account.ID → ContactPointEmail.Party
  4. Account.ID → ContactPointPhone.Party
  5. Account.ID → PartyIdentificationId.Party
Contact Point Address ssot__ContactPointAddress__dlm
  1. Contact Point Address Id (primary key)
  2. Address Line 1
  3. City
  4. Party
  5. Postal Code
  6. State Province
  1. ssot__Id__c
  2. ssot__AddressLine1__c
  3. ssot__CityId__c
  4. ssot__PartyId__c
  5. ssot__PostalCodeId__c
  6. ssot__StateProvinceId__c
ContactPointAddress.Party → Account.ID
Contact Point App ssot__ContactPointApp__dlm
  1. Contact Point App Id (primary key)
  1. ssot__Id__c
ContactPointApp.Party → Account.ID
Contact Point Email ssot__ContactPointEmail__dlm
  1. Contact Point Email Id (primary key)
  2. Party
  3. Email Address
  1. ssot__Id__c
  2. ssot__PartyId__c
  3. ssot__EmailAddress__c
ContactPointEmail.Party → Account.ID
Contact Point Phone ssot__ContactPointPhone__dlm
  1. Contact Point Phone Id (primary key)
  2. Formatted E164 Phone Number
  3. Party
  1. ssot__Id__c
  2. ssot__FormattedE164PhoneNumber__c
  3. ssot__PartyId__c
ContactPointPhone.Party → Account.ID
Party Identification ssot__PartyIdentification__dlm
  1. Party Identification Id (primary key)
  2. Identification Name
  3. Identification Number
  4. Party
  5. Party Identification Type
  1. ssot__Id__c
  2. ssot__Name__c
  3. ssot__IdentificationNumber__c
  4. ssot__PartyId__c
  5. ssot__PartyIdentificationTypeId__c
PartyIdentificationId.Party → Account.ID