Loyalty Member Tier DMO

The benefit tier within the program to which a member is assigned.

Object API Name: ssot__LoyaltyMemberTier__dlm
Category: Unassigned
Availability: Available in 254 and later versions
Primary Key Field: Id

• LoyaltyProgramMemberId has a FOREIGNKEY relationship with the Loyalty Program Member DMO Id field.
• LoyaltyTierId has a FOREIGNKEY relationship with the Loyalty Tier DMO Id field.

• AreBenefitsAssigned
• cdp_sys_record_currency
• CreatedDate
• DataSourceId
• DataSourceObjectId
• EffectiveDate
• EnrollmentType
• ExternalRecordId
• ExternalSourceId
• Id
• InternalOrganizationId
• KQ_Id
• KQ_LoyaltyProgramMemberId
• KQ_LoyaltyTierId
• LastModifiedDate
• LoyaltyMemberTierChangeTypeId
• LoyaltyProgramMemberId
• LoyaltyTierId
• Name
• Status
• TierChangeReasonText
• TierExpirationDate
• TierMemberIdentifier

• Field API Name: ssot__AreBenefitsAssigned__c
• Data Type: BOOLEAN
• Description: This wil be used to track whether the Benefits are already assigned for this Member Tier.

• Field API Name: ssot__cdp_sys_record_currency__c
• Data Type: TEXT
• Description: System-generated metadata field that stores a 3-letter ISO currency code.

• Field API Name: ssot__CreatedDate__c
• Data Type: DATETIME
• Description: The date and time the record was originally created.

• Field API Name: ssot__DataSourceId__c
• Data Type: TEXT
• Description: A unique, system-generated identifier for this record.

• Field API Name: ssot__DataSourceObjectId__c
• Data Type: TEXT
• Description: A unique, system-generated identifier for this record.

• Field API Name: ssot__EffectiveDate__c
• Data Type: DATETIME
• Description: When the member joined the loyalty tier.

• Field API Name: ssot__EnrollmentType__c
• Data Type: TEXT
• Description: Alphanumeric string representing the enrollment type.

• Field API Name: ssot__ExternalRecordId__c
• Data Type: TEXT
• Description: A unique, system-generated identifier for this record.

• Field API Name: ssot__ExternalSourceId__c
• Data Type: TEXT
• Description: A unique, system-generated identifier for this record.

• Field API Name: ssot__Id__c
• Data Type: TEXT
• Description: Required. A unique, system-generated identifier for this LoyaltyMemberTier record. Maximum size is 36 characters.

• Field API Name: ssot__InternalOrganizationId__c
• Data Type: TEXT
• Description: A unique, system-generated identifier for this record.

• Field API Name: KQ_Id__c
• Data Type: TEXT
• Description: Key Qualifier system field for Id

• Field API Name: KQ_LoyaltyProgramMemberId__c
• Data Type: TEXT
• Description: Key Qualifier system field for LoyaltyProgramMemberId

• Field API Name: KQ_LoyaltyTierId__c
• Data Type: TEXT
• Description: Key Qualifier system field for LoyaltyTierId

• Field API Name: ssot__LastModifiedDate__c
• Data Type: DATETIME
• Description: The date and time of the last modification to this record.

• Field API Name: ssot__LoyaltyMemberTierChangeTypeId__c
• Data Type: TEXT
• Description: A unique, system-generated identifier for this record.

• Field API Name: ssot__LoyaltyProgramMemberId__c
• Data Type: TEXT
• Description: A person who has joined a Loyalty Program.

• Field API Name: ssot__LoyaltyTierId__c
• Data Type: TEXT
• Description: Levels of a Loyalty Program where member benefits increase at higher levels of the hierarchy.

• Field API Name: ssot__Name__c
• Data Type: TEXT
• Description: Name of a Loyalty Member Tier.

• Field API Name: ssot__Status__c
• Data Type: TEXT
• Description: The status of this record.

• Field API Name: ssot__TierChangeReasonText__c
• Data Type: TEXT
• Description: explanation of tier change.

• Field API Name: ssot__TierExpirationDate__c
• Data Type: DATETIME
• Description: When the member’s eligibility for the loyalty tier expires.

• Field API Name: ssot__TierMemberIdentifier__c
• Data Type: TEXT
• Description: Alphanumeric string representing the tier member identifier.