ZenotiHelp

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.