Migration Workbench | Workspace: CJIS environment Sample data
MFA RE
Convert › F011

Open Case Aging

CJIWave 2
22 reports  ·  1,463 runs (12 mo)  ·  Medium  ·  Target: Paginated report
Download RDLView outputRefresh
Member reportsTemplatePower BI outputValidation (15)
NameSourceFolderRunsLast runMapping
Copy of Open Case AgingCoCognos user4608819/30/2026 5:39 AMMapped
Open Case Aging - Agency E (2026 YTD)CoCognos Incidents3589/30/2026 2:25 PMMapped
Open Case Aging - Agency L (2024)CoCognos Incidents819/28/2026 12:48 PMMapped
Copy of Open Case AgingCoCognos user324509/30/2026 3:41 AMMapped
Open Case Aging - Agency A (Last 90 Days)CoCognos Incidents179/26/2026 3:44 AMMapped
Copy of Open Case AgingCoCognos user429109/9/2026 10:54 PMMapped
Open Case Aging - Agency F (2026 YTD)CoCognos Incidents99/15/2026 9:34 AMMapped
Open Case Aging - Agency G (2026 YTD)CoCognos Incidents99/23/2026 10:47 AMMapped
Open Case Aging - Agency G (Last 90 Days)CoCognos Incidents89/16/2026 4:51 AMMapped
Open Case Aging - Agency J (2024)CoCognos Incidents88/30/2026 6:37 PMMapped
Copy of Open Case AgingCoCognos user47078/31/2026 3:30 PMMapped
Open Case Aging - Agency F (Last 90 Days)CoCognos Incidents78/28/2026 12:25 PMMapped
Open Case Aging - Agency H (2025)CoCognos Incidents69/18/2026 11:50 AMMapped
Open Case Aging - Agency K (Last 90 Days)CoCognos Incidents66/14/2026 3:11 AMMapped
Copy of Open Case AgingCoCognos user55268/13/2026 10:10 PMMapped
Open Case Aging - Agency G (2025)CoCognos Incidents0NeverMapped
Open Case Aging - Agency L (Last 90 Days)CoCognos Incidents0NeverMapped
Open Case Aging - Agency F (2024)CoCognos Incidents0NeverMapped
Open Case Aging - Agency H (2026 YTD)CoCognos Incidents0NeverMapped
Open Case Aging - Agency C (2024)CoCognos Incidents0NeverMapped
Open Case Aging - Agency E (2024)CoCognos Incidents0NeverMapped
Copy of Open Case AgingCoCognos user2670NeverMapped
22 of 22
Template
Target
Paginated report
Parameters
@Agency, @DateFrom, @DateTo
Security
Row-level, by agency
Replaces
22 reports
Layout
Rebuild formatting
SELECT i.incident_id,
       i.reported_date,
       i.offense_code,
       i.disposition
FROM incident i
WHERE i.disposition = 'Open'
  AND i.agency_id = @Agency
  AND i.occurred_date BETWEEN @DateFrom AND @DateTo