User membership dimension table
Table name: Bi_DimUserMembership
Field | Field description | Example |
|---|---|---|
cancellationreasonfk | ||
centerid | ||
dimusermembershipid | ||
dimusermembershipwid | ||
enddate | The end date of the time period corresponding to the "membership status". Refer example on top. | |
etlcreatedby | ETL system admin user who inserted or updated the corresponding record in this table. | |
EtlLastUpdatedBy | ETL system admin user who inserted or updated the corresponding record in this table. | |
EtlLastUpdatedOn | Latest timestamp at which the corresponding record was either inserted or updated in this table. | |
hassetupfee | Indicates whether the membership version has a Setup Membership associated with it. - True: Setup membership associated - False: Setup membership not associated Refer example on top. | |
invoiceitemid | The Invoice item id of the membership. 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. | |
isautorenew | Indicates whether the membership is set to auto renew for the guest. - True: Is set to auto renew - False: Is not set to auto renew | |
iscurrentrecord | DO NOT USE- THIS FIELD IS BEING DEPRECATED | DO NOT USE- THIS FIELD IS BEING DEPRECATED |
issetupfee | DO NOT USE- THIS FIELD IS BEING DEPRECATED | DO NOT USE- THIS FIELD IS BEING DEPRECATED |
membershipenddate | The expiry date of the membership for the user, irrespective of the 'membership status' for that row. This remains constant throughout the membership lifecycle. Even if the membership gets cancelled before the expiry date, this remains constant. Refer example on top. | |
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. | |
membershipstartdate | The initial start date of the membership for the user, irrespective of the 'membership status' for that row. If a membership involves setup, this is the date on which the set up membership started. This remains constant throughout the membership lifecycle. Even if the membership gets cancelled before the expiry date, this remains constant. Refer example on top. | |
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. | |
podid | ||
recurringcancelleddate | The date from which the recurring payment for a membership is no longer carried out. | Note: This date doesn't signify the cancellation of membership. It signifies the date of cancellation of payment. |
setupusermembershipid | The usermembershipid of the Setup Membership. Refer example on top. | Populates only if a setup membership is created for a user. |
startdate | The start date of the time period corresponding to the "membership status". Refer example on top. | |
status | 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. | Upgrade or Downgrade status just indicates OPTING for an upgrade or downgrade. In this status, the current membership will continue as is until the new membership gets activated. |
terminationreason | The reason for the termination of a membership. Possible values: - Expired - Expired with prepaids remaining - Suspended - Cancelled | |
upgradedowngradefrom | The source usermembershipid for the current membership. Which membership did the current membership get upgraded/ downgraded from? Refer example on top. | |
upgradedowngradeinto | The target usermembershipid for the current membership. Which membership is the current membership getting upgraded/ downgraded to? Refer example on top. | |
userid | A unique identifier for the guest. This is a non-blank value that gets populated for every guest. | |
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. | |
void | DO NOT USE- THIS FIELD IS BEING DEPRECATED | DO NOT USE- THIS FIELD IS BEING DEPRECATED |
groupid | Internal to Zenoti. Used for data processing. | |
isvoluntarycancellation | Flag indicating whether the cancellation was voluntary |