Multipleempcomissions Consolidated
ZTZenoti Docs Team Updated April 10, 2026 2 min readGuide
Consolidated table storing employee commission details for multi-employee commission splits on invoice items across centers.
Columns
| Column Name | Data Type | Nullable | Description |
|---|---|---|---|
| organization name | VARCHAR(512) | YES | Name of the organization. Sourced from DimOrganization.organization_name. |
| organization account name | VARCHAR(256) | YES | Account name of the organization. Sourced from DimOrganization.organization_account_name. |
| center name | VARCHAR(128) | YES | Name of the center. Sourced from DimCenter.center_name. |
| center company name | VARCHAR(128) | YES | Company name associated with the center. Sourced from DimCenter.center_company_name. |
| is center franchise | BOOLEAN | YES | Indicates whether the center is a franchise location. Sourced from DimCenter.is_center_franchise. |
| center cstn number | VARCHAR(80) | YES | CSTN number of the center. Sourced from DimCenter.center_cstn_number. |
| center tin number | VARCHAR(80) | YES | TIN number of the center. Sourced from DimCenter.center_tin_number. |
| center tot number | VARCHAR(80) | YES | TOT number of the center. Sourced from DimCenter.center_tot_number. |
| center service tax number | VARCHAR(80) | YES | Service tax number of the center. Sourced from DimCenter.center_service_tax_number. |
| center vat number | VARCHAR(80) | YES | VAT number of the center. Sourced from DimCenter.center_vat_number. |
| center luxary tax number | VARCHAR(80) | YES | Luxury tax number of the center. Sourced from DimCenter.center_luxary_tax_number. |
| emp commission wid | BIGINT | YES | Warehouse ID for the employee commission record. |
| emp commission id | VARCHAR(36) | YES | Unique identifier for the employee commission. |
| invoice item id | VARCHAR(36) | YES | Unique identifier of the associated invoice item. |
| commission | NUMERIC(19,4) | YES | Commission amount for the employee. |
| appointment id | VARCHAR(36) | YES | Unique identifier of the associated appointment. |
| is primary emp | BOOLEAN | YES | Indicates whether this employee is the primary employee on the commission split. |
| employee first name | VARCHAR(160) | YES | First name of the employee. Sourced from DimEmployee.employee_first_name. |
| employee last name | VARCHAR(256) | YES | Last name of the employee. Sourced from DimEmployee.employee_last_name. |
| employee middle name | VARCHAR(128) | YES | Middle name of the employee. Sourced from DimEmployee.employee_middle_name. |
| employee mobile phone | VARCHAR(64) | YES | Mobile phone number of the employee. Sourced from DimEmployee.employee_mobile_phone. |
| employee code | VARCHAR(128) | YES | Unique code assigned to the employee. Sourced from DimEmployee.employee_code. |
| employee - code | VARCHAR(128) | YES | Alternate employee code format. Sourced from DimEmployee.employee_code. |
| employee gender | VARCHAR(14) | YES | Gender of the employee. Sourced from DimEmployee.employee_gender. |
| employee job name | VARCHAR(1020) | YES | Job title or name for the employee. Sourced from DimEmployee.employee_job_name. |
| employee job code | VARCHAR(8000) | YES | Job code assigned to the employee. Sourced from DimEmployee.employee_job_code. |
| is employee inactive | BOOLEAN | YES | Indicates whether the employee is inactive. Sourced from DimEmployee.is_employee_inactive. |
| employee tags | VARCHAR(65535) | YES | Tags associated with the employee. Sourced from DimEmployee.employee_tags. |
| employee start date | TIMESTAMP WITHOUT TIME ZONE | YES | Start date of the employee. Sourced from DimEmployee.employee_start_date. |
| employee last date | TIMESTAMP WITHOUT TIME ZONE | YES | Last working date of the employee. Sourced from DimEmployee.employee_last_date. |
| employee wid | BIGINT | YES | Warehouse ID of the employee. Sourced from DimEmployee.employee_wid. |
| minutes to add | INTEGER | YES | Time zone offset in minutes to convert to center local time. |
| is commission voided | BOOLEAN | YES | Indicates whether the commission record has been voided. |
| empcommissionpk | NUMERIC(19,0) | YES | Primary key for the employee commission record. |
| Center Code | VARCHAR(40) | YES | Code assigned to the center. Sourced from DimCenter.center_code. |
Primary Key
empcommissionpk (NUMERIC(19,0))
Foreign Keys
employee widreferences DimEmployeeinvoice item idreferences FactInvoiceItemappointment idreferences FactAppointment
Enumerator Values
| Column Name | Known Values |
|---|---|
| employee gender | Male, Female, Other |
Standard ETL metadata columns (EtlLastUpdatedOn, EtlLastUpdatedBy, podname, groupid) are present in the underlying table but omitted from this reference for brevity.
Was this article helpful?
Your feedback helps us improve our documentation.