Column Case Investigative 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.
Manage your cases in a single, unified platform
The biggest 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.
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.