Skip to content

Reference & Data Model

Equipment (equipment)

Equipment is a machine, vehicle or tool with an hourly rate and an active period that is scheduled on tasks like a person.

Equipment is the second plannable resource (master data). It is assigned to tasks, booked, can be unavailable and carries a calculatory hourly rate.

Stammdaten › Equipment-Katalog (Master data › Equipment catalog): tree of „Equipment-Gruppierung“ (equipment groups) and devices; dialogs „Neue Equipment-Gruppierung“ (New equipment group), „Neues Equipment“ (New equipment) and „Updaten“ (Update). The detail view shows „Verfügbarkeit“ (availability), „Auslastung 30 Tage“ (utilization 30 days), „Stundensatz“ (hourly rate), „Einsatzplan“ (deployment plan), „Geplante Einsätze“ (planned usages) and „Wartung & Ausfälle“ (maintenance & unavailabilities). See Guides › Equipment catalog.

Field Technical Type Required Meaning Notes
Title title Text yes Designation
Key user_key Text yes (DB) Your own key dialog does not enforce input
Serial number serial_number Text yes (DB) Manufacturer number dialog does not enforce input
Image image_id Text no Image update dialog
Status active Selection yes „Aktiv“/„Inaktiv“ (Active/Inactive) inactive devices are locked in selection lists
Active since / Active until active_since / active_until Date yes / no Period of use capacity window
Hourly rate hourly_rate Amount no Calculatory rate per booked hour
Currency currency Selection no Currency of the rate
Unit quantity amount Number no Base quantity
Unit base_unit Text no Unit of measure
Description description Text no Free text
Equipment group osp_equipment_unit_id Reference yes Group in the tree from the tree
Responsible assignee_id Reference no Responsible employee only displayed, cannot be set in any dialog
Tags tags Text – only shown in „Info“ not editable

System: „Verfügbarkeit“ = „Frei“ (free) or „Gebucht“ (booked) (only a currently running booking counts), „Auslastung 30 Tage“, deployment plan with „Gebucht“ (booked), „Wartung“ (maintenance), „Defekt“ (defective), „Reserviert“ (reserved), „Frei“ (free).

Tree node with Title (name, required), Color (color), Description (description) and parent group (parent_id). A head (assignee_id) exists in the schema but is neither displayed nor settable anywhere.

Related to Kind Required On archive On delete
Equipment group (osp_equipment_unit) belongs to yes – blocked (a group with devices cannot be deleted)
Responsible (employee) belongs to no – reference cleared
Equipment usage (equipment_usage) has many – – deleted along
Equipment booking (equipment_booking) has many – – deleted along
Unavailability (equipment_unavailability) has many – – deleted along

Equipment cannot be archived.

  • Capacity: Available hours follow the fixed working time default (5 days × 8 hours, Saturday and Sunday off) within the window „Aktiv seit“ to „Aktiv bis“, minus unavailability times. Equipment has no capacity fields of its own.
  • Hourly rate → Optimizer: The rate enters the optimization as cost per hour; 0 or empty means free of charge. There is no cost rule that books equipment usages as planned or actual costs.
  • Conflicts: Double bookings and „Gebucht & Ausfall“ (booked & unavailable) are reported in the resource workload (KPIs › Resources).
  • Master data character: Status changes, the active period and the hourly rate take effect immediately in all tasks, bookings and optimization runs of all projects. Deleting removes all usages, bookings and unavailabilities of the device.

Equipment utilization % and conflicts. See ch. 13 › Resources.

Equipment usage · Equipment booking · Unavailability · Guides › Unavailabilities