Employee Hourly Pay 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 whether 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, 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 the center where the employee's payroll is generated.

etl created date

The date on which the record was created in Analytics.

timestamp

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 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 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

Hourly Pay

These fields detail out the hourly pay and service commission information associated with the corresponding employee and pay period.

total hours

The total hours of work for the employee in the pay period. Note: Calculation of this field is as per the 'Total Hours' column in the 'Employee Payroll Summary' report in the core system.

For more information, refer: Employee Payroll Summary Report

float

Hourly Pay

These fields detail out the hourly pay and service commission information associated with the corresponding employee and pay period.

total hourly pay

The total pay as per regular and overtime hourly rate for the employee in the pay period. Note: Calculation of this field is as per the 'Total Hourly Pay' column in the 'Employee Payroll Summary' report in the core system.

For more information, refer: Employee Payroll Summary Report

decimal(19,4)

Hourly Pay

These fields detail out the hourly pay and service commission information associated with the corresponding employee and pay period.

service hours

The total hours utilized to perform services by the employee in the pay period. Only closed appointments are considered. Note: Calculation of this field is as per the 'Service Hours' column in the 'Employee Payroll Summary' report in the core system.

For more information, refer: Employee Payroll Summary Report

float

Hourly Pay

These fields detail out the hourly pay and service commission information associated with the corresponding employee and pay period.

interval type

The interval at which overtime hours are configured. Possible values are: - Daily - Weekly - Pay Period

For more information, refer: Configure Employee Overtime

varchar(50)

Hourly Pay

These fields detail out the hourly pay and service commission information associated with the corresponding employee and pay period.

service commission

The service commission earned by the employee in the pay period. Service commission includes Add-On commission and Request Therapist Bonus.

For more information, refer: Employee Payroll Summary Report

decimal(19,4)

Hourly Pay

These fields detail out the hourly pay and service commission information associated with the corresponding employee and pay period.

consider hourly pay

Indicates whether hourly pay should be considered while generating the corresponding payroll. This honors the 'Calculate employee pay based on higher of total hourly pay and service commission' setting in the core system.

For more information, refer: Employee Payroll Summary Report

boolean

Hourly Pay

These fields detail out the hourly pay and service commission information associated with the corresponding employee and pay period.

consider service commission

Indicates whether service commission should be considered while generating the corresponding payroll. This honors the 'Calculate employee pay based on higher of total hourly pay and service commission' setting in the core system.

boolean

Hourly Pay

These fields detail out the hourly pay and service commission information associated with the corresponding employee and pay period.

Production Hours

Number of production hours of an employee in pay period

DECIMAL(19,4)

Hourly Pay

These fields detail out the hourly pay and service commission information associated with the corresponding employee and pay period.

Non Production Hours

Number of non production hours of an employee in pay period

DECIMAL(19,4)

Hourly Pay

These fields detail out the hourly pay and service commission information associated with the corresponding employee and pay period.

Overtime Hours

Multiplying factor to arrive at overtime pay per hour from normal pay per hour. This value is set in the product.

FLOAT

Hourly Pay

These fields detail out the hourly pay and service commission information associated with the corresponding employee and pay period.

Overtime HourlyPay

Total amount of pay earned by employee through overtime hours

DECIMAL(19,4)

Hourly Pay

These fields detail out the hourly pay and service commission information associated with the corresponding employee and pay period.

Overtime Multiplier

Multiplying factor to arrive at overtime pay per hour from normal pay per hour. This value is set in the product.

FLOAT

Employee

These fields detail the attributes of the employee whose payroll information is populated.

Employee base center

Number of employee base center of an employee in pay period

VARCHAR(128)

Hourly Pay

These fields detail out the hourly pay and service commission information associated with the corresponding employee and pay period.

"declared tip"

Amount of tips received outside invoice and declared by employee

numeric(19,4)

Hourly Pay

These fields detail out the hourly pay and service commission information associated with the corresponding employee and pay period.

"deductions on total commission"

Displays the deduction on the total commission the employee earned in the pay period.

float8

