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.