Migration Workbench | Workspace: CJIS environment Sample data
MFA RE
Report inventory › Copy of Part A Offense Counts
Co

Copy of Part A Offense Counts

ConsolidateCJI
IBM Cognos Analytics report  ·  /My Folders/user503/Copy of Part A Offense Counts
Definition
Source
Cognos 11.2 (Regional)
Object
Report
Owner
user503
Data access
SQL query
Layout
Crosstab
Parameters
None
Tables
incident, offense_code
Columns
i.agency_id, i.occurred_date, i.offense_code, o.crime_against, o.nibrs_group, o.offense_code, o.offense_desc
Complexity
Medium
Formatting
Standard
Usage (12 months)
Runs
234
Users
1
Last run
9/25/2026 2:19 AM
Failures
8
Migration
Family
F004 Part A Offense Counts
Target
Paginated report
Wave
Wave 1
Validation
Match
Connector notes
  • Native SQL query read from the report specification.