Risk Reviews

Risk reviews are managed via the Lydaro UI and server actions.

Data Model

risk_reviews (
  review_id      uuid PRIMARY KEY,
  risk_id        uuid REFERENCES risks,
  reviewed_by    uuid REFERENCES profiles(id),
  reviewed_at    timestamptz DEFAULT now(),
  status_change  risk_status,  -- optional: new status after review (draft, active, mitigated, realized, closed)
  next_review    date,
  notes          text NOT NULL
)

Impact on Quality Score

Having at least one recent review (within the configured interval) significantly increases Quality Score. Reviews older than the interval are treated as missing.

Review Interval

Configured per organisation in organisation_workflow_settings.review_interval_days. Default: 30 days.

Related

• Workflow Engine
• Quality Scoring