Custom Queries - Admin

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.


CPT® copyright 2019 American Medical Association. All rights reserved.

 


    • Related Articles

    • Custom Encounter Query (CEQ) Report

      The CEQ is a custom report/query tool that queries Encounter Data. Reports > Custom Encounter Query Build a Custom Encounter Query Filter Criteria: Add your filter criteria by clicking the Plus symbol beside "And". The filters you choose will ...

    • Admin Dashboard

      This screen contains Administrative functions which by default only Admin Users have permissions. Setup Panel Default Buttons System Settings Statement Profiles User Maintenance (Security) Clearinghouse Payer List Custom Fields Job Scheduler Custom ...

    • Admin Query Report

      The Admin Query Report functions are for Administrators to track specific User information. Admin Functions Access Log List of Users that have accessed the Database User Date & Time the Database was accessed IP Address Database number Who Is Logged ...

    • Custom Receipt Query (CRQ)

      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. Received Date vs Posted Date Example: Date Range: Run by Received Date ...

    • 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 set up the same. Transaction Query Report Criteria Reports > Custom Transaction Query (CTQ) Totals By: Choose how ...