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 namereferences DimCenterzone namereferences DimZoneorganization account namereferences 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.