Data export and switching
Last updated: 7 October 2026
Your data belongs to you
Head offices and franchise partners can export all data they are allowed to see in Symiko at any time – also during the contract and free of charge. The export is in the application under Export data (head office: settings, partners: profile). It is built in the background; when it is ready you receive an email and can download it for seven days with your second factor. It contains structured files (JSON and CSV) and the stored original files.
Everyone can also download their own data under “My data”, optionally with their documents.
Switching provider
- You can request a switch to another provider or to your own infrastructure with a notice period of at most two months.
- A transition period of 30 days follows. During it we keep operating Symiko unchanged, support the export, inform you about known risks to business continuity and maintain the level of security.
- If 30 days are technically not feasible, we tell you within 14 working days, with reasons; the period is then at most seven months.
- After the switch or the end of the contract you can keep exporting for at least 30 days. We then delete all data of your system completely and confirm the deletion.
- We charge no fees for export and switching.
- For questions about switching and your exit planning contact hello@symiko.de.
Known limitations
- Everyone exports what they are allowed to see: head office does not receive the personnel files of its partners’ employees – each partner exports these itself as employer. Whistleblowing reports are only available to the handlers of the reporting channel.
- Passwords, sessions, second factors: Credentials are not portable and would endanger access.
- Invitation, unsubscribe, confirmation and device codes, API keys and webhook secrets: Secrets that grant actions (e.g. accept an invitation, pair a device, fetch data).
- Push subscriptions and app device tokens: Technical delivery identifiers without use outside Symiko.
- Time clock pairings, PIN hashes, device receipts: Device security data; the recorded times themselves are included.
- Mail queues (including webhook deliveries), rate counters, idempotency receipts: Internal operating state without business content.
- Search indexes and text extracted from PDFs: Derived; the originals (chapter text, PDF) are included.
- Content of generated hygiene reports: Derived from the included raw data; period and checksum are included.
- Data outside one's own permissions: The scope follows the database access rules: partners see their locations, head office its system but no other employers' personnel files; anonymous answers stay anonymous; whistleblowing cases only for designated handlers.
- Data of other franchise systems and operator data: Tenant separation.
Formats
- JSON: UTF-8, one JSON array of objects per file; keys = field names below; missing values as null.
- CSV: UTF-8 with BOM, semicolon separated, header row with field names, CRLF line endings. Text quoted (inner quotes doubled); text starting with =, +, -, @, tab or carriage return gets a leading apostrophe (protection against spreadsheet formulas). Numbers and true/false unquoted, empty values empty, lists and JSON as JSON text. The JSON file is authoritative.
- Files: dateien/<storage area>/<path> – original files (documents, images, videos, photos) as far as the exporting person may open them; paths match the fields in the data.
- Overview: manifest.json – time, system, role, list of all files with row count, fields and description; LIESMICH.txt/README.txt explain the structure.
Register of data structures
All export files with fields and formats (Art. 26(b) Data Act). Machine-readable as register.json.
Format version 1
Organisation, locations and people · 30 Files
Franchise system
System master data: name, colours, logo, legal links, settings.
JSON: daten/organisation/system.json · CSV: daten/organisation/system.csv
| Field | Format | Values |
|---|---|---|
| id | Identifier (UUID, text) | |
| name | Text (UTF-8) | |
| slug | Text (UTF-8) | |
| primary_color | Text (UTF-8) | |
| accent_color | Text (UTF-8) | |
| logo_url | Text (UTF-8) | |
| created_at | Timestamp (ISO 8601 with UTC offset) | |
| secondary_color | Text (UTF-8) | |
| aktiv | Boolean (true/false) | |
| haccp_abschluss_schichtleitung | Boolean (true/false) | |
| datenschutz_url | Text (UTF-8) | |
| impressum_url | Text (UTF-8) | |
| stempel_regel | Text (UTF-8) | |
| loeschung_vorgemerkt_am | Timestamp (ISO 8601 with UTC offset) | |
| loeschung_vorgemerkt_von | Identifier (UUID, text) | |
| mfa_pflicht | Boolean (true/false) | |
| logo_dunkel_url | Text (UTF-8) | |
| antwort_email | Text (UTF-8) | |
| willkommen_text | Text (UTF-8) | |
| willkommen_video_url | Text (UTF-8) | |
| einladung_texte | JSON (object or list; JSON text in CSV) | |
| zertifikat_praefix | Text (UTF-8) | |
| unterschrift_name | Text (UTF-8) | |
| unterschrift_funktion | Text (UTF-8) | |
| unterschrift_bild_url | Text (UTF-8) | |
| begriffe | JSON (object or list; JSON text in CSV) | |
| standard_sprache | Text (UTF-8) | |
| feier_geburtstage | Boolean (true/false) | |
| feier_jubilaeen | Boolean (true/false) | |
| feed_posten | Text (UTF-8) | |
| feed_reaktionen | List (JSON array) of: Text (UTF-8) | |
| feed_kommentare_standard | Boolean (true/false) | |
| haccp_eskalation_stunden | Integer | |
| haccp_partner_anpassen | Boolean (true/false) |
Booked modules
Modules booked for the system.
JSON: daten/organisation/module.json · CSV: daten/organisation/module.csv
| Field | Format | Values |
|---|---|---|
| system_id | Identifier (UUID, text) | |
| modul | Enumerated value (text, see values) | feed, handbuch, academy, chat, dienstplan, bwa, partnerakte, cockpit, redaktion, onboarding, vorhaben, bestellen, audits, fruehwarnung, newsletter, screens, formulare, haccp, compliance, inventur |
| created_at | Timestamp (ISO 8601 with UTC offset) |
Locations
Locations with address, time zone, opening days and rules.
JSON: daten/organisation/standorte.json · CSV: daten/organisation/standorte.csv
| Field | Format | Values |
|---|---|---|
| id | Identifier (UUID, text) | |
| system_id | Identifier (UUID, text) | |
| owner_id | Identifier (UUID, text) | |
| code | Text (UTF-8) | |
| name | Text (UTF-8) | |
| street | Text (UTF-8) | |
| zip | Text (UTF-8) | |
| city | Text (UTF-8) | |
| status | Text (UTF-8) | |
| created_at | Timestamp (ISO 8601 with UTC offset) | |
| bwa_due_day | Integer | |
| bwa_due_since | Date (ISO 8601, YYYY-MM-DD) | |
| zeitzone | Text (UTF-8) | |
| bundesland | Text (UTF-8) | |
| kostenstelle | Text (UTF-8) | |
| oeffnungstage | List (JSON array) of: Integer | |
| stempel_regel | Text (UTF-8) | |
| stempel_regel_zentrale | Boolean (true/false) | |
| haccp_ab | Date (ISO 8601, YYYY-MM-DD) | |
| sprache | Text (UTF-8) | |
| land | Text (UTF-8) | |
| regionen | List (JSON array) of: Text (UTF-8) | |
| bild_url | Text (UTF-8) | |
| standort_typ | Text (UTF-8) |
Closures
Planned closures per location.
JSON: daten/organisation/standort_schliessungen.json · CSV: daten/organisation/standort_schliessungen.csv
| Field | Format | Values |
|---|---|---|
| id | Identifier (UUID, text) | |
| system_id | Identifier (UUID, text) | |
| location_id | Identifier (UUID, text) | |
| von | Date (ISO 8601, YYYY-MM-DD) | |
| bis | Date (ISO 8601, YYYY-MM-DD) | |
| grund | Text (UTF-8) | |
| erstellt_von | Identifier (UUID, text) | |
| erstellt_am | Timestamp (ISO 8601 with UTC offset) |
Location labels
Labels assigned to locations.
JSON: daten/organisation/standort_label.json · CSV: daten/organisation/standort_label.csv
| Field | Format | Values |
|---|---|---|
| location_id | Identifier (UUID, text) | |
| label_id | Identifier (UUID, text) | |
| system_id | Identifier (UUID, text) | |
| created_at | Timestamp (ISO 8601 with UTC offset) |
Location awards
Awards per location and period.
JSON: daten/organisation/standort_auszeichnungen.json · CSV: daten/organisation/standort_auszeichnungen.csv
| Field | Format | Values |
|---|---|---|
| id | Identifier (UUID, text) | |
| system_id | Identifier (UUID, text) | |
| location_id | Identifier (UUID, text) | |
| period | Text (UTF-8) | |
| title | Text (UTF-8) | |
| granted_at | Timestamp (ISO 8601 with UTC offset) | |
| standort_name | Text (UTF-8) |
Departments
Areas such as kitchen or service.
JSON: daten/organisation/abteilungen.json · CSV: daten/organisation/abteilungen.csv
| Field | Format | Values |
|---|---|---|
| id | Identifier (UUID, text) | |
| system_id | Identifier (UUID, text) | |
| name | Text (UTF-8) | |
| sort_order | Integer | |
| created_at | Timestamp (ISO 8601 with UTC offset) | |
| location_id | Identifier (UUID, text) |
Public holidays
Holiday calendar of the system.
JSON: daten/organisation/feiertage.json · CSV: daten/organisation/feiertage.csv
| Field | Format | Values |
|---|---|---|
| id | Identifier (UUID, text) | |
| system_id | Identifier (UUID, text) | |
| bundesland | Text (UTF-8) | |
| datum | Date (ISO 8601, YYYY-MM-DD) | |
| name | Text (UTF-8) | |
| klasse | Text (UTF-8) | |
| created_by | Identifier (UUID, text) | |
| created_at | Timestamp (ISO 8601 with UTC offset) |
People
Accounts with name, role, language and status (no credentials).
JSON: daten/organisation/personen.json · CSV: daten/organisation/personen.csv
| Field | Format | Values |
|---|---|---|
| id | Identifier (UUID, text) | |
| system_id | Identifier (UUID, text) | |
| full_name | Text (UTF-8) | |
| role | Enumerated value (text, see values) | zentrale, multi_unit_partner, partner, schichtleitung, mitarbeiter |
| locale | Text (UTF-8) | |
| avatar_url | Text (UTF-8) | |
| created_at | Timestamp (ISO 8601 with UTC offset) | |
| stempelt | Boolean (true/false) | |
| gesperrt | Boolean (true/false) | |
| darf_erfassungspflicht | Boolean (true/false) | |
| farbschema | Text (UTF-8) |
Phone numbers
Stored phone numbers of the visible people.
JSON: daten/organisation/personen_telefon.json · CSV: daten/organisation/personen_telefon.csv
| Field | Format | Values |
|---|---|---|
| id | Identifier (UUID, text) | |
| phone | Text (UTF-8) |
Location membership
Which person belongs to which location.
JSON: daten/organisation/standort_zugehoerigkeit.json · CSV: daten/organisation/standort_zugehoerigkeit.csv
| Field | Format | Values |
|---|---|---|
| location_id | Identifier (UUID, text) | |
| user_id | Identifier (UUID, text) |
Personal permissions
Module permission overrides per person, also time-limited (valid until), read only (stufe) and with origin from a custom role (vorlage_id).
JSON: daten/organisation/rechte.json · CSV: daten/organisation/rechte.csv
| Field | Format | Values |
|---|---|---|
| user_id | Identifier (UUID, text) | |
| module | Enumerated value (text, see values) | feed, handbuch, academy, chat, dienstplan, bwa, partnerakte, cockpit, redaktion, onboarding, vorhaben, bestellen, audits, fruehwarnung, newsletter, screens, formulare, haccp, compliance, inventur |
| granted | Boolean (true/false) | |
| set_by | Identifier (UUID, text) | |
| set_at | Timestamp (ISO 8601 with UTC offset) | |
| gilt_bis | Date (ISO 8601, YYYY-MM-DD) | |
| stufe | Text (UTF-8) | |
| vorlage_id | Identifier (UUID, text) |
Custom roles
Role templates with base role, version and status (on/off).
JSON: daten/organisation/rollen.json · CSV: daten/organisation/rollen.csv
| Field | Format | Values |
|---|---|---|
| id | Identifier (UUID, text) | |
| system_id | Identifier (UUID, text) | |
| bereich | Text (UTF-8) | |
| besitzer_id | Identifier (UUID, text) | |
| name | Text (UTF-8) | |
| beschreibung | Text (UTF-8) | |
| grundrolle | Enumerated value (text, see values) | zentrale, multi_unit_partner, partner, schichtleitung, mitarbeiter |
| aktiv | Boolean (true/false) | |
| fassung | Integer | |
| erstellt_von | Identifier (UUID, text) | |
| erstellt_am | Timestamp (ISO 8601 with UTC offset) | |
| geaendert_von | Identifier (UUID, text) | |
| geaendert_am | Timestamp (ISO 8601 with UTC offset) |
Custom role modules
Per custom role the areas on, off or read only.
JSON: daten/organisation/rollen_module.json · CSV: daten/organisation/rollen_module.csv
| Field | Format | Values |
|---|---|---|
| id | Identifier (UUID, text) | |
| vorlage_id | Identifier (UUID, text) | |
| system_id | Identifier (UUID, text) | |
| modul | Enumerated value (text, see values) | feed, handbuch, academy, chat, dienstplan, bwa, partnerakte, cockpit, redaktion, onboarding, vorhaben, bestellen, audits, fruehwarnung, newsletter, screens, formulare, haccp, compliance, inventur |
| stufe | Text (UTF-8) |
Role assignments
Which person has which custom role – by hand or by rule, with the applied version.
JSON: daten/organisation/rollen_zuweisungen.json · CSV: daten/organisation/rollen_zuweisungen.csv
| Field | Format | Values |
|---|---|---|
| id | Identifier (UUID, text) | |
| system_id | Identifier (UUID, text) | |
| user_id | Identifier (UUID, text) | |
| vorlage_id | Identifier (UUID, text) | |
| quelle | Text (UTF-8) | |
| regel_id | Identifier (UUID, text) | |
| fassung | Integer | |
| zugewiesen_von | Identifier (UUID, text) | |
| zugewiesen_am | Timestamp (ISO 8601 with UTC offset) |
Role rules
Automatic assignment by job, location or department.
JSON: daten/organisation/rollen_regeln.json · CSV: daten/organisation/rollen_regeln.csv
| Field | Format | Values |
|---|---|---|
| id | Identifier (UUID, text) | |
| system_id | Identifier (UUID, text) | |
| vorlage_id | Identifier (UUID, text) | |
| taetigkeit | Text (UTF-8) | |
| location_id | Identifier (UUID, text) | |
| abteilung_id | Identifier (UUID, text) | |
| aktiv | Boolean (true/false) | |
| reihenfolge | Integer | |
| erstellt_von | Identifier (UUID, text) | |
| erstellt_am | Timestamp (ISO 8601 with UTC offset) |
Permission options
Permission settings, e.g. access via reporting line.
JSON: daten/organisation/rechte_einstellungen.json · CSV: daten/organisation/rechte_einstellungen.csv
| Field | Format | Values |
|---|---|---|
| system_id | Identifier (UUID, text) | |
| berichtslinie_zugriff | Boolean (true/false) | |
| geaendert_von | Identifier (UUID, text) | |
| geaendert_am | Timestamp (ISO 8601 with UTC offset) |
Field support
Responsible field managers per location.
JSON: daten/organisation/betreuung.json · CSV: daten/organisation/betreuung.csv
| Field | Format | Values |
|---|---|---|
| location_id | Identifier (UUID, text) | |
| system_id | Identifier (UUID, text) | |
| user_id | Identifier (UUID, text) | |
| set_at | Timestamp (ISO 8601 with UTC offset) |
Reporting lines
Org chart: who reports to whom.
JSON: daten/organisation/berichtslinien.json · CSV: daten/organisation/berichtslinien.csv
| Field | Format | Values |
|---|---|---|
| id | Identifier (UUID, text) | |
| system_id | Identifier (UUID, text) | |
| location_id | Identifier (UUID, text) | |
| user_id | Identifier (UUID, text) | |
| fuehrung_id | Identifier (UUID, text) | |
| art | Text (UTF-8) | |
| erstellt_von | Identifier (UUID, text) | |
| erstellt_am | Timestamp (ISO 8601 with UTC offset) |
Invitations
Sent invitations (without invitation code).
JSON: daten/organisation/einladungen.json · CSV: daten/organisation/einladungen.csv
| Field | Format | Values |
|---|---|---|
| id | Identifier (UUID, text) | |
| system_id | Identifier (UUID, text) | |
| Text (UTF-8) | ||
| full_name | Text (UTF-8) | |
| role | Enumerated value (text, see values) | zentrale, multi_unit_partner, partner, schichtleitung, mitarbeiter |
| location_id | Identifier (UUID, text) | |
| created_by | Identifier (UUID, text) | |
| accepted_at | Timestamp (ISO 8601 with UTC offset) | |
| expires_at | Timestamp (ISO 8601 with UTC offset) | |
| created_at | Timestamp (ISO 8601 with UTC offset) | |
| akte | JSON (object or list; JSON text in CSV) | |
| verguetung | JSON (object or list; JSON text in CSV) | |
| personalfragebogen | Boolean (true/false) | |
| arbeitgeber_einladung | Boolean (true/false) | |
| sprache | Text (UTF-8) | |
| weitere_standorte | List (JSON array) of: Identifier (UUID, text) | |
| zuletzt_gesendet | Timestamp (ISO 8601 with UTC offset) | |
| erinnerungen | Integer | |
| erinnert_am | Timestamp (ISO 8601 with UTC offset) |
Working time rules
Break, rest and maximum working time rules, self-entry and how far back, leave rules (rounding, monthly accrual).
JSON: daten/organisation/arbeitszeitregeln.json · CSV: daten/organisation/arbeitszeitregeln.csv
| Field | Format | Values |
|---|---|---|
| system_id | Identifier (UUID, text) | |
| land | Text (UTF-8) | |
| pause_schwelle_1 | Integer | |
| pause_dauer_1 | Integer | |
| pause_schwelle_2 | Integer | |
| pause_dauer_2 | Integer | |
| max_arbeitszeit | Integer | |
| min_ruhezeit | Integer | |
| pause_automatisch | Boolean (true/false) | |
| aktualisiert_am | Timestamp (ISO 8601 with UTC offset) | |
| max_wochenarbeitszeit | Integer | |
| ausgleich_wochen | Integer | |
| min_freie_sonntage_jahr | Integer | |
| ruhezeit_gastro_verkuerzt | Boolean (true/false) | |
| nachtarbeit_von | Time of day (HH:MM:SS, local time of the location) | |
| nachtarbeit_bis | Time of day (HH:MM:SS, local time of the location) | |
| warnstufe | Text (UTF-8) | |
| personalquote_gelb | Decimal number (dot as decimal separator) | |
| personalquote_rot | Decimal number (dot as decimal separator) | |
| urlaub_uebertrag_automatisch | Boolean (true/false) | |
| urlaub_uebertrag_max | Decimal number (dot as decimal separator) | |
| ueberstunden_grenze | Decimal number (dot as decimal separator) | |
| urlaub_kuerzung_elternzeit | Boolean (true/false) | |
| urlaub_bonus_stufen | JSON (object or list; JSON text in CSV) | |
| urlaub_probezeit_max | Decimal number (dot as decimal separator) | |
| pause_mindestblock | Integer | |
| verstoesse_bestaetigen | Boolean (true/false) | |
| zeiten_selbst_nachtragen | Boolean (true/false) | |
| nachtragen_max_tage | Integer | |
| urlaub_rundung | Text (UTF-8) | |
| urlaub_ansammlung | Boolean (true/false) | |
| urlaub_ansammlung_grenze | Text (UTF-8) | |
| urlaub_mehrurlaub_verfall | Boolean (true/false) | |
| projektzeiten | Boolean (true/false) |
Surcharge rules
Surcharges for Sundays, holidays and nights.
JSON: daten/organisation/zuschlagsregeln.json · CSV: daten/organisation/zuschlagsregeln.csv
| Field | Format | Values |
|---|---|---|
| id | Identifier (UUID, text) | |
| system_id | Identifier (UUID, text) | |
| art | Text (UTF-8) | |
| prozent | Decimal number (dot as decimal separator) | |
| steuerfrei | Boolean (true/false) | |
| gilt_ab | Date (ISO 8601, YYYY-MM-DD) | |
| aktiv | Boolean (true/false) |
Notifications
Stored updates on own requests and reminders.
JSON: daten/organisation/benachrichtigungen.json · CSV: daten/organisation/benachrichtigungen.csv
| Field | Format | Values |
|---|---|---|
| id | Identifier (UUID, text) | |
| system_id | Identifier (UUID, text) | |
| user_id | Identifier (UUID, text) | |
| art | Text (UTF-8) | |
| bezug_id | Identifier (UUID, text) | |
| daten | JSON (object or list; JSON text in CSV) | |
| erstellt_am | Timestamp (ISO 8601 with UTC offset) | |
| gelesen_am | Timestamp (ISO 8601 with UTC offset) | |
| verworfen_am | Timestamp (ISO 8601 with UTC offset) |
Notification settings
Notification types switched off.
JSON: daten/organisation/benachrichtigung_einstellungen.json · CSV: daten/organisation/benachrichtigung_einstellungen.csv
| Field | Format | Values |
|---|---|---|
| user_id | Identifier (UUID, text) | |
| kategorie | Text (UTF-8) | |
| seit | Timestamp (ISO 8601 with UTC offset) |
Notifications switched on
Notification types a person switched on although they are off by default for their role.
JSON: daten/organisation/benachrichtigung_eingeschaltet.json · CSV: daten/organisation/benachrichtigung_eingeschaltet.csv
| Field | Format | Values |
|---|---|---|
| user_id | Identifier (UUID, text) | |
| kategorie | Text (UTF-8) | |
| seit | Timestamp (ISO 8601 with UTC offset) |
Notification rules
Quiet hours of the system and which notification types are off by default per role.
JSON: daten/organisation/mitteilungsregeln.json · CSV: daten/organisation/mitteilungsregeln.csv
| Field | Format | Values |
|---|---|---|
| system_id | Identifier (UUID, text) | |
| ruhe_an | Boolean (true/false) | |
| ruhe_von | Integer | |
| ruhe_bis | Integer | |
| rollen_aus | JSON (object or list; JSON text in CSV) | |
| geaendert_von | Identifier (UUID, text) | |
| geaendert_am | Timestamp (ISO 8601 with UTC offset) |
Early warning settings
Per warning type: on or off, deadline, urgency and who sees it.
JSON: daten/organisation/fruehwarnung_einstellungen.json · CSV: daten/organisation/fruehwarnung_einstellungen.csv
| Field | Format | Values |
|---|---|---|
| system_id | Identifier (UUID, text) | |
| art | Text (UTF-8) | |
| an | Boolean (true/false) | |
| frist | Integer | |
| schwere | Integer | |
| rollen | List (JSON array) of: Text (UTF-8) | |
| geaendert_von | Identifier (UUID, text) | |
| geaendert_am | Timestamp (ISO 8601 with UTC offset) |
API keys
Own keys (for head office all in the system) with scopes, expiry, revocation and last use – without the key itself.
JSON: daten/organisation/api_schluessel.json · CSV: daten/organisation/api_schluessel.csv
| Field | Format | Values |
|---|---|---|
| id | Identifier (UUID, text) | |
| system_id | Identifier (UUID, text) | |
| user_id | Identifier (UUID, text) | |
| name | Text (UTF-8) | |
| praefix | Text (UTF-8) | |
| bereiche | List (JSON array) of: Text (UTF-8) | |
| erstellt_am | Timestamp (ISO 8601 with UTC offset) | |
| laeuft_ab_am | Timestamp (ISO 8601 with UTC offset) | |
| widerrufen_am | Timestamp (ISO 8601 with UTC offset) | |
| widerrufen_von | Identifier (UUID, text) | |
| letzte_nutzung_am | Timestamp (ISO 8601 with UTC offset) | |
| letzte_ressource | Text (UTF-8) | |
| nutzungen | Integer |
Webhooks
Own webhook subscriptions with address, events and state – without the secret.
JSON: daten/organisation/api_webhooks.json · CSV: daten/organisation/api_webhooks.csv
| Field | Format | Values |
|---|---|---|
| id | Identifier (UUID, text) | |
| system_id | Identifier (UUID, text) | |
| user_id | Identifier (UUID, text) | |
| schluessel_id | Identifier (UUID, text) | |
| name | Text (UTF-8) | |
| url | Text (UTF-8) | |
| ereignisse | List (JSON array) of: Text (UTF-8) | |
| aktiv | Boolean (true/false) | |
| erstellt_am | Timestamp (ISO 8601 with UTC offset) | |
| letzte_zustellung_am | Timestamp (ISO 8601 with UTC offset) | |
| letzter_status | Integer | |
| fehler_in_folge | Integer | |
| pausiert_am | Timestamp (ISO 8601 with UTC offset) | |
| pausiert_grund | Text (UTF-8) |
Dismissed news
Dismissed “New in Symiko” notes.
JSON: daten/organisation/neuigkeiten_gelesen.json · CSV: daten/organisation/neuigkeiten_gelesen.csv
| Field | Format | Values |
|---|---|---|
| user_id | Identifier (UUID, text) | |
| neuigkeit | Text (UTF-8) | |
| gelesen_am | Timestamp (ISO 8601 with UTC offset) |
Feed, chat, polls, newsletters and forms · 24 Files
Posts
Feed posts and mandatory notices.
JSON: daten/kommunikation/beitraege.json · CSV: daten/kommunikation/beitraege.csv
| Field | Format | Values |
|---|---|---|
| id | Identifier (UUID, text) | |
| system_id | Identifier (UUID, text) | |
| author_id | Identifier (UUID, text) | |
| kind | Enumerated value (text, see values) | beitrag, story |
| title | Text (UTF-8) | |
| body | Text (UTF-8) | |
| is_mandatory | Boolean (true/false) | |
| expires_at | Timestamp (ISO 8601 with UTC offset) | |
| published_at | Timestamp (ISO 8601 with UTC offset) | |
| created_at | Timestamp (ISO 8601 with UTC offset) | |
| media | JSON (object or list; JSON text in CSV) | |
| target_roles | List (JSON array) of: Enumerated value (text, see values) | zentrale, multi_unit_partner, partner, schichtleitung, mitarbeiter |
| comments_enabled | Boolean (true/false) | |
| version | Integer | |
| edited_at | Timestamp (ISO 8601 with UTC offset) | |
| edited_by | Identifier (UUID, text) | |
| withdrawn_at | Timestamp (ISO 8601 with UTC offset) | |
| withdrawn_by | Identifier (UUID, text) | |
| replaces_id | Identifier (UUID, text) | |
| shared_post_id | Identifier (UUID, text) | |
| location_id | Identifier (UUID, text) | |
| ack_due_at | Timestamp (ISO 8601 with UTC offset) | |
| ziel_standorte | List (JSON array) of: Identifier (UUID, text) |
Post revisions
Earlier versions of edited posts.
JSON: daten/kommunikation/beitrag_fassungen.json · CSV: daten/kommunikation/beitrag_fassungen.csv
| Field | Format | Values |
|---|---|---|
| id | Identifier (UUID, text) | |
| system_id | Identifier (UUID, text) | |
| post_id | Identifier (UUID, text) | |
| version | Integer | |
| alter_titel | Text (UTF-8) | |
| alter_text | Text (UTF-8) | |
| alte_medien | JSON (object or list; JSON text in CSV) | |
| ersetzter_beitrag | Identifier (UUID, text) | |
| bestaetigungen | Integer | |
| geaendert_von | Identifier (UUID, text) | |
| geaendert_am | Timestamp (ISO 8601 with UTC offset) |
Acknowledgements
Acknowledgements of mandatory notices.
JSON: daten/kommunikation/beitrag_bestaetigungen.json · CSV: daten/kommunikation/beitrag_bestaetigungen.csv
| Field | Format | Values |
|---|---|---|
| post_id | Identifier (UUID, text) | |
| user_id | Identifier (UUID, text) | |
| location_id | Identifier (UUID, text) | |
| acknowledged_at | Timestamp (ISO 8601 with UTC offset) | |
| standorte | List (JSON array) of: Identifier (UUID, text) | |
| fassung | Integer |
Comments
Comments on posts.
JSON: daten/kommunikation/kommentare.json · CSV: daten/kommunikation/kommentare.csv
| Field | Format | Values |
|---|---|---|
| id | Identifier (UUID, text) | |
| post_id | Identifier (UUID, text) | |
| author_id | Identifier (UUID, text) | |
| body | Text (UTF-8) | |
| hidden | Boolean (true/false) | |
| created_at | Timestamp (ISO 8601 with UTC offset) | |
| hidden_by | Identifier (UUID, text) |
Comment reviews
Review status of comments.
JSON: daten/kommunikation/kommentar_pruefungen.json · CSV: daten/kommunikation/kommentar_pruefungen.csv
| Field | Format | Values |
|---|---|---|
| comment_id | Identifier (UUID, text) | |
| system_id | Identifier (UUID, text) | |
| reviewed_by | Identifier (UUID, text) | |
| reviewed_at | Timestamp (ISO 8601 with UTC offset) |
Bookmarks
Own saved posts.
JSON: daten/kommunikation/lesezeichen.json · CSV: daten/kommunikation/lesezeichen.csv
| Field | Format | Values |
|---|---|---|
| post_id | Identifier (UUID, text) | |
| user_id | Identifier (UUID, text) | |
| created_at | Timestamp (ISO 8601 with UTC offset) |
Reactions
Own reactions to posts.
JSON: daten/kommunikation/reaktionen.json · CSV: daten/kommunikation/reaktionen.csv
| Field | Format | Values |
|---|---|---|
| id | Identifier (UUID, text) | |
| post_id | Identifier (UUID, text) | |
| user_id | Identifier (UUID, text) | |
| system_id | Identifier (UUID, text) | |
| reaktion | Text (UTF-8) | |
| erstellt_am | Timestamp (ISO 8601 with UTC offset) |
Polls
Polls in the feed.
JSON: daten/kommunikation/umfragen.json · CSV: daten/kommunikation/umfragen.csv
| Field | Format | Values |
|---|---|---|
| id | Identifier (UUID, text) | |
| system_id | Identifier (UUID, text) | |
| question | Text (UTF-8) | |
| description | Text (UTF-8) | |
| deadline | Timestamp (ISO 8601 with UTC offset) | |
| namentlich | Boolean (true/false) | |
| target_roles | List (JSON array) of: Enumerated value (text, see values) | zentrale, multi_unit_partner, partner, schichtleitung, mitarbeiter |
| created_by | Identifier (UUID, text) | |
| created_at | Timestamp (ISO 8601 with UTC offset) | |
| ergebnis_sichtbar | Boolean (true/false) |
Poll options
Options of the polls.
JSON: daten/kommunikation/umfrage_optionen.json · CSV: daten/kommunikation/umfrage_optionen.csv
| Field | Format | Values |
|---|---|---|
| id | Identifier (UUID, text) | |
| poll_id | Identifier (UUID, text) | |
| system_id | Identifier (UUID, text) | |
| label | Text (UTF-8) | |
| position | Integer |
Votes
Votes cast, as far as visible.
JSON: daten/kommunikation/umfrage_stimmen.json · CSV: daten/kommunikation/umfrage_stimmen.csv
| Field | Format | Values |
|---|---|---|
| poll_id | Identifier (UUID, text) | |
| option_id | Identifier (UUID, text) | |
| system_id | Identifier (UUID, text) | |
| user_id | Identifier (UUID, text) | |
| created_at | Timestamp (ISO 8601 with UTC offset) |
Chat channels
Groups, location channels and direct chats.
JSON: daten/kommunikation/chat_kanaele.json · CSV: daten/kommunikation/chat_kanaele.csv
| Field | Format | Values |
|---|---|---|
| id | Identifier (UUID, text) | |
| system_id | Identifier (UUID, text) | |
| kind | Enumerated value (text, see values) | direkt, gruppe, broadcast, standort, leitung |
| name | Text (UTF-8) | |
| topic | Text (UTF-8) | |
| created_by | Identifier (UUID, text) | |
| created_at | Timestamp (ISO 8601 with UTC offset) | |
| location_id | Identifier (UUID, text) | |
| automatisch | Boolean (true/false) | |
| dm_key | Text (UTF-8) |
Chat members
Who is in which channel.
JSON: daten/kommunikation/chat_mitglieder.json · CSV: daten/kommunikation/chat_mitglieder.csv
| Field | Format | Values |
|---|---|---|
| channel_id | Identifier (UUID, text) | |
| user_id | Identifier (UUID, text) | |
| last_read_at | Timestamp (ISO 8601 with UTC offset) | |
| stumm | Boolean (true/false) |
Chat messages
Messages in visible channels; attachments under dateien/chat/.
JSON: daten/kommunikation/chat_nachrichten.json · CSV: daten/kommunikation/chat_nachrichten.csv
| Field | Format | Values |
|---|---|---|
| id | Identifier (UUID, text) | |
| channel_id | Identifier (UUID, text) | |
| author_id | Identifier (UUID, text) | |
| body | Text (UTF-8) | |
| media_url | Text (UTF-8) | |
| created_at | Timestamp (ISO 8601 with UTC offset) | |
| reply_to | Identifier (UUID, text) | |
| anhang | Text (UTF-8) | |
| edited_at | Timestamp (ISO 8601 with UTC offset) | |
| deleted_at | Timestamp (ISO 8601 with UTC offset) | |
| post_id | Identifier (UUID, text) | |
| anhang_begleittext | Boolean (true/false) |
Message revisions
Earlier texts of edited messages.
JSON: daten/kommunikation/chat_nachricht_fassungen.json · CSV: daten/kommunikation/chat_nachricht_fassungen.csv
| Field | Format | Values |
|---|---|---|
| id | Identifier (UUID, text) | |
| message_id | Identifier (UUID, text) | |
| alter_text | Text (UTF-8) | |
| geaendert_von | Identifier (UUID, text) | |
| geaendert_am | Timestamp (ISO 8601 with UTC offset) |
Reactions
Reactions to messages.
JSON: daten/kommunikation/chat_reaktionen.json · CSV: daten/kommunikation/chat_reaktionen.csv
| Field | Format | Values |
|---|---|---|
| message_id | Identifier (UUID, text) | |
| user_id | Identifier (UUID, text) | |
| emoji | Text (UTF-8) | |
| created_at | Timestamp (ISO 8601 with UTC offset) |
Mentions
Mentions in messages.
JSON: daten/kommunikation/chat_erwaehnungen.json · CSV: daten/kommunikation/chat_erwaehnungen.csv
| Field | Format | Values |
|---|---|---|
| message_id | Identifier (UUID, text) | |
| user_id | Identifier (UUID, text) |
Newsletters
Sent and planned newsletters.
JSON: daten/kommunikation/newsletter.json · CSV: daten/kommunikation/newsletter.csv
| Field | Format | Values |
|---|---|---|
| id | Identifier (UUID, text) | |
| system_id | Identifier (UUID, text) | |
| titel | Text (UTF-8) | |
| inhalt | Text (UTF-8) | |
| zielgruppe | Text (UTF-8) | |
| status | Text (UTF-8) | |
| versendet_am | Timestamp (ISO 8601 with UTC offset) | |
| created_by | Identifier (UUID, text) | |
| created_at | Timestamp (ISO 8601 with UTC offset) | |
| liste_id | Identifier (UUID, text) | |
| fassung | Integer |
Newsletter recipients
Delivery per recipient.
JSON: daten/kommunikation/newsletter_empfaenger.json · CSV: daten/kommunikation/newsletter_empfaenger.csv
| Field | Format | Values |
|---|---|---|
| id | Identifier (UUID, text) | |
| rundbrief_id | Identifier (UUID, text) | |
| system_id | Identifier (UUID, text) | |
| user_id | Identifier (UUID, text) | |
| Text (UTF-8) | ||
| status | Text (UTF-8) | |
| fehler | Text (UTF-8) | |
| created_at | Timestamp (ISO 8601 with UTC offset) | |
| reserviert_am | Timestamp (ISO 8601 with UTC offset) |
Newsletter lists
External recipient lists.
JSON: daten/kommunikation/newsletter_listen.json · CSV: daten/kommunikation/newsletter_listen.csv
| Field | Format | Values |
|---|---|---|
| id | Identifier (UUID, text) | |
| system_id | Identifier (UUID, text) | |
| name | Text (UTF-8) | |
| created_at | Timestamp (ISO 8601 with UTC offset) |
Newsletter subscribers
Subscribers with consent and status (without confirmation/unsubscribe codes).
JSON: daten/kommunikation/newsletter_abonnenten.json · CSV: daten/kommunikation/newsletter_abonnenten.csv
| Field | Format | Values |
|---|---|---|
| id | Identifier (UUID, text) | |
| system_id | Identifier (UUID, text) | |
| liste_id | Identifier (UUID, text) | |
| Text (UTF-8) | ||
| name | Text (UTF-8) | |
| status | Text (UTF-8) | |
| quelle | Text (UTF-8) | |
| einwilligung | Text (UTF-8) | |
| doi_gesendet_am | Timestamp (ISO 8601 with UTC offset) | |
| bestaetigt_am | Timestamp (ISO 8601 with UTC offset) | |
| abgemeldet_am | Timestamp (ISO 8601 with UTC offset) | |
| created_at | Timestamp (ISO 8601 with UTC offset) |
Forms
Public forms with fields.
JSON: daten/kommunikation/formulare.json · CSV: daten/kommunikation/formulare.csv
| Field | Format | Values |
|---|---|---|
| id | Identifier (UUID, text) | |
| system_id | Identifier (UUID, text) | |
| code | Text (UTF-8) | |
| name | Text (UTF-8) | |
| titel | Text (UTF-8) | |
| beschreibung | Text (UTF-8) | |
| knopf | Text (UTF-8) | |
| danke | Text (UTF-8) | |
| felder | JSON (object or list; JSON text in CSV) | |
| liste_id | Identifier (UUID, text) | |
| aktiv | Boolean (true/false) | |
| created_at | Timestamp (ISO 8601 with UTC offset) |
Form entries
Submitted form data.
JSON: daten/kommunikation/formular_eintraege.json · CSV: daten/kommunikation/formular_eintraege.csv
| Field | Format | Values |
|---|---|---|
| id | Identifier (UUID, text) | |
| formular_id | Identifier (UUID, text) | |
| system_id | Identifier (UUID, text) | |
| daten | JSON (object or list; JSON text in CSV) | |
| quelle | Text (UTF-8) | |
| created_at | Timestamp (ISO 8601 with UTC offset) |
Blocked contacts
Own blocks in chat.
JSON: daten/kommunikation/chat_blockierungen.json · CSV: daten/kommunikation/chat_blockierungen.csv
| Field | Format | Values |
|---|---|---|
| user_id | Identifier (UUID, text) | |
| blockiert_id | Identifier (UUID, text) | |
| system_id | Identifier (UUID, text) | |
| created_at | Timestamp (ISO 8601 with UTC offset) |
Content reports
Reported content (DSA), as far as visible.
JSON: daten/kommunikation/inhaltsmeldungen.json · CSV: daten/kommunikation/inhaltsmeldungen.csv
| Field | Format | Values |
|---|---|---|
| id | Identifier (UUID, text) | |
| system_id | Identifier (UUID, text) | |
| melder_id | Identifier (UUID, text) | |
| nachricht_id | Identifier (UUID, text) | |
| kommentar_id | Identifier (UUID, text) | |
| grund | Text (UTF-8) | |
| hinweis | Text (UTF-8) | |
| status | Text (UTF-8) | |
| entschieden_von | Identifier (UUID, text) | |
| entschieden_am | Timestamp (ISO 8601 with UTC offset) | |
| created_at | Timestamp (ISO 8601 with UTC offset) |
Handbook · 6 Files
Chapters
Handbook chapters with text (HTML/Markdown), structure and audience; PDFs under dateien/dokumente/, embedded media under dateien/bilder/ and dateien/videos/.
JSON: daten/handbuch/kapitel.json · CSV: daten/handbuch/kapitel.csv
| Field | Format | Values |
|---|---|---|
| id | Identifier (UUID, text) | |
| system_id | Identifier (UUID, text) | |
| parent_id | Identifier (UUID, text) | |
| number | Text (UTF-8) | |
| title | Text (UTF-8) | |
| body | Text (UTF-8) | |
| version | Integer | |
| sort_order | Integer | |
| requires_ack | Boolean (true/false) | |
| published_at | Timestamp (ISO 8601 with UTC offset) | |
| updated_at | Timestamp (ISO 8601 with UTC offset) | |
| created_at | Timestamp (ISO 8601 with UTC offset) | |
| language | Text (UTF-8) | |
| translation_of | Identifier (UUID, text) | |
| body_format | Text (UTF-8) | |
| pdf_path | Text (UTF-8) | |
| updated_by | Identifier (UUID, text) | |
| source_url | Text (UTF-8) | |
| imported_at | Timestamp (ISO 8601 with UTC offset) | |
| target_roles | List (JSON array) of: Enumerated value (text, see values) | zentrale, multi_unit_partner, partner, schichtleitung, mitarbeiter |
| ack_due_at | Timestamp (ISO 8601 with UTC offset) | |
| review_due_at | Date (ISO 8601, YYYY-MM-DD) | |
| reviewed_at | Timestamp (ISO 8601 with UTC offset) | |
| is_emergency | Boolean (true/false) | |
| course_id | Identifier (UUID, text) | |
| nda_pflicht | Boolean (true/false) |
Chapter versions
Earlier versions of chapters.
JSON: daten/handbuch/kapitel_fassungen.json · CSV: daten/handbuch/kapitel_fassungen.csv
| Field | Format | Values |
|---|---|---|
| id | Identifier (UUID, text) | |
| chapter_id | Identifier (UUID, text) | |
| system_id | Identifier (UUID, text) | |
| version | Integer | |
| number | Text (UTF-8) | |
| title | Text (UTF-8) | |
| body | Text (UTF-8) | |
| body_format | Text (UTF-8) | |
| language | Text (UTF-8) | |
| pdf_path | Text (UTF-8) | |
| requires_ack | Boolean (true/false) | |
| changed_by | Identifier (UUID, text) | |
| changed_at | Timestamp (ISO 8601 with UTC offset) | |
| note | Text (UTF-8) |
Acknowledgements
Current acknowledgements per chapter and person.
JSON: daten/handbuch/kenntnisnahmen.json · CSV: daten/handbuch/kenntnisnahmen.csv
| Field | Format | Values |
|---|---|---|
| chapter_id | Identifier (UUID, text) | |
| user_id | Identifier (UUID, text) | |
| acknowledged_at | Timestamp (ISO 8601 with UTC offset) |
Acknowledgement log
All acknowledgements with version and language.
JSON: daten/handbuch/kenntnisnahme_protokoll.json · CSV: daten/handbuch/kenntnisnahme_protokoll.csv
| Field | Format | Values |
|---|---|---|
| id | Identifier (UUID, text) | |
| system_id | Identifier (UUID, text) | |
| chapter_id | Identifier (UUID, text) | |
| user_id | Identifier (UUID, text) | |
| version | Integer | |
| chapter_updated_at | Timestamp (ISO 8601 with UTC offset) | |
| language | Text (UTF-8) | |
| bestaetigt_ueber | Identifier (UUID, text) | |
| acknowledged_at | Timestamp (ISO 8601 with UTC offset) |
Handbook receipts
Receipts for the whole handbook.
JSON: daten/handbuch/quittungen.json · CSV: daten/handbuch/quittungen.csv
| Field | Format | Values |
|---|---|---|
| id | Identifier (UUID, text) | |
| system_id | Identifier (UUID, text) | |
| user_id | Identifier (UUID, text) | |
| confirmed_at | Timestamp (ISO 8601 with UTC offset) | |
| chapter_count | Integer | |
| snapshot | JSON (object or list; JSON text in CSV) | |
| note | Text (UTF-8) |
Glossary
Terms and definitions.
JSON: daten/handbuch/glossar.json · CSV: daten/handbuch/glossar.csv
| Field | Format | Values |
|---|---|---|
| id | Identifier (UUID, text) | |
| system_id | Identifier (UUID, text) | |
| term | Text (UTF-8) | |
| definition | Text (UTF-8) | |
| created_at | Timestamp (ISO 8601 with UTC offset) | |
| updated_at | Timestamp (ISO 8601 with UTC offset) |
Academy, trainings and qualifications · 16 Files
Course topics
Topics grouping the courses.
JSON: daten/academy/themen.json · CSV: daten/academy/themen.csv
| Field | Format | Values |
|---|---|---|
| id | Identifier (UUID, text) | |
| system_id | Identifier (UUID, text) | |
| title | Text (UTF-8) | |
| sort_order | Integer | |
| created_at | Timestamp (ISO 8601 with UTC offset) |
Courses
Courses with audience, pass mark and validity.
JSON: daten/academy/kurse.json · CSV: daten/academy/kurse.csv
| Field | Format | Values |
|---|---|---|
| id | Identifier (UUID, text) | |
| system_id | Identifier (UUID, text) | |
| title | Text (UTF-8) | |
| description | Text (UTF-8) | |
| video_url | Text (UTF-8) | |
| duration_seconds | Integer | |
| target_roles | List (JSON array) of: Enumerated value (text, see values) | zentrale, multi_unit_partner, partner, schichtleitung, mitarbeiter |
| sort_order | Integer | |
| published_at | Timestamp (ISO 8601 with UTC offset) | |
| created_at | Timestamp (ISO 8601 with UTC offset) | |
| topic_id | Identifier (UUID, text) | |
| valid_months | Integer | |
| is_mandatory | Boolean (true/false) | |
| pass_percent | Integer | |
| quiz_count | Integer | |
| haccp_nachweis | Text (UTF-8) | |
| frist_tage | Integer |
Course modules
Lessons of the courses (text, video, chapter link).
JSON: daten/academy/kurs_module.json · CSV: daten/academy/kurs_module.csv
| Field | Format | Values |
|---|---|---|
| id | Identifier (UUID, text) | |
| course_id | Identifier (UUID, text) | |
| title | Text (UTF-8) | |
| kind | Text (UTF-8) | |
| video_url | Text (UTF-8) | |
| body | Text (UTF-8) | |
| chapter_id | Identifier (UUID, text) | |
| duration_seconds | Integer | |
| sort_order | Integer | |
| created_at | Timestamp (ISO 8601 with UTC offset) | |
| body_format | Text (UTF-8) |
Quiz questions
Questions and answer options.
JSON: daten/academy/kurs_fragen.json · CSV: daten/academy/kurs_fragen.csv
| Field | Format | Values |
|---|---|---|
| id | Identifier (UUID, text) | |
| course_id | Identifier (UUID, text) | |
| question | Text (UTF-8) | |
| options | JSON (object or list; JSON text in CSV) | |
| sort_order | Integer | |
| points | Integer | |
| multiple | Boolean (true/false) | |
| created_at | Timestamp (ISO 8601 with UTC offset) |
Quiz answer keys
Correct answers (visible to editors only).
JSON: daten/academy/kurs_loesungen.json · CSV: daten/academy/kurs_loesungen.csv
| Field | Format | Values |
|---|---|---|
| question_id | Identifier (UUID, text) | |
| correct_indexes | List (JSON array) of: Integer |
Course completions
Results, certificates and validity.
JSON: daten/academy/kursabschluesse.json · CSV: daten/academy/kursabschluesse.csv
| Field | Format | Values |
|---|---|---|
| course_id | Identifier (UUID, text) | |
| user_id | Identifier (UUID, text) | |
| score | Integer | |
| passed | Boolean (true/false) | |
| completed_at | Timestamp (ISO 8601 with UTC offset) | |
| cert_no | Integer | |
| valid_until | Timestamp (ISO 8601 with UTC offset) | |
| cert_code | Text (UTF-8) | |
| kurs_titel | Text (UTF-8) | |
| cert_praefix | Text (UTF-8) |
Learning progress
Completed course modules.
JSON: daten/academy/lernfortschritt.json · CSV: daten/academy/lernfortschritt.csv
| Field | Format | Values |
|---|---|---|
| module_id | Identifier (UUID, text) | |
| user_id | Identifier (UUID, text) | |
| done_at | Timestamp (ISO 8601 with UTC offset) |
Learning paths
Learning paths of the system.
JSON: daten/academy/lernpfade.json · CSV: daten/academy/lernpfade.csv
| Field | Format | Values |
|---|---|---|
| id | Identifier (UUID, text) | |
| system_id | Identifier (UUID, text) | |
| title | Text (UTF-8) | |
| description | Text (UTF-8) | |
| sort_order | Integer | |
| created_at | Timestamp (ISO 8601 with UTC offset) | |
| published_at | Timestamp (ISO 8601 with UTC offset) |
Path stages
Stages of the learning paths.
JSON: daten/academy/lernpfad_stufen.json · CSV: daten/academy/lernpfad_stufen.csv
| Field | Format | Values |
|---|---|---|
| id | Identifier (UUID, text) | |
| path_id | Identifier (UUID, text) | |
| title | Text (UTF-8) | |
| sort_order | Integer | |
| created_at | Timestamp (ISO 8601 with UTC offset) |
Path stage courses
Courses per stage.
JSON: daten/academy/lernpfad_kurse.json · CSV: daten/academy/lernpfad_kurse.csv
| Field | Format | Values |
|---|---|---|
| stage_id | Identifier (UUID, text) | |
| course_id | Identifier (UUID, text) |
Points
Points ledger.
JSON: daten/academy/punkte.json · CSV: daten/academy/punkte.csv
| Field | Format | Values |
|---|---|---|
| id | Identifier (UUID, text) | |
| system_id | Identifier (UUID, text) | |
| user_id | Identifier (UUID, text) | |
| points | Integer | |
| reason | Text (UTF-8) | |
| ref_id | Identifier (UUID, text) | |
| created_at | Timestamp (ISO 8601 with UTC offset) |
Awards
Awarded medals.
JSON: daten/academy/auszeichnungen.json · CSV: daten/academy/auszeichnungen.csv
| Field | Format | Values |
|---|---|---|
| id | Identifier (UUID, text) | |
| system_id | Identifier (UUID, text) | |
| user_id | Identifier (UUID, text) | |
| kind | Text (UTF-8) | |
| key | Text (UTF-8) | |
| title | Text (UTF-8) | |
| granted_at | Timestamp (ISO 8601 with UTC offset) |
Qualification types
Types of qualifications and requirements.
JSON: daten/academy/nachweisarten.json · CSV: daten/academy/nachweisarten.csv
| Field | Format | Values |
|---|---|---|
| id | Identifier (UUID, text) | |
| system_id | Identifier (UUID, text) | |
| name | Text (UTF-8) | |
| beschreibung | Text (UTF-8) | |
| gueltig_monate | Integer | |
| quelle | Text (UTF-8) | |
| course_id | Identifier (UUID, text) | |
| pflicht_rollen | List (JSON array) of: Enumerated value (text, see values) | zentrale, multi_unit_partner, partner, schichtleitung, mitarbeiter |
| mindestens_je_standort | Integer | |
| je_schicht | Boolean (true/false) | |
| standard_key | Text (UTF-8) | |
| aktiv | Boolean (true/false) | |
| reihenfolge | Integer | |
| created_at | Timestamp (ISO 8601 with UTC offset) | |
| updated_at | Timestamp (ISO 8601 with UTC offset) | |
| vorlage_schluessel | Text (UTF-8) | |
| punkt_schluessel | Text (UTF-8) | |
| vorlage_version | Text (UTF-8) | |
| vorlauf_tage | Integer |
Qualifications
Qualification records of people (without costs).
JSON: daten/academy/nachweise.json · CSV: daten/academy/nachweise.csv
| Field | Format | Values |
|---|---|---|
| id | Identifier (UUID, text) | |
| system_id | Identifier (UUID, text) | |
| user_id | Identifier (UUID, text) | |
| type_id | Identifier (UUID, text) | |
| location_id | Identifier (UUID, text) | |
| erworben_am | Date (ISO 8601, YYYY-MM-DD) | |
| gueltig_bis | Date (ISO 8601, YYYY-MM-DD) | |
| aussteller | Text (UTF-8) | |
| notiz | Text (UTF-8) | |
| document_id | Identifier (UUID, text) | |
| herkunft | Text (UTF-8) | |
| session_id | Identifier (UUID, text) | |
| pruefstatus | Text (UTF-8) | |
| geprueft_von | Identifier (UUID, text) | |
| geprueft_am | Timestamp (ISO 8601 with UTC offset) | |
| ablehnungsgrund | Text (UTF-8) | |
| created_by | Identifier (UUID, text) | |
| created_at | Timestamp (ISO 8601 with UTC offset) |
Training sessions
In-person training sessions.
JSON: daten/academy/schulungstermine.json · CSV: daten/academy/schulungstermine.csv
| Field | Format | Values |
|---|---|---|
| id | Identifier (UUID, text) | |
| system_id | Identifier (UUID, text) | |
| location_id | Identifier (UUID, text) | |
| titel | Text (UTF-8) | |
| beschreibung | Text (UTF-8) | |
| ort | Text (UTF-8) | |
| beginn | Timestamp (ISO 8601 with UTC offset) | |
| ende | Timestamp (ISO 8601 with UTC offset) | |
| kapazitaet | Integer | |
| type_id | Identifier (UUID, text) | |
| course_id | Identifier (UUID, text) | |
| selbsteinschreibung | Boolean (true/false) | |
| anmeldeschluss | Timestamp (ISO 8601 with UTC offset) | |
| abgesagt_am | Timestamp (ISO 8601 with UTC offset) | |
| erstellt_von | Identifier (UUID, text) | |
| created_at | Timestamp (ISO 8601 with UTC offset) |
Training enrolments
Enrolments and attendance.
JSON: daten/academy/schulungsanmeldungen.json · CSV: daten/academy/schulungsanmeldungen.csv
| Field | Format | Values |
|---|---|---|
| session_id | Identifier (UUID, text) | |
| user_id | Identifier (UUID, text) | |
| system_id | Identifier (UUID, text) | |
| status | Text (UTF-8) | |
| eingeladen_von | Identifier (UUID, text) | |
| geaendert_am | Timestamp (ISO 8601 with UTC offset) | |
| anwesenheit_von | Identifier (UUID, text) | |
| anwesenheit_am | Timestamp (ISO 8601 with UTC offset) | |
| record_id | Identifier (UUID, text) | |
| created_at | Timestamp (ISO 8601 with UTC offset) |
Rota, time tracking and absences · 32 Files
Shifts
Planned shifts.
JSON: daten/dienstplan/schichten.json · CSV: daten/dienstplan/schichten.csv
| Field | Format | Values |
|---|---|---|
| id | Identifier (UUID, text) | |
| system_id | Identifier (UUID, text) | |
| location_id | Identifier (UUID, text) | |
| user_id | Identifier (UUID, text) | |
| starts_at | Timestamp (ISO 8601 with UTC offset) | |
| ends_at | Timestamp (ISO 8601 with UTC offset) | |
| role_label | Text (UTF-8) | |
| status | Text (UTF-8) | |
| created_by | Identifier (UUID, text) | |
| created_at | Timestamp (ISO 8601 with UTC offset) | |
| department_id | Identifier (UUID, text) |
Shift templates
Weekly templates per location.
JSON: daten/dienstplan/schicht_vorlagen.json · CSV: daten/dienstplan/schicht_vorlagen.csv
| Field | Format | Values |
|---|---|---|
| id | Identifier (UUID, text) | |
| system_id | Identifier (UUID, text) | |
| location_id | Identifier (UUID, text) | |
| name | Text (UTF-8) | |
| created_by | Identifier (UUID, text) | |
| created_at | Timestamp (ISO 8601 with UTC offset) |
Template items
Shifts of the templates.
JSON: daten/dienstplan/schicht_vorlagen_eintraege.json · CSV: daten/dienstplan/schicht_vorlagen_eintraege.csv
| Field | Format | Values |
|---|---|---|
| id | Identifier (UUID, text) | |
| template_id | Identifier (UUID, text) | |
| system_id | Identifier (UUID, text) | |
| weekday | Integer | |
| starts_at | Time of day (HH:MM:SS, local time of the location) | |
| ends_at | Time of day (HH:MM:SS, local time of the location) | |
| department_id | Identifier (UUID, text) | |
| role_label | Text (UTF-8) | |
| user_id | Identifier (UUID, text) |
Rota publications
Published weeks.
JSON: daten/dienstplan/veroeffentlichungen.json · CSV: daten/dienstplan/veroeffentlichungen.csv
| Field | Format | Values |
|---|---|---|
| location_id | Identifier (UUID, text) | |
| montag | Date (ISO 8601, YYYY-MM-DD) | |
| system_id | Identifier (UUID, text) | |
| published_at | Timestamp (ISO 8601 with UTC offset) | |
| published_by | Identifier (UUID, text) | |
| aenderungen | Integer |
Shift swaps
Swap offers and decisions.
JSON: daten/dienstplan/schichttausch.json · CSV: daten/dienstplan/schichttausch.csv
| Field | Format | Values |
|---|---|---|
| id | Identifier (UUID, text) | |
| system_id | Identifier (UUID, text) | |
| location_id | Identifier (UUID, text) | |
| shift_id | Identifier (UUID, text) | |
| von_user | Identifier (UUID, text) | |
| an_user | Identifier (UUID, text) | |
| status | Text (UTF-8) | |
| notiz | Text (UTF-8) | |
| created_at | Timestamp (ISO 8601 with UTC offset) | |
| entschieden_von | Identifier (UUID, text) | |
| entschieden_am | Timestamp (ISO 8601 with UTC offset) |
Time entries
Working times with approval, origin (app, time clock, import, added by the person) and project/cost centre.
JSON: daten/dienstplan/zeiterfassung.json · CSV: daten/dienstplan/zeiterfassung.csv
| Field | Format | Values |
|---|---|---|
| id | Identifier (UUID, text) | |
| system_id | Identifier (UUID, text) | |
| location_id | Identifier (UUID, text) | |
| user_id | Identifier (UUID, text) | |
| started_at | Timestamp (ISO 8601 with UTC offset) | |
| ended_at | Timestamp (ISO 8601 with UTC offset) | |
| zustand | Text (UTF-8) | |
| note | Text (UTF-8) | |
| created_at | Timestamp (ISO 8601 with UTC offset) | |
| pause_min | Integer | |
| pause_started_at | Timestamp (ISO 8601 with UTC offset) | |
| freigegeben_am | Timestamp (ISO 8601 with UTC offset) | |
| freigegeben_von | Identifier (UUID, text) | |
| quelle | Text (UTF-8) | |
| geraet_id | Identifier (UUID, text) | |
| ende_quelle | Text (UTF-8) | |
| ende_geraet_id | Identifier (UUID, text) | |
| kostenstelle_id | Identifier (UUID, text) | |
| schichtbeginn | Timestamp (ISO 8601 with UTC offset) | |
| abrechnung_ab | Timestamp (ISO 8601 with UTC offset) |
Projects and cost centres
Code, name, type, validity and optional project plan – system-wide or per location.
JSON: daten/dienstplan/kostenstellen.json · CSV: daten/dienstplan/kostenstellen.csv
| Field | Format | Values |
|---|---|---|
| id | Identifier (UUID, text) | |
| system_id | Identifier (UUID, text) | |
| location_id | Identifier (UUID, text) | |
| code | Text (UTF-8) | |
| name | Text (UTF-8) | |
| art | Text (UTF-8) | |
| vorhaben_id | Identifier (UUID, text) | |
| gueltig_ab | Date (ISO 8601, YYYY-MM-DD) | |
| gueltig_bis | Date (ISO 8601, YYYY-MM-DD) | |
| aktiv | Boolean (true/false) | |
| geaendert_von | Identifier (UUID, text) | |
| geaendert_am | Timestamp (ISO 8601 with UTC offset) |
Breaks
Breaks per time entry.
JSON: daten/dienstplan/pausen.json · CSV: daten/dienstplan/pausen.csv
| Field | Format | Values |
|---|---|---|
| id | Identifier (UUID, text) | |
| entry_id | Identifier (UUID, text) | |
| system_id | Identifier (UUID, text) | |
| started_at | Timestamp (ISO 8601 with UTC offset) | |
| ended_at | Timestamp (ISO 8601 with UTC offset) | |
| geraetezeit | Boolean (true/false) |
Time corrections
Correction requests and decisions.
JSON: daten/dienstplan/zeitkorrekturen.json · CSV: daten/dienstplan/zeitkorrekturen.csv
| Field | Format | Values |
|---|---|---|
| id | Identifier (UUID, text) | |
| entry_id | Identifier (UUID, text) | |
| system_id | Identifier (UUID, text) | |
| requested_by | Identifier (UUID, text) | |
| vorschlag_start | Timestamp (ISO 8601 with UTC offset) | |
| vorschlag_ende | Timestamp (ISO 8601 with UTC offset) | |
| vorschlag_pause | Integer | |
| grund | Text (UTF-8) | |
| status | Text (UTF-8) | |
| antwort | Text (UTF-8) | |
| entschieden_von | Identifier (UUID, text) | |
| entschieden_am | Timestamp (ISO 8601 with UTC offset) | |
| created_at | Timestamp (ISO 8601 with UTC offset) |
Acknowledged violations
Working time violations (too long, missing break, rest period) acknowledged by the employer with a reason.
JSON: daten/dienstplan/verstoss_kenntnisnahmen.json · CSV: daten/dienstplan/verstoss_kenntnisnahmen.csv
| Field | Format | Values |
|---|---|---|
| id | Identifier (UUID, text) | |
| system_id | Identifier (UUID, text) | |
| location_id | Identifier (UUID, text) | |
| user_id | Identifier (UUID, text) | |
| tag | Date (ISO 8601, YYYY-MM-DD) | |
| regel | Text (UTF-8) | |
| wert_min | Integer | |
| grenze_min | Integer | |
| stand | Text (UTF-8) | |
| begruendung | Text (UTF-8) | |
| bestaetigt_von | Identifier (UUID, text) | |
| bestaetigt_am | Timestamp (ISO 8601 with UTC offset) |
Time changes
Audit trail of time entries.
JSON: daten/dienstplan/zeit_aenderungen.json · CSV: daten/dienstplan/zeit_aenderungen.csv
| Field | Format | Values |
|---|---|---|
| id | Identifier (UUID, text) | |
| entry_id | Identifier (UUID, text) | |
| system_id | Identifier (UUID, text) | |
| geaendert_von | Identifier (UUID, text) | |
| geaendert_am | Timestamp (ISO 8601 with UTC offset) | |
| feld | Text (UTF-8) | |
| vorher | Text (UTF-8) | |
| nachher | Text (UTF-8) | |
| grund | Text (UTF-8) |
Absences
Leave, sickness and other absences, as far as visible – with half days (including half first/last day).
JSON: daten/dienstplan/abwesenheiten.json · CSV: daten/dienstplan/abwesenheiten.csv
| Field | Format | Values |
|---|---|---|
| id | Identifier (UUID, text) | |
| system_id | Identifier (UUID, text) | |
| location_id | Identifier (UUID, text) | |
| user_id | Identifier (UUID, text) | |
| art | Text (UTF-8) | |
| von | Date (ISO 8601, YYYY-MM-DD) | |
| bis | Date (ISO 8601, YYYY-MM-DD) | |
| status | Text (UTF-8) | |
| note | Text (UTF-8) | |
| entschieden_von | Identifier (UUID, text) | |
| entschieden_am | Timestamp (ISO 8601 with UTC offset) | |
| created_by | Identifier (UUID, text) | |
| created_at | Timestamp (ISO 8601 with UTC offset) | |
| halber_tag | Boolean (true/false) | |
| storniert_von | Identifier (UUID, text) | |
| storniert_am | Timestamp (ISO 8601 with UTC offset) | |
| storno_grund | Text (UTF-8) | |
| uhrzeit_von | Time of day (HH:MM:SS, local time of the location) | |
| uhrzeit_bis | Time of day (HH:MM:SS, local time of the location) | |
| stunden | Decimal number (dot as decimal separator) | |
| vertretung_id | Identifier (UUID, text) | |
| entscheidung_kommentar | Text (UTF-8) | |
| storno_antrag_am | Timestamp (ISO 8601 with UTC offset) | |
| storno_antrag_grund | Text (UTF-8) | |
| storno_antrag_entschieden_am | Timestamp (ISO 8601 with UTC offset) | |
| storno_antrag_antwort | Text (UTF-8) | |
| eigene_art_id | Identifier (UUID, text) | |
| vorgenehmigt_von | Identifier (UUID, text) | |
| vorgenehmigt_am | Timestamp (ISO 8601 with UTC offset) | |
| vorgenehmigt_kommentar | Text (UTF-8) | |
| ende_offen | Boolean (true/false) | |
| halb_erster_tag | Boolean (true/false) | |
| halb_letzter_tag | Boolean (true/false) |
Continued illnesses
Links from a sick note to an earlier one for the same illness (no diagnosis, employer only).
JSON: daten/dienstplan/krank_fortsetzungen.json · CSV: daten/dienstplan/krank_fortsetzungen.csv
| Field | Format | Values |
|---|---|---|
| absence_id | Identifier (UUID, text) | |
| system_id | Identifier (UUID, text) | |
| user_id | Identifier (UUID, text) | |
| fortsetzung_von | Identifier (UUID, text) | |
| erfasst_von | Identifier (UUID, text) | |
| erfasst_am | Timestamp (ISO 8601 with UTC offset) |
Delegations
Delegation rules for absences.
JSON: daten/dienstplan/abwesenheit_vertretungen.json · CSV: daten/dienstplan/abwesenheit_vertretungen.csv
| Field | Format | Values |
|---|---|---|
| id | Identifier (UUID, text) | |
| system_id | Identifier (UUID, text) | |
| location_id | Identifier (UUID, text) | |
| stellvertretung_id | Identifier (UUID, text) | |
| erteilt_von | Identifier (UUID, text) | |
| von | Date (ISO 8601, YYYY-MM-DD) | |
| bis | Date (ISO 8601, YYYY-MM-DD) | |
| abwesenheiten | Boolean (true/false) | |
| zeitkorrekturen | Boolean (true/false) | |
| widerrufen_am | Timestamp (ISO 8601 with UTC offset) | |
| widerrufen_von | Identifier (UUID, text) | |
| created_at | Timestamp (ISO 8601 with UTC offset) |
Standing deputies
Who decides while the employer is away.
JSON: daten/dienstplan/staendige_vertretungen.json · CSV: daten/dienstplan/staendige_vertretungen.csv
| Field | Format | Values |
|---|---|---|
| id | Identifier (UUID, text) | |
| system_id | Identifier (UUID, text) | |
| location_id | Identifier (UUID, text) | |
| arbeitgeber_id | Identifier (UUID, text) | |
| stellvertretung_id | Identifier (UUID, text) | |
| abwesenheiten | Boolean (true/false) | |
| zeitkorrekturen | Boolean (true/false) | |
| geaendert_am | Timestamp (ISO 8601 with UTC offset) |
Maternity leave
Due date, date of birth and reason for 12 weeks per maternity leave; after a miscarriage the date, week of pregnancy and whether the person waived the protection period; breastfeeding until (visible to the person and employer only).
JSON: daten/dienstplan/mutterschutz.json · CSV: daten/dienstplan/mutterschutz.csv
| Field | Format | Values |
|---|---|---|
| absence_id | Identifier (UUID, text) | |
| system_id | Identifier (UUID, text) | |
| user_id | Identifier (UUID, text) | |
| location_id | Identifier (UUID, text) | |
| entbindungstermin | Date (ISO 8601, YYYY-MM-DD) | |
| entbindung_am | Date (ISO 8601, YYYY-MM-DD) | |
| zwoelf_wochen | Text (UTF-8) | |
| erfasst_von | Identifier (UUID, text) | |
| erfasst_am | Timestamp (ISO 8601 with UTC offset) | |
| geaendert_von | Identifier (UUID, text) | |
| geaendert_am | Timestamp (ISO 8601 with UTC offset) | |
| fehlgeburt_am | Date (ISO 8601, YYYY-MM-DD) | |
| fehlgeburt_ssw | Integer | |
| verzicht | Boolean (true/false) | |
| stillzeit_bis | Date (ISO 8601, YYYY-MM-DD) |
Severe disability
Record of a severe disability (degree of disability 50 or more) with start and end for the additional leave (visible to the person and employer only, never to head office).
JSON: daten/dienstplan/schwerbehinderung.json · CSV: daten/dienstplan/schwerbehinderung.csv
| Field | Format | Values |
|---|---|---|
| user_id | Identifier (UUID, text) | |
| system_id | Identifier (UUID, text) | |
| seit | Date (ISO 8601, YYYY-MM-DD) | |
| bis | Date (ISO 8601, YYYY-MM-DD) | |
| erfasst_von | Identifier (UUID, text) | |
| erfasst_am | Timestamp (ISO 8601 with UTC offset) | |
| geaendert_am | Timestamp (ISO 8601 with UTC offset) |
Unexcused absence
Days on which the employer recorded an unexcused absence, with a note (affects pay for adjacent public holidays).
JSON: daten/dienstplan/unentschuldigte_fehltage.json · CSV: daten/dienstplan/unentschuldigte_fehltage.csv
| Field | Format | Values |
|---|---|---|
| id | Identifier (UUID, text) | |
| system_id | Identifier (UUID, text) | |
| user_id | Identifier (UUID, text) | |
| tag | Date (ISO 8601, YYYY-MM-DD) | |
| notiz | Text (UTF-8) | |
| erfasst_von | Identifier (UUID, text) | |
| erfasst_am | Timestamp (ISO 8601 with UTC offset) |
Work schedules
Target working time per person, also rotating over several weeks.
JSON: daten/dienstplan/arbeitszeitmodelle.json · CSV: daten/dienstplan/arbeitszeitmodelle.csv
| Field | Format | Values |
|---|---|---|
| id | Identifier (UUID, text) | |
| system_id | Identifier (UUID, text) | |
| location_id | Identifier (UUID, text) | |
| user_id | Identifier (UUID, text) | |
| gueltig_ab | Date (ISO 8601, YYYY-MM-DD) | |
| gueltig_bis | Date (ISO 8601, YYYY-MM-DD) | |
| vorlage_id | Identifier (UUID, text) | |
| bezeichnung | Text (UTF-8) | |
| flexibel | Boolean (true/false) | |
| tagesstunden | List (JSON array) of: Decimal number (dot as decimal separator) | |
| soll_art | Text (UTF-8) | |
| soll_stunden | Decimal number (dot as decimal separator) | |
| created_by | Identifier (UUID, text) | |
| created_at | Timestamp (ISO 8601 with UTC offset) | |
| rhythmus_wochen | Integer | |
| rhythmus_start | Date (ISO 8601, YYYY-MM-DD) | |
| rhythmus_stunden | List (JSON array) of: Decimal number (dot as decimal separator) |
Preferred weekly schedules
Proposed hours per day of a week with the employer's decision.
JSON: daten/dienstplan/wochenplan_wuensche.json · CSV: daten/dienstplan/wochenplan_wuensche.csv
| Field | Format | Values |
|---|---|---|
| id | Identifier (UUID, text) | |
| system_id | Identifier (UUID, text) | |
| location_id | Identifier (UUID, text) | |
| user_id | Identifier (UUID, text) | |
| woche | Date (ISO 8601, YYYY-MM-DD) | |
| tagesstunden | List (JSON array) of: Decimal number (dot as decimal separator) | |
| notiz | Text (UTF-8) | |
| status | Text (UTF-8) | |
| kommentar | Text (UTF-8) | |
| entschieden_von | Identifier (UUID, text) | |
| entschieden_am | Timestamp (ISO 8601 with UTC offset) | |
| erstellt_am | Timestamp (ISO 8601 with UTC offset) |
Schedule templates
Templates for work schedules.
JSON: daten/dienstplan/arbeitszeitmodell_vorlagen.json · CSV: daten/dienstplan/arbeitszeitmodell_vorlagen.csv
| Field | Format | Values |
|---|---|---|
| id | Identifier (UUID, text) | |
| system_id | Identifier (UUID, text) | |
| schluessel | Text (UTF-8) | |
| name | Text (UTF-8) | |
| flexibel | Boolean (true/false) | |
| tagesstunden | List (JSON array) of: Decimal number (dot as decimal separator) | |
| soll_art | Text (UTF-8) | |
| soll_stunden | Decimal number (dot as decimal separator) | |
| reihenfolge | Integer | |
| aktiv | Boolean (true/false) | |
| created_at | Timestamp (ISO 8601 with UTC offset) |
Remote work approvals
Granted approvals.
JSON: daten/dienstplan/homeoffice.json · CSV: daten/dienstplan/homeoffice.csv
| Field | Format | Values |
|---|---|---|
| user_id | Identifier (UUID, text) | |
| system_id | Identifier (UUID, text) | |
| location_id | Identifier (UUID, text) | |
| erteilt_von | Identifier (UUID, text) | |
| erteilt_am | Timestamp (ISO 8601 with UTC offset) |
Leave notices
Notices on remaining leave and expiry.
JSON: daten/dienstplan/urlaub_hinweise.json · CSV: daten/dienstplan/urlaub_hinweise.csv
| Field | Format | Values |
|---|---|---|
| id | Identifier (UUID, text) | |
| system_id | Identifier (UUID, text) | |
| location_id | Identifier (UUID, text) | |
| user_id | Identifier (UUID, text) | |
| art | Text (UTF-8) | |
| jahr | Integer | |
| tage | Decimal number (dot as decimal separator) | |
| verfall | Date (ISO 8601, YYYY-MM-DD) | |
| angezeigt_am | Timestamp (ISO 8601 with UTC offset) | |
| bestaetigt_am | Timestamp (ISO 8601 with UTC offset) |
Absence rules
Rules per absence type (approval, notice, allowance, required comment, maximum length, notification from N days).
JSON: daten/dienstplan/abwesenheitsrichtlinien.json · CSV: daten/dienstplan/abwesenheitsrichtlinien.csv
| Field | Format | Values |
|---|---|---|
| id | Identifier (UUID, text) | |
| system_id | Identifier (UUID, text) | |
| location_id | Identifier (UUID, text) | |
| art | Text (UTF-8) | |
| aktiv | Boolean (true/false) | |
| genehmigung | Text (UTF-8) | |
| vorlauf_tage | Integer | |
| kontingent_tage | Decimal number (dot as decimal separator) | |
| krankschein_ab_tag | Integer | |
| geaendert_von | Identifier (UUID, text) | |
| geaendert_am | Timestamp (ISO 8601 with UTC offset) | |
| kommentar_pflicht | Boolean (true/false) | |
| max_tage | Integer | |
| vertretung_pflicht | Boolean (true/false) | |
| melden_ab_tage | Integer |
Leave blackouts
Periods in which certain types cannot be requested.
JSON: daten/dienstplan/urlaubssperren.json · CSV: daten/dienstplan/urlaubssperren.csv
| Field | Format | Values |
|---|---|---|
| id | Identifier (UUID, text) | |
| system_id | Identifier (UUID, text) | |
| location_id | Identifier (UUID, text) | |
| von | Date (ISO 8601, YYYY-MM-DD) | |
| bis | Date (ISO 8601, YYYY-MM-DD) | |
| arten | List (JSON array) of: Text (UTF-8) | |
| grund | Text (UTF-8) | |
| angelegt_von | Identifier (UUID, text) | |
| angelegt_am | Timestamp (ISO 8601 with UTC offset) |
Absence limits
Maximum number absent at once per location.
JSON: daten/dienstplan/abwesenheitsgrenzen.json · CSV: daten/dienstplan/abwesenheitsgrenzen.csv
| Field | Format | Values |
|---|---|---|
| id | Identifier (UUID, text) | |
| system_id | Identifier (UUID, text) | |
| location_id | Identifier (UUID, text) | |
| max_gleichzeitig | Integer | |
| arten | List (JSON array) of: Text (UTF-8) | |
| geaendert_von | Identifier (UUID, text) | |
| geaendert_am | Timestamp (ISO 8601 with UTC offset) |
Custom absence types
Freely named types with base type, calendar colour and counting (working or calendar days).
JSON: daten/dienstplan/eigene_abwesenheitsarten.json · CSV: daten/dienstplan/eigene_abwesenheitsarten.csv
| Field | Format | Values |
|---|---|---|
| id | Identifier (UUID, text) | |
| system_id | Identifier (UUID, text) | |
| location_id | Identifier (UUID, text) | |
| name | Text (UTF-8) | |
| basis | Text (UTF-8) | |
| kontingent_tage | Decimal number (dot as decimal separator) | |
| aktiv | Boolean (true/false) | |
| geaendert_von | Identifier (UUID, text) | |
| geaendert_am | Timestamp (ISO 8601 with UTC offset) | |
| farbe | Text (UTF-8) | |
| zaehlweise | Text (UTF-8) |
Absence allowances
Days per person, type and year.
JSON: daten/dienstplan/abwesenheitskontingente.json · CSV: daten/dienstplan/abwesenheitskontingente.csv
| Field | Format | Values |
|---|---|---|
| id | Identifier (UUID, text) | |
| system_id | Identifier (UUID, text) | |
| user_id | Identifier (UUID, text) | |
| art | Text (UTF-8) | |
| jahr | Integer | |
| tage | Decimal number (dot as decimal separator) | |
| gesetzt_von | Identifier (UUID, text) | |
| gesetzt_am | Timestamp (ISO 8601 with UTC offset) |
Leave bookings
Adjustments, days converted from overtime and later changes to the carry-over.
JSON: daten/dienstplan/urlaubsbuchungen.json · CSV: daten/dienstplan/urlaubsbuchungen.csv
| Field | Format | Values |
|---|---|---|
| id | Identifier (UUID, text) | |
| system_id | Identifier (UUID, text) | |
| user_id | Identifier (UUID, text) | |
| jahr | Integer | |
| art | Text (UTF-8) | |
| tage | Decimal number (dot as decimal separator) | |
| grund | Text (UTF-8) | |
| zeitbuchung_id | Identifier (UUID, text) | |
| erstellt_von | Identifier (UUID, text) | |
| erstellt_am | Timestamp (ISO 8601 with UTC offset) |
Leave carry-overs
Log of the automatic carry-over at year end, with protected and capped days.
JSON: daten/dienstplan/urlaubsuebertraege.json · CSV: daten/dienstplan/urlaubsuebertraege.csv
| Field | Format | Values |
|---|---|---|
| id | Identifier (UUID, text) | |
| system_id | Identifier (UUID, text) | |
| user_id | Identifier (UUID, text) | |
| jahr | Integer | |
| alt_tage | Decimal number (dot as decimal separator) | |
| alt_verfall | Date (ISO 8601, YYYY-MM-DD) | |
| neu_tage | Decimal number (dot as decimal separator) | |
| neu_verfall | Date (ISO 8601, YYYY-MM-DD) | |
| ergebnis | Text (UTF-8) | |
| erstellt_am | Timestamp (ISO 8601 with UTC offset) | |
| geschuetzt | Decimal number (dot as decimal separator) | |
| geschuetzt_bis | Date (ISO 8601, YYYY-MM-DD) | |
| geschuetzt_grund | Text (UTF-8) | |
| gekappt | Decimal number (dot as decimal separator) | |
| hinweis_gegeben | Boolean (true/false) |
Overtime bookings
Opening balances, adjustments, payouts and conversions.
JSON: daten/dienstplan/zeitkonto_buchungen.json · CSV: daten/dienstplan/zeitkonto_buchungen.csv
| Field | Format | Values |
|---|---|---|
| id | Identifier (UUID, text) | |
| system_id | Identifier (UUID, text) | |
| user_id | Identifier (UUID, text) | |
| art | Text (UTF-8) | |
| datum | Date (ISO 8601, YYYY-MM-DD) | |
| minuten | Integer | |
| grund | Text (UTF-8) | |
| erstellt_von | Identifier (UUID, text) | |
| erstellt_am | Timestamp (ISO 8601 with UTC offset) |
Calendar subscriptions
Own calendar subscriptions (without the secret link).
JSON: daten/dienstplan/kalender_abos.json · CSV: daten/dienstplan/kalender_abos.csv
| Field | Format | Values |
|---|---|---|
| id | Identifier (UUID, text) | |
| umfang | Text (UTF-8) | |
| erstellt_am | Timestamp (ISO 8601 with UTC offset) | |
| letzter_abruf | Timestamp (ISO 8601 with UTC offset) |
Personnel files and documents · 29 Files
Personnel files
Employee master data (visible to the employer only).
JSON: daten/personal/personalakten.json · CSV: daten/personal/personalakten.csv
| Field | Format | Values |
|---|---|---|
| user_id | Identifier (UUID, text) | |
| system_id | Identifier (UUID, text) | |
| location_id | Identifier (UUID, text) | |
| position | Text (UTF-8) | |
| eintritt | Date (ISO 8601, YYYY-MM-DD) | |
| austritt | Date (ISO 8601, YYYY-MM-DD) | |
| befristet_bis | Date (ISO 8601, YYYY-MM-DD) | |
| probezeit_ende | Date (ISO 8601, YYYY-MM-DD) | |
| wochenstunden | Decimal number (dot as decimal separator) | |
| geburtsdatum | Date (ISO 8601, YYYY-MM-DD) | |
| telefon | Text (UTF-8) | |
| anschrift | Text (UTF-8) | |
| notfall_name | Text (UTF-8) | |
| notfall_telefon | Text (UTF-8) | |
| sv_nummer | Text (UTF-8) | |
| steuer_id | Text (UTF-8) | |
| iban | Text (UTF-8) | |
| notiz | Text (UTF-8) | |
| aktualisiert_am | Timestamp (ISO 8601 with UTC offset) | |
| aktualisiert_von | Identifier (UUID, text) | |
| personalnummer | Text (UTF-8) | |
| lohnart | Text (UTF-8) | |
| urlaubsanspruch | Decimal number (dot as decimal separator) | |
| urlaub_uebertrag | Decimal number (dot as decimal separator) | |
| beschaeftigungsart | Text (UTF-8) | |
| arbeitstage_pro_woche | Integer | |
| steuerklasse | Integer | |
| kinderfreibetrag | Decimal number (dot as decimal separator) | |
| konfession | Text (UTF-8) | |
| krankenkasse | Text (UTF-8) | |
| rentenversicherung_befreit | Boolean (true/false) | |
| urlaub_uebertrag_verfall | Date (ISO 8601, YYYY-MM-DD) | |
| kuendigung_eingang | Date (ISO 8601, YYYY-MM-DD) | |
| austrittsgrund | Text (UTF-8) | |
| steuerberater_personalnummer | Text (UTF-8) | |
| minijob_ausnahmemonate | Integer | |
| vorname | Text (UTF-8) | |
| vorsatzwort | Text (UTF-8) | |
| nachname | Text (UTF-8) | |
| namenszusatz | Text (UTF-8) | |
| akademischer_grad | Text (UTF-8) | |
| geburtsname | Text (UTF-8) | |
| geburtsort | Text (UTF-8) | |
| geburtsland | Text (UTF-8) | |
| geschlecht | Text (UTF-8) | |
| staatsangehoerigkeit | Text (UTF-8) | |
| familienstand | Text (UTF-8) | |
| kinder_anzahl | Integer | |
| strasse | Text (UTF-8) | |
| hausnummer | Text (UTF-8) | |
| adresszusatz | Text (UTF-8) | |
| plz | Text (UTF-8) | |
| ort | Text (UTF-8) | |
| land | Text (UTF-8) | |
| notfall_beziehung | Text (UTF-8) | |
| bic | Text (UTF-8) | |
| kontoinhaber | Text (UTF-8) | |
| krankenversicherung_art | Text (UTF-8) | |
| arbeitgeber_art | Text (UTF-8) | |
| weitere_beschaeftigung | Text (UTF-8) | |
| weitere_beschaeftigung_details | Text (UTF-8) | |
| schulabschluss | Text (UTF-8) | |
| berufsausbildung | Text (UTF-8) | |
| ausbildung_beginn | Date (ISO 8601, YYYY-MM-DD) | |
| ausbildung_ende_voraussichtlich | Date (ISO 8601, YYYY-MM-DD) | |
| ausbildung_ende | Date (ISO 8601, YYYY-MM-DD) | |
| studienbescheinigung_bis | Date (ISO 8601, YYYY-MM-DD) | |
| aufenthaltstitel_art | Text (UTF-8) | |
| aufenthaltstitel_bis | Date (ISO 8601, YYYY-MM-DD) | |
| arbeitserlaubnis_bis | Date (ISO 8601, YYYY-MM-DD) | |
| kuendigung_art | Text (UTF-8) | |
| letzter_arbeitstag | Date (ISO 8601, YYYY-MM-DD) | |
| abteilung_id | Identifier (UUID, text) | |
| ueberstunden_abgegolten_min | Integer | |
| ueberstunden_abgegolten_ab | Date (ISO 8601, YYYY-MM-DD) | |
| email_privat | Text (UTF-8) | |
| pv_kinder_unter_25 | Integer |
Documents
Personnel and partner documents; files under dateien/dokumente/.
JSON: daten/personal/dokumente.json · CSV: daten/personal/dokumente.csv
| Field | Format | Values |
|---|---|---|
| id | Identifier (UUID, text) | |
| system_id | Identifier (UUID, text) | |
| location_id | Identifier (UUID, text) | |
| partner_id | Identifier (UUID, text) | |
| category | Text (UTF-8) | |
| title | Text (UTF-8) | |
| file_path | Text (UTF-8) | |
| valid_until | Date (ISO 8601, YYYY-MM-DD) | |
| created_by | Identifier (UUID, text) | |
| created_at | Timestamp (ISO 8601 with UTC offset) | |
| personal | Boolean (true/false) | |
| sichtbar_fuer_mitarbeiter | Boolean (true/false) | |
| unterschrieben_am | Date (ISO 8601, YYYY-MM-DD) | |
| abwesenheit_id | Identifier (UUID, text) | |
| geprueft_von | Identifier (UUID, text) | |
| geprueft_am | Timestamp (ISO 8601 with UTC offset) | |
| selbstauskunft_id | Identifier (UUID, text) | |
| kommentar | Text (UTF-8) | |
| geloescht_am | Timestamp (ISO 8601 with UTC offset) | |
| geloescht_von | Identifier (UUID, text) | |
| geloescht_grund | Text (UTF-8) | |
| eigene_kategorie_id | Identifier (UUID, text) | |
| kategorie_name | Text (UTF-8) | |
| ifsg_art | Text (UTF-8) | |
| belehrung_am | Date (ISO 8601, YYYY-MM-DD) |
Receipt confirmations
Requested and confirmed receipts.
JSON: daten/personal/dokument_erhalt.json · CSV: daten/personal/dokument_erhalt.csv
| Field | Format | Values |
|---|---|---|
| id | Identifier (UUID, text) | |
| system_id | Identifier (UUID, text) | |
| document_id | Identifier (UUID, text) | |
| user_id | Identifier (UUID, text) | |
| location_id | Identifier (UUID, text) | |
| dokument_titel | Text (UTF-8) | |
| file_path | Text (UTF-8) | |
| pdf_sha256 | Text (UTF-8) | |
| angefordert_von | Identifier (UUID, text) | |
| angefordert_am | Timestamp (ISO 8601 with UTC offset) | |
| erinnert_am | Timestamp (ISO 8601 with UTC offset) | |
| erinnerungen | Integer | |
| geoeffnet_am | Timestamp (ISO 8601 with UTC offset) | |
| bestaetigt_am | Timestamp (ISO 8601 with UTC offset) | |
| geraet | Text (UTF-8) | |
| user_agent | Text (UTF-8) | |
| erklaerung | Text (UTF-8) | |
| zurueckgezogen_am | Timestamp (ISO 8601 with UTC offset) | |
| zurueckgezogen_von | Identifier (UUID, text) | |
| art | Text (UTF-8) | |
| unterschrift_name | Text (UTF-8) |
Document templates
Templates for contracts and letters.
JSON: daten/personal/dokument_vorlagen.json · CSV: daten/personal/dokument_vorlagen.csv
| Field | Format | Values |
|---|---|---|
| id | Identifier (UUID, text) | |
| system_id | Identifier (UUID, text) | |
| partner_id | Identifier (UUID, text) | |
| titel | Text (UTF-8) | |
| kategorie | Text (UTF-8) | |
| beschreibung | Text (UTF-8) | |
| schriftform | Boolean (true/false) | |
| muster_key | Text (UTF-8) | |
| aktiv | Boolean (true/false) | |
| aktuelle_version | Integer | |
| erstellt_von | Identifier (UUID, text) | |
| erstellt_am | Timestamp (ISO 8601 with UTC offset) | |
| geaendert_am | Timestamp (ISO 8601 with UTC offset) | |
| bei_einstellung | Text (UTF-8) |
Template versions
Versions of the templates.
JSON: daten/personal/dokument_vorlagen_fassungen.json · CSV: daten/personal/dokument_vorlagen_fassungen.csv
| Field | Format | Values |
|---|---|---|
| id | Identifier (UUID, text) | |
| template_id | Identifier (UUID, text) | |
| system_id | Identifier (UUID, text) | |
| version | Integer | |
| inhalt | Text (UTF-8) | |
| erstellt_von | Identifier (UUID, text) | |
| erstellt_am | Timestamp (ISO 8601 with UTC offset) |
Generated documents
Documents generated from templates with data snapshot.
JSON: daten/personal/dokument_erzeugungen.json · CSV: daten/personal/dokument_erzeugungen.csv
| Field | Format | Values |
|---|---|---|
| id | Identifier (UUID, text) | |
| system_id | Identifier (UUID, text) | |
| document_id | Identifier (UUID, text) | |
| user_id | Identifier (UUID, text) | |
| location_id | Identifier (UUID, text) | |
| template_id | Identifier (UUID, text) | |
| template_version_id | Identifier (UUID, text) | |
| vorlage_titel | Text (UTF-8) | |
| version | Integer | |
| vorlage_inhalt | Text (UTF-8) | |
| datenstand | JSON (object or list; JSON text in CSV) | |
| ueberschrieben | List (JSON array) of: Text (UTF-8) | |
| text | Text (UTF-8) | |
| render | JSON (object or list; JSON text in CSV) | |
| pdf_sha256 | Text (UTF-8) | |
| stapel_id | Identifier (UUID, text) | |
| erzeugt_von | Identifier (UUID, text) | |
| erzeugt_am | Timestamp (ISO 8601 with UTC offset) |
Questionnaires and change requests
Employee submissions and decisions.
JSON: daten/personal/selbstauskuenfte.json · CSV: daten/personal/selbstauskuenfte.csv
| Field | Format | Values |
|---|---|---|
| id | Identifier (UUID, text) | |
| system_id | Identifier (UUID, text) | |
| user_id | Identifier (UUID, text) | |
| art | Text (UTF-8) | |
| status | Text (UTF-8) | |
| werte | JSON (object or list; JSON text in CSV) | |
| notiz | Text (UTF-8) | |
| kommentar | Text (UTF-8) | |
| frist | Date (ISO 8601, YYYY-MM-DD) | |
| uebernommen | List (JSON array) of: Text (UTF-8) | |
| verworfen | List (JSON array) of: Text (UTF-8) | |
| angefordert_von | Identifier (UUID, text) | |
| angefordert_am | Timestamp (ISO 8601 with UTC offset) | |
| eingereicht_am | Timestamp (ISO 8601 with UTC offset) | |
| entschieden_von | Identifier (UUID, text) | |
| entschieden_am | Timestamp (ISO 8601 with UTC offset) | |
| erstellt_am | Timestamp (ISO 8601 with UTC offset) | |
| aktualisiert_am | Timestamp (ISO 8601 with UTC offset) | |
| revision | Integer |
Onboarding/offboarding tasks
Tasks per person.
JSON: daten/personal/eintritt_austritt_aufgaben.json · CSV: daten/personal/eintritt_austritt_aufgaben.csv
| Field | Format | Values |
|---|---|---|
| id | Identifier (UUID, text) | |
| system_id | Identifier (UUID, text) | |
| location_id | Identifier (UUID, text) | |
| user_id | Identifier (UUID, text) | |
| template_id | Identifier (UUID, text) | |
| phase | Text (UTF-8) | |
| bezug | Date (ISO 8601, YYYY-MM-DD) | |
| reihenfolge | Integer | |
| aufgabe | Text (UTF-8) | |
| zustaendig | Text (UTF-8) | |
| faellig | Date (ISO 8601, YYYY-MM-DD) | |
| erledigt_am | Timestamp (ISO 8601 with UTC offset) | |
| erledigt_von | Identifier (UUID, text) | |
| created_at | Timestamp (ISO 8601 with UTC offset) | |
| vorlage_id | Identifier (UUID, text) | |
| vorlage_name | Text (UTF-8) | |
| von_hand | Boolean (true/false) | |
| zugewiesen_von | Identifier (UUID, text) | |
| nur_laender | List (JSON array) of: Text (UTF-8) | |
| nachweis | Text (UTF-8) | |
| erledigt_durch | Text (UTF-8) |
Onboarding/offboarding templates
Task templates.
JSON: daten/personal/eintritt_austritt_vorlagen.json · CSV: daten/personal/eintritt_austritt_vorlagen.csv
| Field | Format | Values |
|---|---|---|
| id | Identifier (UUID, text) | |
| system_id | Identifier (UUID, text) | |
| phase | Text (UTF-8) | |
| reihenfolge | Integer | |
| aufgabe | Text (UTF-8) | |
| zustaendig | Text (UTF-8) | |
| faellig_tage_relativ | Integer | |
| aktiv | Boolean (true/false) | |
| created_at | Timestamp (ISO 8601 with UTC offset) | |
| gespraech_art | Text (UTF-8) | |
| vorlage_id | Identifier (UUID, text) | |
| nur_laender | List (JSON array) of: Text (UTF-8) | |
| nachweis | Text (UTF-8) |
Checklist templates
Templates per stage with name and automatic assignment.
JSON: daten/personal/eintritt_austritt_listen.json · CSV: daten/personal/eintritt_austritt_listen.csv
| Field | Format | Values |
|---|---|---|
| id | Identifier (UUID, text) | |
| system_id | Identifier (UUID, text) | |
| phase | Text (UTF-8) | |
| name | Text (UTF-8) | |
| automatisch | Boolean (true/false) | |
| aktiv | Boolean (true/false) | |
| created_at | Timestamp (ISO 8601 with UTC offset) |
Custom personnel fields
Definitions of additional fields.
JSON: daten/personal/personalfelder.json · CSV: daten/personal/personalfelder.csv
| Field | Format | Values |
|---|---|---|
| id | Identifier (UUID, text) | |
| system_id | Identifier (UUID, text) | |
| location_id | Identifier (UUID, text) | |
| name | Text (UTF-8) | |
| typ | Text (UTF-8) | |
| optionen | List (JSON array) of: Text (UTF-8) | |
| abschnitt | Text (UTF-8) | |
| hilfetext | Text (UTF-8) | |
| pflicht | Boolean (true/false) | |
| sichtbar_fuer_person | Boolean (true/false) | |
| person_aenderbar | Boolean (true/false) | |
| reihenfolge | Integer | |
| im_export | Boolean (true/false) | |
| aktiv | Boolean (true/false) | |
| revision | Integer | |
| erstellt_von | Identifier (UUID, text) | |
| erstellt_am | Timestamp (ISO 8601 with UTC offset) | |
| geaendert_von | Identifier (UUID, text) | |
| geaendert_am | Timestamp (ISO 8601 with UTC offset) | |
| name_en | Text (UTF-8) | |
| hilfetext_en | Text (UTF-8) | |
| eindeutig | Boolean (true/false) |
Custom field values
Values of the additional fields.
JSON: daten/personal/personalfeld_werte.json · CSV: daten/personal/personalfeld_werte.csv
| Field | Format | Values |
|---|---|---|
| id | Identifier (UUID, text) | |
| system_id | Identifier (UUID, text) | |
| feld_id | Identifier (UUID, text) | |
| user_id | Identifier (UUID, text) | |
| location_id | Identifier (UUID, text) | |
| wert | JSON (object or list; JSON text in CSV) | |
| gueltig_ab | Date (ISO 8601, YYYY-MM-DD) | |
| quelle | Text (UTF-8) | |
| antrag_id | Identifier (UUID, text) | |
| erfasst_von | Identifier (UUID, text) | |
| erfasst_am | Timestamp (ISO 8601 with UTC offset) | |
| storniert_am | Timestamp (ISO 8601 with UTC offset) | |
| storniert_von | Identifier (UUID, text) |
Planned changes
Planned employment changes with effective date, new and previous values.
JSON: daten/personal/geplante_aenderungen.json · CSV: daten/personal/geplante_aenderungen.csv
| Field | Format | Values |
|---|---|---|
| id | Identifier (UUID, text) | |
| system_id | Identifier (UUID, text) | |
| user_id | Identifier (UUID, text) | |
| location_id | Identifier (UUID, text) | |
| wirksam_ab | Date (ISO 8601, YYYY-MM-DD) | |
| werte | JSON (object or list; JSON text in CSV) | |
| notiz | Text (UTF-8) | |
| status | Text (UTF-8) | |
| vorher | JSON (object or list; JSON text in CSV) | |
| modell_id | Identifier (UUID, text) | |
| fehler | Text (UTF-8) | |
| erstellt_von | Identifier (UUID, text) | |
| erstellt_am | Timestamp (ISO 8601 with UTC offset) | |
| geaendert_von | Identifier (UUID, text) | |
| geaendert_am | Timestamp (ISO 8601 with UTC offset) | |
| uebernommen_am | Timestamp (ISO 8601 with UTC offset) | |
| zurueckgenommen_von | Identifier (UUID, text) | |
| zurueckgenommen_am | Timestamp (ISO 8601 with UTC offset) |
Automations
Rules with trigger, conditions and actions (without person-related runs).
JSON: daten/personal/automatisierungen.json · CSV: daten/personal/automatisierungen.csv
| Field | Format | Values |
|---|---|---|
| id | Identifier (UUID, text) | |
| system_id | Identifier (UUID, text) | |
| location_id | Identifier (UUID, text) | |
| name | Text (UTF-8) | |
| ausloeser | Text (UTF-8) | |
| tage | Integer | |
| art | Text (UTF-8) | |
| bedingungen | JSON (object or list; JSON text in CSV) | |
| aktionen | JSON (object or list; JSON text in CSV) | |
| aktiv | Boolean (true/false) | |
| pausiert_am | Timestamp (ISO 8601 with UTC offset) | |
| pausiert_von | Identifier (UUID, text) | |
| archiviert_am | Timestamp (ISO 8601 with UTC offset) | |
| erstellt_von | Identifier (UUID, text) | |
| erstellt_am | Timestamp (ISO 8601 with UTC offset) | |
| geaendert_von | Identifier (UUID, text) | |
| geaendert_am | Timestamp (ISO 8601 with UTC offset) |
Job catalogue
Jobs with family and level.
JSON: daten/personal/stellenkatalog.json · CSV: daten/personal/stellenkatalog.csv
| Field | Format | Values |
|---|---|---|
| id | Identifier (UUID, text) | |
| system_id | Identifier (UUID, text) | |
| location_id | Identifier (UUID, text) | |
| titel | Text (UTF-8) | |
| familie | Text (UTF-8) | |
| ebene | Integer | |
| beschreibung | Text (UTF-8) | |
| aktiv | Boolean (true/false) | |
| geaendert_von | Identifier (UUID, text) | |
| geaendert_am | Timestamp (ISO 8601 with UTC offset) |
Staffing plan
Target headcount and weekly hours per location, job and period.
JSON: daten/personal/stellenplan.json · CSV: daten/personal/stellenplan.csv
| Field | Format | Values |
|---|---|---|
| id | Identifier (UUID, text) | |
| system_id | Identifier (UUID, text) | |
| location_id | Identifier (UUID, text) | |
| stelle_id | Identifier (UUID, text) | |
| taetigkeit | Text (UTF-8) | |
| soll_koepfe | Integer | |
| soll_stunden | Decimal number (dot as decimal separator) | |
| gueltig_ab | Date (ISO 8601, YYYY-MM-DD) | |
| gueltig_bis | Date (ISO 8601, YYYY-MM-DD) | |
| notiz | Text (UTF-8) | |
| geaendert_von | Identifier (UUID, text) | |
| geaendert_am | Timestamp (ISO 8601 with UTC offset) |
Former employees
Archive of former employees without an account (master data, rehiring).
JSON: daten/personal/ehemalige.json · CSV: daten/personal/ehemalige.csv
| Field | Format | Values |
|---|---|---|
| id | Identifier (UUID, text) | |
| system_id | Identifier (UUID, text) | |
| location_id | Identifier (UUID, text) | |
| name | Text (UTF-8) | |
| personalnummer | Text (UTF-8) | |
| eintritt | Date (ISO 8601, YYYY-MM-DD) | |
| austritt | Date (ISO 8601, YYYY-MM-DD) | |
| position | Text (UTF-8) | |
| beschaeftigungsart | Text (UTF-8) | |
| notiz | Text (UTF-8) | |
| aufbewahren_bis | Date (ISO 8601, YYYY-MM-DD) | |
| angelegt_von | Identifier (UUID, text) | |
| angelegt_am | Timestamp (ISO 8601 with UTC offset) | |
| wieder_einladung | Identifier (UUID, text) | |
| wieder_eingestellt_am | Timestamp (ISO 8601 with UTC offset) | |
| wieder_eingestellt_user | Identifier (UUID, text) |
Saved views
Own views of the staff list.
JSON: daten/personal/personalliste_ansichten.json · CSV: daten/personal/personalliste_ansichten.csv
| Field | Format | Values |
|---|---|---|
| id | Identifier (UUID, text) | |
| system_id | Identifier (UUID, text) | |
| user_id | Identifier (UUID, text) | |
| name | Text (UTF-8) | |
| spalten | List (JSON array) of: Text (UTF-8) | |
| filter | JSON (object or list; JSON text in CSV) | |
| sortierung | Text (UTF-8) | |
| erstellt_am | Timestamp (ISO 8601 with UTC offset) | |
| geteilt | Boolean (true/false) |
Saved reports
Source, columns, filters and grouping of saved reports.
JSON: daten/personal/bericht_ansichten.json · CSV: daten/personal/bericht_ansichten.csv
| Field | Format | Values |
|---|---|---|
| id | Identifier (UUID, text) | |
| system_id | Identifier (UUID, text) | |
| user_id | Identifier (UUID, text) | |
| name | Text (UTF-8) | |
| quelle | Text (UTF-8) | |
| spalten | List (JSON array) of: Text (UTF-8) | |
| filter | JSON (object or list; JSON text in CSV) | |
| gruppierung | Text (UTF-8) | |
| sortierung | Text (UTF-8) | |
| geteilt | Boolean (true/false) | |
| erstellt_am | Timestamp (ISO 8601 with UTC offset) |
Staff imports
Import runs with result counts.
JSON: daten/personal/personal_importe.json · CSV: daten/personal/personal_importe.csv
| Field | Format | Values |
|---|---|---|
| id | Identifier (UUID, text) | |
| system_id | Identifier (UUID, text) | |
| location_id | Identifier (UUID, text) | |
| kennung | Identifier (UUID, text) | |
| art | Text (UTF-8) | |
| modus | Text (UTF-8) | |
| aktualisieren | Boolean (true/false) | |
| pruefsumme | Text (UTF-8) | |
| uebernommen | Boolean (true/false) | |
| zeilen | Integer | |
| neu | Integer | |
| aktualisiert | Integer | |
| unveraendert | Integer | |
| vorgemerkt | Integer | |
| uebersprungen | Integer | |
| fehler | Integer | |
| erstellt_von | Identifier (UUID, text) | |
| erstellt_am | Timestamp (ISO 8601 with UTC offset) |
Import rows
Result per import row.
JSON: daten/personal/personal_import_zeilen.json · CSV: daten/personal/personal_import_zeilen.csv
| Field | Format | Values |
|---|---|---|
| id | Integer | |
| lauf_id | Identifier (UUID, text) | |
| system_id | Identifier (UUID, text) | |
| zeile | Integer | |
| ergebnis | Text (UTF-8) | |
| location_id | Identifier (UUID, text) | |
| user_id | Identifier (UUID, text) | |
| invitation_id | Identifier (UUID, text) | |
| felder | List (JSON array) of: Text (UTF-8) | |
| meldungen | List (JSON array) of: Text (UTF-8) | |
| hinweise | List (JSON array) of: Text (UTF-8) | |
| einladung_gesendet_am | Timestamp (ISO 8601 with UTC offset) |
Import profiles
Saved column mappings.
JSON: daten/personal/personal_import_profile.json · CSV: daten/personal/personal_import_profile.csv
| Field | Format | Values |
|---|---|---|
| id | Identifier (UUID, text) | |
| system_id | Identifier (UUID, text) | |
| erstellt_von | Identifier (UUID, text) | |
| art | Text (UTF-8) | |
| name | Text (UTF-8) | |
| zuordnung | JSON (object or list; JSON text in CSV) | |
| werte | JSON (object or list; JSON text in CSV) | |
| aktualisiert_am | Timestamp (ISO 8601 with UTC offset) |
Birthday consents
Consents to show the birthday in the team.
JSON: daten/personal/geburtstag_freigaben.json · CSV: daten/personal/geburtstag_freigaben.csv
| Field | Format | Values |
|---|---|---|
| user_id | Identifier (UUID, text) | |
| system_id | Identifier (UUID, text) | |
| erteilt_am | Timestamp (ISO 8601 with UTC offset) |
Anniversary consents
Consents to show the work anniversary in the team.
JSON: daten/personal/jubilaeum_freigaben.json · CSV: daten/personal/jubilaeum_freigaben.csv
| Field | Format | Values |
|---|---|---|
| user_id | Identifier (UUID, text) | |
| system_id | Identifier (UUID, text) | |
| erteilt_am | Timestamp (ISO 8601 with UTC offset) |
Expense categories
Own categories for expenses.
JSON: daten/personal/spesen_kategorien.json · CSV: daten/personal/spesen_kategorien.csv
| Field | Format | Values |
|---|---|---|
| id | Identifier (UUID, text) | |
| system_id | Identifier (UUID, text) | |
| name | Text (UTF-8) | |
| aktiv | Boolean (true/false) | |
| reihenfolge | Integer | |
| geaendert_von | Identifier (UUID, text) | |
| geaendert_am | Timestamp (ISO 8601 with UTC offset) |
Retention holds
Legal holds and extensions.
JSON: daten/personal/aufbewahrungssperren.json · CSV: daten/personal/aufbewahrungssperren.csv
| Field | Format | Values |
|---|---|---|
| id | Identifier (UUID, text) | |
| system_id | Identifier (UUID, text) | |
| location_id | Identifier (UUID, text) | |
| user_id | Identifier (UUID, text) | |
| art | Text (UTF-8) | |
| dokument_id | Identifier (UUID, text) | |
| kategorie | Text (UTF-8) | |
| grund | Text (UTF-8) | |
| bis | Date (ISO 8601, YYYY-MM-DD) | |
| erstellt_von | Identifier (UUID, text) | |
| erstellt_am | Timestamp (ISO 8601 with UTC offset) | |
| aufgehoben_am | Timestamp (ISO 8601 with UTC offset) | |
| aufgehoben_von | Identifier (UUID, text) | |
| aufhebung_grund | Text (UTF-8) | |
| aufhebung_vorgang | Identifier (UUID, text) | |
| gesetzt_durch | Text (UTF-8) |
Equipment
Items such as keys, clothing, devices.
JSON: daten/personal/ausruestung_artikel.json · CSV: daten/personal/ausruestung_artikel.csv
| Field | Format | Values |
|---|---|---|
| id | Identifier (UUID, text) | |
| system_id | Identifier (UUID, text) | |
| location_id | Identifier (UUID, text) | |
| art | Text (UTF-8) | |
| bezeichnung | Text (UTF-8) | |
| inventarnummer | Text (UTF-8) | |
| seriennummer | Text (UTF-8) | |
| wert | Decimal number (dot as decimal separator) | |
| pfand | Decimal number (dot as decimal separator) | |
| aktiv | Boolean (true/false) | |
| created_by | Identifier (UUID, text) | |
| created_at | Timestamp (ISO 8601 with UTC offset) |
Issues
Issued and returned equipment.
JSON: daten/personal/ausruestung_ausgaben.json · CSV: daten/personal/ausruestung_ausgaben.csv
| Field | Format | Values |
|---|---|---|
| id | Identifier (UUID, text) | |
| system_id | Identifier (UUID, text) | |
| location_id | Identifier (UUID, text) | |
| user_id | Identifier (UUID, text) | |
| artikel_id | Identifier (UUID, text) | |
| ausgabe_id | Identifier (UUID, text) | |
| rueckgabe_id | Identifier (UUID, text) | |
| art | Text (UTF-8) | |
| bezeichnung | Text (UTF-8) | |
| inventarnummer | Text (UTF-8) | |
| seriennummer | Text (UTF-8) | |
| einzelstueck | Boolean (true/false) | |
| menge | Integer | |
| groesse | Text (UTF-8) | |
| zustand_ausgabe | Text (UTF-8) | |
| wert | Decimal number (dot as decimal separator) | |
| pfand | Decimal number (dot as decimal separator) | |
| rueckgabe_datum | Date (ISO 8601, YYYY-MM-DD) | |
| zustand_rueckgabe | Text (UTF-8) | |
| pfand_rueck | Text (UTF-8) | |
| vermerk | Text (UTF-8) | |
| storniert_am | Timestamp (ISO 8601 with UTC offset) |
Handovers
Handover records.
JSON: daten/personal/ausruestung_uebergaben.json · CSV: daten/personal/ausruestung_uebergaben.csv
| Field | Format | Values |
|---|---|---|
| id | Identifier (UUID, text) | |
| system_id | Identifier (UUID, text) | |
| location_id | Identifier (UUID, text) | |
| user_id | Identifier (UUID, text) | |
| art | Text (UTF-8) | |
| datum | Date (ISO 8601, YYYY-MM-DD) | |
| notiz | Text (UTF-8) | |
| erfasst_von | Identifier (UUID, text) | |
| erfasst_am | Timestamp (ISO 8601 with UTC offset) | |
| bestaetigt_am | Timestamp (ISO 8601 with UTC offset) | |
| storniert_am | Timestamp (ISO 8601 with UTC offset) | |
| storniert_von | Identifier (UUID, text) | |
| storno_grund | Text (UTF-8) | |
| dokument_id | Identifier (UUID, text) | |
| befehl | Text (UTF-8) |
Pay, payroll and expenses · 18 Files
Pay profiles
Wage and salary data per period.
JSON: daten/lohn/verguetungen.json · CSV: daten/lohn/verguetungen.csv
| Field | Format | Values |
|---|---|---|
| id | Identifier (UUID, text) | |
| system_id | Identifier (UUID, text) | |
| location_id | Identifier (UUID, text) | |
| user_id | Identifier (UUID, text) | |
| gueltig_ab | Date (ISO 8601, YYYY-MM-DD) | |
| gueltig_bis | Date (ISO 8601, YYYY-MM-DD) | |
| verguetungsart | Text (UTF-8) | |
| stundenlohn | Decimal number (dot as decimal separator) | |
| monatsgehalt | Decimal number (dot as decimal separator) | |
| regelstunden_monat | Decimal number (dot as decimal separator) | |
| sfn_zuschlaege | Boolean (true/false) | |
| ueberstunden_zuschlag_prozent | Decimal number (dot as decimal separator) | |
| minijob_grenze_override | Decimal number (dot as decimal separator) | |
| notiz | Text (UTF-8) | |
| created_by | Identifier (UUID, text) | |
| created_at | Timestamp (ISO 8601 with UTC offset) |
Pay review rounds
Pay rounds with selection, monthly budget, effective date, four-eyes approval and status.
JSON: daten/lohn/verguetungsrunden.json · CSV: daten/lohn/verguetungsrunden.csv
| Field | Format | Values |
|---|---|---|
| id | Identifier (UUID, text) | |
| system_id | Identifier (UUID, text) | |
| name | Text (UTF-8) | |
| standorte | List (JSON array) of: Identifier (UUID, text) | |
| taetigkeiten | List (JSON array) of: Text (UTF-8) | |
| stufen | List (JSON array) of: Integer | |
| budget_art | Text (UTF-8) | |
| budget_wert | Decimal number (dot as decimal separator) | |
| gueltig_ab | Date (ISO 8601, YYYY-MM-DD) | |
| vier_augen | Boolean (true/false) | |
| status | Text (UTF-8) | |
| notiz | Text (UTF-8) | |
| erstellt_von | Identifier (UUID, text) | |
| erstellt_am | Timestamp (ISO 8601 with UTC offset) | |
| geaendert_von | Identifier (UUID, text) | |
| geaendert_am | Timestamp (ISO 8601 with UTC offset) | |
| angefragt_von | Identifier (UUID, text) | |
| angefragt_am | Timestamp (ISO 8601 with UTC offset) | |
| freigegeben_von | Identifier (UUID, text) | |
| freigegeben_am | Timestamp (ISO 8601 with UTC offset) | |
| verworfen_von | Identifier (UUID, text) | |
| verworfen_am | Timestamp (ISO 8601 with UTC offset) |
Pay round proposals
Per person previous and proposed pay, rule, comment and result of the update.
JSON: daten/lohn/verguetungsrunde_eintraege.json · CSV: daten/lohn/verguetungsrunde_eintraege.csv
| Field | Format | Values |
|---|---|---|
| id | Identifier (UUID, text) | |
| system_id | Identifier (UUID, text) | |
| runde_id | Identifier (UUID, text) | |
| user_id | Identifier (UUID, text) | |
| location_id | Identifier (UUID, text) | |
| taetigkeit | Text (UTF-8) | |
| stufe | Integer | |
| beschaeftigungsart | Text (UTF-8) | |
| profil_id | Identifier (UUID, text) | |
| verguetungsart | Text (UTF-8) | |
| alt_wert | Decimal number (dot as decimal separator) | |
| stunden_monat | Decimal number (dot as decimal separator) | |
| neu_wert | Decimal number (dot as decimal separator) | |
| regel | Text (UTF-8) | |
| regel_wert | Decimal number (dot as decimal separator) | |
| kommentar | Text (UTF-8) | |
| status | Text (UTF-8) | |
| fehler | Text (UTF-8) | |
| neues_profil_id | Identifier (UUID, text) | |
| uebernommen_am | Timestamp (ISO 8601 with UTC offset) | |
| brief_dokument_id | Identifier (UUID, text) | |
| geaendert_von | Identifier (UUID, text) | |
| geaendert_am | Timestamp (ISO 8601 with UTC offset) |
Pay bands
Minimum and maximum values per level, system-wide or per location.
JSON: daten/lohn/gehaltsbaender.json · CSV: daten/lohn/gehaltsbaender.csv
| Field | Format | Values |
|---|---|---|
| id | Identifier (UUID, text) | |
| system_id | Identifier (UUID, text) | |
| location_id | Identifier (UUID, text) | |
| ebene | Integer | |
| min_stundenlohn | Decimal number (dot as decimal separator) | |
| max_stundenlohn | Decimal number (dot as decimal separator) | |
| min_monatsgehalt | Decimal number (dot as decimal separator) | |
| max_monatsgehalt | Decimal number (dot as decimal separator) | |
| geaendert_von | Identifier (UUID, text) | |
| geaendert_am | Timestamp (ISO 8601 with UTC offset) |
Pay components
Allowances, benefits, deductions.
JSON: daten/lohn/verguetungsbestandteile.json · CSV: daten/lohn/verguetungsbestandteile.csv
| Field | Format | Values |
|---|---|---|
| id | Identifier (UUID, text) | |
| system_id | Identifier (UUID, text) | |
| location_id | Identifier (UUID, text) | |
| user_id | Identifier (UUID, text) | |
| art | Text (UTF-8) | |
| bezeichnung | Text (UTF-8) | |
| rhythmus | Text (UTF-8) | |
| ab_monat | Date (ISO 8601, YYYY-MM-DD) | |
| bis_monat | Date (ISO 8601, YYYY-MM-DD) | |
| betrag | Decimal number (dot as decimal separator) | |
| anzahl | Decimal number (dot as decimal separator) | |
| zuzahlung | Decimal number (dot as decimal separator) | |
| steuerfrei | Boolean (true/false) | |
| vorschuss_id | Identifier (UUID, text) | |
| notiz | Text (UTF-8) | |
| created_by | Identifier (UUID, text) | |
| created_at | Timestamp (ISO 8601 with UTC offset) | |
| beendet_am | Timestamp (ISO 8601 with UTC offset) | |
| beendet_von | Identifier (UUID, text) | |
| storniert_am | Timestamp (ISO 8601 with UTC offset) | |
| storniert_von | Identifier (UUID, text) | |
| storno_grund | Text (UTF-8) |
Advances
Salary advances and instalments.
JSON: daten/lohn/vorschuesse.json · CSV: daten/lohn/vorschuesse.csv
| Field | Format | Values |
|---|---|---|
| id | Identifier (UUID, text) | |
| system_id | Identifier (UUID, text) | |
| location_id | Identifier (UUID, text) | |
| user_id | Identifier (UUID, text) | |
| betrag | Decimal number (dot as decimal separator) | |
| ausgezahlt_am | Date (ISO 8601, YYYY-MM-DD) | |
| auszahlungsweg | Text (UTF-8) | |
| raten | Integer | |
| erste_rate | Date (ISO 8601, YYYY-MM-DD) | |
| notiz | Text (UTF-8) | |
| created_by | Identifier (UUID, text) | |
| created_at | Timestamp (ISO 8601 with UTC offset) | |
| storniert_am | Timestamp (ISO 8601 with UTC offset) | |
| storniert_von | Identifier (UUID, text) | |
| storno_grund | Text (UTF-8) |
Mini-job exception months
Months in which the mini-job limit was exceeded occasionally and unforeseeably.
JSON: daten/lohn/minijob_ausnahmen.json · CSV: daten/lohn/minijob_ausnahmen.csv
| Field | Format | Values |
|---|---|---|
| id | Identifier (UUID, text) | |
| system_id | Identifier (UUID, text) | |
| user_id | Identifier (UUID, text) | |
| monat | Date (ISO 8601, YYYY-MM-DD) | |
| grund | Text (UTF-8) | |
| erfasst_von | Identifier (UUID, text) | |
| erfasst_am | Timestamp (ISO 8601 with UTC offset) |
Payroll periods
Payroll months with review and approval.
JSON: daten/lohn/lohnabschluesse.json · CSV: daten/lohn/lohnabschluesse.csv
| Field | Format | Values |
|---|---|---|
| id | Identifier (UUID, text) | |
| system_id | Identifier (UUID, text) | |
| location_id | Identifier (UUID, text) | |
| monat | Date (ISO 8601, YYYY-MM-DD) | |
| lauf | Integer | |
| status | Text (UTF-8) | |
| korrektur_grund | Text (UTF-8) | |
| offene_korrekturen | Integer | |
| nicht_freigegebene_zeiten | Integer | |
| geprueft_von | Identifier (UUID, text) | |
| geprueft_am | Timestamp (ISO 8601 with UTC offset) | |
| freigegeben_von | Identifier (UUID, text) | |
| freigegeben_am | Timestamp (ISO 8601 with UTC offset) | |
| lines_hash | Text (UTF-8) | |
| created_at | Timestamp (ISO 8601 with UTC offset) |
Payroll lines
Wage types per person and month.
JSON: daten/lohn/lohnzeilen.json · CSV: daten/lohn/lohnzeilen.csv
| Field | Format | Values |
|---|---|---|
| id | Identifier (UUID, text) | |
| period_id | Identifier (UUID, text) | |
| system_id | Identifier (UUID, text) | |
| location_id | Identifier (UUID, text) | |
| user_id | Identifier (UUID, text) | |
| personalnummer | Text (UTF-8) | |
| lohnart_key | Text (UTF-8) | |
| bezeichnung | Text (UTF-8) | |
| menge | Decimal number (dot as decimal separator) | |
| einheit | Text (UTF-8) | |
| satz | Decimal number (dot as decimal separator) | |
| betrag | Decimal number (dot as decimal separator) | |
| steuerfrei | Boolean (true/false) | |
| hinweis | Text (UTF-8) |
Payroll exports
Generated DATEV files (content as text).
JSON: daten/lohn/lohnexporte.json · CSV: daten/lohn/lohnexporte.csv
| Field | Format | Values |
|---|---|---|
| id | Identifier (UUID, text) | |
| period_id | Identifier (UUID, text) | |
| system_id | Identifier (UUID, text) | |
| location_id | Identifier (UUID, text) | |
| variante | Text (UTF-8) | |
| test | Boolean (true/false) | |
| dateiname | Text (UTF-8) | |
| inhalt | Text (UTF-8) | |
| sha256 | Text (UTF-8) | |
| zeilen | Integer | |
| erstellt_von | Identifier (UUID, text) | |
| erstellt_am | Timestamp (ISO 8601 with UTC offset) | |
| abgeholt_am | Timestamp (ISO 8601 with UTC offset) |
Wage type mapping
Mapping to DATEV wage types.
JSON: daten/lohn/lohnarten.json · CSV: daten/lohn/lohnarten.csv
| Field | Format | Values |
|---|---|---|
| location_id | Identifier (UUID, text) | |
| system_id | Identifier (UUID, text) | |
| lohnart_key | Text (UTF-8) | |
| lohnart | Text (UTF-8) |
DATEV settings
Consultant and client numbers per location.
JSON: daten/lohn/datev_einstellungen.json · CSV: daten/lohn/datev_einstellungen.csv
| Field | Format | Values |
|---|---|---|
| location_id | Identifier (UUID, text) | |
| system_id | Identifier (UUID, text) | |
| variante | Text (UTF-8) | |
| beraternummer | Text (UTF-8) | |
| mandantennummer | Text (UTF-8) | |
| personalnummer_quelle | Text (UTF-8) | |
| geaendert_von | Identifier (UUID, text) | |
| geaendert_am | Timestamp (ISO 8601 with UTC offset) |
Payroll documents
Documents from the tax office; files under dateien/dokumente/.
JSON: daten/lohn/gehaltsunterlagen.json · CSV: daten/lohn/gehaltsunterlagen.csv
| Field | Format | Values |
|---|---|---|
| id | Identifier (UUID, text) | |
| system_id | Identifier (UUID, text) | |
| location_id | Identifier (UUID, text) | |
| quelle | Text (UTF-8) | |
| upload_link_id | Identifier (UUID, text) | |
| dateiname | Text (UTF-8) | |
| datei_pfad | Text (UTF-8) | |
| groesse | Integer | |
| seiten | Integer | |
| herkunft_id | Identifier (UUID, text) | |
| herkunft_seiten | Text (UTF-8) | |
| personen_text | Text (UTF-8) | |
| user_id | Identifier (UUID, text) | |
| art | Text (UTF-8) | |
| jahr | Integer | |
| monat | Integer | |
| sicherheit | Text (UTF-8) | |
| hinweis | Text (UTF-8) | |
| status | Text (UTF-8) | |
| document_id | Identifier (UUID, text) | |
| ziel_pfad | Text (UTF-8) | |
| revision | Integer | |
| ersetzt_durch | Identifier (UUID, text) | |
| veroeffentlicht_am | Timestamp (ISO 8601 with UTC offset) | |
| veroeffentlicht_von | Identifier (UUID, text) | |
| erstellt_von | Identifier (UUID, text) | |
| erstellt_am | Timestamp (ISO 8601 with UTC offset) | |
| geaendert_am | Timestamp (ISO 8601 with UTC offset) |
Upload links
Links for the tax office (without access code).
JSON: daten/lohn/upload_links.json · CSV: daten/lohn/upload_links.csv
| Field | Format | Values |
|---|---|---|
| id | Identifier (UUID, text) | |
| system_id | Identifier (UUID, text) | |
| location_id | Identifier (UUID, text) | |
| bezeichnung | Text (UTF-8) | |
| gueltig_bis | Timestamp (ISO 8601 with UTC offset) | |
| max_dateien | Integer | |
| dateien | Integer | |
| letzter_upload | Timestamp (ISO 8601 with UTC offset) | |
| erstellt_von | Identifier (UUID, text) | |
| erstellt_am | Timestamp (ISO 8601 with UTC offset) | |
| widerrufen_am | Timestamp (ISO 8601 with UTC offset) |
Tax office links
Download links of payroll exports (without access code).
JSON: daten/lohn/steuerbuero_links.json · CSV: daten/lohn/steuerbuero_links.csv
| Field | Format | Values |
|---|---|---|
| id | Identifier (UUID, text) | |
| export_id | Identifier (UUID, text) | |
| system_id | Identifier (UUID, text) | |
| location_id | Identifier (UUID, text) | |
| gueltig_bis | Timestamp (ISO 8601 with UTC offset) | |
| erstellt_von | Identifier (UUID, text) | |
| erstellt_am | Timestamp (ISO 8601 with UTC offset) | |
| widerrufen_am | Timestamp (ISO 8601 with UTC offset) | |
| abrufe | Integer | |
| letzter_abruf | Timestamp (ISO 8601 with UTC offset) |
Expenses
Submitted expenses; receipts under dateien/dokumente/.
JSON: daten/lohn/auslagen.json · CSV: daten/lohn/auslagen.csv
| Field | Format | Values |
|---|---|---|
| id | Identifier (UUID, text) | |
| system_id | Identifier (UUID, text) | |
| location_id | Identifier (UUID, text) | |
| user_id | Identifier (UUID, text) | |
| kategorie | Text (UTF-8) | |
| datum | Date (ISO 8601, YYYY-MM-DD) | |
| betrag | Decimal number (dot as decimal separator) | |
| km | Decimal number (dot as decimal separator) | |
| km_satz | Decimal number (dot as decimal separator) | |
| strecke | Text (UTF-8) | |
| mwst_satz | Decimal number (dot as decimal separator) | |
| notiz | Text (UTF-8) | |
| beleg_pfad | Text (UTF-8) | |
| status | Text (UTF-8) | |
| revision | Integer | |
| eingereicht_am | Timestamp (ISO 8601 with UTC offset) | |
| entschieden_von | Identifier (UUID, text) | |
| entschieden_am | Timestamp (ISO 8601 with UTC offset) | |
| entscheidung_grund | Text (UTF-8) | |
| beleg_jahr | Integer | |
| beleg_nr | Integer | |
| erstattung_art | Text (UTF-8) | |
| erstattung_datum | Date (ISO 8601, YYYY-MM-DD) | |
| erstattung_monat | Date (ISO 8601, YYYY-MM-DD) | |
| erstattet_von | Identifier (UUID, text) | |
| erstattet_am | Timestamp (ISO 8601 with UTC offset) | |
| aktualisiert_am | Timestamp (ISO 8601 with UTC offset) |
Expense history
Status changes of expenses.
JSON: daten/lohn/auslagen_verlauf.json · CSV: daten/lohn/auslagen_verlauf.csv
| Field | Format | Values |
|---|---|---|
| id | Integer | |
| spesen_id | Identifier (UUID, text) | |
| system_id | Identifier (UUID, text) | |
| zeit | Timestamp (ISO 8601 with UTC offset) | |
| akteur | Identifier (UUID, text) | |
| ereignis | Text (UTF-8) | |
| grund | Text (UTF-8) |
Expense settings
Limits and accounts per location.
JSON: daten/lohn/auslagen_einstellungen.json · CSV: daten/lohn/auslagen_einstellungen.csv
| Field | Format | Values |
|---|---|---|
| location_id | Identifier (UUID, text) | |
| system_id | Identifier (UUID, text) | |
| schichtleitung_grenze | Decimal number (dot as decimal separator) | |
| konten | JSON (object or list; JSON text in CSV) | |
| geaendert_von | Identifier (UUID, text) | |
| geaendert_am | Timestamp (ISO 8601 with UTC offset) |
Staff development and surveys · 22 Files
Settings
Reminders and deadlines for reviews.
JSON: daten/entwicklung/einstellungen.json · CSV: daten/entwicklung/einstellungen.csv
| Field | Format | Values |
|---|---|---|
| system_id | Identifier (UUID, text) | |
| jahresgespraech_erinnerung | Boolean (true/false) | |
| probezeit_vorlauf_tage | Integer | |
| jahresgespraech_vorlauf_tage | Integer | |
| geaendert_am | Timestamp (ISO 8601 with UTC offset) | |
| geaendert_von | Identifier (UUID, text) | |
| jahresgespraech_stichtag | Date (ISO 8601, YYYY-MM-DD) | |
| kollegenfeedback | Boolean (true/false) |
Location approvals
Reviews by shift leads per location.
JSON: daten/entwicklung/standort_freigaben.json · CSV: daten/entwicklung/standort_freigaben.csv
| Field | Format | Values |
|---|---|---|
| location_id | Identifier (UUID, text) | |
| system_id | Identifier (UUID, text) | |
| schichtleitung_gespraeche | Boolean (true/false) | |
| geaendert_am | Timestamp (ISO 8601 with UTC offset) | |
| geaendert_von | Identifier (UUID, text) |
Review templates
Questions and sections.
JSON: daten/entwicklung/vorlagen.json · CSV: daten/entwicklung/vorlagen.csv
| Field | Format | Values |
|---|---|---|
| id | Identifier (UUID, text) | |
| system_id | Identifier (UUID, text) | |
| location_id | Identifier (UUID, text) | |
| art | Text (UTF-8) | |
| titel | Text (UTF-8) | |
| beschreibung | Text (UTF-8) | |
| abschnitte | JSON (object or list; JSON text in CSV) | |
| selbsteinschaetzung | Boolean (true/false) | |
| aktiv | Boolean (true/false) | |
| erstellt_von | Identifier (UUID, text) | |
| created_at | Timestamp (ISO 8601 with UTC offset) | |
| updated_at | Timestamp (ISO 8601 with UTC offset) |
Reviews
Employee reviews.
JSON: daten/entwicklung/gespraeche.json · CSV: daten/entwicklung/gespraeche.csv
| Field | Format | Values |
|---|---|---|
| id | Identifier (UUID, text) | |
| system_id | Identifier (UUID, text) | |
| location_id | Identifier (UUID, text) | |
| user_id | Identifier (UUID, text) | |
| fuehrung_id | Identifier (UUID, text) | |
| vorlage_id | Identifier (UUID, text) | |
| art | Text (UTF-8) | |
| titel | Text (UTF-8) | |
| termin | Timestamp (ISO 8601 with UTC offset) | |
| ort | Text (UTF-8) | |
| fragen | JSON (object or list; JSON text in CSV) | |
| selbsteinschaetzung | Boolean (true/false) | |
| status | Text (UTF-8) | |
| abgeschlossen_am | Timestamp (ISO 8601 with UTC offset) | |
| abgeschlossen_von | Identifier (UUID, text) | |
| kenntnis_am | Timestamp (ISO 8601 with UTC offset) | |
| person_kommentar | Text (UTF-8) | |
| created_at | Timestamp (ISO 8601 with UTC offset) | |
| updated_at | Timestamp (ISO 8601 with UTC offset) | |
| zyklus_id | Identifier (UUID, text) |
Review answers
Answers per side.
JSON: daten/entwicklung/antworten.json · CSV: daten/entwicklung/antworten.csv
| Field | Format | Values |
|---|---|---|
| gespraech_id | Identifier (UUID, text) | |
| system_id | Identifier (UUID, text) | |
| seite | Text (UTF-8) | |
| antworten | JSON (object or list; JSON text in CSV) | |
| zusammenfassung | Text (UTF-8) | |
| abgegeben_am | Timestamp (ISO 8601 with UTC offset) | |
| geaendert_am | Timestamp (ISO 8601 with UTC offset) | |
| geaendert_von | Identifier (UUID, text) | |
| revision | Integer |
Addenda
Additions after completion.
JSON: daten/entwicklung/nachtraege.json · CSV: daten/entwicklung/nachtraege.csv
| Field | Format | Values |
|---|---|---|
| id | Identifier (UUID, text) | |
| system_id | Identifier (UUID, text) | |
| gespraech_id | Identifier (UUID, text) | |
| autor_id | Identifier (UUID, text) | |
| seite | Text (UTF-8) | |
| text | Text (UTF-8) | |
| created_at | Timestamp (ISO 8601 with UTC offset) |
Own notes
Private notes (visible to the author only).
JSON: daten/entwicklung/notizen.json · CSV: daten/entwicklung/notizen.csv
| Field | Format | Values |
|---|---|---|
| gespraech_id | Identifier (UUID, text) | |
| autor_id | Identifier (UUID, text) | |
| system_id | Identifier (UUID, text) | |
| text | Text (UTF-8) | |
| geaendert_am | Timestamp (ISO 8601 with UTC offset) |
Goals
Agreed goals with progress.
JSON: daten/entwicklung/ziele.json · CSV: daten/entwicklung/ziele.csv
| Field | Format | Values |
|---|---|---|
| id | Identifier (UUID, text) | |
| system_id | Identifier (UUID, text) | |
| location_id | Identifier (UUID, text) | |
| user_id | Identifier (UUID, text) | |
| gespraech_id | Identifier (UUID, text) | |
| titel | Text (UTF-8) | |
| beschreibung | Text (UTF-8) | |
| frist | Date (ISO 8601, YYYY-MM-DD) | |
| fortschritt | Integer | |
| status | Text (UTF-8) | |
| erledigt_am | Timestamp (ISO 8601 with UTC offset) | |
| kurs_id | Identifier (UUID, text) | |
| erstellt_von | Identifier (UUID, text) | |
| created_at | Timestamp (ISO 8601 with UTC offset) | |
| updated_at | Timestamp (ISO 8601 with UTC offset) | |
| eltern_id | Identifier (UUID, text) | |
| gewicht | Integer | |
| messart | Text (UTF-8) | |
| startwert | Decimal number (dot as decimal separator) | |
| zielwert | Decimal number (dot as decimal separator) | |
| istwert | Decimal number (dot as decimal separator) | |
| einheit | Text (UTF-8) | |
| einschaetzung | Text (UTF-8) | |
| gemeldet_am | Timestamp (ISO 8601 with UTC offset) |
Goal comments
Comments on goals.
JSON: daten/entwicklung/ziel_kommentare.json · CSV: daten/entwicklung/ziel_kommentare.csv
| Field | Format | Values |
|---|---|---|
| id | Identifier (UUID, text) | |
| system_id | Identifier (UUID, text) | |
| ziel_id | Identifier (UUID, text) | |
| autor_id | Identifier (UUID, text) | |
| text | Text (UTF-8) | |
| created_at | Timestamp (ISO 8601 with UTC offset) |
Feedback
Praise and notes.
JSON: daten/entwicklung/feedback.json · CSV: daten/entwicklung/feedback.csv
| Field | Format | Values |
|---|---|---|
| id | Identifier (UUID, text) | |
| system_id | Identifier (UUID, text) | |
| location_id | Identifier (UUID, text) | |
| user_id | Identifier (UUID, text) | |
| von_id | Identifier (UUID, text) | |
| art | Text (UTF-8) | |
| text | Text (UTF-8) | |
| created_at | Timestamp (ISO 8601 with UTC offset) |
Progress updates
History of goal progress with rating.
JSON: daten/entwicklung/ziel_meldungen.json · CSV: daten/entwicklung/ziel_meldungen.csv
| Field | Format | Values |
|---|---|---|
| id | Identifier (UUID, text) | |
| system_id | Identifier (UUID, text) | |
| ziel_id | Identifier (UUID, text) | |
| autor_id | Identifier (UUID, text) | |
| fortschritt | Integer | |
| istwert | Decimal number (dot as decimal separator) | |
| erledigt | Boolean (true/false) | |
| einschaetzung | Text (UTF-8) | |
| notiz | Text (UTF-8) | |
| messart | Text (UTF-8) | |
| startwert | Decimal number (dot as decimal separator) | |
| zielwert | Decimal number (dot as decimal separator) | |
| einheit | Text (UTF-8) | |
| created_at | Timestamp (ISO 8601 with UTC offset) |
Requests
Development requests and decisions.
JSON: daten/entwicklung/anfragen.json · CSV: daten/entwicklung/anfragen.csv
| Field | Format | Values |
|---|---|---|
| id | Identifier (UUID, text) | |
| system_id | Identifier (UUID, text) | |
| location_id | Identifier (UUID, text) | |
| user_id | Identifier (UUID, text) | |
| art | Text (UTF-8) | |
| titel | Text (UTF-8) | |
| text | Text (UTF-8) | |
| wunsch_frist | Date (ISO 8601, YYYY-MM-DD) | |
| kurs_id | Identifier (UUID, text) | |
| gespraech_art | Text (UTF-8) | |
| status | Text (UTF-8) | |
| antwort | Text (UTF-8) | |
| entschieden_von | Identifier (UUID, text) | |
| entschieden_am | Timestamp (ISO 8601 with UTC offset) | |
| ziel_id | Identifier (UUID, text) | |
| gespraech_id | Identifier (UUID, text) | |
| created_at | Timestamp (ISO 8601 with UTC offset) | |
| updated_at | Timestamp (ISO 8601 with UTC offset) |
Review cycles
Cycles with template, deadline and selection.
JSON: daten/entwicklung/zyklen.json · CSV: daten/entwicklung/zyklen.csv
| Field | Format | Values |
|---|---|---|
| id | Identifier (UUID, text) | |
| system_id | Identifier (UUID, text) | |
| titel | Text (UTF-8) | |
| art | Text (UTF-8) | |
| vorlage_id | Identifier (UUID, text) | |
| fragen | JSON (object or list; JSON text in CSV) | |
| selbsteinschaetzung | Boolean (true/false) | |
| frist | Date (ISO 8601, YYYY-MM-DD) | |
| erinnerung_tage | Integer | |
| standorte | List (JSON array) of: Identifier (UUID, text) | |
| taetigkeit | Text (UTF-8) | |
| von_zentrale | Boolean (true/false) | |
| erstellt_von | Identifier (UUID, text) | |
| created_at | Timestamp (ISO 8601 with UTC offset) | |
| beendet_am | Timestamp (ISO 8601 with UTC offset) | |
| beendet_von | Identifier (UUID, text) | |
| kollegen_feedback | Boolean (true/false) | |
| fuehrung_feedback | Boolean (true/false) |
Team goal members
Who works on which team goal.
JSON: daten/entwicklung/ziel_personen.json · CSV: daten/entwicklung/ziel_personen.csv
| Field | Format | Values |
|---|---|---|
| id | Identifier (UUID, text) | |
| ziel_id | Identifier (UUID, text) | |
| user_id | Identifier (UUID, text) | |
| system_id | Identifier (UUID, text) | |
| created_at | Timestamp (ISO 8601 with UTC offset) |
Feedback in review cycles
Feedback from colleagues on a review and feedback for the manager, as far as visible.
JSON: daten/entwicklung/rundenfeedback.json · CSV: daten/entwicklung/rundenfeedback.csv
| Field | Format | Values |
|---|---|---|
| id | Identifier (UUID, text) | |
| system_id | Identifier (UUID, text) | |
| zyklus_id | Identifier (UUID, text) | |
| gespraech_id | Identifier (UUID, text) | |
| location_id | Identifier (UUID, text) | |
| art | Text (UTF-8) | |
| von_id | Identifier (UUID, text) | |
| ueber_id | Identifier (UUID, text) | |
| angefragt_von | Identifier (UUID, text) | |
| wert | Integer | |
| text | Text (UTF-8) | |
| angefragt_am | Timestamp (ISO 8601 with UTC offset) | |
| abgegeben_am | Timestamp (ISO 8601 with UTC offset) |
Feedback between colleagues
Praise and notes with sender, as far as visible.
JSON: daten/entwicklung/kollegenfeedback.json · CSV: daten/entwicklung/kollegenfeedback.csv
| Field | Format | Values |
|---|---|---|
| id | Identifier (UUID, text) | |
| system_id | Identifier (UUID, text) | |
| location_id | Identifier (UUID, text) | |
| von_id | Identifier (UUID, text) | |
| an_id | Identifier (UUID, text) | |
| art | Text (UTF-8) | |
| text | Text (UTF-8) | |
| created_at | Timestamp (ISO 8601 with UTC offset) | |
| geteilt_am | Timestamp (ISO 8601 with UTC offset) | |
| gemeldet_am | Timestamp (ISO 8601 with UTC offset) | |
| meldung_grund | Text (UTF-8) | |
| ausgeblendet_am | Timestamp (ISO 8601 with UTC offset) | |
| ausgeblendet_von | Identifier (UUID, text) | |
| ausblend_grund | Text (UTF-8) |
Surveys
Staff surveys.
JSON: daten/entwicklung/befragungen.json · CSV: daten/entwicklung/befragungen.csv
| Field | Format | Values |
|---|---|---|
| id | Identifier (UUID, text) | |
| system_id | Identifier (UUID, text) | |
| bereich | Text (UTF-8) | |
| erstellt_von | Identifier (UUID, text) | |
| titel | Text (UTF-8) | |
| einleitung | Text (UTF-8) | |
| vorlage | Text (UTF-8) | |
| anonym | Boolean (true/false) | |
| mindestgruppe | Integer | |
| zielrollen | List (JSON array) of: Enumerated value (text, see values) | zentrale, multi_unit_partner, partner, schichtleitung, mitarbeiter |
| standorte | List (JSON array) of: Identifier (UUID, text) | |
| art | Text (UTF-8) | |
| rhythmus | Text (UTF-8) | |
| laufzeit_tage | Integer | |
| beginn | Date (ISO 8601, YYYY-MM-DD) | |
| ende | Date (ISO 8601, YYYY-MM-DD) | |
| beendet_am | Timestamp (ISO 8601 with UTC offset) | |
| created_at | Timestamp (ISO 8601 with UTC offset) | |
| netzweit | Boolean (true/false) |
Survey runs
Runs of the surveys.
JSON: daten/entwicklung/befragung_durchgaenge.json · CSV: daten/entwicklung/befragung_durchgaenge.csv
| Field | Format | Values |
|---|---|---|
| id | Identifier (UUID, text) | |
| survey_id | Identifier (UUID, text) | |
| system_id | Identifier (UUID, text) | |
| nummer | Integer | |
| beginn | Date (ISO 8601, YYYY-MM-DD) | |
| ende | Date (ISO 8601, YYYY-MM-DD) | |
| gestartet_am | Timestamp (ISO 8601 with UTC offset) | |
| created_at | Timestamp (ISO 8601 with UTC offset) |
Questions
Survey questions.
JSON: daten/entwicklung/befragung_fragen.json · CSV: daten/entwicklung/befragung_fragen.csv
| Field | Format | Values |
|---|---|---|
| id | Identifier (UUID, text) | |
| survey_id | Identifier (UUID, text) | |
| system_id | Identifier (UUID, text) | |
| position | Integer | |
| typ | Text (UTF-8) | |
| text | Text (UTF-8) | |
| optionen | List (JSON array) of: Text (UTF-8) | |
| pflicht | Boolean (true/false) |
Participation
Invitations and participation.
JSON: daten/entwicklung/befragung_teilnahmen.json · CSV: daten/entwicklung/befragung_teilnahmen.csv
| Field | Format | Values |
|---|---|---|
| run_id | Identifier (UUID, text) | |
| survey_id | Identifier (UUID, text) | |
| system_id | Identifier (UUID, text) | |
| user_id | Identifier (UUID, text) | |
| location_id | Identifier (UUID, text) | |
| eingeladen_am | Timestamp (ISO 8601 with UTC offset) | |
| frist | Date (ISO 8601, YYYY-MM-DD) | |
| teilgenommen_am | Timestamp (ISO 8601 with UTC offset) | |
| erinnert_am | Timestamp (ISO 8601 with UTC offset) | |
| anlass | Text (UTF-8) | |
| anlass_datum | Date (ISO 8601, YYYY-MM-DD) | |
| abgelehnt_am | Timestamp (ISO 8601 with UTC offset) |
Responses
Submitted responses (anonymous ones without person).
JSON: daten/entwicklung/befragung_abgaben.json · CSV: daten/entwicklung/befragung_abgaben.csv
| Field | Format | Values |
|---|---|---|
| id | Identifier (UUID, text) | |
| survey_id | Identifier (UUID, text) | |
| run_id | Identifier (UUID, text) | |
| system_id | Identifier (UUID, text) | |
| location_id | Identifier (UUID, text) | |
| user_id | Identifier (UUID, text) | |
| rolle | Enumerated value (text, see values) | zentrale, multi_unit_partner, partner, schichtleitung, mitarbeiter |
| abgegeben_am | Timestamp (ISO 8601 with UTC offset) |
Answers
Answers per question, as far as visible.
JSON: daten/entwicklung/befragung_antworten.json · CSV: daten/entwicklung/befragung_antworten.csv
| Field | Format | Values |
|---|---|---|
| response_id | Identifier (UUID, text) | |
| question_id | Identifier (UUID, text) | |
| system_id | Identifier (UUID, text) | |
| wert | Integer | |
| auswahl | List (JSON array) of: Integer | |
| text | Text (UTF-8) |
Recruiting · 9 Files
Job postings
Job advertisements.
JSON: daten/recruiting/stellen.json · CSV: daten/recruiting/stellen.csv
| Field | Format | Values |
|---|---|---|
| id | Identifier (UUID, text) | |
| system_id | Identifier (UUID, text) | |
| location_id | Identifier (UUID, text) | |
| vorlage | Boolean (true/false) | |
| vorlage_id | Identifier (UUID, text) | |
| code | Text (UTF-8) | |
| titel | Text (UTF-8) | |
| beschaeftigungsart | Text (UTF-8) | |
| beschreibung | Text (UTF-8) | |
| anforderungen | Text (UTF-8) | |
| start_datum | Date (ISO 8601, YYYY-MM-DD) | |
| verguetung_betrag | Decimal number (dot as decimal separator) | |
| verguetung_einheit | Text (UTF-8) | |
| status | Text (UTF-8) | |
| verantwortliche | List (JSON array) of: Identifier (UUID, text) | |
| veroeffentlicht_am | Timestamp (ISO 8601 with UTC offset) | |
| erstellt_von | Identifier (UUID, text) | |
| created_at | Timestamp (ISO 8601 with UTC offset) | |
| updated_at | Timestamp (ISO 8601 with UTC offset) | |
| vorsortieren_absage | Boolean (true/false) | |
| stellenplan_id | Identifier (UUID, text) |
Applications
Applications with consent; CVs under dateien/dokumente/.
JSON: daten/recruiting/bewerbungen.json · CSV: daten/recruiting/bewerbungen.csv
| Field | Format | Values |
|---|---|---|
| id | Identifier (UUID, text) | |
| system_id | Identifier (UUID, text) | |
| stelle_id | Identifier (UUID, text) | |
| location_id | Identifier (UUID, text) | |
| name | Text (UTF-8) | |
| Text (UTF-8) | ||
| telefon | Text (UTF-8) | |
| tage | List (JSON array) of: Text (UTF-8) | |
| zeiten | List (JSON array) of: Text (UTF-8) | |
| startdatum | Date (ISO 8601, YYYY-MM-DD) | |
| deutsch | Text (UTF-8) | |
| nachricht | Text (UTF-8) | |
| lebenslauf_pfad | Text (UTF-8) | |
| lebenslauf_name | Text (UTF-8) | |
| lebenslauf_sha256 | Text (UTF-8) | |
| einwilligung_text | Text (UTF-8) | |
| einwilligung_am | Timestamp (ISO 8601 with UTC offset) | |
| talentpool | Boolean (true/false) | |
| talentpool_text | Text (UTF-8) | |
| talentpool_am | Timestamp (ISO 8601 with UTC offset) | |
| quelle | Text (UTF-8) | |
| kanal | Text (UTF-8) | |
| sprache | Text (UTF-8) | |
| phase | Text (UTF-8) | |
| bewertung | Integer | |
| gespraech_am | Timestamp (ISO 8601 with UTC offset) | |
| probearbeit_am | Timestamp (ISO 8601 with UTC offset) | |
| abgeschlossen_am | Timestamp (ISO 8601 with UTC offset) | |
| einladung_id | Identifier (UUID, text) | |
| eingang_bestaetigt_am | Timestamp (ISO 8601 with UTC offset) | |
| anonymisiert_am | Timestamp (ISO 8601 with UTC offset) | |
| created_at | Timestamp (ISO 8601 with UTC offset) | |
| updated_at | Timestamp (ISO 8601 with UTC offset) | |
| zwischenphase_id | Identifier (UUID, text) | |
| empfohlen_von | Identifier (UUID, text) | |
| vorsortierung | Text (UTF-8) | |
| vorsortierung_am | Timestamp (ISO 8601 with UTC offset) | |
| absage_vorgeschlagen | Boolean (true/false) |
Application history
Stages and notes.
JSON: daten/recruiting/bewerbung_verlauf.json · CSV: daten/recruiting/bewerbung_verlauf.csv
| Field | Format | Values |
|---|---|---|
| id | Identifier (UUID, text) | |
| system_id | Identifier (UUID, text) | |
| bewerbung_id | Identifier (UUID, text) | |
| art | Text (UTF-8) | |
| von | Text (UTF-8) | |
| nach | Text (UTF-8) | |
| text | Text (UTF-8) | |
| autor | Identifier (UUID, text) | |
| created_at | Timestamp (ISO 8601 with UTC offset) | |
| von_zwischenphase | Text (UTF-8) | |
| nach_zwischenphase | Text (UTF-8) |
Email templates
Own texts for emails to applicants per location or system-wide.
JSON: daten/recruiting/recruiting_mailvorlagen.json · CSV: daten/recruiting/recruiting_mailvorlagen.csv
| Field | Format | Values |
|---|---|---|
| id | Identifier (UUID, text) | |
| system_id | Identifier (UUID, text) | |
| location_id | Identifier (UUID, text) | |
| art | Text (UTF-8) | |
| sprache | Text (UTF-8) | |
| betreff | Text (UTF-8) | |
| text | Text (UTF-8) | |
| geaendert_von | Identifier (UUID, text) | |
| geaendert_am | Timestamp (ISO 8601 with UTC offset) |
Own stages
Intermediate stages with a fixed base stage, system-wide or per job.
JSON: daten/recruiting/recruiting_phasen.json · CSV: daten/recruiting/recruiting_phasen.csv
| Field | Format | Values |
|---|---|---|
| id | Identifier (UUID, text) | |
| system_id | Identifier (UUID, text) | |
| stelle_id | Identifier (UUID, text) | |
| name | Text (UTF-8) | |
| grundphase | Text (UTF-8) | |
| reihenfolge | Integer | |
| aktiv | Boolean (true/false) | |
| geaendert_von | Identifier (UUID, text) | |
| geaendert_am | Timestamp (ISO 8601 with UTC offset) | |
| created_at | Timestamp (ISO 8601 with UTC offset) |
Scorecard criteria
Scorecard criteria, system-wide or per job.
JSON: daten/recruiting/recruiting_kriterien.json · CSV: daten/recruiting/recruiting_kriterien.csv
| Field | Format | Values |
|---|---|---|
| id | Identifier (UUID, text) | |
| system_id | Identifier (UUID, text) | |
| stelle_id | Identifier (UUID, text) | |
| name | Text (UTF-8) | |
| beschreibung | Text (UTF-8) | |
| reihenfolge | Integer | |
| aktiv | Boolean (true/false) | |
| geaendert_von | Identifier (UUID, text) | |
| geaendert_am | Timestamp (ISO 8601 with UTC offset) | |
| created_at | Timestamp (ISO 8601 with UTC offset) |
Scorecards
Scores (1–5) and comments per application, criterion and rater.
JSON: daten/recruiting/bewerbung_bewertungen.json · CSV: daten/recruiting/bewerbung_bewertungen.csv
| Field | Format | Values |
|---|---|---|
| id | Identifier (UUID, text) | |
| system_id | Identifier (UUID, text) | |
| bewerbung_id | Identifier (UUID, text) | |
| kriterium_id | Identifier (UUID, text) | |
| bewerter | Identifier (UUID, text) | |
| punkte | Integer | |
| kommentar | Text (UTF-8) | |
| created_at | Timestamp (ISO 8601 with UTC offset) | |
| updated_at | Timestamp (ISO 8601 with UTC offset) |
Screening questions
Yes/no questions per job with knock-out, minimum age and reason.
JSON: daten/recruiting/stellen_vorfragen.json · CSV: daten/recruiting/stellen_vorfragen.csv
| Field | Format | Values |
|---|---|---|
| id | Identifier (UUID, text) | |
| system_id | Identifier (UUID, text) | |
| stelle_id | Identifier (UUID, text) | |
| art | Text (UTF-8) | |
| text | Text (UTF-8) | |
| text_en | Text (UTF-8) | |
| ko_bei | Text (UTF-8) | |
| mindestalter | Integer | |
| begruendung | Text (UTF-8) | |
| pflicht | Boolean (true/false) | |
| reihenfolge | Integer | |
| aktiv | Boolean (true/false) | |
| geaendert_von | Identifier (UUID, text) | |
| geaendert_am | Timestamp (ISO 8601 with UTC offset) | |
| created_at | Timestamp (ISO 8601 with UTC offset) |
Screening answers
Answers per application with the question wording and result (fits / does not fit).
JSON: daten/recruiting/bewerbung_vorfragen.json · CSV: daten/recruiting/bewerbung_vorfragen.csv
| Field | Format | Values |
|---|---|---|
| id | Identifier (UUID, text) | |
| system_id | Identifier (UUID, text) | |
| bewerbung_id | Identifier (UUID, text) | |
| frage_id | Identifier (UUID, text) | |
| art | Text (UTF-8) | |
| text | Text (UTF-8) | |
| text_en | Text (UTF-8) | |
| mindestalter | Integer | |
| ko_bei | Text (UTF-8) | |
| antwort | Boolean (true/false) | |
| passt | Boolean (true/false) | |
| created_at | Timestamp (ISO 8601 with UTC offset) |
Partner files, contracts, P&L and revenue · 10 Files
Partner files
Company, bank and fee data per location.
JSON: daten/partner/partnerakten.json · CSV: daten/partner/partnerakten.csv
| Field | Format | Values |
|---|---|---|
| location_id | Identifier (UUID, text) | |
| system_id | Identifier (UUID, text) | |
| firma | Text (UTF-8) | |
| rechtsform | Text (UTF-8) | |
| handelsregister | Text (UTF-8) | |
| steuernummer | Text (UTF-8) | |
| ust_id | Text (UTF-8) | |
| iban | Text (UTF-8) | |
| bic | Text (UTF-8) | |
| bank | Text (UTF-8) | |
| ansprech_name | Text (UTF-8) | |
| ansprech_telefon | Text (UTF-8) | |
| ansprech_email | Text (UTF-8) | |
| vertrag_beginn | Date (ISO 8601, YYYY-MM-DD) | |
| vertrag_ende | Date (ISO 8601, YYYY-MM-DD) | |
| kuendigungsfrist_monate | Integer | |
| gebiet | Text (UTF-8) | |
| notiz | Text (UTF-8) | |
| aktualisiert_am | Timestamp (ISO 8601 with UTC offset) | |
| aktualisiert_von | Identifier (UUID, text) | |
| gebuehr_prozent | Decimal number (dot as decimal separator) | |
| marketing_prozent | Decimal number (dot as decimal separator) | |
| gebuehr_fix | Decimal number (dot as decimal separator) | |
| gebuehr_mindest | Decimal number (dot as decimal separator) | |
| gebuehren_ab | Date (ISO 8601, YYYY-MM-DD) | |
| gebuehren_notiz | Text (UTF-8) |
Contracts
Franchise and lease contracts with deadlines.
JSON: daten/partner/vertraege.json · CSV: daten/partner/vertraege.csv
| Field | Format | Values |
|---|---|---|
| id | Identifier (UUID, text) | |
| system_id | Identifier (UUID, text) | |
| location_id | Identifier (UUID, text) | |
| art | Enumerated value (text, see values) | franchisevertrag, nachtrag, gebietsschutz, mietvertrag, sonstiges |
| titel | Text (UTF-8) | |
| status | Enumerated value (text, see values) | entwurf, aktiv, gekuendigt, ausgelaufen, verlaengert |
| beginn | Date (ISO 8601, YYYY-MM-DD) | |
| ende | Date (ISO 8601, YYYY-MM-DD) | |
| kuendigungsfrist_monate | Integer | |
| verlaengert_automatisch | Boolean (true/false) | |
| verlaengerung_monate | Integer | |
| gebiet | Text (UTF-8) | |
| gehoert_zu | Identifier (UUID, text) | |
| dokument_id | Identifier (UUID, text) | |
| notiz | Text (UTF-8) | |
| created_at | Timestamp (ISO 8601 with UTC offset) | |
| aktualisiert_am | Timestamp (ISO 8601 with UTC offset) | |
| aktualisiert_von | Identifier (UUID, text) | |
| geloescht_am | Timestamp (ISO 8601 with UTC offset) | |
| geloescht_von | Identifier (UUID, text) | |
| geloescht_grund | Text (UTF-8) |
P&L (BWA)
Submitted P&L with key figures; files under dateien/dokumente/.
JSON: daten/partner/bwa.json · CSV: daten/partner/bwa.csv
| Field | Format | Values |
|---|---|---|
| id | Identifier (UUID, text) | |
| system_id | Identifier (UUID, text) | |
| location_id | Identifier (UUID, text) | |
| period | Date (ISO 8601, YYYY-MM-DD) | |
| status | Enumerated value (text, see values) | offen, eingereicht, geprueft |
| file_path | Text (UTF-8) | |
| submitted_by | Identifier (UUID, text) | |
| submitted_at | Timestamp (ISO 8601 with UTC offset) | |
| revenue | Decimal number (dot as decimal separator) | |
| cost_of_goods | Decimal number (dot as decimal separator) | |
| personnel_cost | Decimal number (dot as decimal separator) | |
| gross_profit | Decimal number (dot as decimal separator) | |
| personnel_ratio | Decimal number (dot as decimal separator) | |
| alert | Enumerated value (text, see values) | gruen, gelb, rot |
| notes | Text (UTF-8) | |
| created_at | Timestamp (ISO 8601 with UTC offset) |
P&L values
All recognised or typed lines per submitted P&L (month and year to date) with origin (PDF or by hand).
JSON: daten/partner/bwa_werte.json · CSV: daten/partner/bwa_werte.csv
| Field | Format | Values |
|---|---|---|
| id | Identifier (UUID, text) | |
| system_id | Identifier (UUID, text) | |
| location_id | Identifier (UUID, text) | |
| submission_id | Identifier (UUID, text) | |
| period | Date (ISO 8601, YYYY-MM-DD) | |
| kennzahl | Text (UTF-8) | |
| monat | Decimal number (dot as decimal separator) | |
| kumuliert | Decimal number (dot as decimal separator) | |
| quelle | Text (UTF-8) | |
| erfasst_am | Timestamp (ISO 8601 with UTC offset) |
Key figure limits
Head office limits per key figure, for all locations, one store type or one location, with alert and warning value.
JSON: daten/partner/kennzahl_grenzen.json · CSV: daten/partner/kennzahl_grenzen.csv
| Field | Format | Values |
|---|---|---|
| id | Identifier (UUID, text) | |
| system_id | Identifier (UUID, text) | |
| location_id | Identifier (UUID, text) | |
| kennzahl | Text (UTF-8) | |
| richtung | Text (UTF-8) | |
| alarmwert | Decimal number (dot as decimal separator) | |
| warnwert | Decimal number (dot as decimal separator) | |
| geaendert_von | Identifier (UUID, text) | |
| geaendert_am | Timestamp (ISO 8601 with UTC offset) | |
| standort_typ | Text (UTF-8) |
P&L rules
Early-warning settings: trend months, prior-year and daily-sales thresholds, quartile, reminders, weekly email.
JSON: daten/partner/bwa_regeln.json · CSV: daten/partner/bwa_regeln.csv
| Field | Format | Values |
|---|---|---|
| system_id | Identifier (UUID, text) | |
| serie_monate | Integer | |
| vorjahr_prozent | Decimal number (dot as decimal separator) | |
| quartil | Boolean (true/false) | |
| tagesumsatz_prozent | Decimal number (dot as decimal separator) | |
| erinnern_tage | Integer | |
| eskalation_tage | Integer | |
| wochenmail | Boolean (true/false) | |
| geaendert_von | Identifier (UUID, text) | |
| geaendert_am | Timestamp (ISO 8601 with UTC offset) |
Plan figures
Plan figures per location, month and key figure.
JSON: daten/partner/bwa_planwerte.json · CSV: daten/partner/bwa_planwerte.csv
| Field | Format | Values |
|---|---|---|
| id | Identifier (UUID, text) | |
| system_id | Identifier (UUID, text) | |
| location_id | Identifier (UUID, text) | |
| period | Date (ISO 8601, YYYY-MM-DD) | |
| kennzahl | Text (UTF-8) | |
| wert | Decimal number (dot as decimal separator) | |
| geaendert_von | Identifier (UUID, text) | |
| geaendert_am | Timestamp (ISO 8601 with UTC offset) |
Actions
Actions per location with owner, due date, key figure, starting and target value, status and result.
JSON: daten/partner/standort_massnahmen.json · CSV: daten/partner/standort_massnahmen.csv
| Field | Format | Values |
|---|---|---|
| id | Identifier (UUID, text) | |
| system_id | Identifier (UUID, text) | |
| location_id | Identifier (UUID, text) | |
| titel | Text (UTF-8) | |
| beschreibung | Text (UTF-8) | |
| anlass | Text (UTF-8) | |
| kennzahl | Text (UTF-8) | |
| ausgang_period | Date (ISO 8601, YYYY-MM-DD) | |
| ausgang_wert | Decimal number (dot as decimal separator) | |
| ziel_wert | Decimal number (dot as decimal separator) | |
| verantwortlich | Identifier (UUID, text) | |
| faellig_am | Date (ISO 8601, YYYY-MM-DD) | |
| status | Text (UTF-8) | |
| ergebnis | Text (UTF-8) | |
| erledigt_am | Timestamp (ISO 8601 with UTC offset) | |
| erledigt_von | Identifier (UUID, text) | |
| erstellt_von | Identifier (UUID, text) | |
| erstellt_am | Timestamp (ISO 8601 with UTC offset) |
Key figure alerts
Raised alerts per location, month and key figure with level, value, threshold and resolution.
JSON: daten/partner/kennzahl_alarme.json · CSV: daten/partner/kennzahl_alarme.csv
| Field | Format | Values |
|---|---|---|
| id | Identifier (UUID, text) | |
| system_id | Identifier (UUID, text) | |
| location_id | Identifier (UUID, text) | |
| period | Date (ISO 8601, YYYY-MM-DD) | |
| kennzahl | Text (UTF-8) | |
| stufe | Text (UTF-8) | |
| richtung | Text (UTF-8) | |
| wert | Decimal number (dot as decimal separator) | |
| schwelle | Decimal number (dot as decimal separator) | |
| ausgeloest_am | Timestamp (ISO 8601 with UTC offset) | |
| geprueft_am | Timestamp (ISO 8601 with UTC offset) | |
| gemeldet_am | Timestamp (ISO 8601 with UTC offset) | |
| erledigt_am | Timestamp (ISO 8601 with UTC offset) | |
| erledigt_grund | Text (UTF-8) |
Daily revenue
Revenue per location and day.
JSON: daten/partner/tagesumsaetze.json · CSV: daten/partner/tagesumsaetze.csv
| Field | Format | Values |
|---|---|---|
| id | Identifier (UUID, text) | |
| system_id | Identifier (UUID, text) | |
| location_id | Identifier (UUID, text) | |
| datum | Date (ISO 8601, YYYY-MM-DD) | |
| umsatz | Decimal number (dot as decimal separator) | |
| created_by | Identifier (UUID, text) | |
| created_at | Timestamp (ISO 8601 with UTC offset) | |
| quelle | Text (UTF-8) | |
| bons | Integer | |
| kasse | Text (UTF-8) | |
| kasse_stand | Timestamp (ISO 8601 with UTC offset) |
Tasks, checklists, store audits, projects and tickets · 21 Files
Tasks
Assigned and recurring tasks.
JSON: daten/aufgaben/aufgaben.json · CSV: daten/aufgaben/aufgaben.csv
| Field | Format | Values |
|---|---|---|
| id | Identifier (UUID, text) | |
| system_id | Identifier (UUID, text) | |
| kind | Text (UTF-8) | |
| title | Text (UTF-8) | |
| body | Text (UTF-8) | |
| created_by | Identifier (UUID, text) | |
| assignee_id | Identifier (UUID, text) | |
| location_id | Identifier (UUID, text) | |
| due_at | Timestamp (ISO 8601 with UTC offset) | |
| status | Text (UTF-8) | |
| response | Text (UTF-8) | |
| done_at | Timestamp (ISO 8601 with UTC offset) | |
| done_by | Identifier (UUID, text) | |
| created_at | Timestamp (ISO 8601 with UTC offset) | |
| scope | Text (UTF-8) | |
| takt | Text (UTF-8) | |
| active | Boolean (true/false) | |
| rollout_id | Identifier (UUID, text) |
Completions
Completed tasks per period.
JSON: daten/aufgaben/aufgaben_erledigungen.json · CSV: daten/aufgaben/aufgaben_erledigungen.csv
| Field | Format | Values |
|---|---|---|
| id | Identifier (UUID, text) | |
| task_id | Identifier (UUID, text) | |
| system_id | Identifier (UUID, text) | |
| period_start | Date (ISO 8601, YYYY-MM-DD) | |
| done_by | Identifier (UUID, text) | |
| done_at | Timestamp (ISO 8601 with UTC offset) | |
| note | Text (UTF-8) |
Checklists
Checklist templates.
JSON: daten/aufgaben/checklisten.json · CSV: daten/aufgaben/checklisten.csv
| Field | Format | Values |
|---|---|---|
| id | Identifier (UUID, text) | |
| system_id | Identifier (UUID, text) | |
| title | Text (UTF-8) | |
| description | Text (UTF-8) | |
| kind | Enumerated value (text, see values) | oeffnen, schliessen, hygiene, audit, sonstige |
| takt | Enumerated value (text, see values) | taeglich, woechentlich, monatlich, bedarf |
| chapter_id | Identifier (UUID, text) | |
| target_roles | List (JSON array) of: Enumerated value (text, see values) | zentrale, multi_unit_partner, partner, schichtleitung, mitarbeiter |
| active | Boolean (true/false) | |
| sort_order | Integer | |
| created_at | Timestamp (ISO 8601 with UTC offset) | |
| vorlage_schluessel | Text (UTF-8) | |
| punkt_schluessel | Text (UTF-8) | |
| vorlage_version | Text (UTF-8) | |
| faellig_bis | Time of day (HH:MM:SS, local time of the location) |
Checklist items
Items of the checklists.
JSON: daten/aufgaben/checklisten_punkte.json · CSV: daten/aufgaben/checklisten_punkte.csv
| Field | Format | Values |
|---|---|---|
| id | Identifier (UUID, text) | |
| checklist_id | Identifier (UUID, text) | |
| position | Integer | |
| label | Text (UTF-8) | |
| feld | Enumerated value (text, see values) | haken, zahl, text, foto |
| required | Boolean (true/false) | |
| min_value | Decimal number (dot as decimal separator) | |
| max_value | Decimal number (dot as decimal separator) | |
| unit | Text (UTF-8) | |
| hint | Text (UTF-8) | |
| chapter_id | Identifier (UUID, text) | |
| active | Boolean (true/false) | |
| vorlage_schluessel | Text (UTF-8) | |
| punkt_schluessel | Text (UTF-8) | |
| vorlage_version | Text (UTF-8) |
Checklist locations
Validity per location.
JSON: daten/aufgaben/checklisten_standorte.json · CSV: daten/aufgaben/checklisten_standorte.csv
| Field | Format | Values |
|---|---|---|
| checklist_id | Identifier (UUID, text) | |
| location_id | Identifier (UUID, text) | |
| system_id | Identifier (UUID, text) |
Runs
Completed checklists.
JSON: daten/aufgaben/checklisten_durchgaenge.json · CSV: daten/aufgaben/checklisten_durchgaenge.csv
| Field | Format | Values |
|---|---|---|
| id | Identifier (UUID, text) | |
| system_id | Identifier (UUID, text) | |
| checklist_id | Identifier (UUID, text) | |
| location_id | Identifier (UUID, text) | |
| by_user | Identifier (UUID, text) | |
| started_at | Timestamp (ISO 8601 with UTC offset) | |
| completed_at | Timestamp (ISO 8601 with UTC offset) | |
| note | Text (UTF-8) | |
| has_deviation | Boolean (true/false) | |
| title | Text (UTF-8) | |
| kind | Enumerated value (text, see values) | oeffnen, schliessen, hygiene, audit, sonstige |
| takt | Enumerated value (text, see values) | taeglich, woechentlich, monatlich, bedarf |
| schnappschuss_nachgetragen | Boolean (true/false) |
Results
Answers per item; photos under dateien/checklist-photos/.
JSON: daten/aufgaben/checklisten_ergebnisse.json · CSV: daten/aufgaben/checklisten_ergebnisse.csv
| Field | Format | Values |
|---|---|---|
| run_id | Identifier (UUID, text) | |
| item_id | Identifier (UUID, text) | |
| ok | Boolean (true/false) | |
| value | Decimal number (dot as decimal separator) | |
| text_value | Text (UTF-8) | |
| photo_path | Text (UTF-8) | |
| recorded_at | Timestamp (ISO 8601 with UTC offset) | |
| massnahme | Text (UTF-8) | |
| label | Text (UTF-8) | |
| feld | Enumerated value (text, see values) | haken, zahl, text, foto |
| required | Boolean (true/false) | |
| min_value | Decimal number (dot as decimal separator) | |
| max_value | Decimal number (dot as decimal separator) | |
| unit | Text (UTF-8) | |
| hint | Text (UTF-8) |
Store audit templates
Store audit templates.
JSON: daten/aufgaben/storecheck_vorlagen.json · CSV: daten/aufgaben/storecheck_vorlagen.csv
| Field | Format | Values |
|---|---|---|
| id | Identifier (UUID, text) | |
| system_id | Identifier (UUID, text) | |
| name | Text (UTF-8) | |
| beschreibung | Text (UTF-8) | |
| bestanden_ab_prozent | Integer | |
| aktiv | Boolean (true/false) | |
| created_at | Timestamp (ISO 8601 with UTC offset) |
Store audit items
Items of the templates.
JSON: daten/aufgaben/storecheck_fragen.json · CSV: daten/aufgaben/storecheck_fragen.csv
| Field | Format | Values |
|---|---|---|
| id | Identifier (UUID, text) | |
| template_id | Identifier (UUID, text) | |
| system_id | Identifier (UUID, text) | |
| kategorie | Text (UTF-8) | |
| frage | Text (UTF-8) | |
| hinweis | Text (UTF-8) | |
| punkte | Integer | |
| ko | Boolean (true/false) | |
| foto_pflicht | Boolean (true/false) | |
| position | Integer |
Store audits
Performed store audits with result.
JSON: daten/aufgaben/storechecks.json · CSV: daten/aufgaben/storechecks.csv
| Field | Format | Values |
|---|---|---|
| id | Identifier (UUID, text) | |
| system_id | Identifier (UUID, text) | |
| location_id | Identifier (UUID, text) | |
| template_id | Identifier (UUID, text) | |
| auditor | Identifier (UUID, text) | |
| status | Enumerated value (text, see values) | geplant, laeuft, abgeschlossen, abgebrochen |
| geplant_am | Date (ISO 8601, YYYY-MM-DD) | |
| begonnen_am | Timestamp (ISO 8601 with UTC offset) | |
| abgeschlossen_am | Timestamp (ISO 8601 with UTC offset) | |
| punkte_erreicht | Integer | |
| punkte_moeglich | Integer | |
| quote | Decimal number (dot as decimal separator) | |
| bestanden | Boolean (true/false) | |
| ko_verletzt | Boolean (true/false) | |
| fazit | Text (UTF-8) | |
| created_at | Timestamp (ISO 8601 with UTC offset) | |
| bestanden_ab_prozent | Integer |
Store audit results
Rating per item.
JSON: daten/aufgaben/storecheck_ergebnisse.json · CSV: daten/aufgaben/storecheck_ergebnisse.csv
| Field | Format | Values |
|---|---|---|
| audit_id | Identifier (UUID, text) | |
| item_id | Identifier (UUID, text) | |
| system_id | Identifier (UUID, text) | |
| bewertung | Text (UTF-8) | |
| punkte | Integer | |
| bemerkung | Text (UTF-8) | |
| foto_path | Text (UTF-8) |
Actions
Actions from store audits.
JSON: daten/aufgaben/storecheck_massnahmen.json · CSV: daten/aufgaben/storecheck_massnahmen.csv
| Field | Format | Values |
|---|---|---|
| id | Identifier (UUID, text) | |
| audit_id | Identifier (UUID, text) | |
| system_id | Identifier (UUID, text) | |
| item_id | Identifier (UUID, text) | |
| text | Text (UTF-8) | |
| frist | Date (ISO 8601, YYYY-MM-DD) | |
| erledigt_am | Timestamp (ISO 8601 with UTC offset) | |
| erledigt_von | Identifier (UUID, text) | |
| created_at | Timestamp (ISO 8601 with UTC offset) | |
| erledigt_notiz | Text (UTF-8) |
Cancellations
Cancelled store audits.
JSON: daten/aufgaben/storecheck_abbrueche.json · CSV: daten/aufgaben/storecheck_abbrueche.csv
| Field | Format | Values |
|---|---|---|
| audit_id | Identifier (UUID, text) | |
| system_id | Identifier (UUID, text) | |
| abgebrochen_von | Identifier (UUID, text) | |
| abgebrochen_am | Timestamp (ISO 8601 with UTC offset) | |
| grund | Text (UTF-8) |
Projects
Projects such as openings and refits.
JSON: daten/aufgaben/vorhaben.json · CSV: daten/aufgaben/vorhaben.csv
| Field | Format | Values |
|---|---|---|
| id | Identifier (UUID, text) | |
| system_id | Identifier (UUID, text) | |
| location_id | Identifier (UUID, text) | |
| vorlage_id | Identifier (UUID, text) | |
| rollout_id | Identifier (UUID, text) | |
| titel | Text (UTF-8) | |
| beschreibung | Text (UTF-8) | |
| status | Enumerated value (text, see values) | geplant, laeuft, abgeschlossen, abgebrochen |
| stichtag | Date (ISO 8601, YYYY-MM-DD) | |
| verantwortlich | Identifier (UUID, text) | |
| created_by | Identifier (UUID, text) | |
| created_at | Timestamp (ISO 8601 with UTC offset) | |
| abgeschlossen_am | Timestamp (ISO 8601 with UTC offset) |
Project sections
Sections of the projects.
JSON: daten/aufgaben/vorhaben_abschnitte.json · CSV: daten/aufgaben/vorhaben_abschnitte.csv
| Field | Format | Values |
|---|---|---|
| id | Identifier (UUID, text) | |
| system_id | Identifier (UUID, text) | |
| vorhaben_id | Identifier (UUID, text) | |
| name | Text (UTF-8) | |
| reihenfolge | Integer | |
| created_at | Timestamp (ISO 8601 with UTC offset) |
Project steps
Steps with deadlines.
JSON: daten/aufgaben/vorhaben_schritte.json · CSV: daten/aufgaben/vorhaben_schritte.csv
| Field | Format | Values |
|---|---|---|
| id | Identifier (UUID, text) | |
| vorhaben_id | Identifier (UUID, text) | |
| system_id | Identifier (UUID, text) | |
| titel | Text (UTF-8) | |
| beschreibung | Text (UTF-8) | |
| zustaendig | Identifier (UUID, text) | |
| faellig_am | Date (ISO 8601, YYYY-MM-DD) | |
| erledigt_am | Timestamp (ISO 8601 with UTC offset) | |
| erledigt_von | Identifier (UUID, text) | |
| reihenfolge | Integer | |
| abschnitt_id | Identifier (UUID, text) |
Project comments
Comments on projects.
JSON: daten/aufgaben/vorhaben_kommentare.json · CSV: daten/aufgaben/vorhaben_kommentare.csv
| Field | Format | Values |
|---|---|---|
| id | Identifier (UUID, text) | |
| system_id | Identifier (UUID, text) | |
| vorhaben_id | Identifier (UUID, text) | |
| schritt_id | Identifier (UUID, text) | |
| user_id | Identifier (UUID, text) | |
| text | Text (UTF-8) | |
| created_at | Timestamp (ISO 8601 with UTC offset) |
Project templates
Templates for rollouts.
JSON: daten/aufgaben/vorhaben_vorlagen.json · CSV: daten/aufgaben/vorhaben_vorlagen.csv
| Field | Format | Values |
|---|---|---|
| id | Identifier (UUID, text) | |
| system_id | Identifier (UUID, text) | |
| name | Text (UTF-8) | |
| beschreibung | Text (UTF-8) | |
| bezug | Text (UTF-8) | |
| aktiv | Boolean (true/false) | |
| created_at | Timestamp (ISO 8601 with UTC offset) |
Template steps
Steps of the templates.
JSON: daten/aufgaben/vorhaben_vorlagen_schritte.json · CSV: daten/aufgaben/vorhaben_vorlagen_schritte.csv
| Field | Format | Values |
|---|---|---|
| id | Identifier (UUID, text) | |
| vorlage_id | Identifier (UUID, text) | |
| system_id | Identifier (UUID, text) | |
| titel | Text (UTF-8) | |
| beschreibung | Text (UTF-8) | |
| abschnitt | Text (UTF-8) | |
| rolle | Enumerated value (text, see values) | zentrale, multi_unit_partner, partner, schichtleitung, mitarbeiter |
| versatz_tage | Integer | |
| reihenfolge | Integer |
Tickets
Requests from the locations.
JSON: daten/aufgaben/tickets.json · CSV: daten/aufgaben/tickets.csv
| Field | Format | Values |
|---|---|---|
| id | Identifier (UUID, text) | |
| system_id | Identifier (UUID, text) | |
| location_id | Identifier (UUID, text) | |
| created_by | Identifier (UUID, text) | |
| assignee_id | Identifier (UUID, text) | |
| subject | Text (UTF-8) | |
| body | Text (UTF-8) | |
| status | Text (UTF-8) | |
| created_at | Timestamp (ISO 8601 with UTC offset) | |
| done_at | Timestamp (ISO 8601 with UTC offset) | |
| done_by | Identifier (UUID, text) |
Ticket messages
Ticket conversation.
JSON: daten/aufgaben/ticket_nachrichten.json · CSV: daten/aufgaben/ticket_nachrichten.csv
| Field | Format | Values |
|---|---|---|
| id | Identifier (UUID, text) | |
| ticket_id | Identifier (UUID, text) | |
| system_id | Identifier (UUID, text) | |
| author_id | Identifier (UUID, text) | |
| body | Text (UTF-8) | |
| created_at | Timestamp (ISO 8601 with UTC offset) |
Suppliers, orders and stocktaking · 8 Files
Suppliers
Suppliers with contact and notes.
JSON: daten/bestellungen/lieferanten.json · CSV: daten/bestellungen/lieferanten.csv
| Field | Format | Values |
|---|---|---|
| id | Identifier (UUID, text) | |
| system_id | Identifier (UUID, text) | |
| name | Text (UTF-8) | |
| bestell_email | Text (UTF-8) | |
| ansprechpartner | Text (UTF-8) | |
| telefon | Text (UTF-8) | |
| kundennummer | Text (UTF-8) | |
| lieferhinweis | Text (UTF-8) | |
| notiz | Text (UTF-8) | |
| aktiv | Boolean (true/false) | |
| nur_standorte | List (JSON array) of: Identifier (UUID, text) | |
| created_at | Timestamp (ISO 8601 with UTC offset) | |
| aktualisiert_am | Timestamp (ISO 8601 with UTC offset) | |
| mindestbestellwert | Decimal number (dot as decimal separator) | |
| mindestwert_sperrt | Boolean (true/false) | |
| liefertage | List (JSON array) of: Integer | |
| bestellschluss | Time of day (HH:MM:SS, local time of the location) | |
| vorlauf_tage | Integer |
Items
Supplier assortment.
JSON: daten/bestellungen/lieferanten_artikel.json · CSV: daten/bestellungen/lieferanten_artikel.csv
| Field | Format | Values |
|---|---|---|
| id | Identifier (UUID, text) | |
| supplier_id | Identifier (UUID, text) | |
| system_id | Identifier (UUID, text) | |
| name | Text (UTF-8) | |
| einheit | Text (UTF-8) | |
| artikelnummer | Text (UTF-8) | |
| min_menge | Decimal number (dot as decimal separator) | |
| schrittweite | Decimal number (dot as decimal separator) | |
| preis | Decimal number (dot as decimal separator) | |
| kategorie | Text (UTF-8) | |
| aktiv | Boolean (true/false) | |
| position | Integer | |
| created_at | Timestamp (ISO 8601 with UTC offset) | |
| max_menge | Decimal number (dot as decimal separator) | |
| inhalt | Text (UTF-8) |
Suppliers per location
Customer numbers per location.
JSON: daten/bestellungen/lieferanten_standorte.json · CSV: daten/bestellungen/lieferanten_standorte.csv
| Field | Format | Values |
|---|---|---|
| supplier_id | Identifier (UUID, text) | |
| location_id | Identifier (UUID, text) | |
| system_id | Identifier (UUID, text) | |
| kundennummer | Text (UTF-8) |
Orders
Orders with status and cancellation (without supplier reply key).
JSON: daten/bestellungen/bestellungen.json · CSV: daten/bestellungen/bestellungen.csv
| Field | Format | Values |
|---|---|---|
| id | Identifier (UUID, text) | |
| system_id | Identifier (UUID, text) | |
| location_id | Identifier (UUID, text) | |
| supplier_id | Identifier (UUID, text) | |
| nummer | Text (UTF-8) | |
| status | Enumerated value (text, see values) | entwurf, gesendet, bestaetigt, geliefert, storniert |
| wunschtermin | Date (ISO 8601, YYYY-MM-DD) | |
| bemerkung | Text (UTF-8) | |
| by_user | Identifier (UUID, text) | |
| gesendet_am | Timestamp (ISO 8601 with UTC offset) | |
| created_at | Timestamp (ISO 8601 with UTC offset) | |
| mail_gesendet_am | Timestamp (ISO 8601 with UTC offset) | |
| mail_versuche | Integer | |
| mail_fehler | Text (UTF-8) | |
| bestaetigt_am | Timestamp (ISO 8601 with UTC offset) | |
| im_postausgang | Boolean (true/false) | |
| storniert_am | Timestamp (ISO 8601 with UTC offset) | |
| storniert_von | Identifier (UUID, text) | |
| storno_grund | Text (UTF-8) | |
| storno_vorher | Enumerated value (text, see values) | entwurf, gesendet, bestaetigt, geliefert, storniert |
| storno_mail_offen | Boolean (true/false) | |
| storno_mail_gesendet_am | Timestamp (ISO 8601 with UTC offset) | |
| storno_mail_versuche | Integer | |
| storno_mail_fehler | Text (UTF-8) | |
| bestellmail_versuch_am | Timestamp (ISO 8601 with UTC offset) | |
| bestellmail_versuch_ende_am | Timestamp (ISO 8601 with UTC offset) | |
| bestellmail_versuch_id | Identifier (UUID, text) | |
| im_auftrag | Boolean (true/false) |
Order items
Items of the orders.
JSON: daten/bestellungen/bestellpositionen.json · CSV: daten/bestellungen/bestellpositionen.csv
| Field | Format | Values |
|---|---|---|
| id | Identifier (UUID, text) | |
| order_id | Identifier (UUID, text) | |
| system_id | Identifier (UUID, text) | |
| item_id | Identifier (UUID, text) | |
| name | Text (UTF-8) | |
| einheit | Text (UTF-8) | |
| artikelnummer | Text (UTF-8) | |
| menge | Decimal number (dot as decimal separator) | |
| preis | Decimal number (dot as decimal separator) | |
| position | Integer |
Storage areas
Storage areas per location for stocktaking.
JSON: daten/bestellungen/inventur_lagerorte.json · CSV: daten/bestellungen/inventur_lagerorte.csv
| Field | Format | Values |
|---|---|---|
| id | Identifier (UUID, text) | |
| system_id | Identifier (UUID, text) | |
| location_id | Identifier (UUID, text) | |
| name | Text (UTF-8) | |
| position | Integer | |
| aktiv | Boolean (true/false) | |
| created_at | Timestamp (ISO 8601 with UTC offset) |
Stocktakes
Stocktakes per location with count date, status, stock value and cancellation.
JSON: daten/bestellungen/inventuren.json · CSV: daten/bestellungen/inventuren.csv
| Field | Format | Values |
|---|---|---|
| id | Identifier (UUID, text) | |
| system_id | Identifier (UUID, text) | |
| location_id | Identifier (UUID, text) | |
| stichtag | Date (ISO 8601, YYYY-MM-DD) | |
| status | Text (UTF-8) | |
| bemerkung | Text (UTF-8) | |
| gestartet_von | Identifier (UUID, text) | |
| gestartet_am | Timestamp (ISO 8601 with UTC offset) | |
| abgeschlossen_von | Identifier (UUID, text) | |
| abgeschlossen_am | Timestamp (ISO 8601 with UTC offset) | |
| als_null_gewertet | Integer | |
| wert_gesamt | Decimal number (dot as decimal separator) | |
| storniert_von | Identifier (UUID, text) | |
| storniert_am | Timestamp (ISO 8601 with UTC offset) | |
| storno_grund | Text (UTF-8) | |
| storniert_aus | Text (UTF-8) |
Stocktake lines
Counted quantities per storage area with the purchase price at the time of counting.
JSON: daten/bestellungen/inventur_zeilen.json · CSV: daten/bestellungen/inventur_zeilen.csv
| Field | Format | Values |
|---|---|---|
| id | Identifier (UUID, text) | |
| system_id | Identifier (UUID, text) | |
| inventur_id | Identifier (UUID, text) | |
| lagerort_id | Identifier (UUID, text) | |
| artikel_id | Identifier (UUID, text) | |
| frei | Boolean (true/false) | |
| name | Text (UTF-8) | |
| einheit | Text (UTF-8) | |
| inhalt | Text (UTF-8) | |
| artikelnummer | Text (UTF-8) | |
| lieferant | Text (UTF-8) | |
| stueck_je_einheit | Decimal number (dot as decimal separator) | |
| preis | Decimal number (dot as decimal separator) | |
| menge | Decimal number (dot as decimal separator) | |
| anbruch_stueck | Decimal number (dot as decimal separator) | |
| menge_gesamt | Decimal number (dot as decimal separator) | |
| wert | Decimal number (dot as decimal separator) | |
| als_null | Boolean (true/false) | |
| fassung | Integer | |
| letzter_vorgang | Identifier (UUID, text) | |
| gezaehlt_von | Identifier (UUID, text) | |
| gezaehlt_am | Timestamp (ISO 8601 with UTC offset) | |
| geraetezeit | Timestamp (ISO 8601 with UTC offset) | |
| quelle | Text (UTF-8) |
Hygiene (HACCP) · 22 Files
HACCP plans
Approved versions with hazard analysis.
JSON: daten/hygiene/plaene.json · CSV: daten/hygiene/plaene.csv
| Field | Format | Values |
|---|---|---|
| id | Identifier (UUID, text) | |
| system_id | Identifier (UUID, text) | |
| version | Integer | |
| titel | Text (UTF-8) | |
| geltungsbereich | Text (UTF-8) | |
| gefahrenanalyse | JSON (object or list; JSON text in CSV) | |
| aenderung | Text (UTF-8) | |
| freigegeben_von | Identifier (UUID, text) | |
| freigegeben_am | Timestamp (ISO 8601 with UTC offset) | |
| vorgaenger_id | Identifier (UUID, text) | |
| inhalt | JSON (object or list; JSON text in CSV) | |
| fachlich_geprueft_von | Text (UTF-8) | |
| fachlich_geprueft_am | Date (ISO 8601, YYYY-MM-DD) |
Plan acknowledgements
Acknowledgements per location.
JSON: daten/hygiene/plan_bestaetigungen.json · CSV: daten/hygiene/plan_bestaetigungen.csv
| Field | Format | Values |
|---|---|---|
| plan_id | Identifier (UUID, text) | |
| location_id | Identifier (UUID, text) | |
| user_id | Identifier (UUID, text) | |
| acknowledged_at | Timestamp (ISO 8601 with UTC offset) | |
| fassung_sha256 | Text (UTF-8) | |
| anpassungen | JSON (object or list; JSON text in CSV) |
Control points
Checks with frequency, limits and audience.
JSON: daten/hygiene/kontrollpunkte.json · CSV: daten/hygiene/kontrollpunkte.csv
| Field | Format | Values |
|---|---|---|
| id | Identifier (UUID, text) | |
| system_id | Identifier (UUID, text) | |
| location_id | Identifier (UUID, text) | |
| art | Enumerated value (text, see values) | temperatur_geraet, kerntemperatur, abkuehlung, wareneingang, reinigung, schaedling, fritteuse_oel, spuelmaschine, sonstige |
| titel | Text (UTF-8) | |
| hinweis | Text (UTF-8) | |
| takt | Enumerated value (text, see values) | taeglich, woechentlich, monatlich, je_ereignis, bedarf |
| zeitfenster | JSON (object or list; JSON text in CSV) | |
| wochentag | Integer | |
| monatstag | Integer | |
| equipment_art | Enumerated value (text, see values) | kuehlschrank, tiefkuehler, kuehlvitrine, heisshaltung, fritteuse, spuelmaschine, eismaschine, sonstiges, koederbox, insektenfalle, uv_falle, sahneautomat, kaffeemaschine, glaeserspueler, schankanlage, saladette, eisvitrine, eiswuerfelbereiter, softeismaschine |
| equipment_id | Identifier (UUID, text) | |
| feld | Text (UTF-8) | |
| min_wert | Decimal number (dot as decimal separator) | |
| max_wert | Decimal number (dot as decimal separator) | |
| einheit | Text (UTF-8) | |
| foto_pflicht | Boolean (true/false) | |
| zielrollen | List (JSON array) of: Enumerated value (text, see values) | zentrale, multi_unit_partner, partner, schichtleitung, mitarbeiter |
| massnahmen_vorlage | JSON (object or list; JSON text in CSV) | |
| chapter_id | Identifier (UUID, text) | |
| sort | Integer | |
| aktiv | Boolean (true/false) | |
| gueltig_ab | Date (ISO 8601, YYYY-MM-DD) | |
| gueltig_bis | Date (ISO 8601, YYYY-MM-DD) | |
| erstellt_von | Identifier (UUID, text) | |
| erstellt_am | Timestamp (ISO 8601 with UTC offset) | |
| geaendert_von | Identifier (UUID, text) | |
| geaendert_am | Timestamp (ISO 8601 with UTC offset) | |
| bereich | Text (UTF-8) | |
| reinigungsmittel | Text (UTF-8) | |
| konzentration | Text (UTF-8) | |
| einwirkzeit | Text (UTF-8) | |
| aktiv_seit | Timestamp (ISO 8601 with UTC offset) | |
| thema | Text (UTF-8) | |
| vorlage_schluessel | Text (UTF-8) | |
| punkt_schluessel | Text (UTF-8) | |
| vorlage_version | Text (UTF-8) | |
| verbindlichkeit | Text (UTF-8) | |
| quelle | Text (UTF-8) | |
| quelle_url | Text (UTF-8) | |
| nur_standorte | List (JSON array) of: Identifier (UUID, text) | |
| nur_deutschland | Boolean (true/false) | |
| uebersetzung | JSON (object or list; JSON text in CSV) | |
| nur_laender | List (JSON array) of: Text (UTF-8) | |
| laender_punkt | Text (UTF-8) | |
| partner_anpassbar | Boolean (true/false) |
Limits
Stored limit values.
JSON: daten/hygiene/grenzwerte.json · CSV: daten/hygiene/grenzwerte.csv
| Field | Format | Values |
|---|---|---|
| id | Identifier (UUID, text) | |
| system_id | Identifier (UUID, text) | |
| schluessel | Text (UTF-8) | |
| min_wert | Decimal number (dot as decimal separator) | |
| max_wert | Decimal number (dot as decimal separator) | |
| einheit | Text (UTF-8) | |
| gilt_ab | Date (ISO 8601, YYYY-MM-DD) | |
| quelle | Text (UTF-8) | |
| vorlage_schluessel | Text (UTF-8) | |
| punkt_schluessel | Text (UTF-8) | |
| vorlage_version | Text (UTF-8) | |
| eigener_wert | Boolean (true/false) |
Location adjustments
Checks and plan steps that do not apply at a location: reason, explanation, from when, who, lifting.
JSON: daten/hygiene/standort_anpassungen.json · CSV: daten/hygiene/standort_anpassungen.csv
| Field | Format | Values |
|---|---|---|
| id | Identifier (UUID, text) | |
| system_id | Identifier (UUID, text) | |
| location_id | Identifier (UUID, text) | |
| art | Text (UTF-8) | |
| control_id | Identifier (UUID, text) | |
| plan_id | Identifier (UUID, text) | |
| stufe_kennung | Text (UTF-8) | |
| stufe_name | Text (UTF-8) | |
| grund | Text (UTF-8) | |
| begruendung | Text (UTF-8) | |
| ab | Date (ISO 8601, YYYY-MM-DD) | |
| erstellt_von | Identifier (UUID, text) | |
| erstellt_am | Timestamp (ISO 8601 with UTC offset) | |
| wieder_ab | Date (ISO 8601, YYYY-MM-DD) | |
| aufgehoben_von | Identifier (UUID, text) | |
| aufgehoben_am | Timestamp (ISO 8601 with UTC offset) | |
| aufhebung_grund | Text (UTF-8) | |
| aufhebung_art | Text (UTF-8) | |
| bestaetigt_am | Timestamp (ISO 8601 with UTC offset) | |
| punkt_art | List (JSON array) of: Text (UTF-8) |
Control point adjustments per location
Own time windows, frequency, stricter limits, team note and narrower target roles of a head office check: explanation, confirmation of responsibility, from when, who, lifting.
JSON: daten/hygiene/standort_kontrollanpassungen.json · CSV: daten/hygiene/standort_kontrollanpassungen.csv
| Field | Format | Values |
|---|---|---|
| id | Identifier (UUID, text) | |
| system_id | Identifier (UUID, text) | |
| location_id | Identifier (UUID, text) | |
| control_id | Identifier (UUID, text) | |
| zeitfenster | JSON (object or list; JSON text in CSV) | |
| takt | Enumerated value (text, see values) | taeglich, woechentlich, monatlich, je_ereignis, bedarf |
| wochentag | Integer | |
| monatstag | Integer | |
| min_wert | Decimal number (dot as decimal separator) | |
| max_wert | Decimal number (dot as decimal separator) | |
| hinweis | Text (UTF-8) | |
| zielrollen | List (JSON array) of: Enumerated value (text, see values) | zentrale, multi_unit_partner, partner, schichtleitung, mitarbeiter |
| begruendung | Text (UTF-8) | |
| bestaetigt_am | Timestamp (ISO 8601 with UTC offset) | |
| punkt_art | List (JSON array) of: Text (UTF-8) | |
| ab | Date (ISO 8601, YYYY-MM-DD) | |
| erstellt_von | Identifier (UUID, text) | |
| erstellt_am | Timestamp (ISO 8601 with UTC offset) | |
| wieder_ab | Date (ISO 8601, YYYY-MM-DD) | |
| aufgehoben_von | Identifier (UUID, text) | |
| aufgehoben_am | Timestamp (ISO 8601 with UTC offset) | |
| aufhebung_grund | Text (UTF-8) | |
| aufhebung_art | Text (UTF-8) | |
| vorgabe | JSON (object or list; JSON text in CSV) |
Locked plan steps
Steps of the HACCP plan that locations may not exclude: who, when.
JSON: daten/hygiene/planschritt_sperren.json · CSV: daten/hygiene/planschritt_sperren.csv
| Field | Format | Values |
|---|---|---|
| id | Identifier (UUID, text) | |
| system_id | Identifier (UUID, text) | |
| stufe_kennung | Text (UTF-8) | |
| stufe_name | Text (UTF-8) | |
| gesperrt_von | Identifier (UUID, text) | |
| gesperrt_am | Timestamp (ISO 8601 with UTC offset) |
HACCP plan – translations
Translation per version (the German version remains authoritative).
JSON: daten/hygiene/plan_uebersetzungen.json · CSV: daten/hygiene/plan_uebersetzungen.csv
| Field | Format | Values |
|---|---|---|
| id | Identifier (UUID, text) | |
| plan_id | Identifier (UUID, text) | |
| system_id | Identifier (UUID, text) | |
| sprache | Text (UTF-8) | |
| titel | Text (UTF-8) | |
| geltungsbereich | Text (UTF-8) | |
| stufen | JSON (object or list; JSON text in CSV) | |
| erstellt_von | Identifier (UUID, text) | |
| erstellt_am | Timestamp (ISO 8601 with UTC offset) | |
| geaendert_von | Identifier (UUID, text) | |
| geaendert_am | Timestamp (ISO 8601 with UTC offset) | |
| freigegeben_von | Identifier (UUID, text) | |
| freigegeben_am | Timestamp (ISO 8601 with UTC offset) |
Allergens
Allergen details per product (14 major allergens, traces, note).
JSON: daten/hygiene/allergene.json · CSV: daten/hygiene/allergene.csv
| Field | Format | Values |
|---|---|---|
| id | Identifier (UUID, text) | |
| system_id | Identifier (UUID, text) | |
| menue_produkt_id | Identifier (UUID, text) | |
| name | Text (UTF-8) | |
| gruppe | Text (UTF-8) | |
| allergene | List (JSON array) of: Text (UTF-8) | |
| spuren | List (JSON array) of: Text (UTF-8) | |
| hinweis | Text (UTF-8) | |
| aktiv | Boolean (true/false) | |
| version | Integer | |
| geaendert_von | Identifier (UUID, text) | |
| geaendert_am | Timestamp (ISO 8601 with UTC offset) | |
| erstellt_am | Timestamp (ISO 8601 with UTC offset) |
Allergens – versions
Every saved version of the allergen details with reason.
JSON: daten/hygiene/allergene_fassungen.json · CSV: daten/hygiene/allergene_fassungen.csv
| Field | Format | Values |
|---|---|---|
| id | Identifier (UUID, text) | |
| system_id | Identifier (UUID, text) | |
| produkt_id | Identifier (UUID, text) | |
| version | Integer | |
| name | Text (UTF-8) | |
| gruppe | Text (UTF-8) | |
| allergene | List (JSON array) of: Text (UTF-8) | |
| spuren | List (JSON array) of: Text (UTF-8) | |
| hinweis | Text (UTF-8) | |
| aktiv | Boolean (true/false) | |
| grund | Text (UTF-8) | |
| geaendert_von | Identifier (UUID, text) | |
| geaendert_am | Timestamp (ISO 8601 with UTC offset) |
Template adoptions
Adoptions from the template library: template, version, who, when, confirmed notice and result.
JSON: daten/hygiene/vorlagen_uebernahmen.json · CSV: daten/hygiene/vorlagen_uebernahmen.csv
| Field | Format | Values |
|---|---|---|
| id | Identifier (UUID, text) | |
| system_id | Identifier (UUID, text) | |
| vorgang | Identifier (UUID, text) | |
| vorlage_schluessel | Text (UTF-8) | |
| version | Text (UTF-8) | |
| von | Identifier (UUID, text) | |
| am | Timestamp (ISO 8601 with UTC offset) | |
| hinweis_fassung | Text (UTF-8) | |
| hinweis_bestaetigt | Boolean (true/false) | |
| plan_id | Identifier (UUID, text) | |
| ergebnis | JSON (object or list; JSON text in CSV) |
Template decisions
Decision per item of an adoption with the affected row.
JSON: daten/hygiene/vorlagen_entscheidungen.json · CSV: daten/hygiene/vorlagen_entscheidungen.csv
| Field | Format | Values |
|---|---|---|
| id | Integer | |
| system_id | Identifier (UUID, text) | |
| uebernahme_id | Identifier (UUID, text) | |
| typ | Text (UTF-8) | |
| eltern_schluessel | Text (UTF-8) | |
| punkt_schluessel | Text (UTF-8) | |
| vorlage_schluessel | Text (UTF-8) | |
| version | Text (UTF-8) | |
| entscheidung | Text (UTF-8) | |
| ziel_id | Identifier (UUID, text) |
Equipment
Cooling and measuring devices per location.
JSON: daten/hygiene/geraete.json · CSV: daten/hygiene/geraete.csv
| Field | Format | Values |
|---|---|---|
| id | Identifier (UUID, text) | |
| system_id | Identifier (UUID, text) | |
| location_id | Identifier (UUID, text) | |
| name | Text (UTF-8) | |
| art | Enumerated value (text, see values) | kuehlschrank, tiefkuehler, kuehlvitrine, heisshaltung, fritteuse, spuelmaschine, eismaschine, sonstiges, koederbox, insektenfalle, uv_falle, sahneautomat, kaffeemaschine, glaeserspueler, schankanlage, saladette, eisvitrine, eiswuerfelbereiter, softeismaschine |
| bereich | Text (UTF-8) | |
| soll_min | Decimal number (dot as decimal separator) | |
| soll_max | Decimal number (dot as decimal separator) | |
| einheit | Text (UTF-8) | |
| sort | Integer | |
| aktiv | Boolean (true/false) | |
| ausser_betrieb_von | Date (ISO 8601, YYYY-MM-DD) | |
| ausser_betrieb_bis | Date (ISO 8601, YYYY-MM-DD) | |
| erstellt_von | Identifier (UUID, text) | |
| erstellt_am | Timestamp (ISO 8601 with UTC offset) | |
| geaendert_von | Identifier (UUID, text) | |
| geaendert_am | Timestamp (ISO 8601 with UTC offset) | |
| aktiv_seit | Timestamp (ISO 8601 with UTC offset) |
Check entries
All measurements and checks, immutable with hash chain. People as name, or as code for head office; photos under dateien/checklist-photos/.
JSON: daten/hygiene/eintraege.json · CSV: daten/hygiene/eintraege.csv
| Field | Format | Values |
|---|---|---|
| id | Identifier (UUID, text) | |
| location_id | Identifier (UUID, text) | |
| control_id | Identifier (UUID, text) | |
| equipment_id | Identifier (UUID, text) | |
| seq | Integer | |
| tag | Date (ISO 8601, YYYY-MM-DD) | |
| zeitfenster_index | Integer | |
| status | Text (UTF-8) | |
| wert | Decimal number (dot as decimal separator) | |
| text_wert | Text (UTF-8) | |
| haken | Boolean (true/false) | |
| foto_path | Text (UTF-8) | |
| person | Text (UTF-8) | |
| rolle | Enumerated value (text, see values) | zentrale, multi_unit_partner, partner, schichtleitung, mitarbeiter |
| quelle | Text (UTF-8) | |
| erfasst_am | Timestamp (ISO 8601 with UTC offset) | |
| geraetezeit | Timestamp (ISO 8601 with UTC offset) | |
| nachgetragen | Boolean (true/false) | |
| nachtrag_grund | Text (UTF-8) | |
| bezug_id | Identifier (UUID, text) | |
| kontroll_schnappschuss | JSON (object or list; JSON text in CSV) | |
| storniert_am | Timestamp (ISO 8601 with UTC offset) | |
| storniert_von | Text (UTF-8) | |
| vorheriger_hash | Text (UTF-8) | |
| hash | Text (UTF-8) |
Goods receipts
Deliveries with inspection result.
JSON: daten/hygiene/wareneingaenge.json · CSV: daten/hygiene/wareneingaenge.csv
| Field | Format | Values |
|---|---|---|
| id | Identifier (UUID, text) | |
| location_id | Identifier (UUID, text) | |
| record_id | Identifier (UUID, text) | |
| supplier_id | Identifier (UUID, text) | |
| lieferant_name | Text (UTF-8) | |
| lieferschein_nr | Text (UTF-8) | |
| lieferschein_foto | Text (UTF-8) | |
| order_id | Identifier (UUID, text) | |
| transport_temp | Decimal number (dot as decimal separator) | |
| ergebnis | Text (UTF-8) | |
| bemerkung | Text (UTF-8) | |
| person | Text (UTF-8) | |
| erfasst_am | Timestamp (ISO 8601 with UTC offset) |
Goods receipt items
Inspected items per delivery.
JSON: daten/hygiene/wareneingang_positionen.json · CSV: daten/hygiene/wareneingang_positionen.csv
| Field | Format | Values |
|---|---|---|
| id | Identifier (UUID, text) | |
| delivery_id | Identifier (UUID, text) | |
| position | Integer | |
| supplier_item_id | Identifier (UUID, text) | |
| artikel | Text (UTF-8) | |
| warengruppe | Enumerated value (text, see values) | kuehl, tiefkuehl, gefluegel, hackfleisch, fleisch, fisch, milch, trocken, obst_gemuese, sonstige, hackfleisch_tk, innereien, fleischzubereitung |
| menge | Decimal number (dot as decimal separator) | |
| einheit | Text (UTF-8) | |
| temperatur | Decimal number (dot as decimal separator) | |
| grenze | Decimal number (dot as decimal separator) | |
| mhd | Date (ISO 8601, YYYY-MM-DD) | |
| charge | Text (UTF-8) | |
| sicht_ok | Boolean (true/false) | |
| angenommen | Boolean (true/false) | |
| mangel | Text (UTF-8) | |
| foto_path | Text (UTF-8) |
Daily sign-offs
Confirmed days with day hash.
JSON: daten/hygiene/tagesabschluesse.json · CSV: daten/hygiene/tagesabschluesse.csv
| Field | Format | Values |
|---|---|---|
| id | Identifier (UUID, text) | |
| location_id | Identifier (UUID, text) | |
| tag | Date (ISO 8601, YYYY-MM-DD) | |
| person | Text (UTF-8) | |
| rolle | Enumerated value (text, see values) | zentrale, multi_unit_partner, partner, schichtleitung, mitarbeiter |
| bestaetigt_mit | Text (UTF-8) | |
| offene_kontrollen | Integer | |
| offene_abweichungen | Integer | |
| bemerkung | Text (UTF-8) | |
| tageshash | Text (UTF-8) | |
| erfasst_am | Timestamp (ISO 8601 with UTC offset) |
Deviations
Deviations with immediate action, cause, correction and effectiveness.
JSON: daten/hygiene/abweichungen.json · CSV: daten/hygiene/abweichungen.csv
| Field | Format | Values |
|---|---|---|
| id | Identifier (UUID, text) | |
| location_id | Identifier (UUID, text) | |
| record_id | Identifier (UUID, text) | |
| control_id | Identifier (UUID, text) | |
| equipment_id | Identifier (UUID, text) | |
| inspection_id | Identifier (UUID, text) | |
| quelle | Text (UTF-8) | |
| schwere | Integer | |
| titel | Text (UTF-8) | |
| status | Text (UTF-8) | |
| sofortmassnahme | Text (UTF-8) | |
| sofortmassnahme_foto | Text (UTF-8) | |
| sofort_von | Text (UTF-8) | |
| sofort_am | Timestamp (ISO 8601 with UTC offset) | |
| ursache | Text (UTF-8) | |
| ursache_von | Text (UTF-8) | |
| ursache_am | Timestamp (ISO 8601 with UTC offset) | |
| korrektur | Text (UTF-8) | |
| verantwortlich | Text (UTF-8) | |
| frist | Date (ISO 8601, YYYY-MM-DD) | |
| korrektur_von | Text (UTF-8) | |
| korrektur_am | Timestamp (ISO 8601 with UTC offset) | |
| erledigt_von | Text (UTF-8) | |
| erledigt_am | Timestamp (ISO 8601 with UTC offset) | |
| wirksam_von | Text (UTF-8) | |
| wirksam_am | Timestamp (ISO 8601 with UTC offset) | |
| verworfen_grund | Text (UTF-8) | |
| verworfen_von | Text (UTF-8) | |
| verworfen_am | Timestamp (ISO 8601 with UTC offset) | |
| muster | Boolean (true/false) | |
| eskaliert_partner_am | Timestamp (ISO 8601 with UTC offset) | |
| eskaliert_zentrale_am | Timestamp (ISO 8601 with UTC offset) | |
| erstellt_am | Timestamp (ISO 8601 with UTC offset) | |
| korrektur_foto | Text (UTF-8) |
Deviation history
Every processing step of deviations.
JSON: daten/hygiene/abweichungen_verlauf.json · CSV: daten/hygiene/abweichungen_verlauf.csv
| Field | Format | Values |
|---|---|---|
| id | Integer | |
| deviation_id | Identifier (UUID, text) | |
| person | Text (UTF-8) | |
| schritt | Text (UTF-8) | |
| vorher | JSON (object or list; JSON text in CSV) | |
| nachher | JSON (object or list; JSON text in CSV) | |
| geaendert_am | Timestamp (ISO 8601 with UTC offset) |
Official inspections
Inspections by authorities.
JSON: daten/hygiene/amtsbesuche.json · CSV: daten/hygiene/amtsbesuche.csv
| Field | Format | Values |
|---|---|---|
| id | Identifier (UUID, text) | |
| location_id | Identifier (UUID, text) | |
| datum | Date (ISO 8601, YYYY-MM-DD) | |
| behoerde | Text (UTF-8) | |
| kontrolleur | Text (UTF-8) | |
| ergebnis | Text (UTF-8) | |
| bemerkung | Text (UTF-8) | |
| erfasst_von | Text (UTF-8) | |
| erfasst_am | Timestamp (ISO 8601 with UTC offset) |
Quarantine
Unassignable device entries and their resolution.
JSON: daten/hygiene/quarantaene.json · CSV: daten/hygiene/quarantaene.csv
| Field | Format | Values |
|---|---|---|
| id | Identifier (UUID, text) | |
| location_id | Identifier (UUID, text) | |
| control_id | Identifier (UUID, text) | |
| titel | Text (UTF-8) | |
| eintrag | JSON (object or list; JSON text in CSV) | |
| grund | Text (UTF-8) | |
| person | Text (UTF-8) | |
| geraetezeit | Timestamp (ISO 8601 with UTC offset) | |
| gemeldet_am | Timestamp (ISO 8601 with UTC offset) | |
| geklaert_am | Timestamp (ISO 8601 with UTC offset) | |
| geklaert_von | Text (UTF-8) | |
| klaerung | Text (UTF-8) |
Reports
Generated hygiene reports (metadata and checksum).
JSON: daten/hygiene/berichte.json · CSV: daten/hygiene/berichte.csv
| Field | Format | Values |
|---|---|---|
| id | Identifier (UUID, text) | |
| location_id | Identifier (UUID, text) | |
| art | Text (UTF-8) | |
| von | Date (ISO 8601, YYYY-MM-DD) | |
| bis | Date (ISO 8601, YYYY-MM-DD) | |
| sha256 | Text (UTF-8) | |
| erzeugt_von | Text (UTF-8) | |
| erzeugt_am | Timestamp (ISO 8601 with UTC offset) |
Screens and media library · 29 Files
Screens
Devices with location, playlist and schedule (without device secret).
JSON: daten/screens/bildschirme.json · CSV: daten/screens/bildschirme.csv
| Field | Format | Values |
|---|---|---|
| id | Identifier (UUID, text) | |
| system_id | Identifier (UUID, text) | |
| location_id | Identifier (UUID, text) | |
| playlist_id | Identifier (UUID, text) | |
| name | Text (UTF-8) | |
| zuletzt_gesehen | Timestamp (ISO 8601 with UTC offset) | |
| created_at | Timestamp (ISO 8601 with UTC offset) | |
| playlist_vorher | Identifier (UUID, text) | |
| zeigt_item_id | Identifier (UUID, text) | |
| geraet | Text (UTF-8) | |
| drehung | Integer | |
| sync_delay_ms | Integer | |
| betrieb_von | Time of day (HH:MM:SS, local time of the location) | |
| betrieb_bis | Time of day (HH:MM:SS, local time of the location) | |
| restart_id | Identifier (UUID, text) | |
| im_notfall | Boolean (true/false) | |
| fehler_item_id | Identifier (UUID, text) | |
| fehler_am | Timestamp (ISO 8601 with UTC offset) | |
| kanal_id | Identifier (UUID, text) | |
| gruppe_id | Identifier (UUID, text) | |
| zeitplan | JSON (object or list; JSON text in CSV) | |
| lautstaerke | Integer | |
| telemetrie | JSON (object or list; JSON text in CSV) | |
| faehigkeiten | List (JSON array) of: Text (UTF-8) | |
| geraet_gesehen | Timestamp (ISO 8601 with UTC offset) | |
| region | Text (UTF-8) | |
| neu_koppeln_seit | Timestamp (ISO 8601 with UTC offset) |
Screen groups
Groups of screens.
JSON: daten/screens/bildschirm_gruppen.json · CSV: daten/screens/bildschirm_gruppen.csv
| Field | Format | Values |
|---|---|---|
| id | Identifier (UUID, text) | |
| system_id | Identifier (UUID, text) | |
| name | Text (UTF-8) | |
| created_at | Timestamp (ISO 8601 with UTC offset) |
Screen labels
Labels.
JSON: daten/screens/bildschirm_label.json · CSV: daten/screens/bildschirm_label.csv
| Field | Format | Values |
|---|---|---|
| id | Identifier (UUID, text) | |
| system_id | Identifier (UUID, text) | |
| name | Text (UTF-8) | |
| farbe | Text (UTF-8) | |
| created_at | Timestamp (ISO 8601 with UTC offset) |
Label assignment
Labels per screen.
JSON: daten/screens/bildschirm_label_zuordnung.json · CSV: daten/screens/bildschirm_label_zuordnung.csv
| Field | Format | Values |
|---|---|---|
| screen_id | Identifier (UUID, text) | |
| label_id | Identifier (UUID, text) | |
| system_id | Identifier (UUID, text) | |
| created_at | Timestamp (ISO 8601 with UTC offset) |
Playlists
Playlists.
JSON: daten/screens/playlists.json · CSV: daten/screens/playlists.csv
| Field | Format | Values |
|---|---|---|
| id | Identifier (UUID, text) | |
| system_id | Identifier (UUID, text) | |
| name | Text (UTF-8) | |
| created_at | Timestamp (ISO 8601 with UTC offset) | |
| synchron | Boolean (true/false) | |
| live_plan | JSON (object or list; JSON text in CSV) | |
| veroeffentlicht_am | Timestamp (ISO 8601 with UTC offset) | |
| geaendert_am | Timestamp (ISO 8601 with UTC offset) | |
| farbe | Text (UTF-8) | |
| erstellt_von | Identifier (UUID, text) |
Playlist items
Media per playlist with time rules.
JSON: daten/screens/playlist_eintraege.json · CSV: daten/screens/playlist_eintraege.csv
| Field | Format | Values |
|---|---|---|
| id | Identifier (UUID, text) | |
| playlist_id | Identifier (UUID, text) | |
| system_id | Identifier (UUID, text) | |
| medium_id | Identifier (UUID, text) | |
| dauer_s | Integer | |
| reihenfolge | Integer | |
| von | Time of day (HH:MM:SS, local time of the location) | |
| bis | Time of day (HH:MM:SS, local time of the location) | |
| created_at | Timestamp (ISO 8601 with UTC offset) | |
| wochentage | List (JSON array) of: Integer | |
| gilt_von | Date (ISO 8601, YYYY-MM-DD) | |
| gilt_bis | Date (ISO 8601, YYYY-MM-DD) | |
| folie | JSON (object or list; JSON text in CSV) | |
| nur_labels | List (JSON array) of: Identifier (UUID, text) | |
| ohne_labels | List (JSON array) of: Identifier (UUID, text) | |
| nur_standorte | List (JSON array) of: Identifier (UUID, text) | |
| ohne_standorte | List (JSON array) of: Identifier (UUID, text) |
Channels
Programme channels.
JSON: daten/screens/kanaele.json · CSV: daten/screens/kanaele.csv
| Field | Format | Values |
|---|---|---|
| id | Identifier (UUID, text) | |
| system_id | Identifier (UUID, text) | |
| name | Text (UTF-8) | |
| farbe | Text (UTF-8) | |
| rest_playlist_id | Identifier (UUID, text) | |
| created_at | Timestamp (ISO 8601 with UTC offset) |
Channel slots
Time slots per channel.
JSON: daten/screens/kanal_zeitfenster.json · CSV: daten/screens/kanal_zeitfenster.csv
| Field | Format | Values |
|---|---|---|
| id | Identifier (UUID, text) | |
| kanal_id | Identifier (UUID, text) | |
| system_id | Identifier (UUID, text) | |
| playlist_id | Identifier (UUID, text) | |
| wochentage | List (JSON array) of: Integer | |
| von | Time of day (HH:MM:SS, local time of the location) | |
| bis | Time of day (HH:MM:SS, local time of the location) | |
| gilt_von | Date (ISO 8601, YYYY-MM-DD) | |
| gilt_bis | Date (ISO 8601, YYYY-MM-DD) | |
| reihenfolge | Integer | |
| created_at | Timestamp (ISO 8601 with UTC offset) |
Device commands
Restart, volume and other commands.
JSON: daten/screens/befehle.json · CSV: daten/screens/befehle.csv
| Field | Format | Values |
|---|---|---|
| id | Identifier (UUID, text) | |
| system_id | Identifier (UUID, text) | |
| screen_id | Identifier (UUID, text) | |
| art | Text (UTF-8) | |
| wert | Integer | |
| erstellt_von | Identifier (UUID, text) | |
| erstellt_am | Timestamp (ISO 8601 with UTC offset) | |
| abgeholt_am | Timestamp (ISO 8601 with UTC offset) | |
| quittiert_am | Timestamp (ISO 8601 with UTC offset) | |
| ok | Boolean (true/false) | |
| ergebnis | Text (UTF-8) |
Alert rules
Offline notifications per location.
JSON: daten/screens/alarmregeln.json · CSV: daten/screens/alarmregeln.csv
| Field | Format | Values |
|---|---|---|
| id | Identifier (UUID, text) | |
| system_id | Identifier (UUID, text) | |
| location_id | Identifier (UUID, text) | |
| aktiv | Boolean (true/false) | |
| empfaenger | List (JSON array) of: Text (UTF-8) | |
| wartezeit_min | Integer | |
| geaendert_am | Timestamp (ISO 8601 with UTC offset) | |
| geaendert_von | Identifier (UUID, text) |
Alerts
Offline alerts.
JSON: daten/screens/alarme.json · CSV: daten/screens/alarme.csv
| Field | Format | Values |
|---|---|---|
| id | Identifier (UUID, text) | |
| system_id | Identifier (UUID, text) | |
| screen_id | Identifier (UUID, text) | |
| location_id | Identifier (UUID, text) | |
| offline_seit | Timestamp (ISO 8601 with UTC offset) | |
| erstellt_am | Timestamp (ISO 8601 with UTC offset) | |
| empfaenger | List (JSON array) of: Text (UTF-8) | |
| alarm_mail_am | Timestamp (ISO 8601 with UTC offset) | |
| alarm_versuche | Integer | |
| alarm_versucht_an | List (JSON array) of: Text (UTF-8) | |
| zurueck_am | Timestamp (ISO 8601 with UTC offset) | |
| entwarnung_mail_am | Timestamp (ISO 8601 with UTC offset) | |
| entwarnung_versuche | Integer | |
| beansprucht_am | Timestamp (ISO 8601 with UTC offset) | |
| geschlossen_am | Timestamp (ISO 8601 with UTC offset) |
Device log
Messages from the devices.
JSON: daten/screens/geraeteprotokoll.json · CSV: daten/screens/geraeteprotokoll.csv
| Field | Format | Values |
|---|---|---|
| id | Integer | |
| system_id | Identifier (UUID, text) | |
| screen_id | Identifier (UUID, text) | |
| zeit | Timestamp (ISO 8601 with UTC offset) | |
| empfangen_am | Timestamp (ISO 8601 with UTC offset) | |
| stufe | Text (UTF-8) | |
| text | Text (UTF-8) |
Activities
Changes to screens and playlists.
JSON: daten/screens/aktivitaeten.json · CSV: daten/screens/aktivitaeten.csv
| Field | Format | Values |
|---|---|---|
| id | Integer | |
| system_id | Identifier (UUID, text) | |
| screen_id | Identifier (UUID, text) | |
| objekt | Text (UTF-8) | |
| objekt_id | Identifier (UUID, text) | |
| name | Text (UTF-8) | |
| aktion | Text (UTF-8) | |
| details | JSON (object or list; JSON text in CSV) | |
| person_id | Identifier (UUID, text) | |
| erstellt_am | Timestamp (ISO 8601 with UTC offset) |
Media library
Images and videos; files under dateien/bilder/ and dateien/videos/.
JSON: daten/screens/medien.json · CSV: daten/screens/medien.csv
| Field | Format | Values |
|---|---|---|
| id | Identifier (UUID, text) | |
| system_id | Identifier (UUID, text) | |
| bucket | Text (UTF-8) | |
| path | Text (UTF-8) | |
| mime | Text (UTF-8) | |
| bytes | Integer | |
| kind | Text (UTF-8) | |
| titel | Text (UTF-8) | |
| alt | Text (UTF-8) | |
| width | Integer | |
| height | Integer | |
| duration_seconds | Integer | |
| uploaded_by | Identifier (UUID, text) | |
| created_at | Timestamp (ISO 8601 with UTC offset) | |
| video_codec | Text (UTF-8) | |
| ordner_id | Identifier (UUID, text) | |
| loeschung_freigegeben_am | Timestamp (ISO 8601 with UTC offset) |
Media folders
Folders of the media library.
JSON: daten/screens/medien_ordner.json · CSV: daten/screens/medien_ordner.csv
| Field | Format | Values |
|---|---|---|
| id | Identifier (UUID, text) | |
| system_id | Identifier (UUID, text) | |
| parent_id | Identifier (UUID, text) | |
| name | Text (UTF-8) | |
| erstellt_von | Identifier (UUID, text) | |
| created_at | Timestamp (ISO 8601 with UTC offset) |
Media usage
Where each medium is used.
JSON: daten/screens/medien_verwendung.json · CSV: daten/screens/medien_verwendung.csv
| Field | Format | Values |
|---|---|---|
| quelle | Text (UTF-8) | |
| quelle_id | Identifier (UUID, text) | |
| system_id | Identifier (UUID, text) | |
| bucket | Text (UTF-8) | |
| path | Text (UTF-8) |
Playlist approvals
Approval requests and decisions.
JSON: daten/screens/playlist_freigaben.json · CSV: daten/screens/playlist_freigaben.csv
| Field | Format | Values |
|---|---|---|
| id | Identifier (UUID, text) | |
| system_id | Identifier (UUID, text) | |
| playlist_id | Identifier (UUID, text) | |
| stand | Timestamp (ISO 8601 with UTC offset) | |
| status | Text (UTF-8) | |
| eingereicht_von | Identifier (UUID, text) | |
| eingereicht_am | Timestamp (ISO 8601 with UTC offset) | |
| notiz | Text (UTF-8) | |
| entschieden_von | Identifier (UUID, text) | |
| entschieden_am | Timestamp (ISO 8601 with UTC offset) | |
| kommentar | Text (UTF-8) |
Approval rules
When playlists need approval.
JSON: daten/screens/screen_freigabe_regeln.json · CSV: daten/screens/screen_freigabe_regeln.csv
| Field | Format | Values |
|---|---|---|
| system_id | Identifier (UUID, text) | |
| aktiv | Boolean (true/false) | |
| geaendert_von | Identifier (UUID, text) | |
| geaendert_am | Timestamp (ISO 8601 with UTC offset) |
Approvers
Who may approve playlists.
JSON: daten/screens/screen_freigeber.json · CSV: daten/screens/screen_freigeber.csv
| Field | Format | Values |
|---|---|---|
| system_id | Identifier (UUID, text) | |
| user_id | Identifier (UUID, text) | |
| erstellt_am | Timestamp (ISO 8601 with UTC offset) | |
| id | Identifier (UUID, text) |
Menu products
Product catalogue of the menu boards.
JSON: daten/screens/menue_produkte.json · CSV: daten/screens/menue_produkte.csv
| Field | Format | Values |
|---|---|---|
| id | Identifier (UUID, text) | |
| system_id | Identifier (UUID, text) | |
| kategorie | Text (UTF-8) | |
| name | Text (UTF-8) | |
| beschreibung | Text (UTF-8) | |
| hinweis | Text (UTF-8) | |
| artikelnummer | Text (UTF-8) | |
| bild_id | Identifier (UUID, text) | |
| reihenfolge | Integer | |
| aktiv | Boolean (true/false) | |
| erstellt_am | Timestamp (ISO 8601 with UTC offset) | |
| geaendert_am | Timestamp (ISO 8601 with UTC offset) | |
| bild_zoom | Integer | |
| bild_x | Integer | |
| bild_y | Integer |
Menu categories
Categories of the menu boards.
JSON: daten/screens/menue_kategorien.json · CSV: daten/screens/menue_kategorien.csv
| Field | Format | Values |
|---|---|---|
| id | Identifier (UUID, text) | |
| system_id | Identifier (UUID, text) | |
| schluessel | Text (UTF-8) | |
| titel | Text (UTF-8) | |
| reihenfolge | Integer | |
| erstellt_am | Timestamp (ISO 8601 with UTC offset) |
Menu prices
Prices per location with history.
JSON: daten/screens/menue_preise.json · CSV: daten/screens/menue_preise.csv
| Field | Format | Values |
|---|---|---|
| id | Identifier (UUID, text) | |
| system_id | Identifier (UUID, text) | |
| produkt_id | Identifier (UUID, text) | |
| location_id | Identifier (UUID, text) | |
| preis | Decimal number (dot as decimal separator) | |
| gueltig_ab | Timestamp (ISO 8601 with UTC offset) | |
| quelle | Text (UTF-8) | |
| erstellt_von | Identifier (UUID, text) | |
| erstellt_am | Timestamp (ISO 8601 with UTC offset) | |
| folgt_ebene | Boolean (true/false) |
Menu designs
Designs of the menu boards.
JSON: daten/screens/menue_designs.json · CSV: daten/screens/menue_designs.csv
| Field | Format | Values |
|---|---|---|
| id | Identifier (UUID, text) | |
| system_id | Identifier (UUID, text) | |
| name | Text (UTF-8) | |
| entwurf | JSON (object or list; JSON text in CSV) | |
| aktiv | JSON (object or list; JSON text in CSV) | |
| fassung | Integer | |
| veroeffentlicht_am | Timestamp (ISO 8601 with UTC offset) | |
| erstellt_am | Timestamp (ISO 8601 with UTC offset) | |
| geaendert_am | Timestamp (ISO 8601 with UTC offset) | |
| ist_vorlage | Boolean (true/false) |
Design versions
Earlier versions of the designs.
JSON: daten/screens/menue_design_fassungen.json · CSV: daten/screens/menue_design_fassungen.csv
| Field | Format | Values |
|---|---|---|
| design_id | Identifier (UUID, text) | |
| fassung | Integer | |
| system_id | Identifier (UUID, text) | |
| inhalt | JSON (object or list; JSON text in CSV) | |
| veroeffentlicht_am | Timestamp (ISO 8601 with UTC offset) | |
| veroeffentlicht_von | Identifier (UUID, text) |
Menu fonts
Uploaded fonts.
JSON: daten/screens/menue_schriften.json · CSV: daten/screens/menue_schriften.csv
| Field | Format | Values |
|---|---|---|
| id | Identifier (UUID, text) | |
| system_id | Identifier (UUID, text) | |
| name | Text (UTF-8) | |
| path | Text (UTF-8) | |
| bytes | Integer | |
| erstellt_am | Timestamp (ISO 8601 with UTC offset) |
Menu walls
Which board runs at which location.
JSON: daten/screens/menue_waende.json · CSV: daten/screens/menue_waende.csv
| Field | Format | Values |
|---|---|---|
| location_id | Identifier (UUID, text) | |
| system_id | Identifier (UUID, text) | |
| vorlage | Text (UTF-8) | |
| waehrung | Text (UTF-8) | |
| screen_ids | List (JSON array) of: Identifier (UUID, text) | |
| playlist_ids | List (JSON array) of: Identifier (UUID, text) | |
| fassung | Integer | |
| freigegeben_am | Timestamp (ISO 8601 with UTC offset) | |
| freigegeben_von | Identifier (UUID, text) | |
| erstellt_am | Timestamp (ISO 8601 with UTC offset) | |
| design_id | Identifier (UUID, text) | |
| anzahl | Integer |
Price levels
Price levels of the menu boards.
JSON: daten/screens/menue_preisebenen.json · CSV: daten/screens/menue_preisebenen.csv
| Field | Format | Values |
|---|---|---|
| id | Identifier (UUID, text) | |
| system_id | Identifier (UUID, text) | |
| name | Text (UTF-8) | |
| reihenfolge | Integer | |
| erstellt_am | Timestamp (ISO 8601 with UTC offset) | |
| basis_id | Identifier (UUID, text) | |
| aufschlag_cent | Integer | |
| aufschlag_prozent | Decimal number (dot as decimal separator) | |
| rundung | Text (UTF-8) | |
| geaendert_am | Timestamp (ISO 8601 with UTC offset) |
Prices per level
Prices per price level with history.
JSON: daten/screens/menue_ebenen_preise.json · CSV: daten/screens/menue_ebenen_preise.csv
| Field | Format | Values |
|---|---|---|
| id | Identifier (UUID, text) | |
| system_id | Identifier (UUID, text) | |
| ebene_id | Identifier (UUID, text) | |
| produkt_id | Identifier (UUID, text) | |
| preis | Decimal number (dot as decimal separator) | |
| gueltig_ab | Timestamp (ISO 8601 with UTC offset) | |
| quelle | Text (UTF-8) | |
| erstellt_von | Identifier (UUID, text) | |
| erstellt_am | Timestamp (ISO 8601 with UTC offset) | |
| folgt_regel | Boolean (true/false) |
Price level per location
Which location uses which price level.
JSON: daten/screens/menue_standort_ebenen.json · CSV: daten/screens/menue_standort_ebenen.csv
| Field | Format | Values |
|---|---|---|
| id | Identifier (UUID, text) | |
| system_id | Identifier (UUID, text) | |
| location_id | Identifier (UUID, text) | |
| ebene_id | Identifier (UUID, text) | |
| geaendert_am | Timestamp (ISO 8601 with UTC offset) | |
| geaendert_von | Identifier (UUID, text) |
Logs · 2 Files
Event log
Who did what when (without content); visible to head office only.
JSON: daten/protokoll/ereignisse.json · CSV: daten/protokoll/ereignisse.csv
| Field | Format | Values |
|---|---|---|
| id | Integer | |
| system_id | Identifier (UUID, text) | |
| user_id | Identifier (UUID, text) | |
| action | Text (UTF-8) | |
| entity | Text (UTF-8) | |
| entity_id | Identifier (UUID, text) | |
| created_at | Timestamp (ISO 8601 with UTC offset) | |
| felder | List (JSON array) of: Text (UTF-8) | |
| akteur_rolle | Text (UTF-8) | |
| person_id | Identifier (UUID, text) | |
| location_id | Identifier (UUID, text) |
Change log
Changes to personnel files, pay, documents, permissions and hygiene, as in the app's log.
JSON: daten/protokoll/aenderungen.json · CSV: daten/protokoll/aenderungen.csv
| Field | Format | Values |
|---|---|---|
| id | Integer | |
| zeitpunkt | Timestamp (ISO 8601 with UTC offset) | |
| bereich | Text (UTF-8) | |
| aktion | Text (UTF-8) | |
| felder | List (JSON array) of: Text (UTF-8) | |
| person_id | Identifier (UUID, text) | |
| person_name | Text (UTF-8) | |
| location_id | Identifier (UUID, text) | |
| standort | Text (UTF-8) | |
| akteur_name | Text (UTF-8) | |
| akteur_rolle | Text (UTF-8) | |
| system_name | Text (UTF-8) |
Whistleblowing (designated handlers only) · 2 Files
Reporting channels
Reporting channels the exporting person is designated for.
JSON: daten/hinweise/meldestellen.json · CSV: JSON only
| Field | Format | Values |
|---|---|---|
| id | Identifier (UUID, text) | |
| name | Text (UTF-8) | |
| art | Text (UTF-8) | |
| code | Text (UTF-8) | |
| aktiv | Boolean (true/false) | |
| vertretung_aktiv | Boolean (true/false) | |
| rolle | Text (UTF-8) |
Whistleblowing cases
Cases with messages, history and attachment details; attachments under dateien/hinweise/<case number>/.
JSON: daten/hinweise/faelle.json · CSV: JSON only
| Field | Format | Values |
|---|---|---|
| id | Identifier (UUID, text) | |
| aktenzeichen | Text (UTF-8) | |
| meldestelle_id | Identifier (UUID, text) | |
| meldestelle | Text (UTF-8) | |
| kategorie | Text (UTF-8) | |
| beschreibung | Text (UTF-8) | |
| im_auftrag | Boolean (true/false) | |
| bearbeitende_stelle | Text (UTF-8) | |
| anonym | Boolean (true/false) | |
| kontakt_name | Text (UTF-8) | |
| kontakt | Text (UTF-8) | |
| beziehung | Text (UTF-8) | |
| sprache | Text (UTF-8) | |
| status | Text (UTF-8) | |
| eingegangen_am | Timestamp (ISO 8601 with UTC offset) | |
| bestaetigt_am | Timestamp (ISO 8601 with UTC offset) | |
| rueckmeldung_am | Timestamp (ISO 8601 with UTC offset) | |
| abgeschlossen_am | Timestamp (ISO 8601 with UTC offset) | |
| ergebnis | Text (UTF-8) | |
| aufbewahren_bis | Date (ISO 8601, YYYY-MM-DD) | |
| frist_bestaetigung | Date (ISO 8601, YYYY-MM-DD) | |
| frist_rueckmeldung | Date (ISO 8601, YYYY-MM-DD) | |
| loeschung_ab | Date (ISO 8601, YYYY-MM-DD) | |
| nachrichten | JSON (object or list; JSON text in CSV) | |
| verlauf | JSON (object or list; JSON text in CSV) | |
| anhaenge | JSON (object or list; JSON text in CSV) |
Infrastructure
Where the data is stored and which jurisdiction the infrastructure is subject to (Art. 28 Data Act) is listed under Subprocessors.
