Skip to main content

Event Log Report

Generate a report of event log information in myAvatar.

Prerequisite:


  1. Go to: RADplus Utilities > System Security > Auditing > Event Log Report.
  2. Enter the report Start Date and Start Time.
  3. Enter the report End Date and End Time.
  4. In the All Event Types or Selected field, designate whether to generate a report for All Event Types recorded or only for Selected Event Types. If Selected Event Types is chosen, select the event types to report in the Event Type field.
  5. Select View Event Log to generate the report.

Event Log Report

The Event Log Report has several subreports:

  • Events Sorted By Date
  • Events Sorted By User ID
  • Events Sorted By Patient ID
  • Events Sorted By Action
  • Events Sorted By Time
  • Events Sorted By Data Accessed
  • Form Privileges By User ID

When using the Event Log Report to track application logins, it is possible for a single user logout event to generate three logout entries in SYSTEM.RADplus_audit_login_event. This is a normal result of processes running for the user at the time of logout. Each application login to the HomeView generates up to three different job threads: one for the Home View, one for 'fast' widgets with a one second timeout, and one for 'slow' widgets with a timeout greater than one second.

Depending on which type of widgets the user is assigned, the user may generate all three types of jobs. Although these three jobs are all generated by the single application login event, they are all recorded individually on log out. This only affects HomeView.

If the record was modified outside of the application, the text of the row with the alteration appears in red.

Differences Between Entries for 'Data Queried' and 'Entry Added'

'Data Queried' refers to any type of lookup in a given form, such as the client search and staff search fields. Performing a client lookup, staff member lookup, or guarantor lookup queries the staff, client, or guarantor database file, respectively. Consequently, any time a user performs a lookup through a search field this creates a row in the event log to indicate the user performed a data query. Data queries are also logged for any given widgets that are running, since when a client is selected, a query is performed by the widget to display data in the widget.

'Entry Added' signifies a change or update to a given table. For example, when processing an admission for a client's second episode, the Admission form captures a significant amount of information including patient demographics, attending practitioner, admitting practitioner, and the general admission information. All of the information captured during the admission is written to the respective tables, and for each row created in a given table, an Entry Added row is created in the event log. Two 'Entry Added' rows are created for the patient demographics, because even if there are demographics on file, the existing row is updated with the new information and a new row is added to the demographics history table. Ultimately, the rows added to an event log directly correlate to the tables that a form writes to when submitted. Also, any search fields that are used within a given form create 'Data Query' entries if a search or lookup is performed in the field.

► SQL table
  • SYSTEM.RADplus_event_log 

 

  • Was this article helpful?