The Acmeware Advisor.

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
SQL Server database

Accessing Data Across SQL Servers

Not only is it possible to access DR data across SQL servers, but it’s also possible to combine data from different sources in the same query. If there is such a thing as the holy grail of DR reporting, this may be it. Not only is it possible to access data across SQL servers, but it’s also possible to combine data from different sources in the same query. Normally this is straightforward, but the DR adds an extra challenge because of an atypical server-wide setting: the server collation.

2019 MIPS Final Rule

In mid-November, CMS published the CY 2019 Quality Payment Program (QPP) Final Rule which included numerous updates to the Merit-based Incentive Payment System (MIPS) for Year 3 of the QPP (2019 Reporting).

SQL Server database

Clean TSQL Formatting

When we first learn to program in any language, our primary concern is usually learning how to get the thing to work. We care very little about how it looks, adding descriptive comments, or how to use proper spacing between your statements. As I was learning T-SQL and other programming languages, one of the things I never appreciated enough was the importance of clean syntax. How your code is physically laid out on the page is almost always an afterthought.  But it’s one of those small things that turns a good programmer into a great one!

The Value of Validating eCQM Data

How do I make certain the eCQM data I submit is accurate? In this article, we discuss why data validation is so important for eCQMs, and provide a few key tips.

2019 IPPS Final Rule

CMS published the FY 2019 Inpatient Prospective Payment System (IPPS) Final Rule which aims to achieve greater interoperability and reduce burden so that hospitals are better able to deliver high quality care. To this end, CMS has finalized changes to the Hospital Inpatient Quality Reporting (IQR) Program and Medicare & Medicaid EHR Incentive Programs for eligible hospitals and critical access hospitals (CAHs).

2019 Promoting Interoperability

CMS introduces a new scoring methodology for the Medicare Promoting Interoperability program for hospitals. Beginning in 2019, hospitals will be attesting to a smaller set of objectives and measures.

2019 IPPS Proposed Rule

CMS recently published the FY 2019 Inpatient Prospective Payment System (IPPS) Proposed Rule which aims to achieve greater interoperability and reduce burden so that hospitals are better able to deliver high quality care. To this end, CMS has proposed changes to the Hospital Inpatient Quality Reporting (IQR) Program and Medicare & Medicaid EHR Incentive Programs for eligible hospitals and critical access hospitals (CAH). For the complete text of the rule, see the Federal Register.

2018 MIPS Overview

What You Need to Know for Successful MIPS Reporting in 2018

In mid-November, CMS published the CY 2018 Quality Payment Program (QPP) Final Rule which included numerous updates to the Merit-based Incentive Payment System (MIPS) for Year 2 of the QPP (2018 Reporting). While there were also changes made to the other QPP track, Advanced Alternative Payment Models (APMs), this post will only cover MIPS.