Reference & Data Model
Department (osp_employment_unit)
A department is a node in the organization tree that groups employees and sub-departments and can have a head.
Purpose
Section titled “Purpose”Departments map the organizational structure (master data). They structure the employee list, give issues a responsible unit and serve as orientation. No permissions or planning logic depend on them.
Where in the app
Section titled “Where in the app”Stammdaten › Mitarbeiter & Abteilungen (Master data › Employees & departments): tree on the left, dialogs „Neue Abteilung“ (New department) and „Updaten“ (Update). The department view shows „Unterabteilungen“ (sub-departments) and „Mitarbeiter“ (employees) with the „Abteilungsleiter“ (department head). See Guides › Employees & departments.
Fields
Section titled “Fields”| Field | Technical | Type | Required | Meaning | Notes |
|---|---|---|---|---|---|
| Title | name |
Text | yes | Name of the department | |
| Head | assignee_id |
Reference | no | Department head (employee) | descriptive; only in the update dialog |
| Color | color |
Selection | yes | Identifying color in the tree | |
| Description | description |
Text | no | Free text | |
| Parent department | parent_id |
Reference | no | Parent node | prefilled from the tree selection on create |
Displayed system values: number of „Unterabteilungen“ and „Mitarbeiter“.
Relations
Section titled “Relations”| Related to | Kind | Required | On archive | On delete |
|---|---|---|---|---|
Parent department (osp_employment_unit) |
belongs to | no | – | reference cleared |
Head (employee) |
belongs to | no | – | reference cleared |
Employee (employee) |
has many | – | – | reference cleared (employees remain without a department) |
| Sub-departments | has many | – | – | reference cleared (they become root nodes) |
Issue (issue.osp_employee_unit_id) |
has many | – | – | reference cleared |
Rules & automation
Section titled “Rules & automation”- The context menu entry „Löschen“ (Delete) appears only for departments that have a parent department; root departments cannot be deleted in the tree.
- Deleting a department deletes neither employees nor sub-departments; they only lose the reference. Since projects do not reference departments, the change has no effect on project data apart from the department assignment on issues.
- No derivations, no KPIs.