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.