On Demand: Working Smarter: How We Automated MedAxcess Data Submission-Webinar Handouts

Webinar Handouts_1

Pdf Summary

This document contains three closely related SQL Reporting Workbench reports for MedAxiom CPT counts with modifiers. They were created for Quality and are intended to return HB and PB transaction details for validation, limited to a provider list supplied by the Quality Department.<br /><br />Core process used by all three reports:<br />- Define a date range using `PARAMETER_START_DATE` and `PARAMETER_END_DATE`.<br />- Load a provider list from a CSV file into a temp table, then match those NPIs to provider records.<br />- Load a location mapping CSV into another temp table.<br />- Use report parameters to optionally include PB and/or HB data.<br />- Pull PB transactions and HB transactions for the date range, using the selected providers.<br />- Split modifier strings into Modifier 1–4 for HB records.<br />- Assign CPT count logic based on positive/negative quantities, then summarize by account, provider, location, CPT code, and modifiers.<br /><br />The three report outputs differ:<br />1. MedAxiom CPT Count with Modifiers 1-Location  <br />   - Returns a location-level summary.<br />   - Combines PB and HB results and groups by location, location group, provider, CPT code, and modifiers.<br /><br />2. MedAxiom CPT Count with Modifiers 2-Hospital Account CPT Detail  <br />   - Returns detailed hospital account-level CPT data.<br />   - Includes billing system, account ID/name, provider, location, CPT code, modifiers, CPT count, and procedure quantity.<br /><br />3. MedAxiom CPT Count with Modifiers 3-Submission  <br />   - Returns a submission-oriented summary.<br />   - Aggregates by provider, NPI, location group, CPT code, and modifiers.<br />   - Excludes rows where the location group is “Exclude.”<br /><br />Overall, the SQL is designed to produce filtered, modifier-based CPT summaries from both PB and HB transaction sources, using provider and location lookup files to constrain and classify the results.

Keywords

SQL Reporting Workbench

MedAxiom

CPT counts

modifiers

HB transactions

PB transactions

provider list

location mapping

hospital account detail

submission summary