ZenotiHelp

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 wid references DimCenter (service center)
  • payment center name references DimCenter (payment center)
  • invoice id references FactInvoice
  • invoice item id references FactInvoiceItem
  • item wid references DimItem
  • fact segment wid / factsegmentid references FactAppointmentSegment
  • groupid references 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.