ZenotiHelp

Employee Salary Data Model

ZTZenoti Docs Team Updated June 28, 2026 6 min readGuide

An employee's earnings in Zenoti can have five main components:

  • Salary
  • Hourly Pay
  • Commissions
  • Tips
  • SSG

Further, commissions are of three types:

  • Sales Commissions
  • Tenure Commissions
  • Center Commissions

This data source brings in details of each employee's salary, tenure commissions, and center commissions by pay period.

  • Salary by employee for each pay period
  • Center commission by employee for each pay period
  • Tenure commission by employee for each pay period

At the most granular level- data is organized by pay period for each employee.

Note If a particular payroll for a past period is regenerated in the core system, the corresponding row in the data source gets deleted and a new row populated with details as per the regeneration date.

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 the center where the employee's payroll is generated. 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 the center where the employee's payroll is generated. 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 the center where the employee's payroll is generated. center name The center where the corresponding employee's payroll is generated. varchar(128)
Center, Zone, Organization An organization can be divided into zones, which can be further divided into centers. Here, we refer to the center where the employee's payroll is generated. 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 the center where the employee's payroll is generated. 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 the center where the employee's payroll is generated. 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 the center where the employee's payroll is generated. center state name The state where the center is located. varchar(4096)
Center, Zone, Organization An organization can be divided into zones, which can be further divided into centers. Here, we refer to the center where the employee's payroll is generated. country name The country where the center is located. varchar(4096)
Center, Zone, Organization An organization can be divided into zones, which can be further divided into centers. Here, we refer to the center where the employee's payroll is generated. operating center A flag that indicates if the center is operational. True: Operational False: Not operational boolean
Center, Zone, Organization An organization can be divided into zones, which can be further divided into centers. Here, we refer to the center where the employee's payroll is generated. 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. So this field is needed to arrive at the center time. This is not needed for timestamps that are in the datasource directly, those are already in the center time zone. int4
Employee These fields detail the attributes of the employee whose payroll information is populated. employee first name First name of the employee as per employee profile. varchar(160)
Employee These fields detail the attributes of the employee whose payroll information is populated. employee middle name Middle name of the employee as per employee profile. varchar(128)
Employee These fields detail the attributes of the employee whose payroll information is populated. employee last name Last name of the employee as per employee profile. varchar(256)
Employee These fields detail the attributes of the employee whose payroll information is populated. employee mobile phone Mobile number of the employee as per employee profile. varchar(64)
Employee These fields detail the attributes of the employee whose payroll information is populated. employee - code Unique code of 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 whose payroll information is populated. employee gender The gender of the employee. Possible values: - Male - Female - Not applicable varchar(14)
Employee These fields detail the attributes of the employee whose payroll information is populated. employee job name Job name associated with the employee. Therapist, Manager, Aesthetician etc. varchar(1020)
Employee These fields detail the attributes of the employee whose payroll information is populated. is employee inactive A flag indicating if 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 whose payroll information is populated. 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
Pay Period These fields detail out the time period for which the payroll is calculated. Pay Period Name The name of the payroll generation period. varchar(254)
Pay Period These fields detail out the time period for which the payroll is calculated. Payroll Start Date The start date of the payroll period. Timestamp
Pay Period These fields detail out the time period for which the payroll is calculated. Payroll End Date The end date of the payroll period. Timestamp
Salary and Commissions These fields detail out the salary and commission-related details associated with the respective employee for the corresponding pay period. Salary Salary per pay period of the corresponding employee. For more information, refer Add Job Info for a New Employee varchar(14)
Salary and Commissions These fields detail out the salary and commission-related details associated with the respective employee for the corresponding pay period. Tenue Bonus Employees may earn commissions when they complete a given number of years at their company. This is called a tenure-based commission. This field populates the total Tenure Commission for the employee in the pay period. For more information, refer Configure Tenure Based Commissions varchar(36)
Salary and Commissions These fields detail out the salary and commission-related details associated with the respective employee for the corresponding pay period. Center Commission Employees may receive commissions when their center achieves a given target or newly-opened centers may want to boost morale by offering a commission to all employees for the first three months after opening. This is called a center-based commission. This field populates the total Center Commission for the employee in the pay period. varchar(40)
Salary and Commissions These fields detail out the salary and commission-related details associated with the respective employee for the corresponding pay period. Redo Penalty When a guest is not entirely pleased with their service, the center may offer to perform either the same service or another service for free or at a discounted price. Zenoti’s Redo Appointment functionality enables the center to mark a service as a redo service and process a reversal of the initial service provider’s commission. This field populates the amount that is to be deducted from the initial service provider's commission. varchar(36)
Salary and Commissions These fields detail out the salary and commission-related details associated with the respective employee for the corresponding pay period. Employee Total Deduction Commission deductions can be set up on the total commission that an employee earns during a pay period. This field displays the amount that is to be deducted from the total commission of the employee in the corresponding pay period. For more information, refer Set Up Commission Deductions for Invoices and Total Commissions varchar(21)
Was this article helpful?
Your feedback helps us improve our documentation.