Understanding your Salesforce Schema

This tutorial is about getting familiar with the default Salesforce schema found in Stitch and understanding the context of these fields to effectively use Salesforce for your data analytics. A schema is a collection of objects within a database, typically consisting of tables (defined below) and the relationships between those tables.

Note: – The primary key in every table is denoted by 🔑

Account Table Schema

The account table contains information about individual accounts (persons and organizations) associated with your business.

Attribute

Description

🔑idThe account ID.
systemModStampThe time when a user or automated process last modified the account.
accountNumberThe account number assigned to this account.
accountSourceThe source of the account record. For example: Website – Paid Search
annualRevenueThe estimated annual revenue of the account.
billingAddressThe compound form of the account’s billing address. Only available if using the REST API.

If using the Bulk API, track the following fields to replicate the same data:

  • billingStreet
  • billingCity
  • billingState
  • billingStateCode
  • billingCountry
  • billingCountryCode
  • billingPostalCode
  • billingLatitude
  • billingLongitude
  • billingGeocodeAccuracy
billingStreetThe street address for the account’s billing address.
billingCityThe account’s billing city.
billingStateThe state of the account’s billing address.
billingStateCodeThe ISO state code for the account’s billing address.
billingCountryThe account’s billing country.
billingCountryCodeThe ISO country code for the account’s billing address.
billingPostalCodeThe postal code for the account’s billing address.
billingLatitudeUsed with billingLongitude to specify the precise geolocation of a billing address.
billingLongitudeUsed with billingLatitude to specify the precise geolocation of a billing address.
billingGeocodeAccuracyThe compound form of the accuracy level of the geocode for the account’s billing address.
cleanStatusThe account’s clean status as compared with Data.com.

Possible values are:

  • Matched
  • Different
  • Acknowledged
  • NotFound
  • Inactive
  • Pending
  • SelectMatch
  • Skipped
connectionReceivedIdThe ID of the PartnerNetworkConnection that shared the account record with your organization.

Only available if Salesforce to Salesforce is enabled.

descriptionThe description of the account
dunsNumberThe Data Universal Numbering System (DUNS) number associated with the account.

Only available if using Data.com Prospector or Data.com Clean.

faxThe fax number associated with the account.
industryThe industry associated with the account.
isCustomerPortalIndicates whether the account has at least one contact enabled to use the organization’s Customer Portal. This field will be true if at least one contact is enabled to use the portal.

Only available if Customer Portal or Communities is enabled and there are Customer Portal licenses.

isDeletedIndicates if the account has been moved to the Recycle Bin (true) or (false).
isPartnerIndicates whether the account has at least one contact enabled to use the organization’s Partner Portal (true) or not (false).

Only available if Partner Portal or Communities is enabled and there are Partner Portal licenses.

isPersonAccountIndicates if the account has a record type of Person Account (true) or not (false).
jigsawThe account’s ID from Data.com. If an account has a value in this field, it means that the account was imported from Data.com.
lastActivityDateThe due date of the most recently logged event OR the most recently closed task associated with the account, whichever is more recent.
lastReferenceDateThe date a record associated with the account was last viewed.
lastViewedDateThe date the account was last viewed.
masterRecordIdIf the account was deleted as the result of a merge, this field will contain the ID of the record that was kept.

If this account was deleted for any other reason (or hasn’t been deleted), the value will be NULL.

naicsCodeThe North American Industry Classification System (NAICS) code associated with the account.

Only available if using Data.com Prospector or Data.com Clean.

naicsDescriptionThe description associated with the account’s NAICS code.

Only available if using Data.com Prospector or Data.com Clean.

nameThe name of the account.

If the account’s record type is PersonAccount, the value of this field will be a concatenation of the firstName, middleName, lastName, and suffix fields of the associated person contact.

Only available if using the REST API.

numberOfEmployeesThe number of employees working at the company represented by the account.
operatingHoursIdThe operating hours associated with the account.

Only available in Field Service Lightning is enabled.

ownerIdThe ID of the user who currently owns the account.
ownershipThe ownership type for the account. For example: Private
parentIdThe ID of the account’s parent object, if applicable.
phoneThe phone number associated with the account.
photoUrlThe path to be combined with the URL of a Salesforce instance to generate a URL to request the social network profile image associated with the account.

This field will be blank if Social Accounts and Contacts aren’t enabled for the organization or requesting user.

ratingThe account’s prospect rating. For example: cold
recordTypeIdThe ID of the record type assigned to the account.
salutationThe honorific added to the name for use in letters, etc.
shippingAddressThe compound form of the account’s shipping address. Only available if using the REST API.

