# SourceStatuses ## Documentation How current the data of every source is: when the import last succeeded, whether it is failing, and how complete it is against the source system. The platform refreshes the answer every 10 minutes. - Catalog: `OpenBesluitvorming` - Schema: `Catalog` - Primary Keys: `source_key` This is a read-only table. The Open Besluitvorming API may not support changing the data or the Invantive UniversalSQL driver for Open Besluitvorming does not cover it. In the latter case, please use the table NativePlatformScalarRequests to upload data to the Open Besluitvorming API. ## Table Columns The columns of the table `SourceStatuses` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `cbs_id` | `varchar2` | | ☐ | The code of the organisation at Statistics Netherlands, such as GM0321. | | `coverage_checked_at` | `datetime` | | ☐ | When the weekly comparison with the source system ran, UTC. | | `coverage_error` | `varchar2` | | ☐ | Why the comparison itself failed; the four numbers are then empty, which is not the same as zero. | | `coverage_held_documents` | `int64` | | ☐ | How many of those the platform holds. | | `coverage_lower_bound` | `char` | | ☐ | Whether part of the comparison failed, so that the gap may be larger. | | `coverage_missing_documents` | `int64` | | ☐ | How many of those the platform lacks. | | `coverage_ratio` | `decimal` | | ☐ | The share held, 1 for complete; empty when the source system listed nothing. | | `coverage_supplier_documents` | `int64` | | ☐ | The documents the source system listed for the period. | | `coverage_window_from` | `datetime` | | ☐ | The first day of the period compared. | | `coverage_window_to` | `datetime` | | ☐ | The last day of the period compared, inclusive. | | `discontinued_at` | `datetime` | | ☐ | The day the organisation ceased to exist by a merger; only on discontinued. | | `generated_at` | `datetime` | | ☐ | When the platform assembled the answer, UTC. | | `indexed_documents` | `int64` | | ☐ | The number of entries of the search index for the source. Not the number of documents of the export: measured on 2026-11-06 it was 16 to 186 percent higher. | | `label` | `varchar2` | | ☑ | The name of the organisation. | | `last_error_message` | `varchar2` | | ☐ | Why the last attempt failed; empty when it did not. | | `last_indexed_at` | `datetime` | | ☐ | When anything was last added to the search index for the source, UTC. | | `last_run_at` | `datetime` | | ☐ | When the last import was attempted, UTC. | | `last_run_status` | `varchar2` | | ☐ | The outcome of the last attempt, such as succeeded, partial or failed. | | `last_success_at` | `datetime` | | ☐ | When a full import last succeeded, UTC. | | `latest_content_date` | `datetime` | | ☐ | The date of the newest meeting held, UTC. Often in the future: an agenda is published before the meeting. | | `organization_type` | `varchar2` | | ☑ | gemeente, provincie or waterschap. | | `source_key` | `varchar2` | | ☑ | The key of the source. | | `source_ref` | `varchar2` | | ☐ | The reference of the source in the platform. | | `state` | `varchar2` | | ☑ | ok, stale, failing, never_imported, not_implemented or discontinued. failing does not fix itself; one failed night is still ok. | | `succeeded_by_cbs_id` | `varchar2` | | ☐ | The code at Statistics Netherlands of the organisation that took over. | | `succeeded_by_label` | `varchar2` | | ☐ | The name of the organisation that took over. | | `succeeded_by_source_key` | `varchar2` | | ☐ | The source of the organisation that took over; empty when it is not read. | | `supplier` | `varchar2` | | ☑ | The council information system. | | `window_hours` | `int32` | | ☐ | The number of hours within which an import must have succeeded to count as ok. |