ZenotiHelp

Employee Ranking Consolidated

ZTZenoti Docs Team Updated April 10, 2026 4 min readGuide

Consolidated table storing daily employee performance ranking metrics including ticket counts, sales, discounts, taxes, guest counts, and production hours per center.

Columns

Column Name Data Type Nullable Description
organization account name VARCHAR(256) YES Account name of the organization. Sourced from DimOrganization.organization_account_name.
center name VARCHAR(256) YES Name of the center. Sourced from DimCenter.center_name.
zone name VARCHAR(256) YES Name of the zone. Sourced from DimZone.zone_name.
ct date DATE YES Reporting date for the employee ranking data.
employee first name VARCHAR(256) YES First name of the employee. Sourced from DimEmployee.employee_first_name.
employee last name VARCHAR(256) YES Last name of the employee. Sourced from DimEmployee.employee_last_name.
employee middle name VARCHAR(256) YES Middle name of the employee. Sourced from DimEmployee.employee_middle_name.
employee code VARCHAR(256) YES Code assigned to the employee. Sourced from DimEmployee.employee_code.
service parent category VARCHAR(256) YES Parent category of the service. Sourced from DimService.service_parent_category.
service category VARCHAR(256) YES Category of the service. Sourced from DimService.service_category.
total ticket count INTEGER YES Total number of tickets for the employee.
retail sale price FLOAT YES Total retail sale price.
retail discount applied FLOAT YES Total retail discount applied.
retail tax FLOAT YES Total retail tax amount.
retail refund sale price FLOAT YES Total retail refund sale price.
retail refund discount applied FLOAT YES Total retail refund discount applied.
retail refund tax FLOAT YES Total retail refund tax amount.
service sale price FLOAT YES Total service sale price.
service discount applied FLOAT YES Total service discount applied.
service tax FLOAT YES Total service tax amount.
service refund sale price FLOAT YES Total service refund sale price.
service refund discount applied FLOAT YES Total service refund discount applied.
service refund tax FLOAT YES Total service refund tax amount.
total sale price FLOAT YES Grand total of all sale prices.
total refund sale price FLOAT YES Grand total of all refund sale prices.
total discount applied FLOAT YES Grand total of all discounts applied.
total refund discount applied FLOAT YES Grand total of all refund discounts applied.
total tax FLOAT YES Grand total of all taxes.
total refund tax FLOAT YES Grand total of all refund taxes.
new guest count INTEGER YES Count of new guests served by the employee.
total guest count INTEGER YES Total count of guests served by the employee.
therapist request count INTEGER YES Number of times the employee was specifically requested as therapist.
production hours FLOAT YES Total production hours for the employee.
non production hours FLOAT YES Total non-production hours for the employee.
cc amount FLOAT YES Total credit card collection amount.
first check in time DATETIME YES First check-in time of the employee for the day.
last check out time DATETIME YES Last check-out time of the employee for the day.
cuts appointment count INTEGER YES Number of cuts appointments handled.
Break Hours FLOAT YES Total break hours taken by the employee.
total service count INTEGER YES Total number of services performed.
retail ticket count INTEGER YES Number of retail tickets.
male guest count INTEGER YES Count of male guests served.
female guest count INTEGER YES Count of female guests served.
other guest count INTEGER YES Count of other-gender guests served.
cuts less than 5 minutes INTEGER YES Number of cuts completed in less than 5 minutes.
cuts greater than 20 minutes INTEGER YES Number of cuts that took greater than 20 minutes.
cuts service minutes INTEGER YES Total minutes spent on cuts services.
minutes between cuts INTEGER YES Total minutes of gap between cuts.
tip amount FLOAT YES Total tip amount received by the employee.
closed invoice count INTEGER YES Count of closed invoices for the employee.
service retail invoice count INTEGER YES Count of invoices containing both service and retail items.
total service count excluding CN INTEGER YES Total service count excluding credit notes.
male guest count excluding CN INTEGER YES Male guest count excluding credit notes.
female guest count excluding CN INTEGER YES Female guest count excluding credit notes.
other guest count excluding CN INTEGER YES Other-gender guest count excluding credit notes.
total guest count excluding CN INTEGER YES Total guest count excluding credit notes.
total ticket count excluding CN INTEGER YES Total ticket count excluding credit notes.
new guest count excluding CN INTEGER YES New guest count excluding credit notes.
closed invoice count excluding CN INTEGER YES Closed invoice count excluding credit notes.
service retail invoice count excluding CN INTEGER YES Service and retail invoice count excluding credit notes.
retail ticket invoices INTEGER YES Number of invoices that contain retail items.
GCPPC Invoice Count INTEGER YES Count of Gift Card/Prepaid Card invoices.
therapist request count excluding CN INTEGER YES Therapist request count excluding credit notes.
service sale price excluding CN FLOAT YES Service sale price excluding credit notes.
service discount applied excluding CN FLOAT YES Service discount excluding credit notes.
service tax excluding CN FLOAT YES Service tax excluding credit notes.
total sale price excluding CN FLOAT YES Total sale price excluding credit notes.
total discount applied excluding CN FLOAT YES Total discount excluding credit notes.
total tax excluding CN FLOAT YES Total tax excluding credit notes.
loyalty point redemption amount FLOAT YES Total loyalty point redemption amount.
total refund service quantity INTEGER YES Total quantity of refunded services.
total service quantity inc addon INTEGER YES Total service quantity including add-ons.

Primary Key

No explicit primary key defined. Composite of ct date, center name, employee code, service parent category, and service category uniquely identifies a record.

Foreign Keys

  • Employee columns reference DimEmployee
  • center name references DimCenter
  • zone name references DimZone
  • organization account name references DimOrganization
  • Service category columns reference DimService

Standard ETL metadata columns (EtlLastUpdatedOn, EtlLastUpdatedBy, podname, groupid) are present in the underlying table but omitted from this reference for brevity.

Was this article helpful?
Your feedback helps us improve our documentation.