ZenotiHelp

Employee Tips And SSG Details Fact Table

ZTZenoti Docs Team Updated April 10, 2026 1 min readGuide

Captures employee tip and service surcharge (SSG) detail records per invoice item, including split tip indicators, SSG percentages, and payment center information.

Columns

Column Name Data Type Nullable Description
factsegmentwid BIGINT IDENTITY NOT NULL Surrogate key for the tips and SSG detail fact record
factsegmentid BIGINT NULL Business/natural key for the fact segment
centerwid BIGINT NULL Foreign key to the center dimension
invoiceid VARCHAR(36) NULL Unique identifier (GUID) of the invoice
invoiceitemid VARCHAR(36) NULL Unique identifier (GUID) of the invoice item
employeewid BIGINT NULL Foreign key to the employee user dimension
tip NUMERIC(19,4) NULL Tip amount for the employee
ssg NUMERIC(19,4) NULL Service surcharge (SSG) amount for the employee
podid INTEGER NULL Identifier of the source pod/database
void INTEGER NULL Indicates whether the record has been voided
lastupdated TIMESTAMP NULL Timestamp of the last update to the source record
paymentcenterwid BIGINT NULL Foreign key to the center where payment was collected
paymentdateincenter DATE NULL Payment date in center timezone
paymentdatetimeincenter TIMESTAMP NULL Payment date and time in center timezone
itemwid BIGINT NULL Foreign key to the item dimension
transactionid VARCHAR(36) NULL Unique identifier (GUID) for the payment transaction
employeessgpercent DOUBLE PRECISION NULL SSG percentage assigned to the employee
issplittip INTEGER NULL Flag indicating if the tip was split among employees
invoiceno VARCHAR(160) NULL Human-readable invoice number

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

Primary Key

factsegmentwid

Foreign Keys

Column References
centerwid Bi_DimCenter.centerwid
paymentcenterwid Bi_DimCenter.centerwid
employeewid Bi_DimUser.userwid
paymentdateincenter Bi_DimDate.datewid

Enumerator Values

Column Values
void 0 = active, non-zero = voided
issplittip 1 = tip was split, 0 = not split
Was this article helpful?
Your feedback helps us improve our documentation.