Loyaltypoints Fact Consolidated
ZTZenoti Docs Team Updated April 10, 2026 2 min readGuide
Consolidated fact table capturing loyalty points transactions including accruals, redemptions, expirations, and tier information across loyalty programs and centers.
Columns
| Column Name | Data Type | Nullable | Description |
|---|---|---|---|
| action date | DATE | Yes | Date of the loyalty points action. |
| organization account name | VARCHAR(256) | Yes | Account name of the organization. Sourced from DimOrganization.organization_account_name. |
| accrual center name | VARCHAR(128) | Yes | Name of the center where points were accrued. Sourced from DimCenter.center_name. |
| payment center name | VARCHAR(128) | Yes | Name of the center where payment was made. Sourced from DimCenter.center_name. |
| guest base center | VARCHAR(256) | Yes | Base center assigned to the guest. Sourced from DimGuest.base_center. |
| user id | VARCHAR(36) | Yes | Unique identifier (UUID) of the guest. Sourced from DimGuest.user_id. |
| guest first name | VARCHAR(160) | Yes | First name of the guest. Sourced from DimGuest.first_name. |
| guest last name | VARCHAR(256) | Yes | Last name of the guest. Sourced from DimGuest.last_name. |
| guest middle name | VARCHAR(128) | Yes | Middle name of the guest. Sourced from DimGuest.middle_name. |
| accrual tier name | VARCHAR(256) | Yes | Loyalty tier at the time of accrual. |
| previous tier name | VARCHAR(128) | Yes | Previous loyalty tier of the guest. |
| current tier name | VARCHAR(512) | Yes | Current loyalty tier of the guest. |
| program name | VARCHAR(512) | Yes | Name of the loyalty program. |
| action name | VARCHAR(128) | Yes | Name of the loyalty action (e.g., Earn, Redeem, Expire). |
| loyalty points | DOUBLE PRECISION | Yes | Number of loyalty points involved in the action. |
| effective start date | TIMESTAMP | Yes | Start date of the points validity period. |
| effective end date | TIMESTAMP | Yes | End date of the points validity period. |
| record type name | VARCHAR(64) | Yes | Name of the record type. |
| is referral | INTEGER | Yes | Indicates whether the action is from a referral (1 = Yes, 0 = No). |
| guestpointsid | VARCHAR(36) | Yes | Unique identifier (UUID) of the guest points record. |
| accrual center minutes to add | INTEGER | Yes | Timezone offset in minutes for the accrual center. |
| payment center minutes to add | INTEGER | Yes | Timezone offset in minutes for the payment center. |
| invoiceno | VARCHAR(40) | Yes | Invoice number associated with the loyalty action. |
| invoiceid | VARCHAR(36) | Yes | Unique identifier (UUID) of the associated invoice. |
| loyaltypointswid | BIGINT | Yes | Warehouse identifier for the loyalty points record. |
| loyaltypointsid | BIGINT | Yes | Loyalty points record identifier. |
| Accrual Center Code | VARCHAR(40) | Yes | Code of the accrual center. Sourced from DimCenter.center_code. |
| payment Center Code | VARCHAR(40) | Yes | Code of the payment center. Sourced from DimCenter.center_code. |
Primary Key
No explicit primary key is defined. guestpointsid serves as the logical key. loyaltypointswid is used as the distribution key.
Foreign Keys
user idreferences DimGuestaccrual center name,Accrual Center Codereferences DimCenter (accrual center)payment center name,payment Center Codereferences DimCenter (payment center)invoiceid,invoicenoreferences invoice entityprogram namereferences loyalty program entity
Enumerator Values
| Column Name | Known Values |
|---|---|
| action name | Earn, Redeem, Expire, Adjust, Refund, etc. |
| record type name | Accrual, Redemption, Expiration, Adjustment |
| is referral | 0 (No), 1 (Yes) |
Standard ETL metadata columns (EtlLastUpdatedOn, EtlLastUpdatedBy, podname, groupid) are present in the underlying table but omitted from this reference for brevity.
Was this article helpful?
Your feedback helps us improve our documentation.