Migration Workbench | Workspace: CJIS environment Sample data
MFA RE
Convert › F007

Field Interview Log

CJIWave 2
9 reports from 2 platforms  ·  531 runs (12 mo)  ·  Simple  ·  Target: Paginated report
Dataset query (SQL Server)
SELECT f.fi_id,
       f.fi_date,
       f.beat,
       f.reason
FROM field_interview f
WHERE f.agency_id = @Agency
  AND f.fi_date BETWEEN @DateFrom AND @DateTo