ZenotiHelp

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.