Are ProcedureLogs Archived?
Posted: Mon Oct 28, 2024 7:51 am
This is sort of a follow on to this topic regarding billing. In another portion of our software, we're trying to do some patient balance work, which had been using ProcedureLog as the source for "ProcFee," but it appears that after ~5 years, this data no longer exists? A simplified version of my query.
This works fine for our newer patients, but we had one come up that's been a patient since 2007 who had an out of whack balance. I am able to see his charges all the way back to 2007 in OpenDental itself, and if I drop the join to PL on that query, the appointments come through too. Is there a different or historical table I should be using to grab procedure fee info, broken up by proc code?
Code: Select all
select
appt.AptNum,
appt.PatNum,
appt.AptDateTime,
appt.ProcDescript,
pl.ProcFee
from appointment appt
join procedurelog pl on appt.AptNum = pl.AptNum
where appt.PatNum = <Patient>
and appt.AptStatus = 2