Tips payout fact table
Bi_FactTipsPayout
Field | Field type | Description | Primary Key | Mapped Dimension table Dimension table field | |
|---|---|---|---|---|---|
FactTipsPayoutwid | BIGINT | Unique identifer for the row. Primary key | Yes | ||
FactTipsPOId | BIGINT | Unique GUID for the row | |||
TipsInvoicePK | BIGINT | GUID for Zenoti internal tables. | |||
InvoiceID | VARCHAR(36) | Unique identifier for the invoice | |||
EmployeeWid | BIGINT | unique identifier for the employee. | bi_dimuser userwid | ||
Centerwid | BIGINT | unique identifier for the center | bi_dimcenter centerwid | ||
CashTip | FLOAT | Amount of cash tip earned by employee for the invoice | |||
CheckTip | FLOAT | Amount of check tip earned by employee for the invoice | |||
CustomTip | FLOAT | Amount of custom tip earned by employee for the invoice | |||
CCTip | FLOAT | Amount of tip earned by employee though credit card for the invoice | |||
PrepaidCardTip | FLOAT | Amount of tip earned by employee thorugh prepaid card for the invoice | |||
TotalTip | FLOAT | Total tips earned by employee for the invoice | |||
paymentstatuswid | BIGINT | identifier to indicate the status of tips Payout | |||
payoutDateInCenterTime | DATETIME | Date on which tips earned through the invoice are paid out to employee | |||
SaleDate | DATE | Date on which sale is made | |||
ProviderID | NVARCHAR(64) | indicates the payment service providername (MyZen, ADP,etc..) | |||
ConfiguredTypewid | BIGINT | identifier to indicate the type of tips configured to be paid out through provider service. Indicates what type of tips are eligible for tips payout. | Dimstatus statusname = configuration type. Column name = status value | ||
EtlCreatedBy | BIGINT | Userid who created the data sync between core system and Redshift. Internal to Zenoti | |||
etllogid | bigint | Internal to Zenoti ETL process | |||
AELastUpdatedDate | datetime | Date on which source table is last updated. Internal to Zenoti | |||
EtlCreatedDate | DATETIME | Date on which row is created in the table. Internal to Zenoti | |||
void | BOOLEAN | Indicates if row is void. 1- void, 0- not void | |||
podname | VARCHAR(20) | Region in which customer is hosted. Internal to Zenoti | |||
organizationid | VARCHAR(36) | Unique identifier for an Organization. To be mapped with Organizationid in bi_dimcenter | bi_dimcenter organizationid | ||
mezenbatchdate | timestamp | Date on which tips payout batch is created to process the day’s tips to credit to employee account | |||
earneddate | DATETIME | Date on which provider provided service and earned tips and batch is created to process tips payout | |||
groupid | Internal to Zenoti. Used for data processing. | BIGINT | |||