Views
Views are similar to tables in the way that data is represented; however, views are read-only.
Queries can be executed against a view as if it were a normal table.
CData ODBC Driver for Salesforce Data Cloud Views
| Name | Description |
| Account | The Account DMO is a Data Cloud data model object for how a party wantsto interact with your company. Provided in both the Sales and Service Data Kits. |
| AccountContact | The Account Contact DMO is a Data Cloud data model object for anindividual who has a role specific to an account. Provided in both the Sales and ServiceData Kits. |
| Affiliation | The Affiliation DMO is a Data Cloud data model object for affiliation orhow to map data Marketing Cloud Engagement business unit use cases. |
| AgentServicePresence | The Agent Service Presence DMO is a Data Cloud data model object (DMO) for a presence user’s real-time presence status. |
| AgentWork | The Agent Work DMO is a Data Cloud data model object (DMO) for a work assignment that has been routed to an agent. |
| AgentWorkSkill | The Agent Work Skill DMO is a Data Cloud data model object (DMO) for a for a skill used to route a work assignment to an agent. |
| AuthorizationForm | The Authorization Form DMO is a Data Cloud data model object (DMO) for the set of terms and conditions, such as privacy policy, contract, or consent forms. |
| AuthorizationFormConsent | The Authorization Form Consent DMO is a Data Cloud data model object (DMO). This DMO captures the where, when, and how a party gives consent for a form, a set of terms and conditions, or a privacy policy. |
| AuthorizationFormDataUse | The Authorization Form Data Use data model object (DMO) is a Data Cloud DMO for the data uses consented to in an authorization form. |
| AuthorizationFormText | The Authorization Form Text DMO is a Data Cloud data model object (DMO) for an authorization form’s text and language settings. |
| BenefitAction | The Benefit Action DMO is a Data Cloud data model object (DMO) for actions triggered when a program benefit is assigned to a loyalty program member. |
| BenefitType | The Benefit Type DMO is a Data Cloud data model object (DMO) for the types of benefits of a loyalty program, such as healthcare, financial, and loyalty. |
| Brand | The Brand DMO is a Data Cloud data model object (DMO) for the product’s brand, for example, Northern Trail Outfitters. |
| CardAccount | Represents a financial tool offered by a bank as a type of loan, with a line of revolving credit that you can access via your card and your card's account. Provided in the Financial Services Cloud Data Kit. This DMO is available in API version 58 and later. |
| Case | The Case DMO is a Data Cloud data model object (DMO) for support cases based on recorded issues, for example, a laptop connectivity problem. Provided in both the Sales and Service Data Kits. |
| CaseUpdate | The Case Update DMO is a Data Cloud data model object (DMO) for a for historical information about changes made to the associated case. |
| CommunicationSubscription | The Communication Subscription DMO is a Data Cloud data model object (DMO) for a customer’s subscription preferences for a specific communication. |
| CommunicationSubscriptionChannelType | The Communication Subscription Channel Type DMO is a Data Cloud data model object (DMO) for the engagement channel through which a customer is reached for a communication subscription. |
| CommunicationSubscriptionConsent | The Communication Subscription Consent DMO is a Data Cloud data model object (DMO) for the engagement or communication channel preferences of a customer. |
| CommunicationSubscriptionTiming | The Communication Subscription Timing DMO is a Data Cloud data model object (DMO) for a customer's timing preferences for receiving a communication subscription. |
| ConsentAction | The Consent Action DMO is a Data Cloud data model object (DMO) for what a user consents to be done with their data, for example, data collection or web activity tracking. |
| ConsentStatus | The Consent Status DMO is a Data Cloud data model object (DMO) for the status of consent, for example opted in or out of data collection. |
| ContactPointAddress | The Contact Point Address data model object (DMO) is a Data CloudDMObased on the mailing address of a party. Provided in both the Sales and Service DataKits. |
| ContactPointApp | The Contact Point App DMO is a Data Cloud data model object for the softwareapplication of a party on a specific device. |
| ContactPointConsent | The Contact Point Consent DMO is a Data Cloud data model object (DMO) for recording information about consent for a specific contact point. This data includes when, how, for how long, and whether the party has double opted-in. |
| ContactPointEmail | The Contact Point Email DMO is a Data Cloud data model object for theemail address of a party. Provided in both the Sales and Service Data Kits. |
| ContactPointPhone | The Contact Point Phone data model object (DMO) is a Data Cloud DMO forthe phone number of a party. Provided in both the Sales and Service Data Kits. |
| ContactPointSocial | The Contact Point Social DMO is a Data Cloud data model object (DMO) for the social media handle for a party, for example @trustednews on Twitter. |
| ConversationEntryTranscriptExcerpt | The Conversation Entry Transcript Excerpt DMO is a Data Cloud data modelobject for a portion of a Conversation Entry that includes a portion of a transcript. |
| ConversationReason | The Conversation Reason DMO is a Data Clouddata model object for the reason a conversation started. It contains aggregated metrics for excerpts. Example values include cancel order, update order, and check on order status. |
| ConversationReasonCategory | The Conversation Reason Category DMO is a Data Cloud data model object for a grouping of conversation reasons that have the same overall topic. It contains aggregated metrics for the associated conversation reasons. Example values include Order Management, Payments, and Account Management. |
| ConversationReasonReportDefinition | The Conversation Reason Report Definition DMO is a Data Cloud data model object for a conversation mining report that contains an overview of the conversational data shape and groups of conversation reasons and excerpts. |
| ConversationReasonReportSegmentDef | The Conversation Reason Report Segment Def DMO is a Data Cloud data model object for a segment definition of a conversation reason report. |
| DataUseLegalBasis | The Data Use Legal Basis DMO is a Data Cloud data model object (DMO) for the legal reason for contacting a customer, such as billing or contract. |
| DataUsePurpose | The Data Use Purpose DMO is a Data Cloud data model object (DMO) for the purpose of contacting a prospect or customer, such as for billing, marketing, or surveys. |
| DataUsePurposeConsentAction | The Data Use Purpose Consent Action DMO is a Data Cloud data model object (DMO) for individual consent preferences for consent actions. |
| DepositAccount | Represents a subtype of a financial account. Provided in the Financial Services Cloud Data Kit. This DMO is available in API version 58 and later. |
| Device | The Device data model object (DMO) is a Data Cloud DMO for a specificelectronic unit that you want to track signals from, for example, a refrigerator, watch, orcar. |
| DeviceApplicationEngagement | The Device Application Engagement DMO is a Data Cloud data model object(DMO) for data about device engagement, for example mobile app usage. |
| DeviceApplicationTemplate | The Device Application Template DMO is a Data Cloud data model object(DMO) for a reusable standard format for applications to exchange information betweendevices. |
| EmailEngagement | The Email Engagement DMO is a Data Cloud data model object (DMO) for data captured from various data sources about engagement in the Email channel. |
| EmailMessage | The Email Message DMO is a Data Cloud data model object (DMO) for an email message, usually text, but possibly HTML, including attachments sent or received over the network. |
| EmailPublication | The Email Publication DMO is a Data Cloud data model object (DMO) that contains information about a publication such as a campaign or an orchestration used in the Email channel |
| EmailTemplate | The Email Template DMO is a Data Cloud data model object (DMO) for the standard form of an email message that can be personalized and customized based on a campaign. |
| EngagementChannelType | The Engagement Channel Type DMO is a Data Cloud data model object (DMO) for which channels are supported by individual preferences. For example, individuals can set consent preferences for SMS but not for a phone call. |
| EngagementChannelTypeConsent | The Engagement Channel Type Consent DMO is a Data Cloud data model object (DMO) for an individual’s consent preferences specific to a type of communication, such as email. |
| EngagementTopic | The Engagement Topic DMO is a Data Cloud data model object (DMO) that is used to refer to multiple topics such as multiple campaigns or promotions. |
| FinancialAccount | Represents a financial account held at a financial institution such as a bank. Provided in the Financial Services Cloud Data Kit. This DMO is available in API version 58 and later. |
| FinancialAccountBalance | Represents types of balances associated to a financial account. Provided in the Financial Services Cloud Data Kit. This DMO is available in API version 58 and later. |
| FinancialAccountFee | Represents fees associated with a financial account. Provided in the Financial Services Cloud Data Kit. This DMO is available in API version 58 and later. |
| FinancialAccountInterestRate | Represents the interest rate associated with a financial account. Provided in the Financial Services Cloud Data Kit. This DMO is available in API version 58 and later. |
| FinancialAccountLimit | Represents the limits associated with a financial account. Provided in the Financial Services Cloud Data Kit. This DMO is available in API version 58 and later. |
| FinancialAccountParty | Represents the role of an organization account or person account related to a financial account. Provided in the Financial Services Cloud Data Kit. This DMO is available in API version 58 and later. |
| FinancialAccountTransaction | Represents transactions related to a financial account. There can be various types of transactions such as credit, debit, and so forth. Provided in the Financial Services Cloud Data Kit. This DMO is available in API version 58 and later. |
| FinancialCustomer | Represents an extension of an account to capture financial services attributes. Provided in the Financial Services Cloud Data Kit. This DMO is available in API version 58 and later. |
| FinancialGoal | Represents the money to achieve a financial goal such as education or home purchase. Provided in the Financial Services Cloud Data Kit. This DMO is available in API version 58 and later. |
| FinancialGoalFunding | Represents a financial goal of an individual or person account that requires funding. This DMO is available in API version 61 and later. |
| FinancialGoalParty | Represents an association between a financial goal and the related party. Provided in the Financial Services Cloud Data Kit. This DMO is available in API version 58 and later. |
| FinancialHolding | Represents the financial holdings associated with either an account or a financial account. Provided in the Financial Services Cloud Data Kit. This DMO is available in API version 58 and later. |
| FinancialPlan | Represents a financial plan for a person account. This DMO is available in API version 61 and later. |
| FinancialSecurity | Represents a financial holding such as securities, bonds, mutual funds, and so forth in relation to either an account or a financial account (investment account). Provided in the Financial Services Cloud Data Kit. This DMO is available in API version 58 and later. |
| Flow | The Flow DMO is a Data Cloud data model object (DMO) for details about a flow. |
| FlowElement | The Flow Element DMO is a Data Cloud data model object (DMO) for details about a single element within a flow version. |
| FlowElementRun | The Flow Element Run DMO is a Data Cloud data model object (DMO) for the status of a single element executed within a flow run. |
| FlowRun | The Flow Run DMO is a Data Cloud data model object (DMO) for details about a single execution of a flow. |
| FlowVersion | The Flow Version DMO is a Data Cloud data model object (DMO) for details about a version of a flow. |
| FlowVersionOccurrence | The Flow Version Occurrence DMO is a Data Cloud data model object (DMO) for an instance of a recurring flow that runs on a schedule. For example, a flow that runs weekly on Wednesdays creates an occurrence each time it runs. |
| GoodsProduct | The Goods Product DMO is a Data Cloud data model object (DMO) for a specific product, for example a carton of milk or a set of towels |
| Individual | The Individual DMO is a Data Cloud data model object for contacts,customers, or other people interested in your company's products or services. |
| InsurancePolicy | Represents an insurance policy. Provided in the Financial Services Cloud Data Kit. This DMO is available in API version 58 and later. |
| InterestTagDefinition | Represents products, services, features in which a party has expressed interest. Provided in the Financial Services Cloud Data Kit. This DMO is available in API version 58 and later. |
| InvestmentAccount | Represents a subtype of a financial account. Provided in the Financial Services Cloud Data Kit. This DMO is available in API version 58 and later. |
| KnowledgeArticleEngagement | Stores the user engagement details related to a Knowledge Article. It’s a logical subtype of EngagementAction. Provided by the Knowledge Engagement Ingestion API. This DMO is available in API version 58 and later. |
| Lead | The Lead data model object (DMO) is a Data Cloud DMO for a person orcompany that shows interest in a company’s products or services. |
| LoanAccount | Represents a subtype of financial account. Provided in the Financial Services Cloud Data Kit. This DMO is available in API version 58 and later. |
| LoyaltyBenefit | The Loyalty Benefit DMO is a Data Cloud data model object (DMO) for a perk or betterment that is available to the members of a Loyalty Program. Examples include waived airline baggage fees, complimentary hotel stays, or a rental car upgrade. |
| LoyaltyBenefitType | The Loyalty Benefit Type DMO is a Data Cloud data model object (DMO) for the type of loyalty benefit, such as rewards or gift cards. |
| LoyaltyJournalSubtype | The Loyalty Journal Subtype DMO is a Data Cloud data model object (DMO) for a subtype of a loyalty journal type, such as a watched video or product review. |
| LoyaltyJournalType | The Loyalty Journal Type DMO is a Data Cloud data model object (DMO) for the type of loyalty journal. |
| LoyaltyLedger | The Loyalty Ledger DMO is a Data Cloud data model object (DMO) to record the points credited or debited for a member across transactions. |
| LoyaltyMemberCurrency | The Loyalty Member Currency DMO is a Data Cloud data model object (DMO) representing the value a loyalty member selects to receive, for example, as airline miles or as points. |
| LoyaltyMemberTierDataModelObject | The Loyalty Member Tier DMO is a Data Cloud data model object (DMO) for the benefit tier within the program that a member is assigned. |
| LoyaltyPartnerProduct | The Loyalty Partner Product DMO is a Data Cloud data model object (DMO) for a product offered by a loyalty program partner, such as a coupon from another company. |
| LoyaltyProgram | The Loyalty Program DMO is a Data Cloud data model object (DMO) for a strategy designed to encourage customers to continue to be loyal to the business associated with the program. |
| LoyaltyProgramCurrency | The Loyalty Program Currency DMO is a Data Cloud data model object (DMO) representing the value or currency that the loyalty program offers to customers. |
| LoyaltyProgramMemberDataModelObject | The Loyalty Program Member DMO is a Data Cloud data model object (DMO) for a person who has joined a loyalty program. |
| LoyaltyProgramMemberPromotion | The Loyalty Program Member Promotion DMO is a Data Cloud data model object (DMO) that represents details about a promotion available to a loyalty program member. For example, if a program allows double points on outdoor purchases. |
| LoyaltyProgramPartner | The Loyalty Program Partner DMO is a Data Cloud data model object (DMO) for companies with loyalty program offerings. |
| LoyaltyTier | The Loyalty Tier DMO is a Data Cloud data model object (DMO) for a level of a loyalty program where member benefits increase at higher levels of the hierarchy. |
| LoyaltyTierBenefit | The Loyalty Tier Benefit DMO is a Data Cloud data model object (DMO) for a benefit that is available in a specific loyalty member tier. |
| LoyaltyTierGroup | The Loyalty Tier Group DMO is a Data Cloud data model object (DMO) for loyalty programs that have multiple tiers of benefits. Tiers can be organized based on objectives, for example, lifetime, marketing, or regular. |
| LoyaltyTransactionJournal | The Loyalty Transaction Journal DMO is a Data Cloud data model object (DMO) for a collection of transactions related to a loyalty program. Loyalty Transaction Journals are related to a voucher, but could relate to other payment method types. |
| MarketJourneyActivity | The Market Journey Activity data model object (DMO) is a Data Cloud DMO for a step or activity within a journey in Journey Builder. |
| MarketSegment | The Market Segment DMO is a Data Cloud data model object (DMO) for a group of people who share one or more common characteristics, grouped for marketing purposes. |
| MasterProduct | The Master Product DMO is a Data Cloud data model object (DMO) for data about a company’s products. |
| MemberBenefit | The Member Benefit DMO is a Data Cloud data model object (DMO) for a benefit available within the loyalty program that a member is qualified for and has elected to receive. |
| MessageEngagement | The Message Engagement DMO is a Data Cloud data model object (DMO) for a user’s engagement with a marketing message. |
| OperatingHours | The Operating Hours DMO is a Data Cloud data model object (DMO) for when a business or business function is available for use. |
| Opportunity | The Opportunity DMO is a Data Cloud data model object (DMO) for deals or sales that are in progress and not yet completed. |
| OpportunityProduct | The Opportunity Product DMO is a Data Cloud data model object (DMO) for connecting an opportunity to the product that it represents, allowing for a many-to-many relationship. |
| OrderDeliveryMethod | The Order Delivery Method data model object (DMO) is a Data Cloud DMO for the order and delivery methods for products or service fulfillment. |
| Party | Represents information about who you are dealing with. Provided in the Financial Services Cloud Data Kit. This DMO is available in API version 58 and later. |
| PartyConsent | The Privacy Consent DMO is a Data Cloud data model object (DMO) for an individual’s consent preferences. |
| PartyExpense | Represents the expense incurred by an individual or account. This DMO is available in API version 61 and later. |
| PartyFinancialAsset | Represents a financial asset associated with an individual or an organization. For example, cash in hand, owned property, and so forth. Provided in the Financial Services Cloud Data Kit. This DMO is available in API version 58 and later. |
| PartyFinancialLiability | Represents a financial liability associated with an individual or an organization. For example a mortgage or loan. Provided in the Financial Services Cloud Data Kit. This DMO is available in API version 58 and later. |
| PartyIdentification | The Party Identification DMO is a Data Cloud data model object for theways to identify a party, such as a driver’s license or a birth certificate. |
| PartyIncome | Represents the income of an individual or a business. The income can be from salaries, commissions, fees, rental properties, and other sources. This DMO is available in API version 61 and later. |
| PartyInterestTag | Represents an association between a party and interest tag. Provided in the Financial Services Cloud Data Kit. This DMO is available in API version 58 and later. |
| PaymentMethod | Represents the way a customer pays for a transaction. |
| PersonLifeEvent | Represents a major life event for an individual. Provided in the Financial Services Cloud Data Kit. This DMO is available in API version 58 and later. |
| PrivacyConsentLog | The Privacy Consent Log DMO is a Data Cloud data model object (DMO) for information about a user’s requested consent and privacy information. |
| ProductBrowseEngagement | Product Browse Engagement DMO is a Data Cloud data model object (DMO) for data captured from a user action, such as searching for products or viewing a list of products. |
| ProductCatalog | The Product Catalog DMO is a Data Cloud data model object (DMO) for a company’s inventory or merchandising catalog. |
| ProductCatalogCategory | The Product Catalog Category DMO is a Data Cloud data model object (DMO) for the category of the product catalog, such as shoes, trucks, or housewares. |
| ProductCategory | The Product Category data model object (DMO) is a Data Cloud DMO for the types of products a company has or offers, such as shoes or types of services. |
| ProductCategoryProduct | The Product Category Product data model object (DMO) is a Data Cloud DMO used to identify how products are assigned to categories. For example, Northern Trail Outfitters can use this DMO to identify how a specific running shoe is assigned to a shoe and running categories. |
| ProductOrderEngagement | The Product Order Engagement DMO is a Data Cloud data model object (DMO) for a user’s online shopping order data. |
| Promotion | The Promotion DMO is a Data Cloud data model object (DMO) for loyalty promotion details such as the type of promotion. |
| PromotionLoyaltyPartnerProduct | The Promotion Loyalty Partner Product DMO is a Data Cloud data model object (DMO) for the promotion of a product that a partner is co-marketing to loyalty program members. |
| RecordAlert | Represents record alerts for an account. Provided in the Financial Services Cloud Data Kit. This DMO is available in API version 58 and later. |
| SalesOrder | The Sales Order DMO is a Data Cloud data model object (DMO) that provides information around current and pending sales orders. |
| SalesOrderProduct | The Sales Order Product DMO is a Data Cloud data model object (DMO) for the component of a sales order that identifies a product or service to be sold to the customer. |
| SalesStore | The Sales Store DMO is a Data Cloud data model object (DMO) that provides information regarding a retail establishment selling items to the public. |
| ServicePresenceStatus | The Service Presence Status DMO is a Data Cloud data model object (DMO) for a presence status that can be assigned to a service channel. For example, Available for Leads, Out for Lunch, or Busy. |
| ShoppingCartEngagement | The Shopping Cart Engagement DMO is a Data Cloud Data Platform data model object (DMO) for data captured from user actions, such as adding and removing items from a shopping cart. |
| ShoppingCartEventType | The Shopping Cart Event Type DMO is a Data Cloud data model object (DMO) for when a customer interacts with a commerce site’s shopping cart. |
| ShoppingCartProductEngagement | The Shopping Cart Product Engagement DMO is a Data Cloud data model object (DMO) for data captured from user actions, such as adding and removing items from a shopping cart. |
| Skill | The Skill DMO is a Data Cloud data model object (DMO) for proficiency, competence, or expertise that an employee possesses, which is useful to the mission of an organization. |
| SMSPublication | The SMS Publication DMO is a Data Cloud data model object (DMO) for the process that sends out a set of SMS messages to multiple recipients. |
| SMSTemplate | The SMS Template DMO is a Data Cloud data model object (DMO) for a reusable, standard format for text (SMS) messages. |
| SoftwareApplication | The Software Application DMO is a Data Cloud data model object (DMO) for defining programs created for the end user, such as an app for Northern Trail Outfitters loyalty members. |
| Survey | The Survey DMO is a Data Cloud data model object (DMO) for a survey. |
| SurveyInvitation | The Survey Invitation DMO is a Data Cloud data model object (DMO) for the invitation sent to a participant to complete the survey. |
| SurveyQuestion | The Survey Question DMO is a Data Cloud data model object (DMO) for a question in a survey under a section. |
| SurveyQuestionResponse | The Survey Question Response DMO is a Data Cloud data model object (DMO) for participants who answer specific questions. |
| SurveyQuestionSection | The Survey Question Section DMO is a Data Cloud data model object (DMO) for a section, such as the title section or a question section, in a survey. |
| SurveyResponse | The Survey Response DMO is a Data Cloud data model object (DMO) for an answer to a survey question. |
| SurveySubject | The Survey Subject DMO is a Data Cloud data model object (DMO) for a relationship between a survey and another object, such as an account or a case. |
| SurveyVersion | The Survey Version DMO is a Data Cloud data model object (DMO) for a version of the survey. |
| User | The User DMO is a Data Cloud data model object (DMO) for an account, a person or a machine, that can log in to use the deployed software system. |
| UserGroup | The User Group DMO is a Data Cloud data model object (DMO) for a set of system users with common characteristics. User Groups are often created to simplify the granting of system privileges and granting access to resources. |
| Voucher | The Voucher DMO is a Data Cloud data model object (DMO) for a loyalty program’s voucher. |
| VoucherDefinition | The Voucher Definition DMO is a Data Cloud data model object (DMO) for details about a voucher definition associated with a loyalty program. |
| WebSearchEngagement | The Web Search Engagement DMO is a Data Cloud data model object (DMO) for web search engagement data. |
| WebsiteEngagement | The Website Engagement DMO is a Data Cloud data model object (DMO) for any data associated with website engagement, such as views or clicks. |