Session Query Not Pulling Everything

Day-to-Day Users
1

We are trying to pull all the encounter data for the day for all of our clinicians. There is a subset of our clinicians, interns, that are not being pulled using this query. They work with clients that don’t have any insurance, so they don’t have an insurance identified. I’m not sure if that is it or not. Here is the query we are using. Any thoughts on why only that group of clinicians and their clients are not being pulled?

SELECT
p.fname, 
p.lname, 
pc.pc_pid, 
p.DOB, 
pc.pc_eventDate, 
pc.pc_startTime, 
pc.pc_title,
pc.pc_hometext,
CONCAT(u.fname, ' ', u.mname, ' ', u.lname) Provider
FROM
patient_data p
LEFT JOIN
openemr_postcalendar_events pc ON p.pid = pc.pc_pid
LEFT JOIN users u ON u.id = pc.pc_aid
WHERE pc.pc_eventDate = "2022-10-10"
ORDER BY pc.pc_startTime ASC
;
2

are any of the appointments recurring?

3

They are mostly recurring, but when they get confirmed the appointment type changes to a confirmed appointment (we created a calendar entry for Hold appointments that are typically recurring). All of our other clinicians use the same system described above and their session data pulls over.

One of our former staff members implemented this query, so I’m not sure if it pulls from the calendar or the encounter notes that were created.