No Immutable Dates for When Items are Treatment Planned.
No Immutable Dates for When Items are Treatment Planned.
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
- jordansparks
- Site Admin
- Posts: 5742
- Joined: Sun Jun 17, 2007 3:59 pm
- Location: Salem, Oregon
- Contact:
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.
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.
Jordan Sparks, DMD
http://www.opendental.com
http://www.opendental.com
- jordansparks
- Site Admin
- Posts: 5742
- Joined: Sun Jun 17, 2007 3:59 pm
- Location: Salem, Oregon
- Contact:
- jordansparks
- Site Admin
- Posts: 5742
- Joined: Sun Jun 17, 2007 3:59 pm
- Location: Salem, Oregon
- Contact:
Since you don't have SVN commit priv yet, I guess I'll go ahead and add that field this weekend.
Jordan Sparks, DMD
http://www.opendental.com
http://www.opendental.com