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.