Validation › Copy of Vehicle Crime Summary

Compare results

MatchCJIAgency L onlyAccess logged

Object: Copy of Vehicle Crime Summary · Source: IBM Cognos Analytics · Target: Power BI report · Parameters: Agency L, 7/2/2026 to 9/30/2026

Download evidence Audit trail Open familyRefresh

Checks

Check	Source (Cognos)	Target (Power BI)	Result
Row count	2	2	Match
Total of incidents	80	80	Match
Total of loss	154,036.63	154,036.63	Match
Record hash	2bcf5246ba5c	2bcf5246ba5c	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

CJIS Security Policy controls

Source query

SELECT i.offense_code,
       COUNT(*) AS incidents,
       SUM(i.property_loss) AS loss
FROM incident i
WHERE i.offense_code IN ('23F','240')
  AND i.agency_id = 12
  AND i.occurred_date BETWEEN '2026-07-02' AND '2026-09-30'
GROUP BY i.offense_code

Power BI dataset query

SELECT i.offense_code,
       COUNT(*) AS incidents,
       SUM(i.property_loss) AS loss
FROM incident i
WHERE i.offense_code IN ('23F','240')
  AND i.agency_id = @Agency
  AND i.occurred_date BETWEEN @DateFrom AND @DateTo
GROUP BY i.offense_code