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 factuser wid- References Dim_User.widinvoice id- References the invoice recordinvoice 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.