ZenotiHelp

Recurring Status Log Fact Table

ZTZenoti Docs Team Updated April 10, 2026 3 min readGuide

Tracks the history of recurring payment status changes including start, end, cancellation, and renewal events for user memberships with recurring billing.

Columns

Column Name Data Type Nullable Description
FactRecurringStatusLogWID BIGINT IDENTITY NOT NULL Surrogate warehouse key for the recurring status log record.
FactRecurringStatusLogId BIGINT NULL Source system identifier for the recurring status log.
RecurringStatusLogPK BIGINT NULL Primary key of the recurring status log in the source system.
UserMembershipPK BIGINT NULL Primary key of the user membership in the source system.
Status INT NULL Current recurring payment 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 is the current active status record.
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 recurring 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 recurring 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

FactRecurringStatusLogWID

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
11 = Suspended (Pending tries)
12 = Failed
13 = Upgrade
14 = Downgrade
15 = Pending (Direct Debit)
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
11 = Suspended (Pending tries)
12 = Failed
13 = Upgrade
14 = Downgrade
15 = Pending (Direct Debit)
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
Was this article helpful?
Your feedback helps us improve our documentation.