ZenotiHelp

Daily Traffic Consolidated

ZTZenoti Docs Team Updated April 10, 2026 1 min readGuide

Consolidated table storing daily hourly traffic metrics per employee, including appointment counts, walk-in counts, deleted appointments, and production hours.

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 traffic data.
ct hour INTEGER YES Hour of the day (0-23) for the traffic data.
day name VARCHAR(100) YES Name of the day of the week (e.g., Monday, Tuesday).
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.
Appointment count INTEGER YES Number of appointments during the hour.
Look and walk count INTEGER YES Number of walk-in (look-and-walk) guests during the hour.
Delete appointment count INTEGER YES Number of deleted appointments during the hour.
Production Hours FLOAT YES Production hours recorded during the hour.

Primary Key

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

Foreign Keys

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

Enumerator Values

Column Name Known Values
day name Monday, Tuesday, Wednesday, Thursday, Friday, Saturday, Sunday

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.