ZenotiHelp

Membership User Redemptions Consolidated

ZTZenoti Docs Team Updated April 10, 2026 9 min readGuide

Consolidated membership user redemptions fact table combining membership sales, benefit redemptions, refunds, and benefit transfers with guest, employee, service, product, class, and center dimensions for comprehensive membership benefit lifecycle analytics.

Columns

Column Name Data Type Nullable Description
Record Category VARCHAR(50) Yes Category of the record (e.g., Sale, Redemption, Refund, Transfer). Sourced from Fact_MembershipUserRedemption.record_category.
User Membership ID VARCHAR(36) Yes Unique identifier of the user-membership association. Sourced from Dim_UserMembership.user_membership_id.
Membership ID VARCHAR(36) Yes Unique identifier (GUID) of the membership. Sourced from Dim_Membership.membership_id.
Membership Type VARCHAR(50) Yes Type of the membership. Sourced from Dim_Membership.membership_type.
No Of Cycles Paid INT Yes Number of billing cycles paid. Sourced from Fact_MembershipUserRedemption.no_of_cycles_paid.
Membership Start Date TIMESTAMP Yes Start date of the membership. Sourced from Dim_UserMembership.membership_start_date.
Membership End Date TIMESTAMP Yes End date of the membership. Sourced from Dim_UserMembership.membership_end_date.
Membership Status INT Yes Numeric status code of the membership. Sourced from Dim_UserMembership.membership_status.
Setup Membership Id VARCHAR(36) Yes Identifier of the setup membership. Sourced from Dim_UserMembership.setup_membership_id.
Membership Name NVARCHAR(512) Yes Name of the membership. Sourced from Dim_Membership.membership_name.
Membership Version ID VARCHAR(36) Yes Version identifier of the membership. Sourced from Dim_Membership.membership_version_id.
Membership Business Unit ID VARCHAR(36) Yes Business unit identifier of the membership. Sourced from Dim_Membership.business_unit_id.
Membership Category Name NVARCHAR(200) Yes Category name of the membership. Sourced from Dim_Membership.membership_category_name.
Cancelled Date TIMESTAMP Yes Date when the membership was cancelled. Sourced from Dim_UserMembership.cancelled_date.
Redeem Post Expiry INT Yes Whether benefits can be redeemed post expiry. Sourced from Dim_Membership.redeem_post_expiry.
Organization Name VARCHAR(512) Yes Name of the organization. Sourced from Dim_Organization.organization_name.
Organization Account Name VARCHAR(256) Yes Account name of the organization. Sourced from Dim_Organization.organization_account_name.
Center name VARCHAR(128) Yes Name of the center where the transaction occurred. Sourced from Dim_Center.center_name.
Center company name VARCHAR(128) Yes Company name of the center. Sourced from Dim_Center.company_name.
Sold Center name VARCHAR(128) Yes Name of the center where the membership was sold. Sourced from Dim_Center.center_name (sold center).
Sold Center company name VARCHAR(128) Yes Company name of the center where membership was sold. Sourced from Dim_Center.company_name (sold center).
Invoice ID VARCHAR(36) Yes Unique identifier (GUID) of the invoice. Sourced from Fact_MembershipUserRedemption.invoice_id.
Invoice Item ID VARCHAR(36) Yes Unique identifier (GUID) of the invoice item. Sourced from Fact_MembershipUserRedemption.invoice_item_id.
Invoice no NVARCHAR(80) Yes Invoice number. Sourced from Fact_MembershipUserRedemption.invoice_no.
Group Invoice Id VARCHAR(36) Yes Identifier of the group invoice. Sourced from Fact_MembershipUserRedemption.group_invoice_id.
Processed SMALLINT Yes Whether the record has been processed. Sourced from Fact_MembershipUserRedemption.processed.
Closed Date Time In Center TIMESTAMP Yes Invoice closed date and time in center timezone. Sourced from Fact_MembershipUserRedemption.closed_date_time_in_center.
Created Date In Center TIMESTAMP Yes Invoice created date in center timezone. Sourced from Fact_MembershipUserRedemption.created_date_in_center.
Item Type Code VARCHAR(100) Yes Type code of the item. Sourced from Fact_MembershipUserRedemption.item_type_code.
Item ID VARCHAR(36) Yes Unique identifier of the item. Sourced from Fact_MembershipUserRedemption.item_id.
Item Name NVARCHAR(512) Yes Name of the item. Sourced from Fact_MembershipUserRedemption.item_name.
Item Code NVARCHAR(256) Yes Code of the item. Sourced from Fact_MembershipUserRedemption.item_code.
Guest Id VARCHAR(36) Yes Unique identifier (GUID) of the guest. Sourced from Dim_User.user_id.
Guest First Name VARCHAR(160) Yes First name of the guest. Sourced from Dim_User.first_name.
Guest Last Name VARCHAR(256) Yes Last name of the guest. Sourced from Dim_User.last_name.
Guest Middle Name VARCHAR(128) Yes Middle name of the guest. Sourced from Dim_User.middle_name.
Guest City VARCHAR(128) Yes City of the guest. Sourced from Dim_User.city.
Guest Zipcode VARCHAR(128) Yes Zip/postal code of the guest. Sourced from Dim_User.zipcode.
Guest Base Center VARCHAR(256) Yes Base/home center of the guest. Sourced from Dim_User.base_center.
Guest Type Name VARCHAR(128) Yes Type classification of the guest. Sourced from Dim_User.guest_type_name.
Guest Email VARCHAR(256) Yes Email address of the guest. Sourced from Dim_User.email.
Guest Mobile Phone VARCHAR(64) Yes Mobile phone number of the guest. Sourced from Dim_User.mobile_phone.
Guest Home Phone VARCHAR(64) Yes Home phone number of the guest. Sourced from Dim_User.home_phone.
Guest Phone Code INTEGER Yes Phone country code of the guest. Sourced from Dim_User.phone_code.
Guest Code VARCHAR(128) Yes Unique code of the guest. Sourced from Dim_User.guest_code.
Guest Gender VARCHAR(14) Yes Gender of the guest. Sourced from Dim_User.gender.
Guest State VARCHAR(4096) Yes State of the guest address. Sourced from Dim_User.state.
Guest Country Name VARCHAR(4096) Yes Country name of the guest. Sourced from Dim_User.country_name.
Is Guest InActive BOOLEAN Yes Whether the guest is inactive. Sourced from Dim_User.is_inactive.
Guest Tags VARCHAR(65535) Yes Tags associated with the guest. Sourced from Dim_User.tags.
Sold to Guest Id VARCHAR(36) Yes GUID of the guest who originally purchased the membership. Sourced from Fact_MembershipUserRedemption.sold_to_guest_id.
Sold to Guest Code VARCHAR(128) Yes Code of the guest who originally purchased the membership. Sourced from Fact_MembershipUserRedemption.sold_to_guest_code.
Closed By User Id VARCHAR(36) Yes User ID of the person who closed the invoice. Sourced from Fact_MembershipUserRedemption.closed_by_user_id.
Closed By User Code VARCHAR(128) Yes Code of the user who closed the invoice. Sourced from Fact_MembershipUserRedemption.closed_by_user_code.
Closed By User - Code VARCHAR(128) Yes Alternate code of the user who closed the invoice. Sourced from Fact_MembershipUserRedemption.closed_by_user_code_alt.
Created By User Id VARCHAR(36) Yes User ID of the person who created the invoice. Sourced from Fact_MembershipUserRedemption.created_by_user_id.
Created By User Code VARCHAR(128) Yes Code of the user who created the invoice. Sourced from Fact_MembershipUserRedemption.created_by_user_code.
Created By User - Code VARCHAR(128) Yes Alternate code of the user who created the invoice. Sourced from Fact_MembershipUserRedemption.created_by_user_code_alt.
Employee First Name VARCHAR(160) Yes First name of the selling employee. Sourced from Dim_Employee.first_name.
Employee Last Name VARCHAR(256) Yes Last name of the selling employee. Sourced from Dim_Employee.last_name.
Employee Middle Name VARCHAR(128) Yes Middle name of the selling employee. Sourced from Dim_Employee.middle_name.
Employee Mobile Phone VARCHAR(64) Yes Mobile phone of the selling employee. Sourced from Dim_Employee.mobile_phone.
Employee Code VARCHAR(128) Yes Code of the selling employee. Sourced from Dim_Employee.employee_code.
Employee - Code VARCHAR(128) Yes Alternate code of the selling employee. Sourced from Dim_Employee.employee_code_alt.
Employee Gender VARCHAR(14) Yes Gender of the selling employee. Sourced from Dim_Employee.gender.
Employee Job Name VARCHAR(1020) Yes Job title of the selling employee. Sourced from Dim_Employee.job_name.
Employee Job Code VARCHAR(1020) Yes Job code of the selling employee. Sourced from Dim_Employee.job_code.
Is Employee InActive BOOLEAN Yes Whether the selling employee is inactive. Sourced from Dim_Employee.is_inactive.
Service Name VARCHAR(512) Yes Name of the service. Sourced from Dim_Service.service_name.
Service Length INTEGER Yes Duration of the service in minutes. Sourced from Dim_Service.service_length.
Service Category VARCHAR(256) Yes Category of the service. Sourced from Dim_Service.service_category.
Service Parent Category VARCHAR(256) Yes Parent category of the service. Sourced from Dim_Service.parent_category.
Service Has Variant VARCHAR(14) Yes Whether the service has variants. Sourced from Dim_Service.has_variant.
Service Is Variant VARCHAR(14) Yes Whether the service is itself a variant. Sourced from Dim_Service.is_variant.
Service BusinessUnit VARCHAR(200) Yes Business unit of the service. Sourced from Dim_Service.businessunit.
Is Service InActive BOOLEAN Yes Whether the service is inactive. Sourced from Dim_Service.is_inactive.
Service Tags VARCHAR(65535) Yes Tags associated with the service. Sourced from Dim_Service.tags.
Product Name VARCHAR(256) Yes Name of the product. Sourced from Dim_Product.product_name.
Product Category VARCHAR(256) Yes Category of the product. Sourced from Dim_Product.product_category.
Product Parent Category VARCHAR(256) Yes Parent category of the product. Sourced from Dim_Product.parent_category.
Product Business Unit VARCHAR(200) Yes Business unit of the product. Sourced from Dim_Product.business_unit.
Product Has Variant BOOLEAN Yes Whether the product has variants. Sourced from Dim_Product.has_variant.
Is Product InActive BOOLEAN Yes Whether the product is inactive. Sourced from Dim_Product.is_inactive.
Product Tags VARCHAR(65535) Yes Tags associated with the product. Sourced from Dim_Product.tags.
Class ID VARCHAR(36) Yes Unique identifier of the class. Sourced from Fact_MembershipUserRedemption.class_id.
Class Name VARCHAR(256) Yes Name of the class. Sourced from Fact_MembershipUserRedemption.class_name.
Actual Quantity FLOAT Yes Actual quantity of items/services. Sourced from Fact_MembershipUserRedemption.actual_quantity.
Service Credit Amount FLOAT Yes Service credit amount from the membership. Sourced from Fact_MembershipUserRedemption.service_credit_amount.
Product Credit Amount FLOAT Yes Product credit amount from the membership. Sourced from Fact_MembershipUserRedemption.product_credit_amount.
Other Credit Amount FLOAT Yes Other credit amount from the membership. Sourced from Fact_MembershipUserRedemption.other_credit_amount.
Total Credit Amount FLOAT Yes Total credit amount from the membership. Sourced from Fact_MembershipUserRedemption.total_credit_amount.
Setup fee FLOAT Yes Setup fee amount. Sourced from Fact_MembershipUserRedemption.setup_fee.
Sale Price FLOAT Yes Sale price of the membership. Sourced from Fact_MembershipUserRedemption.sale_price.
Discount FLOAT Yes Discount amount applied. Sourced from Fact_MembershipUserRedemption.discount.
Taxes FLOAT Yes Tax amount. Sourced from Fact_MembershipUserRedemption.taxes.
Final Sale Price FLOAT Yes Final sale price after discount and taxes. Sourced from Fact_MembershipUserRedemption.final_sale_price.
Quantity Used FLOAT Yes Quantity of benefits used/redeemed. Sourced from Fact_MembershipUserRedemption.quantity_used.
Redemption Amount FLOAT Yes Monetary amount of the redemption. Sourced from Fact_MembershipUserRedemption.redemption_amount.
Item Revenue FLOAT Yes Revenue attributed to the item. Sourced from Fact_MembershipUserRedemption.item_revenue.
Benefit Redemption Date TIMESTAMP Yes Date when the benefit was redeemed. Sourced from Fact_MembershipUserRedemption.benefit_redemption_date.
Return Value FLOAT Yes Refund/return value. Sourced from Fact_MembershipUserRedemption.return_value.
Return Date TIMESTAMP Yes Date of the return/refund. Sourced from Fact_MembershipUserRedemption.return_date.
Sold Invoice Item ID VARCHAR(36) Yes Invoice item ID of the original sale. Sourced from Fact_MembershipUserRedemption.sold_invoice_item_id.
Transfer Detail ID VARCHAR(36) Yes Identifier for the transfer detail. Sourced from Fact_MembershipUserRedemption.transfer_detail_id.
Transferred Quantity FLOAT Yes Quantity of benefits transferred. Sourced from Fact_MembershipUserRedemption.transferred_quantity.
Service Category ID VARCHAR(36) Yes Identifier of the service category. Sourced from Fact_MembershipUserRedemption.service_category_id.
Membership Service Price FLOAT Yes Price of the membership service. Sourced from Fact_MembershipUserRedemption.membership_service_price.
Benefit Accrued Date TIMESTAMP Yes Date when the benefit was accrued. Sourced from Fact_MembershipUserRedemption.benefit_accrued_date.
Benefit Expiration Date TIMESTAMP Yes Date when the benefit expires. Sourced from Fact_MembershipUserRedemption.benefit_expiration_date.
Shared On_Transferred TIMESTAMP Yes Date when the benefit was shared or transferred. Sourced from Fact_MembershipUserRedemption.shared_on_transferred.
Transferred to User Id VARCHAR(36) Yes User ID of the transfer recipient. Sourced from Fact_MembershipUserRedemption.transferred_to_user_id.
Transferred to Guest Code VARCHAR(128) Yes Guest code of the transfer recipient. Sourced from Fact_MembershipUserRedemption.transferred_to_guest_code.
Transferred to Center name VARCHAR(128) Yes Center name of the transfer destination. Sourced from Dim_Center.center_name (transferred to).
Transferred to Center company name VARCHAR(128) Yes Company name of the transfer destination center. Sourced from Dim_Center.company_name (transferred to).
Minutes To ADD INTEGER Yes Minutes offset to add for timezone conversion. Sourced from Dim_Center.minutes_to_add.
Unused Amount NUMERIC(18,4) Yes Unused/remaining amount from benefits. Sourced from Fact_MembershipUserRedemption.unused_amount.
AccuralInvoiceID VARCHAR(36) Yes Accrual invoice identifier. Sourced from Fact_MembershipUserRedemption.accural_invoice_id.
AccuralInvoiceItemID VARCHAR(36) Yes Accrual invoice item identifier. Sourced from Fact_MembershipUserRedemption.accural_invoice_item_id.
UnitBenefitLevelPayment FLOAT Yes Payment at unit benefit level. Sourced from Fact_MembershipUserRedemption.unit_benefit_level_payment.
Zone name VARCHAR(800) Yes Name of the zone. Sourced from Dim_Center.zone_name.
Sold Zone name VARCHAR(800) Yes Zone name of the selling center. Sourced from Dim_Center.zone_name (sold center).
benefitconversionpk BIGINT Yes Primary key for benefit conversion. Sourced from Fact_MembershipUserRedemption.benefit_conversion_pk.
factsegmentwid BIGINT Yes Warehouse identifier for the segment fact. Sourced from Fact_MembershipUserRedemption.factsegmentwid.
benefits ignored SMALLINT Yes Whether benefits were ignored. Sourced from Fact_MembershipUserRedemption.benefits_ignored.
User GuestPassID VARCHAR(36) Yes Guest pass identifier for the user. Sourced from Fact_MembershipUserRedemption.user_guestpass_id.
GuestPasses Per Period INTEGER Yes Number of guest passes per period. Sourced from Fact_MembershipUserRedemption.guestpasses_per_period.
Max Passes Allowed INTEGER Yes Maximum number of passes allowed. Sourced from Fact_MembershipUserRedemption.max_passes_allowed.
Session Name VARCHAR(256) Yes Name of the class session. Sourced from Fact_MembershipUserRedemption.session_name.
Center Code VARCHAR(40) Yes Code of the center. Sourced from Dim_Center.center_code.
Sold Center Code VARCHAR(40) Yes Code of the selling center. Sourced from Dim_Center.center_code (sold center).
Transferred to Center Code VARCHAR(40) Yes Code of the transfer destination center. Sourced from Dim_Center.center_code (transferred to).
Class Category VARCHAR(512) Yes Category of the class. Sourced from the class dimension.

