Task Schema

Task title

Task description

Task status. PENDING_REVIEW is the intermediate state between IN_PROGRESS and DONE when reviewMode = hard.

Task priority

Project UUID (legacy, use referenceId/referenceSchema)

Optional task-list bucket (Todoist-style, ADR 0132). Independent of projectId/referenceId — a task can belong to a project AND a personal list at the same time.

Parent task UUID for subtasks

Sort order within parent/project

Assigned user UUID. Deprecated: mirror of assigneeIds[0] for backward compatibility. Write via assigneeIds.

Assigned user UUIDs (multi-assignee). Canonical assignee field.

ADR 0224: set when a template-materialized task should be auto-assigned by the dispatch pipeline (assignmentRule.strategy = ai_dispatch | ai_suggest). The worker event-router enqueues a dispatch job and clears this flag.

ADR 0224: id of the dispatch_decision that assigned this task (ai_* strategy).

Team / organizational unit UUID

ADR 0421: when true, every member of `orgUnitId` may fully edit and delete this task, not just work it off. Opt-in per task — the ADR-0192 default keeps manage rights with the creator / project manager / admin. No effect when `orgUnitId` is null. Only an owner (creator / project manager / campaign owner / admin) may flip this flag.

Reporter user UUID

Optional reviewer user UUID. When set together with reviewMode=hard, only this user (or a user with task_review/admin_bypass) may transition the task from PENDING_REVIEW to DONE.

Review enforcement: 'hard' inserts a PENDING_REVIEW gate before DONE and restricts the final transition to the reviewer; 'soft' only notifies the reviewer when the task is completed. Null/absent = no review.

Sprint UUID

Kanban board column ID

Project phase UUID for Gantt

Story points estimate

Estimated effort in minutes

Hard cap on logged minutes for this task (applied when limitMode=minutes). Used by project limit checks; values are not auto-enforced unless project.limits.hardBlockOnExceed is true.

Linked sales_order UUID (the order this task originated from)

ID of the orderItem inside the linked sales_order (matches salesOrder.orderItems[].id)

Origin of the linked sales-order item — internal or weclapp

ADR 0310: optional project_position this task hangs under. null = free task (no position). The position aggregates this task’s effort (loggedMinutes/consumedAmount) and carries the billing model (flat_rate vs. time_and_material).

Limit mode: minutes (cap on logged time via maxMinutes), amount (cap on consumed EUR via maxAmount), or none.

Hard cap on consumed billable amount in EUR (decimal string)

ISO 4217 currency for maxAmount (default EUR when null)

Sum of time_record.consumedAmount for this task (cached, auto-computed by time-record service)

Project-less fallback for the budget hard-block. When the task has no project, this opts the task into hard-blocking time bookings past maxMinutes/maxAmount (mirrors project.limits.hardBlockOnExceed). Ignored when the task belongs to a project — the project setting wins.

Pre-selected service_type UUID for time bookings on this task. Not enforced — users may pick a different type.

Set when maxMinutes was manually overridden (via task_override_budget). Reconcile from sales-order skips this field while set.

Set when maxAmount was manually overridden (via task_override_budget). Reconcile from sales-order skips this field while set.

Last reason for a budget override (audit trail; full history lives in history collection).

Linked weclapp task ID (target for time-record write-through)

Sync state of this task against weclapp

Last successful weclapp sync timestamp

Last weclapp sync error message

ID of the mirrored task in Microsoft To Do (per connected user mailbox)

ID of the Microsoft To Do list this task is mirrored into

Last seen Microsoft Graph @odata.etag of the mirrored task — used for echo-suppression on inbound delta sync

Last successful Microsoft To Do sync timestamp for this task

Which side last wrote the synced state (conflict-resolution hint)

Task start date (YYYY-MM-DD)

Task due date (YYYY-MM-DD)

Task completion timestamp

User UUID of the person who marked the task as DONE (cleared on re-open)

Optional scheduled start date-time for calendar display

Optional scheduled end date-time for calendar display

Task type

Task labels (like Jira labels)

Linked ticket UUID

Linked asset UUIDs

ADR 0218: predecessor task UUIDs that must reach a terminal status (DONE/CANCELLED) before this task may start. Single source of truth for task dependencies; validated server-side (existence, same-project, no cycles).

