ZenotiHelp

Loyalty Points Fact Table

ZTZenoti Docs Team Updated April 10, 2026 1 min readGuide

Stores loyalty point accrual and redemption transactions, including program, tier, action details, and effective date ranges.

Columns

Column Name Data Type Nullable Description
loyaltypointswid BIGINT IDENTITY NOT NULL Surrogate key and primary key for the loyalty points record.
loyaltypointsid BIGINT NOT NULL Source system identifier for the loyalty points fact.
guestpointsid VARCHAR(36) YES GUID identifier for the guest points record.
actiondate DATE NOT NULL Date the loyalty points action occurred.
accrualcenterwid BIGINT YES Foreign key to the center where points were accrued (Bi_DimCenter.centerwid).
paymentcenterwid BIGINT YES Foreign key to the center where payment was made (Bi_DimCenter.centerwid).
guestwid BIGINT YES Foreign key to the guest dimension (Bi_DimUser.userwid).
recordtypeid SMALLINT NOT NULL Record type identifier distinguishing accrual vs. redemption.
invoiceid VARCHAR(36) YES GUID of the associated invoice.
programwid BIGINT YES Foreign key to the loyalty program dimension.
accrualtierwid BIGINT YES Foreign key to the accrual tier dimension.
actionwid BIGINT YES Foreign key to the loyalty action dimension.
effectivestartdate TIMESTAMP YES Effective start date of the loyalty points.
effectiveenddate TIMESTAMP YES Effective end date (expiry) of the loyalty points.
loyaltypoints DOUBLE PRECISION NOT NULL Number of loyalty points accrued or redeemed.
refpoints INTEGER YES Reference points value. Default: 0.
void INTEGER YES Soft-delete flag (0 = active, non-zero = voided). Default: 0.
invoiceno VARCHAR(40) YES Human-readable invoice number.

Note: All fact tables also include standard ETL metadata columns (podname, organizationid, groupid, etlCreatedDate) which are omitted from this reference for brevity.

Primary Key

loyaltypointswid

Foreign Keys

Column References
guestwid Bi_DimUser.userwid
accrualcenterwid Bi_DimCenter.centerwid
paymentcenterwid Bi_DimCenter.centerwid

Enumerator Values

Column Values
recordtypeid 0 = Not Applicable
1 = Accrual
2 = Redemption
void 0 = active; non-zero = voided/soft-deleted.
refpoints 1 = Referral points; 0 = Regular points.
Was this article helpful?
Your feedback helps us improve our documentation.