Migration Workbench | Workspace: CJIS environment Sample data
MFA RE
Report inventory › Clearance Rate by Offense - Agency C (2025)
RS

Clearance Rate by Offense - Agency C (2025)

ConsolidateCJI
SQL Server Reporting Services report  ·  /Agency C/NIBRS/Clearance Rate by Offense - Agency C (2025)
Definition
Source
SSRS 2016 (Records)
Object
Report
Owner
Shared
Data access
SQL query
Layout
List
Parameters
None
Tables
incident
Columns
i.agency_id, i.cleared, i.occurred_date, i.offense_code
Complexity
Simple
Formatting
Standard
Usage (12 months)
Runs
10
Users
10
Last run
9/13/2026 4:28 PM
Failures
0
Migration
Family
F005 Clearance Rate by Offense
Target
Paginated report
Wave
Wave 2
Validation
Match
Connector notes
  • Dataset query read from the RDL.