Employee Pay Fact Table
ZTZenoti Docs Team Updated April 10, 2026 1 min readGuide
Stores employee pay details per payroll interval, including hourly pay, service commissions, overtime, production/non-production hours, tips, and payroll consideration flags.
Columns
| Column Name | Data Type | Nullable | Description |
|---|---|---|---|
| factemployeepaywid | BIGINT IDENTITY | No | Surrogate primary key (auto-generated) |
| factemployeepayid | NUMERIC(19,0) | Yes | Source system identifier for the employee pay fact |
| payrollid | NUMERIC(19,0) | Yes | Source payroll identifier |
| employeewid | BIGINT | Yes | Foreign key to the employee (user) dimension |
| centerwid | BIGINT | Yes | Foreign key to the center dimension |
| podid | INTEGER | Yes | Pod identifier for multi-tenant partitioning |
| totalhours | DOUBLE PRECISION | Yes | Total hours worked in the interval |
| totalhourlypay | NUMERIC(19,4) | Yes | Total hourly pay for the interval |
| servicecommission | NUMERIC(19,4) | Yes | Service commission earned in the interval |
| intervalstartdate | TIMESTAMP | Yes | Start datetime of the pay interval |
| intervalenddate | TIMESTAMP | Yes | End datetime of the pay interval |
| intervaltype | VARCHAR(50) | Yes | Type of pay interval (e.g., weekly, biweekly) |
| payrollstartdate | DATE | Yes | Start date of the payroll period |
| payrollenddate | DATE | Yes | End date of the payroll period |
| payperiodname | VARCHAR(512) | Yes | Name of the payroll period |
| considerhourlypay | BOOLEAN | Yes | Flag indicating if hourly pay is considered for this record |
| considerservicecommission | BOOLEAN | Yes | Flag indicating if service commission is considered |
| dontconsiderothercenterinvoicesforpayroll | BOOLEAN | Yes | Flag to exclude other center invoices from payroll calculation |
| declaredtip | DECIMAL(19,4) | Yes | Declared tip amount |
| tipspaidamountthroughzenoti | DECIMAL(19,4) | Yes | Tip amount paid through Zenoti platform |
| ProductionHours | DECIMAL(19,4) | Yes | Hours spent in production (serving guests) |
| NonProductionHours | DECIMAL(19,4) | Yes | Hours spent in non-production activities |
| OvertimeHours | FLOAT | Yes | Overtime hours worked |
| OvertimeHourlyPay | DECIMAL(19,4) | Yes | Hourly pay rate for overtime |
| OvertimeMultiplier | FLOAT | Yes | Multiplier applied to overtime pay |
| void | BOOLEAN | Yes | Indicates if the record is voided |
Note: All fact tables also include standard ETL metadata columns (
podname,organizationid,groupid,etlCreatedDate) which are omitted from this reference for brevity.
Primary Key
factemployeepaywid
Foreign Keys
| Column | References |
|---|---|
| employeewid | Bi_DimUser.userwid |
| centerwid | Bi_DimCenter.centerwid |
| payrollstartdate | Bi_DimDate.datewid |
| payrollenddate | Bi_DimDate.datewid |
Enumerator Values
| Column | Values |
|---|---|
| void | true = Voided, false = Active |
| considerhourlypay | true = Consider, false = Ignore |
| considerservicecommission | true = Consider, false = Ignore |
Was this article helpful?
Your feedback helps us improve our documentation.