ZenotiHelp

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.