ZenotiHelp

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 id references DimGuest
  • accrual center name, Accrual Center Code references DimCenter (accrual center)
  • payment center name, payment Center Code references DimCenter (payment center)
  • invoiceid, invoiceno references invoice entity
  • program name references 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.