ZenotiHelp

Membership Transfers Fact Table

ZTZenoti Docs Team Updated April 10, 2026 1 min readGuide

Stores membership transfer transactions between centers, including pricing, discount, collection date adjustments, and transfer status details.

Columns

Column Name Data Type Nullable Description
factmembershiptransferwid BIGINT IDENTITY NOT NULL Surrogate key and primary key for the membership transfer record.
factmembershiptransferid BIGINT YES Source system identifier for the membership transfer fact.
usermembershipwid BIGINT YES Foreign key to the user membership dimension.
invoiceid VARCHAR(36) YES GUID of the associated invoice.
transfereddate TIMESTAMP YES Date/time the membership was transferred.
transfertocenterwid BIGINT YES Foreign key to the destination center (Bi_DimCenter.centerwid).
salecenterwid BIGINT YES Foreign key to the center where the membership was originally sold (Bi_DimCenter.centerwid).
membershipversionwid BIGINT YES Foreign key to the membership version dimension.
price FLOAT YES Price of the membership transfer.
isdiscount BOOLEAN YES Flag indicating whether a discount was applied to the transfer.
transferredbywid BIGINT YES Foreign key to the employee who processed the transfer (Bi_DimUser.userwid).
actualnextcollectiondate TIMESTAMP YES Actual next payment collection date.
nextcollectiondate TIMESTAMP YES Scheduled next payment collection date.
recurringenddate TIMESTAMP YES End date for recurring payments.
comments VARCHAR(MAX) YES Free-text comments about the transfer.
updatedinvoiceid VARCHAR(36) YES GUID of the updated invoice after transfer.
updatedusermembershipwid BIGINT YES Updated user membership WID after transfer.
active BOOLEAN YES Flag indicating whether the transfer record is active.
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

factmembershiptransferwid

Foreign Keys

Column References
transferredbywid Bi_DimUser.userwid
transfertocenterwid Bi_DimCenter.centerwid
salecenterwid Bi_DimCenter.centerwid

Enumerator Values

Column Values
isdiscount TRUE if a discount was applied; FALSE otherwise.
active TRUE if the transfer record is active; FALSE otherwise.
void TRUE if the record is soft-deleted; FALSE otherwise.
Was this article helpful?
Your feedback helps us improve our documentation.