Archive for the 'Reporting' Category

Announcing Free Galen EHR and Analytics Webcasts

Galen Healthcare Solutions will be hosting a series of free webcasts covering the Allscripts EHR database and Allscripts Analytics application.

The purpose of the EHR webcasts is to give a detailed view into the underlying database schemas as well as useful queries for the Patient and Order/Results tables. For Analytics we will be covering a basic overview of the Analytics applications as well as detailed examples using Worksheets and Crosstabs. 

These will be structured in a similar format to university courses – the three classes will be at 100 (intro) levels.  The list of the webcasts and their times may be found below.

 

Allscripts EHR – Patient: Overview of the Patient tables as they relate to the Allscripts EHR Database. This course will cover basic concepts related to Patient tables, as well as useful queries, views and general best practice techniques. 

  • Wednesday, June 2nd, 2010 at 2:00pm EST

Allscripts EHR – Order/Results: Overview of the Order/Results tables as they relate to the Allscripts EHR Database. This course will cover basic concepts related to Order/Results tables, as well as useful queries, views and general best practice techniques. 

  • Wednesday July 7th, 2010 at 2:00pm EST

Allscripts Analytics: Overview of the Allscipts Analytics application. This course will cover basic concepts related to general functionality of the Allcripts Analytics applications, including example Worksheet and Crosstab problems as well as general best practice techniques. 

  • Wednesday August 11th, 2010 at 2:00pm EST

To attend, please contact Dave Boerner, Dave.Boerner@galenhealthcare.com . You must be an existing Allscripts Enterprise EHR client to attend.

We also offer training courses and reporting services for the Allscripts Enterprise EHR database, ETL database, Analytics and the ConnectR  database.  Please contact sales@galenhealthcare.com for more information regarding these courses and our reporting services.

Meaningful Use FAQ

As reported on EMR and HIPAA, CMS has made comments on the Meaningful Use Interim Final Rule public, providing an additive level of transparency and CMIO promptly provided a summary of the EHR comments. In light of the transparency CMS/HHC/ONC yields in regards to the Meaningful Use Interim Final Rule, we encourage members of the healthcare IT community to take full advantage of the comment period, which ends in less than a month from now. To encourage ongoing dialogue, we have published a Meaningful Use FAQ in which we anticipate aggregating questions that persist in the community and also encourage active participation. For instance, in a previous post, I pondered how meaningful use would be communicated.

Other items to note in regards to lingering questions surrounding Meaningful Use and ARRA as a whole:

  • Dr. John Halamka also addressed the public comments on the Interim final rule on his blog post.
  • Many questions persist surrounding interoperability standards, and as John over at EMR and EHR addressed on his blog post, the Healthcare Information Technology Standards Panel (HITSP) was recently extended to be operational until April 30th only. How will this impact communication of meaningful use from organization to the government?
  • We recently updated our meaningful use matrix to include which functionality supporting MU measures are delivered in the Allscripts Enterprise EHR (AE-EHR). John at EMR and HIPAA is also collecting a number of the various matrixes that people have put together around the EMR meaningful use criteria

If your organization is looking for assistance in exhibiting meaningful use, please contact sales@galenhealthcare.com and visit our website for more information regarding our technical and professional service offerings.

EHR Database Architecture and Reporting Workshop

Galen will be hosting another in Enterprise reporting workshop this coming March.  This has been a popular course, so please sign up early!

What: A three-day course for report writers, DBAs and those in healthcare informatics on the Allscripts Enterprise EHR database.
When
: March 1 – 3, 2010
Where: Boston, MA
Price: $2,500


The Galen Database Architecture and Reporting Workshop has furthered our understanding of the Allscripts Enterprise EHR database.  The clear presentation and substantial hands-on time helped us to greatly accelerate our production of customized reports.  And, the data dictionary documentation alone is invaluable.
– Chris Hyde, DBA, Albuquerque Health Partners

The attached announcement includes additional information regarding the course and suggested audience (report writers, DBAs, etc).

Please contact Mike Dow to register, or if you have any questions – mike.dow@galenhealthcare.com


Estimated Effort to Exhibit Meaningful Use

There is quite a bit of buzz in the healthcare IT community surrounding the ONCHIT/CMS release of the Meaningful Use Interim Final Rule and the  and the EHR certification requirements. The author of HISTalk kindly spent his New Year’s Eve poring over the documents to provide an excel worksheet summary of the actual criteria and thresholds and the author of the Medical Software Advice blog did a great job of outlining definition, features and measurement with his blog entry.  I thought I would take it a step further and provide some meaningful information to CFOs and PMs by taking a stab at quantifying the effort involved with each measure. First some background information and disclaimers:

  • This estimated effort is based on 50 physician multi-specialty organization.
  • It is intended to give a ballpark of effort involved and the numbers serve as estimates only.
  • It does not necessarily scale linearly with number of providers or specialties.
  • The effort only addresses four categories of effort – implementation, technical, interface and training.
  • Categories of effort not addressed include project management, systems configuration and deployment, networking configuration and deployment, hardware (including desktop) deployment, and helpdesk and on-going support.

