ZenotiHelp

Fact tables: Employees, memberships, and operations

ZTZenoti Docs Team Updated April 10, 2026 2 min readGuide

This article catalogs the fact tables for employee payroll, commissions, tips, memberships, and packages.

Before you begin

  • Your organization must have Analytics — Amazon S3 enabled with data loaded.
  • Always filter WHERE void = 0 on fact tables to return only current, active records.
  • Use WID surrogate key columns to join fact tables to dimension tables in queries.

Reminder: Always filter WHERE void = 0 on fact tables to return only current, active records.

Employee and payroll

Table Description Key measures Key dimension FKs Grain
Bi_FactEmployeePay Employee pay details per payroll interval hourlypay, servicecommission, overtime, tips employeewid, centerwid One row per employee per pay period
Bi_FactEmpSalary Employee salary with commission, tenure bonus salary, commission, tenurebonus, penalties employeewid, centerwid One row per salary record
Bi_FactEmployeeSalary Employee salary per pay period (alternate) centercommission, tenurebonus, penalties employeewid, centerwid One row per pay period
Bi_FactEmployeeSchedule Employee schedule records shiftstarttime, shiftendtime, breakminutes employeewid, centerwid, breakcategorywid One row per schedule entry
Bi_FactEmployeeCommission Employee commission per invoice commissionamount, servicecommission employeewid, centerwid One row per employee per invoice
Bi_FactEmployeeDeclareTips Employee-declared tip amounts tipamount employeewid, centerwid One row per tip declaration
Bi_FactEmployeeItemLevelCommissions Item-level commission configuration commissionpercent, labourcost employeewid, centerwid, itemtypewid One row per employee per item
Bi_FactEmployeeMembershipCommissions Commission for membership items commissionpercent employeewid, centerwid, membershipwid One row per employee per membership
Bi_FactItemCommissionDeductions Commission deduction rules deductionamount employeewid, centerwid One row per deduction rule
Bi_FactMultipleEmployeeCommission Commission for multiple employees per item commissionamount employeewid, centerwid One row per employee per item
Bi_FactTipsPayout Employee tip payout details cashpayout, checkpayout, creditcardpayout employeewid, centerwid One row per tip payout
Bi_FactEmployeeTipsAndSSGDetails Tip and service surcharge details tipamount, ssgamount employeewid, centerwid One row per employee per invoice item
Bi_FactEmployeeworktasksPayroll Employee work task payroll details hoursworked, payrate employeewid, centerwid, worktaskwid One row per work task entry
Bi_FactRecurringPaymentAmountLog Recurring payment amount logs paymentamount, discount, tax usermembershipwid One row per recurring payment log

Membership

Table Description Key measures Key dimension FKs Grain
Bi_FactMembershipDunning Membership dunning/collection records scheduledamount, actualamount, retrycount usermembershipwid, centerwid One row per dunning record
Bi_FactMembershipStatusLog Membership status change history statuschangedate usermembershipwid, membershipstatuswid One row per status change
Bi_FactMembershipStatusLogDeleted Archive for deleted membership status logs statuschangedate usermembershipwid One row per deleted log
Bi_FactMembershipTransfers Membership transfer transactions price, discount, collectionadjustment usermembershipwid, fromcenterwid, tocenterwid One row per transfer
Bi_FactMembershipUserRedemptions Membership benefit redemptions redemptionamount, revenueamount usermembershipwid, centerwid One row per redemption
Bi_FactRecurringStatusLog Recurring payment status change history statuschangedate usermembershipwid One row per status change
Bi_FactRecurringStatusLogDeleted Archive for deleted recurring status logs statuschangedate usermembershipwid One row per deleted log

Package

Table Description Key measures Key dimension FKs Grain
Bi_FactPackageUserRedemptions Package item redemptions by users saleprice, discount, paymentamount packageuserwid, centerwid, userwid One row per redemption
Bi_FactPackageValue Package sale, payment, and revenue data saleprice, discount, refund, revenueamount packageuserwid, centerwid One row per package value record
Was this article helpful?
Your feedback helps us improve our documentation.