Verify a separation-of-duties rule with SQL

The query

The published sample includes the Engine’s rules table. This query retrieves the all-time process-flow result for the declared assessment/approval control.

SELECT r.checked_count, r.hit_count
FROM rules AS r
JOIN analysis_windows AS w ON w.scope_id = r.scope_id
WHERE w.analysis_window = 'all'
  AND w.analysis_domain = 'process_flow'
  AND r.rule = 'role_separation'
  AND r.activity = 'Assess Claim'
  AND r.second_activity = 'Approve Claim';

Read the exact source rows.

The rule_hits table identifies the affected claims and events; events preserves the source links. One affected claim may have multiple hit rows, so count distinct claim IDs when measuring how many claims were affected.

Download the result file.

Run the query above in your browser, or open the file in any SQLite viewer. All records are synthetic and published for independent inspection.