If using the Bulk API, track the following fields to replicate the same data:

  • shippingStreet
  • shippingCity
  • shippingStae
  • shippingStateCode
  • shippingCountry
  • shippingCountryCode
  • shippingPostalCode
  • shippingLatitude
  • shippingLongitude
  • shippingGeocodeAccuracy
shippingStreetThe street address for the account’s shipping address
shippingCityThe account’s shipping city.
shippingStateThe state for the account’s shipping address.
shippingStateCodeThe ISO state code for the account’s shipping address.
shippingCountryThe account’s shipping country.
shippingCountryCodeThe ISO country code for the account’s shipping address.
shippingPostalCodeThe postal code for the account’s shipping address.
shippingLatitudeUsed with shippingLongitude to specify the precise geolocation of a shipping address.
shippingLongitudeUsed with shippingLatitude to specify the precise geolocation of a shipping address.
shippingGeocodeAccuracyThe compound form of the accuracy level of the geocode for the account’s shipping address.
sicThe Standard Industrial Classification code of the company’s main business organization.
sicDescThe description associated with the account’s SIC code.
siteThe name of the account’s location. For example: California or Main Office.
tickerSymbolThe stock market symbol associated with the account.
tradeStyleSimilar to doing business as, this is the name (different from its legal name), that the organization may use for conducting business.

Only available if using Data.com Prospector or Data.com Clean.

typeThe type of the account. For example: Partner
websiteThe website associated with the account.
yearStartedThe date when the account (organization) was legally established.

Only available if using Data.com Prospector or Data.com Clean.

Contact Table Schema

The contact table contains information about your contacts who are individuals associated with accounts in your Salesforce.

AttributeDescription
🔑idThe contact ID.
systemModStampThe time when a user or automated process last modified the contact.
accountIdThe ID of the account that is the parent of the contact.
assistantNameThe name of the assistant.
assistantPhoneThe phone number associated with the contact.
birthdateThe birthdate of the contact.
canAllowPortalSelfRegIndicates if the contact can self-register for your organization’s Customer Portal (true) or not (false).
cleanStatusThe account’s clean status as compared with Data.com.

Possible values are:

  • Matched
  • Different
  • Acknowledged
  • NotFound
  • Inactive
  • Pending
  • SelectMatch
  • Skipped
connectionReceivedIdThe ID of the PartnerNetworkConnection that shared the contact record with your organization.

Only available if Salesforce to Salesforce is enabled.

connectionSentIdThe ID of the PartnerNetworkConnection that you shared the contact record with.

Deprecated by Salesforce.

departmentThe department of the contact.
descriptionThe description of the contact.
doNotCallIndicates if the contact does not want to be called (true).
emailThe email address associated with the contact.
emailBouncedDateIf bounce management is activated and an email sent to the contact bounces, the date and time the bounce occurred.
emailBouncedReasonIf bounce management is activated and an email sent to the contact bounces, the reason the bounce occurred.
faxThe fax number associated with the contact.
firstNameThe first name of the contact.
hasOptedOutOfEmail Indicates if the contact would prefer not to receive email from Salesforce (true) or not (false).
hasOptedOutOfFaxIndicates if the contact would prefer not to receive faxes (true) or not (false).
homePhoneThe home phone number associated with the contact.
isDeletedIndicates if the contact has been moved to the Recycle Bin (true) or not (false).
isEmailBouncedIf bounce management is activated and an email is sent to a contact, indicates if the email bounced (true) or not (false).
isPersonAccountIndicates if the contact has a record type of Person Account (true) or not (false).
jigsawThe contact’s ID from Data.com. If a contact has a value in this field, it means that the contact was imported from Data.com.
lastActivityDateThe due date of the most recently logged event OR the most recently closed task associated with the contact, whichever is more recent.
lastNameThe last name of the contact.
lastReferenceDateThe date a record associated with the contact was last viewed.
lastViewedDate The date the contact was last viewed.
leadSourceThe source of the lead.
mailingAddressThe compound form of the contact’s mailing address. Only available if using the REST API.

If using the Bulk API, track the following fields to replicate the same data:

  • mailingStreet
  • mailingCity
  • mailingState
  • mailingStateCode
  • mailingCountry
  • mailingCountryCode
  • mailingPostalCode
  • mailingLatitude
  • mailingLongitude
  • mailingGeocodeAccuracy
