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.