Guest Loyalty Tier Dimension Table
ZTZenoti Docs Team Updated April 10, 2026 1 min readGuide
Dimension table storing guest loyalty tier assignments, tracking which loyalty tier a guest belongs to and the effective date range.
Columns
| Column Name | Data Type | Nullable | Description |
|---|---|---|---|
| loyaltytierwid | BIGINT IDENTITY | No | Surrogate warehouse key for the guest loyalty tier (Primary Key) |
| userid | VARCHAR(36) | Yes | Unique identifier (GUID) of the guest/user |
| guesttierpk | BIGINT | Yes | Source system primary key for the guest tier record |
| firstname | VARCHAR(320) | Yes | First name of the guest |
| lastname | VARCHAR(512) | Yes | Last name of the guest |
| tierid | VARCHAR(36) | Yes | Unique identifier (GUID) of the loyalty tier |
| tiername | VARCHAR(2014) | Yes | Display name of the loyalty tier |
| startdate | TIMESTAMP | Yes | Start date of the tier assignment |
| enddate | TIMESTAMP | Yes | End date of the tier assignment |
| centerid | VARCHAR(36) | Yes | Identifier (GUID) of the associated center |
Note: All dimension tables also include standard ETL metadata columns (
podname,organizationid,groupid,etlLastUpdatedOn,etlLastUpdatedBy) which are omitted from this reference for brevity.
Primary Key
loyaltytierwid
Foreign Keys
This table has no foreign key relationships to other analytics tables.
Was this article helpful?
Your feedback helps us improve our documentation.