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.
Purpose
Section titled “Purpose”Equipment is the second plannable resource (master data). It is assigned to tasks, booked, can be unavailable and carries a calculatory hourly rate.
Where in the app
Section titled “Where in the app”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.
Fields
Section titled “Fields”| 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).
Equipment group (osp_equipment_unit)
Section titled “Equipment group (osp_equipment_unit)”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.
Relations
Section titled “Relations”| 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.
Rules & automation
Section titled “Rules & automation”- 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.
See also
Section titled “See also”Equipment usage · Equipment booking · Unavailability · Guides › Unavailabilities