ZenotiHelp

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 wid references DimEmployee
  • invoice item id references FactInvoiceItem
  • appointment id references 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.