ZenotiHelp

User Guest Pass Fact Table

ZTZenoti Docs Team Updated April 10, 2026 1 min readGuide

Tracks guest passes issued by members to invitees, including pass status, sharing and expiration dates, category details, and membership association.

Columns

Column Name Data Type Nullable Description
FactUserGuestPassWID BIGINT IDENTITY NOT NULL Surrogate key for the user guest pass fact record.
FactUserGuestPassID DECIMAL(19,0) NULL Business/natural key for the guest pass fact.
UserGuestPassPK DECIMAL(19,0) NULL Source system primary key for the user guest pass.
UserGuestPassID VARCHAR(36) NULL Unique identifier (GUID) of the user guest pass.
BenefitTransferFK DECIMAL(19,0) NULL Foreign key reference to the benefit transfer record.
HostuserWID BIGINT NULL Foreign key to the host member user dimension.
Usermembershipwid BIGINT NULL Foreign key to the user-membership association.
InviteeUserWId BIGINT NULL Foreign key to the invitee/guest user dimension.
CenterwId BIGINT NULL Foreign key to the center dimension.
Status INT NULL Status code of the guest pass.
Statusdesc VARCHAR(50) NULL Description of the guest pass status.
Void BOOLEAN NULL Indicates whether the record has been voided.
Sharedon TIMESTAMP NULL Date and time when the guest pass was shared.
ExpiresOn TIMESTAMP NULL Date and time when the guest pass expires.
CategoryID VARCHAR(36) NULL GUID of the guest pass category.
CategoryName NVARCHAR(2048) NULL Name of the guest pass category.
RegistrationId VARCHAR(36) NULL GUID of the invitee registration.
etlCreatedBy DECIMAL(19,0) NULL ID of the ETL process/user that created this record.

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

Primary Key

FactUserGuestPassWID

Foreign Keys

Column References
HostuserWID Bi_DimUser.userwid
InviteeUserWId Bi_DimUser.userwid
CenterwId Bi_DimCenter.centerwid

Enumerator Values

Column Values
Status 1 = Active
2 = InActive
3 = Frozen
4 = Cancelled
5 = Expired
6 = Closed (Expired with Prepaids)
7 = Not Started
8 = Suspended
9 = Refund
10 = Deleted
12 = Failed
13 = Upgrade
14 = Downgrade
15 = Pending
16 = Transferred
Statusdesc Issued
Redeemed
Expired
Cancelled
Void FALSE = Active, TRUE = Voided
Was this article helpful?
Your feedback helps us improve our documentation.