mailingStreetThe street address for the contact’s mailing address.
mailingCityThe contact’s mailing city.
mailingStateThe state for the contact’s mailing address.
mailingStateCodeThe ISO state code for the contact’s mailing address.
mailingCountryThe contact’s mailing country.
mailingCountryCodeThe ISO country code for the contact’s mailing address.
mailingPostalCodeThe postal code for the contact’s mailing address.
mailingLatitudeUsed with mailingLongitude to specify the precise geolocation of a mailing address.
mailingLongitudeUsed with mailingLatitude to specify the precise geolocation of a mailing address.
mailingGeocodeAccuracyThe compound form of the accuracy level of the geocode for the contact’s mailing address.
masterRecordIdIf the contact was deleted as the result of a merge, this field will contain the ID of the record that was kept.

If this contact was deleted for any other reason (or hasn’t been deleted), the value will be NULL.

middleNameThe middle name of the contact.
mobilePhoneThe mobile phone number associated with the contact.
nameThe concatenation of firstName, middleName, lastName, and suffix. Only available if using the REST API.

If using the Bulk API, track the following fields to replicate the same data:

  • firstName
  • middleName
  • lastName
  • suffix
otherAddress The compound form of the contact’s alternate address. Only available if using the REST API.

If using the Bulk API, track the following fields to replicate the same data:

  • otherStreet
  • otherCity
  • otherState
  • otherStateCode
  • otherCountry
  • otherCountryCode
  • otherPostalCode
  • otherLatitude
  • otherLongitude
  • otherGeocodeAccuracy
otherStreetThe street address for the contact’s alternate address.
otherCityThe contact’s alternate city.
otherStateThe state for the contact’s alternate address.
otherStateCodeThe ISO state code for the contact’s alternate address.
otherCountryThe contact’s alternate country.
otherCountryCodeThe ISO country code for the contact’s alternate address.
otherPostalCodeThe postal code for the contact’s alternate address.
otherLatitudeUsed with otherLongitude to specify the precise geolocation of the contact’s alternate address.
otherLongitudeUsed with otherLatitude to specify the precise geolocation of the contact’s alternate address.
otherGeocodeAccuracyThe compound form of the accuracy level of the geocode for the contact’s alternate address.
otherPhoneThe phone number associated with the contact’s alternate address.
ownerIdThe ID of the owner of the account associated with the contact.
phoneThe phone number associated with the contact.
photoUrlThe path to be combined with the URL of a Salesforce instance to generate a URL to request the social network profile image associated with the contact.

This field will be blank if Social Accounts and Contacts aren’t enabled for the organization or requesting user.

recordTypeIdThe ID of the record type assigned to the contact.
reportsToIdIf isPersonAccount is true, this field will be NULL.
salutationThe honorific added to the contact’s name for use in letters, etc.
suffixThe name suffix of the contact.
titleThe title of the contact. For example: CMO, Director of Product, etc.

Lead Table Schema

The lead table contains information about your leads who are prospects or potential opportunities.

AttributeDescription
🔑idThe lead ID.
systemModStampThe time when a user or automated process last modified the lead.
address The compound form of the lead’s address. Only available if using the REST API.

If using the Bulk API, track the following fields to replicate the same data:

  • street
  • city
  • state
  • stateCode
  • country
  • countryCode
  • postalCode
  • latitude
  • longitude
  • geocodeAccuracy
annualRevenueThe estimated annual revenue for the lead’s company.
cityThe city for the address of the lead.
cleanStatus The lead’s clean status as compared with Data.com. Possible values are:
  • Matched
  • Different
  • Acknowledged
  • NotFound
  • Inactive
  • Pending
  • SelectMatch
  • Skipped
companyThe company associated with the lead.
companyDunsNumberThe Data Universal Numbering System (DUNS) number associated with the lead’s company.

Only available if using Data.com Prospector or Data.com Clean.

connectionReceivedIdThe ID of the PartnerNetworkConnection that shared the lead record with your organization.

Only available if Salesforce to Salesforce is enabled.

convertedAccountIdThe reference ID that points to the Account into which the lead has been converted.
convertedContactIdThe reference ID that points to the Contact into which the lead has been converted.
convertedDateThe date on which the lead was converted.
convertedOpportunityIdThe reference ID that points to the Opportunity into which the lead has been converted.
countryThe country for the address of the lead.
countryCodeThe ISO country code for the lead’s address.
currencyIsoCodeThe ISO code for any currency allowed by the organization.

Only available for organizations with the multicurrency feature enabled.

