Guest checkin fact table
bi_factguestcheckin
Field | Field type | Description | Primary key | Mapped Dimension table Mapped Dimension field |
|---|---|---|---|---|
factguestcheckinwid | BIGINT | Unique identifier for the row in the org. Primary key | yes | |
factguestcheckinid | BIGINT | Unique identifier for the row in the table. | ||
accessusagepk | BIGINT | Unique identifier for the row in the table, internal to zenoti | ||
userwid | BIGINT | unique identifier for the guest who checked in | Bi_dimuser | |
userwid | ||||
centerwid | BIGINT | unique identifier for the center | bi_dimcenter | |
centerwid | ||||
lastarrived | TIMESTAMP | time at which guest has checkedin into the center | ||
resourcewid | BIGINT | room to which guest checked-in | ||
usermembershipwid | BIGINT | membership of user through which guest checked in. In case it is guest pass, it is the user membership to which guest pass is related to | ||
membershipuserwid | BIGINT | unique identifier for the guest who purchased membership | ||
membershipcenterwid | BIGINT | unique identifier for the center where membership was purchased | ||
etlcreateddate | TIMESTAMP | Date and Time on which row is created | ||
etlcreatedby | BIGINT | System user which created the row. Internal to Zenoti | ||
void | BOOLEAN | Indicates if row is void or not. 0-active, 1- void | ||
etllastupdatedon | TIMESTAMP | Date and Time on which row is updated | ||
etllastupdatedby | VARCHAR(50) | System user which updated the row. Internal to Zenoti | ||
organizationid | VARCHAR(36) | Unique identifier for the organization | bi_dimcenter | |
organizationid | ||||
podname | VARCHAR(200) | Identifier for the region customer belongs to. Internal to Zenoti | ||
groupid | BIGINT | Internal to Zenoti. Used for data processing. | ||
checkinstatus | VARCHAR(400) | Status of the check-in event. | ||
membershipexpiringsoon | BOOLEAN | Flag indicating the guest's membership is expiring soon. | ||
remoteguest | BOOLEAN | Flag indicating the guest is from a remote/different center. | ||
minorguest | BOOLEAN | Flag indicating the guest is a minor. | ||
prospect | BOOLEAN | Flag indicating the guest is a prospect (non-member). | ||
membershipexpired | BOOLEAN | Flag indicating the guest's membership has expired. | ||
membershipcancelled | BOOLEAN | Flag indicating the guest's membership is cancelled. | ||
membershipfrozen | BOOLEAN | Flag indicating the guest's membership is frozen. | ||
membershipupgrade | BOOLEAN | Flag indicating a membership upgrade scenario. | ||
membershipdowngrade | BOOLEAN | Flag indicating a membership downgrade scenario. | ||
membershipsuspended | BOOLEAN | Flag indicating the guest's membership is suspended. | ||
noprofilepicture | BOOLEAN | Flag indicating the guest has no profile picture. | ||
pendingpayments | FLOAT | Amount of pending payments for the guest. | ||
memberbirthday | BOOLEAN | Flag indicating it is the member's birthday. | ||
memberanniversary | BOOLEAN | Flag indicating it is the member's anniversary. | ||
additionalfield1 | BOOLEAN | Custom additional boolean field 1. | ||
additionalfield2 | BOOLEAN | Custom additional boolean field 2. | ||
trackingnotenabled | BOOLEAN | Flag indicating tracking notes are enabled for the guest. | ||
crosscenterredemptionrestricted | BOOLEAN | Flag indicating cross-center redemption is restricted. | ||
usernomembership | BOOLEAN | Flag indicating the user has no membership. | ||
usernoguestpass | BOOLEAN | Flag indicating the user has no guest pass. | ||
userguestpassexpired | BOOLEAN | Flag indicating the user's guest pass has expired. | ||
userhostnotcheckedin | BOOLEAN | Flag indicating the user's host has not checked in. | ||
guestpassuservisitsexceeded | BOOLEAN | Flag indicating the guest pass user's total visits have been exceeded. | ||
guestpassuserperdayvisitsexceeded | BOOLEAN | Flag indicating the guest pass user's per-day visit limit has been exceeded. | ||
uservisitsexceeded | BOOLEAN | Flag indicating the user's visit limit has been exceeded. |