ZenotiHelp

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.