Report inventory › Field Interview Log - Agency A (Last 90 Days)
CR
Field Interview Log - Agency A (Last 90 Days)
ConsolidateCJIDefinition
- Source
- Crystal Reports 2016 (Jail and Records)
- Object
- Report
- Owner
- Shared
- Data access
- SQL query
- Layout
- List
- Parameters
- None
- Tables
- field_interview
- Columns
- f.agency_id, f.beat, f.fi_date, f.fi_id, f.reason
- Complexity
- Simple
- Formatting
- Standard
Usage (12 months)
- Runs
- 91
- Users
- 66
- Last run
- 9/30/2026 5:49 AM
- Failures
- 3
Migration
- Family
- F007 Field Interview Log
- Target
- Paginated report
- Wave
- Wave 2
- Validation
- Match
Connector notes
- Record selection formula translated to SQL: {field_interview.agency_id} = 1 and {field_interview.fi_date} in Date(2026,7,2) to Date(2026,9,30)