Reference & Data Model
Time log (time_log)
A time log is the header of the time a person logged on one day for a project and optionally a task; it carries status, billability and description.
Purpose
Section titled “Purpose”The time log bundles all time spans of a person for one day-project-task combination and goes through approval. Approved time logs are locked and are posted once as personnel costs. (Transactional data)
Where in the app
Section titled “Where in the app”Workmanagement › Zeiterfassung (Guides › Time tracking):
- „Erfassungsansicht“ (Tracking view,
/time-tracking): your own time logs per day or week; „Neue Zeiterfassung“ (New time log); clicking opens the dialog „Zeiterfassung“. - „Detailansicht“ (Detail view,
/detail-time-view): all time logs of a period, grouped by day, week, month, project, task, employee, billing or status; filters by status, date, description, billable, „Genehmigt am“, „Abgelehnt am“, employee, project, task; status editable directly in the row; creating for other people. - „Freigabeansicht“ (Approval view,
/time-approval): totals per employee and „Genehmigen“ (Approve) / „Ablehnen“ (Reject); single view with „Auf Genehmigt wechseln“ / „Auf Abgelehnt wechseln“ (Guides › Approve your team’s time).
Fields
Section titled “Fields”| Field | Technical | Type | Required | Meaning | Notes |
|---|---|---|---|---|---|
| Employee | employee_id |
Reference | no | Whose time | Tracking view: your own employee; detail view: freely selectable |
| Project | project_id |
Reference | yes | Related project | |
| Task | task_id |
Reference | no | Task of the project | Without task: „Projektzeiterfassungen ohne Aufgabenbezug“ (project time logs without task reference) |
| Date | date |
Date | yes | Day of the work | Browse with „Vorheriger Tag“ / „Nächster Tag“ |
| Status | state |
Selection | yes | „Ausstehend“ (Pending), „Genehmigt“ (Approved), „Abgelehnt“ (Rejected) | Default „Ausstehend“; locked after approval |
| Billable | billable |
Yes/No | yes | Feeds into „Abrechenbare Stunden (%)“ | Default Yes |
| Description | description |
Text | no | Free text | |
| Approved on | approved_at |
Date | no | Time of approval | Shown in the dialog; currently not set by any action and therefore stays empty |
| Rejected on | rejected_at |
Date | no | Time of rejection | as above |
| Logged working time | Sum of time entries | Duration | — | Shown, not stored |
Relations
Section titled “Relations”| Related to | Kind | Required | On archive | On delete |
|---|---|---|---|---|
| Employee | belongs to | no | — | kept |
| Project | belongs to | yes | kept | deleted along – blocked while approved |
| Task | belongs to | no | kept | deleted along – blocked while approved |
| Time entry | has many | — | kept | deleted along |
States
Section titled “States”| Value | Label | Meaning | Set by |
|---|---|---|---|
pending |
Ausstehend (in totals „Offen (h)“) | Logged, not yet decided | Creation; withdrawal of a decision |
approved |
Genehmigt | Approved, content locked, costs posted | „Genehmigen“, status selection |
rejected |
Abgelehnt | Rejected, still editable | „Ablehnen“, status selection |
„Genehmigen“ / Status → Genehmigt Ausstehend ─────────────────────────────────► Genehmigt (locked) ▲ │ │ ▲ │ │ „Ablehnen“ │ │ „Auf Genehmigt wechseln“ │ ▼ │ │ │ Abgelehnt ◄────„Auf Abgelehnt wechseln“───┘ │ │ └────────────────────────────────────────┘ └── Status back to „Ausstehend“ (detail view / dialog)All transitions are free via the status selection field; anyone whose [grant](/en/referenz/01-organisation-zugriff/b1-permissions/) at the project allows it may perform them.Rules & automation
Section titled “Rules & automation”- Uniqueness: Per employee, date, project and task there is at most one non-approved time log. The dialog „Neue Zeiterfassung“ reuses the existing one („Für diesen Mitarbeiter, dieses Datum, Projekt und Aufgabe existiert bereits ein Zeiteintrag“). If the existing one is approved, creation is blocked („… bereits freigegeben. Freigabe zurücknehmen …“). A record that nonetheless arrives as a duplicate is merged on the server.
- Lock after approval: date, description, billable, employee, project, task and all time entries are immutable; deletion is rejected („approved time log cannot be deleted — un-approve it first“). Only the status remains editable. See Locks.
- Personnel costs: the first approval posts once „Personalkosten aus Zeiterfassung“ = sum of time entries × hourly rate (project hourly rate of the project member, otherwise the employee’s hourly cost), date = day of the time log. Withdrawal, change and re-approval do not post again. See Actual personnel costs.
- Delete protection: a task cannot be deleted while approved time logs are attached to it. A project with time logs cannot be deleted at all; it is ended with „Als fehlgeschlagen abschließen & archivieren“ (close as failed & archive) instead (Project).
- Closed projects: for a succeeded or failed project the interface creates no new time logs („Projekt abgeschlossen – keine neuen Einträge möglich.“).
- The bulk action of the approval view sets all time logs of the selected employees in the period, including already rejected ones.
„Ziel-Arbeitsstunden“ (target working hours: weekly hours ÷ 5 × workdays), „Gesamte Arbeitsstunden“ (total working hours), „Gesamt / Ziel (%)“, „Abrechenbare Stunden (%)“ (billable hours), „Offen (h)“ (open), „Genehmigt (h)“ (approved), „Abgelehnt (h)“ (rejected); overview: hours this week, tracking rate, open approvals – see Work and Counts.
See also
Section titled “See also”Time entry · Employee usage · Guides › Log time → approve → project costs