Skip to content

Reference & Data Model

Risk (risk)

A risk is a possible loss event of a project, assessed with amount, probability and rating.

A risk makes an uncertainty visible and values it in money. The possible loss and the probability of occurrence give the expected value; measures lower the probability. If the risk occurs, you record the actual loss. (Data type: project world, transactional data)

Projekt › Risiken/Chancen › Risiken (Project › Risks/Opportunities › Risks). Double-click or „Details“ opens the risk sheet with the sections „Info“, „Präventive Maßnahmen“ (Preventive measures) and „Reaktive Maßnahmen“ (Reactive measures). Edit via the menu „Risiko-Optionen“ › „Aktualisieren“. Create via „Neues Risiko hinzufügen“. Program › „Risiken/Chancen“ shows the same rows for all projects of the program. See Guides › Risks/Opportunities and Guides › Risk → Measure.

Field Technical Type Required Meaning Notes
Name (table: „Titel“) name Text yes Unique name of the risk Search field
Type type Text yes Free kind or category no catalog
Risk administrator owner_id Reference (employee) no Responsible person only in the „Neues Risiko“ dialog and as a filter; descriptive, no permissions
Priority priority Number no Manual ordering Default 1
Possible loss possible_risk_value Amount yes Maximum loss on occurrence Default 0
Currency currency Selection yes Currency of the amounts Default EUR
Occurrence (%) (sheet: „Geschätzte Eintrittswahrscheinlichkeit“) likelihood_in_pct Number yes Probability of occurrence without measures Tooltip shows the effective probability after mitigation
Loss magnitude degree_of_risk Selection yes Manual rating „Hoch“, „Mittel“, „Niedrig“ (high, medium, low) not calculated from amount × probability; axis of the heat map
Probability rating degree_of_likelihood Selection yes Manual rating „Hoch“, „Mittel“, „Niedrig“ axis of the heat map
Active / inactive active Yes/No yes Whether the risk counts in cards, matrix and costs Toggle in the update dialog; inactive rows greyed out
Description description Text yes Detailed description multi-line
Consequences if the risk occurs consequences_of_risk_occurrence Text yes Impact on occurrence multi-line
Actual loss occurred_risk_value Amount no Loss that occurred only after „Risiko ist eingetreten“
Occurred on occurred_at Date no Date of occurrence Checkbox „Risiko ist eingetreten“ sets both fields; unchecking clears them
Completed on completed_at Date no Completion of handling only after occurrence

“Required” = technically required (notNull); the dialog only demands the name and fills the rest with defaults.

Related to Kind Required On archive On delete
Project (project) belongs to yes archived along deleted along
Employee (employee, risk administrator) belongs to no kept reference cleared
Measure (risk_action) has many – archived along deleted along

No state field. Two yes/no attributes act like states: active/inactive (active) and occurred / not occurred (occurred_at set or empty; the table shows „Nicht eingetreten“).

  • Delete from the row menu after a confirmation prompt; deletes all measures along with it.
  • A risk without a measure is marked red in the table and carries the badge „Keine Maßnahme“ in the sheet.
  • Filter and sorting affect only the table; cards and matrix always use the whole set.

Possible loss, probable loss (with measures and measure costs), actual loss, risk exposure (server, without measures, without active filter), risk/opportunity matrix (X = occurrence %, Y = possible loss, active only) and risk heat map (loss magnitude × probability rating). See Risks & opportunities.

Measure · Opportunity · Risk costs · Guides › Risk/opportunity matrix