ZenotiHelp

Employeeitemlevelcommissions Consolidated

ZTZenoti Docs Team Updated April 10, 2026 3 min readGuide

Consolidated table storing employee item-level commission configuration, including commission percentages, labor costs, shop costs, and service assignment details per employee and item/category combination.

Columns

Column Name Data Type Nullable Description
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 geographic zone. Sourced from DimCenter.zone name.
center name VARCHAR(128) YES Name of the center. Sourced from DimCenter.center name.
center city VARCHAR(128) YES City where the center is located. Sourced from DimCenter.center city.
center zip VARCHAR(32) YES ZIP/postal code of the center. Sourced from DimCenter.center zip.
center state name VARCHAR(4096) YES State name of the center. Sourced from DimCenter.center state name.
country name VARCHAR(4096) YES Country name of the center. Sourced from DimCenter.country name.
center company name VARCHAR(200) YES Company name associated with the center. Sourced from DimCenter.center company name.
operating center BOOLEAN YES Indicates whether the center is an operating center. Sourced from DimCenter.operating center.
center wid BIGINT YES Warehouse identifier for the center. Sourced from DimCenter.center wid.
employee first name VARCHAR(160) 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(128) YES Middle name of the employee. Sourced from DimEmployee.employee middle name.
employee mobile phone VARCHAR(64) YES Mobile phone number of the employee. Sourced from DimEmployee.employee mobile phone.
employee code VARCHAR(128) YES Code for the employee. Sourced from DimEmployee.employee code.
employee - code VARCHAR(128) YES Alternate employee code identifier. Sourced from DimEmployee.employee - code.
employee gender VARCHAR(14) YES Gender of the employee. Sourced from DimEmployee.employee gender.
employee job name VARCHAR(1020) YES Job title of the employee. Sourced from DimEmployee.employee job name.
employee job code VARCHAR(1020) YES Job code of the employee. Sourced from DimEmployee.employee job code.
is employee inactive BOOLEAN YES Indicates whether the employee is inactive. Sourced from DimEmployee.is employee inactive.
employee additional field 1 VARCHAR(8000) YES Custom additional field 1 for the employee. Sourced from DimEmployee.employee additional field 1.
employee additional field 2 VARCHAR(8000) YES Custom additional field 2 for the employee. Sourced from DimEmployee.employee additional field 2.
employee last date TIMESTAMP WITHOUT TIME ZONE YES Last working date of the employee. Sourced from DimEmployee.employee last date.
employee wid BIGINT YES Warehouse identifier for the employee. Sourced from DimEmployee.employee wid.
item id VARCHAR(36) YES Unique identifier for the item. Sourced from DimItem.item id.
item name VARCHAR(512) YES Name of the item. Sourced from DimItem.item name.
item code VARCHAR(256) YES Code of the item. Sourced from DimItem.item code.
businessunit VARCHAR(65535) YES Business unit the item belongs to. Sourced from DimItem.businessunit.
is item inactive BOOLEAN YES Indicates whether the item is inactive. Sourced from DimItem.is item inactive.
item tags VARCHAR(65535) YES Tags associated with the item. Sourced from DimItem.item tags.
item wid BIGINT YES Warehouse identifier for the item. Sourced from DimItem.item wid.
is category BOOLEAN YES Indicates whether the commission is set at the category level rather than item level.
service time INTEGER YES Duration of the service in minutes.
commission percent value VARCHAR(80) YES Commission percentage or value configuration string.
assigned BOOLEAN YES Indicates whether the employee is assigned to this item.
new guest cost VARCHAR(80) YES Cost value associated with acquiring a new guest for this item.
price scaling factor VARCHAR(80) YES Price scaling factor applied to the item for commission calculation.
labour cost VARCHAR(120) YES Labour cost associated with performing the service.
shop cost VARCHAR(120) YES Shop cost associated with performing the service.
category name VARCHAR(256) YES Name of the item category. Sourced from DimItem.category name.
parent category name VARCHAR(256) YES Name of the parent item category. Sourced from DimItem.parent category name.
minutes to add INTEGER YES Minute offset to convert UTC to center local time.
Center Code VARCHAR(40) YES Code assigned to the center. Sourced from DimCenter.Center Code.

Primary Key

No explicit primary key is defined. Rows are uniquely identified by the combination of employee wid, item wid, center wid, and groupid.

Foreign Keys

  • center wid references DimCenter
  • employee wid references DimEmployee
  • item wid / item id references DimItem
  • groupid references the tenant/data group

Enumerator Values

Column Name Known Values
employee gender VARCHAR(14)

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.