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

Incident Listing

CJIWave 1
16 reports  ·  3,808 runs (12 mo)  ·  Simple  ·  Target: Paginated report
Download RDLView outputRefresh
Member reportsTemplatePower BI outputValidation (12)
NameSourceFolderRunsLast runMapping
Incident Listing - Agency L (Last 90 Days)CoCognos Incidents1,2669/30/2026 5:58 PMMapped
Copy of Incident ListingCoCognos user3151,0409/29/2026 2:26 PMMapped
Incident Listing - Agency A (2026 YTD)CoCognos Incidents7849/30/2026 6:32 PMMapped
Incident Listing - Agency A (Last 90 Days)CoCognos Incidents4939/30/2026 8:42 PMMapped
Incident Listing - Agency D (2026 YTD)CoCognos Incidents1419/30/2026 10:52 AMMapped
Incident Listing - Agency D (2024)CoCognos Incidents229/18/2026 9:22 AMMapped
Incident Listing - Agency L (2024)CoCognos Incidents168/28/2026 1:34 AMMapped
Incident Listing - Agency G (2025)CoCognos Incidents149/24/2026 1:06 PMMapped
Incident Listing - Agency F (2025)CoCognos Incidents128/14/2026 11:31 AMMapped
Incident Listing - Agency I (2024)CoCognos Incidents88/29/2026 11:17 AMMapped
Copy of Incident ListingCoCognos user13769/5/2026 1:19 AMMapped
Incident Listing - Agency D (2025)CoCognos Incidents69/19/2026 5:03 AMMapped
Incident Listing - Agency B (2025)CoCognos Incidents0NeverMapped
Incident Listing - Agency I (2025)CoCognos Incidents0NeverMapped
Copy of Incident ListingCoCognos user5830NeverMapped
Copy of Incident ListingCoCognos user2790NeverMapped
16 of 16
Template
Target
Paginated report
Parameters
@Agency, @DateFrom, @DateTo
Security
Row-level, by agency
Replaces
16 reports
Layout
Standard
SELECT i.incident_id,
       i.occurred_date,
       o.offense_desc,
       i.beat,
       i.disposition
FROM incident i
JOIN offense_code o ON o.offense_code = i.offense_code
WHERE i.agency_id = @Agency
  AND i.occurred_date BETWEEN @DateFrom AND @DateTo
ORDER BY i.occurred_date