Juvenile Arrests

CJIRetire

1 reports · 0 runs (12 mo) · Simple · Target: Retire

Member reports Template Power BI output Validation

Name	Source	Folder	Runs	Last run	Mapping
Juvenile Arrests	CoCognos	Arrests	0	Never	Mapped

1 of 1

Template

Target: Retire
Parameters: @DateFrom, @DateTo
Security: Row-level, by agency
Replaces: 1 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 1 = 1
  AND r.arrest_date BETWEEN @DateFrom AND @DateTo