descriptionThe description of the lead.
divisionThe logical segment of your organization’s data. For example: Asia, Consulting, Marketing.

Only available if the organization has the Division permission enabled.

emailThe email address associated with the lead.
emailBouncedDateIf bounce management is activated and an email sent to the lead bounces, the date and time the bounce occurred.
emailBouncedReasonIf bounce management is activated and an email sent to the lead bounces, the reason the bounce occurred.
faxThe fax number associated with the lead.
firstNameThe first name of the lead.
hasOptedOutOfEmailIndicates if the lead would prefer not to receive email from Salesforce (true) or not (false).
geocodeAccuracyThe compound form of the accuracy level of the geocode for the lead’s address.
industryThe industry the lead works in.
isConvertedIndicates if the lead has been converted (true) or not (false).
isDeletedIndicates if the lead has been moved to the Recycle Bin (true) or not (false).
isUnreadByOwnerIf true, the lead has been assigned but not yet viewed.
jigsawThe lead’s ID from Data.com. If a lead has a value in this field, it means that the contact was imported from Data.com.
lastActivityDateThe due date of the most recently logged event OR the most recently closed task associated with the lead, whichever is more recent.
lastNameThe last name of the lead.
lastReferenceDateThe date a record associated with the lead was last viewed.
lastViewedDateThe date the lead was last viewed.
latitudeUsed with longitude to specify the precise geolocation of an address.
longitudeUsed with latitude to specify the precise geolocation of an address.
leadSourceThe source from which the lead was obtained.
masterRecordIdIf the lead was deleted as the result of a merge, this field will contain the ID of the record that was kept.

If this lead was deleted for any other reason (or hasn’t been deleted), the value will be NULL.

middleNameThe middle name of the lead.
mobilePhoneThe mobile phone number associated with the lead.
nameThe concatenation of firstName, middleName, lastName, and suffix. Only available if using the REST API.

If using the Bulk API, track the following fields to replicate the same data:

  • firstName
  • middleName
  • lastName
  • suffix
numberOfEmployeesThe number of employees at the lead’s company.
ownerIdThe ID of the owner of the lead.
partnerAccountIdThe ID of the partner account for the partner that owns the lead.

Only available if Partner Relationship Management is enabled or Communities is enabled and you have partner licenses.

phoneThe phone number associated with the lead.
photoUrlThe path to be combined with the URL of a Salesforce instance to generate a URL to request the social network profile image associated with the lead.

This field will be blank if Social Accounts and Contacts aren’t enabled for the organization or requesting user.

PostalCodeThe postal code for the lead’s address.
ratingThe rating of the lead.
recordTypeIdThe ID of the record type assigned to the lead.
salutationThe salutation of the lead.
scoreIntelligenceIdThe ID of the intelligent field record that contains the lead score.
stateThe state for the lead’s address.
stateCodeThe ISO state code for the lead’s address.
statusThe status code of the converted lead.
streetThe street address for the lead’s address.
suffixThe name suffix of the lead.
titleThe title of the lead. For example: CFO, VP of Sales, etc.
websiteThe website for the lead.

Opportunity Table Schema

The opportunity table contains information about your opportunities which are pending deals or sales.

AttributeDescription
🔑idThe opportunity ID.
systemModStampThe time when a user or automated process last modified the opportunity.
accountIdThe ID of the account associated with the opportunity.
amountThe estimated total sale amount. For opportunities with products, the amount will be the total sum of the related products.
campaignIdThe ID of a related campaign.

Only defined for organizations where the campaign feature is enabled.

closeDateThe date the opportunity is expected to close.
connectionReceivedIdThe ID of the PartnerNetworkConnection that shared the opportunity record with your organization.

Only available if Salesforce to Salesforce is enabled.

connectionSentIdThe ID of the PartnerNetworkConnection that you shared the opportunity record with.

Deprecated by Salesforce.

currencyIsoCodeThe ISO code for any currency allowed by the organization.

Only available for organizations with the multicurrency feature enabled.

