Skip to content

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

FieldFormatValues
idIdentifier (UUID, text)
nameText (UTF-8)
slugText (UTF-8)
primary_colorText (UTF-8)
accent_colorText (UTF-8)
logo_urlText (UTF-8)
created_atTimestamp (ISO 8601 with UTC offset)
secondary_colorText (UTF-8)
aktivBoolean (true/false)
haccp_abschluss_schichtleitungBoolean (true/false)
datenschutz_urlText (UTF-8)
impressum_urlText (UTF-8)
stempel_regelText (UTF-8)
loeschung_vorgemerkt_amTimestamp (ISO 8601 with UTC offset)
loeschung_vorgemerkt_vonIdentifier (UUID, text)
mfa_pflichtBoolean (true/false)
logo_dunkel_urlText (UTF-8)
antwort_emailText (UTF-8)
willkommen_textText (UTF-8)
willkommen_video_urlText (UTF-8)
einladung_texteJSON (object or list; JSON text in CSV)
zertifikat_praefixText (UTF-8)
unterschrift_nameText (UTF-8)
unterschrift_funktionText (UTF-8)
unterschrift_bild_urlText (UTF-8)
begriffeJSON (object or list; JSON text in CSV)
standard_spracheText (UTF-8)
feier_geburtstageBoolean (true/false)
feier_jubilaeenBoolean (true/false)
feed_postenText (UTF-8)
feed_reaktionenList (JSON array) of: Text (UTF-8)
feed_kommentare_standardBoolean (true/false)
haccp_eskalation_stundenInteger
haccp_partner_anpassenBoolean (true/false)

Booked modules

Modules booked for the system.

JSON: daten/organisation/module.json · CSV: daten/organisation/module.csv

