781.329.4300 ¦ 
Main Menu
About Us
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
- 2022 IPPS Proposed Rule
- 2022 QPP Proposed Rule
- 2022 IPPS 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
- SQL Server User-defined Functions
- Why SourceID is Important in DR
- SQL Server User-defined Functions - part 2
- Microsoft Power BI and DR
- Connecting to DR with Power BI
- General
- Regulatory
- 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
- 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
- Power BI
Professional Services
- Custom reporting
- Data integration
- DR support
- Expanse migration
- EHR conversion
- MEDITECH SQL reports
- Partnership program
- Staff augmentation