Custom Encounter Query (CEQ)

Custom Encounter Query (CEQ)

The CEQ is a Custom Query that queries Encounter Data.
  • Access the CEQ Report by selecting Reports on the left side menu.
  • Select Custom Encounter Query in the Transactions panel.

Build a Custom Encounter Query

  1. Filter Criteria: Add your filter criteria by selecting the Plus symbol beside "And". 
  • The filters you choose will determine the specific parameters to obtain the desired query results.
  • Example: A specific Encounter Date Range for a specific Provider.

  1. Add Columns to the Report by clicking the Columns button.
  • Use the Search Field to find a specific item, or expand the sections using the Plus symbol.

  1. Use the check boxes to choose the items to use as Columns on the report.
  2. In the Selected Columns panel, deselect any items that are not needed as Columns.
  3. As you select columns, they will show in the Reorder Columns pane.  Click and drag the columns to reorder how they will show on the report (the top column will be the furthest left column in the report).
  4. Select Save (F2).
  5. Select the Run button. 


Date Range

Use Greater Than and Less Than with a DOS filter to create a Date Range.

  • Example: Use Less than or equal to and Greater than or equal to with the Procedure - DOS filter to create a date range from 01/01/2018 through 11/10/2021.
  • The start and end dates are included in the date range.


Total-By

Total-By Options: The Totals By will display as 1 row per entity showing totals for each column for that entity.

Count Column

This uses the same logic used in other reports to report the number of Encounters that have taken place during the reporting period (Service Facility Visits).

  • Each Visit/Encounter = 1
  • 'Reversed' Encounter = 1 
  • Created as a clone to replace the Encounter in the original period.
  • 'Reversal' Encounter = -1 
  • This is the Offset (negative values) mirror image of the Encounter that was Reversed.
  • Encounter that has no charge lines = 0
  • Encounter that was created by 'rolling up' other encounters = 0
  • The Reversal = -1 and the New Encounter = 1, so they net to 0 new Encounters.


Where to Find Most Recently Used

  • Policy Panel
  • Claim Status
  • Insurances (1-4)
  • Policy Numbers
  • Encounter Panel
  • UB/Institutional Claims: Is Institutional
  • Count (Encounter): Count
  • First Billed - Date
  • Is Incomplete
  • Is Reversed
  • Is Self Pay
  • Most Recent Statement
  • Tags
  • Procedure Panel
  • Procedure Code (CPT): CPT - ID
  • Diagnosis Codes (ICD-10): Diagnosis 1, etc.
  • DOS
  • Fee
  • NDC: NDC - Number
  • Transaction Panel
  • Adjustments
  • Allowed
  • Charges
  • Copay
  • Insurance Payments
  • Patient Payments
  • Write-Offs
  • Balance Panel
  • Collection
  • Insurance
  • Insurance by aging categories
  • Patient
  • Patient by aging categories
  • Total


Build a Self-Pay Patient Report using the CEQ

  1. Select the Plus button before "AND".
  2. Select Insurance (1) - ID.



  1. For Policy - Insurance(1) - ID, select Equals.
  2. Enter the word, Patient, in the Lookup field.
  3. Select the Run button after all other criteria have been chosen.



Use the CEQ to Query Custom Fields

The Custom Encounter Query can be used to query Custom Fields from the following screens:

  • Patient Registration
  • Modify Patient
  • Add/Modify Employer (Employer/Attorney Library)
  • Add/Modify Note
  • Add/Modify Policy (Insurance Management)
  • Add/Modify Insurance (Insurance Library)
  • Post Charge
  • Add/Modify Diagnosis Code (ICD Code Library)
  • Add/Modify Procedure Code (Procedure Code Library)
  • Add/Modify Case
  • Add/Modify Billing/Rendering/Supervising Provider (Billing/Rendering/Supervising Provider Library)
  • Add/Modify Referring Provider (Referring Provider Library)
  • Add/Modify Service Facility (Service Facility Library)
  • Modify Pay To Location (Pay To/Billing Location Library)

Learn More

Create a Custom Query Report

Custom Query Report/Table Filters and Criteria

Create a Job to Run a Custom Query Report

Custom Fields Overview

    • Related Articles

    • Custom Receipt Query (CRQ)

      The Custom Receipt Query is driven by entered/posted Receipts. This report will match the Receipt Management report if it is run by the same parameters: Total By - Receipt - Number Receipt - Is Registered Type = Yes Post Date Range Reports > ...
    • Custom Patient Query (CPQ)

      Custom Patient Query (CPQ) The Custom Patient Query report is located in the Patient panel on the Reports screen and is built by the User. The content of this report is Patient related. For instructions on building a Custom Query Report, see Create a ...
    • Custom Transaction Query (CTQ)

      The Transaction Query Report is driven by the Posted Transactions. This Report will match the Payments & Adjustments Report if they are run by the same parameters. Transaction Query Report Criteria Reports > Custom Transaction Query (CTQ) Totals By: ...
    • Self Pay Profile

      Self-Pay Profile The Guarantor is the Responsible Party for all balances that are in the status of Patient Responsibility. The System defaults to Self Pay when there is no Insurance Profile. The Self-Pay Profile is System delivered, which makes it ...
    • Encounter By Status List

      The Encounters by Status List can be run multiple ways. It can be used to change the Status of multiple Encounters in one step and to send Encounters to a Worklist. Claims > Claims Management Dashboard. Select the Encounters by Status Link. Use the ...