Guest checkin fact table
bi_factguestcheckin_s3
Table | Field | Description | Field type | Primary key | Mapped Dimension table Mapped Dimension field |
|---|---|---|---|---|---|
bi_factguestcheckin_s3 | factguestcheckinid | Unique identifier for the row in the table. | BIGINT | yes | |
bi_factguestcheckin_s3 | accessusagepk | Unique identifier for the row in the table. Internal to zenoti | BIGINT | ||
bi_factguestcheckin_s3 | userid | unique identifier for the guest who checked in | VARCHAR(36) | Bi_dimuser | |
userid | |||||
bi_factguestcheckin_s3 | usermembershipid | 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 | VARCHAR(36) | ||
bi_factguestcheckin_s3 | centerid | unique identifier for the center | VARCHAR(36) | bi_dimcenter | |
centerid | |||||
bi_factguestcheckin_s3 | lastarrived | time at which guest has checkedin into the center | TIMESTAMP | ||
bi_factguestcheckin_s3 | roomid | room to which guest checked-in | VARCHAR(36) | ||
bi_factguestcheckin_s3 | membershipuser | unique identifier for the guest who purchased membership | VARCHAR(36) | ||
bi_factguestcheckin_s3 | membershipcenterid | unique identifier for the center where membership was purchased | VARCHAR(36) | ||
bi_factguestcheckin_s3 | etlcreateddate | Date and Time on which row is created | TIMESTAMP | ||
bi_factguestcheckin_s3 | etlcreatedby | System user which created the row. Internal to Zenoti | BIGINT | ||
bi_factguestcheckin_s3 | etllastupdatedon | Date and Time on which row is updated | TIMESTAMP | ||
bi_factguestcheckin_s3 | void | Indicates if row is void or not. 0-active, 1- void | BOOLEAN | ||
bi_factguestcheckin_s3 | podname | Identifer for the region customer belongs to. Internal to Zenoti | VARCHAR(200) | ||
bi_factguestcheckin_s3 | organizationid | Unique identifier for the organization | VARCHAR(36) | bi_dimcenter organizationid | |
bi_factguestcheckin_s3 | groupid | Internal to Zenoti. Used for data processing. | BIGINT | ||
bi_factguestcheckin_s3 | checkinstatus | Indicates if a checkin is successful or not | VARCHAR(400); | ||
bi_factguestcheckin_s3 | membershipexpiringsoon | Indicates if "membership expiring soon alert" is raised on not when guest tries to checkin | BOOLEAN; | ||
bi_factguestcheckin_s3 | remoteguest | Indicates if ''remoteguest'' alert is raised on not when guest tries to checkin | BOOLEAN; | ||
bi_factguestcheckin_s3 | minorguest | Indicates if ''minorguest'' alert is raised on not when guest tries to checkin | BOOLEAN; | ||
bi_factguestcheckin_s3 | prospect | Indicates if ''prospect'' alert is raised on not when guest tries to checkin | BOOLEAN; | ||
bi_factguestcheckin_s3 | membershipexpired | Indicates if ''membershipexpired'' alert is raised on not when guest tries to checkin | BOOLEAN; | ||
bi_factguestcheckin_s3 | membershipcancelled | Indicates if ''membershipcancelled'' alert is raised on not when guest tries to checkin | BOOLEAN; | ||
bi_factguestcheckin_s3 | membershipfrozen | Indicates if ''membershipfrozen'' alert is raised on not when guest tries to checkin | BOOLEAN; | ||
bi_factguestcheckin_s3 | membershipupgrade | Indicates if ''membershipupgrade'' alert is raised on not when guest tries to checkin | BOOLEAN; | ||
bi_factguestcheckin_s3 | membershipdowngrade | Indicates if ''membershipdowngrade'' alert is raised on not when guest tries to checkin | BOOLEAN; | ||
bi_factguestcheckin_s3 | membershipsuspended | Indicates if ''membershipsuspended'' alert is raised on not when guest tries to checkin | BOOLEAN; | ||
bi_factguestcheckin_s3 | noprofilepicture | Indicates if ''noprofilepicture'' alert is raised on not when guest tries to checkin | BOOLEAN; | ||
bi_factguestcheckin_s3 | pendingpayments | Pending payment amount | FLOAT; | ||
bi_factguestcheckin_s3 | memberbirthday | Indicates if ''memberbirthday'' alert is raised on not when guest tries to checkin | BOOLEAN; | ||
bi_factguestcheckin_s3 | memberanniversary | Indicates if ''memberanniversary'' alert is raised on not when guest tries to checkin | BOOLEAN; | ||
bi_factguestcheckin_s3 | additionalfield1 | Indicates if ''additionalfield1'' alert is raised on not when guest tries to checkin | BOOLEAN; | ||
bi_factguestcheckin_s3 | additionalfield2 | Indicates if ''additionalfield2'' alert is raised on not when guest tries to checkin | BOOLEAN; | ||
bi_factguestcheckin_s3 | trackingnotenabled | Indicates if ''trackingnotenabled'' alert is raised on not when guest tries to checkin | BOOLEAN; | ||
bi_factguestcheckin_s3 | crosscenterredemptionrestricted | Indicates if ''crosscenterredemptionrestricted'' alert is raised on not when guest tries to checkin | BOOLEAN; | ||
bi_factguestcheckin_s3 | usernomembership | Indicates if ''usernomembership'' alert is raised on not when guest tries to checkin | BOOLEAN; | ||
bi_factguestcheckin_s3 | usernoguestpass | Indicates if ''usernoguestpass'' alert is raised on not when guest tries to checkin | BOOLEAN; | ||
bi_factguestcheckin_s3 | userguestpassexpired | Indicates if ''userguestpassexpired'' alert is raised on not when guest tries to checkin | BOOLEAN; | ||
bi_factguestcheckin_s3 | userhostnotcheckedin | Indicates if ''userhostnotcheckedin'' alert is raised on not when guest tries to checkin | BOOLEAN; | ||
bi_factguestcheckin_s3 | guestpassuservisitsexceeded | Indicates if ''guestpassuservisitsexceeded'' alert is raised on not when guest tries to checkin | BOOLEAN; | ||
bi_factguestcheckin_s3 | guestpassuserperdayvisitsexceeded | Indicates if ''guestpassuserperdayvisitsexceeded'' alert is raised on not when guest tries to checkin | BOOLEAN; | ||
bi_factguestcheckin_s3 | uservisitsexceeded | Indicates if ''uservisitsexceeded'' alert is raised on not when guest tries to checkin | BOOLEAN; |