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