Report inventory › Juvenile Arrests - Agency I (2024)
CR
Juvenile Arrests - Agency I (2024)
ConsolidateCJIDefinition
- 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/19/2026 6:55 PM
- Failures
- 1
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} = 9 and {arrest.arrest_date} in Date(2024,1,1) to Date(2024,12,31)