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.