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.