The meaningful use matrix with effort broken-out can be found on the Galen Healthcare Solutions Wiki.

Now that we have presented the effort involved, let’s delve into how EHR deployments – specifically  AE-EHR deployements – are typically phased:

Phase I: Base, Document, Scan and Dictate

Description: Provide a baseline level of EHR functionality to all users. Real-time access to physician schedules, transcribed and scanned documents, facilitation of dictation.  Data conversions, Scanned charts and documents, Base Deployment. This approach typically appeals to all providers regardless of technical aptitude and would not require significant workflow changes

Advantages: Clinical information access internal and external to the clinic, reduced level of change for physicians through the use of dictate, realized benefits of decreased errors and re-work.

Interfaces:

  • Registration & Scheduling
    • Real-time inbound registration and scheduling feed from practice management system.
    • Initial bulk-load of existing active patients and appointments
  • Transcription
    • Real-time inbound transcription interface from transcription system.

*Phase II: Rx+, Note, Forms, Results

Description: Add medication management, structured note and results

Advantages: Ability to collect structured information facilitating use of panel queries. Additionally, formulary compliance, and prescription faxing/e-prescribing to pharmacies and ability to capture results as discrete data elements

Interfaces:

  • Results
    • Real-time inbound results interface from lab system.

*Phase III: Order, Charge

Description: Facilitates charge capture and order transmission.

Advantages: Completes the access to centralized patient data and further enhances the quality of care and service to patients.

Interfaces:

  • Orders
    • Real-time outbound order interface to lab system
  • Charge
    • Real-time outbound charge interface to the practice management system.

*Phase II and III can be combined based upon the organization requirements

In conclusion, one of the biggest questions that lingers for me is how the data is to be relayed to the government such that organizations can be evaluated as to whether or not they meet the thresholds to receive the incentives. Custom reporting comes to mind as precedent has been set here, specifically with PQRI and Medicare HCC. Galen Healthcare Solutions certainly can provide custom reporting specific to organizations needs in order to communicate meaningful use. Another solution is Allscripts Clinical Quality Solution powered by TeamPraxis. In the meantime, we wait for the rule to be finalized and anticipate announcement of how the meaningful use data is to be relayed.

If your organization is looking for assistance in exhibiting meaningful use, please contact sales@galenhealthcare.com and visit our website for more information regarding our technical and professional service offerings.

Allscripts Enterprise EHR Custom Reporting

The requests for reports that we get runs the gamut. Most of the time, clients are looking to modify the existing canned reports that Allscripts offers with the Allscripts Enterprise Electronic Health Record (AE-EHR). Other times, clients envision a custom report that is unlike any of those currently offered and is unique to their particular organization. And still further, some organizations wish to fulfill reporting metrics to receive monetary incentives from initiatives such as the Physician Quality Reporting Initiatives (PQRI) and P4P (Pay for Performance) .  Given the commonalities in the requests we receive, with our reporting solutions store, we have attempted to pick the most popular reports requested from clients and offer them via on-demand payment, download and installation.

We also receive a substantial amount of inquiries from clients as to what exactly goes into customizing existing reports and creating new reports. Clients are often curious as to what types of skill sets are needed. These organizations may feel that they are better suited to have their own personnel develop custom reports. For instance, the organization may have performed an return on investment (ROI) analysis and determined it makes the most financial sense to train their own staff to supply the multitude of administrative and “print” reports they require in the coming future.

That said, let’s get to answering the question of what goes into developing custom reports for the AE-EHR:

  1. AE-EHR Clinical Database Stored Procedures: These are used to extract data out of the database to render in the report. The stored procedures can be thought of as a “middle-man” between the database and the Crystal Report. More information on the basics of stored procedures can be found via the following link.
  2. Crystal Reports: Most AE-EHR reports are developed using Crystal Reports. Crystal controls the how the data extracted from the stored procedures renders in the final report. Crystal offers functionality for pivot tables, summary of data fields, grouping, custom formulas, suppression based upon data values, etc. For more information on Crystal reports tutorials, follow this link .
  3. Insert Scripts:  There are several places that reports can be installed within the context of the application’s user interface (UI) – these are called “Calling Points.” Reports can be printed from the administrative workplace, and also added to the UI for the traditional “print documents” – immunization or results “calling point” for instance.

AEEHR Custom Reporting

The most important ingredient to custom AE-EHR report recipes comes in the experience – specifically knowledge of the database schema. Knowing what tables to pull from, how tables are related, and what functions, stored procedures and existing custom reports can be utilized so as to not re-invent the wheel. Knowledge of advanced SQL querying is invaluable as well. If you would like to learn more, Galen is offering free EHR Reporting webcasts.

Let us know if we may assist your organization in developing and delivering custom AE-EHR reports. In addition to the reporting solutions store, we also offer training courses and reporting services for the Allscripts Enterprise EHR database, ETL database, Analytics and the ConnectR  database.  Please contact sales@galenhealthcare.com for more information regarding these courses and our reporting services.

« Previous Page