descriptionThe description of the opportunity.
expectedRevenueAmount equal to the product of the opportunity amount field and the probability.
fiscalThe name of the fiscal quarter or period in which the opportunity closeDate falls. Applicable if fiscal years are not enabled.
fiscalQuarterThe numerical representation of the fiscal quarter. Possible values are 1, 2, 3, or 4.
fiscalYearThe fiscal year.
forecastCategory The forecast category for the opportunity.
forecastCategoryNameThe name of the forecast category for the opportunity.
hasOpenActivityIndicates if the opportunity has associated line items (true) or not (false).
hasOpportunityLineItem Indicates if the opportunity has an open event (true) or not (false). Opportunities can have opportunity line items only if the opportunity has a price book.
hasOverdueTaskIndicates if an opportunity has an overdue task (true) or not (false).
isClosedIndicates if the opportunity is closed (true) or not (false).
isDeletedIndicates if the opportunity has been moved to the Recycle Bin (true) or not (false).
isExcludedFromTerritory2FilterIndicates if the opportunity is excluded (true) or included (false) each time the APEX filter is executed.
isSplitIndicates whether credit for the opportunity is split between team members (true) or not (false).
isWonIndicates if the opportunity is won (true) or not (false).
lastActivityDateThe due date of the most recently logged event OR the most recently closed task associated with the opportunity, whichever is more recent.
lastReferenceDateThe date a record associated with the opportunity was last viewed.
lastViewedDateThe date the opportunity was last viewed.
leadSourceThe source from which the opportunity was obtained. For example: Advertisement, Trade Show
nameThe name of the opportunity.
nextStepThe description of the next task in closing the opportunity.
ownerIdThe ID of the user who has been assigned to work the opportunity.
pricebook2IdThe ID of the related Pricebook2 object.

Only available if the products feature is enabled for an organization.

pricebookIdThe ID of the related Pricebook object.

Deprecated by Salesforce.

probabilityThe percentage of estimated confidence in closing the opportunity.
recordTypeIdThe ID of the record type assigned to the opportunity.
stageNameThe current stage of the opportunity.
syncedQuoteIdThe ID of the quote that syncs with the opportunity.
territory2IdThe ID of the territory assigned to the opportunity.

Only available if Enterprise Territory Management is enabled.

totalOpportunityQuantityThe number of items included in the opportunity.
typeThe type of opportunity. For example: New Business

User Table Schema

The user table contains information about the users in your organization.

AttributeDescription
🔑idThe user ID.
systemModStampThe time when a user or automated process last modified the user.
aboutMeInformation about the user, such as areas of interest or skills.
accountIdThe ID of the account associated with a Customer Portal user. This field will be NULL for Salesforce users.
addressThe compound form of the lead’s address. Only available if using the REST API.

If using the Bulk API, track the following fields to replicate the same data:

  • street
  • city
  • state
  • stateCode
  • country
  • countryCode
  • postalCode
  • latitude
  • longitude
  • geocodeAccuracy
aliasThe user’s alias.
badgeTextThe text description of a user badge that appears over the user’s photo.
bannerPhotoUrlThe URL for the user’s banner photo.
callCenterIdThe call center to which the user is assigned.

Only available if Salesforce CRM Call Center is enabled.

cityThe city associated with the user.
communityNicknameThe name used to identify this user in the Community application, which includes the ideas and answers features.
companyNameThe name of the user’s company.
contactIdThe ID of the contact associated with the account.
countryThe country associated with the user.
countryCodeThe ISO country code associated with the user.
defaultCurrencyIsoCodeThe user’s default currency setting for new records.
defaultDivisionThe user’s default division.

Only applicable if divisions are enabled.

defaultGroupNotificationFrequencyThe default frequency for sending the user’s Chatter group email notifications when the user joins groups. Possible values are:
  • P – Email on every post
  • D – Daily digests
  • W – Weekly digests
  • N – Never
delegatedApproverIdThe ID of the user who is a delegated approver for the user.
departmentThe company department associated with the user.
digestFrequencyThe frequency at which the system sends the user’s Chatter personal digest. Possible values are:
  • D – Daily
  • W – Weekly
  • N – Never
divisionThe division associated with the user. This is similar to department and unrelated to defaultDivision.
emailThe email address associated with the user.
emailEncodingKeyThe email encoding for the user, such as ISO-8859- or UTF-8.
emailPreferencesAutoBccIndicates if the user receives copies of sent emails (true) or not (false).

Only applicable if compliance BCC emails aren’t enabled.

employeeNumberThe user’s employee number.
extensionThe user’s phone extension number.
faxThe fax number associated with the user.
federationIdentifierThe value that must be listed in the Subject element of a Security Assertion Markup Language (SAML) IDP certificate to authenticate the user for a client application using single-on.
firstNameThe user’s first name.
forecastEnabledIndicates if the user is enabled as a Forecast Manager (true) or not (false) in customizable forecasting.
fullPhotoUrlThe URL for the user’s current profile photo.
isActiveIndicates if the user has access to log in (true) or not (false).
isPortalEnabledIndicates if the user has access to Communities or portals (true) or not (false).
isPortalSelfRegisteredIndicates if the user is a Customer Portal user who self-registered for your organization’s Customer Portal (true) or not (false).
isPrmSuperUserIndicates if the user has super user access in the partner portal (true) or (false).

