Migration Workbench | Workspace: CJIS environment Sample data
MFA RE
Report inventory › Open Case Aging - Agency F (Last 90 Days)
Co

Open Case Aging - Agency F (Last 90 Days)

ConsolidateCJI
IBM Cognos Analytics report  ·  /Public Folders/Agency F/Incidents/Open Case Aging - Agency F (Last 90 Days)
Definition
Source
Cognos 11.2 (Regional)
Object
Report
Owner
Shared
Data access
SQL query
Layout
List
Parameters
None
Tables
incident
Columns
i.agency_id, i.disposition, i.incident_id, i.occurred_date, i.offense_code, i.reported_date
Complexity
Medium
Formatting
Conditional styles (6), Master-detail links
Usage (12 months)
Runs
7
Users
7
Last run
8/28/2026 12:25 PM
Failures
1
Migration
Family
F011 Open Case Aging
Target
Paginated report
Wave
Wave 2
Validation
Match
Connector notes
  • Native SQL query read from the report specification.