ZenotiHelp

Employee Commission Fact Consolidated

ZTZenoti Docs Team Updated April 10, 2026 6 min readGuide

Consolidated employee commission fact table combining commission details with guest, employee, service, item, and payroll dimensions for comprehensive commission and compensation analytics.

Columns

Column Name Data Type Nullable Description
organization name VARCHAR(512) Yes Name of the organization. Sourced from Dim_Organization.organization_name.
organization account name VARCHAR(256) Yes Account name of the organization. Sourced from Dim_Organization.organization_account_name.
zone name VARCHAR(800) Yes Name of the zone the center belongs to. Sourced from Dim_Center.zone_name.
center name VARCHAR(128) Yes Name of the center. Sourced from Dim_Center.center_name.
center city VARCHAR(128) Yes City where the center is located. Sourced from Dim_Center.center_city.
center zip VARCHAR(32) Yes Zip/postal code of the center. Sourced from Dim_Center.center_zip.
center state name VARCHAR(4096) Yes State name of the center. Sourced from Dim_Center.center_state_name.
country name VARCHAR(4096) Yes Country name of the center. Sourced from Dim_Center.country_name.
operating center BOOLEAN Yes Whether the center is an operating center. Sourced from Dim_Center.operating_center.
user wid BIGINT Yes Warehouse identifier for the guest/user dimension. Sourced from Dim_User.wid.
guest first name VARCHAR(256) Yes First name of the guest. Sourced from Dim_User.first_name.
guest last name VARCHAR(256) Yes Last name of the guest. Sourced from Dim_User.last_name.
guest middle name VARCHAR(256) Yes Middle name of the guest. Sourced from Dim_User.middle_name.
guest city VARCHAR(128) Yes City of the guest. Sourced from Dim_User.city.
guest zipcode VARCHAR(128) Yes Zip/postal code of the guest. Sourced from Dim_User.zipcode.
guest type name VARCHAR(128) Yes Type classification of the guest. Sourced from Dim_User.guest_type_name.
guest email VARCHAR(512) Yes Email address of the guest. Sourced from Dim_User.email.
guest mobile phone VARCHAR(64) Yes Mobile phone number of the guest. Sourced from Dim_User.mobile_phone.
guest phone code INTEGER Yes Phone country code of the guest. Sourced from Dim_User.phone_code.
guest gender VARCHAR(14) Yes Gender of the guest. Sourced from Dim_User.gender.
guest dob TIMESTAMP WITHOUT TIME ZONE Yes Date of birth of the guest. Sourced from Dim_User.dob.
referred by guestid VARCHAR(36) Yes GUID of the guest who referred this guest. Sourced from Dim_User.referred_by_guestid.
guest anniversary date TIMESTAMP WITHOUT TIME ZONE Yes Anniversary date of the guest. Sourced from Dim_User.anniversary_date.
guest state VARCHAR(4096) Yes State of the guest address. Sourced from Dim_User.state.
guest country name VARCHAR(4096) Yes Country name of the guest. Sourced from Dim_User.country_name.
guest is active BOOLEAN Yes Whether the guest is active. Sourced from Dim_User.is_active.
guest tags VARCHAR(65535) Yes Tags associated with the guest. Sourced from Dim_User.tags.
guest referral source VARCHAR(3200) Yes Referral source of the guest. Sourced from Dim_User.referral_source.
employee first name VARCHAR(256) Yes First name of the employee earning commission. Sourced from Dim_Employee.first_name.
employee last name VARCHAR(256) Yes Last name of the employee. Sourced from Dim_Employee.last_name.
employee middle name VARCHAR(256) Yes Middle name of the employee. Sourced from Dim_Employee.middle_name.
employee mobile phone VARCHAR(64) Yes Mobile phone of the employee. Sourced from Dim_Employee.mobile_phone.
employee code VARCHAR(128) Yes Code of the employee. Sourced from Dim_Employee.employee_code.
employee - code VARCHAR(512) Yes Alternate code of the employee. Sourced from Dim_Employee.employee_code_alt.
employee gender VARCHAR(14) Yes Gender of the employee. Sourced from Dim_Employee.gender.
employee job name VARCHAR(1020) Yes Job title of the employee. Sourced from Dim_Employee.job_name.
is employee inactive BOOLEAN Yes Whether the employee is inactive. Sourced from Dim_Employee.is_inactive.
item name VARCHAR(512) Yes Name of the item for commission calculation. Sourced from Fact_EmployeeCommission.item_name.
item code VARCHAR(256) Yes Code of the item. Sourced from Fact_EmployeeCommission.item_code.
businessunit VARCHAR(65535) Yes Business unit of the item. Sourced from Fact_EmployeeCommission.businessunit.
is item inactive BOOLEAN Yes Whether the item is inactive. Sourced from Fact_EmployeeCommission.is_item_inactive.
item tags VARCHAR(65535) Yes Tags associated with the item. Sourced from Fact_EmployeeCommission.item_tags.
item type VARCHAR(100) Yes Type of the item. Sourced from Fact_EmployeeCommission.item_type.
tip NUMERIC(19,4) Yes Tip amount. Sourced from Fact_EmployeeCommission.tip.
split commission percentage DOUBLE PRECISION Yes Percentage of commission split. Sourced from Fact_EmployeeCommission.split_commission_percentage.
service name VARCHAR(1024) Yes Name of the service. Sourced from Dim_Service.service_name.
service length INTEGER Yes Duration of the service in minutes. Sourced from Dim_Service.service_length.
service category VARCHAR(1024) Yes Category of the service. Sourced from Dim_Service.service_category.
service parent category VARCHAR(1024) Yes Parent category of the service. Sourced from Dim_Service.parent_category.
service deduction NUMERIC(19,4) Yes Deduction on the service. Sourced from Fact_EmployeeCommission.service_deduction.
service date DATE Yes Date of the service. Sourced from Fact_EmployeeCommission.service_date.
request therapist bonus NUMERIC(19,4) Yes Bonus for requested therapist. Sourced from Fact_EmployeeCommission.request_therapist_bonus.
payroll start date DATE Yes Start date of the payroll period. Sourced from Fact_EmployeeCommission.payroll_start_date.
payroll end date DATE Yes End date of the payroll period. Sourced from Fact_EmployeeCommission.payroll_end_date.
pay period name VARCHAR(512) Yes Name of the pay period. Sourced from Fact_EmployeeCommission.pay_period_name.
no show revenue NUMERIC(19,4) Yes Revenue from no-show appointments. Sourced from Fact_EmployeeCommission.no_show_revenue.
no show commission NUMERIC(19,4) Yes Commission from no-show appointments. Sourced from Fact_EmployeeCommission.no_show_commission.
appointment status VARCHAR(100) Yes Status of the related appointment. Sourced from Fact_EmployeeCommission.appointment_status.
item sale revenue NUMERIC(19,4) Yes Sale revenue for the item. Sourced from Fact_EmployeeCommission.item_sale_revenue.
is therapist requested BOOLEAN Yes Whether the therapist was specifically requested. Sourced from Fact_EmployeeCommission.is_therapist_requested.
is add on BOOLEAN Yes Whether this is an add-on service. Sourced from Fact_EmployeeCommission.is_add_on.
invoice level deduction NUMERIC(19,4) Yes Deduction at the invoice level. Sourced from Fact_EmployeeCommission.invoice_level_deduction.
invoice id VARCHAR(36) Yes Unique identifier (GUID) of the invoice. Sourced from Fact_EmployeeCommission.invoice_id.
invoice close date DATE Yes Date when the invoice was closed. Sourced from Fact_EmployeeCommission.invoice_close_date.
free service revenue NUMERIC(19,4) Yes Revenue from free services. Sourced from Fact_EmployeeCommission.free_service_revenue.
free service commission NUMERIC(19,4) Yes Commission from free services. Sourced from Fact_EmployeeCommission.free_service_commission.
deduction NUMERIC(19,4) Yes Total deduction amount. Sourced from Fact_EmployeeCommission.deduction.
commission factor DOUBLE PRECISION Yes Commission factor/rate applied. Sourced from Fact_EmployeeCommission.commission_factor.
commission NUMERIC(19,4) Yes Commission amount earned. Sourced from Fact_EmployeeCommission.commission.
class commission NUMERIC(19,4) Yes Commission from class services. Sourced from Fact_EmployeeCommission.class_commission.
class bonus NUMERIC(19,4) Yes Bonus from class services. Sourced from Fact_EmployeeCommission.class_bonus.
cancellation revenue NUMERIC(19,4) Yes Revenue from cancellations. Sourced from Fact_EmployeeCommission.cancellation_revenue.
cancellation commission NUMERIC(19,4) Yes Commission from cancellations. Sourced from Fact_EmployeeCommission.cancellation_commission.
bonus commission NUMERIC(19,4) Yes Bonus commission amount. Sourced from Fact_EmployeeCommission.bonus_commission.
list price NUMERIC(19,4) Yes List/original price of the item. Sourced from Fact_EmployeeCommission.list_price.
sale price NUMERIC(19,4) Yes Sale price of the item. Sourced from Fact_EmployeeCommission.sale_price.
etl created date TIMESTAMP WITHOUT TIME ZONE Yes Date when the ETL record was created. Sourced from Fact_EmployeeCommission.etl_created_date.
refund item type VARCHAR(100) Yes Type of refund item. Sourced from Fact_EmployeeCommission.refund_item_type.
minutes to add INTEGER Yes Minutes offset to add for timezone conversion. Sourced from Dim_Center.minutes_to_add.
invoice item id VARCHAR(36) Yes Unique identifier (GUID) of the invoice item. Sourced from Fact_EmployeeCommission.invoice_item_id.
payment date in center TIMESTAMP WITHOUT TIME ZONE Yes Payment date in the center's timezone. Sourced from Fact_EmployeeCommission.payment_date_in_center.
fact employee commission wid BIGINT Yes Warehouse identifier for the employee commission fact. Sourced from Fact_EmployeeCommission.wid.
factemployeecommissionid NUMERIC(19,0) Yes Internal identifier for the commission fact record. Sourced from Fact_EmployeeCommission.id.
Center Code VARCHAR(40) Yes Code of the center. Sourced from Dim_Center.center_code.
invoice no VARCHAR(160) Yes Invoice number. Sourced from Fact_EmployeeCommission.invoice_no.

Primary Key

No explicit primary key defined. The fact employee commission wid serves as the logical warehouse identifier.

Foreign Keys

  • fact employee commission wid - Warehouse identifier for the commission fact (also used as DISTKEY)
  • factemployeecommissionid - Internal identifier for the commission fact
  • user wid - References Dim_User.wid
  • invoice id - References the invoice record
  • invoice item id - References the invoice item record

Enumerator Values

Column Name Known Values
item -1 = None
0 = Service
2 = Product
3 = Membership
4 = Series Package
5 = Day/Promo Package
6 = Gift Card
8 = Employee
11 = Class
14 = Add-ons
-90 = Service Refund
-92 = Product Refund
-93 = Membership Refund
-94 = Series Package Refund
-95 = Day Package Refund
-96 = Gift Card Refund
-911 = Class Refund
appointment status -2 = No Show
refund item type -90 = Service Refund

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.