# Sources ## Documentation The municipalities, provinces and water authorities the platform reads, one row per source. The key of a source is also the code of its partition: use houten@obv reads only Houten. - 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 `Sources` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `implemented` | `char` | | ☑ | Whether the platform still imports from the source. A source no longer imported still answers with the data it has. | | `is_aggregate` | `char` | | ☑ | Whether the row is a collection of all sources of one system. A collection is no partition and answers no rows in the export. | | `label` | `varchar2` | | ☑ | The name of the municipality, province or water authority. | | `organization_type` | `varchar2` | | ☑ | gemeente, provincie, waterschap, or verzameling for a collection of all sources of one system. | | `source_key` | `varchar2` | | ☑ | The key of the source, such as houten or amsterdam; case sensitive. The code of the partition. | | `source_ref` | `varchar2` | | ☐ | The reference of the source in the platform, such as ibabs:gemeente:houten. | | `supplier` | `varchar2` | | ☑ | The council information system it is read from: notubiz, ibabs, gemeenteoplossingen or parlaeus. | ## Referenced By The columns of these tables refer to a row of this table. | Table | Columns | Guarantee | |---|---|---| | [[Export-Documents\|Export.Documents]] | `source_key` | In words only: The source, which is also the partition. | | [[Export-Meetings\|Export.Meetings]] | `source_key` | In words only: The source, which is also the partition. | | [[Export-Motions\|Export.Motions]] | `source_key` | In words only: The source, which is also the partition. | | [[Export-Recordings\|Export.Recordings]] | `source_key` | In words only: The source, which is also the partition. |