Anasazi Data Extractor

Are you leaving Cerner CBH and wondering if there is a way to get your assessment data out? The Anasazi/CBH Data Extractor can completely automate that process.

The tool works by using the page definitions of your assessments to locate the SQL data storage locations. It builds a SQL statement to access all of those fields, and does lookups for code values. You can use the SQL statement to make your own views or queries, or this tool can dynamically create a SQL table to store your assessment data in a flat file format.

You can read more about it here: https://www.vanvoorstconsulting.com/projects/anasazi-cbh-data-extractor/

Anasazi/Cerner CBH WYSIWYG Assistant

For those who use Anasazi/Cerner CBH and develop their own forms, you know it can be a fairly tedious process.  One of the big time consuming steps is finding an appropriate “question” to use for each of the items on your form.  In addition to finding a question with the right data type, you also need to make sure it doesn’t interfere with other questions on your existing forms.  This can be a very time consuming process for even a small form.

To assist with this part of the form development process, I’ve developed the “WYSIWYG Assistant”.  This tool interfaces with your Anasazi/Cerner CBH system to analyze your existing forms and the available questions and assists you in rapidly selecting appropriate and safe questions to use.

For more information, including a video that demonstrates how it works, check out the project page here: WYSIWYG Assistant

Contact me for more information!

Anasazi/Cerner CBH Document Extractor

Are you leaving Cerner CBH and wondering if there is a way to get your clinical documents out of it?  The short answer is that there doesn’t seem to be an easy way to do that.  The good news is that there is at least ONE way to do it without investing hundreds of hours of manual exporting.  That ONE way is the use of my “Document Extractor” utility.  It’s a highly specialized tool designed for one purpose – extract clinical documents from Cerner CBH into PDF files in an automated way.

The tool works by interacting with the “Print Clinical Documents” report and a PDF printer.  It allows you to choose a list of clients whose documents you’d like to have extracted, and it will automatically run the Print Clinical Documents report for each of them and print the report to a PDF file.

You can read more about here: Document Extractor

An evaluation copy is available!

Excel based dashboard accessing enterprise data

The Excel based “dashboard” concept that I’ve developed for a few clients is one that allows department supervisors to quickly access and overview of the key elements of their programs.

The Excel spreadsheet has code in it that allows for direct refreshing of the data from the enterprise software database on SQL server.  The data and charts that are displayed are specific to what they need to monitor and aggregate data from multiple sources.  That data may be available on various reports in the enterprise system, but this tool pulls all they key pieces together in one place for a quick view of all key information.

By using a spreadsheet to access this information, the end-user can further analyze the data if they want.

The most common place that I’ve used this method is in connection with the Anasazi/Cerner Community Behavioral Health software package.  The spreadsheet links to Anasazi/Cerner and uses the logged in user information to check which units/subunits the user has access to and will limit the data that they can access to only what they can normally see in Anasazi/Cerner.

With the basic methodology of how this works completed, I’m able to do additional spreadsheet data extracts/dashboards in as little as a couple of hours – making it a very cost effective way of putting a fantastic management tool in the hands of supervisors and managers.