Migration Workbench | Workspace: CJIS environment Sample data
MFA RE
Report inventory › Incident Listing - Agency J (Last 90 Days)
CR

Incident Listing - Agency J (Last 90 Days)

ConsolidateCJI
SAP Crystal Reports report  ·  /Crystal/Agency J/Incidents/Incident Listing - Agency J (Last 90 Days)
Definition
Source
Crystal Reports 2016 (Jail and Records)
Object
Report
Owner
Shared
Data access
SQL query
Layout
List
Parameters
None
Tables
incident, offense_code
Columns
i.agency_id, i.beat, i.disposition, i.incident_id, i.occurred_date, i.offense_code, o.offense_code, o.offense_desc
Complexity
Simple
Formatting
Standard
Usage (12 months)
Runs
31
Users
27
Last run
9/23/2026 6:43 AM
Failures
0
Migration
Family
F003 Incident Listing
Target
Paginated report
Wave
Wave 2
Validation
Match
Connector notes
  • SQL command read from the report.