# SupplierStatuses ## Documentation How the imports from every council information system went over the last hours. - Catalog: `OpenBesluitvorming` - Schema: `Catalog` - Primary Keys: `supplier` 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 `SupplierStatuses` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `failed_count` | `int32` | | ☐ | How many failed. | | `label` | `varchar2` | | ☑ | Its name. | | `last_error_message` | `varchar2` | | ☐ | The last error. | | `last_success_at` | `datetime` | | ☐ | When the system last delivered anything, UTC; for a system that is down, how long the outage has lasted. | | `ok_source_count` | `int32` | | ☐ | How many of them are ok. | | `run_count` | `int32` | | ☐ | The number of imports attempted in the window. | | `source_count` | `int32` | | ☐ | The number of sources read from the system. | | `state` | `varchar2` | | ☑ | ok, degraded, down or idle. down: at least five attempts and none succeeded. | | `succeeded_count` | `int32` | | ☐ | How many succeeded. | | `supplier` | `varchar2` | | ☑ | The council information system. |