# MeetingAgendaItems ## Documentation The items of the agendas of the meetings, sub-items included. Read from the export of the platform, 1 000 records per request, for every selected source: a full read of every source takes over 100 minutes at the rate limit of the platform, one source of 20 000 records some 20 seconds. Narrow it with use <source>@obv. - Catalog: `OpenBesluitvorming` - Schema: `Export` - Primary Keys: `meeting_entity_id, agenda_item_id` The data in this table is partitioned per value of the `` column. 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 `MeetingAgendaItems` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `agenda_item_id` | `varchar2` | | ☑ | The id of the agenda item. | | `classification` | `varchar2` | | ☐ | The kind of item, such as agenda_point. | | `depth` | `int32` | | ☑ | 0 for an item at the top. | | `description` | `varchar2` | | ☐ | The description of the item. | | `document_entity_ids` | `varchar2` | | ☐ | The documents on the item, separated by a comma. | | `is_heading` | `char` | | ☐ | Whether the item is only a heading. | | `item_number` | `varchar2` | | ☐ | The number on the agenda as printed, such as 4a; only some systems have it. | | `meeting_entity_id` | `varchar2` | | ☑ | The meeting. | | `parent_agenda_item_id` | `varchar2` | | ☐ | The item this one is a sub-item of; empty at the top. | | `sort_order` | `int32` | | ☐ | The position on the agenda. | | `source_key` | `varchar2` | | ☑ | The source. | | `title` | `varchar2` | | ☐ | The title of the item. | ## Foreign Keys The values of these columns refer to a row of another table. | Columns | Referenced Table | Referenced Columns | Guarantee | |---|---|---|---| | `meeting_entity_id` | [[Export-Meetings\|Export.Meetings]] | `entity_id` | Declared by the connector, not enforced by the platform | ## Referenced By The columns of these tables refer to a row of this table. | Table | Columns | Guarantee | |---|---|---| | [[Export-Motions\|Export.Motions]] | `agenda_item_id` | In words only: The agenda item under which the motion was decided; the key of an agenda item includes its meeting, which may differ from the meeting of the motion. | | [[Export-RecordingChapters\|Export.RecordingChapters]] | `agenda_item_id` | In words only: The agenda item a chapter of the registration discusses. |