ZenotiHelp

Scheduled Collections Fact Table

ZTZenoti Docs Team Updated April 10, 2026 2 min readGuide

Records scheduled payment collection events, including expected and actual collection amounts, dates, payment types, collection status, and source information.

Columns

Column Name Data Type Nullable Description
scheduledcollectionwid BIGINT IDENTITY NOT NULL Surrogate key for the scheduled collection fact record.
factsegmentid BIGINT NULL Business/natural key for the fact segment.
scheduledcollectionpk BIGINT NULL Source system primary key for the scheduled collection.
centerwid BIGINT NULL Foreign key to the center dimension.
userwid BIGINT NULL Foreign key to the guest/customer user dimension.
scheduledpaymenttype VARCHAR(200) NULL Type of scheduled payment.
paymentoptiontype VARCHAR(200) NULL Payment option type used.
collectionamount DOUBLE PRECISION NULL Expected collection amount.
collectiondateincenter DATE NULL Scheduled collection date in center timezone.
collectedamount DOUBLE PRECISION NULL Actual collected amount.
collecteddatetimeincenter TIMESTAMP NULL Actual collection date and time in center timezone.
collecteddateincenter DATE NULL Actual collection date in center timezone.
invoiceid VARCHAR(36) NULL Unique identifier (GUID) of the invoice.
lasttriedon DATE NULL Date of the last collection attempt.
nexttryat DATE NULL Date of the next scheduled collection retry.
createddatetimeincenter TIMESTAMP NULL Record creation date and time in center timezone.
createddateincenter DATE NULL Record creation date in center timezone.
collectionstatus VARCHAR(200) NULL Status of the collection (e.g., pending, collected, failed).
collectionsource VARCHAR(200) NULL Source of the collection (e.g., auto-debit, manual).
void BOOLEAN NULL Indicates whether the record has been voided.
podid BIGINT NULL Identifier of the source pod/database.
custompaymentname VARCHAR(800) NULL Name of the custom payment method, if applicable.
considerinfinancials BOOLEAN NULL Flag indicating if the collection should be included in financials.

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

Primary Key

scheduledcollectionwid

Foreign Keys

Column References
centerwid Bi_DimCenter.centerwid
userwid Bi_DimUser.userwid
collecteddateincenter Bi_DimDate.datewid
collectiondateincenter Bi_DimDate.datewid
createddateincenter Bi_DimDate.datewid

Enumerator Values

Column Values
collectionstatus 1 = Collected
2 = Suspended
3 = Frozen
4 = Waived
5 = Error
collectionsource Auto-debit
Manual
Dunning
System
scheduledpaymenttype Recurring Cycle
OneTime
Setup Fee
Freeze Fee
Annual Fee
Cancel Fee
paymentoptiontype Cash
Credit Card
Debit Card
Check
Custom
ACH (Automated Clearing House)
void FALSE = Active, TRUE = Voided
considerinfinancials TRUE if included in financial reporting, FALSE otherwise
Was this article helpful?
Your feedback helps us improve our documentation.