FieldFormatValues
system_idIdentifier (UUID, text)
modulEnumerated 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_atTimestamp (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

FieldFormatValues
idIdentifier (UUID, text)
system_idIdentifier (UUID, text)
owner_idIdentifier (UUID, text)
codeText (UTF-8)
nameText (UTF-8)
streetText (UTF-8)
zipText (UTF-8)
cityText (UTF-8)
statusText (UTF-8)
created_atTimestamp (ISO 8601 with UTC offset)
bwa_due_dayInteger
bwa_due_sinceDate (ISO 8601, YYYY-MM-DD)
zeitzoneText (UTF-8)
bundeslandText (UTF-8)
kostenstelleText (UTF-8)
oeffnungstageList (JSON array) of: Integer
stempel_regelText (UTF-8)
stempel_regel_zentraleBoolean (true/false)
haccp_abDate (ISO 8601, YYYY-MM-DD)
spracheText (UTF-8)
landText (UTF-8)
regionenList (JSON array) of: Text (UTF-8)
bild_urlText (UTF-8)
standort_typText (UTF-8)

Closures

Planned closures per location.

JSON: daten/organisation/standort_schliessungen.json · CSV: daten/organisation/standort_schliessungen.csv

FieldFormatValues
idIdentifier (UUID, text)
system_idIdentifier (UUID, text)
location_idIdentifier (UUID, text)
vonDate (ISO 8601, YYYY-MM-DD)
bisDate (ISO 8601, YYYY-MM-DD)
grundText (UTF-8)
erstellt_vonIdentifier (UUID, text)
erstellt_amTimestamp (ISO 8601 with UTC offset)

Location labels

Labels assigned to locations.

JSON: daten/organisation/standort_label.json · CSV: daten/organisation/standort_label.csv

FieldFormatValues
location_idIdentifier (UUID, text)
label_idIdentifier (UUID, text)
system_idIdentifier (UUID, text)
created_atTimestamp (ISO 8601 with UTC offset)

Location awards

Awards per location and period.

JSON: daten/organisation/standort_auszeichnungen.json · CSV: daten/organisation/standort_auszeichnungen.csv

FieldFormatValues
idIdentifier (UUID, text)
system_idIdentifier (UUID, text)
location_idIdentifier (UUID, text)
periodText (UTF-8)
titleText (UTF-8)
granted_atTimestamp (ISO 8601 with UTC offset)
standort_nameText (UTF-8)

Departments

Areas such as kitchen or service.

JSON: daten/organisation/abteilungen.json · CSV: daten/organisation/abteilungen.csv

FieldFormatValues
idIdentifier (UUID, text)
system_idIdentifier (UUID, text)
nameText (UTF-8)
sort_orderInteger
created_atTimestamp (ISO 8601 with UTC offset)
location_idIdentifier (UUID, text)

Public holidays

Holiday calendar of the system.

JSON: daten/organisation/feiertage.json · CSV: daten/organisation/feiertage.csv

FieldFormatValues
idIdentifier (UUID, text)
system_idIdentifier (UUID, text)
bundeslandText (UTF-8)
datumDate (ISO 8601, YYYY-MM-DD)
nameText (UTF-8)
klasseText (UTF-8)
created_byIdentifier (UUID, text)
created_atTimestamp (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

FieldFormatValues
idIdentifier (UUID, text)
system_idIdentifier (UUID, text)
full_nameText (UTF-8)
roleEnumerated value (text, see values)zentrale, multi_unit_partner, partner, schichtleitung, mitarbeiter
localeText (UTF-8)
avatar_urlText (UTF-8)
created_atTimestamp (ISO 8601 with UTC offset)
stempeltBoolean (true/false)
gesperrtBoolean (true/false)
darf_erfassungspflichtBoolean (true/false)
farbschemaText (UTF-8)

Phone numbers

Stored phone numbers of the visible people.

JSON: daten/organisation/personen_telefon.json · CSV: daten/organisation/personen_telefon.csv

FieldFormatValues
idIdentifier (UUID, text)
phoneText (UTF-8)

Location membership

Which person belongs to which location.

JSON: daten/organisation/standort_zugehoerigkeit.json · CSV: daten/organisation/standort_zugehoerigkeit.csv

FieldFormatValues
location_idIdentifier (UUID, text)
user_idIdentifier (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

FieldFormatValues
user_idIdentifier (UUID, text)
moduleEnumerated value (text, see values)feed, handbuch, academy, chat, dienstplan, bwa, partnerakte, cockpit, redaktion, onboarding, vorhaben, bestellen, audits, fruehwarnung, newsletter, screens, formulare, haccp, compliance, inventur
grantedBoolean (true/false)
set_byIdentifier (UUID, text)
set_atTimestamp (ISO 8601 with UTC offset)
gilt_bisDate (ISO 8601, YYYY-MM-DD)
stufeText (UTF-8)
vorlage_idIdentifier (UUID, text)

Custom roles

Role templates with base role, version and status (on/off).

JSON: daten/organisation/rollen.json · CSV: daten/organisation/rollen.csv

FieldFormatValues
idIdentifier (UUID, text)
system_idIdentifier (UUID, text)
bereichText (UTF-8)
besitzer_idIdentifier (UUID, text)
nameText (UTF-8)
beschreibungText (UTF-8)
grundrolleEnumerated value (text, see values)zentrale, multi_unit_partner, partner, schichtleitung, mitarbeiter
aktivBoolean (true/false)
fassungInteger
erstellt_vonIdentifier (UUID, text)
erstellt_amTimestamp (ISO 8601 with UTC offset)
geaendert_vonIdentifier (UUID, text)
geaendert_amTimestamp (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

FieldFormatValues
idIdentifier (UUID, text)
vorlage_idIdentifier (UUID, text)
system_idIdentifier (UUID, text)
modulEnumerated value (text, see values)feed, handbuch, academy, chat, dienstplan, bwa, partnerakte, cockpit, redaktion, onboarding, vorhaben, bestellen, audits, fruehwarnung, newsletter, screens, formulare, haccp, compliance, inventur
stufeText (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

FieldFormatValues
idIdentifier (UUID, text)
system_idIdentifier (UUID, text)
user_idIdentifier (UUID, text)
vorlage_idIdentifier (UUID, text)
quelleText (UTF-8)
regel_idIdentifier (UUID, text)
fassungInteger
zugewiesen_vonIdentifier (UUID, text)
zugewiesen_amTimestamp (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

FieldFormatValues
idIdentifier (UUID, text)
system_idIdentifier (UUID, text)
vorlage_idIdentifier (UUID, text)
taetigkeitText (UTF-8)
location_idIdentifier (UUID, text)
abteilung_idIdentifier (UUID, text)
aktivBoolean (true/false)
reihenfolgeInteger
erstellt_vonIdentifier (UUID, text)
erstellt_amTimestamp (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

FieldFormatValues
system_idIdentifier (UUID, text)
berichtslinie_zugriffBoolean (true/false)
geaendert_vonIdentifier (UUID, text)
geaendert_amTimestamp (ISO 8601 with UTC offset)

Field support

Responsible field managers per location.

JSON: daten/organisation/betreuung.json · CSV: daten/organisation/betreuung.csv

FieldFormatValues
location_idIdentifier (UUID, text)
system_idIdentifier (UUID, text)
user_idIdentifier (UUID, text)
set_atTimestamp (ISO 8601 with UTC offset)

Reporting lines

Org chart: who reports to whom.

JSON: daten/organisation/berichtslinien.json · CSV: daten/organisation/berichtslinien.csv

FieldFormatValues
idIdentifier (UUID, text)
system_idIdentifier (UUID, text)
location_idIdentifier (UUID, text)
user_idIdentifier (UUID, text)
fuehrung_idIdentifier (UUID, text)
artText (UTF-8)
erstellt_vonIdentifier (UUID, text)
erstellt_amTimestamp (ISO 8601 with UTC offset)

Invitations

Sent invitations (without invitation code).

JSON: daten/organisation/einladungen.json · CSV: daten/organisation/einladungen.csv

FieldFormatValues
idIdentifier (UUID, text)
system_idIdentifier (UUID, text)
emailText (UTF-8)
full_nameText (UTF-8)
roleEnumerated value (text, see values)zentrale, multi_unit_partner, partner, schichtleitung, mitarbeiter
location_idIdentifier (UUID, text)
created_byIdentifier (UUID, text)
accepted_atTimestamp (ISO 8601 with UTC offset)
expires_atTimestamp (ISO 8601 with UTC offset)
created_atTimestamp (ISO 8601 with UTC offset)
akteJSON (object or list; JSON text in CSV)
verguetungJSON (object or list; JSON text in CSV)
personalfragebogenBoolean (true/false)
arbeitgeber_einladungBoolean (true/false)
spracheText (UTF-8)
weitere_standorteList (JSON array) of: Identifier (UUID, text)
zuletzt_gesendetTimestamp (ISO 8601 with UTC offset)
erinnerungenInteger
erinnert_amTimestamp (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

FieldFormatValues
system_idIdentifier (UUID, text)
landText (UTF-8)
pause_schwelle_1Integer
pause_dauer_1Integer
pause_schwelle_2Integer
pause_dauer_2Integer
max_arbeitszeitInteger
min_ruhezeitInteger
pause_automatischBoolean (true/false)
aktualisiert_amTimestamp (ISO 8601 with UTC offset)
max_wochenarbeitszeitInteger
ausgleich_wochenInteger
min_freie_sonntage_jahrInteger
ruhezeit_gastro_verkuerztBoolean (true/false)
nachtarbeit_vonTime of day (HH:MM:SS, local time of the location)
nachtarbeit_bisTime of day (HH:MM:SS, local time of the location)
warnstufeText (UTF-8)
personalquote_gelbDecimal number (dot as decimal separator)
personalquote_rotDecimal number (dot as decimal separator)
urlaub_uebertrag_automatischBoolean (true/false)
urlaub_uebertrag_maxDecimal number (dot as decimal separator)
ueberstunden_grenzeDecimal number (dot as decimal separator)
urlaub_kuerzung_elternzeitBoolean (true/false)
urlaub_bonus_stufenJSON (object or list; JSON text in CSV)
urlaub_probezeit_maxDecimal number (dot as decimal separator)
pause_mindestblockInteger
verstoesse_bestaetigenBoolean (true/false)
zeiten_selbst_nachtragenBoolean (true/false)
nachtragen_max_tageInteger
urlaub_rundungText (UTF-8)
urlaub_ansammlungBoolean (true/false)
urlaub_ansammlung_grenzeText (UTF-8)
urlaub_mehrurlaub_verfallBoolean (true/false)
projektzeitenBoolean (true/false)

Surcharge rules

Surcharges for Sundays, holidays and nights.

JSON: daten/organisation/zuschlagsregeln.json · CSV: daten/organisation/zuschlagsregeln.csv

FieldFormatValues
idIdentifier (UUID, text)
system_idIdentifier (UUID, text)
artText (UTF-8)
prozentDecimal number (dot as decimal separator)
steuerfreiBoolean (true/false)
gilt_abDate (ISO 8601, YYYY-MM-DD)
aktivBoolean (true/false)

Notifications

Stored updates on own requests and reminders.

JSON: daten/organisation/benachrichtigungen.json · CSV: daten/organisation/benachrichtigungen.csv

FieldFormatValues
idIdentifier (UUID, text)
system_idIdentifier (UUID, text)
user_idIdentifier (UUID, text)
artText (UTF-8)
bezug_idIdentifier (UUID, text)
datenJSON (object or list; JSON text in CSV)
erstellt_amTimestamp (ISO 8601 with UTC offset)
gelesen_amTimestamp (ISO 8601 with UTC offset)
verworfen_amTimestamp (ISO 8601 with UTC offset)

Notification settings

Notification types switched off.

JSON: daten/organisation/benachrichtigung_einstellungen.json · CSV: daten/organisation/benachrichtigung_einstellungen.csv

FieldFormatValues
user_idIdentifier (UUID, text)
kategorieText (UTF-8)
seitTimestamp (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

FieldFormatValues
user_idIdentifier (UUID, text)
kategorieText (UTF-8)
seitTimestamp (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

FieldFormatValues
system_idIdentifier (UUID, text)
ruhe_anBoolean (true/false)
ruhe_vonInteger
ruhe_bisInteger
rollen_ausJSON (object or list; JSON text in CSV)
geaendert_vonIdentifier (UUID, text)
geaendert_amTimestamp (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

FieldFormatValues
system_idIdentifier (UUID, text)
artText (UTF-8)
anBoolean (true/false)
fristInteger
schwereInteger
rollenList (JSON array) of: Text (UTF-8)
geaendert_vonIdentifier (UUID, text)
geaendert_amTimestamp (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

FieldFormatValues
idIdentifier (UUID, text)
system_idIdentifier (UUID, text)
user_idIdentifier (UUID, text)
nameText (UTF-8)
praefixText (UTF-8)
bereicheList (JSON array) of: Text (UTF-8)
erstellt_amTimestamp (ISO 8601 with UTC offset)
laeuft_ab_amTimestamp (ISO 8601 with UTC offset)
widerrufen_amTimestamp (ISO 8601 with UTC offset)
widerrufen_vonIdentifier (UUID, text)
letzte_nutzung_amTimestamp (ISO 8601 with UTC offset)
letzte_ressourceText (UTF-8)
nutzungenInteger

Webhooks

Own webhook subscriptions with address, events and state – without the secret.

JSON: daten/organisation/api_webhooks.json · CSV: daten/organisation/api_webhooks.csv

FieldFormatValues
idIdentifier (UUID, text)
system_idIdentifier (UUID, text)
user_idIdentifier (UUID, text)
schluessel_idIdentifier (UUID, text)
nameText (UTF-8)
urlText (UTF-8)
ereignisseList (JSON array) of: Text (UTF-8)
aktivBoolean (true/false)
erstellt_amTimestamp (ISO 8601 with UTC offset)
letzte_zustellung_amTimestamp (ISO 8601 with UTC offset)
letzter_statusInteger
fehler_in_folgeInteger
pausiert_amTimestamp (ISO 8601 with UTC offset)
pausiert_grundText (UTF-8)

Dismissed news

Dismissed “New in Symiko” notes.

JSON: daten/organisation/neuigkeiten_gelesen.json · CSV: daten/organisation/neuigkeiten_gelesen.csv

FieldFormatValues
user_idIdentifier (UUID, text)
neuigkeitText (UTF-8)
gelesen_amTimestamp (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

FieldFormatValues
idIdentifier (UUID, text)
system_idIdentifier (UUID, text)
author_idIdentifier (UUID, text)
kindEnumerated value (text, see values)beitrag, story
titleText (UTF-8)
bodyText (UTF-8)
is_mandatoryBoolean (true/false)
expires_atTimestamp (ISO 8601 with UTC offset)
published_atTimestamp (ISO 8601 with UTC offset)
created_atTimestamp (ISO 8601 with UTC offset)
mediaJSON (object or list; JSON text in CSV)
target_rolesList (JSON array) of: Enumerated value (text, see values)zentrale, multi_unit_partner, partner, schichtleitung, mitarbeiter
comments_enabledBoolean (true/false)
versionInteger
edited_atTimestamp (ISO 8601 with UTC offset)
edited_byIdentifier (UUID, text)
withdrawn_atTimestamp (ISO 8601 with UTC offset)
withdrawn_byIdentifier (UUID, text)
replaces_idIdentifier (UUID, text)
shared_post_idIdentifier (UUID, text)
location_idIdentifier (UUID, text)
ack_due_atTimestamp (ISO 8601 with UTC offset)
ziel_standorteList (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

FieldFormatValues
idIdentifier (UUID, text)
system_idIdentifier (UUID, text)
post_idIdentifier (UUID, text)
versionInteger
alter_titelText (UTF-8)
alter_textText (UTF-8)
alte_medienJSON (object or list; JSON text in CSV)
ersetzter_beitragIdentifier (UUID, text)
bestaetigungenInteger
geaendert_vonIdentifier (UUID, text)
geaendert_amTimestamp (ISO 8601 with UTC offset)

Acknowledgements

Acknowledgements of mandatory notices.

JSON: daten/kommunikation/beitrag_bestaetigungen.json · CSV: daten/kommunikation/beitrag_bestaetigungen.csv

FieldFormatValues
post_idIdentifier (UUID, text)
user_idIdentifier (UUID, text)
location_idIdentifier (UUID, text)
acknowledged_atTimestamp (ISO 8601 with UTC offset)
standorteList (JSON array) of: Identifier (UUID, text)
fassungInteger

Comments

Comments on posts.

JSON: daten/kommunikation/kommentare.json · CSV: daten/kommunikation/kommentare.csv

FieldFormatValues
idIdentifier (UUID, text)
post_idIdentifier (UUID, text)
author_idIdentifier (UUID, text)
bodyText (UTF-8)
hiddenBoolean (true/false)
created_atTimestamp (ISO 8601 with UTC offset)
hidden_byIdentifier (UUID, text)

Comment reviews

Review status of comments.

JSON: daten/kommunikation/kommentar_pruefungen.json · CSV: daten/kommunikation/kommentar_pruefungen.csv

FieldFormatValues
comment_idIdentifier (UUID, text)
system_idIdentifier (UUID, text)
reviewed_byIdentifier (UUID, text)
reviewed_atTimestamp (ISO 8601 with UTC offset)

Bookmarks

Own saved posts.

JSON: daten/kommunikation/lesezeichen.json · CSV: daten/kommunikation/lesezeichen.csv

FieldFormatValues
post_idIdentifier (UUID, text)
user_idIdentifier (UUID, text)
created_atTimestamp (ISO 8601 with UTC offset)

Reactions

Own reactions to posts.

JSON: daten/kommunikation/reaktionen.json · CSV: daten/kommunikation/reaktionen.csv

FieldFormatValues
idIdentifier (UUID, text)
post_idIdentifier (UUID, text)
user_idIdentifier (UUID, text)
system_idIdentifier (UUID, text)
reaktionText (UTF-8)
erstellt_amTimestamp (ISO 8601 with UTC offset)

Polls

Polls in the feed.

JSON: daten/kommunikation/umfragen.json · CSV: daten/kommunikation/umfragen.csv

FieldFormatValues
idIdentifier (UUID, text)
system_idIdentifier (UUID, text)
questionText (UTF-8)
descriptionText (UTF-8)
deadlineTimestamp (ISO 8601 with UTC offset)
namentlichBoolean (true/false)
target_rolesList (JSON array) of: Enumerated value (text, see values)zentrale, multi_unit_partner, partner, schichtleitung, mitarbeiter
created_byIdentifier (UUID, text)
created_atTimestamp (ISO 8601 with UTC offset)
ergebnis_sichtbarBoolean (true/false)

Poll options

Options of the polls.

JSON: daten/kommunikation/umfrage_optionen.json · CSV: daten/kommunikation/umfrage_optionen.csv

FieldFormatValues
idIdentifier (UUID, text)
poll_idIdentifier (UUID, text)
system_idIdentifier (UUID, text)
labelText (UTF-8)
positionInteger

Votes

Votes cast, as far as visible.

JSON: daten/kommunikation/umfrage_stimmen.json · CSV: daten/kommunikation/umfrage_stimmen.csv

FieldFormatValues
poll_idIdentifier (UUID, text)
option_idIdentifier (UUID, text)
system_idIdentifier (UUID, text)
user_idIdentifier (UUID, text)
created_atTimestamp (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

FieldFormatValues
idIdentifier (UUID, text)
system_idIdentifier (UUID, text)
kindEnumerated value (text, see values)direkt, gruppe, broadcast, standort, leitung
nameText (UTF-8)
topicText (UTF-8)
created_byIdentifier (UUID, text)
created_atTimestamp (ISO 8601 with UTC offset)
location_idIdentifier (UUID, text)
automatischBoolean (true/false)
dm_keyText (UTF-8)

Chat members

Who is in which channel.

JSON: daten/kommunikation/chat_mitglieder.json · CSV: daten/kommunikation/chat_mitglieder.csv

FieldFormatValues
channel_idIdentifier (UUID, text)
user_idIdentifier (UUID, text)
last_read_atTimestamp (ISO 8601 with UTC offset)
stummBoolean (true/false)

Chat messages

Messages in visible channels; attachments under dateien/chat/.

JSON: daten/kommunikation/chat_nachrichten.json · CSV: daten/kommunikation/chat_nachrichten.csv

FieldFormatValues
idIdentifier (UUID, text)
channel_idIdentifier (UUID, text)
author_idIdentifier (UUID, text)
bodyText (UTF-8)
media_urlText (UTF-8)
created_atTimestamp (ISO 8601 with UTC offset)
reply_toIdentifier (UUID, text)
anhangText (UTF-8)
edited_atTimestamp (ISO 8601 with UTC offset)
deleted_atTimestamp (ISO 8601 with UTC offset)
post_idIdentifier (UUID, text)
anhang_begleittextBoolean (true/false)

Message revisions

Earlier texts of edited messages.

JSON: daten/kommunikation/chat_nachricht_fassungen.json · CSV: daten/kommunikation/chat_nachricht_fassungen.csv

FieldFormatValues
idIdentifier (UUID, text)
message_idIdentifier (UUID, text)
alter_textText (UTF-8)
geaendert_vonIdentifier (UUID, text)
geaendert_amTimestamp (ISO 8601 with UTC offset)

Reactions

Reactions to messages.

JSON: daten/kommunikation/chat_reaktionen.json · CSV: daten/kommunikation/chat_reaktionen.csv

FieldFormatValues
message_idIdentifier (UUID, text)
user_idIdentifier (UUID, text)
emojiText (UTF-8)
created_atTimestamp (ISO 8601 with UTC offset)

Mentions

Mentions in messages.

JSON: daten/kommunikation/chat_erwaehnungen.json · CSV: daten/kommunikation/chat_erwaehnungen.csv

FieldFormatValues
message_idIdentifier (UUID, text)
user_idIdentifier (UUID, text)

Newsletters

Sent and planned newsletters.

JSON: daten/kommunikation/newsletter.json · CSV: daten/kommunikation/newsletter.csv

FieldFormatValues
idIdentifier (UUID, text)
system_idIdentifier (UUID, text)
titelText (UTF-8)
inhaltText (UTF-8)
zielgruppeText (UTF-8)
statusText (UTF-8)
versendet_amTimestamp (ISO 8601 with UTC offset)
created_byIdentifier (UUID, text)
created_atTimestamp (ISO 8601 with UTC offset)
liste_idIdentifier (UUID, text)
fassungInteger

Newsletter recipients

Delivery per recipient.

JSON: daten/kommunikation/newsletter_empfaenger.json · CSV: daten/kommunikation/newsletter_empfaenger.csv

FieldFormatValues
idIdentifier (UUID, text)
rundbrief_idIdentifier (UUID, text)
system_idIdentifier (UUID, text)
user_idIdentifier (UUID, text)
emailText (UTF-8)
statusText (UTF-8)
fehlerText (UTF-8)
created_atTimestamp (ISO 8601 with UTC offset)
reserviert_amTimestamp (ISO 8601 with UTC offset)

Newsletter lists

External recipient lists.

JSON: daten/kommunikation/newsletter_listen.json · CSV: daten/kommunikation/newsletter_listen.csv

FieldFormatValues
idIdentifier (UUID, text)
system_idIdentifier (UUID, text)
nameText (UTF-8)
created_atTimestamp (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

FieldFormatValues
idIdentifier (UUID, text)
system_idIdentifier (UUID, text)
liste_idIdentifier (UUID, text)
emailText (UTF-8)
nameText (UTF-8)
statusText (UTF-8)
quelleText (UTF-8)
einwilligungText (UTF-8)
doi_gesendet_amTimestamp (ISO 8601 with UTC offset)
bestaetigt_amTimestamp (ISO 8601 with UTC offset)
abgemeldet_amTimestamp (ISO 8601 with UTC offset)
created_atTimestamp (ISO 8601 with UTC offset)

Forms

Public forms with fields.

JSON: daten/kommunikation/formulare.json · CSV: daten/kommunikation/formulare.csv

FieldFormatValues
idIdentifier (UUID, text)
system_idIdentifier (UUID, text)
codeText (UTF-8)
nameText (UTF-8)
titelText (UTF-8)
beschreibungText (UTF-8)
knopfText (UTF-8)
dankeText (UTF-8)
felderJSON (object or list; JSON text in CSV)
liste_idIdentifier (UUID, text)
aktivBoolean (true/false)
created_atTimestamp (ISO 8601 with UTC offset)

Form entries

Submitted form data.

JSON: daten/kommunikation/formular_eintraege.json · CSV: daten/kommunikation/formular_eintraege.csv

FieldFormatValues
idIdentifier (UUID, text)
formular_idIdentifier (UUID, text)
system_idIdentifier (UUID, text)
datenJSON (object or list; JSON text in CSV)
quelleText (UTF-8)
created_atTimestamp (ISO 8601 with UTC offset)

Blocked contacts

Own blocks in chat.

JSON: daten/kommunikation/chat_blockierungen.json · CSV: daten/kommunikation/chat_blockierungen.csv

FieldFormatValues
user_idIdentifier (UUID, text)
blockiert_idIdentifier (UUID, text)
system_idIdentifier (UUID, text)
created_atTimestamp (ISO 8601 with UTC offset)

Content reports

Reported content (DSA), as far as visible.

JSON: daten/kommunikation/inhaltsmeldungen.json · CSV: daten/kommunikation/inhaltsmeldungen.csv

FieldFormatValues
idIdentifier (UUID, text)
system_idIdentifier (UUID, text)
melder_idIdentifier (UUID, text)
nachricht_idIdentifier (UUID, text)
kommentar_idIdentifier (UUID, text)
grundText (UTF-8)
hinweisText (UTF-8)
statusText (UTF-8)
entschieden_vonIdentifier (UUID, text)
entschieden_amTimestamp (ISO 8601 with UTC offset)
created_atTimestamp (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

FieldFormatValues
idIdentifier (UUID, text)
system_idIdentifier (UUID, text)
parent_idIdentifier (UUID, text)
numberText (UTF-8)
titleText (UTF-8)
bodyText (UTF-8)
versionInteger
sort_orderInteger
requires_ackBoolean (true/false)
published_atTimestamp (ISO 8601 with UTC offset)
updated_atTimestamp (ISO 8601 with UTC offset)
created_atTimestamp (ISO 8601 with UTC offset)
languageText (UTF-8)
translation_ofIdentifier (UUID, text)
body_formatText (UTF-8)
pdf_pathText (UTF-8)
updated_byIdentifier (UUID, text)
source_urlText (UTF-8)
imported_atTimestamp (ISO 8601 with UTC offset)
target_rolesList (JSON array) of: Enumerated value (text, see values)zentrale, multi_unit_partner, partner, schichtleitung, mitarbeiter
ack_due_atTimestamp (ISO 8601 with UTC offset)
review_due_atDate (ISO 8601, YYYY-MM-DD)
reviewed_atTimestamp (ISO 8601 with UTC offset)
is_emergencyBoolean (true/false)
course_idIdentifier (UUID, text)
nda_pflichtBoolean (true/false)

Chapter versions

Earlier versions of chapters.

JSON: daten/handbuch/kapitel_fassungen.json · CSV: daten/handbuch/kapitel_fassungen.csv

FieldFormatValues
idIdentifier (UUID, text)
chapter_idIdentifier (UUID, text)
system_idIdentifier (UUID, text)
versionInteger
numberText (UTF-8)
titleText (UTF-8)
bodyText (UTF-8)
body_formatText (UTF-8)
languageText (UTF-8)
pdf_pathText (UTF-8)
requires_ackBoolean (true/false)
changed_byIdentifier (UUID, text)
changed_atTimestamp (ISO 8601 with UTC offset)
noteText (UTF-8)

Acknowledgements

Current acknowledgements per chapter and person.

JSON: daten/handbuch/kenntnisnahmen.json · CSV: daten/handbuch/kenntnisnahmen.csv

FieldFormatValues
chapter_idIdentifier (UUID, text)
user_idIdentifier (UUID, text)
acknowledged_atTimestamp (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

FieldFormatValues
idIdentifier (UUID, text)
system_idIdentifier (UUID, text)
chapter_idIdentifier (UUID, text)
user_idIdentifier (UUID, text)
versionInteger
chapter_updated_atTimestamp (ISO 8601 with UTC offset)
languageText (UTF-8)
bestaetigt_ueberIdentifier (UUID, text)
acknowledged_atTimestamp (ISO 8601 with UTC offset)

Handbook receipts

Receipts for the whole handbook.

JSON: daten/handbuch/quittungen.json · CSV: daten/handbuch/quittungen.csv

FieldFormatValues
idIdentifier (UUID, text)
system_idIdentifier (UUID, text)
user_idIdentifier (UUID, text)
confirmed_atTimestamp (ISO 8601 with UTC offset)
chapter_countInteger
snapshotJSON (object or list; JSON text in CSV)
noteText (UTF-8)

Glossary

Terms and definitions.

JSON: daten/handbuch/glossar.json · CSV: daten/handbuch/glossar.csv

FieldFormatValues
idIdentifier (UUID, text)
system_idIdentifier (UUID, text)
termText (UTF-8)
definitionText (UTF-8)
created_atTimestamp (ISO 8601 with UTC offset)
updated_atTimestamp (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

FieldFormatValues
idIdentifier (UUID, text)
system_idIdentifier (UUID, text)
titleText (UTF-8)
sort_orderInteger
created_atTimestamp (ISO 8601 with UTC offset)

Courses

Courses with audience, pass mark and validity.

JSON: daten/academy/kurse.json · CSV: daten/academy/kurse.csv

FieldFormatValues
idIdentifier (UUID, text)
system_idIdentifier (UUID, text)
titleText (UTF-8)
descriptionText (UTF-8)
video_urlText (UTF-8)
duration_secondsInteger
target_rolesList (JSON array) of: Enumerated value (text, see values)zentrale, multi_unit_partner, partner, schichtleitung, mitarbeiter
sort_orderInteger
published_atTimestamp (ISO 8601 with UTC offset)
created_atTimestamp (ISO 8601 with UTC offset)
topic_idIdentifier (UUID, text)
valid_monthsInteger
is_mandatoryBoolean (true/false)
pass_percentInteger
quiz_countInteger
haccp_nachweisText (UTF-8)
frist_tageInteger

Course modules

Lessons of the courses (text, video, chapter link).

JSON: daten/academy/kurs_module.json · CSV: daten/academy/kurs_module.csv

FieldFormatValues
idIdentifier (UUID, text)
course_idIdentifier (UUID, text)
titleText (UTF-8)
kindText (UTF-8)
video_urlText (UTF-8)
bodyText (UTF-8)
chapter_idIdentifier (UUID, text)
duration_secondsInteger
sort_orderInteger
created_atTimestamp (ISO 8601 with UTC offset)
body_formatText (UTF-8)

Quiz questions

Questions and answer options.

JSON: daten/academy/kurs_fragen.json · CSV: daten/academy/kurs_fragen.csv

FieldFormatValues
idIdentifier (UUID, text)
course_idIdentifier (UUID, text)
questionText (UTF-8)
optionsJSON (object or list; JSON text in CSV)
sort_orderInteger
pointsInteger
multipleBoolean (true/false)
created_atTimestamp (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

FieldFormatValues
question_idIdentifier (UUID, text)
correct_indexesList (JSON array) of: Integer

Course completions

Results, certificates and validity.

JSON: daten/academy/kursabschluesse.json · CSV: daten/academy/kursabschluesse.csv

FieldFormatValues
course_idIdentifier (UUID, text)
user_idIdentifier (UUID, text)
scoreInteger
passedBoolean (true/false)
completed_atTimestamp (ISO 8601 with UTC offset)
cert_noInteger
valid_untilTimestamp (ISO 8601 with UTC offset)
cert_codeText (UTF-8)
kurs_titelText (UTF-8)
cert_praefixText (UTF-8)

Learning progress

Completed course modules.

JSON: daten/academy/lernfortschritt.json · CSV: daten/academy/lernfortschritt.csv

FieldFormatValues
module_idIdentifier (UUID, text)
user_idIdentifier (UUID, text)
done_atTimestamp (ISO 8601 with UTC offset)

Learning paths

Learning paths of the system.

JSON: daten/academy/lernpfade.json · CSV: daten/academy/lernpfade.csv

FieldFormatValues
idIdentifier (UUID, text)
system_idIdentifier (UUID, text)
titleText (UTF-8)
descriptionText (UTF-8)
sort_orderInteger
created_atTimestamp (ISO 8601 with UTC offset)
published_atTimestamp (ISO 8601 with UTC offset)

Path stages

Stages of the learning paths.

JSON: daten/academy/lernpfad_stufen.json · CSV: daten/academy/lernpfad_stufen.csv

FieldFormatValues
idIdentifier (UUID, text)
path_idIdentifier (UUID, text)
titleText (UTF-8)
sort_orderInteger
created_atTimestamp (ISO 8601 with UTC offset)

Path stage courses

Courses per stage.

JSON: daten/academy/lernpfad_kurse.json · CSV: daten/academy/lernpfad_kurse.csv

FieldFormatValues
stage_idIdentifier (UUID, text)
course_idIdentifier (UUID, text)

Points

Points ledger.

JSON: daten/academy/punkte.json · CSV: daten/academy/punkte.csv

FieldFormatValues
idIdentifier (UUID, text)
system_idIdentifier (UUID, text)
user_idIdentifier (UUID, text)
pointsInteger
reasonText (UTF-8)
ref_idIdentifier (UUID, text)
created_atTimestamp (ISO 8601 with UTC offset)

Awards

Awarded medals.

JSON: daten/academy/auszeichnungen.json · CSV: daten/academy/auszeichnungen.csv

FieldFormatValues
idIdentifier (UUID, text)
system_idIdentifier (UUID, text)
user_idIdentifier (UUID, text)
kindText (UTF-8)
keyText (UTF-8)
titleText (UTF-8)
granted_atTimestamp (ISO 8601 with UTC offset)

Qualification types

Types of qualifications and requirements.

JSON: daten/academy/nachweisarten.json · CSV: daten/academy/nachweisarten.csv

FieldFormatValues
idIdentifier (UUID, text)
system_idIdentifier (UUID, text)
nameText (UTF-8)
beschreibungText (UTF-8)
gueltig_monateInteger
quelleText (UTF-8)
course_idIdentifier (UUID, text)
pflicht_rollenList (JSON array) of: Enumerated value (text, see values)zentrale, multi_unit_partner, partner, schichtleitung, mitarbeiter
mindestens_je_standortInteger
je_schichtBoolean (true/false)
standard_keyText (UTF-8)
aktivBoolean (true/false)
reihenfolgeInteger
created_atTimestamp (ISO 8601 with UTC offset)
updated_atTimestamp (ISO 8601 with UTC offset)
vorlage_schluesselText (UTF-8)
punkt_schluesselText (UTF-8)
vorlage_versionText (UTF-8)
vorlauf_tageInteger

Qualifications

Qualification records of people (without costs).

JSON: daten/academy/nachweise.json · CSV: daten/academy/nachweise.csv

FieldFormatValues
idIdentifier (UUID, text)
system_idIdentifier (UUID, text)
user_idIdentifier (UUID, text)
type_idIdentifier (UUID, text)
location_idIdentifier (UUID, text)
erworben_amDate (ISO 8601, YYYY-MM-DD)
gueltig_bisDate (ISO 8601, YYYY-MM-DD)
ausstellerText (UTF-8)
notizText (UTF-8)
document_idIdentifier (UUID, text)
herkunftText (UTF-8)
session_idIdentifier (UUID, text)
pruefstatusText (UTF-8)
geprueft_vonIdentifier (UUID, text)
geprueft_amTimestamp (ISO 8601 with UTC offset)
ablehnungsgrundText (UTF-8)
created_byIdentifier (UUID, text)
created_atTimestamp (ISO 8601 with UTC offset)

Training sessions

In-person training sessions.

JSON: daten/academy/schulungstermine.json · CSV: daten/academy/schulungstermine.csv

FieldFormatValues
idIdentifier (UUID, text)
system_idIdentifier (UUID, text)
location_idIdentifier (UUID, text)
titelText (UTF-8)
beschreibungText (UTF-8)
ortText (UTF-8)
beginnTimestamp (ISO 8601 with UTC offset)
endeTimestamp (ISO 8601 with UTC offset)
kapazitaetInteger
type_idIdentifier (UUID, text)
course_idIdentifier (UUID, text)
selbsteinschreibungBoolean (true/false)
anmeldeschlussTimestamp (ISO 8601 with UTC offset)
abgesagt_amTimestamp (ISO 8601 with UTC offset)
erstellt_vonIdentifier (UUID, text)
created_atTimestamp (ISO 8601 with UTC offset)

Training enrolments

Enrolments and attendance.

JSON: daten/academy/schulungsanmeldungen.json · CSV: daten/academy/schulungsanmeldungen.csv

FieldFormatValues
session_idIdentifier (UUID, text)
user_idIdentifier (UUID, text)
system_idIdentifier (UUID, text)
statusText (UTF-8)
eingeladen_vonIdentifier (UUID, text)
geaendert_amTimestamp (ISO 8601 with UTC offset)
anwesenheit_vonIdentifier (UUID, text)
anwesenheit_amTimestamp (ISO 8601 with UTC offset)
record_idIdentifier (UUID, text)
created_atTimestamp (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

FieldFormatValues
idIdentifier (UUID, text)
system_idIdentifier (UUID, text)
location_idIdentifier (UUID, text)
user_idIdentifier (UUID, text)
starts_atTimestamp (ISO 8601 with UTC offset)
ends_atTimestamp (ISO 8601 with UTC offset)
role_labelText (UTF-8)
statusText (UTF-8)
created_byIdentifier (UUID, text)
created_atTimestamp (ISO 8601 with UTC offset)
department_idIdentifier (UUID, text)

Shift templates

Weekly templates per location.

JSON: daten/dienstplan/schicht_vorlagen.json · CSV: daten/dienstplan/schicht_vorlagen.csv

FieldFormatValues
idIdentifier (UUID, text)
system_idIdentifier (UUID, text)
location_idIdentifier (UUID, text)
nameText (UTF-8)
created_byIdentifier (UUID, text)
created_atTimestamp (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

FieldFormatValues
idIdentifier (UUID, text)
template_idIdentifier (UUID, text)
system_idIdentifier (UUID, text)
weekdayInteger
starts_atTime of day (HH:MM:SS, local time of the location)
ends_atTime of day (HH:MM:SS, local time of the location)
department_idIdentifier (UUID, text)
role_labelText (UTF-8)
user_idIdentifier (UUID, text)

Rota publications

Published weeks.

JSON: daten/dienstplan/veroeffentlichungen.json · CSV: daten/dienstplan/veroeffentlichungen.csv

FieldFormatValues
location_idIdentifier (UUID, text)
montagDate (ISO 8601, YYYY-MM-DD)
system_idIdentifier (UUID, text)
published_atTimestamp (ISO 8601 with UTC offset)
published_byIdentifier (UUID, text)
aenderungenInteger

Shift swaps

Swap offers and decisions.

JSON: daten/dienstplan/schichttausch.json · CSV: daten/dienstplan/schichttausch.csv

FieldFormatValues
idIdentifier (UUID, text)
system_idIdentifier (UUID, text)
location_idIdentifier (UUID, text)
shift_idIdentifier (UUID, text)
von_userIdentifier (UUID, text)
an_userIdentifier (UUID, text)
statusText (UTF-8)
notizText (UTF-8)
created_atTimestamp (ISO 8601 with UTC offset)
entschieden_vonIdentifier (UUID, text)
entschieden_amTimestamp (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

FieldFormatValues
idIdentifier (UUID, text)
system_idIdentifier (UUID, text)
location_idIdentifier (UUID, text)
user_idIdentifier (UUID, text)
started_atTimestamp (ISO 8601 with UTC offset)
ended_atTimestamp (ISO 8601 with UTC offset)
zustandText (UTF-8)
noteText (UTF-8)
created_atTimestamp (ISO 8601 with UTC offset)
pause_minInteger
pause_started_atTimestamp (ISO 8601 with UTC offset)
freigegeben_amTimestamp (ISO 8601 with UTC offset)
freigegeben_vonIdentifier (UUID, text)
quelleText (UTF-8)
geraet_idIdentifier (UUID, text)
ende_quelleText (UTF-8)
ende_geraet_idIdentifier (UUID, text)
kostenstelle_idIdentifier (UUID, text)
schichtbeginnTimestamp (ISO 8601 with UTC offset)
abrechnung_abTimestamp (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

FieldFormatValues
idIdentifier (UUID, text)
system_idIdentifier (UUID, text)
location_idIdentifier (UUID, text)
codeText (UTF-8)
nameText (UTF-8)
artText (UTF-8)
vorhaben_idIdentifier (UUID, text)
gueltig_abDate (ISO 8601, YYYY-MM-DD)
gueltig_bisDate (ISO 8601, YYYY-MM-DD)
aktivBoolean (true/false)
geaendert_vonIdentifier (UUID, text)
geaendert_amTimestamp (ISO 8601 with UTC offset)

Breaks

Breaks per time entry.

JSON: daten/dienstplan/pausen.json · CSV: daten/dienstplan/pausen.csv

FieldFormatValues
idIdentifier (UUID, text)
entry_idIdentifier (UUID, text)
system_idIdentifier (UUID, text)
started_atTimestamp (ISO 8601 with UTC offset)
ended_atTimestamp (ISO 8601 with UTC offset)
geraetezeitBoolean (true/false)

Time corrections

Correction requests and decisions.

JSON: daten/dienstplan/zeitkorrekturen.json · CSV: daten/dienstplan/zeitkorrekturen.csv

FieldFormatValues
idIdentifier (UUID, text)
entry_idIdentifier (UUID, text)
system_idIdentifier (UUID, text)
requested_byIdentifier (UUID, text)
vorschlag_startTimestamp (ISO 8601 with UTC offset)
vorschlag_endeTimestamp (ISO 8601 with UTC offset)
vorschlag_pauseInteger
grundText (UTF-8)
statusText (UTF-8)
antwortText (UTF-8)
entschieden_vonIdentifier (UUID, text)
entschieden_amTimestamp (ISO 8601 with UTC offset)
created_atTimestamp (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

FieldFormatValues
idIdentifier (UUID, text)
system_idIdentifier (UUID, text)
location_idIdentifier (UUID, text)
user_idIdentifier (UUID, text)
tagDate (ISO 8601, YYYY-MM-DD)
regelText (UTF-8)
wert_minInteger
grenze_minInteger
standText (UTF-8)
begruendungText (UTF-8)
bestaetigt_vonIdentifier (UUID, text)
bestaetigt_amTimestamp (ISO 8601 with UTC offset)

Time changes

Audit trail of time entries.

JSON: daten/dienstplan/zeit_aenderungen.json · CSV: daten/dienstplan/zeit_aenderungen.csv

FieldFormatValues
idIdentifier (UUID, text)
entry_idIdentifier (UUID, text)
system_idIdentifier (UUID, text)
geaendert_vonIdentifier (UUID, text)
geaendert_amTimestamp (ISO 8601 with UTC offset)
feldText (UTF-8)
vorherText (UTF-8)
nachherText (UTF-8)
grundText (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

FieldFormatValues
idIdentifier (UUID, text)
system_idIdentifier (UUID, text)
location_idIdentifier (UUID, text)
user_idIdentifier (UUID, text)
artText (UTF-8)
vonDate (ISO 8601, YYYY-MM-DD)
bisDate (ISO 8601, YYYY-MM-DD)
statusText (UTF-8)
noteText (UTF-8)
entschieden_vonIdentifier (UUID, text)
entschieden_amTimestamp (ISO 8601 with UTC offset)
created_byIdentifier (UUID, text)
created_atTimestamp (ISO 8601 with UTC offset)
halber_tagBoolean (true/false)
storniert_vonIdentifier (UUID, text)
storniert_amTimestamp (ISO 8601 with UTC offset)
storno_grundText (UTF-8)
uhrzeit_vonTime of day (HH:MM:SS, local time of the location)
uhrzeit_bisTime of day (HH:MM:SS, local time of the location)
stundenDecimal number (dot as decimal separator)
vertretung_idIdentifier (UUID, text)
entscheidung_kommentarText (UTF-8)
storno_antrag_amTimestamp (ISO 8601 with UTC offset)
storno_antrag_grundText (UTF-8)
storno_antrag_entschieden_amTimestamp (ISO 8601 with UTC offset)
storno_antrag_antwortText (UTF-8)
eigene_art_idIdentifier (UUID, text)
vorgenehmigt_vonIdentifier (UUID, text)
vorgenehmigt_amTimestamp (ISO 8601 with UTC offset)
vorgenehmigt_kommentarText (UTF-8)
ende_offenBoolean (true/false)
halb_erster_tagBoolean (true/false)
halb_letzter_tagBoolean (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

FieldFormatValues
absence_idIdentifier (UUID, text)
system_idIdentifier (UUID, text)
user_idIdentifier (UUID, text)
fortsetzung_vonIdentifier (UUID, text)
erfasst_vonIdentifier (UUID, text)
erfasst_amTimestamp (ISO 8601 with UTC offset)

Delegations

Delegation rules for absences.

JSON: daten/dienstplan/abwesenheit_vertretungen.json · CSV: daten/dienstplan/abwesenheit_vertretungen.csv

FieldFormatValues
idIdentifier (UUID, text)
system_idIdentifier (UUID, text)
location_idIdentifier (UUID, text)
stellvertretung_idIdentifier (UUID, text)
erteilt_vonIdentifier (UUID, text)
vonDate (ISO 8601, YYYY-MM-DD)
bisDate (ISO 8601, YYYY-MM-DD)
abwesenheitenBoolean (true/false)
zeitkorrekturenBoolean (true/false)
widerrufen_amTimestamp (ISO 8601 with UTC offset)
widerrufen_vonIdentifier (UUID, text)
created_atTimestamp (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

FieldFormatValues
idIdentifier (UUID, text)
system_idIdentifier (UUID, text)
location_idIdentifier (UUID, text)
arbeitgeber_idIdentifier (UUID, text)
stellvertretung_idIdentifier (UUID, text)
abwesenheitenBoolean (true/false)
zeitkorrekturenBoolean (true/false)
geaendert_amTimestamp (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

FieldFormatValues
absence_idIdentifier (UUID, text)
system_idIdentifier (UUID, text)
user_idIdentifier (UUID, text)
location_idIdentifier (UUID, text)
entbindungsterminDate (ISO 8601, YYYY-MM-DD)
entbindung_amDate (ISO 8601, YYYY-MM-DD)
zwoelf_wochenText (UTF-8)
erfasst_vonIdentifier (UUID, text)
erfasst_amTimestamp (ISO 8601 with UTC offset)
geaendert_vonIdentifier (UUID, text)
geaendert_amTimestamp (ISO 8601 with UTC offset)
fehlgeburt_amDate (ISO 8601, YYYY-MM-DD)
fehlgeburt_sswInteger
verzichtBoolean (true/false)
stillzeit_bisDate (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

FieldFormatValues
user_idIdentifier (UUID, text)
system_idIdentifier (UUID, text)
seitDate (ISO 8601, YYYY-MM-DD)
bisDate (ISO 8601, YYYY-MM-DD)
erfasst_vonIdentifier (UUID, text)
erfasst_amTimestamp (ISO 8601 with UTC offset)
geaendert_amTimestamp (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

FieldFormatValues
idIdentifier (UUID, text)
system_idIdentifier (UUID, text)
user_idIdentifier (UUID, text)
tagDate (ISO 8601, YYYY-MM-DD)
notizText (UTF-8)
erfasst_vonIdentifier (UUID, text)
erfasst_amTimestamp (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

FieldFormatValues
idIdentifier (UUID, text)
system_idIdentifier (UUID, text)
location_idIdentifier (UUID, text)
user_idIdentifier (UUID, text)
gueltig_abDate (ISO 8601, YYYY-MM-DD)
gueltig_bisDate (ISO 8601, YYYY-MM-DD)
vorlage_idIdentifier (UUID, text)
bezeichnungText (UTF-8)
flexibelBoolean (true/false)
tagesstundenList (JSON array) of: Decimal number (dot as decimal separator)
soll_artText (UTF-8)
soll_stundenDecimal number (dot as decimal separator)
created_byIdentifier (UUID, text)
created_atTimestamp (ISO 8601 with UTC offset)
rhythmus_wochenInteger
rhythmus_startDate (ISO 8601, YYYY-MM-DD)
rhythmus_stundenList (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

FieldFormatValues
idIdentifier (UUID, text)
system_idIdentifier (UUID, text)
location_idIdentifier (UUID, text)
user_idIdentifier (UUID, text)
wocheDate (ISO 8601, YYYY-MM-DD)
tagesstundenList (JSON array) of: Decimal number (dot as decimal separator)
notizText (UTF-8)
statusText (UTF-8)
kommentarText (UTF-8)
entschieden_vonIdentifier (UUID, text)
entschieden_amTimestamp (ISO 8601 with UTC offset)
erstellt_amTimestamp (ISO 8601 with UTC offset)

Schedule templates

Templates for work schedules.

JSON: daten/dienstplan/arbeitszeitmodell_vorlagen.json · CSV: daten/dienstplan/arbeitszeitmodell_vorlagen.csv

FieldFormatValues
idIdentifier (UUID, text)
system_idIdentifier (UUID, text)
schluesselText (UTF-8)
nameText (UTF-8)
flexibelBoolean (true/false)
tagesstundenList (JSON array) of: Decimal number (dot as decimal separator)
soll_artText (UTF-8)
soll_stundenDecimal number (dot as decimal separator)
reihenfolgeInteger
aktivBoolean (true/false)
created_atTimestamp (ISO 8601 with UTC offset)

Remote work approvals

Granted approvals.

JSON: daten/dienstplan/homeoffice.json · CSV: daten/dienstplan/homeoffice.csv

FieldFormatValues
user_idIdentifier (UUID, text)
system_idIdentifier (UUID, text)
location_idIdentifier (UUID, text)
erteilt_vonIdentifier (UUID, text)
erteilt_amTimestamp (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

FieldFormatValues
idIdentifier (UUID, text)
system_idIdentifier (UUID, text)
location_idIdentifier (UUID, text)
user_idIdentifier (UUID, text)
artText (UTF-8)
jahrInteger
tageDecimal number (dot as decimal separator)
verfallDate (ISO 8601, YYYY-MM-DD)
angezeigt_amTimestamp (ISO 8601 with UTC offset)
bestaetigt_amTimestamp (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

FieldFormatValues
idIdentifier (UUID, text)
system_idIdentifier (UUID, text)
location_idIdentifier (UUID, text)
artText (UTF-8)
aktivBoolean (true/false)
genehmigungText (UTF-8)
vorlauf_tageInteger
kontingent_tageDecimal number (dot as decimal separator)
krankschein_ab_tagInteger
geaendert_vonIdentifier (UUID, text)
geaendert_amTimestamp (ISO 8601 with UTC offset)
kommentar_pflichtBoolean (true/false)
max_tageInteger
vertretung_pflichtBoolean (true/false)
melden_ab_tageInteger

Leave blackouts

Periods in which certain types cannot be requested.

JSON: daten/dienstplan/urlaubssperren.json · CSV: daten/dienstplan/urlaubssperren.csv

FieldFormatValues
idIdentifier (UUID, text)
system_idIdentifier (UUID, text)
location_idIdentifier (UUID, text)
vonDate (ISO 8601, YYYY-MM-DD)
bisDate (ISO 8601, YYYY-MM-DD)
artenList (JSON array) of: Text (UTF-8)
grundText (UTF-8)
angelegt_vonIdentifier (UUID, text)
angelegt_amTimestamp (ISO 8601 with UTC offset)

Absence limits

Maximum number absent at once per location.

JSON: daten/dienstplan/abwesenheitsgrenzen.json · CSV: daten/dienstplan/abwesenheitsgrenzen.csv

FieldFormatValues
idIdentifier (UUID, text)
system_idIdentifier (UUID, text)
location_idIdentifier (UUID, text)
max_gleichzeitigInteger
artenList (JSON array) of: Text (UTF-8)
geaendert_vonIdentifier (UUID, text)
geaendert_amTimestamp (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

FieldFormatValues
idIdentifier (UUID, text)
system_idIdentifier (UUID, text)
location_idIdentifier (UUID, text)
nameText (UTF-8)
basisText (UTF-8)
kontingent_tageDecimal number (dot as decimal separator)
aktivBoolean (true/false)
geaendert_vonIdentifier (UUID, text)
geaendert_amTimestamp (ISO 8601 with UTC offset)
farbeText (UTF-8)
zaehlweiseText (UTF-8)

Absence allowances

Days per person, type and year.

JSON: daten/dienstplan/abwesenheitskontingente.json · CSV: daten/dienstplan/abwesenheitskontingente.csv

FieldFormatValues
idIdentifier (UUID, text)
system_idIdentifier (UUID, text)
user_idIdentifier (UUID, text)
artText (UTF-8)
jahrInteger
tageDecimal number (dot as decimal separator)
gesetzt_vonIdentifier (UUID, text)
gesetzt_amTimestamp (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

FieldFormatValues
idIdentifier (UUID, text)
system_idIdentifier (UUID, text)
user_idIdentifier (UUID, text)
jahrInteger
artText (UTF-8)
tageDecimal number (dot as decimal separator)
grundText (UTF-8)
zeitbuchung_idIdentifier (UUID, text)
erstellt_vonIdentifier (UUID, text)
erstellt_amTimestamp (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

FieldFormatValues
idIdentifier (UUID, text)
system_idIdentifier (UUID, text)
user_idIdentifier (UUID, text)
jahrInteger
alt_tageDecimal number (dot as decimal separator)
alt_verfallDate (ISO 8601, YYYY-MM-DD)
neu_tageDecimal number (dot as decimal separator)
neu_verfallDate (ISO 8601, YYYY-MM-DD)
ergebnisText (UTF-8)
erstellt_amTimestamp (ISO 8601 with UTC offset)
geschuetztDecimal number (dot as decimal separator)
geschuetzt_bisDate (ISO 8601, YYYY-MM-DD)
geschuetzt_grundText (UTF-8)
gekapptDecimal number (dot as decimal separator)
hinweis_gegebenBoolean (true/false)

Overtime bookings

Opening balances, adjustments, payouts and conversions.

JSON: daten/dienstplan/zeitkonto_buchungen.json · CSV: daten/dienstplan/zeitkonto_buchungen.csv

FieldFormatValues
idIdentifier (UUID, text)
system_idIdentifier (UUID, text)
user_idIdentifier (UUID, text)
artText (UTF-8)
datumDate (ISO 8601, YYYY-MM-DD)
minutenInteger
grundText (UTF-8)
erstellt_vonIdentifier (UUID, text)
erstellt_amTimestamp (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

FieldFormatValues
idIdentifier (UUID, text)
umfangText (UTF-8)
erstellt_amTimestamp (ISO 8601 with UTC offset)
letzter_abrufTimestamp (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

FieldFormatValues
user_idIdentifier (UUID, text)
system_idIdentifier (UUID, text)
location_idIdentifier (UUID, text)
positionText (UTF-8)
eintrittDate (ISO 8601, YYYY-MM-DD)
austrittDate (ISO 8601, YYYY-MM-DD)
befristet_bisDate (ISO 8601, YYYY-MM-DD)
probezeit_endeDate (ISO 8601, YYYY-MM-DD)
wochenstundenDecimal number (dot as decimal separator)
geburtsdatumDate (ISO 8601, YYYY-MM-DD)
telefonText (UTF-8)
anschriftText (UTF-8)
notfall_nameText (UTF-8)
notfall_telefonText (UTF-8)
sv_nummerText (UTF-8)
steuer_idText (UTF-8)
ibanText (UTF-8)
notizText (UTF-8)
aktualisiert_amTimestamp (ISO 8601 with UTC offset)
aktualisiert_vonIdentifier (UUID, text)
personalnummerText (UTF-8)
lohnartText (UTF-8)
urlaubsanspruchDecimal number (dot as decimal separator)
urlaub_uebertragDecimal number (dot as decimal separator)
beschaeftigungsartText (UTF-8)
arbeitstage_pro_wocheInteger
steuerklasseInteger
kinderfreibetragDecimal number (dot as decimal separator)
konfessionText (UTF-8)
krankenkasseText (UTF-8)
rentenversicherung_befreitBoolean (true/false)
urlaub_uebertrag_verfallDate (ISO 8601, YYYY-MM-DD)
kuendigung_eingangDate (ISO 8601, YYYY-MM-DD)
austrittsgrundText (UTF-8)
steuerberater_personalnummerText (UTF-8)
minijob_ausnahmemonateInteger
vornameText (UTF-8)
vorsatzwortText (UTF-8)
nachnameText (UTF-8)
namenszusatzText (UTF-8)
akademischer_gradText (UTF-8)
geburtsnameText (UTF-8)
geburtsortText (UTF-8)
geburtslandText (UTF-8)
geschlechtText (UTF-8)
staatsangehoerigkeitText (UTF-8)
familienstandText (UTF-8)
kinder_anzahlInteger
strasseText (UTF-8)
hausnummerText (UTF-8)
adresszusatzText (UTF-8)
plzText (UTF-8)
ortText (UTF-8)
landText (UTF-8)
notfall_beziehungText (UTF-8)
bicText (UTF-8)
kontoinhaberText (UTF-8)
krankenversicherung_artText (UTF-8)
arbeitgeber_artText (UTF-8)
weitere_beschaeftigungText (UTF-8)
weitere_beschaeftigung_detailsText (UTF-8)
schulabschlussText (UTF-8)
berufsausbildungText (UTF-8)
ausbildung_beginnDate (ISO 8601, YYYY-MM-DD)
ausbildung_ende_voraussichtlichDate (ISO 8601, YYYY-MM-DD)
ausbildung_endeDate (ISO 8601, YYYY-MM-DD)
studienbescheinigung_bisDate (ISO 8601, YYYY-MM-DD)
aufenthaltstitel_artText (UTF-8)
aufenthaltstitel_bisDate (ISO 8601, YYYY-MM-DD)
arbeitserlaubnis_bisDate (ISO 8601, YYYY-MM-DD)
kuendigung_artText (UTF-8)
letzter_arbeitstagDate (ISO 8601, YYYY-MM-DD)
abteilung_idIdentifier (UUID, text)
ueberstunden_abgegolten_minInteger
ueberstunden_abgegolten_abDate (ISO 8601, YYYY-MM-DD)
email_privatText (UTF-8)
pv_kinder_unter_25Integer

Documents

Personnel and partner documents; files under dateien/dokumente/.

JSON: daten/personal/dokumente.json · CSV: daten/personal/dokumente.csv

FieldFormatValues
idIdentifier (UUID, text)
system_idIdentifier (UUID, text)
location_idIdentifier (UUID, text)
partner_idIdentifier (UUID, text)
categoryText (UTF-8)
titleText (UTF-8)
file_pathText (UTF-8)
valid_untilDate (ISO 8601, YYYY-MM-DD)
created_byIdentifier (UUID, text)
created_atTimestamp (ISO 8601 with UTC offset)
personalBoolean (true/false)
sichtbar_fuer_mitarbeiterBoolean (true/false)
unterschrieben_amDate (ISO 8601, YYYY-MM-DD)
abwesenheit_idIdentifier (UUID, text)
geprueft_vonIdentifier (UUID, text)
geprueft_amTimestamp (ISO 8601 with UTC offset)
selbstauskunft_idIdentifier (UUID, text)
kommentarText (UTF-8)
geloescht_amTimestamp (ISO 8601 with UTC offset)
geloescht_vonIdentifier (UUID, text)
geloescht_grundText (UTF-8)
eigene_kategorie_idIdentifier (UUID, text)
kategorie_nameText (UTF-8)
ifsg_artText (UTF-8)
belehrung_amDate (ISO 8601, YYYY-MM-DD)

Receipt confirmations

Requested and confirmed receipts.

JSON: daten/personal/dokument_erhalt.json · CSV: daten/personal/dokument_erhalt.csv

FieldFormatValues
idIdentifier (UUID, text)
system_idIdentifier (UUID, text)
document_idIdentifier (UUID, text)
user_idIdentifier (UUID, text)
location_idIdentifier (UUID, text)
dokument_titelText (UTF-8)
file_pathText (UTF-8)
pdf_sha256Text (UTF-8)
angefordert_vonIdentifier (UUID, text)
angefordert_amTimestamp (ISO 8601 with UTC offset)
erinnert_amTimestamp (ISO 8601 with UTC offset)
erinnerungenInteger
geoeffnet_amTimestamp (ISO 8601 with UTC offset)
bestaetigt_amTimestamp (ISO 8601 with UTC offset)
geraetText (UTF-8)
user_agentText (UTF-8)
erklaerungText (UTF-8)
zurueckgezogen_amTimestamp (ISO 8601 with UTC offset)
zurueckgezogen_vonIdentifier (UUID, text)
artText (UTF-8)
unterschrift_nameText (UTF-8)

Document templates

Templates for contracts and letters.

JSON: daten/personal/dokument_vorlagen.json · CSV: daten/personal/dokument_vorlagen.csv

FieldFormatValues
idIdentifier (UUID, text)
system_idIdentifier (UUID, text)
partner_idIdentifier (UUID, text)
titelText (UTF-8)
kategorieText (UTF-8)
beschreibungText (UTF-8)
schriftformBoolean (true/false)
muster_keyText (UTF-8)
aktivBoolean (true/false)
aktuelle_versionInteger
erstellt_vonIdentifier (UUID, text)
erstellt_amTimestamp (ISO 8601 with UTC offset)
geaendert_amTimestamp (ISO 8601 with UTC offset)
bei_einstellungText (UTF-8)

Template versions

Versions of the templates.

JSON: daten/personal/dokument_vorlagen_fassungen.json · CSV: daten/personal/dokument_vorlagen_fassungen.csv

FieldFormatValues
idIdentifier (UUID, text)
template_idIdentifier (UUID, text)
system_idIdentifier (UUID, text)
versionInteger
inhaltText (UTF-8)
erstellt_vonIdentifier (UUID, text)
erstellt_amTimestamp (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

FieldFormatValues
idIdentifier (UUID, text)
system_idIdentifier (UUID, text)
document_idIdentifier (UUID, text)
user_idIdentifier (UUID, text)
location_idIdentifier (UUID, text)
template_idIdentifier (UUID, text)
template_version_idIdentifier (UUID, text)
vorlage_titelText (UTF-8)
versionInteger
vorlage_inhaltText (UTF-8)
datenstandJSON (object or list; JSON text in CSV)
ueberschriebenList (JSON array) of: Text (UTF-8)
textText (UTF-8)
renderJSON (object or list; JSON text in CSV)
pdf_sha256Text (UTF-8)
stapel_idIdentifier (UUID, text)
erzeugt_vonIdentifier (UUID, text)
erzeugt_amTimestamp (ISO 8601 with UTC offset)

Questionnaires and change requests

Employee submissions and decisions.

JSON: daten/personal/selbstauskuenfte.json · CSV: daten/personal/selbstauskuenfte.csv

FieldFormatValues
idIdentifier (UUID, text)
system_idIdentifier (UUID, text)
user_idIdentifier (UUID, text)
artText (UTF-8)
statusText (UTF-8)
werteJSON (object or list; JSON text in CSV)
notizText (UTF-8)
kommentarText (UTF-8)
fristDate (ISO 8601, YYYY-MM-DD)
uebernommenList (JSON array) of: Text (UTF-8)
verworfenList (JSON array) of: Text (UTF-8)
angefordert_vonIdentifier (UUID, text)
angefordert_amTimestamp (ISO 8601 with UTC offset)
eingereicht_amTimestamp (ISO 8601 with UTC offset)
entschieden_vonIdentifier (UUID, text)
entschieden_amTimestamp (ISO 8601 with UTC offset)
erstellt_amTimestamp (ISO 8601 with UTC offset)
aktualisiert_amTimestamp (ISO 8601 with UTC offset)
revisionInteger

Onboarding/offboarding tasks

Tasks per person.

JSON: daten/personal/eintritt_austritt_aufgaben.json · CSV: daten/personal/eintritt_austritt_aufgaben.csv

FieldFormatValues
idIdentifier (UUID, text)
system_idIdentifier (UUID, text)
location_idIdentifier (UUID, text)
user_idIdentifier (UUID, text)
template_idIdentifier (UUID, text)
phaseText (UTF-8)
bezugDate (ISO 8601, YYYY-MM-DD)
reihenfolgeInteger
aufgabeText (UTF-8)
zustaendigText (UTF-8)
faelligDate (ISO 8601, YYYY-MM-DD)
erledigt_amTimestamp (ISO 8601 with UTC offset)
erledigt_vonIdentifier (UUID, text)
created_atTimestamp (ISO 8601 with UTC offset)
vorlage_idIdentifier (UUID, text)
vorlage_nameText (UTF-8)
von_handBoolean (true/false)
zugewiesen_vonIdentifier (UUID, text)
nur_laenderList (JSON array) of: Text (UTF-8)
nachweisText (UTF-8)
erledigt_durchText (UTF-8)

Onboarding/offboarding templates

Task templates.

JSON: daten/personal/eintritt_austritt_vorlagen.json · CSV: daten/personal/eintritt_austritt_vorlagen.csv

FieldFormatValues
idIdentifier (UUID, text)
system_idIdentifier (UUID, text)
phaseText (UTF-8)
reihenfolgeInteger
aufgabeText (UTF-8)
zustaendigText (UTF-8)
faellig_tage_relativInteger
aktivBoolean (true/false)
created_atTimestamp (ISO 8601 with UTC offset)
gespraech_artText (UTF-8)
vorlage_idIdentifier (UUID, text)
nur_laenderList (JSON array) of: Text (UTF-8)
nachweisText (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

FieldFormatValues
idIdentifier (UUID, text)
system_idIdentifier (UUID, text)
phaseText (UTF-8)
nameText (UTF-8)
automatischBoolean (true/false)
aktivBoolean (true/false)
created_atTimestamp (ISO 8601 with UTC offset)

Custom personnel fields

Definitions of additional fields.

JSON: daten/personal/personalfelder.json · CSV: daten/personal/personalfelder.csv

FieldFormatValues
idIdentifier (UUID, text)
system_idIdentifier (UUID, text)
location_idIdentifier (UUID, text)
nameText (UTF-8)
typText (UTF-8)
optionenList (JSON array) of: Text (UTF-8)
abschnittText (UTF-8)
hilfetextText (UTF-8)
pflichtBoolean (true/false)
sichtbar_fuer_personBoolean (true/false)
person_aenderbarBoolean (true/false)
reihenfolgeInteger
im_exportBoolean (true/false)
aktivBoolean (true/false)
revisionInteger
erstellt_vonIdentifier (UUID, text)
erstellt_amTimestamp (ISO 8601 with UTC offset)
geaendert_vonIdentifier (UUID, text)
geaendert_amTimestamp (ISO 8601 with UTC offset)
name_enText (UTF-8)
hilfetext_enText (UTF-8)
eindeutigBoolean (true/false)

Custom field values

Values of the additional fields.

JSON: daten/personal/personalfeld_werte.json · CSV: daten/personal/personalfeld_werte.csv

FieldFormatValues
idIdentifier (UUID, text)
system_idIdentifier (UUID, text)
feld_idIdentifier (UUID, text)
user_idIdentifier (UUID, text)
location_idIdentifier (UUID, text)
wertJSON (object or list; JSON text in CSV)
gueltig_abDate (ISO 8601, YYYY-MM-DD)
quelleText (UTF-8)
antrag_idIdentifier (UUID, text)
erfasst_vonIdentifier (UUID, text)
erfasst_amTimestamp (ISO 8601 with UTC offset)
storniert_amTimestamp (ISO 8601 with UTC offset)
storniert_vonIdentifier (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

FieldFormatValues
idIdentifier (UUID, text)
system_idIdentifier (UUID, text)
user_idIdentifier (UUID, text)
location_idIdentifier (UUID, text)
wirksam_abDate (ISO 8601, YYYY-MM-DD)
werteJSON (object or list; JSON text in CSV)
notizText (UTF-8)
statusText (UTF-8)
vorherJSON (object or list; JSON text in CSV)
modell_idIdentifier (UUID, text)
fehlerText (UTF-8)
erstellt_vonIdentifier (UUID, text)
erstellt_amTimestamp (ISO 8601 with UTC offset)
geaendert_vonIdentifier (UUID, text)
geaendert_amTimestamp (ISO 8601 with UTC offset)
uebernommen_amTimestamp (ISO 8601 with UTC offset)
zurueckgenommen_vonIdentifier (UUID, text)
zurueckgenommen_amTimestamp (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

FieldFormatValues
idIdentifier (UUID, text)
system_idIdentifier (UUID, text)
location_idIdentifier (UUID, text)
nameText (UTF-8)
ausloeserText (UTF-8)
tageInteger
artText (UTF-8)
bedingungenJSON (object or list; JSON text in CSV)
aktionenJSON (object or list; JSON text in CSV)
aktivBoolean (true/false)
pausiert_amTimestamp (ISO 8601 with UTC offset)
pausiert_vonIdentifier (UUID, text)
archiviert_amTimestamp (ISO 8601 with UTC offset)
erstellt_vonIdentifier (UUID, text)
erstellt_amTimestamp (ISO 8601 with UTC offset)
geaendert_vonIdentifier (UUID, text)
geaendert_amTimestamp (ISO 8601 with UTC offset)

Job catalogue

Jobs with family and level.

JSON: daten/personal/stellenkatalog.json · CSV: daten/personal/stellenkatalog.csv

FieldFormatValues
idIdentifier (UUID, text)
system_idIdentifier (UUID, text)
location_idIdentifier (UUID, text)
titelText (UTF-8)
familieText (UTF-8)
ebeneInteger
beschreibungText (UTF-8)
aktivBoolean (true/false)
geaendert_vonIdentifier (UUID, text)
geaendert_amTimestamp (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

FieldFormatValues
idIdentifier (UUID, text)
system_idIdentifier (UUID, text)
location_idIdentifier (UUID, text)
stelle_idIdentifier (UUID, text)
taetigkeitText (UTF-8)
soll_koepfeInteger
soll_stundenDecimal number (dot as decimal separator)
gueltig_abDate (ISO 8601, YYYY-MM-DD)
gueltig_bisDate (ISO 8601, YYYY-MM-DD)
notizText (UTF-8)
geaendert_vonIdentifier (UUID, text)
geaendert_amTimestamp (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

FieldFormatValues
idIdentifier (UUID, text)
system_idIdentifier (UUID, text)
location_idIdentifier (UUID, text)
nameText (UTF-8)
personalnummerText (UTF-8)
eintrittDate (ISO 8601, YYYY-MM-DD)
austrittDate (ISO 8601, YYYY-MM-DD)
positionText (UTF-8)
beschaeftigungsartText (UTF-8)
notizText (UTF-8)
aufbewahren_bisDate (ISO 8601, YYYY-MM-DD)
angelegt_vonIdentifier (UUID, text)
angelegt_amTimestamp (ISO 8601 with UTC offset)
wieder_einladungIdentifier (UUID, text)
wieder_eingestellt_amTimestamp (ISO 8601 with UTC offset)
wieder_eingestellt_userIdentifier (UUID, text)

Saved views

Own views of the staff list.

JSON: daten/personal/personalliste_ansichten.json · CSV: daten/personal/personalliste_ansichten.csv

FieldFormatValues
idIdentifier (UUID, text)
system_idIdentifier (UUID, text)
user_idIdentifier (UUID, text)
nameText (UTF-8)
spaltenList (JSON array) of: Text (UTF-8)
filterJSON (object or list; JSON text in CSV)
sortierungText (UTF-8)
erstellt_amTimestamp (ISO 8601 with UTC offset)
geteiltBoolean (true/false)

Saved reports

Source, columns, filters and grouping of saved reports.

JSON: daten/personal/bericht_ansichten.json · CSV: daten/personal/bericht_ansichten.csv

FieldFormatValues
idIdentifier (UUID, text)
system_idIdentifier (UUID, text)
user_idIdentifier (UUID, text)
nameText (UTF-8)
quelleText (UTF-8)
spaltenList (JSON array) of: Text (UTF-8)
filterJSON (object or list; JSON text in CSV)
gruppierungText (UTF-8)
sortierungText (UTF-8)
geteiltBoolean (true/false)
erstellt_amTimestamp (ISO 8601 with UTC offset)

Staff imports

Import runs with result counts.

JSON: daten/personal/personal_importe.json · CSV: daten/personal/personal_importe.csv

FieldFormatValues
idIdentifier (UUID, text)
system_idIdentifier (UUID, text)
location_idIdentifier (UUID, text)
kennungIdentifier (UUID, text)
artText (UTF-8)
modusText (UTF-8)
aktualisierenBoolean (true/false)
pruefsummeText (UTF-8)
uebernommenBoolean (true/false)
zeilenInteger
neuInteger
aktualisiertInteger
unveraendertInteger
vorgemerktInteger
uebersprungenInteger
fehlerInteger
erstellt_vonIdentifier (UUID, text)
erstellt_amTimestamp (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

FieldFormatValues
idInteger
lauf_idIdentifier (UUID, text)
system_idIdentifier (UUID, text)
zeileInteger
ergebnisText (UTF-8)
location_idIdentifier (UUID, text)
user_idIdentifier (UUID, text)
invitation_idIdentifier (UUID, text)
felderList (JSON array) of: Text (UTF-8)
meldungenList (JSON array) of: Text (UTF-8)
hinweiseList (JSON array) of: Text (UTF-8)
einladung_gesendet_amTimestamp (ISO 8601 with UTC offset)

Import profiles

Saved column mappings.

JSON: daten/personal/personal_import_profile.json · CSV: daten/personal/personal_import_profile.csv

FieldFormatValues
idIdentifier (UUID, text)
system_idIdentifier (UUID, text)
erstellt_vonIdentifier (UUID, text)
artText (UTF-8)
nameText (UTF-8)
zuordnungJSON (object or list; JSON text in CSV)
werteJSON (object or list; JSON text in CSV)
aktualisiert_amTimestamp (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

FieldFormatValues
user_idIdentifier (UUID, text)
system_idIdentifier (UUID, text)
erteilt_amTimestamp (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

FieldFormatValues
user_idIdentifier (UUID, text)
system_idIdentifier (UUID, text)
erteilt_amTimestamp (ISO 8601 with UTC offset)

Expense categories

Own categories for expenses.

JSON: daten/personal/spesen_kategorien.json · CSV: daten/personal/spesen_kategorien.csv

FieldFormatValues
idIdentifier (UUID, text)
system_idIdentifier (UUID, text)
nameText (UTF-8)
aktivBoolean (true/false)
reihenfolgeInteger
geaendert_vonIdentifier (UUID, text)
geaendert_amTimestamp (ISO 8601 with UTC offset)

Retention holds

Legal holds and extensions.

JSON: daten/personal/aufbewahrungssperren.json · CSV: daten/personal/aufbewahrungssperren.csv

FieldFormatValues
idIdentifier (UUID, text)
system_idIdentifier (UUID, text)
location_idIdentifier (UUID, text)
user_idIdentifier (UUID, text)
artText (UTF-8)
dokument_idIdentifier (UUID, text)
kategorieText (UTF-8)
grundText (UTF-8)
bisDate (ISO 8601, YYYY-MM-DD)
erstellt_vonIdentifier (UUID, text)
erstellt_amTimestamp (ISO 8601 with UTC offset)
aufgehoben_amTimestamp (ISO 8601 with UTC offset)
aufgehoben_vonIdentifier (UUID, text)
aufhebung_grundText (UTF-8)
aufhebung_vorgangIdentifier (UUID, text)
gesetzt_durchText (UTF-8)

Equipment

Items such as keys, clothing, devices.

JSON: daten/personal/ausruestung_artikel.json · CSV: daten/personal/ausruestung_artikel.csv

FieldFormatValues
idIdentifier (UUID, text)
system_idIdentifier (UUID, text)
location_idIdentifier (UUID, text)
artText (UTF-8)
bezeichnungText (UTF-8)
inventarnummerText (UTF-8)
seriennummerText (UTF-8)
wertDecimal number (dot as decimal separator)
pfandDecimal number (dot as decimal separator)
aktivBoolean (true/false)
created_byIdentifier (UUID, text)
created_atTimestamp (ISO 8601 with UTC offset)

Issues

Issued and returned equipment.

JSON: daten/personal/ausruestung_ausgaben.json · CSV: daten/personal/ausruestung_ausgaben.csv

FieldFormatValues
idIdentifier (UUID, text)
system_idIdentifier (UUID, text)
location_idIdentifier (UUID, text)
user_idIdentifier (UUID, text)
artikel_idIdentifier (UUID, text)
ausgabe_idIdentifier (UUID, text)
rueckgabe_idIdentifier (UUID, text)
artText (UTF-8)
bezeichnungText (UTF-8)
inventarnummerText (UTF-8)
seriennummerText (UTF-8)
einzelstueckBoolean (true/false)
mengeInteger
groesseText (UTF-8)
zustand_ausgabeText (UTF-8)
wertDecimal number (dot as decimal separator)
pfandDecimal number (dot as decimal separator)
rueckgabe_datumDate (ISO 8601, YYYY-MM-DD)
zustand_rueckgabeText (UTF-8)
pfand_rueckText (UTF-8)
vermerkText (UTF-8)
storniert_amTimestamp (ISO 8601 with UTC offset)

Handovers

Handover records.

JSON: daten/personal/ausruestung_uebergaben.json · CSV: daten/personal/ausruestung_uebergaben.csv

FieldFormatValues
idIdentifier (UUID, text)
system_idIdentifier (UUID, text)
location_idIdentifier (UUID, text)
user_idIdentifier (UUID, text)
artText (UTF-8)
datumDate (ISO 8601, YYYY-MM-DD)
notizText (UTF-8)
erfasst_vonIdentifier (UUID, text)
erfasst_amTimestamp (ISO 8601 with UTC offset)
bestaetigt_amTimestamp (ISO 8601 with UTC offset)
storniert_amTimestamp (ISO 8601 with UTC offset)
storniert_vonIdentifier (UUID, text)
storno_grundText (UTF-8)
dokument_idIdentifier (UUID, text)
befehlText (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

FieldFormatValues
idIdentifier (UUID, text)
system_idIdentifier (UUID, text)
location_idIdentifier (UUID, text)
user_idIdentifier (UUID, text)
gueltig_abDate (ISO 8601, YYYY-MM-DD)
gueltig_bisDate (ISO 8601, YYYY-MM-DD)
verguetungsartText (UTF-8)
stundenlohnDecimal number (dot as decimal separator)
monatsgehaltDecimal number (dot as decimal separator)
regelstunden_monatDecimal number (dot as decimal separator)
sfn_zuschlaegeBoolean (true/false)
ueberstunden_zuschlag_prozentDecimal number (dot as decimal separator)
minijob_grenze_overrideDecimal number (dot as decimal separator)
notizText (UTF-8)
created_byIdentifier (UUID, text)
created_atTimestamp (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

FieldFormatValues
idIdentifier (UUID, text)
system_idIdentifier (UUID, text)
nameText (UTF-8)
standorteList (JSON array) of: Identifier (UUID, text)
taetigkeitenList (JSON array) of: Text (UTF-8)
stufenList (JSON array) of: Integer
budget_artText (UTF-8)
budget_wertDecimal number (dot as decimal separator)
gueltig_abDate (ISO 8601, YYYY-MM-DD)
vier_augenBoolean (true/false)
statusText (UTF-8)
notizText (UTF-8)
erstellt_vonIdentifier (UUID, text)
erstellt_amTimestamp (ISO 8601 with UTC offset)
geaendert_vonIdentifier (UUID, text)
geaendert_amTimestamp (ISO 8601 with UTC offset)
angefragt_vonIdentifier (UUID, text)
angefragt_amTimestamp (ISO 8601 with UTC offset)
freigegeben_vonIdentifier (UUID, text)
freigegeben_amTimestamp (ISO 8601 with UTC offset)
verworfen_vonIdentifier (UUID, text)
verworfen_amTimestamp (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

FieldFormatValues
idIdentifier (UUID, text)
system_idIdentifier (UUID, text)
runde_idIdentifier (UUID, text)
user_idIdentifier (UUID, text)
location_idIdentifier (UUID, text)
taetigkeitText (UTF-8)
stufeInteger
beschaeftigungsartText (UTF-8)
profil_idIdentifier (UUID, text)
verguetungsartText (UTF-8)
alt_wertDecimal number (dot as decimal separator)
stunden_monatDecimal number (dot as decimal separator)
neu_wertDecimal number (dot as decimal separator)
regelText (UTF-8)
regel_wertDecimal number (dot as decimal separator)
kommentarText (UTF-8)
statusText (UTF-8)
fehlerText (UTF-8)
neues_profil_idIdentifier (UUID, text)
uebernommen_amTimestamp (ISO 8601 with UTC offset)
brief_dokument_idIdentifier (UUID, text)
geaendert_vonIdentifier (UUID, text)
geaendert_amTimestamp (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

FieldFormatValues
idIdentifier (UUID, text)
system_idIdentifier (UUID, text)
location_idIdentifier (UUID, text)
ebeneInteger
min_stundenlohnDecimal number (dot as decimal separator)
max_stundenlohnDecimal number (dot as decimal separator)
min_monatsgehaltDecimal number (dot as decimal separator)
max_monatsgehaltDecimal number (dot as decimal separator)
geaendert_vonIdentifier (UUID, text)
geaendert_amTimestamp (ISO 8601 with UTC offset)

Pay components

Allowances, benefits, deductions.

JSON: daten/lohn/verguetungsbestandteile.json · CSV: daten/lohn/verguetungsbestandteile.csv

FieldFormatValues
idIdentifier (UUID, text)
system_idIdentifier (UUID, text)
location_idIdentifier (UUID, text)
user_idIdentifier (UUID, text)
artText (UTF-8)
bezeichnungText (UTF-8)
rhythmusText (UTF-8)
ab_monatDate (ISO 8601, YYYY-MM-DD)
bis_monatDate (ISO 8601, YYYY-MM-DD)
betragDecimal number (dot as decimal separator)
anzahlDecimal number (dot as decimal separator)
zuzahlungDecimal number (dot as decimal separator)
steuerfreiBoolean (true/false)
vorschuss_idIdentifier (UUID, text)
notizText (UTF-8)
created_byIdentifier (UUID, text)
created_atTimestamp (ISO 8601 with UTC offset)
beendet_amTimestamp (ISO 8601 with UTC offset)
beendet_vonIdentifier (UUID, text)
storniert_amTimestamp (ISO 8601 with UTC offset)
storniert_vonIdentifier (UUID, text)
storno_grundText (UTF-8)

Advances

Salary advances and instalments.

JSON: daten/lohn/vorschuesse.json · CSV: daten/lohn/vorschuesse.csv

FieldFormatValues
idIdentifier (UUID, text)
system_idIdentifier (UUID, text)
location_idIdentifier (UUID, text)
user_idIdentifier (UUID, text)
betragDecimal number (dot as decimal separator)
ausgezahlt_amDate (ISO 8601, YYYY-MM-DD)
auszahlungswegText (UTF-8)
ratenInteger
erste_rateDate (ISO 8601, YYYY-MM-DD)
notizText (UTF-8)
created_byIdentifier (UUID, text)
created_atTimestamp (ISO 8601 with UTC offset)
storniert_amTimestamp (ISO 8601 with UTC offset)
storniert_vonIdentifier (UUID, text)
storno_grundText (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

FieldFormatValues
idIdentifier (UUID, text)
system_idIdentifier (UUID, text)
user_idIdentifier (UUID, text)
monatDate (ISO 8601, YYYY-MM-DD)
grundText (UTF-8)
erfasst_vonIdentifier (UUID, text)
erfasst_amTimestamp (ISO 8601 with UTC offset)

Payroll periods

Payroll months with review and approval.

JSON: daten/lohn/lohnabschluesse.json · CSV: daten/lohn/lohnabschluesse.csv

FieldFormatValues
idIdentifier (UUID, text)
system_idIdentifier (UUID, text)
location_idIdentifier (UUID, text)
monatDate (ISO 8601, YYYY-MM-DD)
laufInteger
statusText (UTF-8)
korrektur_grundText (UTF-8)
offene_korrekturenInteger
nicht_freigegebene_zeitenInteger
geprueft_vonIdentifier (UUID, text)
geprueft_amTimestamp (ISO 8601 with UTC offset)
freigegeben_vonIdentifier (UUID, text)
freigegeben_amTimestamp (ISO 8601 with UTC offset)
lines_hashText (UTF-8)
created_atTimestamp (ISO 8601 with UTC offset)

Payroll lines

Wage types per person and month.

JSON: daten/lohn/lohnzeilen.json · CSV: daten/lohn/lohnzeilen.csv

FieldFormatValues
idIdentifier (UUID, text)
period_idIdentifier (UUID, text)
system_idIdentifier (UUID, text)
location_idIdentifier (UUID, text)
user_idIdentifier (UUID, text)
personalnummerText (UTF-8)
lohnart_keyText (UTF-8)
bezeichnungText (UTF-8)
mengeDecimal number (dot as decimal separator)
einheitText (UTF-8)
satzDecimal number (dot as decimal separator)
betragDecimal number (dot as decimal separator)
steuerfreiBoolean (true/false)
hinweisText (UTF-8)

Payroll exports

Generated DATEV files (content as text).

JSON: daten/lohn/lohnexporte.json · CSV: daten/lohn/lohnexporte.csv

FieldFormatValues
idIdentifier (UUID, text)
period_idIdentifier (UUID, text)
system_idIdentifier (UUID, text)
location_idIdentifier (UUID, text)
varianteText (UTF-8)
testBoolean (true/false)
dateinameText (UTF-8)
inhaltText (UTF-8)
sha256Text (UTF-8)
zeilenInteger
erstellt_vonIdentifier (UUID, text)
erstellt_amTimestamp (ISO 8601 with UTC offset)
abgeholt_amTimestamp (ISO 8601 with UTC offset)

Wage type mapping

Mapping to DATEV wage types.

JSON: daten/lohn/lohnarten.json · CSV: daten/lohn/lohnarten.csv

FieldFormatValues
location_idIdentifier (UUID, text)
system_idIdentifier (UUID, text)
lohnart_keyText (UTF-8)
lohnartText (UTF-8)

DATEV settings

Consultant and client numbers per location.

JSON: daten/lohn/datev_einstellungen.json · CSV: daten/lohn/datev_einstellungen.csv

FieldFormatValues
location_idIdentifier (UUID, text)
system_idIdentifier (UUID, text)
varianteText (UTF-8)
beraternummerText (UTF-8)
mandantennummerText (UTF-8)
personalnummer_quelleText (UTF-8)
geaendert_vonIdentifier (UUID, text)
geaendert_amTimestamp (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

FieldFormatValues
idIdentifier (UUID, text)
system_idIdentifier (UUID, text)
location_idIdentifier (UUID, text)
quelleText (UTF-8)
upload_link_idIdentifier (UUID, text)
dateinameText (UTF-8)
datei_pfadText (UTF-8)
groesseInteger
seitenInteger
herkunft_idIdentifier (UUID, text)
herkunft_seitenText (UTF-8)
personen_textText (UTF-8)
user_idIdentifier (UUID, text)
artText (UTF-8)
jahrInteger
monatInteger
sicherheitText (UTF-8)
hinweisText (UTF-8)
statusText (UTF-8)
document_idIdentifier (UUID, text)
ziel_pfadText (UTF-8)
revisionInteger
ersetzt_durchIdentifier (UUID, text)
veroeffentlicht_amTimestamp (ISO 8601 with UTC offset)
veroeffentlicht_vonIdentifier (UUID, text)
erstellt_vonIdentifier (UUID, text)
erstellt_amTimestamp (ISO 8601 with UTC offset)
geaendert_amTimestamp (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

FieldFormatValues
idIdentifier (UUID, text)
system_idIdentifier (UUID, text)
location_idIdentifier (UUID, text)
bezeichnungText (UTF-8)
gueltig_bisTimestamp (ISO 8601 with UTC offset)
max_dateienInteger
dateienInteger
letzter_uploadTimestamp (ISO 8601 with UTC offset)
erstellt_vonIdentifier (UUID, text)
erstellt_amTimestamp (ISO 8601 with UTC offset)
widerrufen_amTimestamp (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

FieldFormatValues
idIdentifier (UUID, text)
export_idIdentifier (UUID, text)
system_idIdentifier (UUID, text)
location_idIdentifier (UUID, text)
gueltig_bisTimestamp (ISO 8601 with UTC offset)
erstellt_vonIdentifier (UUID, text)
erstellt_amTimestamp (ISO 8601 with UTC offset)
widerrufen_amTimestamp (ISO 8601 with UTC offset)
abrufeInteger
letzter_abrufTimestamp (ISO 8601 with UTC offset)

Expenses

Submitted expenses; receipts under dateien/dokumente/.

JSON: daten/lohn/auslagen.json · CSV: daten/lohn/auslagen.csv

FieldFormatValues
idIdentifier (UUID, text)
system_idIdentifier (UUID, text)
location_idIdentifier (UUID, text)
user_idIdentifier (UUID, text)
kategorieText (UTF-8)
datumDate (ISO 8601, YYYY-MM-DD)
betragDecimal number (dot as decimal separator)
kmDecimal number (dot as decimal separator)
km_satzDecimal number (dot as decimal separator)
streckeText (UTF-8)
mwst_satzDecimal number (dot as decimal separator)
notizText (UTF-8)
beleg_pfadText (UTF-8)
statusText (UTF-8)
revisionInteger
eingereicht_amTimestamp (ISO 8601 with UTC offset)
entschieden_vonIdentifier (UUID, text)
entschieden_amTimestamp (ISO 8601 with UTC offset)
entscheidung_grundText (UTF-8)
beleg_jahrInteger
beleg_nrInteger
erstattung_artText (UTF-8)
erstattung_datumDate (ISO 8601, YYYY-MM-DD)
erstattung_monatDate (ISO 8601, YYYY-MM-DD)
erstattet_vonIdentifier (UUID, text)
erstattet_amTimestamp (ISO 8601 with UTC offset)
aktualisiert_amTimestamp (ISO 8601 with UTC offset)

Expense history

Status changes of expenses.

JSON: daten/lohn/auslagen_verlauf.json · CSV: daten/lohn/auslagen_verlauf.csv

FieldFormatValues
idInteger
spesen_idIdentifier (UUID, text)
system_idIdentifier (UUID, text)
zeitTimestamp (ISO 8601 with UTC offset)
akteurIdentifier (UUID, text)
ereignisText (UTF-8)
grundText (UTF-8)

Expense settings

Limits and accounts per location.

JSON: daten/lohn/auslagen_einstellungen.json · CSV: daten/lohn/auslagen_einstellungen.csv

FieldFormatValues
location_idIdentifier (UUID, text)
system_idIdentifier (UUID, text)
schichtleitung_grenzeDecimal number (dot as decimal separator)
kontenJSON (object or list; JSON text in CSV)
geaendert_vonIdentifier (UUID, text)
geaendert_amTimestamp (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

FieldFormatValues
system_idIdentifier (UUID, text)
jahresgespraech_erinnerungBoolean (true/false)
probezeit_vorlauf_tageInteger
jahresgespraech_vorlauf_tageInteger
geaendert_amTimestamp (ISO 8601 with UTC offset)
geaendert_vonIdentifier (UUID, text)
jahresgespraech_stichtagDate (ISO 8601, YYYY-MM-DD)
kollegenfeedbackBoolean (true/false)

Location approvals

Reviews by shift leads per location.

JSON: daten/entwicklung/standort_freigaben.json · CSV: daten/entwicklung/standort_freigaben.csv

FieldFormatValues
location_idIdentifier (UUID, text)
system_idIdentifier (UUID, text)
schichtleitung_gespraecheBoolean (true/false)
geaendert_amTimestamp (ISO 8601 with UTC offset)
geaendert_vonIdentifier (UUID, text)

Review templates

Questions and sections.

JSON: daten/entwicklung/vorlagen.json · CSV: daten/entwicklung/vorlagen.csv

FieldFormatValues
idIdentifier (UUID, text)
system_idIdentifier (UUID, text)
location_idIdentifier (UUID, text)
artText (UTF-8)
titelText (UTF-8)
beschreibungText (UTF-8)
abschnitteJSON (object or list; JSON text in CSV)
selbsteinschaetzungBoolean (true/false)
aktivBoolean (true/false)
erstellt_vonIdentifier (UUID, text)
created_atTimestamp (ISO 8601 with UTC offset)
updated_atTimestamp (ISO 8601 with UTC offset)

Reviews

Employee reviews.

JSON: daten/entwicklung/gespraeche.json · CSV: daten/entwicklung/gespraeche.csv

FieldFormatValues
idIdentifier (UUID, text)
system_idIdentifier (UUID, text)
location_idIdentifier (UUID, text)
user_idIdentifier (UUID, text)
fuehrung_idIdentifier (UUID, text)
vorlage_idIdentifier (UUID, text)
artText (UTF-8)
titelText (UTF-8)
terminTimestamp (ISO 8601 with UTC offset)
ortText (UTF-8)
fragenJSON (object or list; JSON text in CSV)
selbsteinschaetzungBoolean (true/false)
statusText (UTF-8)
abgeschlossen_amTimestamp (ISO 8601 with UTC offset)
abgeschlossen_vonIdentifier (UUID, text)
kenntnis_amTimestamp (ISO 8601 with UTC offset)
person_kommentarText (UTF-8)
created_atTimestamp (ISO 8601 with UTC offset)
updated_atTimestamp (ISO 8601 with UTC offset)
zyklus_idIdentifier (UUID, text)

Review answers

Answers per side.

JSON: daten/entwicklung/antworten.json · CSV: daten/entwicklung/antworten.csv

FieldFormatValues
gespraech_idIdentifier (UUID, text)
system_idIdentifier (UUID, text)
seiteText (UTF-8)
antwortenJSON (object or list; JSON text in CSV)
zusammenfassungText (UTF-8)
abgegeben_amTimestamp (ISO 8601 with UTC offset)
geaendert_amTimestamp (ISO 8601 with UTC offset)
geaendert_vonIdentifier (UUID, text)
revisionInteger

Addenda

Additions after completion.

JSON: daten/entwicklung/nachtraege.json · CSV: daten/entwicklung/nachtraege.csv

FieldFormatValues
idIdentifier (UUID, text)
system_idIdentifier (UUID, text)
gespraech_idIdentifier (UUID, text)
autor_idIdentifier (UUID, text)
seiteText (UTF-8)
textText (UTF-8)
created_atTimestamp (ISO 8601 with UTC offset)

Own notes

Private notes (visible to the author only).

JSON: daten/entwicklung/notizen.json · CSV: daten/entwicklung/notizen.csv

FieldFormatValues
gespraech_idIdentifier (UUID, text)
autor_idIdentifier (UUID, text)
system_idIdentifier (UUID, text)
textText (UTF-8)
geaendert_amTimestamp (ISO 8601 with UTC offset)

Goals

Agreed goals with progress.

JSON: daten/entwicklung/ziele.json · CSV: daten/entwicklung/ziele.csv

FieldFormatValues
idIdentifier (UUID, text)
system_idIdentifier (UUID, text)
location_idIdentifier (UUID, text)
user_idIdentifier (UUID, text)
gespraech_idIdentifier (UUID, text)
titelText (UTF-8)
beschreibungText (UTF-8)
fristDate (ISO 8601, YYYY-MM-DD)
fortschrittInteger
statusText (UTF-8)
erledigt_amTimestamp (ISO 8601 with UTC offset)
kurs_idIdentifier (UUID, text)
erstellt_vonIdentifier (UUID, text)
created_atTimestamp (ISO 8601 with UTC offset)
updated_atTimestamp (ISO 8601 with UTC offset)
eltern_idIdentifier (UUID, text)
gewichtInteger
messartText (UTF-8)
startwertDecimal number (dot as decimal separator)
zielwertDecimal number (dot as decimal separator)
istwertDecimal number (dot as decimal separator)
einheitText (UTF-8)
einschaetzungText (UTF-8)
gemeldet_amTimestamp (ISO 8601 with UTC offset)

Goal comments

Comments on goals.

JSON: daten/entwicklung/ziel_kommentare.json · CSV: daten/entwicklung/ziel_kommentare.csv

FieldFormatValues
idIdentifier (UUID, text)
system_idIdentifier (UUID, text)
ziel_idIdentifier (UUID, text)
autor_idIdentifier (UUID, text)
textText (UTF-8)
created_atTimestamp (ISO 8601 with UTC offset)

Feedback

Praise and notes.

JSON: daten/entwicklung/feedback.json · CSV: daten/entwicklung/feedback.csv

FieldFormatValues
idIdentifier (UUID, text)
system_idIdentifier (UUID, text)
location_idIdentifier (UUID, text)
user_idIdentifier (UUID, text)
von_idIdentifier (UUID, text)
artText (UTF-8)
textText (UTF-8)
created_atTimestamp (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

FieldFormatValues
idIdentifier (UUID, text)
system_idIdentifier (UUID, text)
ziel_idIdentifier (UUID, text)
autor_idIdentifier (UUID, text)
fortschrittInteger
istwertDecimal number (dot as decimal separator)
erledigtBoolean (true/false)
einschaetzungText (UTF-8)
notizText (UTF-8)
messartText (UTF-8)
startwertDecimal number (dot as decimal separator)
zielwertDecimal number (dot as decimal separator)
einheitText (UTF-8)
created_atTimestamp (ISO 8601 with UTC offset)

Requests

Development requests and decisions.

JSON: daten/entwicklung/anfragen.json · CSV: daten/entwicklung/anfragen.csv

FieldFormatValues
idIdentifier (UUID, text)
system_idIdentifier (UUID, text)
location_idIdentifier (UUID, text)
user_idIdentifier (UUID, text)
artText (UTF-8)
titelText (UTF-8)
textText (UTF-8)
wunsch_fristDate (ISO 8601, YYYY-MM-DD)
kurs_idIdentifier (UUID, text)
gespraech_artText (UTF-8)
statusText (UTF-8)
antwortText (UTF-8)
entschieden_vonIdentifier (UUID, text)
entschieden_amTimestamp (ISO 8601 with UTC offset)
ziel_idIdentifier (UUID, text)
gespraech_idIdentifier (UUID, text)
created_atTimestamp (ISO 8601 with UTC offset)
updated_atTimestamp (ISO 8601 with UTC offset)

Review cycles

Cycles with template, deadline and selection.

JSON: daten/entwicklung/zyklen.json · CSV: daten/entwicklung/zyklen.csv

FieldFormatValues
idIdentifier (UUID, text)
system_idIdentifier (UUID, text)
titelText (UTF-8)
artText (UTF-8)
vorlage_idIdentifier (UUID, text)
fragenJSON (object or list; JSON text in CSV)
selbsteinschaetzungBoolean (true/false)
fristDate (ISO 8601, YYYY-MM-DD)
erinnerung_tageInteger
standorteList (JSON array) of: Identifier (UUID, text)
taetigkeitText (UTF-8)
von_zentraleBoolean (true/false)
erstellt_vonIdentifier (UUID, text)
created_atTimestamp (ISO 8601 with UTC offset)
beendet_amTimestamp (ISO 8601 with UTC offset)
beendet_vonIdentifier (UUID, text)
kollegen_feedbackBoolean (true/false)
fuehrung_feedbackBoolean (true/false)

Team goal members

Who works on which team goal.

JSON: daten/entwicklung/ziel_personen.json · CSV: daten/entwicklung/ziel_personen.csv

FieldFormatValues
idIdentifier (UUID, text)
ziel_idIdentifier (UUID, text)
user_idIdentifier (UUID, text)
system_idIdentifier (UUID, text)
created_atTimestamp (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

FieldFormatValues
idIdentifier (UUID, text)
system_idIdentifier (UUID, text)
zyklus_idIdentifier (UUID, text)
gespraech_idIdentifier (UUID, text)
location_idIdentifier (UUID, text)
artText (UTF-8)
von_idIdentifier (UUID, text)
ueber_idIdentifier (UUID, text)
angefragt_vonIdentifier (UUID, text)
wertInteger
textText (UTF-8)
angefragt_amTimestamp (ISO 8601 with UTC offset)
abgegeben_amTimestamp (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

FieldFormatValues
idIdentifier (UUID, text)
system_idIdentifier (UUID, text)
location_idIdentifier (UUID, text)
von_idIdentifier (UUID, text)
an_idIdentifier (UUID, text)
artText (UTF-8)
textText (UTF-8)
created_atTimestamp (ISO 8601 with UTC offset)
geteilt_amTimestamp (ISO 8601 with UTC offset)
gemeldet_amTimestamp (ISO 8601 with UTC offset)
meldung_grundText (UTF-8)
ausgeblendet_amTimestamp (ISO 8601 with UTC offset)
ausgeblendet_vonIdentifier (UUID, text)
ausblend_grundText (UTF-8)

Surveys

Staff surveys.

JSON: daten/entwicklung/befragungen.json · CSV: daten/entwicklung/befragungen.csv

FieldFormatValues
idIdentifier (UUID, text)
system_idIdentifier (UUID, text)
bereichText (UTF-8)
erstellt_vonIdentifier (UUID, text)
titelText (UTF-8)
einleitungText (UTF-8)
vorlageText (UTF-8)
anonymBoolean (true/false)
mindestgruppeInteger
zielrollenList (JSON array) of: Enumerated value (text, see values)zentrale, multi_unit_partner, partner, schichtleitung, mitarbeiter
standorteList (JSON array) of: Identifier (UUID, text)
artText (UTF-8)
rhythmusText (UTF-8)
laufzeit_tageInteger
beginnDate (ISO 8601, YYYY-MM-DD)
endeDate (ISO 8601, YYYY-MM-DD)
beendet_amTimestamp (ISO 8601 with UTC offset)
created_atTimestamp (ISO 8601 with UTC offset)
netzweitBoolean (true/false)

Survey runs

Runs of the surveys.

JSON: daten/entwicklung/befragung_durchgaenge.json · CSV: daten/entwicklung/befragung_durchgaenge.csv

FieldFormatValues
idIdentifier (UUID, text)
survey_idIdentifier (UUID, text)
system_idIdentifier (UUID, text)
nummerInteger
beginnDate (ISO 8601, YYYY-MM-DD)
endeDate (ISO 8601, YYYY-MM-DD)
gestartet_amTimestamp (ISO 8601 with UTC offset)
created_atTimestamp (ISO 8601 with UTC offset)

Questions

Survey questions.

JSON: daten/entwicklung/befragung_fragen.json · CSV: daten/entwicklung/befragung_fragen.csv

FieldFormatValues
idIdentifier (UUID, text)
survey_idIdentifier (UUID, text)
system_idIdentifier (UUID, text)
positionInteger
typText (UTF-8)
textText (UTF-8)
optionenList (JSON array) of: Text (UTF-8)
pflichtBoolean (true/false)

Participation

Invitations and participation.

JSON: daten/entwicklung/befragung_teilnahmen.json · CSV: daten/entwicklung/befragung_teilnahmen.csv

FieldFormatValues
run_idIdentifier (UUID, text)
survey_idIdentifier (UUID, text)
system_idIdentifier (UUID, text)
user_idIdentifier (UUID, text)
location_idIdentifier (UUID, text)
eingeladen_amTimestamp (ISO 8601 with UTC offset)
fristDate (ISO 8601, YYYY-MM-DD)
teilgenommen_amTimestamp (ISO 8601 with UTC offset)
erinnert_amTimestamp (ISO 8601 with UTC offset)
anlassText (UTF-8)
anlass_datumDate (ISO 8601, YYYY-MM-DD)
abgelehnt_amTimestamp (ISO 8601 with UTC offset)

Responses

Submitted responses (anonymous ones without person).

JSON: daten/entwicklung/befragung_abgaben.json · CSV: daten/entwicklung/befragung_abgaben.csv

FieldFormatValues
idIdentifier (UUID, text)
survey_idIdentifier (UUID, text)
run_idIdentifier (UUID, text)
system_idIdentifier (UUID, text)
location_idIdentifier (UUID, text)
user_idIdentifier (UUID, text)
rolleEnumerated value (text, see values)zentrale, multi_unit_partner, partner, schichtleitung, mitarbeiter
abgegeben_amTimestamp (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

FieldFormatValues
response_idIdentifier (UUID, text)
question_idIdentifier (UUID, text)
system_idIdentifier (UUID, text)
wertInteger
auswahlList (JSON array) of: Integer
textText (UTF-8)
Recruiting · 9 Files

Job postings

Job advertisements.

JSON: daten/recruiting/stellen.json · CSV: daten/recruiting/stellen.csv

FieldFormatValues
idIdentifier (UUID, text)
system_idIdentifier (UUID, text)
location_idIdentifier (UUID, text)
vorlageBoolean (true/false)
vorlage_idIdentifier (UUID, text)
codeText (UTF-8)
titelText (UTF-8)
beschaeftigungsartText (UTF-8)
beschreibungText (UTF-8)
anforderungenText (UTF-8)
start_datumDate (ISO 8601, YYYY-MM-DD)
verguetung_betragDecimal number (dot as decimal separator)
verguetung_einheitText (UTF-8)
statusText (UTF-8)
verantwortlicheList (JSON array) of: Identifier (UUID, text)
veroeffentlicht_amTimestamp (ISO 8601 with UTC offset)
erstellt_vonIdentifier (UUID, text)
created_atTimestamp (ISO 8601 with UTC offset)
updated_atTimestamp (ISO 8601 with UTC offset)
vorsortieren_absageBoolean (true/false)
stellenplan_idIdentifier (UUID, text)

Applications

Applications with consent; CVs under dateien/dokumente/.

JSON: daten/recruiting/bewerbungen.json · CSV: daten/recruiting/bewerbungen.csv

FieldFormatValues
idIdentifier (UUID, text)
system_idIdentifier (UUID, text)
stelle_idIdentifier (UUID, text)
location_idIdentifier (UUID, text)
nameText (UTF-8)
emailText (UTF-8)
telefonText (UTF-8)
tageList (JSON array) of: Text (UTF-8)
zeitenList (JSON array) of: Text (UTF-8)
startdatumDate (ISO 8601, YYYY-MM-DD)
deutschText (UTF-8)
nachrichtText (UTF-8)
lebenslauf_pfadText (UTF-8)
lebenslauf_nameText (UTF-8)
lebenslauf_sha256Text (UTF-8)
einwilligung_textText (UTF-8)
einwilligung_amTimestamp (ISO 8601 with UTC offset)
talentpoolBoolean (true/false)
talentpool_textText (UTF-8)
talentpool_amTimestamp (ISO 8601 with UTC offset)
quelleText (UTF-8)
kanalText (UTF-8)
spracheText (UTF-8)
phaseText (UTF-8)
bewertungInteger
gespraech_amTimestamp (ISO 8601 with UTC offset)
probearbeit_amTimestamp (ISO 8601 with UTC offset)
abgeschlossen_amTimestamp (ISO 8601 with UTC offset)
einladung_idIdentifier (UUID, text)
eingang_bestaetigt_amTimestamp (ISO 8601 with UTC offset)
anonymisiert_amTimestamp (ISO 8601 with UTC offset)
created_atTimestamp (ISO 8601 with UTC offset)
updated_atTimestamp (ISO 8601 with UTC offset)
zwischenphase_idIdentifier (UUID, text)
empfohlen_vonIdentifier (UUID, text)
vorsortierungText (UTF-8)
vorsortierung_amTimestamp (ISO 8601 with UTC offset)
absage_vorgeschlagenBoolean (true/false)

Application history

Stages and notes.

JSON: daten/recruiting/bewerbung_verlauf.json · CSV: daten/recruiting/bewerbung_verlauf.csv

FieldFormatValues
idIdentifier (UUID, text)
system_idIdentifier (UUID, text)
bewerbung_idIdentifier (UUID, text)
artText (UTF-8)
vonText (UTF-8)
nachText (UTF-8)
textText (UTF-8)
autorIdentifier (UUID, text)
created_atTimestamp (ISO 8601 with UTC offset)
von_zwischenphaseText (UTF-8)
nach_zwischenphaseText (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

FieldFormatValues
idIdentifier (UUID, text)
system_idIdentifier (UUID, text)
location_idIdentifier (UUID, text)
artText (UTF-8)
spracheText (UTF-8)
betreffText (UTF-8)
textText (UTF-8)
geaendert_vonIdentifier (UUID, text)
geaendert_amTimestamp (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

FieldFormatValues
idIdentifier (UUID, text)
system_idIdentifier (UUID, text)
stelle_idIdentifier (UUID, text)
nameText (UTF-8)
grundphaseText (UTF-8)
reihenfolgeInteger
aktivBoolean (true/false)
geaendert_vonIdentifier (UUID, text)
geaendert_amTimestamp (ISO 8601 with UTC offset)
created_atTimestamp (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

FieldFormatValues
idIdentifier (UUID, text)
system_idIdentifier (UUID, text)
stelle_idIdentifier (UUID, text)
nameText (UTF-8)
beschreibungText (UTF-8)
reihenfolgeInteger
aktivBoolean (true/false)
geaendert_vonIdentifier (UUID, text)
geaendert_amTimestamp (ISO 8601 with UTC offset)
created_atTimestamp (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

FieldFormatValues
idIdentifier (UUID, text)
system_idIdentifier (UUID, text)
bewerbung_idIdentifier (UUID, text)
kriterium_idIdentifier (UUID, text)
bewerterIdentifier (UUID, text)
punkteInteger
kommentarText (UTF-8)
created_atTimestamp (ISO 8601 with UTC offset)
updated_atTimestamp (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

FieldFormatValues
idIdentifier (UUID, text)
system_idIdentifier (UUID, text)
stelle_idIdentifier (UUID, text)
artText (UTF-8)
textText (UTF-8)
text_enText (UTF-8)
ko_beiText (UTF-8)
mindestalterInteger
begruendungText (UTF-8)
pflichtBoolean (true/false)
reihenfolgeInteger
aktivBoolean (true/false)
geaendert_vonIdentifier (UUID, text)
geaendert_amTimestamp (ISO 8601 with UTC offset)
created_atTimestamp (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

FieldFormatValues
idIdentifier (UUID, text)
system_idIdentifier (UUID, text)
bewerbung_idIdentifier (UUID, text)
frage_idIdentifier (UUID, text)
artText (UTF-8)
textText (UTF-8)
text_enText (UTF-8)
mindestalterInteger
ko_beiText (UTF-8)
antwortBoolean (true/false)
passtBoolean (true/false)
created_atTimestamp (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

FieldFormatValues
location_idIdentifier (UUID, text)
system_idIdentifier (UUID, text)
firmaText (UTF-8)
rechtsformText (UTF-8)
handelsregisterText (UTF-8)
steuernummerText (UTF-8)
ust_idText (UTF-8)
ibanText (UTF-8)
bicText (UTF-8)
bankText (UTF-8)
ansprech_nameText (UTF-8)
ansprech_telefonText (UTF-8)
ansprech_emailText (UTF-8)
vertrag_beginnDate (ISO 8601, YYYY-MM-DD)
vertrag_endeDate (ISO 8601, YYYY-MM-DD)
kuendigungsfrist_monateInteger
gebietText (UTF-8)
notizText (UTF-8)
aktualisiert_amTimestamp (ISO 8601 with UTC offset)
aktualisiert_vonIdentifier (UUID, text)
gebuehr_prozentDecimal number (dot as decimal separator)
marketing_prozentDecimal number (dot as decimal separator)
gebuehr_fixDecimal number (dot as decimal separator)
gebuehr_mindestDecimal number (dot as decimal separator)
gebuehren_abDate (ISO 8601, YYYY-MM-DD)
gebuehren_notizText (UTF-8)

Contracts

Franchise and lease contracts with deadlines.

JSON: daten/partner/vertraege.json · CSV: daten/partner/vertraege.csv

FieldFormatValues
idIdentifier (UUID, text)
system_idIdentifier (UUID, text)
location_idIdentifier (UUID, text)
artEnumerated value (text, see values)franchisevertrag, nachtrag, gebietsschutz, mietvertrag, sonstiges
titelText (UTF-8)
statusEnumerated value (text, see values)entwurf, aktiv, gekuendigt, ausgelaufen, verlaengert
beginnDate (ISO 8601, YYYY-MM-DD)
endeDate (ISO 8601, YYYY-MM-DD)
kuendigungsfrist_monateInteger
verlaengert_automatischBoolean (true/false)
verlaengerung_monateInteger
gebietText (UTF-8)
gehoert_zuIdentifier (UUID, text)
dokument_idIdentifier (UUID, text)
notizText (UTF-8)
created_atTimestamp (ISO 8601 with UTC offset)
aktualisiert_amTimestamp (ISO 8601 with UTC offset)
aktualisiert_vonIdentifier (UUID, text)
geloescht_amTimestamp (ISO 8601 with UTC offset)
geloescht_vonIdentifier (UUID, text)
geloescht_grundText (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

FieldFormatValues
idIdentifier (UUID, text)
system_idIdentifier (UUID, text)
location_idIdentifier (UUID, text)
periodDate (ISO 8601, YYYY-MM-DD)
statusEnumerated value (text, see values)offen, eingereicht, geprueft
file_pathText (UTF-8)
submitted_byIdentifier (UUID, text)
submitted_atTimestamp (ISO 8601 with UTC offset)
revenueDecimal number (dot as decimal separator)
cost_of_goodsDecimal number (dot as decimal separator)
personnel_costDecimal number (dot as decimal separator)
gross_profitDecimal number (dot as decimal separator)
personnel_ratioDecimal number (dot as decimal separator)
alertEnumerated value (text, see values)gruen, gelb, rot
notesText (UTF-8)
created_atTimestamp (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

FieldFormatValues
idIdentifier (UUID, text)
system_idIdentifier (UUID, text)
location_idIdentifier (UUID, text)
submission_idIdentifier (UUID, text)
periodDate (ISO 8601, YYYY-MM-DD)
kennzahlText (UTF-8)
monatDecimal number (dot as decimal separator)
kumuliertDecimal number (dot as decimal separator)
quelleText (UTF-8)
erfasst_amTimestamp (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

FieldFormatValues
idIdentifier (UUID, text)
system_idIdentifier (UUID, text)
location_idIdentifier (UUID, text)
kennzahlText (UTF-8)
richtungText (UTF-8)
alarmwertDecimal number (dot as decimal separator)
warnwertDecimal number (dot as decimal separator)
geaendert_vonIdentifier (UUID, text)
geaendert_amTimestamp (ISO 8601 with UTC offset)
standort_typText (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

FieldFormatValues
system_idIdentifier (UUID, text)
serie_monateInteger
vorjahr_prozentDecimal number (dot as decimal separator)
quartilBoolean (true/false)
tagesumsatz_prozentDecimal number (dot as decimal separator)
erinnern_tageInteger
eskalation_tageInteger
wochenmailBoolean (true/false)
geaendert_vonIdentifier (UUID, text)
geaendert_amTimestamp (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

FieldFormatValues
idIdentifier (UUID, text)
system_idIdentifier (UUID, text)
location_idIdentifier (UUID, text)
periodDate (ISO 8601, YYYY-MM-DD)
kennzahlText (UTF-8)
wertDecimal number (dot as decimal separator)
geaendert_vonIdentifier (UUID, text)
geaendert_amTimestamp (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

FieldFormatValues
idIdentifier (UUID, text)
system_idIdentifier (UUID, text)
location_idIdentifier (UUID, text)
titelText (UTF-8)
beschreibungText (UTF-8)
anlassText (UTF-8)
kennzahlText (UTF-8)
ausgang_periodDate (ISO 8601, YYYY-MM-DD)
ausgang_wertDecimal number (dot as decimal separator)
ziel_wertDecimal number (dot as decimal separator)
verantwortlichIdentifier (UUID, text)
faellig_amDate (ISO 8601, YYYY-MM-DD)
statusText (UTF-8)
ergebnisText (UTF-8)
erledigt_amTimestamp (ISO 8601 with UTC offset)
erledigt_vonIdentifier (UUID, text)
erstellt_vonIdentifier (UUID, text)
erstellt_amTimestamp (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

FieldFormatValues
idIdentifier (UUID, text)
system_idIdentifier (UUID, text)
location_idIdentifier (UUID, text)
periodDate (ISO 8601, YYYY-MM-DD)
kennzahlText (UTF-8)
stufeText (UTF-8)
richtungText (UTF-8)
wertDecimal number (dot as decimal separator)
schwelleDecimal number (dot as decimal separator)
ausgeloest_amTimestamp (ISO 8601 with UTC offset)
geprueft_amTimestamp (ISO 8601 with UTC offset)
gemeldet_amTimestamp (ISO 8601 with UTC offset)
erledigt_amTimestamp (ISO 8601 with UTC offset)
erledigt_grundText (UTF-8)

Daily revenue

Revenue per location and day.

JSON: daten/partner/tagesumsaetze.json · CSV: daten/partner/tagesumsaetze.csv

FieldFormatValues
idIdentifier (UUID, text)
system_idIdentifier (UUID, text)
location_idIdentifier (UUID, text)
datumDate (ISO 8601, YYYY-MM-DD)
umsatzDecimal number (dot as decimal separator)
created_byIdentifier (UUID, text)
created_atTimestamp (ISO 8601 with UTC offset)
quelleText (UTF-8)
bonsInteger
kasseText (UTF-8)
kasse_standTimestamp (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

FieldFormatValues
idIdentifier (UUID, text)
system_idIdentifier (UUID, text)
kindText (UTF-8)
titleText (UTF-8)
bodyText (UTF-8)
created_byIdentifier (UUID, text)
assignee_idIdentifier (UUID, text)
location_idIdentifier (UUID, text)
due_atTimestamp (ISO 8601 with UTC offset)
statusText (UTF-8)
responseText (UTF-8)
done_atTimestamp (ISO 8601 with UTC offset)
done_byIdentifier (UUID, text)
created_atTimestamp (ISO 8601 with UTC offset)
scopeText (UTF-8)
taktText (UTF-8)
activeBoolean (true/false)
rollout_idIdentifier (UUID, text)

Completions

Completed tasks per period.

JSON: daten/aufgaben/aufgaben_erledigungen.json · CSV: daten/aufgaben/aufgaben_erledigungen.csv

FieldFormatValues
idIdentifier (UUID, text)
task_idIdentifier (UUID, text)
system_idIdentifier (UUID, text)
period_startDate (ISO 8601, YYYY-MM-DD)
done_byIdentifier (UUID, text)
done_atTimestamp (ISO 8601 with UTC offset)
noteText (UTF-8)

Checklists

Checklist templates.

JSON: daten/aufgaben/checklisten.json · CSV: daten/aufgaben/checklisten.csv

FieldFormatValues
idIdentifier (UUID, text)
system_idIdentifier (UUID, text)
titleText (UTF-8)
descriptionText (UTF-8)
kindEnumerated value (text, see values)oeffnen, schliessen, hygiene, audit, sonstige
taktEnumerated value (text, see values)taeglich, woechentlich, monatlich, bedarf
chapter_idIdentifier (UUID, text)
target_rolesList (JSON array) of: Enumerated value (text, see values)zentrale, multi_unit_partner, partner, schichtleitung, mitarbeiter
activeBoolean (true/false)
sort_orderInteger
created_atTimestamp (ISO 8601 with UTC offset)
vorlage_schluesselText (UTF-8)
punkt_schluesselText (UTF-8)
vorlage_versionText (UTF-8)
faellig_bisTime 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

FieldFormatValues
idIdentifier (UUID, text)
checklist_idIdentifier (UUID, text)
positionInteger
labelText (UTF-8)
feldEnumerated value (text, see values)haken, zahl, text, foto
requiredBoolean (true/false)
min_valueDecimal number (dot as decimal separator)
max_valueDecimal number (dot as decimal separator)
unitText (UTF-8)
hintText (UTF-8)
chapter_idIdentifier (UUID, text)
activeBoolean (true/false)
vorlage_schluesselText (UTF-8)
punkt_schluesselText (UTF-8)
vorlage_versionText (UTF-8)

Checklist locations

Validity per location.

JSON: daten/aufgaben/checklisten_standorte.json · CSV: daten/aufgaben/checklisten_standorte.csv

FieldFormatValues
checklist_idIdentifier (UUID, text)
location_idIdentifier (UUID, text)
system_idIdentifier (UUID, text)

Runs

Completed checklists.

JSON: daten/aufgaben/checklisten_durchgaenge.json · CSV: daten/aufgaben/checklisten_durchgaenge.csv

FieldFormatValues
idIdentifier (UUID, text)
system_idIdentifier (UUID, text)
checklist_idIdentifier (UUID, text)
location_idIdentifier (UUID, text)
by_userIdentifier (UUID, text)
started_atTimestamp (ISO 8601 with UTC offset)
completed_atTimestamp (ISO 8601 with UTC offset)
noteText (UTF-8)
has_deviationBoolean (true/false)
titleText (UTF-8)
kindEnumerated value (text, see values)oeffnen, schliessen, hygiene, audit, sonstige
taktEnumerated value (text, see values)taeglich, woechentlich, monatlich, bedarf
schnappschuss_nachgetragenBoolean (true/false)

Results

Answers per item; photos under dateien/checklist-photos/.

JSON: daten/aufgaben/checklisten_ergebnisse.json · CSV: daten/aufgaben/checklisten_ergebnisse.csv

FieldFormatValues
run_idIdentifier (UUID, text)
item_idIdentifier (UUID, text)
okBoolean (true/false)
valueDecimal number (dot as decimal separator)
text_valueText (UTF-8)
photo_pathText (UTF-8)
recorded_atTimestamp (ISO 8601 with UTC offset)
massnahmeText (UTF-8)
labelText (UTF-8)
feldEnumerated value (text, see values)haken, zahl, text, foto
requiredBoolean (true/false)
min_valueDecimal number (dot as decimal separator)
max_valueDecimal number (dot as decimal separator)
unitText (UTF-8)
hintText (UTF-8)

Store audit templates

Store audit templates.

JSON: daten/aufgaben/storecheck_vorlagen.json · CSV: daten/aufgaben/storecheck_vorlagen.csv

FieldFormatValues
idIdentifier (UUID, text)
system_idIdentifier (UUID, text)
nameText (UTF-8)
beschreibungText (UTF-8)
bestanden_ab_prozentInteger
aktivBoolean (true/false)
created_atTimestamp (ISO 8601 with UTC offset)

Store audit items

Items of the templates.

JSON: daten/aufgaben/storecheck_fragen.json · CSV: daten/aufgaben/storecheck_fragen.csv

FieldFormatValues
idIdentifier (UUID, text)
template_idIdentifier (UUID, text)
system_idIdentifier (UUID, text)
kategorieText (UTF-8)
frageText (UTF-8)
hinweisText (UTF-8)
punkteInteger
koBoolean (true/false)
foto_pflichtBoolean (true/false)
positionInteger

Store audits

Performed store audits with result.

JSON: daten/aufgaben/storechecks.json · CSV: daten/aufgaben/storechecks.csv

FieldFormatValues
idIdentifier (UUID, text)
system_idIdentifier (UUID, text)
location_idIdentifier (UUID, text)
template_idIdentifier (UUID, text)
auditorIdentifier (UUID, text)
statusEnumerated value (text, see values)geplant, laeuft, abgeschlossen, abgebrochen
geplant_amDate (ISO 8601, YYYY-MM-DD)
begonnen_amTimestamp (ISO 8601 with UTC offset)
abgeschlossen_amTimestamp (ISO 8601 with UTC offset)
punkte_erreichtInteger
punkte_moeglichInteger
quoteDecimal number (dot as decimal separator)
bestandenBoolean (true/false)
ko_verletztBoolean (true/false)
fazitText (UTF-8)
created_atTimestamp (ISO 8601 with UTC offset)
bestanden_ab_prozentInteger

Store audit results

Rating per item.

JSON: daten/aufgaben/storecheck_ergebnisse.json · CSV: daten/aufgaben/storecheck_ergebnisse.csv

FieldFormatValues
audit_idIdentifier (UUID, text)
item_idIdentifier (UUID, text)
system_idIdentifier (UUID, text)
bewertungText (UTF-8)
punkteInteger
bemerkungText (UTF-8)
foto_pathText (UTF-8)

Actions

Actions from store audits.

JSON: daten/aufgaben/storecheck_massnahmen.json · CSV: daten/aufgaben/storecheck_massnahmen.csv

FieldFormatValues
idIdentifier (UUID, text)
audit_idIdentifier (UUID, text)
system_idIdentifier (UUID, text)
item_idIdentifier (UUID, text)
textText (UTF-8)
fristDate (ISO 8601, YYYY-MM-DD)
erledigt_amTimestamp (ISO 8601 with UTC offset)
erledigt_vonIdentifier (UUID, text)
created_atTimestamp (ISO 8601 with UTC offset)
erledigt_notizText (UTF-8)

Cancellations

Cancelled store audits.

JSON: daten/aufgaben/storecheck_abbrueche.json · CSV: daten/aufgaben/storecheck_abbrueche.csv

FieldFormatValues
audit_idIdentifier (UUID, text)
system_idIdentifier (UUID, text)
abgebrochen_vonIdentifier (UUID, text)
abgebrochen_amTimestamp (ISO 8601 with UTC offset)
grundText (UTF-8)

Projects

Projects such as openings and refits.

JSON: daten/aufgaben/vorhaben.json · CSV: daten/aufgaben/vorhaben.csv

FieldFormatValues
idIdentifier (UUID, text)
system_idIdentifier (UUID, text)
location_idIdentifier (UUID, text)
vorlage_idIdentifier (UUID, text)
rollout_idIdentifier (UUID, text)
titelText (UTF-8)
beschreibungText (UTF-8)
statusEnumerated value (text, see values)geplant, laeuft, abgeschlossen, abgebrochen
stichtagDate (ISO 8601, YYYY-MM-DD)
verantwortlichIdentifier (UUID, text)
created_byIdentifier (UUID, text)
created_atTimestamp (ISO 8601 with UTC offset)
abgeschlossen_amTimestamp (ISO 8601 with UTC offset)

Project sections

Sections of the projects.

JSON: daten/aufgaben/vorhaben_abschnitte.json · CSV: daten/aufgaben/vorhaben_abschnitte.csv

FieldFormatValues
idIdentifier (UUID, text)
system_idIdentifier (UUID, text)
vorhaben_idIdentifier (UUID, text)
nameText (UTF-8)
reihenfolgeInteger
created_atTimestamp (ISO 8601 with UTC offset)

Project steps

Steps with deadlines.

JSON: daten/aufgaben/vorhaben_schritte.json · CSV: daten/aufgaben/vorhaben_schritte.csv

FieldFormatValues
idIdentifier (UUID, text)
vorhaben_idIdentifier (UUID, text)
system_idIdentifier (UUID, text)
titelText (UTF-8)
beschreibungText (UTF-8)
zustaendigIdentifier (UUID, text)
faellig_amDate (ISO 8601, YYYY-MM-DD)
erledigt_amTimestamp (ISO 8601 with UTC offset)
erledigt_vonIdentifier (UUID, text)
reihenfolgeInteger
abschnitt_idIdentifier (UUID, text)

Project comments

Comments on projects.

JSON: daten/aufgaben/vorhaben_kommentare.json · CSV: daten/aufgaben/vorhaben_kommentare.csv

FieldFormatValues
idIdentifier (UUID, text)
system_idIdentifier (UUID, text)
vorhaben_idIdentifier (UUID, text)
schritt_idIdentifier (UUID, text)
user_idIdentifier (UUID, text)
textText (UTF-8)
created_atTimestamp (ISO 8601 with UTC offset)

Project templates

Templates for rollouts.

JSON: daten/aufgaben/vorhaben_vorlagen.json · CSV: daten/aufgaben/vorhaben_vorlagen.csv

FieldFormatValues
idIdentifier (UUID, text)
system_idIdentifier (UUID, text)
nameText (UTF-8)
beschreibungText (UTF-8)
bezugText (UTF-8)
aktivBoolean (true/false)
created_atTimestamp (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

FieldFormatValues
idIdentifier (UUID, text)
vorlage_idIdentifier (UUID, text)
system_idIdentifier (UUID, text)
titelText (UTF-8)
beschreibungText (UTF-8)
abschnittText (UTF-8)
rolleEnumerated value (text, see values)zentrale, multi_unit_partner, partner, schichtleitung, mitarbeiter
versatz_tageInteger
reihenfolgeInteger

Tickets

Requests from the locations.

JSON: daten/aufgaben/tickets.json · CSV: daten/aufgaben/tickets.csv

FieldFormatValues
idIdentifier (UUID, text)
system_idIdentifier (UUID, text)
location_idIdentifier (UUID, text)
created_byIdentifier (UUID, text)
assignee_idIdentifier (UUID, text)
subjectText (UTF-8)
bodyText (UTF-8)
statusText (UTF-8)
created_atTimestamp (ISO 8601 with UTC offset)
done_atTimestamp (ISO 8601 with UTC offset)
done_byIdentifier (UUID, text)

Ticket messages

Ticket conversation.

JSON: daten/aufgaben/ticket_nachrichten.json · CSV: daten/aufgaben/ticket_nachrichten.csv

FieldFormatValues
idIdentifier (UUID, text)
ticket_idIdentifier (UUID, text)
system_idIdentifier (UUID, text)
author_idIdentifier (UUID, text)
bodyText (UTF-8)
created_atTimestamp (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

FieldFormatValues
idIdentifier (UUID, text)
system_idIdentifier (UUID, text)
nameText (UTF-8)
bestell_emailText (UTF-8)
ansprechpartnerText (UTF-8)
telefonText (UTF-8)
kundennummerText (UTF-8)
lieferhinweisText (UTF-8)
notizText (UTF-8)
aktivBoolean (true/false)
nur_standorteList (JSON array) of: Identifier (UUID, text)
created_atTimestamp (ISO 8601 with UTC offset)
aktualisiert_amTimestamp (ISO 8601 with UTC offset)
mindestbestellwertDecimal number (dot as decimal separator)
mindestwert_sperrtBoolean (true/false)
liefertageList (JSON array) of: Integer
bestellschlussTime of day (HH:MM:SS, local time of the location)
vorlauf_tageInteger

Items

Supplier assortment.

JSON: daten/bestellungen/lieferanten_artikel.json · CSV: daten/bestellungen/lieferanten_artikel.csv

FieldFormatValues
idIdentifier (UUID, text)
supplier_idIdentifier (UUID, text)
system_idIdentifier (UUID, text)
nameText (UTF-8)
einheitText (UTF-8)
artikelnummerText (UTF-8)
min_mengeDecimal number (dot as decimal separator)
schrittweiteDecimal number (dot as decimal separator)
preisDecimal number (dot as decimal separator)
kategorieText (UTF-8)
aktivBoolean (true/false)
positionInteger
created_atTimestamp (ISO 8601 with UTC offset)
max_mengeDecimal number (dot as decimal separator)
inhaltText (UTF-8)

Suppliers per location

Customer numbers per location.

JSON: daten/bestellungen/lieferanten_standorte.json · CSV: daten/bestellungen/lieferanten_standorte.csv

FieldFormatValues
supplier_idIdentifier (UUID, text)
location_idIdentifier (UUID, text)
system_idIdentifier (UUID, text)
kundennummerText (UTF-8)

Orders

Orders with status and cancellation (without supplier reply key).

JSON: daten/bestellungen/bestellungen.json · CSV: daten/bestellungen/bestellungen.csv

FieldFormatValues
idIdentifier (UUID, text)
system_idIdentifier (UUID, text)
location_idIdentifier (UUID, text)
supplier_idIdentifier (UUID, text)
nummerText (UTF-8)
statusEnumerated value (text, see values)entwurf, gesendet, bestaetigt, geliefert, storniert
wunschterminDate (ISO 8601, YYYY-MM-DD)
bemerkungText (UTF-8)
by_userIdentifier (UUID, text)
gesendet_amTimestamp (ISO 8601 with UTC offset)
created_atTimestamp (ISO 8601 with UTC offset)
mail_gesendet_amTimestamp (ISO 8601 with UTC offset)
mail_versucheInteger
mail_fehlerText (UTF-8)
bestaetigt_amTimestamp (ISO 8601 with UTC offset)
im_postausgangBoolean (true/false)
storniert_amTimestamp (ISO 8601 with UTC offset)
storniert_vonIdentifier (UUID, text)
storno_grundText (UTF-8)
storno_vorherEnumerated value (text, see values)entwurf, gesendet, bestaetigt, geliefert, storniert
storno_mail_offenBoolean (true/false)
storno_mail_gesendet_amTimestamp (ISO 8601 with UTC offset)
storno_mail_versucheInteger
storno_mail_fehlerText (UTF-8)
bestellmail_versuch_amTimestamp (ISO 8601 with UTC offset)
bestellmail_versuch_ende_amTimestamp (ISO 8601 with UTC offset)
bestellmail_versuch_idIdentifier (UUID, text)
im_auftragBoolean (true/false)

Order items

Items of the orders.

JSON: daten/bestellungen/bestellpositionen.json · CSV: daten/bestellungen/bestellpositionen.csv

FieldFormatValues
idIdentifier (UUID, text)
order_idIdentifier (UUID, text)
system_idIdentifier (UUID, text)
item_idIdentifier (UUID, text)
nameText (UTF-8)
einheitText (UTF-8)
artikelnummerText (UTF-8)
mengeDecimal number (dot as decimal separator)
preisDecimal number (dot as decimal separator)
positionInteger

Storage areas

Storage areas per location for stocktaking.

JSON: daten/bestellungen/inventur_lagerorte.json · CSV: daten/bestellungen/inventur_lagerorte.csv

FieldFormatValues
idIdentifier (UUID, text)
system_idIdentifier (UUID, text)
location_idIdentifier (UUID, text)
nameText (UTF-8)
positionInteger
aktivBoolean (true/false)
created_atTimestamp (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

FieldFormatValues
idIdentifier (UUID, text)
system_idIdentifier (UUID, text)
location_idIdentifier (UUID, text)
stichtagDate (ISO 8601, YYYY-MM-DD)
statusText (UTF-8)
bemerkungText (UTF-8)
gestartet_vonIdentifier (UUID, text)
gestartet_amTimestamp (ISO 8601 with UTC offset)
abgeschlossen_vonIdentifier (UUID, text)
abgeschlossen_amTimestamp (ISO 8601 with UTC offset)
als_null_gewertetInteger
wert_gesamtDecimal number (dot as decimal separator)
storniert_vonIdentifier (UUID, text)
storniert_amTimestamp (ISO 8601 with UTC offset)
storno_grundText (UTF-8)
storniert_ausText (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

FieldFormatValues
idIdentifier (UUID, text)
system_idIdentifier (UUID, text)
inventur_idIdentifier (UUID, text)
lagerort_idIdentifier (UUID, text)
artikel_idIdentifier (UUID, text)
freiBoolean (true/false)
nameText (UTF-8)
einheitText (UTF-8)
inhaltText (UTF-8)
artikelnummerText (UTF-8)
lieferantText (UTF-8)
stueck_je_einheitDecimal number (dot as decimal separator)
preisDecimal number (dot as decimal separator)
mengeDecimal number (dot as decimal separator)
anbruch_stueckDecimal number (dot as decimal separator)
menge_gesamtDecimal number (dot as decimal separator)
wertDecimal number (dot as decimal separator)
als_nullBoolean (true/false)
fassungInteger
letzter_vorgangIdentifier (UUID, text)
gezaehlt_vonIdentifier (UUID, text)
gezaehlt_amTimestamp (ISO 8601 with UTC offset)
geraetezeitTimestamp (ISO 8601 with UTC offset)
quelleText (UTF-8)
Hygiene (HACCP) · 22 Files

HACCP plans

Approved versions with hazard analysis.

JSON: daten/hygiene/plaene.json · CSV: daten/hygiene/plaene.csv

FieldFormatValues
idIdentifier (UUID, text)
system_idIdentifier (UUID, text)
versionInteger
titelText (UTF-8)
geltungsbereichText (UTF-8)
gefahrenanalyseJSON (object or list; JSON text in CSV)
aenderungText (UTF-8)
freigegeben_vonIdentifier (UUID, text)
freigegeben_amTimestamp (ISO 8601 with UTC offset)
vorgaenger_idIdentifier (UUID, text)
inhaltJSON (object or list; JSON text in CSV)
fachlich_geprueft_vonText (UTF-8)
fachlich_geprueft_amDate (ISO 8601, YYYY-MM-DD)

Plan acknowledgements

Acknowledgements per location.

JSON: daten/hygiene/plan_bestaetigungen.json · CSV: daten/hygiene/plan_bestaetigungen.csv

FieldFormatValues
plan_idIdentifier (UUID, text)
location_idIdentifier (UUID, text)
user_idIdentifier (UUID, text)
acknowledged_atTimestamp (ISO 8601 with UTC offset)
fassung_sha256Text (UTF-8)
anpassungenJSON (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

FieldFormatValues
idIdentifier (UUID, text)
system_idIdentifier (UUID, text)
location_idIdentifier (UUID, text)
artEnumerated value (text, see values)temperatur_geraet, kerntemperatur, abkuehlung, wareneingang, reinigung, schaedling, fritteuse_oel, spuelmaschine, sonstige
titelText (UTF-8)
hinweisText (UTF-8)
taktEnumerated value (text, see values)taeglich, woechentlich, monatlich, je_ereignis, bedarf
zeitfensterJSON (object or list; JSON text in CSV)
wochentagInteger
monatstagInteger
equipment_artEnumerated 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_idIdentifier (UUID, text)
feldText (UTF-8)
min_wertDecimal number (dot as decimal separator)
max_wertDecimal number (dot as decimal separator)
einheitText (UTF-8)
foto_pflichtBoolean (true/false)
zielrollenList (JSON array) of: Enumerated value (text, see values)zentrale, multi_unit_partner, partner, schichtleitung, mitarbeiter
massnahmen_vorlageJSON (object or list; JSON text in CSV)
chapter_idIdentifier (UUID, text)
sortInteger
aktivBoolean (true/false)
gueltig_abDate (ISO 8601, YYYY-MM-DD)
gueltig_bisDate (ISO 8601, YYYY-MM-DD)
erstellt_vonIdentifier (UUID, text)
erstellt_amTimestamp (ISO 8601 with UTC offset)
geaendert_vonIdentifier (UUID, text)
geaendert_amTimestamp (ISO 8601 with UTC offset)
bereichText (UTF-8)
reinigungsmittelText (UTF-8)
konzentrationText (UTF-8)
einwirkzeitText (UTF-8)
aktiv_seitTimestamp (ISO 8601 with UTC offset)
themaText (UTF-8)
vorlage_schluesselText (UTF-8)
punkt_schluesselText (UTF-8)
vorlage_versionText (UTF-8)
verbindlichkeitText (UTF-8)
quelleText (UTF-8)
quelle_urlText (UTF-8)
nur_standorteList (JSON array) of: Identifier (UUID, text)
nur_deutschlandBoolean (true/false)
uebersetzungJSON (object or list; JSON text in CSV)
nur_laenderList (JSON array) of: Text (UTF-8)
laender_punktText (UTF-8)
partner_anpassbarBoolean (true/false)

Limits

Stored limit values.

JSON: daten/hygiene/grenzwerte.json · CSV: daten/hygiene/grenzwerte.csv

FieldFormatValues
idIdentifier (UUID, text)
system_idIdentifier (UUID, text)
schluesselText (UTF-8)
min_wertDecimal number (dot as decimal separator)
max_wertDecimal number (dot as decimal separator)
einheitText (UTF-8)
gilt_abDate (ISO 8601, YYYY-MM-DD)
quelleText (UTF-8)
vorlage_schluesselText (UTF-8)
punkt_schluesselText (UTF-8)
vorlage_versionText (UTF-8)
eigener_wertBoolean (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

FieldFormatValues
idIdentifier (UUID, text)
system_idIdentifier (UUID, text)
location_idIdentifier (UUID, text)
artText (UTF-8)
control_idIdentifier (UUID, text)
plan_idIdentifier (UUID, text)
stufe_kennungText (UTF-8)
stufe_nameText (UTF-8)
grundText (UTF-8)
begruendungText (UTF-8)
abDate (ISO 8601, YYYY-MM-DD)
erstellt_vonIdentifier (UUID, text)
erstellt_amTimestamp (ISO 8601 with UTC offset)
wieder_abDate (ISO 8601, YYYY-MM-DD)
aufgehoben_vonIdentifier (UUID, text)
aufgehoben_amTimestamp (ISO 8601 with UTC offset)
aufhebung_grundText (UTF-8)
aufhebung_artText (UTF-8)
bestaetigt_amTimestamp (ISO 8601 with UTC offset)
punkt_artList (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

FieldFormatValues
idIdentifier (UUID, text)
system_idIdentifier (UUID, text)
location_idIdentifier (UUID, text)
control_idIdentifier (UUID, text)
zeitfensterJSON (object or list; JSON text in CSV)
taktEnumerated value (text, see values)taeglich, woechentlich, monatlich, je_ereignis, bedarf
wochentagInteger
monatstagInteger
min_wertDecimal number (dot as decimal separator)
max_wertDecimal number (dot as decimal separator)
hinweisText (UTF-8)
zielrollenList (JSON array) of: Enumerated value (text, see values)zentrale, multi_unit_partner, partner, schichtleitung, mitarbeiter
begruendungText (UTF-8)
bestaetigt_amTimestamp (ISO 8601 with UTC offset)
punkt_artList (JSON array) of: Text (UTF-8)
abDate (ISO 8601, YYYY-MM-DD)
erstellt_vonIdentifier (UUID, text)
erstellt_amTimestamp (ISO 8601 with UTC offset)
wieder_abDate (ISO 8601, YYYY-MM-DD)
aufgehoben_vonIdentifier (UUID, text)
aufgehoben_amTimestamp (ISO 8601 with UTC offset)
aufhebung_grundText (UTF-8)
aufhebung_artText (UTF-8)
vorgabeJSON (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

FieldFormatValues
idIdentifier (UUID, text)
system_idIdentifier (UUID, text)
stufe_kennungText (UTF-8)
stufe_nameText (UTF-8)
gesperrt_vonIdentifier (UUID, text)
gesperrt_amTimestamp (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

FieldFormatValues
idIdentifier (UUID, text)
plan_idIdentifier (UUID, text)
system_idIdentifier (UUID, text)
spracheText (UTF-8)
titelText (UTF-8)
geltungsbereichText (UTF-8)
stufenJSON (object or list; JSON text in CSV)
erstellt_vonIdentifier (UUID, text)
erstellt_amTimestamp (ISO 8601 with UTC offset)
geaendert_vonIdentifier (UUID, text)
geaendert_amTimestamp (ISO 8601 with UTC offset)
freigegeben_vonIdentifier (UUID, text)
freigegeben_amTimestamp (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

FieldFormatValues
idIdentifier (UUID, text)
system_idIdentifier (UUID, text)
menue_produkt_idIdentifier (UUID, text)
nameText (UTF-8)
gruppeText (UTF-8)
allergeneList (JSON array) of: Text (UTF-8)
spurenList (JSON array) of: Text (UTF-8)
hinweisText (UTF-8)
aktivBoolean (true/false)
versionInteger
geaendert_vonIdentifier (UUID, text)
geaendert_amTimestamp (ISO 8601 with UTC offset)
erstellt_amTimestamp (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

FieldFormatValues
idIdentifier (UUID, text)
system_idIdentifier (UUID, text)
produkt_idIdentifier (UUID, text)
versionInteger
nameText (UTF-8)
gruppeText (UTF-8)
allergeneList (JSON array) of: Text (UTF-8)
spurenList (JSON array) of: Text (UTF-8)
hinweisText (UTF-8)
aktivBoolean (true/false)
grundText (UTF-8)
geaendert_vonIdentifier (UUID, text)
geaendert_amTimestamp (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

FieldFormatValues
idIdentifier (UUID, text)
system_idIdentifier (UUID, text)
vorgangIdentifier (UUID, text)
vorlage_schluesselText (UTF-8)
versionText (UTF-8)
vonIdentifier (UUID, text)
amTimestamp (ISO 8601 with UTC offset)
hinweis_fassungText (UTF-8)
hinweis_bestaetigtBoolean (true/false)
plan_idIdentifier (UUID, text)
ergebnisJSON (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

FieldFormatValues
idInteger
system_idIdentifier (UUID, text)
uebernahme_idIdentifier (UUID, text)
typText (UTF-8)
eltern_schluesselText (UTF-8)
punkt_schluesselText (UTF-8)
vorlage_schluesselText (UTF-8)
versionText (UTF-8)
entscheidungText (UTF-8)
ziel_idIdentifier (UUID, text)

Equipment

Cooling and measuring devices per location.

JSON: daten/hygiene/geraete.json · CSV: daten/hygiene/geraete.csv

FieldFormatValues
idIdentifier (UUID, text)
system_idIdentifier (UUID, text)
location_idIdentifier (UUID, text)
nameText (UTF-8)
artEnumerated value (text, see values)kuehlschrank, tiefkuehler, kuehlvitrine, heisshaltung, fritteuse, spuelmaschine, eismaschine, sonstiges, koederbox, insektenfalle, uv_falle, sahneautomat, kaffeemaschine, glaeserspueler, schankanlage, saladette, eisvitrine, eiswuerfelbereiter, softeismaschine
bereichText (UTF-8)
soll_minDecimal number (dot as decimal separator)
soll_maxDecimal number (dot as decimal separator)
einheitText (UTF-8)
sortInteger
aktivBoolean (true/false)
ausser_betrieb_vonDate (ISO 8601, YYYY-MM-DD)
ausser_betrieb_bisDate (ISO 8601, YYYY-MM-DD)
erstellt_vonIdentifier (UUID, text)
erstellt_amTimestamp (ISO 8601 with UTC offset)
geaendert_vonIdentifier (UUID, text)
geaendert_amTimestamp (ISO 8601 with UTC offset)
aktiv_seitTimestamp (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

FieldFormatValues
idIdentifier (UUID, text)
location_idIdentifier (UUID, text)
control_idIdentifier (UUID, text)
equipment_idIdentifier (UUID, text)
seqInteger
tagDate (ISO 8601, YYYY-MM-DD)
zeitfenster_indexInteger
statusText (UTF-8)
wertDecimal number (dot as decimal separator)
text_wertText (UTF-8)
hakenBoolean (true/false)
foto_pathText (UTF-8)
personText (UTF-8)
rolleEnumerated value (text, see values)zentrale, multi_unit_partner, partner, schichtleitung, mitarbeiter
quelleText (UTF-8)
erfasst_amTimestamp (ISO 8601 with UTC offset)
geraetezeitTimestamp (ISO 8601 with UTC offset)
nachgetragenBoolean (true/false)
nachtrag_grundText (UTF-8)
bezug_idIdentifier (UUID, text)
kontroll_schnappschussJSON (object or list; JSON text in CSV)
storniert_amTimestamp (ISO 8601 with UTC offset)
storniert_vonText (UTF-8)
vorheriger_hashText (UTF-8)
hashText (UTF-8)

Goods receipts

Deliveries with inspection result.

JSON: daten/hygiene/wareneingaenge.json · CSV: daten/hygiene/wareneingaenge.csv

FieldFormatValues
idIdentifier (UUID, text)
location_idIdentifier (UUID, text)
record_idIdentifier (UUID, text)
supplier_idIdentifier (UUID, text)
lieferant_nameText (UTF-8)
lieferschein_nrText (UTF-8)
lieferschein_fotoText (UTF-8)
order_idIdentifier (UUID, text)
transport_tempDecimal number (dot as decimal separator)
ergebnisText (UTF-8)
bemerkungText (UTF-8)
personText (UTF-8)
erfasst_amTimestamp (ISO 8601 with UTC offset)

Goods receipt items

Inspected items per delivery.

JSON: daten/hygiene/wareneingang_positionen.json · CSV: daten/hygiene/wareneingang_positionen.csv

FieldFormatValues
idIdentifier (UUID, text)
delivery_idIdentifier (UUID, text)
positionInteger
supplier_item_idIdentifier (UUID, text)
artikelText (UTF-8)
warengruppeEnumerated value (text, see values)kuehl, tiefkuehl, gefluegel, hackfleisch, fleisch, fisch, milch, trocken, obst_gemuese, sonstige, hackfleisch_tk, innereien, fleischzubereitung
mengeDecimal number (dot as decimal separator)
einheitText (UTF-8)
temperaturDecimal number (dot as decimal separator)
grenzeDecimal number (dot as decimal separator)
mhdDate (ISO 8601, YYYY-MM-DD)
chargeText (UTF-8)
sicht_okBoolean (true/false)
angenommenBoolean (true/false)
mangelText (UTF-8)
foto_pathText (UTF-8)

Daily sign-offs

Confirmed days with day hash.

JSON: daten/hygiene/tagesabschluesse.json · CSV: daten/hygiene/tagesabschluesse.csv

FieldFormatValues
idIdentifier (UUID, text)
location_idIdentifier (UUID, text)
tagDate (ISO 8601, YYYY-MM-DD)
personText (UTF-8)
rolleEnumerated value (text, see values)zentrale, multi_unit_partner, partner, schichtleitung, mitarbeiter
bestaetigt_mitText (UTF-8)
offene_kontrollenInteger
offene_abweichungenInteger
bemerkungText (UTF-8)
tageshashText (UTF-8)
erfasst_amTimestamp (ISO 8601 with UTC offset)

Deviations

Deviations with immediate action, cause, correction and effectiveness.

JSON: daten/hygiene/abweichungen.json · CSV: daten/hygiene/abweichungen.csv

FieldFormatValues
idIdentifier (UUID, text)
location_idIdentifier (UUID, text)
record_idIdentifier (UUID, text)
control_idIdentifier (UUID, text)
equipment_idIdentifier (UUID, text)
inspection_idIdentifier (UUID, text)
quelleText (UTF-8)
schwereInteger
titelText (UTF-8)
statusText (UTF-8)
sofortmassnahmeText (UTF-8)
sofortmassnahme_fotoText (UTF-8)
sofort_vonText (UTF-8)
sofort_amTimestamp (ISO 8601 with UTC offset)
ursacheText (UTF-8)
ursache_vonText (UTF-8)
ursache_amTimestamp (ISO 8601 with UTC offset)
korrekturText (UTF-8)
verantwortlichText (UTF-8)
fristDate (ISO 8601, YYYY-MM-DD)
korrektur_vonText (UTF-8)
korrektur_amTimestamp (ISO 8601 with UTC offset)
erledigt_vonText (UTF-8)
erledigt_amTimestamp (ISO 8601 with UTC offset)
wirksam_vonText (UTF-8)
wirksam_amTimestamp (ISO 8601 with UTC offset)
verworfen_grundText (UTF-8)
verworfen_vonText (UTF-8)
verworfen_amTimestamp (ISO 8601 with UTC offset)
musterBoolean (true/false)
eskaliert_partner_amTimestamp (ISO 8601 with UTC offset)
eskaliert_zentrale_amTimestamp (ISO 8601 with UTC offset)
erstellt_amTimestamp (ISO 8601 with UTC offset)
korrektur_fotoText (UTF-8)

Deviation history

Every processing step of deviations.

JSON: daten/hygiene/abweichungen_verlauf.json · CSV: daten/hygiene/abweichungen_verlauf.csv

FieldFormatValues
idInteger
deviation_idIdentifier (UUID, text)
personText (UTF-8)
schrittText (UTF-8)
vorherJSON (object or list; JSON text in CSV)
nachherJSON (object or list; JSON text in CSV)
geaendert_amTimestamp (ISO 8601 with UTC offset)

Official inspections

Inspections by authorities.

JSON: daten/hygiene/amtsbesuche.json · CSV: daten/hygiene/amtsbesuche.csv

FieldFormatValues
idIdentifier (UUID, text)
location_idIdentifier (UUID, text)
datumDate (ISO 8601, YYYY-MM-DD)
behoerdeText (UTF-8)
kontrolleurText (UTF-8)
ergebnisText (UTF-8)
bemerkungText (UTF-8)
erfasst_vonText (UTF-8)
erfasst_amTimestamp (ISO 8601 with UTC offset)

Quarantine

Unassignable device entries and their resolution.

JSON: daten/hygiene/quarantaene.json · CSV: daten/hygiene/quarantaene.csv

FieldFormatValues
idIdentifier (UUID, text)
location_idIdentifier (UUID, text)
control_idIdentifier (UUID, text)
titelText (UTF-8)
eintragJSON (object or list; JSON text in CSV)
grundText (UTF-8)
personText (UTF-8)
geraetezeitTimestamp (ISO 8601 with UTC offset)
gemeldet_amTimestamp (ISO 8601 with UTC offset)
geklaert_amTimestamp (ISO 8601 with UTC offset)
geklaert_vonText (UTF-8)
klaerungText (UTF-8)

Reports

Generated hygiene reports (metadata and checksum).

JSON: daten/hygiene/berichte.json · CSV: daten/hygiene/berichte.csv

FieldFormatValues
idIdentifier (UUID, text)
location_idIdentifier (UUID, text)
artText (UTF-8)
vonDate (ISO 8601, YYYY-MM-DD)
bisDate (ISO 8601, YYYY-MM-DD)
sha256Text (UTF-8)
erzeugt_vonText (UTF-8)
erzeugt_amTimestamp (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

FieldFormatValues
idIdentifier (UUID, text)
system_idIdentifier (UUID, text)
location_idIdentifier (UUID, text)
playlist_idIdentifier (UUID, text)
nameText (UTF-8)
zuletzt_gesehenTimestamp (ISO 8601 with UTC offset)
created_atTimestamp (ISO 8601 with UTC offset)
playlist_vorherIdentifier (UUID, text)
zeigt_item_idIdentifier (UUID, text)
geraetText (UTF-8)
drehungInteger
sync_delay_msInteger
betrieb_vonTime of day (HH:MM:SS, local time of the location)
betrieb_bisTime of day (HH:MM:SS, local time of the location)
restart_idIdentifier (UUID, text)
im_notfallBoolean (true/false)
fehler_item_idIdentifier (UUID, text)
fehler_amTimestamp (ISO 8601 with UTC offset)
kanal_idIdentifier (UUID, text)
gruppe_idIdentifier (UUID, text)
zeitplanJSON (object or list; JSON text in CSV)
lautstaerkeInteger
telemetrieJSON (object or list; JSON text in CSV)
faehigkeitenList (JSON array) of: Text (UTF-8)
geraet_gesehenTimestamp (ISO 8601 with UTC offset)
regionText (UTF-8)
neu_koppeln_seitTimestamp (ISO 8601 with UTC offset)

Screen groups

Groups of screens.

JSON: daten/screens/bildschirm_gruppen.json · CSV: daten/screens/bildschirm_gruppen.csv

FieldFormatValues
idIdentifier (UUID, text)
system_idIdentifier (UUID, text)
nameText (UTF-8)
created_atTimestamp (ISO 8601 with UTC offset)

Screen labels

Labels.

JSON: daten/screens/bildschirm_label.json · CSV: daten/screens/bildschirm_label.csv

FieldFormatValues
idIdentifier (UUID, text)
system_idIdentifier (UUID, text)
nameText (UTF-8)
farbeText (UTF-8)
created_atTimestamp (ISO 8601 with UTC offset)

Label assignment

Labels per screen.

JSON: daten/screens/bildschirm_label_zuordnung.json · CSV: daten/screens/bildschirm_label_zuordnung.csv

FieldFormatValues
screen_idIdentifier (UUID, text)
label_idIdentifier (UUID, text)
system_idIdentifier (UUID, text)
created_atTimestamp (ISO 8601 with UTC offset)

Playlists

Playlists.

JSON: daten/screens/playlists.json · CSV: daten/screens/playlists.csv

FieldFormatValues
idIdentifier (UUID, text)
system_idIdentifier (UUID, text)
nameText (UTF-8)
created_atTimestamp (ISO 8601 with UTC offset)
synchronBoolean (true/false)
live_planJSON (object or list; JSON text in CSV)
veroeffentlicht_amTimestamp (ISO 8601 with UTC offset)
geaendert_amTimestamp (ISO 8601 with UTC offset)
farbeText (UTF-8)
erstellt_vonIdentifier (UUID, text)

Playlist items

Media per playlist with time rules.

JSON: daten/screens/playlist_eintraege.json · CSV: daten/screens/playlist_eintraege.csv

FieldFormatValues
idIdentifier (UUID, text)
playlist_idIdentifier (UUID, text)
system_idIdentifier (UUID, text)
medium_idIdentifier (UUID, text)
dauer_sInteger
reihenfolgeInteger
vonTime of day (HH:MM:SS, local time of the location)
bisTime of day (HH:MM:SS, local time of the location)
created_atTimestamp (ISO 8601 with UTC offset)
wochentageList (JSON array) of: Integer
gilt_vonDate (ISO 8601, YYYY-MM-DD)
gilt_bisDate (ISO 8601, YYYY-MM-DD)
folieJSON (object or list; JSON text in CSV)
nur_labelsList (JSON array) of: Identifier (UUID, text)
ohne_labelsList (JSON array) of: Identifier (UUID, text)
nur_standorteList (JSON array) of: Identifier (UUID, text)
ohne_standorteList (JSON array) of: Identifier (UUID, text)

Channels

Programme channels.

JSON: daten/screens/kanaele.json · CSV: daten/screens/kanaele.csv

FieldFormatValues
idIdentifier (UUID, text)
system_idIdentifier (UUID, text)
nameText (UTF-8)
farbeText (UTF-8)
rest_playlist_idIdentifier (UUID, text)
created_atTimestamp (ISO 8601 with UTC offset)

Channel slots

Time slots per channel.

JSON: daten/screens/kanal_zeitfenster.json · CSV: daten/screens/kanal_zeitfenster.csv

FieldFormatValues
idIdentifier (UUID, text)
kanal_idIdentifier (UUID, text)
system_idIdentifier (UUID, text)
playlist_idIdentifier (UUID, text)
wochentageList (JSON array) of: Integer
vonTime of day (HH:MM:SS, local time of the location)
bisTime of day (HH:MM:SS, local time of the location)
gilt_vonDate (ISO 8601, YYYY-MM-DD)
gilt_bisDate (ISO 8601, YYYY-MM-DD)
reihenfolgeInteger
created_atTimestamp (ISO 8601 with UTC offset)

Device commands

Restart, volume and other commands.

JSON: daten/screens/befehle.json · CSV: daten/screens/befehle.csv

FieldFormatValues
idIdentifier (UUID, text)
system_idIdentifier (UUID, text)
screen_idIdentifier (UUID, text)
artText (UTF-8)
wertInteger
erstellt_vonIdentifier (UUID, text)
erstellt_amTimestamp (ISO 8601 with UTC offset)
abgeholt_amTimestamp (ISO 8601 with UTC offset)
quittiert_amTimestamp (ISO 8601 with UTC offset)
okBoolean (true/false)
ergebnisText (UTF-8)

Alert rules

Offline notifications per location.

JSON: daten/screens/alarmregeln.json · CSV: daten/screens/alarmregeln.csv

FieldFormatValues
idIdentifier (UUID, text)
system_idIdentifier (UUID, text)
location_idIdentifier (UUID, text)
aktivBoolean (true/false)
empfaengerList (JSON array) of: Text (UTF-8)
wartezeit_minInteger
geaendert_amTimestamp (ISO 8601 with UTC offset)
geaendert_vonIdentifier (UUID, text)

Alerts

Offline alerts.

JSON: daten/screens/alarme.json · CSV: daten/screens/alarme.csv

FieldFormatValues
idIdentifier (UUID, text)
system_idIdentifier (UUID, text)
screen_idIdentifier (UUID, text)
location_idIdentifier (UUID, text)
offline_seitTimestamp (ISO 8601 with UTC offset)
erstellt_amTimestamp (ISO 8601 with UTC offset)
empfaengerList (JSON array) of: Text (UTF-8)
alarm_mail_amTimestamp (ISO 8601 with UTC offset)
alarm_versucheInteger
alarm_versucht_anList (JSON array) of: Text (UTF-8)
zurueck_amTimestamp (ISO 8601 with UTC offset)
entwarnung_mail_amTimestamp (ISO 8601 with UTC offset)
entwarnung_versucheInteger
beansprucht_amTimestamp (ISO 8601 with UTC offset)
geschlossen_amTimestamp (ISO 8601 with UTC offset)

Device log

Messages from the devices.

JSON: daten/screens/geraeteprotokoll.json · CSV: daten/screens/geraeteprotokoll.csv

FieldFormatValues
idInteger
system_idIdentifier (UUID, text)
screen_idIdentifier (UUID, text)
zeitTimestamp (ISO 8601 with UTC offset)
empfangen_amTimestamp (ISO 8601 with UTC offset)
stufeText (UTF-8)
textText (UTF-8)

Activities

Changes to screens and playlists.

JSON: daten/screens/aktivitaeten.json · CSV: daten/screens/aktivitaeten.csv

FieldFormatValues
idInteger
system_idIdentifier (UUID, text)
screen_idIdentifier (UUID, text)
objektText (UTF-8)
objekt_idIdentifier (UUID, text)
nameText (UTF-8)
aktionText (UTF-8)
detailsJSON (object or list; JSON text in CSV)
person_idIdentifier (UUID, text)
erstellt_amTimestamp (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

FieldFormatValues
idIdentifier (UUID, text)
system_idIdentifier (UUID, text)
bucketText (UTF-8)
pathText (UTF-8)
mimeText (UTF-8)
bytesInteger
kindText (UTF-8)
titelText (UTF-8)
altText (UTF-8)
widthInteger
heightInteger
duration_secondsInteger
uploaded_byIdentifier (UUID, text)
created_atTimestamp (ISO 8601 with UTC offset)
video_codecText (UTF-8)
ordner_idIdentifier (UUID, text)
loeschung_freigegeben_amTimestamp (ISO 8601 with UTC offset)

Media folders

Folders of the media library.

JSON: daten/screens/medien_ordner.json · CSV: daten/screens/medien_ordner.csv

FieldFormatValues
idIdentifier (UUID, text)
system_idIdentifier (UUID, text)
parent_idIdentifier (UUID, text)
nameText (UTF-8)
erstellt_vonIdentifier (UUID, text)
created_atTimestamp (ISO 8601 with UTC offset)

Media usage

Where each medium is used.

JSON: daten/screens/medien_verwendung.json · CSV: daten/screens/medien_verwendung.csv

FieldFormatValues
quelleText (UTF-8)
quelle_idIdentifier (UUID, text)
system_idIdentifier (UUID, text)
bucketText (UTF-8)
pathText (UTF-8)

Playlist approvals

Approval requests and decisions.

JSON: daten/screens/playlist_freigaben.json · CSV: daten/screens/playlist_freigaben.csv

FieldFormatValues
idIdentifier (UUID, text)
system_idIdentifier (UUID, text)
playlist_idIdentifier (UUID, text)
standTimestamp (ISO 8601 with UTC offset)
statusText (UTF-8)
eingereicht_vonIdentifier (UUID, text)
eingereicht_amTimestamp (ISO 8601 with UTC offset)
notizText (UTF-8)
entschieden_vonIdentifier (UUID, text)
entschieden_amTimestamp (ISO 8601 with UTC offset)
kommentarText (UTF-8)

Approval rules

When playlists need approval.

JSON: daten/screens/screen_freigabe_regeln.json · CSV: daten/screens/screen_freigabe_regeln.csv

FieldFormatValues
system_idIdentifier (UUID, text)
aktivBoolean (true/false)
geaendert_vonIdentifier (UUID, text)
geaendert_amTimestamp (ISO 8601 with UTC offset)

Approvers

Who may approve playlists.

JSON: daten/screens/screen_freigeber.json · CSV: daten/screens/screen_freigeber.csv

FieldFormatValues
system_idIdentifier (UUID, text)
user_idIdentifier (UUID, text)
erstellt_amTimestamp (ISO 8601 with UTC offset)
idIdentifier (UUID, text)

Menu products

Product catalogue of the menu boards.

JSON: daten/screens/menue_produkte.json · CSV: daten/screens/menue_produkte.csv

FieldFormatValues
idIdentifier (UUID, text)
system_idIdentifier (UUID, text)
kategorieText (UTF-8)
nameText (UTF-8)
beschreibungText (UTF-8)
hinweisText (UTF-8)
artikelnummerText (UTF-8)
bild_idIdentifier (UUID, text)
reihenfolgeInteger
aktivBoolean (true/false)
erstellt_amTimestamp (ISO 8601 with UTC offset)
geaendert_amTimestamp (ISO 8601 with UTC offset)
bild_zoomInteger
bild_xInteger
bild_yInteger

Menu categories

Categories of the menu boards.

JSON: daten/screens/menue_kategorien.json · CSV: daten/screens/menue_kategorien.csv

FieldFormatValues
idIdentifier (UUID, text)
system_idIdentifier (UUID, text)
schluesselText (UTF-8)
titelText (UTF-8)
reihenfolgeInteger
erstellt_amTimestamp (ISO 8601 with UTC offset)

Menu prices

Prices per location with history.

JSON: daten/screens/menue_preise.json · CSV: daten/screens/menue_preise.csv

FieldFormatValues
idIdentifier (UUID, text)
system_idIdentifier (UUID, text)
produkt_idIdentifier (UUID, text)
location_idIdentifier (UUID, text)
preisDecimal number (dot as decimal separator)
gueltig_abTimestamp (ISO 8601 with UTC offset)
quelleText (UTF-8)
erstellt_vonIdentifier (UUID, text)
erstellt_amTimestamp (ISO 8601 with UTC offset)
folgt_ebeneBoolean (true/false)

Menu designs

Designs of the menu boards.

JSON: daten/screens/menue_designs.json · CSV: daten/screens/menue_designs.csv

FieldFormatValues
idIdentifier (UUID, text)
system_idIdentifier (UUID, text)
nameText (UTF-8)
entwurfJSON (object or list; JSON text in CSV)
aktivJSON (object or list; JSON text in CSV)
fassungInteger
veroeffentlicht_amTimestamp (ISO 8601 with UTC offset)
erstellt_amTimestamp (ISO 8601 with UTC offset)
geaendert_amTimestamp (ISO 8601 with UTC offset)
ist_vorlageBoolean (true/false)

Design versions

Earlier versions of the designs.

JSON: daten/screens/menue_design_fassungen.json · CSV: daten/screens/menue_design_fassungen.csv

FieldFormatValues
design_idIdentifier (UUID, text)
fassungInteger
system_idIdentifier (UUID, text)
inhaltJSON (object or list; JSON text in CSV)
veroeffentlicht_amTimestamp (ISO 8601 with UTC offset)
veroeffentlicht_vonIdentifier (UUID, text)

Menu fonts

Uploaded fonts.

JSON: daten/screens/menue_schriften.json · CSV: daten/screens/menue_schriften.csv

FieldFormatValues
idIdentifier (UUID, text)
system_idIdentifier (UUID, text)
nameText (UTF-8)
pathText (UTF-8)
bytesInteger
erstellt_amTimestamp (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

FieldFormatValues
location_idIdentifier (UUID, text)
system_idIdentifier (UUID, text)
vorlageText (UTF-8)
waehrungText (UTF-8)
screen_idsList (JSON array) of: Identifier (UUID, text)
playlist_idsList (JSON array) of: Identifier (UUID, text)
fassungInteger
freigegeben_amTimestamp (ISO 8601 with UTC offset)
freigegeben_vonIdentifier (UUID, text)
erstellt_amTimestamp (ISO 8601 with UTC offset)
design_idIdentifier (UUID, text)
anzahlInteger

Price levels

Price levels of the menu boards.

JSON: daten/screens/menue_preisebenen.json · CSV: daten/screens/menue_preisebenen.csv

FieldFormatValues
idIdentifier (UUID, text)
system_idIdentifier (UUID, text)
nameText (UTF-8)
reihenfolgeInteger
erstellt_amTimestamp (ISO 8601 with UTC offset)
basis_idIdentifier (UUID, text)
aufschlag_centInteger
aufschlag_prozentDecimal number (dot as decimal separator)
rundungText (UTF-8)
geaendert_amTimestamp (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

FieldFormatValues
idIdentifier (UUID, text)
system_idIdentifier (UUID, text)
ebene_idIdentifier (UUID, text)
produkt_idIdentifier (UUID, text)
preisDecimal number (dot as decimal separator)
gueltig_abTimestamp (ISO 8601 with UTC offset)
quelleText (UTF-8)
erstellt_vonIdentifier (UUID, text)
erstellt_amTimestamp (ISO 8601 with UTC offset)
folgt_regelBoolean (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

FieldFormatValues
idIdentifier (UUID, text)
system_idIdentifier (UUID, text)
location_idIdentifier (UUID, text)
ebene_idIdentifier (UUID, text)
geaendert_amTimestamp (ISO 8601 with UTC offset)
geaendert_vonIdentifier (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

FieldFormatValues
idInteger
system_idIdentifier (UUID, text)
user_idIdentifier (UUID, text)
actionText (UTF-8)
entityText (UTF-8)
entity_idIdentifier (UUID, text)
created_atTimestamp (ISO 8601 with UTC offset)
felderList (JSON array) of: Text (UTF-8)
akteur_rolleText (UTF-8)
person_idIdentifier (UUID, text)
location_idIdentifier (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

FieldFormatValues
idInteger
zeitpunktTimestamp (ISO 8601 with UTC offset)
bereichText (UTF-8)
aktionText (UTF-8)
felderList (JSON array) of: Text (UTF-8)
person_idIdentifier (UUID, text)
person_nameText (UTF-8)
location_idIdentifier (UUID, text)
standortText (UTF-8)
akteur_nameText (UTF-8)
akteur_rolleText (UTF-8)
system_nameText (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

FieldFormatValues
idIdentifier (UUID, text)
nameText (UTF-8)
artText (UTF-8)
codeText (UTF-8)
aktivBoolean (true/false)
vertretung_aktivBoolean (true/false)
rolleText (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

FieldFormatValues
idIdentifier (UUID, text)
aktenzeichenText (UTF-8)
meldestelle_idIdentifier (UUID, text)
meldestelleText (UTF-8)
kategorieText (UTF-8)
beschreibungText (UTF-8)
im_auftragBoolean (true/false)
bearbeitende_stelleText (UTF-8)
anonymBoolean (true/false)
kontakt_nameText (UTF-8)
kontaktText (UTF-8)
beziehungText (UTF-8)
spracheText (UTF-8)
statusText (UTF-8)
eingegangen_amTimestamp (ISO 8601 with UTC offset)
bestaetigt_amTimestamp (ISO 8601 with UTC offset)
rueckmeldung_amTimestamp (ISO 8601 with UTC offset)
abgeschlossen_amTimestamp (ISO 8601 with UTC offset)
ergebnisText (UTF-8)
aufbewahren_bisDate (ISO 8601, YYYY-MM-DD)
frist_bestaetigungDate (ISO 8601, YYYY-MM-DD)
frist_rueckmeldungDate (ISO 8601, YYYY-MM-DD)
loeschung_abDate (ISO 8601, YYYY-MM-DD)
nachrichtenJSON (object or list; JSON text in CSV)
verlaufJSON (object or list; JSON text in CSV)
anhaengeJSON (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.