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.