ZenotiHelp

Multiple Employee Commission Fact Table

ZTZenoti Docs Team Updated April 10, 2026 1 min readGuide

Stores commission records for multiple employees associated with invoice items and appointments.

Columns

Column Name Data Type Nullable Description
empcommissionwid BIGINT IDENTITY NOT NULL Surrogate key and primary key for the commission record.
empcommissionpk NUMERIC(19,0) YES Source system primary key for the employee commission.
empcommissionid VARCHAR(36) YES GUID identifier for the employee commission record.
invoiceitemid VARCHAR(36) YES GUID of the associated invoice item.
employeewid BIGINT YES Foreign key to the employee dimension (Bi_DimUser.userwid).
commission NUMERIC(19,4) YES Commission amount earned by the employee.
appointmentid VARCHAR(36) YES GUID of the associated appointment.
centerwid BIGINT YES Foreign key to the center dimension (Bi_DimCenter.centerwid).
primaryemp BOOLEAN YES Indicates whether this employee is the primary employee on the appointment.
updatedon TIMESTAMP YES Timestamp of the last update to this record.
updatedby VARCHAR(36) YES GUID of the user who last updated the record.
isvoid BOOLEAN YES Indicates whether the commission record has been voided.
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

empcommissionwid

Foreign Keys

Column References
employeewid Bi_DimUser.userwid
centerwid Bi_DimCenter.centerwid

Enumerator Values

Column Values
primaryemp TRUE if the employee is the primary employee; FALSE otherwise.
isvoid TRUE if the commission has been voided; FALSE otherwise.
void TRUE if the record is soft-deleted; FALSE otherwise.
Was this article helpful?
Your feedback helps us improve our documentation.