<< Click to Display Table of Contents >> Navigation:  HearAid On-Line Help > How To... > Log Tables

HearAid uses a number of tables to log various activities:

•The Batch Log keeps track of all the HSP e-Claim batch files uploaded to HSO. The Reconciliation process will automatically update the log and claim records and will store copies of the batch file and the response files within the database. This data is stored in the ECLAIMS_LOG table and is accessible from e-Claims|Batch Log

The following log tables are accessible from Tools|Browse:

•The Accounts Interface log records the results of transactions with the HearAid-Reckon Accounts interface

•The Calendar Reminders log records the date, time, addressee and contact (email address or mobile phone number) used to send appointment reminders. This data is stored in the CALENDAR_REMINDERS table.

•The Contact Log stores a reference to the most recent contact for a client whenever a data record is added or modified in
 
Client Details
Claims
Consumable Issues
Documents
Fittings
Notes
Orders
Recalls
Repairs
Reports
 
These updates occur automatically at the database level and are stored in the CONTACT_LOG table and controlled by the P_CONTACT_LOG stored procedure

•The Email Log stores records for emails sent out by HearAid. It records the Date/time the email was sent, the email address it was sent to and the subject of the email. For example, records of  emailed appointment reminders are recorded in this table. This data is stored in the EMAIL_LOG table.

•Mail Outs records details of mail-merges sent from the Quick Reports|Mail Merge menu. The log records a reference to the primary key for the Client, the date the mail out was sent and the name of the mail out document. The table is linked to the Mail tab in the Client Details work-area and is also used for Mail Merge Follow-up processing

•The Process Log records all additions, updates and deletions of data from the main data tables. Each record includes the ID of the logged on user who made the change, what table was affected, the new and old values of modified data (except for BLOB and memo data) and the date/time when the change occurred. This can be very useful information when trying to trace data anomalies and errors!

•The Error Message Log records details of user errors and major programming errors which may indicate a bug. This information can be useful in tracing odd program behaviour and errors

The Accounts Interface, Calendar Reminder Messages, Error Message and Process Logs should be purged regularly, by clicking Tools|Purge Logs