ZenotiHelp

Membership User Redemptions Fact Table

ZTZenoti Docs Team Updated April 10, 2026 4 min readGuide

Tracks membership benefit redemptions and revenue recognition, including membership lifecycle events, benefit transfers, credit amounts, and service/product usage details.

Columns

Column Name Data Type Nullable Description
factsegmentwid BIGINT IDENTITY NOT NULL Surrogate key for the membership redemption fact record.
factsegmentid BIGINT NULL Business/natural key for the fact segment.
itemwid BIGINT NULL Foreign key to the item dimension.
productwid BIGINT NULL Foreign key to the product dimension.
servicewid BIGINT NULL Foreign key to the service dimension.
itemtypewid BIGINT NULL Foreign key to the item type dimension.
centerwid BIGINT NULL Foreign key to the center dimension.
userwid BIGINT NULL Foreign key to the guest/customer user dimension.
salebywid BIGINT NULL Foreign key to the employee who made the sale.
membershipversionwid BIGINT NULL Foreign key to the membership version dimension.
membershipid VARCHAR(36) NULL Unique identifier (GUID) of the membership.
setupmembershipid VARCHAR(36) NULL GUID of the setup/template membership.
usermembershipwid BIGINT NULL Foreign key to the user-membership association.
membershipcategoryid VARCHAR(36) NULL GUID of the membership category.
membershipbusinessunitid VARCHAR(36) NULL GUID of the membership business unit.
membershipdays INTEGER NULL Number of days in the membership period.
showfrequencyinweeks INTEGER NULL Frequency of benefit display in weeks.
isrecurringmembership INTEGER NULL Flag indicating if membership is recurring (1=yes, 0=no).
noofcyclespaid INTEGER NULL Number of billing cycles paid.
membershipstartdate TIMESTAMP NULL Start date of the membership.
membershipenddate TIMESTAMP NULL End date of the membership.
membershipstatus INTEGER NULL Status code of the membership.
actualquantity DOUBLE PRECISION NULL Actual quantity of benefits available.
quantityused DOUBLE PRECISION NULL Quantity of benefits used/redeemed.
servicecreditamount DOUBLE PRECISION NULL Service credit amount included in the membership.
productcreditamount DOUBLE PRECISION NULL Product credit amount included in the membership.
othercreditamount DOUBLE PRECISION NULL Other credit amount included in the membership.
totalcreditamount DOUBLE PRECISION NULL Total credit amount across all categories.
setupfee DOUBLE PRECISION NULL One-time setup fee for the membership.
saleprice DOUBLE PRECISION NULL Sale price of the membership.
discount DOUBLE PRECISION NULL Discount amount applied.
taxes DOUBLE PRECISION NULL Tax amount applied.
finalsaleprice DOUBLE PRECISION NULL Final sale price after discount and tax.
redemptionamount DOUBLE PRECISION NULL Monetary value of the redemption.
itemrevenue DOUBLE PRECISION NULL Revenue attributed to the item.
recordcategory VARCHAR(50) NULL Category of the record (e.g., sale, redemption, accrual).
void BOOLEAN NULL Indicates whether the record has been voided.
podid INTEGER NULL Identifier of the source pod/database.
invoiceid VARCHAR(36) NULL Unique identifier (GUID) of the invoice.
benefitexpirationdays INTEGER NULL Number of days until the benefit expires.
benefitcreationdate TIMESTAMP NULL Date when the benefit was created.
invoiceitemid VARCHAR(36) NULL Unique identifier (GUID) of the invoice item.
invoice_no VARCHAR(80) NULL Human-readable invoice number.
groupinvoiceid VARCHAR(36) NULL GUID of the group invoice.
closebywid BIGINT NULL Foreign key to the employee who closed the invoice.
createdbywid BIGINT NULL Foreign key to the employee who created the record.
processed SMALLINT NULL Processing status flag.
closeddatetimeincenter TIMESTAMP NULL Invoice close date and time in center timezone.
createddateincenter TIMESTAMP NULL Record creation date in center timezone.
cancelleddate TIMESTAMP NULL Date when the membership was cancelled.
initiallyrecognizedamt DOUBLE PRECISION NULL Initially recognized revenue amount.
monthlyrecognizedamt DOUBLE PRECISION NULL Monthly recognized revenue amount.
freeservicerecognizedamt DOUBLE PRECISION NULL Recognized amount for free services.
redeempostexpiry INTEGER NULL Flag indicating if redemption is allowed post-expiry.
soldtouserwid BIGINT NULL Foreign key to the user to whom the membership was sold.
soldatcenterwid BIGINT NULL Foreign key to the center where the membership was sold.
productname VARCHAR(512) NULL Name of the product redeemed.
servicename VARCHAR(256) NULL Name of the service redeemed.
classid VARCHAR(36) NULL GUID of the class.
classname VARCHAR(256) NULL Name of the class.
benefitredemptiondate TIMESTAMP NULL Date when the benefit was redeemed.
returnvalue DOUBLE PRECISION NULL Value of any returned item.
returndate TIMESTAMP NULL Date of the return.
soldinvoiceitemid VARCHAR(36) NULL GUID of the original sold invoice item.
transferdetailid VARCHAR(36) NULL GUID of the transfer detail record.
transferredquantity DOUBLE PRECISION NULL Quantity transferred to another user/center.
servicecategoryid VARCHAR(36) NULL GUID of the service category.
membershipserviceprice DOUBLE PRECISION NULL Price of the membership service.
membershipservicepricewithoutrecognizedrevenue DOUBLE PRECISION NULL Membership service price excluding recognized revenue.
accrueddate TIMESTAMP NULL Date when revenue was accrued.
benefitexpirationdate TIMESTAMP NULL Date when the benefit expires.
sharedon_transferred TIMESTAMP NULL Date when the benefit was shared or transferred.
useridto_transferredwid BIGINT NULL Foreign key to the user who received the transfer.
centeridto_transferredwid BIGINT NULL Foreign key to the center that received the transfer.
unusedamount NUMERIC(18,4) NULL Unused credit or benefit amount.
benefitsignored SMALLINT NULL Flag indicating if benefits were ignored.
userguestpassid VARCHAR(36) NULL GUID of the associated user guest pass.
numberperperiod INTEGER NULL Number of benefits available per period.
maxpassesallowed INTEGER NULL Maximum number of guest passes allowed.
dimsessionwid DECIMAL(19,0) NULL Foreign key to the session dimension.
classcategory VARCHAR(512) YES Class category name.

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

