Employee Salary Data Model

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)