This field must be enabled by Salesforce.

isProfilePhotoActiveIndicates if the user has a profile photo (true) or not (false).
jigsawImportLimitOverrideThe Data.com user’s monthly addition limit.
languageLocaleKeyThe user’s language. For example: English or French
lastLoginDateThe date and time when the user last successfully logged in.
lastNameThe user’s last name.
lastReferenceDateThe date a record associated with the lead was last viewed.
lastViewedDateThe date the lead was last viewed.
latitudeUsed with longitude to specify the precise geolocation of an address.
longitudeUsed with latitude to specify the precise geolocation of an address.
managerThe user’s manager.
managerIdThe ID of the user who manages the user.
mediumBannerPhotoUrlThe URL for the user’s medium-sized user profile banner photo.
middleNameThe user’s middle name.

This field must be enabled by Salesforce.

mobilePhoneThe mobile phone number associated with the user.
nameThe concatenation of firstName and lastName. Only available if using the REST API.

If using the Bulk API, track the firstName and lastName fields to replicate the same data.

offlineTrialExpirationDateThe date and time when the user’s Connect Offline trial expires.
phoneThe phone number associated with the user.
portalRoleThe role of the user in the Customer Portal. Possible values are:
  • Executive
  • Manager
  • User
  • PersonAccount

Only available if Customer Portal is enabled or Communities is enabled and there are available partner portal, Customer Portal, or High-Volume Portal User licenses.

postalCodeThe user’s postal or ZIP code.
profileIdThe ID of the user’s profile.
receivesAdminInfoEmailsIndicates if the user receives email for administrators from Salesforce (true) or not (false).
receivesInfoEmailsIndicates if the user receives informational email from Salesforce (true) or not (false).
senderEmailThe From email address when the user sends email.
senderNameThe name used as the email sender when the user sends emails.
signatureThe signature text added to emails.
smallBannerPhotoUrlThe URL for the user’s small user profile banner photo.
smallPhotoUrlThe URL for the thumbnail of the user’s current profile photo.
stateThe state associated with the user.
stateCodeThe ISO state code of the state associated with the user.
streetThe street address for the lead’s address.
suffixThe name suffix of the lead.
titleThe business title of the user. For example: CEO, Director of Product, etc.
usernameThe name the user enters to log into the API or user interface.
userPermissionsCallCenterAutoLoginIndicates if the user is enabled to use the auto login feature of the call center (true) or not (false).

Only applicable if Salesforce CRM Call Center is enabled.

