Mass replace procedure codes

For complex topics that regular users would not be interested in. For power users and database administrators.
Post Reply
Mifa
Posts: 140
Joined: Wed Nov 21, 2007 7:52 pm
Location: Saint-Bruno, QC, Canada
Contact:

Mass replace procedure codes

Post by Mifa » Tue May 17, 2022 1:38 pm

Hi everyone,

I need to mass replace some procedure codes in future appointments to accommodate a change in the way we build our hygiene appointments. There are several hundreds of such appointments already scheduled. Needless to say that I am not thrilled with the idea of having to manually edit and update them one at a time... I cannot update the existing procedure codes table to reflect our new way of working as it would also be changing those codes in completed appointments.

I'm contemplating the idea of building a query that will identify then update these appointments. For those procedures that need to be changed, it would modify the codenum and procfee columns of their records in the procedurelog table then it would update the procdescript column in the appointment table, so that the schedule looks fine too.

Would that work? Is there something else I need to change, am I missing something?

Thanks.

Mifa

Post Reply