Migration Workbench | Workspace: CJIS environment Sample data
MFA RE
Report inventory › Copy of Property Loss Report
Co

Copy of Property Loss Report

RetireCJI
IBM Cognos Analytics report  ·  /My Folders/user126/Copy of Property Loss Report
Source query
SELECT i.incident_id,
       i.occurred_date,
       i.offense_code,
       i.property_loss
FROM incident i
WHERE i.property_loss > 0
  AND i.agency_id = 5
  AND i.occurred_date BETWEEN '2026-07-02' AND '2026-09-30'