The Acmeware Advisor.

Our blog is your source for timely information on MEDITECH Data Repository, SQL Server and business intelligence, quality reporting, healthcare regulatory issues, and more.

Contact us
500 characters left

Electronic Case Reporting

Electronic Case Reporting (eCR) enables automatic, real-time exchange of case information with Public Health Agencies (PHAs).

When data is recorded in the EHR, it is checked against a trigger table to determine whether there is a reportable condition — and if so, an electronic Initial Case Report (eICR) is sent to the PHAs.

Case Study: Power BI at NVRH


hospital logo

Power BI is the latest enterprise business intelligence platform from Microsoft. With Power BI's beautiful and dynamic data visualization tools, unlock the informatics potential of MEDITECH Data Repository in ways not before possible. To learn more, read our case study from Northeastern Vermont Regional Hospital, who use Power BI with their MEDITECH Expanse system.
Power BI blog

Connecting to DR with Power BI

In our first Power BI blog, we introduced the Power BI platform and reviewed the desktop applications and cloud-based tools we can use to develop and share reports and dashboards. In this blog, we’ll look more specifically at the ins and outs of using Power BI with MEDITECH Data Repository.

Power BI blog

Microsoft Power BI and DR

MEDITECH’s Data Repository has come a long way since its inception over twenty years ago. In the early days of DR, usable front-end reporting tools were few and far between: Microsoft Access and Crystal Reports were common choices for many hospitals. Fast forward to 2021 however, and DR is an integral part of the MEDITECH EHR and report developers have a variety of tools to use: the ubiquitous SQL Server Reporting Services (SSRS) from Microsoft; MEDITECH’s BCA with MicroStrategy; and third-party software like Tableau and Qlik, among others.

2022 IPPS Final Rule

CMS recently published the FY 2022 Inpatient Prospective Payment System (IPPS) Final Rule which includes several proposed changes to the Hospital Inpatient Quality Reporting (IQR) Program and Medicare Promoting Interoperability Program for eligible hospitals and critical access hospitals (CAHs). For the full text of the rule, see the Federal Register.

2022 QPP Proposed Rule

CMS recently published the CY 2022 Quality Payment Program (QPP) proposed rules which include many changes to the Merit Based Incentive Payment System (MIPS) for 2022 and subsequent reporting years. The full text of the rule can be viewed on the Federal Register.

SQL Server database

SQL Server User-defined Functions II

In part 1 of this blog, we covered at a high level the basics of T-SQL user defined functions. In part 2 we’ll explore the advantages of leveraging functions, and when to do so.

SQL Server database

Why SourceID is Important in DR

I recently had a student from one of our online training sessions email me a few days after class, asking why I recommend always using the SourceID column as part of every TSQL join. They sent two queries to demonstrate why they felt they shouldn’t use SourceID.

2022 IPPS Proposed Rule

CMS recently published the FY 2022 Inpatient Prospective Payment System (IPPS) Proposed Rule which includes several proposed changes to the Hospital Inpatient Quality Reporting (IQR) Program and Medicare Promoting Interoperability Program for eligible hospitals and critical access hospitals (CAHs). For the full text of the rule, see the Federal Register.

SQL Server database

SQL Server User-defined Functions

So, in plain English, what is a T-SQL user-defined function? A function is a SQL query saved as a database object, which leverages and outputs data to serve a focused purpose. Once a function is created it easily can be utilized at any time by anyone with proper access. Measured creation and execution of functions will greatly streamline data production from your T-SQL environment, allowing technology to do what it’s supposed to - make our lives easier! Let’s start with a simple example to better explain why we should be using functions and illustrate different types.

Case Study: Conversion to Expanse

  anderson hospital logo

 

Background

Anderson Healthcare has served the Illinois communities of Madison and Macoupin counties since 1977 and continues its commitment to providing residents with the highest quality of advanced medical care. A 154-bed inpatient hospital, critical access hospital, rehab institute, surgery center and outpatient acute care facility offer patients cutting-edge medical diagnostics that are not often found in a local community setting using the MEDITECH Expanse electronic health record platform.

Situation

The leadership at Anderson Healthcare committed to upgrading their MEDITECH EHR to the Expanse platform in 2018. Having been on Client/Server for nearly 20 years, they had created a large inventory of NPR and Data Repository SQL reports that would be affected by the new data architecture in Expanse. Early in the process, Anderson Hospital recognized that they did not employ the necessary resources to rewrite their comprehensive library of reports.

Assessment

Anderson Healthcare has been an Acmeware Partnership Program client since 2010, and a OneView Quality Reporting customer since 2013. When Anderson determined that they needed outside assistance to develop the new reports, they turned to their trusted partner Acmeware. Using OneTrac, their proprietary report inventory and project management tool to identify and prioritize the data objects that would need updating, Acmeware evaluated 2,619 reports and data objects for conversion to Expanse. During the prioritization process we determined that 152 reports could be retired with the remainder needing to be rewritten for Expanse. 

Results

Starting in January 2019 and working through December 2020, all the NPR and Data Repository reports and stored procedures were rewritten. While Acmeware was initially engaged to convert over 1,700 DR SQL stored procedures, another third-party resource was employed to convert the 858 NPR reports. By May of 2020, Anderson decided their NPR resource was not meeting their expectations and Acmeware was asked to finish the NPR report conversions. Acmeware’s expertise and catalog of existing reports resulted in fast and accurate deployment of the complete library of new reports ahead of the Expanse go-live and on budget.

 


mike ward 100x100

While we work with many vendors, Acmeware has come to be a true partner. Since 2013, they've been an integral part of our IS department through their Partnership Program. Their Data Repository expertise has been invaluable.

– Mike Ward, Anderson Hospital Chief of IT

Case Study: Data Repository Services

We are thrilled with our partnership with Acmeware. Data and analytics are key to our business and our ability to provide top quality healthcare to our communities. So many people rely on timely and accurate data, it is a foundational part of our Information Technology infrastructure.