Membership Dimension Table
ZTZenoti Docs Team Updated April 10, 2026 3 min readGuide
Dimension table storing membership version definitions including pricing, validity, commission settings, recurring billing configuration, and catalog display options. Populated from the membership and membership version master data.
Columns
| Column Name | Data Type | Nullable | Description |
|---|---|---|---|
| membershipversionwid | BIGINT IDENTITY | No | Surrogate warehouse key for the membership version dimension, auto-generated |
| membershipversionid | VARCHAR(36) | Yes | Natural unique identifier (GUID) of the membership version from the source system |
| membershipname | VARCHAR(512) | Yes | Name of the membership |
| membershipdays | INTEGER | Yes | Duration of the membership in days |
| salestartdate | TIMESTAMP | Yes | Date when the membership version becomes available for sale |
| saleenddate | TIMESTAMP | Yes | Date when the membership version is no longer available for sale |
| membershipcategoryname | VARCHAR(200) | Yes | Name of the membership category |
| membershipcategorydescription | VARCHAR(2048) | Yes | Description of the membership category |
| membershipdesc | VARCHAR(2048) | Yes | Detailed description of the membership |
| creationdate | TIMESTAMP | Yes | Timestamp when the membership record was created |
| creditamount | DOUBLE PRECISION | Yes | Credit amount included with the membership |
| active | BOOLEAN | Yes | Whether the membership version is currently active |
| comissioneligible | BOOLEAN | Yes | Whether the membership is eligible for commission |
| membershipid | VARCHAR(36) | Yes | Identifier of the parent membership definition |
| enddate | TIMESTAMP | Yes | End date of the membership version validity |
| creditamountexpiration | BOOLEAN | Yes | Whether the credit amount expires |
| numguests | INTEGER | Yes | Number of guests allowed under the membership |
| allowgiftcertificates | BOOLEAN | Yes | Whether gift certificates can be used with this membership |
| differentmembershipcode | BOOLEAN | Yes | Whether a different membership code is assigned per member |
| commissionfactor | DOUBLE PRECISION | Yes | Commission factor/multiplier for the membership |
| initiallyrecognizedamt | NUMERIC(19,4) | Yes | Amount recognized as revenue at the time of sale |
| monthlyrecognizedamt | NUMERIC(19,4) | Yes | Amount recognized as revenue on a monthly basis |
| restrictpayment | BOOLEAN | Yes | Whether payment methods are restricted for this membership |
| code | VARCHAR(32) | Yes | Short code identifier for the membership |
| needotpauthorization | BOOLEAN | Yes | Whether OTP authorization is required for redemption |
| freeservicecommissioneligible | BOOLEAN | Yes | Whether free services under this membership are commission-eligible |
| discounttype | INTEGER | Yes | Type of discount applied (enumerated value) |
| displayname | VARCHAR(512) | Yes | Display name for the membership in catalogs |
| displayprice | VARCHAR(512) | Yes | Display price string for the membership |
| showprice | BOOLEAN | Yes | Whether the price should be displayed in the catalog |
| businessunitid | VARCHAR(36) | Yes | Identifier of the business unit the membership belongs to |
| showfrequencyinweeks | BOOLEAN | Yes | Whether to show redemption frequency in weeks |
| membershipmonths | INTEGER | Yes | Duration of the membership in months |
| recurringtype | INTEGER | Yes | Type of recurring billing (enumerated value) |
| carryovermembers | BOOLEAN | Yes | Whether members can be carried over to the next cycle |
| recurringcycle | VARCHAR(64) | Yes | Definition of the recurring billing cycle |
| recurringcycletype | INTEGER | Yes | Type of recurring cycle (enumerated value) |
| lockcycles | INTEGER | Yes | Number of mandatory billing cycles before cancellation is allowed |
| paymenttype | INTEGER | Yes | Payment method type (enumerated value) |
| startvalidityatfirstredemption | BOOLEAN | Yes | Whether membership validity starts at first redemption rather than purchase |
| visitfrequencyredemption | INTEGER | Yes | Maximum visit/redemption frequency allowed |
| canbook | BOOLEAN | Yes | Whether members can make bookings with this membership |
| membershiptype | INTEGER | Yes | Type of membership (enumerated value) |
| membershiptypedisplayvalue | VARCHAR(65535) | Yes | Display value for the membership type |
| setupmembershipid | VARCHAR(36) | Yes | Reference to the setup/template membership definition |
| void | BOOLEAN | Yes | Soft-delete flag; TRUE indicates the record is voided/inactive |
| tags | VARCHAR(65535) | Yes | Tags associated with the membership for categorization/filtering |
| tandcpostacceptance | VARCHAR(65535) | Yes | Terms and conditions text shown post-acceptance |
Note: All dimension tables also include standard ETL metadata columns (
podname,organizationid,groupid,etlLastUpdatedOn,etlLastUpdatedBy) which are omitted from this reference for brevity.
Primary Key
membershipversionwid
Foreign Keys
| Column | References |
|---|---|
| organizationid | Bi_DimCenter |
| membershipid | the parent membership definition |
| businessunitid | the business unit entity |
| setupmembershipid | the template/setup membership |
Enumerator Values
| Column | Values |
|---|---|
| discounttype | 1 = Percentage 2 = Flat Amount 3 = Custom |
| recurringtype | 0 = Non-Recurring 1 = Recurring |
| recurringcycletype | 1 = Weekly 2 = Bi-Weekly 3 = Monthly 4 = Quarterly 5 = Annually |
| paymenttype | 1 = Cash 2 = Card 3 = Check 4 = Custom 5 = Membership Credit 6 = Gift Card 7 = PPC (Pre-Paid Card) 8 = Loyalty Points 9 = Package Usage 10 = Membership Usage 11 = CashBack |
| membershiptype | 0 = Non-Recurring 1 = Recurring 3 = All |
Was this article helpful?
Your feedback helps us improve our documentation.