Disocount Summery Consolidated
ZTZenoti Docs Team Updated April 10, 2026 1 min readGuide
Consolidated summary table storing daily discount metrics per employee and campaign, including discount values, sale prices, quantities sold, and guest counts.
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 discount summary. |
| employee first name | VARCHAR(152) | YES | First name of the employee. Sourced from DimEmployee.employee_first_name. |
| employee last name | VARCHAR(152) | YES | Last name of the employee. Sourced from DimEmployee.employee_last_name. |
| employee middle name | VARCHAR(152) | YES | Middle name of the employee. Sourced from DimEmployee.employee_middle_name. |
| employee code | VARCHAR(100) | YES | Code assigned to the employee. Sourced from DimEmployee.employee_code. |
| item type code | VARCHAR(100) | YES | Code for the item type (e.g., Service, Product). |
| campaign name | VARCHAR(1024) | YES | Name of the discount campaign. |
| campaign code | VARCHAR(254) | YES | Code of the discount campaign. |
| discount value | FLOAT | YES | Total discount value applied. |
| sale price | FLOAT | YES | Total sale price after discount. |
| quantity sold | FLOAT | YES | Total quantity of items sold. |
| new guest | INTEGER | YES | Count of new guests associated with the discount. |
| total guest | INTEGER | YES | Total count of guests associated with the discount. |
Primary Key
No explicit primary key defined. Composite of ct date, center name, employee code, item type code, and campaign 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 |
|---|---|
| item type code | Service, Product, Membership, Package, Gift Card, Day Package |
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.