Membership dimension table
bi_dimmembership
Field | Description | Field Type | Primary Key |
|---|---|---|---|
active | DO NOT USE- THIS FIELD IS BEING DEPRECATED | boolean | |
allowgiftcertificates | boolean | ||
businessunitid | varchar ( 36 ) | ||
canbook | boolean | ||
carryovermembers | boolean | ||
code | A unique identifier for the membership. This maps to the membership code in the Membership configuration page of the core system. | varchar ( 32 ) | |
comissioneligible | is commission eligible | boolean | |
commissionfactor | double precision | ||
creationdate | timestamp without time zone | ||
creditamount | Amount credited to the eligible membership for the respective cycle. | double precision | |
creditamountexpiration | boolean | ||
differentmembershipcode | functionality to assign differents codes for member who are sold same membership | boolean | |
discounttype | type of discount : flat or percent | integer | |
displayname | display name of membership in Product | varchar ( 512 ) | |
displayprice | price to display in webstore | varchar ( 512 ) | |
enddate | last date on which membership can be sold | timestamp without time zone | |
etllastupdatedby | ETL system admin user who inserted or updated the corresponding record in this table. | varchar ( 50 ) | |
etllastupdatedon | Latest timestamp at which the corresponding record was either inserted or updated in this table. | timestamp without time zone | |
freeservicecommissioneligible | indicates if therapist can earn commission by providing service during membership redemptions | boolean | |
initiallyrecognizedamt | recoginized revenue at the time of sale of membership | numeric | |
lockcycles | duration for which membership cannot be cancelled | integer | |
membershipcategorydescription | description of membership category | varchar ( 2048 ) | |
membershipcategoryname | The category of the membership. | varchar ( 200 ) | |
membershipdays | Number of days to expire from sale date | integer | |
membershipdesc | description of membership | varchar ( 2048 ) | |
membershipid | A unique identifier for the membership.This maps to the ID in the URL in the Membership configuration page of the core system. If the mmembership type is a 'Setup Membership', this field always points to the Main Membership that the Setup is associated to. Refer example on top. | varchar ( 36 ) | |
membershipmonths | Number of months to expire from sale date | integer | |
membershipname | The name of the membership. | varchar ( 512 ) | |
membershiptype | The type of membership sold. This is usually Recurring, Non-Recurring or Set up. | integer | |
membershiptypedisplayvalue | The type of the membership. Possible values: - Recurring - Non-Recurring - Setup Membership: This is populated for memberships that have setup involved. | varchar ( 65535 ) | |
membershipversionid | A unique identifier for every version of a membership.This maps to the version ID in the URL in the Membership configuration page of the core system. | varchar ( 36 ) | |
membershipversionwid | unique identifier for a membership version | bigint | |
monthlyrecognizedamt | numeric | ||
needotpauthorization | should OTP be used during membership credit amount redemption | boolean | |
numguests | Number of guests that meet the criteria specified in the target segment. | integer | |
organizationid | varchar ( 36 ) | ||
paymenttype | integer | ||
podname | varchar ( 20 ) | ||
recurringcycle | monthly.weekly,annual, etc | varchar ( 64 ) | |
recurringcycletype | monthly.weekly,annual, etc | integer | |
recurringtype | This flag indicates whether the corresponding membership is a recurring membership. This is useful when the membership type is Set up. This field lets you know whether the set up was done for a recurring or non-recurring membership. - True indicates a recurring membership. - False indicates a non-recurring membership. | integer | |
restrictpayment | boolean | ||
saleenddate | last date of sale | timestamp without time zone | |
salestartdate | date on which sale can be started | timestamp without time zone | |
setupmembershipid | unique identifier | varchar ( 36 ) | |
showfrequencyinweeks | indicates if payment is weekly or not | boolean | |
showprice | boolean | ||
startvalidityatfirstredemption | indicates if membership should start from redemption date or sale date | boolean | |
tags | The tags associated with the membership. | varchar ( 65535 ) | |
tandcpostacceptance | varchar ( 65535 ) | ||
visitfrequencyredemption | frequency at which service can be redeemed using memberships | integer | |
void | Indicates whether the membership has been deleted from the UI. - True: Membership is voided - False: Membership is not voided | boolean | |
groupid | Internal to Zenoti. Used for data processing. | BIGINT |