Hourly Pay

These fields detail out the hourly pay and service commission information associated with the corresponding employee and pay period.

"hourly or service"

Indicates if the payment is to be based on hourly pay or service commission.

varchar(2048)

Hourly Pay

These fields detail out the hourly pay and service commission information associated with the corresponding employee and pay period.

"hourly rate"

The hourly rate or charges of the employee.

float8

Pay Period

These fields detail out the time period for which the payroll is calculated.

"interval end date"

end date of the week

timestamp

Pay Period

These fields detail out the time period for which the payroll is calculated.

"interval start date"

start date of the week

timestamp

Hourly Pay

These fields detail out the hourly pay and service commission information associated with the corresponding employee and pay period.

"max of hourly pay or service commission value"

Indicates the maximum payment amount that can be made in lieu of hourly pay or service commission.

float8

Hourly Pay

These fields detail out the hourly pay and service commission information associated with the corresponding employee and pay period.

"max of hourly pay or service commission"

Indicates if the payment is to be based on the higher amount between hourly pay or service commission.

boolean

Hourly Pay

These fields detail out the hourly pay and service commission information associated with the corresponding employee and pay period.

"no of invoices"

Displays the total number of closed invoices in which the employee has sold at least one item.

Note: The # Invoices it is not the number of items sold by the employee, but the number of invoices in which they have sold at least one sales item such as performing a service, or selling a product, membership, package, or gift card.

integer

Hourly Pay

These fields detail out the hourly pay and service commission information associated with the corresponding employee and pay period.

"no of requested"

Displays the number of times guests requested for a particular employee to perform a service and where the invoice was closed.

integer

Hourly Pay

These fields detail out the hourly pay and service commission information associated with the corresponding employee and pay period.

"no of services"

Displays the number of services the employee has closed or performed.

integer

Hourly Pay

These fields detail out the hourly pay and service commission information associated with the corresponding employee and pay period.

"non service commission"

The non-service commission earned by the employee in the pay period.

float8

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 id"

Unique identifier for an organization

varchar(36)

Hourly Pay

These fields detail out the hourly pay and service commission information associated with the corresponding employee and pay period.

"overtime pay"

Do not use this column

numeric(19,4)

Hourly Pay

These fields detail out the hourly pay and service commission information associated with the corresponding employee and pay period.

"rt bouns"

Request Therapist Bonus. Displays the total amount an employee earns as a bonus in the selected pay period because a guest requested a particular employee to perform a service and where the invoice was closed. Read: Employee Overtime and Therapist Request Bonus

Requested Therapist Bonus is configured in the Employee profile: Employee > Employees > [Employee Name] > General > Requested Therapist Bonus.

The Requested Therapist Bonus for the pay period is calculated as follows: Requested (total number of requests for the therapist) x Requested Therapist Bonus (from the employee profile).

float8

Hourly Pay

These fields detail out the hourly pay and service commission information associated with the corresponding employee and pay period.

"service and invoice level deductions"

Displays the deduction at service and invoice level from the commission the employee earned.

float8

Hourly Pay

These fields detail out the hourly pay and service commission information associated with the corresponding employee and pay period.

"tips paid amount through zenoti"

Amount of tips paid directly to Service provider card/wallet through Zwallet feature

numeric(19,4)

Hourly Pay

These fields detail out the hourly pay and service commission information associated with the corresponding employee and pay period.

"total hours with rounding"

Indicates if total hours is to arrived at, with rounding off.

float8

Hourly Pay

These fields detail out the hourly pay and service commission information associated with the corresponding employee and pay period.

salary

Salary per pay period of the corresponding employee.

float8

Hourly Pay

These fields detail out the hourly pay and service commission information associated with the corresponding employee and pay period.

ssg

Support Staff Gratuity. Displays the total SSG amount the employee earns as SSG (gratuity or service charge) on closed invoices in the selected pay period.

float8

Hourly Pay

These fields detail out the hourly pay and service commission information associated with the corresponding employee and pay period.

tip

Total tips the employee earns in the selected pay period.

float8