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