Data Trail Overview

Avatar Data Trail adds new SQL tables, providing auditing information for all RADplus modeled forms and select myAvatar PM forms. Data Trail also allows external SQL table access to auditing information in an easy-to-report format.

This feature is useful in helping you to confirm and record when data is added, edited, reviewed, and deleted. It allows you to see the order in which changes were made, and the date/time of access to patient records.

Although Data Trail is a PM module, auditing is supported in myAvatar CWS and myAvatar MSO.

The new AUDIT tables are based on the associated SYSTEM table (e.g., SYSTEM.billing_tx_history), and will contain several new fields, which are unique to myAvatar Data Trail.

► Fields and allowable values

• action_code
  • A - A new row is added.
  • E - An existing row is edited with a new entry.
  • R - An existing row is filed with no changes made.
  • D - A row was deleted.
• action_value
  • Add, Edit, Review, or Delete.
• audit_date
  • Data entry date.
• audit_time
  • Data entry time.
• audit_data_entry_by
  • Description of user logged into myAvatar .
• audit_data_entry_by_option
  • Description of user logged into the myAvatar form.
• audit_data_entry_user_id
  • User ID logged into myAvatar .
• audit_data_entry_user_name
  • Description of user logged into myAvatar .

After adding a form or table to the Audit Trail, you will need to grant user SQL access in the User Definition and/or User Role Definition form.

The selected tables are created in the AUDIT schema.

Refresh your ODBC Connection for access to the new tables.

Note: Newly created AUDIT tables contain no data. Audit entries are created for data files after the table has been selected for Audit Trail auditing.
Data entered prior to the table being selected for Data Trail will not be added to the table.