HearAid Version 5.0

Removing Claims Prepared Automatically in Advance

Removing Claims Prepared Automatically in Advance

Previous topic Next topic  

Removing Claims Prepared Automatically in Advance

Previous topic Next topic  

You can remove the automatically generated claims using a SQL script in Database|Query, which identifies maintenance claims with service dates after a defined date

1.Have all other users exit HA5
2.Make a fresh backup of your database by opening HA5 then exiting immediately, making a backup as you exit
3.Log in to HA5 using the SYSDBA username and password
4.Select Database|Query
5.Click the New Query button
6.Copy the following text into the editor

 

   DELETE FROM

     CLAIMS

   WHERE

     (SERVICE_DATE >= '2009-10-01') AND

     (ITEM = '777') AND

     EXISTS

       (SELECT

          *

        FROM

          CLAIMS C

        WHERE

          (C.ITEM IN ('700', '710')) AND

          (C.SERVICE_DATE = CLAIMS.SERVICE_DATE) AND

          (C.CLIENT_PK = CLAIMS.CLIENT_PK));

   DELETE FROM

     CLAIMS

   WHERE

     (SERVICE_DATE >= '2009-10-01') AND

     (ITEM IN ('700', '710'));

 

7.Change the cut-off date by editing the dates shown in bold red above... in the example shown, the cut-off date is 1 October 2009
8.Click the Execute SQL button
9.Install the fee update and then re-run the auto-maintenance function