Can I build my own database queries in HYPE Medical?

Can I build my own database queries in HYPE Medical?

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.


  1. Unsubmitted: a search for all claims ready to be submitted to OHIP.
  2. Submitted: a search for all the claims submitted to OHIP, patients and 3rd parties. These claims are outstanding.
  3. Rejected:
    1. Rejected [All]: a search for claims rejected by OHIP that need revising and resubmitting.
    2. Rejected [Error Report]: a search for claims rejected by OHIP via an Error Report.
    3. 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

    • How do I track a Claim through Hype Medical?

      The HYPEMedical`s Billing Cycle tracks claims through four status’s UNSUBMITTED claims that have been saved by the user SUBMITTED claims that have been submitted for payment by the user to OHIP [as well as individual patients, or private ...
    • 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 ...
    • How do I delete an OHIP Claim?

      I billed the wrong patient, how do I delete that OHIP claim if I have already created a newer OHIP claim with the right patient? In HYPEMedical, claim deletion is available in the three places where you would normally search for a claim: The Claim ...
    • Efficient Billing Cycle Search In Two Hospitals

      Periodically I need to search for my doctor’s past claims for a particular date period and hospital locations. What’s an efficient way to do that? Have a look at the image below at how I would perform that in a single search. Set up the search ...
    • Where can I find the claims I saved?

      How would I edit a claim I have just saved (Unsubmitted) or revise a Rejected claim? First step: go to Billing Cycle. Hover over Claims in the main menu and click on Billing Cycle. HYPEMedical will compile a list of Unsubmitted (Saved by the user) or ...