ZenotiHelp

Tips Payout Fact Table

ZTZenoti Docs Team Updated April 10, 2026 1 min readGuide

Records employee tip payout details by payment method (cash, check, custom, credit card, prepaid card) including payout status, sale date, and credit card fee adjustments.

Columns

Column Name Data Type Nullable Description
FactTipsPayoutwid BIGINT IDENTITY NOT NULL Surrogate key for the tips payout fact record.
FactTipsPOId BIGINT NULL Business/natural key for the tips payout.
TipsInvoicePK BIGINT NULL Source system primary key for the tips invoice.
InvoiceID VARCHAR(36) NULL Unique identifier (GUID) of the invoice.
EmployeeWid BIGINT NULL Foreign key to the employee user dimension.
Centerwid BIGINT NULL Foreign key to the center dimension.
CashTip FLOAT NULL Tip amount paid in cash.
CheckTip FLOAT NULL Tip amount paid by check.
CustomTip FLOAT NULL Tip amount paid via custom payment method.
CCTip FLOAT NULL Tip amount paid by credit card.
PrepaidCardTip FLOAT NULL Tip amount paid by prepaid card.
TotalTip FLOAT NULL Total tip amount across all payment methods.
paymentstatuswid BIGINT NULL Foreign key to the payment status dimension.
payoutDateInCenterTime DATETIME NULL Date and time of the payout in center timezone.
SaleDate DATE NULL Date of the original sale.
ProviderID NVARCHAR(64) NULL Identifier of the payment provider.
ConfiguredTypewid BIGINT NULL Foreign key to the configured type dimension.
etllogid BIGINT NULL ETL log identifier for audit trail.
AELastUpdatedDate DATETIME NULL Last updated date from the Accounting ETL source.
void BOOLEAN NULL Indicates whether the record has been voided.
myzenbatchdate TIMESTAMP YES MyZen batch processing date.
EarnedDate TIMESTAMP YES Date the tip was earned.
AdjustedCCTip FLOAT NULL Credit card tip amount after adjustments (e.g., CC fee deductions).
CCFees FLOAT NULL Credit card processing fees deducted from tips.
AdjustedTotalTip FLOAT NULL Total tip amount after credit card fee adjustments.

Note: All fact tables also include standard ETL metadata columns (podname, organizationid, groupid, etlCreatedDate) which are omitted from this reference for brevity.

Primary Key

FactTipsPayoutwid

Foreign Keys

Column References
EmployeeWid Bi_DimUser.userwid
Centerwid Bi_DimCenter.centerwid
SaleDate Bi_DimDate.datewid

Enumerator Values

Column Values
void FALSE = Active, TRUE = Voided
Was this article helpful?
Your feedback helps us improve our documentation.