ZenotiHelp

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.