delete old patient and their claims and procedures

rajeshpareek · Post by **rajeshpareek** » Sun Sep 05, 2010 7:20 am

Is there a SQL statement to delete patients, their procedures and their claims prior to say 09/01/2010. Much Thanks!

I entered patients from a new office with old office data. In the new office, want to remove the old office patient so that we get correct reports, patient list etc. OR Can I hide procedures and patients from the the list . Make them inactive ? THANKS!

Post by **jordansparks** » Thu Sep 09, 2010 9:05 pm

No. Can you explain why on earth you would want to do such a thing? Open Dental never deletes patients or procedures; it just hides them.

rajeshpareek · Post by **rajeshpareek** » Wed Sep 29, 2010 4:36 am

THANKS DR SPARKS. I entered patients from a new office with old office data. In the new office, i want to remove the old office patient so that we get correct reports, production, patient list etc. OR Can I hide procedures and old office patients from the the list . Make them inactive ? THANKS!

Post by **jordansparks** » Wed Sep 29, 2010 6:39 pm

No, you should have started with a fresh database.

Open Dental

delete old patient and their claims and procedures

delete old patient and their claims and procedures

Re: delete old patient and their claims and procedures

Re: delete old patient and their claims and procedures

Re: delete old patient and their claims and procedures