Are ProcedureLogs Archived?

[graham_mueller]

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.

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
 

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?

[graham_mueller]

Followed up with support; ProcedureLogs are not archived, but the clinics I'm working with didn't associate them with Appointments prior to 2019, so I have to tie up another way, likely just by date.