ZenotiHelp

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.