Convert › F033
Juvenile Arrests
CJIWave 3| Name | Source | Folder | Runs | Last run | Mapping |
|---|---|---|---|---|---|
| Copy of Juvenile Arrests | CoCognos | user423 | 64 | 9/27/2026 2:23 PM | Mapped |
| Juvenile Arrests - Agency B (2025) | CoCognos | Arrests | 53 | 9/27/2026 10:14 PM | Mapped |
| Juvenile Arrests - Agency I (2026 YTD) | CoCognos | Arrests | 24 | 9/27/2026 3:59 PM | Mapped |
| Copy of Juvenile Arrests | CoCognos | user125 | 14 | 9/19/2026 11:12 PM | Mapped |
| Juvenile Arrests - Agency I (2024) | CoCognos | Arrests | 13 | 9/3/2026 11:50 AM | Mapped |
| Juvenile Arrests - Agency G (2026 YTD) | CoCognos | Arrests | 11 | 8/27/2026 1:38 PM | Mapped |
| Juvenile Arrests - Agency G (2024) | CoCognos | Arrests | 10 | 9/1/2026 1:32 PM | Mapped |
| Juvenile Arrests - Agency A (2026 YTD) | CoCognos | Arrests | 9 | 9/5/2026 12:32 PM | Mapped |
| Juvenile Arrests - Agency D (2026 YTD) | CoCognos | Arrests | 7 | 8/22/2026 7:01 AM | Mapped |
| Juvenile Arrests - Agency B (Last 90 Days) | CoCognos | Arrests | 6 | 7/30/2026 3:00 PM | Mapped |
| Juvenile Arrests - Agency A (2025) | CoCognos | Arrests | 6 | 8/31/2026 9:28 AM | Mapped |
| Juvenile Arrests - Agency E (2026 YTD) | CoCognos | Arrests | 6 | 9/13/2026 6:16 AM | Mapped |
| Juvenile Arrests - Agency H (2024) | CoCognos | Arrests | 0 | Never | Mapped |
| Juvenile Arrests - Agency D (2025) | CoCognos | Arrests | 0 | Never | Mapped |
| Juvenile Arrests - Agency B (2026 YTD) | CoCognos | Arrests | 0 | Never | Mapped |
| Juvenile Arrests - Agency I (2025) | CoCognos | Arrests | 0 | Never | Mapped |
| Copy of Juvenile Arrests | CoCognos | user197 | 0 | Never | Mapped |
17 of 17
Template
- Target
- Paginated report
- Parameters
- @Agency, @DateFrom, @DateTo
- Security
- Row-level, by agency
- Replaces
- 17 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