Validation › Citations by Violation - Agency B (Last 90 Days)
Compare results
MatchCJIAgency B onlyAccess loggedWCAG 2.1 AAChecks
| Check | Source (SSRS) | Target (Power BI) | Result |
|---|---|---|---|
| Row count | 15 | 15 | Match |
| Total of citations | 195 | 195 | Match |
| Total of fines | 37,719.0 | 37,719.0 | Match |
| Record hash | cb6ad973b338 | cb6ad973b338 | Match |
Access and audit
- Classification
- CJI
- Row security
- By agency AC-3
- Session
- MFA, CJIS-trained user IA-2(1)
- Data location
- Agency network SC-28
- Run by
- Validation service, read only AC-6
- This view
- Logged AU-2
- Evidence
- Retained with the release AU-11
Accessibility, WCAG 2.1 AA generated paginated report
| Success criterion | Requirement | Generated report | Result |
|---|---|---|---|
| Text contrast (1.4.3) | At least 4.5:1 | 6.2:1 | Pass |
| Report title (2.4.2) | Title and description | Present | Pass |
| Parameter labels (3.3.2) | 3 parameters | All labelled | Pass |
| Table headers (1.3.1) | Header row repeats | Yes | Pass |
| Reading order (1.3.2) | Top to bottom | In order | Pass |
| Alt text (1.1.1) | Images and charts described | No images or charts | Pass |
Source query
SELECT c.violation, substr(c.issued_date,1,7) AS month, COUNT(*) AS citations, SUM(c.fine) AS fines FROM citation c WHERE c.agency_id = 2 AND c.issued_date BETWEEN '2026-07-02' AND '2026-09-30' GROUP BY c.violation, substr(c.issued_date,1,7)
Power BI dataset query
SELECT c.violation, CONVERT(char(7), c.issued_date, 126) AS month, COUNT(*) AS citations, SUM(c.fine) AS fines FROM citation c WHERE c.agency_id = @Agency AND c.issued_date BETWEEN @DateFrom AND @DateTo GROUP BY c.violation, CONVERT(char(7), c.issued_date, 126)