Migration Workbench | Workspace: CJIS environment Sample data
MFA RE
Report inventory › Citations by Violation - Agency H (Last 90 Days)
Co

Citations by Violation - Agency H (Last 90 Days)

ConsolidateCJI
IBM Cognos Analytics report  ·  /Public Folders/Agency H/Citations/Citations by Violation - Agency H (Last 90 Days)
Definition
Source
Cognos 11.2 (Regional)
Object
Report
Owner
Shared
Data access
SQL query
Layout
Crosstab
Parameters
None
Tables
citation
Columns
c.agency_id, c.fine, c.issued_date, c.violation
Complexity
Medium
Formatting
Standard
Usage (12 months)
Runs
6
Users
6
Last run
8/27/2026 4:02 AM
Failures
0
Migration
Family
F009 Citations by Violation
Target
Paginated report
Wave
Wave 1
Validation
Match
Connector notes
  • Native SQL query read from the report specification.