Primary Key

factsegmentwid

Foreign Keys

Column References
centerwid Bi_DimCenter.centerwid
soldatcenterwid Bi_DimCenter.centerwid
centeridto_transferredwid Bi_DimCenter.centerwid
userwid Bi_DimUser.userwid
salebywid Bi_DimUser.userwid
closebywid Bi_DimUser.userwid
createdbywid Bi_DimUser.userwid
soldtouserwid Bi_DimUser.userwid
useridto_transferredwid Bi_DimUser.userwid

Enumerator Values

Column Values
membershipstatus 1 = Active
2 = InActive
3 = Frozen
4 = Cancelled
5 = Expired
6 = Closed (Expired with Prepaids)
7 = Not Started
8 = Suspended
9 = Refund
10 = Deleted
12 = Failed
13 = Upgrade
14 = Downgrade
15 = Pending
16 = Transferred
isrecurringmembership 1 = recurring, 0 = non-recurring
void FALSE = Active, TRUE = Voided
processed 0 = Unprocessed
1 = Processed
redeempostexpiry 1 = allowed to redeem post-expiry, 0 = not allowed
benefitsignored 1 = benefits ignored, 0 = benefits active
recordcategory Sale
Redemption
Refund
Transfer
Adjustment
showfrequencyinweeks 1 = Show in weeks; 0 = Show in days.
Was this article helpful?
Your feedback helps us improve our documentation.