The Acmeware Blog

Regulatory updates, Data Repository best practices, and healthcare IT insights from the team that built it.

Understanding the MIPS Complex Patient Bonus

The MIPS Complex Patient Bonus awards up to 10 points based on medical complexity (HCC scores) and social risk (dual eligibility ratio).

Read

Optimize Your MIPS Cost Category Score

The MIPS Cost category accounts for 30% of your score in 2024. Learn strategies to optimize performance across 29 cost measures.

Read

All Articles

Why SourceID is Important in DR

June 25, 2021

Including SourceID in every DR join enables efficient Clustered Index Seeks instead of slow full-table scans on realistic queries.

Read

SQL Server User-Defined Functions

April 26, 2021

User-defined functions in SQL Server let you create reusable logic for common calculations like patient age and clinical time intervals.

Read

Optimal DR tempdb Configuration

January 7, 2021

Follow MEDITECH best practices to configure tempdb with dedicated storage, eight data files, and proper sizing for optimal DR performance.

Read

Using URLs in SQL Server Reporting Services - Part 2

July 7, 2020

Use URL-based navigation to connect SSRS reports across different project folders by constructing parameterized links in T-SQL.

Read

Using URLs in SQL Server Reporting Services

June 5, 2020

Use the Action property in SQL Server Reporting Services to build dynamic URL-based navigation from report data to external websites.

Read

Multi-value Parameters in SQL Server Reporting Services

November 15, 2019

A step-by-step guide to implementing multi-value dropdown parameters in SSRS using a table-valued function and stored procedures.

Read

Primary Keys in Data Repository

August 29, 2019

Primary keys define table uniqueness and parent-child relationships in DR, making them essential for correct and efficient SQL joins.

Read

Why Data Repository is Different

March 2, 2020

Data Repository differs from typical SQL databases in collation, normalization, schema stability, and sheer complexity of healthcare data.

Read

When to Build a Data Mart

July 31, 2019

Data marts improve report performance by separating complex, frequently-refreshed datasets from the live Data Repository.

Read

Management Studio Shortcuts

June 3, 2019

Boost your SQL Server Management Studio productivity with custom query shortcuts, block select editing, and essential keyboard commands.

Read

Where's the Data?

May 3, 2019

An introductory guide to how MEDITECH organizes clinical and financial data in the Data Repository for new report writers.

Read

Accessing Data Across SQL Servers

March 12, 2019

Learn how to set up Linked Servers and handle collation differences to combine MEDITECH DR data with third-party SQL databases.

Read

Clean TSQL Formatting

December 21, 2018

Clean T-SQL formatting improves readability, speeds debugging, boosts productivity, and enables more advanced report development.

Read

The Value of Validating eCQM Data

November 13, 2018

Continuous eCQM data validation prevents submission errors, catches mapping issues early, and prepares your facility for CMS audits.

Read

The Importance of Mapping for Quality

November 8, 2023

Incorrect MEDITECH data mapping can silently reduce your eCQM scores. Learn how to validate mapping annually to protect quality performance.

Read

2027 IPF PPS Final Rule

April 28, 2026

CMS published proposed changes to the Inpatient Psychiatric Facility Quality Reporting program, including measure removals and a new patient assessment instrument.

Read

Quality

2022 Quality Reporting Requirements for Inpatient Psychiatric Facilities

September 12, 2022

A comprehensive guide to CY 2022 IPFQR chart-abstracted measures, claims-based measures, and Joint Commission reporting requirements.

Read

2023 IPF PPS Final Rule

September 1, 2022

CMS finalized a 2.5% IPF payment increase with no changes to the IPFQR Program and solicited feedback on health equity disparities.

Read

2023 IPPS Final Rule

August 10, 2022

CMS finalized ten new IQR measures, expanded eCQM requirements, and restructured PI scoring in the FY 2023 IPPS Final Rule.

Read

2023 OPPS Proposed Rule

July 26, 2022

CMS proposed keeping OP-31 voluntary, aligning chart-abstracted measure timing with calendar years, and new validation targeting criteria.

Read

2023 QPP Proposed Rule

July 20, 2022

CMS proposed five new MVPs, a 75-point threshold, nine new quality measures, and PI changes including required PDMP query for the 2023 QPP.

Read

2023 IPPS Proposed Rule

June 6, 2022

CMS proposed ten new IQR measures, increased eCQM requirements, and significant PI scoring changes in the FY 2023 IPPS Proposed Rule.

Read

Electronic Case Reporting

February 9, 2022

Electronic Case Reporting automates real-time sharing of reportable condition data between EHR systems and public health agencies.

Read

The Importance of Mapping for Quality

November 8, 2023

Incorrect MEDITECH data mapping can silently reduce your eCQM scores. Learn how to validate mapping annually to protect quality performance.

Read

2027 IPF PPS Final Rule

April 28, 2026

CMS published proposed changes to the Inpatient Psychiatric Facility Quality Reporting program, including measure removals and a new patient assessment instrument.

Read

Data Repository

The Importance of Data Governance

August 26, 2024

Healthcare data governance establishes policies for data quality, security, and consistent use that support better clinical and strategic decisions.

Read

