Features about Data Repository, Quality Reporting and more

Multi-value Parameters in SQL Server Reporting Services

Howard Minor Data Repository November 15, 2019

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.

Data Repository System Tables

Taylor Solari Data Repository September 13, 2019

How do I find data in the MEDITECH Data Repository? Fortunately, the system contains valuable metadata to help find the tables and columns you need. Read on, or click below to see it on YouTube!

Primary Keys in Data Repository

Ian Proffer Data Repository August 29, 2019

Knowing which tables to use is one of the biggest challenges when writing DR reports. Understanding those tables, and the relationships between them is part of that challenge. Primary keys are a critical part of any database, but especially so in the DR, since they are the only definition we have for how to correctly and quickly get information.

2020 IPPS Final Rule

Alexis O'Grady Regulatory August 6, 2019

CMS recently released the FY 2020 Inpatient Prospective Payment Systems (IPPS) Final Rule which continues to focus on transforming the healthcare delivery system to provide patients with better care. To this end, CMS 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 (CAHs). (For the full text of the final rule, see the Federal Register.)

When to Build a Data Mart

Ian Proffer Data Repository July 31, 2019

As report writers and analysts, we sometimes have to ask: how do I go about optimizing data retrieval from the MEDITECH Data Repository? When is it appropriate to construct a data mart and what should I consider? Before we explore the answer, let's first, define a few terms (thanks to Technopedia and Wikipedia):

Management Studio Shortcuts

Ian Proffer Data Repository June 3, 2019

Whether you’re GPSing around traffic, going through a drive-thru, or using ALT+TAB to switch between open windows, life demands shortcuts. You know the adage – work smarter, not harder. Working with SQL Server is no different - if you’re a busy developer or DBA, you likely spend part of your day writing TSQL code in Management Studio. Fortunately, Microsoft has built in features we can use to make our jobs a bit easier. Here are a few recommended shortcuts and other tips to help save you time and keystrokes.

2020 IPPS Proposed Rule

Alexis O'Grady Regulatory May 17, 2019

CMS recently published the FY 2020 proposed rule for the Inpatient Prospective Payment Systems (IPPS) which continue to focus on transforming the healthcare delivery system to provide patients with better care. To this end, CMS 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 (CAHs). (For the full text of the rule, see the Federal Register.)