Training Assignment Schema

UUID of the employee profile

UUID of the user assigned to this training (for scope-based access)

UUID of the academy course (null for external trainings)

Whether this is an external (non-Academy) training

Name of external training/certification (e.g. Microsoft AZ-900)

External training provider (e.g. Microsoft, Cisco)

Linked skill definition UUID (auto-upgrade on completion)

Assignment type

Deadline for completing the training

Recurrence interval in months (e.g. 12 for annual)

UUID of uploaded completion certificate

Certification expiry date

Course/registration fee in cents (WP-E). Sensitive — gated by training_cost_view.

Labor cost (paid working time) in cents (WP-E).

Subsidy / funding received in cents, reduces net cost (WP-E).

ISO 4217 currency for the cost fields (default EUR, WP-E).

Free-text note on the training cost / funding (WP-E).

Fleet driver ID if this assignment was created by the UVV training workflow

Links this assignment to a training_session (Schulungsgruppe). The session is a scheduling wrapper; its participants ARE these assignments (consolidation, supersedes training_session_participant).

Session registration state (only for session-linked assignments; capacity → WAITLISTED).

Attendance confirmation for a session-linked assignment (Teilnahmebestätigung). ATTENDED additionally sets status=COMPLETED.

User who confirmed attendance.

Which recurrence cycle this assignment represents (1, 2, 3...)

Link to previous cycle training_assignment for audit trail

User who self-submitted this external training

Admin/HR user who approved or rejected the submission

When the submission was reviewed

Reason for rejection (if status is REJECTED)

Number of times this assignment submission has been rejected