ZenotiHelp

Employee Hourly Pay Fact Consolidated

ZTZenoti Docs Team Updated April 10, 2026 4 min readGuide

Consolidated employee hourly pay fact table combining hourly pay, service commission, overtime, and payroll details with employee and center dimensions for hourly 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.
employee first name VARCHAR(256) Yes First name of the employee. 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.
total hours DOUBLE PRECISION Yes Total hours worked. Sourced from Fact_EmployeeHourlyPay.total_hours.
total hourly pay NUMERIC(19,4) Yes Total hourly pay amount. Sourced from Fact_EmployeeHourlyPay.total_hourly_pay.
service commission NUMERIC(19,4) Yes Service commission amount. Sourced from Fact_EmployeeHourlyPay.service_commission.
interval start date TIMESTAMP WITHOUT TIME ZONE Yes Start date of the pay interval. Sourced from Fact_EmployeeHourlyPay.interval_start_date.
interval end date TIMESTAMP WITHOUT TIME ZONE Yes End date of the pay interval. Sourced from Fact_EmployeeHourlyPay.interval_end_date.
interval type VARCHAR(50) Yes Type of the pay interval. Sourced from Fact_EmployeeHourlyPay.interval_type.
payroll start date DATE Yes Start date of the payroll period. Sourced from Fact_EmployeeHourlyPay.payroll_start_date.
payroll end date DATE Yes End date of the payroll period. Sourced from Fact_EmployeeHourlyPay.payroll_end_date.
pay period name VARCHAR(512) Yes Name of the pay period. Sourced from Fact_EmployeeHourlyPay.pay_period_name.
consider hourly pay VARCHAR(14) Yes Whether to consider hourly pay in calculations. Sourced from Fact_EmployeeHourlyPay.consider_hourly_pay.
consider service commission VARCHAR(14) Yes Whether to consider service commission. Sourced from Fact_EmployeeHourlyPay.consider_service_commission.
etl created date TIMESTAMP WITHOUT TIME ZONE Yes Date when the ETL record was created. Sourced from Fact_EmployeeHourlyPay.etl_created_date.
minutes to add INTEGER Yes Minutes offset to add for timezone conversion. Sourced from Dim_Center.minutes_to_add.
hourly or service VARCHAR(2048) Yes Indicates whether pay is hourly or service-based. Sourced from Fact_EmployeeHourlyPay.hourly_or_service.
organization id VARCHAR(36) Yes Unique identifier (GUID) of the organization. Sourced from Dim_Organization.organization_id.
max of hourly pay or service commission BOOLEAN Yes Whether to use the max of hourly pay or service commission. Sourced from Fact_EmployeeHourlyPay.
salary DOUBLE PRECISION Yes Base salary amount. Sourced from Fact_EmployeeHourlyPay.salary.
service hours DOUBLE PRECISION Yes Total service hours worked. Sourced from Fact_EmployeeHourlyPay.service_hours.
non service commission DOUBLE PRECISION Yes Non-service commission amount. Sourced from Fact_EmployeeHourlyPay.non_service_commission.
tip DOUBLE PRECISION Yes Tip amount. Sourced from Fact_EmployeeHourlyPay.tip.
ssg DOUBLE PRECISION Yes SSG (service support guarantee) amount. Sourced from Fact_EmployeeHourlyPay.ssg.
no of invoices INTEGER Yes Number of invoices. Sourced from Fact_EmployeeHourlyPay.no_of_invoices.
no of requested INTEGER Yes Number of therapist requests. Sourced from Fact_EmployeeHourlyPay.no_of_requested.
no of services INTEGER Yes Number of services performed. Sourced from Fact_EmployeeHourlyPay.no_of_services.
rt bouns DOUBLE PRECISION Yes Requested therapist bonus. Sourced from Fact_EmployeeHourlyPay.rt_bonus.
max of hourly pay or service commission value DOUBLE PRECISION Yes Computed max value of hourly pay vs. service commission. Sourced from Fact_EmployeeHourlyPay.
hourly rate DOUBLE PRECISION Yes Hourly rate of the employee. Sourced from Fact_EmployeeHourlyPay.hourly_rate.
deductions on total commission DOUBLE PRECISION Yes Deductions on total commission. Sourced from Fact_EmployeeHourlyPay.deductions_on_total_commission.
service and invoice level deductions DOUBLE PRECISION Yes Service and invoice level deductions. Sourced from Fact_EmployeeHourlyPay.
overtime pay NUMERIC(19,4) Yes Overtime pay amount. Sourced from Fact_EmployeeHourlyPay.overtime_pay.
total hours with rounding DOUBLE PRECISION Yes Total hours with rounding applied. Sourced from Fact_EmployeeHourlyPay.total_hours_with_rounding.
declared tip DECIMAL(19,4) Yes Declared tip amount. Sourced from Fact_EmployeeHourlyPay.declared_tip.
tips paid amount through zenoti DECIMAL(19,4) Yes Tips paid through Zenoti platform. Sourced from Fact_EmployeeHourlyPay.tips_paid_amount_through_zenoti.
production hours DECIMAL(19,4) Yes Production hours worked. Sourced from Fact_EmployeeHourlyPay.production_hours.
non production hours DECIMAL(19,4) Yes Non-production hours. Sourced from Fact_EmployeeHourlyPay.non_production_hours.
Overtime Hours DOUBLE PRECISION Yes Overtime hours worked. Sourced from Fact_EmployeeHourlyPay.overtime_hours.
Overtime HourlyPay DECIMAL(19,4) Yes Overtime hourly pay rate. Sourced from Fact_EmployeeHourlyPay.overtime_hourlypay.
Overtime Multiplier DOUBLE PRECISION Yes Overtime pay multiplier. Sourced from Fact_EmployeeHourlyPay.overtime_multiplier.
Employee base center VARCHAR(128) Yes Base center of the employee. Sourced from Dim_Employee.base_center.
fact employee pay wid BIGINT Yes Warehouse identifier for the employee pay fact. Sourced from Fact_EmployeeHourlyPay.wid.
Center Code VARCHAR(40) Yes Code of the center. Sourced from Dim_Center.center_code.

Primary Key

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

Foreign Keys

  • fact employee pay wid - Warehouse identifier for the employee pay fact (also used as DISTKEY)
  • organization id - References Dim_Organization.organization_id

Enumerator Values

Column Name Known Values
interval type Weekly
hourly or service Hourly
consider hourly pay 0 = No
consider service commission 0 = No

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.