Add On User Membership Dimension Table
ZTZenoti Docs Team Updated April 10, 2026 1 min readGuide
Dimension table tracking add-on membership assignments to users at specific centers, including membership lifecycle dates and primary member designation.
Columns
| Column Name | Data Type | Nullable | Description |
|---|---|---|---|
| addonusermembershipwid | BIGINT IDENTITY | No | Surrogate warehouse identifier (auto-generated) |
| DimAddOnUserMembershipId | INTEGER | Yes | Source dimension identifier for the add-on user membership |
| userwid | BIGINT | Yes | Foreign key to the user dimension warehouse ID |
| centerwid | BIGINT | Yes | Foreign key to the center dimension warehouse ID |
| AddOnUserMembershipId | VARCHAR(36) | Yes | Source system unique identifier for the add-on membership assignment |
| VoidDate | TIMESTAMP | Yes | Date/time the membership was voided |
| AddDate | TIMESTAMP | Yes | Date/time the membership was added |
| MembershipCode | VARCHAR(500) | Yes | Code identifying the membership type |
| addedbywid | BIGINT | Yes | Foreign key to the user dimension for the user who added the membership |
| RemovedBywid | BIGINT | Yes | Foreign key to the user dimension for the user who removed the membership |
| IsRecordVoided | INT | Yes | Flag indicating if the record has been voided |
| PrimaryMember | INT | Yes | Flag indicating if this is the primary member on the membership |
| MembershipEndDate | TIMESTAMP | Yes | Scheduled end date of the membership |
| Void | INT | Yes | Soft-delete flag (non-zero indicates voided) |
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
addonusermembershipwid
Foreign Keys
| Column | References |
|---|---|
| userwid | the user dimension (Bi_DimUser or equivalent) |
| centerwid | the center dimension |
| addedbywid | the user dimension (user who added the membership) |
| RemovedBywid | the user dimension (user who removed the membership) |
Enumerator Values
| Column | Values |
|---|---|
| IsRecordVoided | -- 0 = active, non-zero = voided |
| PrimaryMember | -- 0 = not primary, 1 = primary member |
| Void | -- 0 = active, non-zero = voided |
Was this article helpful?
Your feedback helps us improve our documentation.