Open Dental Forum

It is a bit confusing to me as to why you have two dates in the ProcedureLog Table. DateEntryC and ProcDate. Both Dates change when ever you set procedure complete. I am trying to generate a list of procedures that have been treatment planned but I have to use a query that calculates this based on Completed procedures and treatment planned procedures. Can we add a Column that is OriginalTPDate that will not change after the procedure is treatment planned?

See Revenue come from production which is always a % of what is treatment planned. I need to know this to measure the treatment planning proficiency of myself and other doctors.

I am capable of adding this feature with the okay.

Dan

DateEntryC is a security related date, because only completed procedures affect finances, so we have to very carefully track when a procedure was actually marked complete. ProcDate is the date that shows to the user; the ordinary date.

I agree it's time to add "DateTP". We have a number of users who need to carefully track this date. I think in all practicality, it will just be a simple creation date that never changes. Go for it.

But do you have SVN commit priv? If not, call.

Since you don't have SVN commit priv yet, I guess I'll go ahead and add that field this weekend.