ZenotiHelp

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 name references DimCenter
  • organization id / organization account name references DimOrganization
  • zone name references 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.