ADR 0218: DERIVED downstream dependents (tasks whose blockedByIds reference this task). Computed on read via reverse lookup — read-only / protected, never written directly.

Logged time in minutes (auto-computed)

Task tags

Linked entity UUID

Schema type of the linked entity

Additional free-form cross-entity links (Mehrfachverknüpfung, 04.08.2026). UNLIKE phone_call (ADR 0386) this does NOT supersede the single reference: referenceId/referenceSchema stays the PRIMARY link (predecessor-sibling logic, partyScope/projectId query expansion, kanbans all key on it) — linkedEntities carries the secondary links, e.g. an opportunity-task also linked to the customer and a contact person. Same item shape as phone_call.linkedEntities.

Set when the task was spawned from a performance_review agreement. Used to mirror task.status ↔ agreement.status. Legacy — superseded by linkedGoalId / linkedBenefitId.

Set when the task was spawned from a performance_review_goal. Used to mirror task.status ↔ goal.status.

Set when the task was spawned from a performance_review_benefit. Used to mirror task.status ↔ benefit.status.

Backlink to the campaign that produced this task (CREATE_TASK action).

Optional link to the contract this task belongs to. Drives contract-aware lifecycle: recurrence.endDate is auto-capped to contract.endDate on creation, and worker handlers cap/cancel tasks when contract.endDate moves or contract.status transitions to SUSPENDED/CANCELLED/EXPIRED.

UUID of the recurring master task this exception belongs to. Mutually exclusive with `recurrence` — a series-master child cannot itself start a series. Set only by the materialization endpoint.

YYYY-MM-DD of the specific occurrence this exception represents. Required when seriesMasterId is set; together they form the idempotency key.

How this occurrence diverges from the master. exception = materialized instance with its own status; cancellation = skipped occurrence (hidden from the calendar but kept for audit).

IANA TZ used when interpreting seriesOccurrenceDate. Defaults to the tenant TZ when null. Mirrors the calendar-event recurrence model.

Recurrence configuration for recurring tasks

Compliance rule that auto-generated this task (e.g. HU, AU, MAINTENANCE)

The compliance deadline date this task tracks (YYYY-MM-DD)

Task visibility. PRIVATE tasks are only visible to their creator and assignee.

Task difficulty (0–100). Feeds the XP award formula when the task transitions to DONE. Defaults to 50 at award time if null.

Structured skill requirements for this task. Drives XP awards to the task assignee on completion.

Set once when XP was awarded for this task completion. Prevents duplicate XP grants on DONE→other→DONE transitions.

Whether this task is visible on the project customer portal (requires project.customerAccess feature viewAssignedTasks).

Customer party (contact or organization) this task is assigned to (public portal). Used alongside assigneeId.

True if the task was created by a customer via the public portal.

task_template._id this task was instantiated from.

Pinned template version at instantiation time (semver).

ID of the subTemplates[] link this task came from. Null on root tasks.

Denormalized "/slug-a/slug-b" path for fast roll-up analytics.

True for the root task of a template execution.

Denormalized: every task in a template execution carries the root task id.

Snapshot of template input values (key → value) at instantiation time.

Reason for CANCELLED status. e.g. "template-instantiation-optional-skipped" when an optional sub-step was de-selected.

True if the task is parked for on-site field service ("Wartestellung"). Orthogonal to status — a parked task keeps its normal workflow status.

Anchor customer party for the on-site work. Prefilled from referenceId when referenceSchema = party. Used as the proximity origin.

parties.addresses[]._id of the concrete on-site address (geocoding source for proximity). Falls back to the MAIN address when null.

Timestamp when the task was parked (cleared when un-parked).

User UUID who parked the task (cleared when un-parked).

Primary calendar_event this task was scheduled into. Many parked tasks may point to one appointment. Set by the schedule-into-event endpoint. For split tasks (ADR 0219) this is the FIRST part-event; the full set lives in calendarEventIds.

All calendar_events this task was planned into (ADR 0219). For a split task the planner writes one event per part; linkedCalendarEventId mirrors [0] for backward compatibility. Readers that need every appointment should prefer this and fall back to [linkedCalendarEventId] when absent (older data). Set server-side (plan/commit + schedule-into-event); protected against direct PATCH.