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

Case Study: Data Integration

novant uva logo 

 

Background

Novant Health UVA Health System Culpeper Medical Center serves the greater Culpeper, Virginia community and surrounding areas. The campus in is home to a 70-bed, community hospital, Family Birth Center and 24/7 emergency department, and is complemented by additional outpatient services in other northern VA towns, as well as the Novant Health UVA Health System Haymarket Medical Center. Culpeper Medical Center is a longtime MEDITECH MAGIC customer.

Situation

 Culpeper Medical Center sought to increase operational efficiency, reduce operating costs, and enhance comparison reporting with other hospitals in the Novant system (which use Epic) by targeting financial and clinical data to be compared across disparate EHR’s. The goal was to accomplish this through the development and automation of data export packages.

Assessment

Culpeper has been an Acmeware Partnership Program client since 2004, and a OneView Hospital Quality Reporting customer since 2017. When Culpeper determined they needed outside assistance to develop the desired data export packages and logic, they turned to Acmeware who evaluated the various data integration specifications and facility’s needs from a data compatibility perspective.

Results

Acmeware built several data export projects, extracting data from Culpeper’s Magic 5.67 system to feed a range of financial and clinical vendor systems. Wherever possible, data movement packages were automated for improve client workflow. The projects include:

  • Syntellis: Axiom (BAR Reconciliation/Cost Accounting)
  • Syntellis: Kauffman (AP/GL Reconciliation) AOIC (Integration for Radiology)
  • Vizient (clinical data)
  • NRC Health (custom survey)
  • Periodic reporting to HHS

The data export projects are running smoothly as Acmeware continues to assess and refine them for optimal efficiency. Culpeper continues to leverage their investment in the MEDITECH system to automate and achieve greater efficiencies from integration with third-party vendor systems.



2021 QPP Final Rule

CMS recently published the CY 2021 Quality Payment Program (QPP) Final Rule which included numerous updates to the Merit-based Incentive Payment System (MIPS) for 2020 reporting and subsequent reporting years, with a focus on 2021 reporting. For the full text of the rule, see the Federal Register.

SQL Server database

Optimal DR tempdb configuration

MEDITECH's Data Repository best practices recommend a dedicated drive for tempdb data files, that the space allocated to this drive be 25-30% of total data space for the SQL Instance, and that the allocated space be split between eight data files and one log file. Is it possible to modify tempdb to meet these standards? Read on to learn how.

2021 QPP Proposed Rule

CMS recently published the CY 2021 Quality Payment Program (QPP) Proposed Rule which included numerous updates to the Merit-based Incentive Payment System (MIPS) for 2020 reporting and subsequent reporting years, with a focus on 2021 reporting. For the full text of the rule, see the Federal Register.

2021 IPPS Final Rule

CMS recently published the FY 2021 final rule for the Inpatient Prospective Payment Systems (IPPS) and has finalized changes to the Hospital Inpatient Quality Reporting (IQR) program and Medicare & Medicaid Promoting Interoperability (PI) program for eligible hospitals and critical access hospitals. For the full text of the rule, see the Federal Register.

SQL Server database

Using URLs in SQL Server Reporting Services - Part 2

In part 1 of this blog, we discussed how to build a URL that could navigate to various resources on the internet. We learned how to build the URL string based on a combination of the website path and the data within our results. In part 2, we’ll look at a similar example of how to navigate to another SSRS report on our local network that resides in a different project folder. Using the same technique, we can build the navigation link and pass parameters into another report instead of using the default SSRS method which only links to reports in the same folder.

SQL Server database

Using URLs in SQL Server Reporting Services

Part 1 - Navigating to an Internet site

One of the most obvious features of SQL Server Reporting Services is that the reports are presented to the user with a web browser. This means that SSRS natively has access to many of the same functional principles as most web pages and web sites. Specifically, this would include the use of hyperlinks (URLs) to easily navigate to other reports, web pages, or other web-based resources. How do we do that? With the Action property.

2021 IPPS Proposed Rule

CMS recently published the FY 2021 proposed rule for the Inpatient Prospective Payment Systems (IPPS) and has proposed changes to the Hospital Inpatient Quality Reporting (IQR) program and Medicare & Medicaid Promoting Interoperability (PI) program for eligible hospitals and critical access hospitals. For the full text of the rule, see the Federal Register.

Know Your Data

It doesn’t matter which MEDITECH version you have; from MAGIC to Expanse, each reporting technology has its own strengths and weaknesses. Whether it’s good old NPR, Report Designer or Data Repository with SQL Server, you can get the most out of each of them by using them together. While Data Repository has increasingly become the “go-to” choice for many reports, DR and SQL tools can also be used as an intermediary tool to help you build better NPR and RD reports too!

SQL Server database

Why Data Repository is Different

Technically speaking, MEDITECH's Data Repository is a typical relational database, in that it stores data in tables, uses primary key columns for referential integrity, and is interacted with using off-the-shelf tools like Microsoft SQL Server Management Studio. But there are several aspects that make it unique – and challenging to work with – all of which are important to understand if you’re a data analyst or report writer at a MEDITECH hospital.

2020 MIPS Final Rule

CMS recently published the CY 2020 Quality Payment Program (QPP) Final Rule which included numerous updates to the Merit-based Incentive Payment System (MIPS) for 2019, 2020 and 2021 reporting.

SQL Server database

Multi-value Parameters in SQL Server Reporting Services

One of my favorite features of SQL Server Reporting Services is the ability to provide a parameter with multiple values. This is a great way to give your users flexibility at runtime by allowing them to select one, two, several, or all values from a given list. It even has a built-in way to easily select and de-select all the possible values. A common scenario that would benefit from this is when you are going to publish a single report that could potentially be used by multiple locations or departments.