Convert › F013
Juvenile Arrests
CJIWave 3| Name | Source | Folder | Runs | Last run | Mapping |
|---|---|---|---|---|---|
| Juvenile Arrests - Agency A (2024) | RSSSRS | Arrests | 19 | 8/15/2026 8:26 PM | Mapped |
| Juvenile Arrests - Agency D (2025) | CRCrystal | Arrests | 10 | 9/5/2026 12:04 AM | Mapped |
| Juvenile Arrests - Agency I (2024) | CRCrystal | Arrests | 10 | 9/19/2026 6:55 PM | Mapped |
| Juvenile Arrests - Agency K (2025) | RSSSRS | Arrests | 6 | 7/21/2026 11:58 AM | Mapped |
| Juvenile Arrests - Agency J (2024) | RSSSRS | Arrests | 0 | Never | Mapped |
| Juvenile Arrests - Agency D (2024) | RSSSRS | Arrests | 0 | Never | Mapped |
| Juvenile Arrests - Agency G (2026 YTD) | CRCrystal | Arrests | 0 | Never | Mapped |
| Juvenile Arrests - Agency A (2025) | CRCrystal | Arrests | 0 | Never | Mapped |
| Juvenile Arrests - Agency L (2026 YTD) | CRCrystal | Arrests | 0 | Never | Mapped |
9 of 9
Template
- Target
- Paginated report
- Parameters
- @Agency, @DateFrom, @DateTo
- Security
- Row-level, by agency
- Replaces
- 9 reports
- Layout
- Standard
SELECT r.arrest_id, r.arrest_date, r.charge_code, r.arrestee_age FROM arrest r WHERE r.arrestee_age < 18 AND r.agency_id = @Agency AND r.arrest_date BETWEEN @DateFrom AND @DateTo