Employee Item Level Commissions Fact Table
ZTZenoti Docs Team Updated April 10, 2026 1 min readGuide
Stores employee-level commission configuration for items, including commission percentages, pricing factors, labour/shop costs, and category assignments.
Columns
| Column Name | Data Type | Nullable | Description |
|---|---|---|---|
| employeeitemcommissionwid | BIGINT IDENTITY | NOT NULL | Surrogate key and primary key for the employee item commission record. |
| employeeitemid | VARCHAR(36) | YES | GUID identifier for the employee-item commission assignment. |
| employeewid | BIGINT | YES | Foreign key to the employee dimension (Bi_DimUser.userwid). |
| itemwid | BIGINT | YES | Foreign key to the item dimension. |
| centerwid | BIGINT | YES | Foreign key to the center dimension (Bi_DimCenter.centerwid). |
| iscategory | BOOLEAN | YES | Flag indicating whether the commission is defined at the category level. |
| categoryid | VARCHAR(36) | YES | GUID of the category if commission is category-level. |
| servicetime | INTEGER | YES | Service time in minutes for the item. |
| commpercentvalue | VARCHAR(80) | YES | Commission percentage or value configuration. |
| assigned | BOOLEAN | YES | Flag indicating whether the employee is assigned to this item. |
| newguestcost | VARCHAR(80) | YES | Cost factor for new guest appointments. |
| pricescalingfactor | VARCHAR(80) | YES | Price scaling factor for commission calculation. |
| labourcost | VARCHAR(120) | YES | Labour cost associated with the item. |
| shopcost | VARCHAR(120) | YES | Shop cost associated with the item. |
| categoryname | VARCHAR(256) | YES | Name of the item category. |
| parentcategoryname | VARCHAR(256) | YES | Name of the parent item category. |
| podid | INTEGER | YES | Identifier for the pod (database partition). |
| void | BOOLEAN | YES | Soft-delete flag indicating the record is logically deleted. |
Note: All fact tables also include standard ETL metadata columns (
podname,organizationid,groupid,etlCreatedDate) which are omitted from this reference for brevity.
Primary Key
employeeitemcommissionwid
Foreign Keys
| Column | References |
|---|---|
| employeewid | Bi_DimUser.userwid |
| centerwid | Bi_DimCenter.centerwid |
Enumerator Values
| Column | Values |
|---|---|
| iscategory | TRUE if commission is at category level; FALSE if at item level. |
| assigned | TRUE if the employee is assigned; FALSE otherwise. |
| void | TRUE if the record is soft-deleted; FALSE otherwise. |
Was this article helpful?
Your feedback helps us improve our documentation.