Primary Key

No explicit primary key defined. The combination of User Membership ID, Center name, and Invoice Item ID serves as a logical compound key (reflected in SORTKEY).

Foreign Keys

  • User Membership ID - References Dim_UserMembership.user_membership_id
  • Membership ID - References Dim_Membership.membership_id
  • Membership Version ID - References Dim_Membership.membership_version_id
  • Membership Business Unit ID - References the business unit
  • Setup Membership Id - References the setup membership
  • Invoice ID - References the invoice record
  • Invoice Item ID - References the invoice item record
  • Group Invoice Id - References the group invoice
  • Guest Id - References Dim_User.user_id
  • Sold to Guest Id - References Dim_User (original purchaser)
  • Closed By User Id - References the closing user
  • Created By User Id - References the creating user
  • Transferred to User Id - References Dim_User (transfer recipient)
  • Transfer Detail ID - References the transfer detail
  • Service Category ID - References the service category
  • Item ID - References the item
  • Sold Invoice Item ID - References the original sale invoice item
  • AccuralInvoiceID - References the accrual invoice
  • AccuralInvoiceItemID - References the accrual invoice item
  • benefitconversionpk - References the benefit conversion record
  • factsegmentwid / factsegmentid - References the segment fact
  • User GuestPassID - References the guest pass
  • Class ID - References the class

Enumerator Values

Column Name Known Values
Record 0 = Not Applicable
1 = Accrual
2 = Redemption
Membership 0 = Non-Recurring
1 = Recurring
3 = All
Membership 0 = Non-Recurring
1 = Recurring
3 = All
Item -1 = None
0 = Service
2 = Product
3 = Membership
4 = Series Package
5 = Day/Promo Package
6 = Gift Card
8 = Employee
11 = Class
14 = Add-ons
-90 = Service Refund
-92 = Product Refund
-93 = Membership Refund
-94 = Series Package Refund
-95 = Day Package Refund
-96 = Gift Card Refund
-911 = Class Refund
Processed Processing status (0/1)

Standard ETL metadata columns (EtlLastUpdatedOn, EtlLastUpdatedBy, podname, groupid) are present in the underlying table but omitted from this reference for brevity.

Was this article helpful?
Your feedback helps us improve our documentation.