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.