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

Field Interview Log

CJIWave 2
17 reports  ·  488 runs (12 mo)  ·  Simple  ·  Target: Paginated report
Download RDLView outputRefresh
Member reportsTemplatePower BI outputValidation (13)
NameSourceFolderRunsLast runMapping
Field Interview Log - Agency F (Last 90 Days)CoCognos Field Interviews2079/29/2026 10:54 AMMapped
Copy of Field Interview LogCoCognos user466769/30/2026 7:32 PMMapped
Field Interview Log - Agency B (Last 90 Days)CoCognos Field Interviews529/26/2026 8:56 AMMapped
Field Interview Log - Agency L (Last 90 Days)CoCognos Field Interviews499/30/2026 7:31 PMMapped
Field Interview Log - Agency D (2025)CoCognos Field Interviews418/27/2026 11:37 PMMapped
Field Interview Log - Agency K (2026 YTD)CoCognos Field Interviews109/28/2026 9:15 AMMapped
Field Interview Log - Agency G (2026 YTD)CoCognos Field Interviews96/26/2026 4:03 AMMapped
Field Interview Log - Agency E (Last 90 Days)CoCognos Field Interviews99/16/2026 11:20 PMMapped
Field Interview Log - Agency C (2025)CoCognos Field Interviews89/26/2026 10:55 AMMapped
Field Interview Log - Agency J (2024)CoCognos Field Interviews78/12/2026 4:41 AMMapped
Field Interview Log - Agency G (2025)CoCognos Field Interviews78/7/2026 4:21 PMMapped
Field Interview Log - Agency D (Last 90 Days)CoCognos Field Interviews79/21/2026 7:46 PMMapped
Field Interview Log - Agency E (2025)CoCognos Field Interviews69/24/2026 2:49 AMMapped
Field Interview Log - Agency C (2024)CoCognos Field Interviews0NeverMapped
Field Interview Log - Agency E (2026 YTD)CoCognos Field Interviews0NeverMapped
Field Interview Log - Agency B (2026 YTD)CoCognos Field Interviews0NeverMapped
Copy of Field Interview LogCoCognos user5170NeverMapped
17 of 17
Template
Target
Paginated report
Parameters
@Agency, @DateFrom, @DateTo
Security
Row-level, by agency
Replaces
17 reports
Layout
Standard
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