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 = 0on 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 = 0on 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.