Membership Dunning Fact Table
ZTZenoti Docs Team Updated April 10, 2026 2 min readGuide
Tracks membership recurring collection dunning records, including scheduled and actual collection dates, retry attempts, cycle details, amounts, and collection status for membership billing.
Columns
| Column Name | Data Type | Nullable | Description |
|---|---|---|---|
| FactMembershipDunningWId | BIGINT IDENTITY | NOT NULL | Surrogate key for the membership dunning fact record |
| FactMembershipDunningId | BIGINT | NULL | Business/natural key for the dunning record |
| UserWId | BIGINT | NULL | Foreign key to the guest/customer user dimension |
| usermembershipwid | BIGINT | NULL | Foreign key to the user-membership association |
| CenterWId | BIGINT | NULL | Foreign key to the center dimension |
| membershipversionwid | BIGINT | NULL | Foreign key to the membership version dimension |
| MembershipStartDate | TIMESTAMP | NULL | Start date of the membership |
| MembershipEndDate | TIMESTAMP | NULL | End date of the membership |
| NextCollectionDate | TIMESTAMP | NULL | Next scheduled collection date |
| ExpectedCollectionDateInFreezePeriod | TIMESTAMP | NULL | Expected collection date during a freeze period |
| LastTriedOn | TIMESTAMP | NULL | Date and time of the last collection attempt |
| NextTryAt | TIMESTAMP | NULL | Date and time of the next scheduled collection retry |
| CollectionStatus | INT | NULL | Status code of the collection attempt |
| InvoiceId | VARCHAR(36) | NULL | Unique identifier (GUID) of the invoice |
| InvoiceItemId | VARCHAR(36) | NULL | Unique identifier (GUID) of the invoice item |
| Amount | FLOAT | NULL | Base collection amount |
| FinalSalePrice | FLOAT | NULL | Final sale price after discounts |
| Discount | FLOAT | NULL | Discount amount applied |
| Tax | FLOAT | NULL | Tax amount applied |
| CollectedDate | TIMESTAMP | NULL | Date and time when the amount was collected |
| CycleNumber | INT | NULL | Billing cycle number |
| Duration | INT | NULL | Duration of the membership period |
| DurationType | INT | NULL | Type of duration unit (e.g., days, months) |
| RecurringCollectionPK | BIGINT | NULL | Source system primary key for the recurring collection |
| void | INT | NULL | Indicates whether the record has been voided |
| podid | INT | NULL | Identifier of the source pod/database |
| factrecordtype | VARCHAR(400) | NULL | Type or category of the fact record |
| groupinvoiceid | VARCHAR(36) | NULL | GUID of the group invoice |
| invoiceno | VARCHAR(160) | NULL | Human-readable invoice number |
| collectioninitiateddate | TIMESTAMP | Yes | Date when collection was initiated |
| nooftries | INT | Yes | Number of collection attempts |
| collectionmode | VARCHAR(400) | Yes | Mode of collection (auto, manual, etc.) |
Note: All fact tables also include standard ETL metadata columns (
podname,organizationid,groupid,etlCreatedDate) which are omitted from this reference for brevity.
Primary Key
FactMembershipDunningWId
Foreign Keys
| Column | References |
|---|---|
| UserWId | Bi_DimUser.userwid |
| CenterWId | Bi_DimCenter.centerwid |
Enumerator Values
| Column | Values |
|---|---|
| CollectionStatus | 1 = Collected 2 = Suspended 3 = Frozen 4 = Waived 5 = Error |
| DurationType | 1 = Days 2 = Weeks 3 = Months |
| void | 0 = active, non-zero = voided |
| factrecordtype | Membership Recurring Freeze Cancel Setup |
Was this article helpful?
Your feedback helps us improve our documentation.