Reference & Data Model
Risk (risk)
A risk is a possible loss event of a project, assessed with amount, probability and rating.
Purpose
Section titled “Purpose”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)
Where in the app
Section titled “Where in the app”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.
Fields
Section titled “Fields”| 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.
Relations
Section titled “Relations”| 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 |
States
Section titled “States”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“).
Rules & automation
Section titled “Rules & automation”- 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.
See also
Section titled “See also”Measure · Opportunity · Risk costs · Guides › Risk/opportunity matrix