Training Report (Ausbildungsnachweis) Schema

IHK "Ausbildungsnachweis Nr." — per-apprentice running number (1, 2, 3 …). Set at creation = count of the apprentice's existing reports + 1.

User UUID of the apprentice (Azubi) this report belongs to.

employee_profile UUID of the apprentice (denormalized for lookup).

Vor- und Zuname — snapshot of the apprentice name at creation (auto-filled).

Ausbildungsberuf, Fachrichtung (e.g. "Fachinformatiker für Anwendungsentwicklung"). Auto-filled from the profile qualification, apprentice-editable.

Ausbildungsjahr as printed on the IHK form (e.g. "2025" — the year the training started). Free string, auto-filled from the hire year.

Ausbildungsabteilung/-bereich during the reporting period (e.g. "Entwicklung").

Ausbildungs-Standort/Arbeitsort as a denormalized snapshot label (e.g. "Trier · 54290 Trier"), resolved from the apprentice profile workLocationId → legal-entity address at creation. Powers the reviewer "Standort" filter. Optional → null on reports created before this field existed (no backfill; the filter simply does not match those old drafts).

Reporting period — monthly. Drives the unique-per-month constraint.

Human-readable period label (e.g. "Mai 2026"). Auto-filled.

First day of the reporting period (ISO date). Auto-filled.

Last day of the reporting period (ISO date). Auto-filled.

User UUID of the reviewing team lead / Ausbilder. Resolved from the apprentice profile (ausbilderEmployeeId → userId, managerId fallback) at creation.

Snapshot of the assigned Ausbilder name (shown to the apprentice in their list). Auto-filled at creation.

Workflow status. Transitions enforced by training-report.service.

"Tätigkeiten diesen Monat" — one entry per bullet point (PLAIN; derived from activitiesHtml when the rich editor is used; authoritative for PDF/AI/reviewer offset-annotations).

Rich-text HTML body for the monthly activities list (sanitised).

Rich-text HTML for the vocational-school subjects list (sanitised).

Rich-text HTML for the vocational-school topics list (sanitised).

Berufsschule → Unterrichtsfächer (e.g. "FAE_L01", "Sport").

Berufsschule → Unterrichtsthemen (one entry per topic line).

Ausführliche Beschreibung einer Arbeitsaufgabe für diesen Monat.

Externally uploaded report files (e.g. signed PDF, scanned sheet) via the file/DMS service.

How the report is authored: "form" (default) = the structured IHK form, the SSoT for inline annotations / AI pre-check / search; "upload" = the apprentice uploaded a finished document (uploadedPdfFileId — PDF or Word) which IS the report document instead of the rendered form.

When source="upload": file id (collection `files`, entityType `training_reports`) of the apprentice-uploaded source document served as the report document (download/preview) in place of the form render. Legacy name — the file may be a PDF or a Word document (see uploadedDocumentVersions[].mimeType). Kept as the downloadable original after a PDF→form extraction.

Chronological stack of every uploaded report document (source="upload"). Each successful set-pdf upload appends an entry; the last entry is the active document (uploadedPdfFileId). Lets the apprentice and reviewer see and download previous versions after a re-upload. Optional → absent/empty on reports whose single upload predates this field (fall back to uploadedPdfFileId, assumed PDF).

State of the manual "Felder aus PDF erkennen" job (OCR + LLM that parses the uploaded PDF into the form fields, then flips source=upload → form). Null = never run.

Error / completion message from the PDF field-extraction job.

When the apprentice submitted the report.

When the team lead approved or sent back the report.

User UUID of the reviewer who took the last review action.

How often the report has been sent back for revision.

Overall feedback text from the team lead (shown to the apprentice).

Inline text-passage markups by the reviewer: the apprentice sees these anchored comments on return.

Digital signature captured when the apprentice submits ("für die Richtigkeit" — IHK "Unterschrift des Auszubildenden"). Drawn online, uploaded as an image, or typed.

Digital signature captured when the reviewer approves the report (IHK "Unterschrift des Ausbildenden").

When the reviewer last sent the apprentice a reminder for this report.

How many reminders the reviewer has sent for this report.

State of the manual AI pre-check. Null = never run.

AI summary of the report quality.

What the apprentice did well (AI).

Problems / gaps the AI found.

Actionable improvement suggestions (AI).

Per-criterion verdict of the AI pre-check (spelling, accuracy, completeness, clarity) — drives the "Geprüft wird" result list in the reviewer UI.

Suggested quality score 0–100 (AI). Advisory only — no grading.

AI confidence 0.0–1.0.

When the AI pre-check completed.

File id of the generated, signed IHK PDF (collection `files`, entityType `training_report`). Created on approval; the apprentice can download it afterwards via GET /training-reports/:id/download.