Aveda Employee Consolidated
ZTZenoti Docs Team Updated April 10, 2026 2 min readGuide
Consolidated table storing daily Aveda-specific employee performance metrics including service and retail sales, transaction counts, colour/hair/treatment breakdowns, and schedule utilization.
Columns
| Column Name | Data Type | Nullable | Description |
|---|---|---|---|
| Employee First Name | VARCHAR(256) | YES | First name of the employee. Sourced from DimEmployee.employee_first_name. |
| Employee Middle Name | VARCHAR(256) | YES | Middle name of the employee. Sourced from DimEmployee.employee_middle_name. |
| Employee Last Name | VARCHAR(256) | YES | Last name of the employee. Sourced from DimEmployee.employee_last_name. |
| Employee Code | VARCHAR(512) | YES | Code assigned to the employee. Sourced from DimEmployee.employee_code. |
| employee job name | VARCHAR(1020) | YES | Job title of the employee. Sourced from DimEmployee.employee_job_name. |
| employee job code | VARCHAR(8000) | YES | Job code of the employee. Sourced from DimEmployee.employee_job_code. |
| organization name | VARCHAR(512) | YES | Name of the organization. Sourced from DimOrganization.organization_name. |
| organization account name | VARCHAR(256) | YES | Account name of the organization. Sourced from DimOrganization.organization_account_name. |
| zone name | VARCHAR(800) | YES | Name of the zone. Sourced from DimZone.zone_name. |
| center name | VARCHAR(128) | YES | Name of the center. Sourced from DimCenter.center_name. |
| employee id | VARCHAR(36) | YES | Unique identifier of the employee. Sourced from DimEmployee.employee_id. |
| center id | VARCHAR(36) | YES | Unique identifier of the center. Sourced from DimCenter.center_id. |
| center code | VARCHAR(40) | YES | Code assigned to the center. Sourced from DimCenter.center_code. |
| organization id | VARCHAR(36) | YES | Unique identifier of the organization. Sourced from DimOrganization.organization_id. |
| ct date | DATE | YES | Reporting date for the employee performance data. |
| Total Service Sales | FLOAT | YES | Total revenue from service sales. |
| Total Service Transactions | BIGINT | YES | Total number of service transactions. |
| Total retail sales | FLOAT | YES | Total revenue from retail sales. |
| Total retail Transactions | BIGINT | YES | Total number of retail transactions. |
| Service Transactions with Retail | BIGINT | YES | Number of service transactions that also included retail items. |
| Total Colour transactions | BIGINT | YES | Total number of colour service transactions. |
| Total Hair service transactions | BIGINT | YES | Total number of hair service transactions. |
| Total Treatment Transactions | BIGINT | YES | Total number of treatment transactions. |
| Schedule Minutes | BIGINT | YES | Total scheduled minutes for the employee. |
| unpaid blockouts | BIGINT | YES | Total number of unpaid block-out minutes. |
| service time | FLOAT | YES | Total service time in minutes or hours. |
| Total Transactions | BIGINT | YES | Grand total of all transactions. |
| Shop cost | FLOAT | YES | Total shop cost or cost-of-goods. |
Primary Key
No explicit primary key defined. Composite of ct date, center name, and employee id uniquely identifies a record.
Foreign Keys
- Employee columns reference DimEmployee
center id/center namereferences DimCenterorganization id/organization account namereferences DimOrganizationzone namereferences DimZone
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.