Migration Workbench | Workspace: CJIS environment Sample data
MFA RE

Validation

90 active query reports compared with their rebuilt Power BI dataset  ·  same parameters on both sides  ·  rows, totals and record hash
Compared
90
Match
90
Mismatch
0
Families with mismatches
0
ReportSourceFamilySource rowsPower BI rowsRecord hashWCAG 2.1 AAResult
Burglary by BeatRS SSRS F0099090 992e44f5323bPassMatch
Records Request 207RS SSRS F015159159 0cf69283c390PassMatch
Citations by Violation - Agency F (2026 YTD)RS SSRS F0174545 3f8d058a5587PassMatch
Clearance Rate by Offense - Agency C (2025)RS SSRS F0051212 cd9604c80e68PassMatch
Clearance Rate by Offense - Agency I (Last 90 Days)RS SSRS F0051212 1d441e61e942PassMatch
Juvenile Arrests - Agency D (2025)CR Crystal F0133232 9fad67988f9dPassMatch
Juvenile Arrests - Agency I (2024)CR Crystal F0132424 a1d95562479fPassMatch
Field Interview Log - Agency I (Last 90 Days)CR Crystal F0076565 0b19ece3263dPassMatch
Records Request 216RS SSRS F016242242 426b80ee9f7fPassMatch
Open Case Aging - Agency D (Last 90 Days)RS SSRS F008101101 979fdcbbae98PassMatch
Records Request 206RS SSRS F018111111 c16211e58957PassMatch
Burglary by Beat - Agency I (2026 YTD)RS SSRS F0095454 3845eac77a0bPassMatch
Drug and Weapon Violations - Agency B (2026 YTD)CR Crystal F004223223 0af7e4473ecePassMatch
Property Loss Report - Agency B (2026 YTD)CR Crystal F002981981 0b5e5a507b64PassMatch
Arrests by Charge - Agency A (Last 90 Days)CR Crystal F0013535 6006190c13edPassMatch
Open Case Aging - Agency A (2026 YTD)CR Crystal F008477477 acc11c5d94eePassMatch
Drug and Weapon Violations - Agency F (2025)CR Crystal F004191191 6aaf7248910cPassMatch
Clearance Rate by OffenseRS SSRS F0051212 cd9604c80e68PassMatch
Incident ListingRS SSRS F0031,9951,995 62c8a658269fPassMatch
Records Request 213RS SSRS F014159159 fc77a237c584PassMatch
Arrests by Charge - Agency F (2025)RS SSRS F0013636 87450e02b73cPassMatch
Burglary by Beat - Agency K (2025)RS SSRS F0097878 a4d9e4828774PassMatch
Field Interview Log - Agency F (2024)CR Crystal F007276276 dd5f6097f684PassMatch
Arrest Detail with Incident - Agency C (2026 YTD)CR Crystal F012406406 ec9a0d3b76a5PassMatch
Property Loss Report - Agency B (2025)RS SSRS F0021,3941,394 514c168ebde0PassMatch
51 to 75 of 90 ‹ 1234 ›