HotFiles 2.0

Introduction

CPI’s OpenFox Hotfiles Application 2.0 (HFA) helps manage and control intrastate and NCIC records for efficient record sharing. The application is implemented in MS SQL Server® or Oracle® RDBMS technology. It is fully integrated with the OpenFox Message Switch and utilizes configurations rather than hard coding to define transaction processing and response creation. The Hotfiles 2.0 system is composed of both State-specific files as well as NCIC mirror files. CPI’s OpenFox® Hotfiles Application (HFA) 2.0 helps manage and control intrastate and NCIC records for efficient record sharing. The application is implemented in SQL Server or Oracle technology and is fully integrated with the OpenFox® Message Switch. The all new HFA 2.0 leverages CPI’s patent-pending NCIC sync technology first developed for CPI’s Sex Offender Registry 2.0 solution. The new and improved design has enhanced performance and flexibility. The following principles and functionality explain why the development of HFA 2.0 has significantly improved CPI’s HotFiles product.

Features Overview

The OpenFox Hotfile Application (HFA) provides support for the following essential capabilities:

Transaction Support

All NCIC2000 transaction and record types, and many intrastate record types, are fully supported including ENTRY, MODIFY, QUERY, CANCEL, CLEAR, and LOCATE capabilities. Full supplemental support is included.

XML Support

The HFA supports XML and standard NCIC presentation-style data exchanges based on endpoint requirements and capabilities.

Workflow and NCIC Synchronization

The HFA includes workflow management that ensures a high level of synchronization with NCIC. CPI’s cutting edge, Patent-Pending records sync functionality, which is also utilized by the SOR 2.0 solution, manages transactions modifying the Hotfile database or NCIC updates. The HFA ensures all updates to all databases and NCIC are synchronized.

Flexible Response Formats

Many of an HFA implementation’s key operational characteristics are table-driven, providing flexibility in defining response formats, duplicate checking definitions, and search algorithm details.

Record Retention and Purges

The NCIC record retention and purge guidelines and requirements are implemented in the standard design.

Backup and Recovery

The HFA implementation includes a comprehensive backup and recovery method that provides for daily online backups, in addition to a point-in-time recovery model.

Reporting

The Hotfile application environment includes administration reports and standard activity and status reports. Many reporting tools can easily support customer reporting requirements.

 

HFA 2.0 Process Flow
HFA 2.0 Data Model

Technical Breakdown

Hotfiles Application (HFA) 2.0 Design Principles:

  • Complete NCIC compliance
  • Enhanced performance
  • Enhanced flexibility
  • Improved ease of maintenance
  • Robust query functionalities
  • Flexible reporting capabilities
  • Database independent

Upgraded NCIC Compliance:

  • Leverages patent-pending NCIC sync technology
  • New NCIC data model
  • Handle both letter O and number 0 for record matching
  • Handle NCIC unsolicited messages
  • Send unsolicited messages for local-only records
  • Validation and reporting capabilities

Hibernate Framework:

  • Code auto-generation
  • More robust data retrieval
  • In Conjunction with data structure redesign

Real-time Replication Reporting Database:

  • Enhanced Flexibility
  • No negative impact on production database performance
  • Soft delete feature allows reports on purged records

HotFiles 2.0 in Action

This OpenFox® product is currently in use by:

  • Arizona Department of Public Safety
  • And Many More
‘Wounded Goddess’ statue atop the Arizona State Capitol Building in Phoenix Arizona. Other names: Statue of Justice; Winged Victory; Goddess of Victory;

HotFiles 2.0

Download PDF

Want to know more?

Feel free to reach out to us.

Contact Sales