Membership user dimension table
bi_dimmembershipuser
Field | Description | Field Type | Primary Key |
|---|---|---|---|
acceptedfromip | varchar ( 2048 ) | ||
acceptedon | timestamp without time zone | ||
businessunitid | varchar ( 36 ) | ||
cancellationsource | varchar ( 256 ) | ||
cancelledby | varchar ( 144 ) | ||
cancelleddate | varchar ( 256 ) | ||
centerid | varchar ( 36 ) | ||
childinvoiceid | varchar ( 36 ) | ||
closed | smallint | ||
closedby | varchar ( 144 ) | ||
closedinvoice | varchar ( 144 ) | ||
closedon | timestamp without time zone | ||
code | varchar ( 256 ) | ||
creationdate | timestamp without time zone | ||
creditamount | double precision | ||
displayprice | varchar ( 512 ) | ||
enddate | The end date of the time period corresponding to the "membership status". Refer example on top. | 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 | |
firstname | varchar ( 1024 ) | ||
firstsale | smallint | ||
groupusermembershipid | varchar ( 36 ) | ||
invoiceid | varchar ( 36 ) | ||
lastname | varchar ( 1024 ) | ||
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 ) | |
membershipname | varchar ( 512 ) | ||
membershipstatus | Status of the membership between "membership start date" and "membership end date". Possible values: - Active - Frozen - Suspended - Expired with prepaids remaining - Upgrade (when the current membership is opted for an upgrade) - Downgrade (when the current membership is opted for an downgrade) - Upgraded (when the opted upgrade has actually started) - Downgraded (when the opted downgrade has actually started) - Not Applicable (when there are multiple status changes on the same day. These are not considered valid statuses when that happens) Refer example on top. | integer | |
noofcyclespaid | integer | ||
numvisits | integer | ||
organizationid | varchar ( 36 ) | ||
othercreditamt | double precision | ||
podname | varchar ( 20 ) | ||
previoususermembershipid | varchar ( 36 ) | ||
productcreditamt | double precision | ||
recurrenceorder | integer | ||
recurring | integer | ||
redeempostexpiry | smallint | ||
renewaldiscountappliedby | varchar ( 144 ) | ||
renewaldiscountappliedon | timestamp without time zone | ||
renewalmembershipid | varchar ( 144 ) | ||
renewmembershipamount | double precision | ||
salecenterid | varchar ( 36 ) | ||
servicecreditamt | double precision | ||
startdate | The start date of the time period corresponding to the "membership status". Refer example on top. | timestamp without time zone | |
subscriptionsource | integer | ||
subscriptionstatus | integer | ||
transactioninvoiceno | varchar ( 256 ) | ||
userid | A unique identifier for the guest. This is a non-blank value that gets populated for every guest. | varchar ( 36 ) | |
usermembershipid | A unique identifier for every membership sold. 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 ) | |
usermembershipwid | bigint | ||
void | smallint | ||
primarypaymenttype | Indicates primary payment type for recurring collections. E.g: cash, cheque, Credit card, etc. | NVARCHAR(800) | |
primarypaymentbrand | Brand of primary payment type | NVARCHAR(256) | |
backuppaymenttype | Indicates Secondary payment type for recurring collections. E.g: cash, cheque, Credit card, etc. | NVARCHAR(800) | |
backuppaymentbrand | Brand of Secondary payment type | NVARCHAR(256) | |
groupid | Internal to Zenoti. Used for data processing. | BIGINT | |
primarypaymentcardtype | varchar(50) | ||
backuppaymentcardtype | varchar(50) | ||
isprimarycardfromvault | boolean | ||
isbackupcardfromvault | boolean | ||
primaryisscotiasupported | boolean | ||
backupisscotiasupported | boolean | ||
paymentamount | float | ||
discountamount | float | ||
taxamount | float | ||
annualfeeamount | float | ||
annualfeediscount | float | ||
annualfeetaxamount | float | ||
cancellationinitiatedon | timestamp | ||
graceperioddate | timestamp |