Skip to main content

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.

httpreportszenoticomwp-contentuploads201902analyticsexpress_datamodel_tipsssgjpg.jpeg

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)