Custom Queries - Admin
Custom Queries - Admin
These are custom SQL queries that are written for clients to extract specific information to meet specific needs. There may be a charge for the creation of the Custom Query and will be presented to the client before starting the report.
Admin > Custom Queries
Reasons that a client requests a Custom Query:
The client cannot get the data through a standard System delivered report; or
A report that contains the data they need, but it contains too much data.
Adjustment Audit
The Admin Custom Query can be used to audit Adjustments on all CPTs® that have written off by a CO Adjustment Code.
From Admin on the Left Side Menu, select Custom Queries, Admin Dashboard and Custom Query
From the list, find Audit Adjustments.
Select Run on the right.
The addition of the Custom Query Reports on the Report screen have eliminated most of the need for Custom Queries. There are 5 System delivered Custom Query Reports.
Custom Encounter Query (CEQ)
Custom Receipt Query (CRQ)
Custom Transaction Query (CTQ)
Custom Patient Query (CPQ)
Custom Appointment Query (CAQ)
CPT® copyright 2019 American Medical Association. All rights reserved.
Related Articles
Custom Query Reports Hub
Custom Query Reports (CQR) Custom Encounter Query = CEQ Custom Receipt Query = CRQ Custom Transaction Query = CTQ Custom Patient Query = CPQ Custom Appointment Query = CAQ Overview Filters and Criteria Create a CQR CEQ CRQ CTQ CPQ CAQ Overview Custom ...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 Filter Criteria: Add your filter criteria ...Custom Query Reports Overview
Custom Query Reports Overview Custom Query Reports can be custom-built to produce the output and columns you want specifically. A Default Report is System delivered for each Custom Query Report. They all operate in the same way but pull specific ...Custom Appointment Query (CAQ)
Custom Appointment Query (CAQ) The Custom Appointment Query (CAQ) report can be customized to query Appointment information. This report can be used for: A Scheduling List for the day, which gives more detail than the Appointment List Report; and 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: ...