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.