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.