HearAid Version 5.0

Log Tables

Log Tables

Previous topic Next topic  

Log Tables

Previous topic Next topic  

HearAid 5.0 uses a number of tables to log various activities:

The Batch Log keeps track of all the OHS e-Claim batch files uploaded to Medicare. 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.
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 5.0. 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
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 Process Log should be purged regularly, by clicking Tools|Purge Proces Log. This process removes log entries older than the number of weeks specified in Tools|Options|General|Purge Process Log Entries Older Than (Weeks)
 
PurgeProcessLogWeeks
The Program Errors Log records details of major programming errors which may indicate a bug. This information can be useful in tracing odd program behaviour and errors