Tips and SSG data model
An employee's earnings in Zenoti can have five main components:
Salary
Hourly Pay
Commissions
Tips
SSG
This data source brings in details of the tips and SSG received by employees. It only brings in invoice items where a tip or SSG was received by an employee. For example, if an invoice has three services and a tip was given only for two services, only details of those two services are brought in to the data source.
Example use-cases
Total value of tips and SSG given to employees
Tips by employee and item
Total value of adjusted tips
Note
Tip and SSG payments can be adjusted after the date of the initial payment. Whenever this happens, the data source brings in the adjusted entries as of the day of adjustment.
Granularity of the data
At the most granular level- data is organized by invoice item. For day packages, the items within the day package are further split into rows. Only invoice items where a tip or SSG is received are brought in to this data source. If multiple employees receive tips or SSG for the same invoice item, the rows are further split out to accommodate this granularity. In the example below, Invoice '1ABC' has one item 'Stress Buster'. On Jan 24th, Sajana received a tip of $13.8 for this item. On Jan 27th, this tip was adjusted and transferred to Shova. Hence, there is a negative entry for Sajana on the 27th and a corresponding positive entry for Shova. The next Invoice '1XYZ' contains a day package with Invoice Item ID '1XYZ11'. There are three items within the day package - Freelife, Relax, and Rejuvenate. Lily received a tip of $10.6, $3.4 and $13.8 for these three items respectively.
![]() |
Note
Tip and SSG payments can be adjusted after the date of the initial payment. Whenever this happens, the data source brings in the adjusted entries as of the day of adjustment.
Group | Description | Field | New Definition | Examples/Notes | Data Type |
---|---|---|---|---|---|
Center, Zone, Organization | An organization can be divided into zones, which can be further divided into centers. Here, we refer to two types of centers. 1. Center: Center where the invoice is created. 2. Payment Center: Center where the payment is done. | organization name | The formal name of the organization. | 'Massage Spa Express' is the formal name of an organization. | varchar(512) |
Center, Zone, Organization | An organization can be divided into zones, which can be further divided into centers. Here, we refer to two types of centers. 1. Center: Center where the invoice is created. 2. Payment Center: Center where the payment is done. | organization account name | The domain name of the organization in Zenoti. | If you use this URL to log in to Zenoti 'https://massagespa.zenoti.com', then massagespa is your account name. The formal name and domain name may be different. | varchar(256) |
Center, Zone, Organization | An organization can be divided into zones, which can be further divided into centers. Here, we refer to two types of centers. 1. Center: Center where the invoice is created. 2. Payment Center: Center where the payment is done. | center name | The center where the invoice is created. | varchar(128) | |
Center, Zone, Organization | An organization can be divided into zones, which can be further divided into centers. Here, we refer to two types of centers. 1. Center: Center where the invoice is created. 2. Payment Center: Center where the payment is done. | center wid | A unique identifier, in Analytics, for the center. It does not exist in the core system. | bigint | |
Center, Zone, Organization | An organization can be divided into zones, which can be further divided into centers. Here, we refer to two types of centers. 1. Center: Center where the invoice is created. 2. Payment Center: Center where the payment is done. | zone name | The zone to which the center belongs. | varchar(800) | |
Center, Zone, Organization | An organization can be divided into zones, which can be further divided into centers. Here, we refer to two types of centers. 1. Center: Center where the invoice is created. 2. Payment Center: Center where the payment is done. | center city | The city where the center is located. | varchar(128) | |
Center, Zone, Organization | An organization can be divided into zones, which can be further divided into centers. Here, we refer to two types of centers. 1. Center: Center where the invoice is created. 2. Payment Center: Center where the payment is done. | center zip | Zipcode of the center's location. | varchar(32) | |
Center, Zone, Organization | An organization can be divided into zones, which can be further divided into centers. Here, we refer to two types of centers. 1. Center: Center where the invoice is created. 2. Payment Center: Center where the payment is done. | center state name | The state where the center is located. | varchar(1024) | |
Center, Zone, Organization | An organization can be divided into zones, which can be further divided into centers. Here, we refer to two types of centers. 1. Center: Center where the invoice is created. 2. Payment Center: Center where the payment is done. | country name | The country where the center is located. | varchar(1024) | |
Center, Zone, Organization | An organization can be divided into zones, which can be further divided into centers. Here, we refer to two types of centers. 1. Center: Center where the invoice is created. 2. Payment Center: Center where the payment is done. | center company name | The name with which the center is registered. | varchar(200) | |
Center, Zone, Organization | An organization can be divided into zones, which can be further divided into centers. Here, we refer to two types of centers. 1. Center: Center where the invoice is created. 2. Payment Center: Center where the payment is done. | operating center | A flag that indicates whether the center is operational. - True: Indicates operational - False: indicates not operational | boolean | |
Center, Zone, Organization | An organization can be divided into zones, which can be further divided into centers. Here, we refer to two types of centers. 1. Center: Center where the invoice is created. 2. Payment Center: Center where the payment is done. | minutes to add | The number of minutes that need to be added to UTC time to get the current time at the center. Timestamps that are generated by Tableau [E.g. if you use filters such as Today, Tomorrow, etc.] are in UTC, hence this field is needed to arrive at the center time. This is not needed for timestamps that are in the datasource directly, these are already in the center time zone. | int4 | |
Center, Zone, Organization | An organization can be divided into zones, which can be further divided into centers. Here, we refer to two types of centers. 1. Center: Center where the invoice is created. 2. Payment Center: Center where the payment is done. | payment center name | The center where the payment for the tip or SSG is done. | In some cases, this can be different from the center where the invoice is created. | varchar(128) |
Center, Zone, Organization | An organization can be divided into zones, which can be further divided into centers. Here, we refer to two types of centers. 1. Center: Center where the invoice is created. 2. Payment Center: Center where the payment is done. | payment center city | The city where the payment center is located. | varchar(128) | |
Center, Zone, Organization | An organization can be divided into zones, which can be further divided into centers. Here, we refer to two types of centers. 1. Center: Center where the invoice is created. 2. Payment Center: Center where the payment is done. | payment center zip | Zipcode of the payment center's location. | varchar(32) | |
Center, Zone, Organization | An organization can be divided into zones, which can be further divided into centers. Here, we refer to two types of centers. 1. Center: Center where the invoice is created. 2. Payment Center: Center where the payment is done. | payment center state name | The state where the payment center is located. | varchar(1024) | |
Center, Zone, Organization | An organization can be divided into zones, which can be further divided into centers. Here, we refer to two types of centers. 1. Center: Center where the invoice is created. 2. Payment Center: Center where the payment is done. | payment center country name | The country where the payment center is located. | varchar(1024) | |
Center, Zone, Organization | An organization can be divided into zones, which can be further divided into centers. Here, we refer to two types of centers. 1. Center: Center where the invoice is created. 2. Payment Center: Center where the payment is done. | payment center company name | The name with which the payment center is registered. | varchar(200) | |
Center, Zone, Organization | An organization can be divided into zones, which can be further divided into centers. Here, we refer to two types of centers. 1. Center: Center where the invoice is created. 2. Payment Center: Center where the payment is done. | is payment center operating | A flag that indicates whether the payment center is operational. - True: Indicates operational - False: Indicates not operational | boolean | |
Invoice & Item | These fields detail out the item and invoice for which the employee received the tip or SSG. | item name | The name of the item. For example, if item type code = Service, then item name is the name of the service. If item type code = Product, then item name is the name the product. | varchar(512) | |
Invoice & Item | These fields detail out the item and invoice for which the employee received the tip or SSG. | item code | The unique code of the item sold. For example, if item type code = Service, then item code is the code associated with that service. If item type code = Product, then item code is the code associated with that product. It is slightly different for a gift card. If item type code = Gift card, then item code is unique for every gift card sold. | varchar(256) | |
Invoice & Item | These fields detail out the item and invoice for which the employee received the tip or SSG. | item wid | A unique identifier for the item in Analytics. This is generated by Analytics and does not exist in the core system. | ||
Invoice & Item | These fields detail out the item and invoice for which the employee received the tip or SSG. | item tags | The tags associated with the item. | Tags can be created for a service, product, package, or membership in the Organization view. These will be comma separated values if there are multiple tags. | varchar(65535) |
Invoice & Item | These fields detail out the item and invoice for which the employee received the tip or SSG. | businessunit | The business unit to which the item belongs. | varchar(65535) | |
Invoice & Item | These fields detail out the item and invoice for which the employee received the tip or SSG. | invoice id | The unique identifier for the invoice within the organization. | varchar(36) | |
Invoice & Item | These fields detail out the item and invoice for which the employee received the tip or SSG. | InvoiceNo | Invoice number that helps in identifying and tracking the invoice. | ||
Invoice & Item | These fields detail out the item and invoice for which the employee received the tip or SSG. | invoice item id | The unique identifier for each line item within the invoice. | varchar(36) | |
Invoice & Item | These fields detail out the item and invoice for which the employee received the tip or SSG. | invoice status | This indicates whether the invoice is open or closed. | varchar(14) | |
Invoice & Item | These fields detail out the item and invoice for which the employee received the tip or SSG. | invoice created date | The date on which the invoice item was added into the invoice. | date | |
Invoice & Item | These fields detail out the item and invoice for which the employee received the tip or SSG. | invoice created date and time | The date and time at which the invoice item was added into the invoice. | timestamp | |
Invoice & Item | These fields detail out the item and invoice for which the employee received the tip or SSG. | sale date | For Service item type, this is the date on which the service was performed. For other item types, this is the date on which the item was added to the invoice. | date | |
Invoice & Item | These fields detail out the item and invoice for which the employee received the tip or SSG. | sale date and time | For Service item type, this is the date and time at which the service was performed. For other item types, this is the date and time at which the item was added to the invoice. | timestamp | |
Invoice & Item | These fields detail out the item and invoice for which the employee received the tip or SSG. | invoice closed date | The date on which the invoice was closed. | date | |
Invoice & Item | These fields detail out the item and invoice for which the employee received the tip or SSG. | invoice closed date and time | The date and time at which the invoice was closed. | timestamp | |
Employee | These fields detail the attributes of the employee who received the tip or SSG. | employee first name | First name of the employee as per employee profile. | varchar(160) | |
Employee | These fields detail the attributes of the employee who received the tip or SSG. | employee middle name | Middle name of the employee as per employee profile. | varchar(128) | |
Employee | These fields detail the attributes of the employee who received the tip or SSG. | employee last name | Last name of the employee as per employee profile. | varchar(256) | |
Employee | These fields detail the attributes of the employee who received the tip or SSG. | employee mobile phone | Mobile number of the employee as per employee profile. | varchar(64) | |
Employee | These fields detail the attributes of the employee who received the tip or SSG. | employee - code | Unique code for the employee. This is the code taken from the employee's profile in Zenoti. | varchar(128) | |
Employee | These fields detail the attributes of the employee who received the tip or SSG. | employee gender | The gender of the employee. | Possible values: - Male - Female - Not applicable | varchar(14) |
Employee | These fields detail the attributes of the employee who received the tip or SSG. | employee job name | Job name associated with the employee. | Therapist, Manager, Aesthetician etc. | varchar(1020) |
Employee | These fields detail the attributes of the employee who received the tip or SSG. | employee job code | Unique code associated with the employee's job. | varchar(1020) | |
Employee | These fields detail the attributes of the employee who received the tip or SSG. | is employee inactive | A flag indicating whether the employee is inactive. An employee is considered inactive if they have been removed from the system. - True: Employee is inactive - False: Employee is active | boolean | |
Employee | These fields detail the attributes of the employee who received the tip or SSG. | employee code | Unique code of the employee. This is the code from the employee's guest profile. When an employee's profile is created, Zenoti automatically creates their guest profile. Note: The 'employee code' is usually the same as 'employee - code' unless someone manually changes it in the employee's guest profile. | DO NOT USE- THIS FIELD IS BEING DEPRECATED | |
Tip and SSG | These fields detail out the tip and SSG received by the employee. | tip adjusted date | The date of payment of the tip or SSG. If the tip or SSG get adjusted after the date of payment, this field contains the date of the adjustment. | timestamp | |
Tip and SSG | These fields detail out the tip and SSG received by the employee. | tip | The tip amount for the corresponding employee and invoice item. | numeric(19,4) | |
Tip and SSG | These fields detail out the tip and SSG received by the employee. | ssg | The SSG amount for the corresponding employee and invoice item. The 'employee SSG percent' field has to be applied on this to get the final SSG that the employee receives. | Example: If 'SSG' of $10 is collected on an item and the 'Employee SSG Percent' is set as 50%, the employee will receive $5 from the SSG collected. | numeric(19,4) |
Tip and SSG | These fields detail out the tip and SSG received by the employee. | employee ssg percent | The percentage of SSG that the employee is eligible for. This is a setting in the core system. This has to be applied on the 'SSG' field to get the final SSG that the employee receives. | Example: If 'SSG' of $10 is collected on an item and the 'Employee SSG Percent' is set as 50%, the employee will receive $5 from the SSG collected. | float8 |
Tip and SSG | These fields detail out the tip and SSG received by the employee. | is split tip | A flag that indicates whether the tip was generated using the split tips feature in Zenoti. - True: Tip was generated using the Split Tips feature. - False: Tip was not generated using the Split Tips feature. | integer | |
Tip and SSG | These fields detail out the tip and SSG received by the employee. | commission percentage | This field determines the split of tips for items within day packages. For items other than day packages, this value is always 100% or -100%. | Example: If a tip of $25 is collected on a day package which has three services and if the services receive $15, $5, and $5 as tips, then the commission percentage for the three services would be 60, 20, and 20 respectively. | numeric(38,19) |