User guest pass fact table
Bi_FactUserGuestPass_s3
Field | Description | Field type | Primary key | Mapped Dimension table Mapped Dimension field | |
FactUserGuestPassID | Unique identifer for the row. Primary Key | DECIMAL(19,0) | Yes | ||
UserGuestPassPK | Unique identifer for the guest pass. Internal to Zenoti | DECIMAL(19,0) | |||
UserGuestPassID | Unique identifer for the guest pass | VARCHAR(36) | |||
BenefitTransferFK | Internal to Zenoti | DECIMAL(19,0) | |||
HostuserID | UserID of member who shared guest pass to a guest | VARCHAR(36) | Bi_dimuser_s3 userwid | ||
Usermembershipid | Unique identifier of the membership sold to user. Unique for a member and membership | VARCHAR(36) | |||
InviteeUserId | userID of guest who received guest pass | VARCHAR(36) | Bi_dimuser_s3 userwid | ||
CenterId | Unique Identifer for the center | VARCHAR(36) | bi_dimcenter_s3 centerid | ||
OrganizationId | Unique identifier for the organization | VARCHAR(36) | bi_dimcenter_s3 organizationid | ||
Status | Indicates status of guest pass | INT | |||
statusdesc | Description of status populated in "status" column | VARCHAR(50) | |||
Void | Indicates if row is void or not. 0-active, 1- void | BOOLEAN | |||
Sharedon | Date on which guest pass is shared with a user | TIMESTAMP | |||
ExpiresOn | Date on which guest pass will expire | TIMESTAMP | |||
CategoryID | ID of the category of class/workshop guest pass is utilized for | VARCHAR(36) | |||
CategoryName | Name of the category of class/workshop guest pass is utilized for | NVARCHAR(512) | |||
RegistrationId | Registration ID for the class which guest registered using GuestPass | VARCHAR(36) | |||
etlCreatedBy | System user which created/updated the row. Internal to Zenoti | DECIMAL(19,0) | |||
etlCreatedDate | Date and Time on which row is updated | TIMESTAMP | |||
podname | Identifer for the region customer belongs to. Internal to Zenoti | VARCHAR(20) | |||
groupid | Internal to Zenoti. Used for data processing. | BIGINT | |||