ZenotiHelp

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.