Guest Check In Fact Table
ZTZenoti Docs Team Updated April 10, 2026 2 min readGuide
Stores guest check-in events at centers, including membership status flags, guest attributes, and access-related indicators.
Columns
| Column Name | Data Type | Nullable | Description |
|---|---|---|---|
| factguestcheckinwid | BIGINT IDENTITY | NOT NULL | Surrogate key and primary key for the guest check-in record. |
| factguestcheckinid | BIGINT | YES | Source system identifier for the guest check-in fact. |
| accessusagepk | BIGINT | YES | Source system primary key for access usage. |
| userwid | BIGINT | YES | Foreign key to the guest/user dimension (Bi_DimUser.userwid). |
| centerwid | BIGINT | YES | Foreign key to the center dimension (Bi_DimCenter.centerwid). |
| lastarrived | TIMESTAMP | YES | Timestamp of the guest's last arrival. |
| resourcewid | BIGINT | YES | Foreign key to the resource dimension. |
| usermembershipwid | BIGINT | YES | Foreign key to the user membership dimension. |
| membershipuserwid | BIGINT | YES | Foreign key to the membership owner (Bi_DimUser.userwid). |
| membershipcenterwid | BIGINT | YES | Foreign key to the center where the membership was sold (Bi_DimCenter.centerwid). |
| void | BOOLEAN | YES | Soft-delete flag indicating the record is logically deleted. |
| checkinstatus | VARCHAR(400) | YES | Status of the check-in event. |
| membershipexpiringsoon | BOOLEAN | YES | Flag indicating the guest's membership is expiring soon. |
| remoteguest | BOOLEAN | YES | Flag indicating the guest is from a remote/different center. |
| minorguest | BOOLEAN | YES | Flag indicating the guest is a minor. |
| prospect | BOOLEAN | YES | Flag indicating the guest is a prospect (non-member). |
| membershipexpired | BOOLEAN | YES | Flag indicating the guest's membership has expired. |
| membershipcancelled | BOOLEAN | YES | Flag indicating the guest's membership is cancelled. |
| membershipfrozen | BOOLEAN | YES | Flag indicating the guest's membership is frozen. |
| membershipupgrade | BOOLEAN | YES | Flag indicating a membership upgrade scenario. |
| membershipdowngrade | BOOLEAN | YES | Flag indicating a membership downgrade scenario. |
| membershipsuspended | BOOLEAN | YES | Flag indicating the guest's membership is suspended. |
| noprofilepicture | BOOLEAN | YES | Flag indicating the guest has no profile picture. |
| pendingpayments | FLOAT | YES | Amount of pending payments for the guest. |
| memberbirthday | BOOLEAN | YES | Flag indicating it is the member's birthday. |
| memberanniversary | BOOLEAN | YES | Flag indicating it is the member's anniversary. |
| additionalfield1 | BOOLEAN | YES | Custom additional boolean field 1. |
| additionalfield2 | BOOLEAN | YES | Custom additional boolean field 2. |
| trackingnotenabled | BOOLEAN | YES | Flag indicating tracking notes are enabled for the guest. |
| crosscenterredemptionrestricted | BOOLEAN | YES | Flag indicating cross-center redemption is restricted. |
| usernomembership | BOOLEAN | YES | Flag indicating the user has no membership. |
| usernoguestpass | BOOLEAN | YES | Flag indicating the user has no guest pass. |
| userguestpassexpired | BOOLEAN | YES | Flag indicating the user's guest pass has expired. |
| userhostnotcheckedin | BOOLEAN | YES | Flag indicating the user's host has not checked in. |
| guestpassuservisitsexceeded | BOOLEAN | YES | Flag indicating the guest pass user's total visits have been exceeded. |
| guestpassuserperdayvisitsexceeded | BOOLEAN | YES | Flag indicating the guest pass user's per-day visit limit has been exceeded. |
| uservisitsexceeded | BOOLEAN | YES | Flag indicating the user's visit limit has been exceeded. |
Note: All fact tables also include standard ETL metadata columns (
podname,organizationid,groupid,etlCreatedDate) which are omitted from this reference for brevity.
Primary Key
factguestcheckinwid
Foreign Keys
| Column | References |
|---|---|
| userwid | Bi_DimUser.userwid |
| membershipuserwid | Bi_DimUser.userwid |
| centerwid | Bi_DimCenter.centerwid |
| membershipcenterwid | Bi_DimCenter.centerwid |
Enumerator Values
| Column | Values |
|---|---|
| checkinstatus | Checked-In Not Checked-In Auto Check-In Walk-In |
| void | TRUE = soft-deleted, FALSE = active |
| membershipexpiringsoon | FALSE = Not Expiring Soon, TRUE = Expiring Soon |
| remoteguest | FALSE = Local Guest, TRUE = Remote Guest |
| minorguest | FALSE = Adult, TRUE = Minor |
| prospect | FALSE = Not a Prospect, TRUE = Prospect |
| membershipexpired | FALSE = Not Expired, TRUE = Expired |
| membershipcancelled | FALSE = Not Cancelled, TRUE = Cancelled |
| membershipfrozen | FALSE = Not Frozen, TRUE = Frozen |
| membershipsuspended | FALSE = Not Suspended, TRUE = Suspended |
Was this article helpful?
Your feedback helps us improve our documentation.