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

Clearance Rate by Offense - Agency F (2024)

MigrateCJI
SQL Server Reporting Services report  ·  /Agency F/NIBRS/Clearance Rate by Offense - Agency F (2024)
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
887
Users
150
Last run
9/30/2026 9:30 PM
Failures
18
Migration
Family
F005 Clearance Rate by Offense
Target
Paginated report
Wave
Wave 2
Validation
Match
Connector notes
  • Dataset query read from the RDL.