Skip to content

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.

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.

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.

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“.

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
  • 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.

Employee · Issue