EHR Downtime Insights

April 1, 2024

MEDITECH community survey data reveals that 32% of hospitals experienced 12+ hour downtimes, underscoring the need for robust preparedness.

Read

Why Power BI is the Best Reporting Platform for DR - Part 2

March 7, 2024

Part 2 explores how Power BI's cached data model and dynamic visualizations deliver a superior end-user analytics experience over SSRS.

Read

Why Power BI is the Best Reporting Platform for DR

January 17, 2024

Part 1 of a two-part series examining why Power BI outperforms SQL Server Reporting Services for MEDITECH Data Repository analytics.

Read

Nonclustered Indexes in Data Repository

July 19, 2023

A practical guide to creating nonclustered indexes in Data Repository, including when they help, what to index, and advanced strategies.

Read

Data Models in Power BI

March 15, 2023

Data models are foundational to Power BI report development. This article explores star schemas, rowset-based models, and snowflake schemas.

Read

Working with Precision in T-SQL

November 3, 2022

Understand the ROUND function, float vs. decimal data types, and truncation behavior to write accurate numeric calculations in T-SQL.

Read

The Importance of DR Maintenance

September 14, 2022

Regular DR maintenance including transfer monitoring, error review, storage management, and index defragmentation prevents data accuracy issues.

Read

So You Want a Barcode

April 25, 2022

Install free barcode fonts and apply them in SSRS or Power BI Report Builder to add scannable barcodes to any Data Repository report.

Read

Report and Data Validation

March 4, 2022

A validation checklist for Data Repository reports covering data accuracy, source comparison, and file export verification.

Read

Connecting to DR with Power BI

November 29, 2021

Learn how to connect Power BI to MEDITECH Data Repository using Import and DirectQuery modes while building effective data models.

Read

Microsoft Power BI and DR

September 29, 2021

Power BI brings modern analytics to MEDITECH Data Repository, connecting multiple data sources into interactive dashboards and reports.

Read

SQL Server User-Defined Functions II

July 26, 2021

Table-valued functions centralize complex multi-table logic so teams can write standardized, maintainable DR code across the organization.

Read

Data Repository System Tables

June 28, 2021

MEDITECH's DR system tables map application data to SQL columns, helping report writers quickly find the right tables and fields.

Read

Why SourceID is Important in DR

June 25, 2021

Including SourceID in every DR join enables efficient Clustered Index Seeks instead of slow full-table scans on realistic queries.

Read

SQL Server User-Defined Functions

April 26, 2021

User-defined functions in SQL Server let you create reusable logic for common calculations like patient age and clinical time intervals.

Read

Optimal DR tempdb Configuration

January 7, 2021

Follow MEDITECH best practices to configure tempdb with dedicated storage, eight data files, and proper sizing for optimal DR performance.

Read

Using URLs in SQL Server Reporting Services - Part 2

July 7, 2020

Use URL-based navigation to connect SSRS reports across different project folders by constructing parameterized links in T-SQL.

Read

Using URLs in SQL Server Reporting Services

June 5, 2020

Use the Action property in SQL Server Reporting Services to build dynamic URL-based navigation from report data to external websites.

Read

Why Data Repository is Different

March 2, 2020

Data Repository differs from typical SQL databases in collation, normalization, schema stability, and sheer complexity of healthcare data.

Read

Multi-value Parameters in SQL Server Reporting Services

November 15, 2019

A step-by-step guide to implementing multi-value dropdown parameters in SSRS using a table-valued function and stored procedures.

Read

Primary Keys in Data Repository

August 29, 2019

Primary keys define table uniqueness and parent-child relationships in DR, making them essential for correct and efficient SQL joins.

Read

When to Build a Data Mart

July 31, 2019

Data marts improve report performance by separating complex, frequently-refreshed datasets from the live Data Repository.

Read

Management Studio Shortcuts

June 3, 2019

Boost your SQL Server Management Studio productivity with custom query shortcuts, block select editing, and essential keyboard commands.

Read

Where's the Data?

May 3, 2019

An introductory guide to how MEDITECH organizes clinical and financial data in the Data Repository for new report writers.

Read

Thought Leadership

MUSE Views Podcast

May 10, 2024

Acmeware President Joel Benware discusses the Empower platform, AI-driven analytics, and Downtime Defender on the MUSE Views podcast.

Read

External Links in MEDITECH

July 13, 2023

External Links in MEDITECH let users launch web-based reports, Power BI dashboards, and intranet resources directly from application menus.

Read

Emergency Preparedness in Healthcare

May 4, 2023

A structured six-phase approach to EHR downtime planning that keeps clinical data accessible and patient care safe during outages.

Read

Know Your Data

May 13, 2020

Data Repository and SQL Server tools help you visualize MEDITECH data, build better NPR and RD reports, and train new analysts faster.

Read

The Value of Validating eCQM Data

November 13, 2018

Continuous eCQM data validation prevents submission errors, catches mapping issues early, and prepares your facility for CMS audits.

Read

Blog

01.

Industry trends, regulatory updates, and expert perspective on the MEDITECH ecosystem.

Articles

Company News & Events

02.

Product launches, partnerships, and what's happening at Acmeware.

Articles