ZenotiHelp

Membership Status Log Deleted Fact Table

ZTZenoti Docs Team Updated April 10, 2026 3 min readGuide

Archive table for deleted membership status log records, preserving the full history of membership status changes that have been removed from the active fact table.

Columns

Column Name Data Type Nullable Description
FactMembershipStatusLogWID BIGINT IDENTITY NOT NULL Surrogate warehouse key for the deleted membership status log record.
FactMembershipStatusLogId BIGINT NULL Source system identifier for the membership status log.
MembershipStatusLogPK BIGINT NULL Primary key of the membership status log in the source system.
UserMembershipPK BIGINT NULL Primary key of the user membership in the source system.
Status INT NULL Current membership status code.
StartDate TIMESTAMP NULL Start date/time of this status period.
ChangedTo INT NULL Status code that this record was changed to.
Comments VARCHAR(65535) NULL Free-text comments associated with the status change.
EndDate TIMESTAMP NULL End date/time of this status period.
StartedManually BOOLEAN NULL Indicates if the status was started manually by a user.
EndedManually BOOLEAN NULL Indicates if the status was ended manually by a user.
CreatedDate TIMESTAMP NULL Date/time the status log record was created in the source system.
IsCurrentRecord BOOLEAN NULL Indicates if this was the current active status record at time of deletion.
Source INT NULL Source system or channel from which the status change originated.
MembershipStartDate DATE NULL Start date of the overall membership.
MembershipEndDate DATE NULL End date of the overall membership.
CancellationDate TIMESTAMP NULL Date/time the membership was cancelled.
usermembershipwid BIGINT NULL Warehouse key referencing the user membership dimension.
CenterWId BIGINT NULL Warehouse key referencing the center dimension.
RenewedFromUMId VARCHAR(36) NULL Source system user membership ID this was renewed from.
RenewedToUMId VARCHAR(36) NULL Source system user membership ID this was renewed to.
CancellationReasonFK BIGINT NULL Foreign key to the cancellation reason lookup.
UserWId BIGINT NULL Warehouse key referencing the user dimension.
membershipversionwid BIGINT NULL Warehouse key referencing the membership version dimension.
UpgradeDate TIMESTAMP NULL Date/time the membership was upgraded.
etlCreatedBy BIGINT NULL Identifier of the ETL process or user that created this record.
void INT NULL Flag indicating whether the record is voided (soft delete).

Note: All fact tables also include standard ETL metadata columns (podname, organizationid, groupid, etlCreatedDate) which are omitted from this reference for brevity.

Primary Key

FactMembershipStatusLogWID

Foreign Keys

Column References
CenterWId Bi_DimCenter.centerwid
UserWId Bi_DimUser.userwid

Enumerator Values

Column Values
Status 1 = Active
2 = InActive
3 = Frozen
4 = Cancelled
5 = Expired
6 = Closed (Expired with Prepaids)
7 = Not Started
8 = Suspended
9 = Refund
10 = Deleted
12 = Failed
13 = Upgrade
14 = Downgrade
15 = Pending
16 = Transferred
ChangedTo 1 = Active
2 = InActive
3 = Frozen
4 = Cancelled
5 = Expired
6 = Closed (Expired with Prepaids)
7 = Not Started
8 = Suspended
9 = Refund
10 = Deleted
12 = Failed
13 = Upgrade
14 = Downgrade
15 = Pending
16 = Transferred
Source 0 = Store (MMS)
1 = Mobile
2 = Web
3 = Imports
4 = Offline
5 = Dunning
6 = Employee App
7 = Manager App
8 = Auto Collection
9 = Biometric App
10 = Support Login
11 = Take 5
12 = Therapist App Android
13 = Therapist App iOS
14 = Mobile POS (Point of Sale) Android
15 = Mobile POS iOS
16 = PoS
17 = Shopify
18 = ECommerce
19 = Instore App
20 = Api Direct
21 = Unknown
22 = Extension
23 = Queue
24 = Kiosk
25 = Kiosk CMA (Customer Mobile App)
26 = Kiosk Web
27 = Invoice Refund
28 = Membership Unfreeze
29 = Membership Cancellation
30 = External CMA
31 = External Webstore
32 = Client App
33 = Bot
void 0 = Active, 1 = Voided
StartedManually TRUE = Manually started; FALSE = Automatically started.
EndedManually TRUE = Manually ended; FALSE = Automatically ended.
IsCurrentRecord TRUE = Current record; FALSE = Historical record.
Was this article helpful?
Your feedback helps us improve our documentation.