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.