Admin Query Report

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
  • DateTime the Database was accessed
  • IP Address
  • Database number

Who Is Logged In?

  • List of Users who are currently Logged In
  • User
  • Program
  • DateTime of Log In
  • Database Number

Last Accessed Patients

  • List of Patients that have been accessed
  • Patient ID of User who accessed the Patient
  • Date and Time Patient was accessed
  • User who accessed the Patient

Last Reports

  • List of Reports that have been run
  • View: Select the link to view the Report
  • Date and Time the Report was run
  • Title of the Report
  • File Name
  • Report Parameters
  • User who ran the Report

Deleted Receipts

  • List of Receipts that have been deleted
  • Receipt number
  • Amount of the Receipt
  • Amount that was Applied
  • Amount is Escrow
  • Type of Payment
  • Reference #
  • User who Deleted the Receipt
  • Date and Time the Deletion was done
  • Reason for the Deletion

AR Log

  • Undone Transactions
  • Encounter ID
  • Date and Time
  • Action
  • Program
  • Note
  • User


    • Related Articles

    • 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 ...
    • 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: ...
    • 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 > ...
    • POPS Session Usage Report

      The Session Usage Report can be accessed from 2 places within the System: POPS Management Admin > POPS Management > Session Usage Reports Dashboard Reports > Session Usage Use Session Usage to Report on Patient activity within a POPS session. ...
    • 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 ...