Can I build my own database queries in HYPEMedical's Billing Cycle utility?
An Introduction to The Billing Cycle.
In the Billing Cycle, Queries are built visually by the user. The Billing Cycle offers the user two query-building components. In the first component, the user visually creates a search using most of the possible billing parameters. The second component allows the user to design the query's display results from a wide selection of available report columns.
Intro. to Basic Claim Searches
There are two panels dedicated to creating a search query. The first includes built-in searches for the new user. This first panel consists of all the basic searches a user will likely require. We will explore the second panel in another KB article.
The most basic searches a new user requires are available with the three blue buttons on the top left of the first panel.
- Unsubmitted: a search for all claims ready to be submitted to OHIP.
- Submitted: a search for all the claims submitted to OHIP, patients and 3rd parties. These claims are outstanding.
- Rejected:
- Rejected [All]: a search for claims rejected by OHIP that need revising and resubmitting.
- Rejected [Error Report]: a search for claims rejected by OHIP via an Error Report.
- Rejected [RA]: a search for claims returned by OHIP via a Remittance Advice report.
Intro. to Selecting Report Columns
The bottom green band contains a selection of report columns. Columns can be chosen by check-marking columns across three tabs (Service, Claim and Patient Based).
The green button at the bottom left is a tool for creating shortcuts for each one of the user-defined column selections. A primary selection of columns is available for the new user.
The Billing Cycle's 'Report Columns'; The Second Component to Building a Query.
*Originally published August 8, 2020
Related Articles
Advanced Searches in HYPEMedical's Billing Cycle - A Visual Query Buillder
How do I find completed records of my billings including all studies read, payments, codes? The Advanced Search Options in Billing Cycle enable you to tailor your searches to your unique requirements. You can specify precise criteria in the “Popular” ...Is there a way to see all claims that were submitted in an Excel or PDF file?
Yes. HYPEMedical provides several reporting options depending on the information you need. While you can create a custom search in the Billing Cycle, the simplest way to generate a PDF report is from Claims \ MCEDT Files \ Batch Submissions. For ...Could I get instructions on how to get a report of all the out of province claims from April 2022- March 2023?
This question is a great example to demonstrate Billing Cycle's utility! Billing Cycle is HYPEMedical's billing search engine. Users can form searches using any claim parameter(s). OK. Let's look for all Out of Province claims (Claim type RMB as ...How can I find the claims that OHIP has rejected?
HYPEMedical automatically downloads and processes your OHIP reports. One of these reports, the Error Report, is automatically downloaded and processed by HYPEMedical. Processing the Error report flags claims with errors as Rejected Claims. To find ...What is the difference between a batch submission from Billing cycle vs. MCEDT files?
When you submit from Billing Cycle → Results, only the check-marked claims from your search results will be sent. This is useful when submitting a specific subset of claims. ------------------------------------------ To submit all unsubmitted claims, ...