Validation › Incident Listing - Agency A (Last 90 Days)
Compare results
MismatchCJIAgency A onlyAccess loggedWCAG 2.1 AAFinding: Incidents without a beat dropped by an inner join. (Defect seeded on purpose in this sample workspace.)
Checks
| Check | Source (Cognos) | Target (Power BI) | Result |
|---|---|---|---|
| Row count | 773 | 748 | Mismatch |
| Record hash | d077cadd44c3 | e72a93dfc5d6 | Mismatch |
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 |
In source, missing in target (25)
| incident_id | occurred_date | offense_desc | beat | disposition |
|---|---|---|---|---|
| 254 | 2026-08-28 | Simple Assault | (blank) | Cleared by Arrest |
| 543 | 2026-09-21 | All Other Larceny | (blank) | Open |
| 1032 | 2026-08-16 | Simple Assault | (blank) | Closed |
| 1049 | 2026-08-02 | Motor Vehicle Theft | (blank) | Open |
| 2785 | 2026-09-05 | All Other Larceny | (blank) | Exceptionally Cleared |
| 4096 | 2026-08-06 | All Other Larceny | (blank) | Exceptionally Cleared |
| 4405 | 2026-09-17 | Simple Assault | (blank) | Exceptionally Cleared |
| 15853 | 2026-07-19 | All Other Larceny | (blank) | Cleared by Arrest |
| 16677 | 2026-08-30 | All Other Larceny | (blank) | Unfounded |
| 18030 | 2026-07-14 | Driving Under the Influence | (blank) | Open |
Source query
SELECT i.incident_id, i.occurred_date, o.offense_desc, i.beat, i.disposition FROM incident i JOIN offense_code o ON o.offense_code = i.offense_code WHERE i.agency_id = 1 AND i.occurred_date BETWEEN '2026-07-02' AND '2026-09-30' ORDER BY i.occurred_date
Power BI dataset query
SELECT i.incident_id, i.occurred_date, o.offense_desc, i.beat, i.disposition FROM incident i JOIN offense_code o ON o.offense_code = i.offense_code JOIN (SELECT DISTINCT beat FROM incident WHERE beat IS NOT NULL) b ON b.beat = i.beat WHERE i.agency_id = @Agency AND i.occurred_date BETWEEN @DateFrom AND @DateTo ORDER BY i.occurred_date