Migration Workbench | Workspace: CJIS environment Sample data
MFA RE
Report inventory › Juvenile Arrests - Agency D (2025)
CR

Juvenile Arrests - Agency D (2025)

ConsolidateCJI
SAP Crystal Reports report  ·  /Crystal/Agency D/Arrests/Juvenile Arrests - Agency D (2025)
Definition
Source
Crystal Reports 2016 (Jail and Records)
Object
Report
Owner
Shared
Data access
SQL query
Layout
List
Parameters
None
Tables
arrest
Columns
r.agency_id, r.arrest_date, r.arrest_id, r.arrestee_age, r.charge_code
Complexity
Simple
Formatting
Standard
Usage (12 months)
Runs
10
Users
10
Last run
9/5/2026 12:04 AM
Failures
0
Migration
Family
F013 Juvenile Arrests
Target
Paginated report
Wave
Wave 3
Validation
Match
Connector notes
  • Record selection formula translated to SQL: {arrest.arrestee_age} < 18 and {arrest.agency_id} = 4 and {arrest.arrest_date} in Date(2025,1,1) to Date(2025,12,31)