ZenotiHelp

Guest Tier Changes Fact Table

ZTZenoti Docs Team Updated April 10, 2026 1 min readGuide

Stores guest loyalty tier change history, tracking transitions between tiers with effective date ranges.

Columns

Column Name Data Type Nullable Description
guesttierchangeswid BIGINT IDENTITY NOT NULL Surrogate key for the guest tier change record.
guesttierchangesid NUMERIC(19,0) NOT NULL Source system identifier and primary key for the tier change.
guestwid BIGINT YES Foreign key to the guest dimension (Bi_DimUser.userwid).
basecenterid BIGINT YES Foreign key to the guest's base center (Bi_DimCenter.centerwid).
startdate DATE YES Start date of the tier assignment.
enddate DATE YES End date of the tier assignment.
currenttierwid BIGINT YES Foreign key to the current tier dimension.
previoustierwid BIGINT YES Foreign key to the previous tier dimension.
void BOOLEAN YES Soft-delete flag indicating the record is logically deleted.

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

Primary Key

guesttierchangesid

Foreign Keys

Column References
guestwid Bi_DimUser.userwid
basecenterid Bi_DimCenter.centerwid

Enumerator Values

Column Values
void TRUE if the record is soft-deleted; FALSE otherwise.
Was this article helpful?
Your feedback helps us improve our documentation.