ZenotiHelp

Employee Membership Commissions Fact Table

ZTZenoti Docs Team Updated April 10, 2026 1 min readGuide

Stores employee-level commission configuration for membership items, including commission percentage values per center.

Columns

Column Name Data Type Nullable Description
employeemembershipcommissionwid BIGINT IDENTITY NOT NULL Surrogate key and primary key for the employee membership commission record.
empmembershippk BIGINT YES Source system primary key for the employee membership commission.
employeewid BIGINT YES Foreign key to the employee dimension (Bi_DimUser.userwid).
itemwid BIGINT YES Foreign key to the membership item dimension.
centerwid BIGINT YES Foreign key to the center dimension (Bi_DimCenter.centerwid).
commpercentvalue VARCHAR(80) YES Commission percentage or value configuration.
podid INTEGER YES Identifier for the pod (database partition).
void BOOLEAN YES Soft-delete flag indicating the record is logically deleted.

Note: All fact tables also include standard ETL metadata columns (podname, organizationid, groupid, etlCreatedDate) which are omitted from this reference for brevity.

Primary Key

employeemembershipcommissionwid

Foreign Keys

Column References
employeewid Bi_DimUser.userwid
centerwid Bi_DimCenter.centerwid

Enumerator Values

Column Values
void TRUE if the record is soft-deleted; FALSE otherwise.
Was this article helpful?
Your feedback helps us improve our documentation.