updating billingtype and feesched

[Mifa]

A long time ago, when we imported our data from our old PMS, I had the great idea to create a different "feesched" and "billingtype" for children under 10. Well, it turns out it was not such a bright idea... To undo it, I was thinking of running an "update patient set ... = ..." query for these two fields in the patient table in order to reset them to (our) default values. I have run the query on a test database and everything seems OK. Before I do it on our production data, can someone tell me if I am missing anything or if it is safe.

Thanks!

Mifa

[jordansparks]

I'm ok with it as long as you make sure the values you are setting to are valid and as long as you have tested in your test database.

[Mifa]

Thanks Jordan. and yes, I've checked our default values for these two fields in the patient table and will update these fields accordingly.