ZenotiHelp

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.