Main Menu

• Home
• COVID-19
• Services
• Solutions
• The Hub
• Education
• About
• Contact

About Us

• How we work
• Our story
• Our team
• Careers

The Hub

• Blog
  • Regulatory
    • 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
  • Data Repository
    • 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
    • Moving SQL Server Database Files
  • General
    • The Value of Validating eCQM Data
    • Know Your Data
• 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
  • 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
  • RD and NPR
    • Patient Wristband
    • NPR Report List (MAGIC)
    • NPR Report List (CS)
  • DR Network
• Events
  • OneView Q Series
  • Training
    • DR201: Intermediate T-SQL
    • DR101: Reporting Fundamentals
• News
  • Acmeware & Cloudwave Announce DR & SQL Support Services
  • Acmeware Achieves 100% MIPS Submission Success
  • Acmeware Partners with Diagnotes for MEDITECH Integration
  • 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

Professional Services

• Custom reporting
• Expanse migration
• Data integration
• DR support
• EHR conversion
• MEDITECH SQL Reports
• Partnership program
• Staff augmentation

Solutions

• OneView
  • Hospital quality
  • Chart abstracted measures
  • MIPS
• OneTrac
• Custom applications

Contact us

• Contact form
• Message confirmation

Education

• Live online classes
• In-person classes
• Training videos
• MUSE Conference

General

• Privacy policy
• Sitemap
• Terms of use
• Eligible Hospital Supported Measures
• Eligible Clinician Supported Measure

COVID-19

• COVID-19 Support