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.