ZenotiHelp

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