Employee Tips SSG Consolidated
ZTZenoti Docs Team Updated April 10, 2026 4 min readGuide
Consolidated fact table storing employee tip and SSG (service-specific gratuity) details at the invoice item level, including commission percentages, tip amounts, and payment center information.
Columns
| Column Name | Data Type | Nullable | Description |
|---|---|---|---|
| organization name | VARCHAR(512) | YES | Name of the organization. Sourced from DimOrganization.organization name. |
| organization account name | VARCHAR(256) | YES | Account name of the organization. Sourced from DimOrganization.organization account name. |
| zone name | VARCHAR(800) | YES | Name of the geographic zone. Sourced from DimCenter.zone name. |
| center name | VARCHAR(128) | YES | Name of the center. Sourced from DimCenter.center name. |
| center city | VARCHAR(128) | YES | City where the center is located. Sourced from DimCenter.center city. |
| center zip | VARCHAR(32) | YES | ZIP/postal code of the center. Sourced from DimCenter.center zip. |
| center state name | VARCHAR(4096) | YES | State name of the center. Sourced from DimCenter.center state name. |
| country name | VARCHAR(4096) | YES | Country name of the center. Sourced from DimCenter.country name. |
| center company name | VARCHAR(200) | YES | Company name associated with the center. Sourced from DimCenter.center company name. |
| operating center | BOOLEAN | YES | Indicates whether the center is an operating center. Sourced from DimCenter.operating center. |
| center wid | BIGINT | YES | Warehouse identifier for the center. Sourced from DimCenter.center wid. |
| employee first name | VARCHAR(256) | YES | First name of the employee. Sourced from DimEmployee.employee first name. |
| employee last name | VARCHAR(256) | YES | Last name of the employee. Sourced from DimEmployee.employee last name. |
| employee middle name | VARCHAR(256) | YES | Middle name of the employee. Sourced from DimEmployee.employee middle name. |
| employee mobile phone | VARCHAR(64) | YES | Mobile phone number of the employee. Sourced from DimEmployee.employee mobile phone. |
| employee code | VARCHAR(128) | YES | Code for the employee. Sourced from DimEmployee.employee code. |
| employee - code | VARCHAR(512) | YES | Alternate employee code identifier. Sourced from DimEmployee.employee - code. |
| employee gender | VARCHAR(14) | YES | Gender of the employee. Sourced from DimEmployee.employee gender. |
| employee job name | VARCHAR(1020) | YES | Job title of the employee. Sourced from DimEmployee.employee job name. |
| employee job code | VARCHAR(1020) | YES | Job code of the employee. Sourced from DimEmployee.employee job code. |
| is employee inactive | BOOLEAN | YES | Indicates whether the employee is inactive. Sourced from DimEmployee.is employee inactive. |
| invoice created date | DATE | YES | Date the invoice was created. |
| invoice created date and time | TIMESTAMP WITHOUT TIME ZONE | YES | Date and time the invoice was created. |
| sale date | DATE | YES | Date of the sale. |
| sale date and time | DATE | YES | Date and time of the sale. |
| invoice closed date | DATE | YES | Date the invoice was closed. |
| invoice closed date and time | TIMESTAMP WITHOUT TIME ZONE | YES | Date and time the invoice was closed. |
| invoice status | VARCHAR(14) | YES | Status of the invoice. |
| invoice id | VARCHAR(36) | YES | Unique identifier for the invoice. |
| invoice item id | VARCHAR(36) | YES | Unique identifier for the invoice item. |
| tip adjusted date | TIMESTAMP WITHOUT TIME ZONE | YES | Date and time the tip was last adjusted. |
| tip | DOUBLE PRECISION | YES | Tip amount for the employee on this invoice item. |
| commission percentage | DOUBLE PRECISION | YES | Commission percentage applied to the employee. |
| ssg | DOUBLE PRECISION | YES | Service-specific gratuity (SSG) amount. |
| minutes to add | INTEGER | YES | Minute offset to convert UTC to center local time. |
| payment center name | VARCHAR(128) | YES | Name of the center where payment was collected. Sourced from DimCenter.center name. |
| payment center city | VARCHAR(128) | YES | City of the payment center. Sourced from DimCenter.center city. |
| payment center zip | VARCHAR(32) | YES | ZIP/postal code of the payment center. Sourced from DimCenter.center zip. |
| payment center state name | VARCHAR(4096) | YES | State name of the payment center. Sourced from DimCenter.center state name. |
| payment center country name | VARCHAR(4096) | YES | Country name of the payment center. Sourced from DimCenter.country name. |
| payment center company name | VARCHAR(200) | YES | Company name of the payment center. Sourced from DimCenter.center company name. |
| is payment center operating | BOOLEAN | YES | Indicates whether the payment center is an operating center. Sourced from DimCenter.operating center. |
| item name | VARCHAR(512) | YES | Name of the service/item. Sourced from DimItem.item name. |
| item code | VARCHAR(256) | YES | Code of the service/item. Sourced from DimItem.item code. |
| businessunit | VARCHAR(65535) | YES | Business unit the item belongs to. Sourced from DimItem.businessunit. |
| item tags | VARCHAR(65535) | YES | Tags associated with the item. Sourced from DimItem.item tags. |
| employee ssg percent | DOUBLE PRECISION | YES | Employee's SSG percentage allocation. |
| is split tip | INTEGER | YES | Indicates whether the tip was split among multiple employees (1=split, 0=not split). |
| item wid | BIGINT | YES | Warehouse identifier for the item. Sourced from DimItem.item wid. |
| fact segment wid | BIGINT | YES | Warehouse identifier for the appointment segment fact. |
| Center Code | VARCHAR(40) | YES | Code assigned to the center. Sourced from DimCenter.Center Code. |
| Payment Center Code | VARCHAR(40) | YES | Code assigned to the payment center. Sourced from DimCenter.Center Code. |
| Invoice No | VARCHAR(160) | YES | Human-readable invoice number. |
Primary Key
fact segment wid -- BIGINT warehouse surrogate key uniquely identifying each employee tips/SSG fact record.
Foreign Keys
center widreferences DimCenter (service center)payment center namereferences DimCenter (payment center)invoice idreferences FactInvoiceinvoice item idreferences FactInvoiceItemitem widreferences DimItemfact segment wid/factsegmentidreferences FactAppointmentSegmentgroupidreferences the tenant/data group
Enumerator Values
| Column Name | Known Values |
|---|---|
| invoice status | VARCHAR(14) |
| is split tip | INTEGER |
Standard ETL metadata columns (EtlLastUpdatedOn, EtlLastUpdatedBy, podname, groupid) are present in the underlying table but omitted from this reference for brevity.
Was this article helpful?
Your feedback helps us improve our documentation.