Loyalty Point Programs Dimension Table
ZTZenoti Docs Team Updated April 10, 2026 1 min readGuide
Dimension table storing loyalty point program definitions, including purchase/redemption date ranges, auto-apply settings, and member restrictions.
Columns
| Column Name | Data Type | Nullable | Description |
|---|---|---|---|
| dimloyaltypointprogramwid | BIGINT IDENTITY | No | Surrogate warehouse key for the loyalty point program record |
| programid | VARCHAR(65535) | Yes | Unique identifier for the loyalty point program |
| programname | VARCHAR(65535) | Yes | Display name of the loyalty point program |
| programdesc | VARCHAR(65535) | Yes | Description of the loyalty point program |
| purchasedatestart | TIMESTAMP | Yes | Start date of the purchase eligibility window |
| purchasedateend | TIMESTAMP | Yes | End date of the purchase eligibility window |
| redemptionstartdate | TIMESTAMP | Yes | Start date for point redemption eligibility |
| redemptionstartdays | INTEGER | Yes | Number of days after earning before points can be redeemed |
| redemptionenddate | TIMESTAMP | Yes | End date for point redemption eligibility |
| redemptionenddays | INTEGER | Yes | Number of days after earning when points expire |
| void | INTEGER | Yes | Indicates whether the record has been voided/soft-deleted |
| autoapply | INTEGER | Yes | Flag indicating whether the program is automatically applied |
| code | VARCHAR(65535) | Yes | Code assigned to the loyalty point program |
| freeservicecommissioneligible | INTEGER | Yes | Flag indicating if free service commissions are eligible under this program |
| customerid | VARCHAR(65535) | Yes | Unique identifier of a specific customer if the program is customer-specific |
| restricttomembers | INTEGER | Yes | Flag indicating whether the program is restricted to members only |
| rebookserviceptstype | INTEGER | Yes | Type of points applied for rebooked services |
Note: All dimension tables also include standard ETL metadata columns (
podname,organizationid,groupid,etlLastUpdatedOn,etlLastUpdatedBy) which are omitted from this reference for brevity.
Primary Key
dimloyaltypointprogramwid
Foreign Keys
| Column | References |
|---|---|
| organizationid | an organization entity in the source system |
| customerid | a customer/user entity in the source system |
Enumerator Values
| Column | Values |
|---|---|
| void | 0 = Active, 1 = Voided |
| autoapply | 0 = Manual 1 = Auto-apply Enabled |
| freeservicecommissioneligible | 0 = Not Eligible 1 = Eligible |
| restricttomembers | 0 = Open to All 1 = Members Only |
| rebookserviceptstype | 0 = No Points 1 = Fixed 2 = Percentage |
Was this article helpful?
Your feedback helps us improve our documentation.