userPermissionsChatterAnswersUserIndicates if the portal user is enabled to use the Chatter Answers feature (true) or not (false).
userPermissionsInteractionUserIndicates if the user can run flows (true) or not (false).
userPermissionsJigsawProspectingUserIndicates if the user is allocated one Data.com user license (true) or not (false).
userPermissionsKnowledgeUserIndicates if the user is enabled to use Salesforce Knowledge (true) or not (false).
userPermissionsLiveAgentUserIndicates if the user is enabled to use Live Agent (true) or not (false).
userPermissionsMarketingUserIndicates if the user is enabled to manage campaigns in the user interface (true) or not (false).
userPermissionsMobileUserIndicates if the user is allocated one Salesforce Mobile Classic license (true) or not (false).
userPermissionsOfflineUserIndicates if the user is enabled to use Offline Edition (true) or not (false).
userPermissionsSFContentUserIndicates if the user is allocated one Salesforce CRM Content User license (true) or not (false).
userPermissionsSiteforceContributorUserIndicates if the user is allocated one Site.com Contributor feature license (true) or not (false).
userPermissionsSiteforcePublisherUserIndicates if the user is allocated one Site.com Publisher feature license (true) or not (false).
userPermissionsSupportUserIndicates if the user is enabled to use the Salesforce console (true) or not (false).
userPermissionsWorkDotComUserFeatureIndicates if the Work.com feature is enabled for the user (true) or not (false).
userPreferencesAcitivityRemindersPopupWhen true, a reminder popup window will automatically open when an activity reminder is due for the user.
userPreferencesApexPagesDeveloperModeWhen true, indicates the user has enabled developer mode for editing Visualforce pages and controllers.
userPreferencesContentEmailAsAndWhenWhen false, a user with Salesforce CRM Content subscriptions receives a once daily email summary if activity occurs on their subscribed content, libraries, tags, or authors.
userPreferencesContentNoEmailWhen false, a user with Salesforce CRM Content subscriptions receives email notifications if activity occurs on their subscribed content, libraries, tags, or authors.
userPreferencesEnableAutoSubForFeedsWhen true, the user automatically subscribes to feeds for any objects that the user creates.
userPreferencesDisableAllFeedsEmailWhen false, the user automatically receives email for all updates to Chatter feeds, based on the types of feed emails and digests the user has enabled.
userPreferencesDisableBookmarkEmailWhen false, the user automatically receives email every time someone comments on a Chatter feed item after the user bookmarks it.
userPreferencesDisableChangeCommentEmailWhen false, the user automatically receives email every time someone comments on a change the user has made. For example: an update to their profile.
userPreferencesDisableEndorsementEmailWhen false, the user automatically receives email every time someone endorses them for a topic.
userPreferencesDisableFileShareNotificationsForApiWhen false, email notifications are sent from the person who has shared a file to the users with whom the file has been shared.
userPreferencesDisableFollowersEmailWhen false, the user will automatically receive an email every time someone starts following the user in Chatter.
userPreferencesDisableLaterCommentEmailWhen false, the user automatically receives an email every time someone comments on a feed item after the user has commented on a feed item.
userPreferencesDisableLikeEmailWhen false, the user automatically receives email every time someone likes a post or comment the user made.
userPreferencesDisableMentionsPostEmailWhen false, the user automatically receives email every time the user is mentioned in posts.
userPreferencesDisableMentionsPostEmailWhen false, the user automatically receives email every time the user is mentioned in a post.
userPreferencesDisableProfilePostEmailWhen false, the user automatically receives email every time someone posts to the user’s profile.
userPreferencesDisableSharePostEmailWhen false, the user automatically receives email every time the user’s post is shared.
userPreferencesDisableFeedbackEmailWhen false, the user automatically receives email related to Work.com feedback.
userPreferencesDisCommentAfterLikeEmailWhen false, the user automatically receives email every time someone comments on a post the user has liked.
userPreferencesDisMentionsCommentEmailWhen false, the user automatically receives email every time the user is mentioned in a comment.
userPreferencesDisableMessageEmailWhen false, the user automatically receives email for Chatter messages sent to the user.
userPreferencesDisableRewardEmailWhen false, the user automatically receives email related to Work.com rewards.
userPreferencesDisableWorkEmailWhen false, the user automatically receives emails related to Work.com feedback, goals, and coaching.
userPreferencesDisProfPostCommentEmailWhen false, the user automatically receives email every time someone comments on posts on the user’s profile.
userPreferencesEventRemindersCheckboxDefaultWhen true, a reminder popup is automatically set on the user’s events.
userPreferencesHideBiggerPhotoCalloutWhen true, users can choose to hide the callout text below the large profile photo.
userPreferencesHideChatterOnboardingSplashWhen true, the initial Chatter onboarding prompts won’t appear for the user.
userPreferencesHideCSNDesktopTaskWhen true, the Chatter recommendations panel never displays the recommendation to install Chatter Desktop for the user.
userPreferencesHideCSNGetChatterMobileTaskWhen true, the Chatter recommendations panel never displays the recommendation to install Chatter Mobile for the user.
userPreferencesHideHideSecondChatterOnboardingSplashWhen true, the secondary Chatter onboarding prompts won’t appear for the user.
userPreferencesHideS1BrowserUIWhen true, the user will see the full Salesforce site. If false, the user will be automatically redirected to the Salesforce mobile web.
userPreferencesHideSfxWelcomeMatIndicates if the user sees the Lightning Experience new user message (true) or not (false).
userPreferencesJigsawListUserWhen true, the user is a Data.com List user and shares record additions from a pool.
userPreferencesLightningExperiencePreferredWhen true, the user will be redirected to the Lighting Experience Interface.
userPreferencesPathAssistantCollapsedWhen true, Sales Path appears collapsed or hidden to the user.
userPreferencesReminderSoundOffWhen true, a sound automatically plays when an activity reminder is due for the user.
userPreferencesShowCityToExternalUsersWhen true, the city in the user’s contact info will be visible to external users.
userPreferencesShowCityToGuestUsersWhen true, the city in the user’s contact info will be visible to guest users.
userPreferencesShowCountryToExternalUsersWhen true, the country in the user’s contact info will be visible to external users.
userPreferencesShowCountryToGuestUsersWhen true, the country in the user’s contact info will be visible to guest users.
userPreferencesShowEmailToExternalUsersWhen true, the email address in the user’s contact info will be visible to external users.
userPreferencesShowEmailToGuestUsersWhen true, the email address in the user’s contact info will be visible to guest users.
userPreferencesShowFaxToExternalUsersWhen true, the fax number in the user’s contact info will be visible to external users.
userPreferencesShowFaxToGuestUsersWhen true, the fax number in the user’s contact info will be visible to guest users.
userPreferencesShowManagerToExternalUsersWhen true, the user’s manager in the user’s contact info will be visible to external users.
userPreferencesShowManagerToGuestUsersWhen true, the user’s manager in the user’s contact info will be visible to guest users.
userPreferencesShowMobilePhoneToExternalUsersWhen true, the mobile phone number in the user’s contact info will be visible to external users.
userPreferencesShowMobilePhoneToGuestUsersWhen true, the mobile phone number in the user’s contact info will be visible to guest users.
userPreferencesShowPostalCodeToExternalUsersWhen true, the postal code in the user’s contact info will be visible to external users.
userPreferencesShowPostalCodeToGuestUsersWhen true, the postal code in the user’s contact info will be visible to guest users.
userPreferencesShowProfilePicToExternalUsersWhen true, the user’s profile photo will be visible to external users.
userPreferencesShowProfilePicToGuestUsersWhen true, the user’s profile photo will be visible to guest users.
userPreferencesShowStateToExternalUsersWhen true, the state in the user’s contact info will be visible to external users.
userPreferencesShowStateToGuestUsersWhen true, the state in the user’s contact info will be visible to guest users.
userPreferencesShowStreetAddressToExternalUsersWhen true, the street address in the user’s contact info will be visible to external users.
userPreferencesShowStreetAddressToGuestUsersWhen true, the street address in the user’s contact info will be visible to guest users.
userPreferencesShowTitleToExternalUsersWhen true, the business title in the user’s contact info will be visible to external users.
userPreferencesShowTitleToGuestUsersWhen true, the business title in the user’s contact info will be visible to guest users.
userPreferencesShowWorkPhoneToExternalUsersWhen true, the work phone number in the user’s contact info will be visible to external users.
userPreferencesShowWorkPhoneToGuestUsersWhen true, the work phone number in the user’s contact info will be visible to guest users.
userPreferencesSortFeedByCommentWhen true, the user’s feed is sorted by most recent comment activity. If false, the feed is sorted by post date.
userPreferencesTaskRemindersCheckboxDefaultWhen true, a reminder popup is automatically set on the user’s tasks.
userRoleIdThe ID of the user role assigned to the user.
userTypeThe category of the user license allocated to the user. Possible values include:
  • Standard
  • PowerPartner
  • CSPLitePortal
  • CustomerSuccess
  • PowerCustomerSuccess
  • CsnOnly

