ZenotiHelp

User Membership Dimension Table

ZTZenoti Docs Team Updated April 10, 2026 2 min readGuide

Slowly changing dimension (SCD) table tracking each user's membership subscription lifecycle, including start/end dates, status transitions, auto-renewal, and upgrade/downgrade lineage. Populated from user-membership transactional data.

Columns

Column Name Data Type Nullable Description
dimusermembershipwid BIGINT IDENTITY No Surrogate warehouse key for the user membership dimension
dimusermembershipid NUMERIC(19,0) Yes Natural numeric identifier of the user membership record
podid INTEGER Yes Identifier of the source pod
userid VARCHAR(36) Yes Identifier of the guest/user who holds the membership
membershipid VARCHAR(36) Yes Identifier of the membership plan
membershipversionid VARCHAR(36) Yes Identifier of the specific membership version
usermembershipid VARCHAR(36) Yes Unique identifier of the user-membership association
centerid VARCHAR(36) Yes Identifier of the center where the membership was sold
startdate DATE Yes Effective start date of the membership period
enddate DATE Yes Effective end date of the membership period
status SMALLINT Yes Numeric status code of the membership (e.g., Active, Expired, Cancelled)
hassetupfee BOOLEAN Yes Flag indicating whether the membership includes a setup fee
issetupfee BOOLEAN Yes Flag indicating whether this record represents the setup-fee component
iscurrentrecord BOOLEAN Yes SCD flag; TRUE indicates this is the most recent version of the record
terminationreason INTEGER Yes Enumerated reason code for membership termination
setupusermembershipid VARCHAR(36) Yes Identifier linking to the parent setup-fee user membership
invoiceitemid VARCHAR(36) Yes Identifier of the invoice item associated with the membership sale
isautorenew VARCHAR(10) Yes Flag indicating whether the membership is set to auto-renew
etlcreatedby INTEGER Yes Identifier of the ETL process that created the record
void BOOLEAN Yes Soft-delete flag; TRUE means the record is logically deleted
recurringcancelleddate DATE Yes Date on which the recurring billing was cancelled
cancellationreasonfk BIGINT Yes Foreign key to the cancellation reason dimension
membershipenddate DATE Yes Contractual end date of the membership plan
membershipstartdate DATE Yes Contractual start date of the membership plan
upgradedowngradeinto VARCHAR(36) Yes Identifier of the membership this record was upgraded/downgraded into
upgradedowngradefrom VARCHAR(36) Yes Identifier of the membership this record was upgraded/downgraded from
isvoluntarycancellation BOOLEAN Yes Flag indicating whether the cancellation was voluntary (added via ALTER)

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

dimusermembershipwid

Foreign Keys

Column References
userid Bi_DimUser / Bi_DimGuest
membershipid Bi_DimMembership.membershipid
membershipversionid Membership version reference
centerid Bi_DimCenter.centerid
cancellationreasonfk Bi_DimReasons.reasonwid
invoiceitemid Fact invoice item reference
setupusermembershipid Self-referencing (setup-fee parent)
upgradedowngradeinto Self-referencing (target membership)
upgradedowngradefrom Self-referencing (source membership)

Enumerator Values

Column Values
status 1 = Active
3 = Frozen
4 = Cancelled
5 = Expired
6 = Expired with Prepaids
8 = Suspended
terminationreason 4 = Cancelled
5 = Expired
8 = Suspended
Was this article helpful?
Your feedback helps us improve our documentation.