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 widreferences DimCenteremployee widreferences DimEmployeeitem wid/item idreferences DimItemgroupidreferences 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.