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.
Columns
| Name | Type | References | Description |
| 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 an 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. | |
| Description | Varchar | A description of the loyalty program tier group. | |
| 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 a business unit or other internal organization that owns a business account. | |
| Is Active | Varchar | An indicator of whether the loyalty tier group is active. | |
| Is Extended To End Of Month | Varchar | An indicator that determines if the benefit expiration date is extended to the last date of the month. | |
| Is Hidden To Members | Varchar | An indicator that determines the visibility of the Loyalty Tier Group to the members of the loyalty program. | |
| Is Primary | Varchar | An indicator that determines if the loyalty tier group is the primary tier group for the loyalty program. | |
| Last Modified Date | Datetime | The date when a user last modified the record. | |
| Loyalty Program | Varchar | A reference ID to a marketing strategy designed to encourage customers to shop at or use the services of business associated with the program. | |
| Loyalty Tier Group Id | Varchar | A unique ID that is used as the primary key for the Loyalty Tier Group DMO. | |
| Loyalty Tier Model | Varchar | A reference ID to the tier model used for processing, either fixed or anniversary. | |
| Name | Varchar | The name of the loyalty program tier group. | |
| Qualifying Points Reset Date | Datetime | The date when the qualifying points are to be reset. | |
| Qualifying Points Reset Frequency | Double | The unit of measure for the reset period between qualifying points resets. For example, the number of months between a reset. | |
| Qualifying Points Reset Period UOM | Varchar | The measure of time between resets of qualifying points, for example monthly or yearly. | |
| Tier Period Time UOM | Varchar | The measure of time between processing of tiers, for example monthly or yearly. | |
| Tier Time Period Quantity | Double | The number of time units that between processing of tiers within the loyalty tier group. |