ZenotiHelp

Membership Status Dimension Table

ZTZenoti Docs Team Updated April 10, 2026 1 min readGuide

Dimension table storing membership status definitions, mapping numeric status codes to human-readable membership and recurring status values. This is a static lookup table populated via seed data.

Columns

Column Name Data Type Nullable Description
MembershipStatusWID BIGINT IDENTITY No Surrogate warehouse key for the membership status (Primary Key)
Status INT Yes Numeric status code identifying the membership state
MembershipStatusValue VARCHAR(500) Yes Human-readable label for the membership status
RecurringStatusValue VARCHAR(500) Yes Human-readable label for the associated recurring billing status

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

MembershipStatusWID

Foreign Keys

This table has no foreign key relationships to other analytics tables.

Was this article helpful?
Your feedback helps us improve our documentation.