No Immutable Dates for When Items are Treatment Planned.

dwkrueger · Post by **dwkrueger** » Thu Oct 25, 2007 7:05 pm

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

Post by **jordansparks** » Thu Oct 25, 2007 7:55 pm

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.

Post by **jordansparks** » Thu Oct 25, 2007 9:39 pm

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

Post by **jordansparks** » Fri Oct 26, 2007 4:54 pm

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