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_idMembership ID- References Dim_Membership.membership_idMembership Version ID- References Dim_Membership.membership_version_idMembership Business Unit ID- References the business unitSetup Membership Id- References the setup membershipInvoice ID- References the invoice recordInvoice Item ID- References the invoice item recordGroup Invoice Id- References the group invoiceGuest Id- References Dim_User.user_idSold to Guest Id- References Dim_User (original purchaser)Closed By User Id- References the closing userCreated By User Id- References the creating userTransferred to User Id- References Dim_User (transfer recipient)Transfer Detail ID- References the transfer detailService Category ID- References the service categoryItem ID- References the itemSold Invoice Item ID- References the original sale invoice itemAccuralInvoiceID- References the accrual invoiceAccuralInvoiceItemID- References the accrual invoice itembenefitconversionpk- References the benefit conversion recordfactsegmentwid/factsegmentid- References the segment factUser GuestPassID- References the guest passClass 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.