Employee Commission Fact Table
ZTZenoti Docs Team Updated April 10, 2026 2 min readGuide
Stores employee commission details per invoice, including commission breakdowns for services, classes, no-shows, cancellations, bonuses, deductions, tips, and payroll period context.
Columns
| Column Name | Data Type | Nullable | Description |
|---|---|---|---|
| factemployeecommissionwid | BIGINT IDENTITY | No | Surrogate primary key (auto-generated) |
| factemployeecommissionid | NUMERIC(19,0) | Yes | Source system identifier for the commission fact |
| employeewid | BIGINT | Yes | Foreign key to the employee (user) dimension |
| userwid | BIGINT | Yes | Foreign key to the guest/user dimension |
| invoiceid | VARCHAR(36) | Yes | Unique identifier (GUID) of the invoice |
| invoiceno | VARCHAR(80) | Yes | Human-readable invoice number |
| itemwid | BIGINT | Yes | Foreign key to the generic item dimension |
| itemtypewid | BIGINT | Yes | Foreign key to the item type dimension |
| invoicecenterwid | BIGINT | Yes | Foreign key to the center where the invoice was created |
| centerwid | BIGINT | Yes | Foreign key to the center dimension (employee's center) |
| podid | INTEGER | Yes | Pod identifier for multi-tenant partitioning |
| itemsalerevenue | NUMERIC(19,4) | Yes | Revenue from item sale |
| freeservicerevenue | NUMERIC(19,4) | Yes | Revenue attributed to free services |
| cancellationrevenue | NUMERIC(19,4) | Yes | Revenue attributed to cancellations |
| noshowrevenue | NUMERIC(19,4) | Yes | Revenue attributed to no-shows |
| commission | NUMERIC(19,4) | Yes | Total commission amount |
| isaddon | BOOLEAN | Yes | Flag indicating if this is for an add-on service |
| invoiceclosedate | DATE | Yes | Date when the invoice was closed |
| servicedate | DATE | Yes | Date when the service was performed |
| servicewid | BIGINT | Yes | Foreign key to the service dimension |
| splitcommissionpercentage | DOUBLE PRECISION | Yes | Percentage split for shared commissions |
| bonuscommission | NUMERIC(19,4) | Yes | Bonus commission amount |
| requesttherapistbonus | NUMERIC(19,4) | Yes | Bonus for being a requested therapist |
| deduction | NUMERIC(19,4) | Yes | Total deduction amount |
| classcommission | NUMERIC(19,4) | Yes | Commission from class services |
| classbonus | NUMERIC(19,4) | Yes | Bonus from class services |
| noshowcommission | NUMERIC(19,4) | Yes | Commission from no-show appointments |
| freeservicecommission | NUMERIC(19,4) | Yes | Commission from free services |
| cancellationcommission | NUMERIC(19,4) | Yes | Commission from cancelled appointments |
| servicededuction | NUMERIC(19,4) | Yes | Deduction at service level |
| invoiceleveldeduction | NUMERIC(19,4) | Yes | Deduction at invoice level |
| redoappointmentamount | NUMERIC(19,4) | Yes | Amount related to redo appointments |
| tip | NUMERIC(19,4) | Yes | Tip amount |
| ef | NUMERIC(19,4) | Yes | Employee fund amount |
| ssg | NUMERIC(19,4) | Yes | SSG (special service guarantee) amount |
| appstatuswid | BIGINT | Yes | Foreign key to the appointment status dimension |
| commissionfactor | DOUBLE PRECISION | Yes | Factor/multiplier applied to commission |
| istherapistrequested | BOOLEAN | Yes | Flag indicating if the therapist was requested |
| considerforpayroll | BOOLEAN | Yes | Flag indicating if this should be considered for payroll |
| payrollstartdate | DATE | Yes | Start date of the payroll period |
| payrollenddate | DATE | Yes | End date of the payroll period |
| payperiodname | VARCHAR(512) | Yes | Name of the payroll period |
| void | BOOLEAN | Yes | Indicates if the record is voided |
| saleprice | NUMERIC(19,4) | Yes | Sale price of the item |
| finalsaleprice | NUMERIC(19,4) | Yes | Final sale price after adjustments |
| refitemtypewid | BIGINT | Yes | Foreign key to the reference item type dimension |
| payperiodname_new | VARCHAR(512) | Yes | Updated payroll period name |
Note: All fact tables also include standard ETL metadata columns (
podname,organizationid,groupid,etlCreatedDate) which are omitted from this reference for brevity.
Primary Key
factemployeecommissionwid
Foreign Keys
| Column | References |
|---|---|
| employeewid | Bi_DimUser.userwid |
| userwid | Bi_DimUser.userwid |
| centerwid | Bi_DimCenter.centerwid |
| invoicecenterwid | Bi_DimCenter.centerwid |
| invoiceclosedate | Bi_DimDate.datewid |
| servicedate | Bi_DimDate.datewid |
| payrollstartdate | Bi_DimDate.datewid |
| payrollenddate | Bi_DimDate.datewid |
Enumerator Values
| Column | Values |
|---|---|
| void | true = Voided, false = Active |
| isaddon | true = Add-on service, false = Primary service |
| istherapistrequested | true = Requested, false = Not requested |
| considerforpayroll | true = Include in payroll, false = Exclude |
Was this article helpful?
Your feedback helps us improve our documentation.