Custom Transaction Query (CTQ)

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: Choose how you want the Report Totaled By. Posted Transactions - Line is the Default.


Match to the Payments and Adjustments Report using Totals By: Posted Transactions - Code

  • Add the Post Date range:
  • Posted Transactions - Post Date Greater Than or Equal To (Date).
  • Posted Transactions - Post Date Less Than or Equal To (Date).
  • Add Procedure Billable Equals Yes.
  • Add Posted Transactions - Significant Transactions Equals Yes.
  • Totals By: Posted Transaction - Detailed Code
  • Select Run.

Examples

Custom Transaction Query


Payments and Adjustments


Use the CTQ to Query Custom Fields

The Custom Transaction Query can be used to query Custom Fields that have been added to the following screens:

  • Post Charge
  • Add/Modify Receipt
  • Patient Registration
  • Modify Patient
  • Creating a Reference Batch
  • Add/Modify Employer (Employer/Attorney Library)
  • Add/Modify Note
  • Add/Modify Procedure Code (Procedure Code Library)
  • Add/Modify Policy (Insurance Management)
  • Add/Modify Insurance (Insurance Library)
  • Add/Modify Service Facility (Service Facility Library)
  • Add/Modify Billing/Rendering Provider (Billing/Rendering Provider Library)
  • Add/Modify Referring Provider (Referring Provider Library)

Learn More

Custom Query Reports Overview

Custom Query Report/Table Filters and Criteria

Create a Custom Query Report

Custom Encounter Query (CEQ)

Custom Patient Query (CPQ)

Custom Receipt Query (CRQ)


    • 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 ...
    • Create a Custom Query Report

      Select the Custom Query Report There are five Custom Query Reports. Select the one that you want to use. Transactions Panel Custom Encounter Query (CEQ) Custome Receipt Query (CTQ) Custom Transaction Query (CTQ) Patient Panel Custom Patient Query ...
    • 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 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 ...