S3_Tips payout fact table
Bi_FactTipsPayout_s3
Field | Field type | Description | Primary Key | Mapped Dimension table Dimension table field | |
|---|---|---|---|---|---|
FactTipsPOId | DECIMAL(19,0) | Unique GUID for the row. Primary Key | yes | ||
TipsInvoicePK | DECIMAL(19,0) | GUID for Zenoti internal tables. | |||
InvoiceID | VARCHAR(36) | Unique identifier for the invoice | |||
EmployeeID | VARCHAR(36) | unique identifier for the employee. | bi_dimuser userid | ||
CenterID | VARCHAR(36) | unique identifier for the center | bi_dimcenter centerid | ||
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 | |||
paymentStatus | INT | identifier to indicate the status of tips Payout | |||
payoutDateInCenterTime | TIMESTAMP | Date on which tips earned through the invoice are paid out to employee | |||
SaleDate | DATE | Date on which sale is made | |||
ProviderID | NVARCHAR(256) | indicates the payment service providername (MyZen, ADP,etc..) | |||
ConfiguredType | DECIMAL(19,0) | 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 | DECIMAL(19,0) | Userid who created the data sync between core system and Redshift. Internal to Zenoti | |||
etllogid | DECIMAL(19,0) | Internal to Zenoti ETL process | |||
AELastUpdatedDate | TIMESTAMP | Date on which source table is last updated. Internal to Zenoti | |||
etlCreatedDate | TIMESTAMP | 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 | ||
myzenbatchdate | TIMESTAMP | Date on which tips payout batch is created to process the day’s tips to credit to employee account | |||
EarnedDate | TIMESTAMP | 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 | |||
adjustedcctip | Total credit card tip excluding tips convenience fee | float | |||
ccfees | Tips convience fee | float | |||
adjustedtotaltip | Total tip earned excluding tips convenience fee | float | |||
tipsconveniencefee | Processing fee levied on credit card tips | float | |||