781.329.4300 ¦ 
Main Menu
About Us
The Hub
- Advisor
- Quality
- Electronic Case Reporting
- 2023 IPPS Proposed Rule
- 2023 QPP Proposed Rule
- 2023 OPPS Proposed Rule
- 2023 IPPS Final Rule
- 2023 IPF PPS Final Rule
- 2022 Quality Reporting Requirements for Inpatient Psychiatric Facilities
- SAFER Guides-Contingency Planning
- 2023 QPP Final Rule
- 2023 OPPS Final Rule
- New Requirements to Reduce Health Care Disparities
- Palliative Care vs. Hospice Care
- 2024 IPF PPS Proposed Rule
- 2024 IPPS Proposed Rule
- 2024 OPPS Proposed Rule
- 2024 QPP Proposed Rule
- 2024 IPF PPS Final Rule
- 2024 IPPS Final Rule
- The Importance of Mapping for Quality
- 2024 QPP Final Rule
- 2024 OPPS Final Rule
- Navigating Antimicrobial Use and Resistance Reporting
- Data Repository
- Power BI
- Data Repository System Tables
- Clean TSQL Formatting
- Accessing Data Across SQL Servers
- Where's the Data?
- Primary Keys in Data Repository
- Management Studio Shortcuts
- When to Build a Data Mart
- Multi-value Parameters in SQL Server Reporting Services
- Why Data Repository is Different
- Using URLs in SQL Server Reporting Services
- Using URLs in SQL Server Reporting Services - Part 2
- Optimal DR tempdb configuration
- SQL Server User-defined Functions
- Why SourceID is Important in DR
- SQL Server User-defined Functions II
- Report and Data Validation
- So You Want a Barcode...
- The Importance of DR Maintenance
- Working with Precision in T-SQL
- Nonclustered Indexes in Data Repository
- General
- Case study
- Archive
- 2019 IPPS Final Rule
- 2019 MIPS Final Rule
- 2019 IPPS Proposed Rule
- 2018 MIPS Overview
- 2019 Promoting Interoperability
- 2020 IPPS Proposed Rule
- 2020 IPPS Final Rule
- 2020 MIPS Final Rule
- 2021 IPPS Proposed Rule
- 2021 IPPS Final Rule
- 2021 QPP Proposed Rule
- 2021 QPP Final Rule
- 2022 IPPS Proposed Rule
- 2022 QPP Proposed Rule
- 2022 IPPS Final Rule
- Quality
- DR Network
- SSRS report
- Patient Account Financial Summary
- Average Census by Hour
- Inpatient Readmissions
- Patient Account Charges by Category
- Medication Administrations by Patient Account
- Census by Location
- Payment Summary by Insurance
- Current Inpatient Medication Administrations by Location
- Charge Summary by Department and Category
- Current Inpatients with Last Visit
- Lab Results by Patient Account
- Lab Results for Current Inpatients
- Bad Debt Accounts by Date
- Current Inpatients with Last Vital Signs
- Current Inpatient Orders by Provider
- Current Inpatient Orders
- Current Inpatients without Admit Order
- Census by Attending Provider
- Coded Allergies by Patient
- Allergies by Patient
- Charge Codes and Bills
- Current Inpatient IV Information
- All Patients with Home Medication
- Cancelled Appointments
- COVID-19 Dashboard
- Patient Dashboard
- Discharged Patients by Date
- Surgery Dashboard
- TSQL code
- Clinic and Hospital Matching Charges
- Parse Name (function)
- Convert CDS Response to DateTime (function)
- Proper Case (function)
- Convert MT Time to Datetime (function)
- Age in Years (function)
- Age in Years and Months (function)
- Age in Months and Days (function)
- Get end of day (function)
- Compare DR Schemas
- Patient Providers by Discharge Date
- Report Server Usage
- Find DR Dependencies
- Inpatient ADM Clinical Queries
- Age intervals (function)
- Search DR Metadata by Name
- RD and NPR
- DR Network
- SSRS report
- Events
- News
- Acmeware & Cloudwave Announce DR & SQL Support Services
- Acmeware Achieves 100% MIPS Submission Success
- eCQM Submission Success
- Acmeware Achieves 100% Submission Success
- Acmeware Launches Redesigned Website
- Acmeware Announces IT Staff Augmentation Services
- Acmeware Unveils Free COVID-19 Dashboard
- Acmeware Launches Live Online Training
- Acmeware Leads the Way in Data Analytics
- Acmeware Announces Downtime Defender
- Security Announcement: Log4j Vulnerability
- Positioned for Success in 2023
- Acmeware President Announces Retirement Plans
- Joel Benware Named President of Acmeware
- Empower by Acmeware Revolutionizes Healthcare Data Analytics
- Power BI alias