Power BI Connector for Salesforce Data Cloud

Build 24.0.9175

LoyaltyProgramMemberDataModelObject

The Loyalty Program Member DMO is a Data Cloud data model object (DMO) for a person who has joined a loyalty program.

Columns

Name Type References Description
Account Varchar A reference ID to account of company that employs member.
Account Contact Varchar A reference ID to individual who has a role specific to account.
Can Receive Partner Promotions Varchar An indicator whether a member has opted-in to receive promotions from partners.
Can Receive Promotions Varchar An indicator whether a member has opted-in to receive promotions.
Created Date Datetime The date when the record was created.
Data Source Varchar A reference ID for the logical name for a system that is the source of records identified by external record ID.
Data Source Object Varchar A reference ID for the logical name of the object where this record came from, whether that is a name of a cloud storage file or another connector’s external object.
Enrollment Channel Varchar A reference ID to methods that members can use to enroll in loyalty programs, for example via web, email, call center, social media, or point of sale.
Enrollment Date Datetime The date the member was admitted to loyalty program.
External Record ID Varchar A reference ID to an external data source system.
External Source ID Varchar A reference ID for the system in which the external record ID was assigned.
Internal Organization Varchar A reference ID to the business unit or other internal organization that owns the business account.
Last Activity Date Datetime The date of the most recent account activity.
Last Modified Date Datetime The date when a user last modified the record.
Last Renewal Date Datetime The date when member last extended their membership in program.
Loyalty Member Type Varchar A reference ID to types of loyalty members.
Loyalty Program Varchar A reference ID to marketing strategy designed to encourage customers to shop at or use the services of business associated with program.
Loyalty Program Member ID Varchar A unique ID used as primary key for the Loyalty Program Member DMO.
Loyalty Program Member Status Varchar A reference ID to state of member's status in loyalty program.
Loyalty Statement Delivery Type Varchar A reference ID to type of delivery method for loyalty statement, for example postal mail, email, or text message.
Membership Expiration Date Datetime The date a membership expires.
Membership Number Varchar An alphanumeric ID visible to loyalty program members.
Name Varchar The name of loyalty program member.
Party Varchar A reference ID to person who belongs to loyalty program.
Referred by Member Varchar A reference ID to person who referred member to loyalty program.
Referred by Party Varchar A reference ID to person who referred member to loyalty program.
Related Corporate Program Member Varchar A reference ID to corporate membership account associated with member.
Statement Last Generated Date Datetime The date the member was last sent program statement.
Statement Frequency Time UOM Varchar A reference ID to how often member has elected to receive program statements, for example monthly or yearly.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 24.0.9175