Investigative Case Management for Law Enforcement

Column Case Management makes the investigators more productive by providing many best practices out of the box. With that said, if you require viewing the entire case and subject history, we have the product for you. If you need a product that allows you to link data and display data in a simple manner, we have the product for you. If you need a product that eliminates duplicate records, we have a product for you. If you need a product that helps enforce the Garrity requirement, well, I think you get the picture.

In summary, Column manages the life cycle of the case from intake or complaint to case completion or closure, and all the steps in between including journals, e-forms, email, video, etc. in logical and reportable structure. All of which can be viewed at the station or in field with our mobile-first architecture.

NIBRS Module

Column’s National Incident-Based Reporting System (NIBRS) Rules Engine allows investigatory data to be standardized in a NIBRS compliant way for reporting. More importantly, we have a validation engine that ensures all 212 NIBRS rules are reported accurately by checking for standards, logic, and data conflict for NIBRS associations in real-time during the data entry process. For example, if an Incident report included an offense of Homicide, but the reporting officer also entered an offense of Aggravated Assault, the system will run a validation check and send out a specific error message indicating the two violations are mutually exclusive. The application would not allow the reporting officer to close the Case until the information is corrected.

Manage your cases in a single, unified platform

What’s the most significant benefit for law enforcement? Our case management software puts everything they need right at their fingertips. Evidence is collected and stored in a single database, regardless of type or origin — meaning video and audio files are kept alongside witness reports and crime scene details. Searching for data is simple. Using our out-of-the-box, full-text search engine, investigators enter their search terms (search for complaints, cases, people, sites, property, vehicles…and even attachments) and get exactly what they're looking for the first time. This search engine can also be configured to search other databases and network directories, providing a single source for searching, relating, and viewing multiple systems.

Ease the challenges of duplicate data and reconciliation

The bane of all law enforcement investigations? Duplicate records. If multiple records are created for the same crime, subject or piece of evidence, police officers must waste valuable time tracking the relevant record and then deleting all others, in turn reducing the amount of time spent solving cases. At Column Case Investigative, we've developed an integrated duplicate detection tool — when officers search records or create new ones, they're provided a list of all duplicate data. In addition, our software allows officers to merge these records to preserve useful data while eliminating redundancy.

Prioritize and Optimize

To help ensure cases are solved efficiently, officers can use our solvability matrix to determine which investigations have the highest likelihood of a positive outcome and can also customize reports and warnings to ensure time-sensitive data or case files are handled appropriately. With multiple cases to solve, it's easy for officers to lose track of small, disconnected pieces of data or miss deadlines — we've built a system from the ground up to increase officer efficiency rather than demanding more of their time.

Law enforcement personnel are under constant pressure to solve cases and under constant scrutiny from public agencies to effectively handle data. Column Case Investigative's unified case management software tackles both challenges.

Community Policing

Column Case helps manage all of your community policing activities from relationship-building; to the scheduling of events and meetings to the timely follow up with action plans. Additionally, Column can help agencies prioritize the type and number of citizen complaints allowing leadership to view in real-time the numbers based on local statistics and data.

For example, an agency may have a policy that states if five or more accidents occur at a particular intersection an alert can be sent through the application to initiate a safety review of that intersection.

Internal Affairs and Complaint Management

Manage police compliments and complaints with our Internal Affairs Module. We have one of the largest police departments in the country handling complaints and compliments and the entire external proceeding process. Your agency can quickly run reports or have the system automatically generate notifications based on complaints, and your agency's policies. For example, if there are two excessive force complaints in 6 months, an alert can go out to whoever needs to know. All of the notifications are configurable.

In summary, all we need to know is who and when to notify, and the application will manage the process.