Foreign Key Joints

A foreign key is a column in a table that establishes an association with another table via shared values. To accomplish this, a foreign key is populated with values of the primary key from the other table. Foreign keys are also typically titled IDs, but prepended with the name of the referenced table. Below are some of the relations you could have when joining the different Salesforce tables.

Note: All foreign key relationships are color coordinated based on each primary key in the tables above for easy identification.

Account with User Table

When you want to link your users who own the accounts, here’s how you do it:

Account.Owner ID <-> User.Id

Contact with Account Table

When you want to link contacts to accounts, here’s how you do it:

Contact.Account Id <-> Account.Id

Lead with Account Table

When you want to link accounts into which the lead has been converted, here’s how you do it:

Lead. Converted Account Id <-> Account.Id

Lead with Contact Table

When you want to link contacts into which the lead has been converted, here’s how you do it:

Lead. Converted Contact Id <-> Contact.Id

Lead with Opportunity Table

When you want to link opportunities into which the lead has been converted, here’s how you do it:

Lead. Converted Opportunity Id <-> Opportunity.Id

Opportunity with Account Table

When you want to link accounts associated with opportunities, here’s how you do it:

Opportunity. Account Id <-> Account.Id

Opportunity with User Table

When you want to link users with opportunities assigned for them to work on, here’s how you do it:

Opportunity. Owner Id <-> User.Id

 

Ridhima Rao Donthineni

About Ridhima Rao Donthineni