After care calls / evening call list for Doctor

For users or potential users.
Post Reply
vonore
Posts: 8
Joined: Mon Aug 20, 2018 11:39 am

After care calls / evening call list for Doctor

Post by vonore » Wed Jun 03, 2020 7:49 am

My research shows only a suggestion to create a task for this. I am looking for a report to provide patient name, phone and treatment completed in a single day. This report can be given to the doctor to take home and make evening calls to check on patients. Any suggestions?

joes
Posts: 239
Joined: Tue Aug 13, 2019 12:41 pm

Re: After care calls / evening call list for Doctor

Post by joes » Wed Jun 03, 2020 9:16 am

Hello vonore,
We do have a query on our website that you can run to generate a list for evening calls. If you run it as is, you will get a list of all patients that have had procedures completed today, their phone numbers, and a list of the procedure codes that were completed for each patient. The query has variables that allow you to get results for a date range and filter results by procedure code. I'll place the query in a separate post so that it is easy to copy and paste. If you have any questions about it, please let me know.
Joe Sullivan
Open Dental Software
http://www.opendental.com

joes
Posts: 239
Joined: Tue Aug 13, 2019 12:41 pm

Re: After care calls / evening call list for Doctor

Post by joes » Wed Jun 03, 2020 9:17 am

/*150 End of day call back list for completed procedures*/
SET @AlwaysCurrentDay = 'Yes'; -- Set this to 'Yes' to always run for "today", change to 'No' to run for the specified date range
SET @FromDate='2020-01-01', @ToDate='2020-01-01';
SET @Procedures=''; -- Comma delimited list of procedure codes, leave blank for all

/*------------ DO NOT MODIFY BELOW THIS LINE ------------*/
/*Query code written/modified on: 05/28/2020:RobG*/

SELECT
pl.ProcDate,
p.PatNum,
p.HmPhone,
p.WirelessPhone,
p.WkPhone,
GROUP_CONCAT(DISTINCT pr.Abbr) AS 'Provider',
GROUP_CONCAT(DISTINCT pc.ProcCode) AS 'Code'
FROM patient p
INNER JOIN procedurelog pl
ON p.PatNum = pl.PatNum
AND pl.ProcStatus = 2 -- Completed
AND IF(@AlwaysCurrentDay = "Yes", pl.ProcDate = CURDATE(), pl.ProcDate BETWEEN @FromDate AND @ToDate) -- Date range
INNER JOIN procedurecode pc
ON pl.CodeNum = pc.CodeNum
AND IF(LENGTH(@Procedures) = 0, TRUE, FIND_IN_SET(pc.ProcCode, @Procedures)) -- Procedure filter
INNER JOIN provider pr
ON pr.ProvNum = pl.ProvNum
GROUP BY pl.ProcDate, pl.PatNum
ORDER BY pl.ProcDate, p.LName, p.FName
Joe Sullivan
Open Dental Software
http://www.opendental.com

nolesdental
Posts: 1
Joined: Tue Mar 07, 2023 1:12 pm

Re: After care calls / evening call list for Doctor

Post by nolesdental » Wed Mar 08, 2023 6:52 am

How to we edit this to choose certain procedure codes?

Post Reply