ZenotiHelp

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.