Open audit findings (count)
Findings still open or in remediation. Major findings drive surveillance-audit risk.
qualityDQ pass
qms.findings_open_count
4
findings · 5/3/2026, 4:46:18 AM
- Source
- qms-in-a-box (mvp-02)
- Owner
- Quality Manager
- Versions
- 1
30-day trend
Current published version
Published 5/2/2026 by seed-script
v1
Formula
count where status in ('open','in_remediation')Source SQL
select count(*)::int as value
from qms_audit_findings
where status in ('open', 'in_remediation')Data-quality assertions (1)
- rangeNon-negative counterror
Recent snapshots (32)
| Captured | Value | DQ | Notes |
|---|---|---|---|
| 5/3/2026, 4:46:18 AM | 4 | DQ pass | |
| 5/2/2026, 6:43:17 PM | 4 | DQ pass | |
| 5/1/2026, 6:43:59 PM | 4 | DQ pass | synthetic |
| 4/30/2026, 6:43:59 PM | 4 | DQ pass | synthetic |
| 4/29/2026, 6:43:59 PM | 4 | DQ pass | synthetic |
| 4/28/2026, 6:43:59 PM | 4 | DQ pass | synthetic |
| 4/27/2026, 6:43:59 PM | 4 | DQ pass | synthetic |
| 4/26/2026, 6:43:59 PM | 4 | DQ pass | synthetic |
| 4/25/2026, 6:44:00 PM | 4 | DQ pass | synthetic |
| 4/24/2026, 6:44:00 PM | 4 | DQ pass | synthetic |
| 4/23/2026, 6:44:00 PM | 4 | DQ pass | synthetic |
| 4/22/2026, 6:44:00 PM | 4 | DQ pass | synthetic |
| 4/21/2026, 6:44:00 PM | 4 | DQ pass | synthetic |
| 4/20/2026, 6:44:00 PM | 4 | DQ pass | synthetic |
| 4/19/2026, 6:44:00 PM | 4 | DQ pass | synthetic |
| 4/18/2026, 6:44:00 PM | 4 | DQ pass | synthetic |
| 4/17/2026, 6:44:01 PM | 4 | DQ pass | synthetic |
| 4/16/2026, 6:44:01 PM | 4 | DQ pass | synthetic |
| 4/15/2026, 6:44:01 PM | 4 | DQ pass | synthetic |
| 4/14/2026, 6:44:01 PM | 4 | DQ pass | synthetic |
| 4/13/2026, 6:44:01 PM | 4 | DQ pass | synthetic |
| 4/12/2026, 6:44:01 PM | 4 | DQ pass | synthetic |
| 4/11/2026, 6:44:01 PM | 4 | DQ pass | synthetic |
| 4/10/2026, 6:44:02 PM | 4 | DQ pass | synthetic |
| 4/9/2026, 6:44:02 PM | 4 | DQ pass | synthetic |
| 4/8/2026, 6:44:02 PM | 4 | DQ pass | synthetic |
| 4/7/2026, 6:44:02 PM | 4 | DQ pass | synthetic |
| 4/6/2026, 6:44:02 PM | 4 | DQ pass | synthetic |
| 4/5/2026, 6:44:02 PM | 4 | DQ pass | synthetic |
| 4/4/2026, 6:44:02 PM | 4 | DQ pass | synthetic |