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.