After care calls / evening call list for Doctor
After care calls / evening call list for Doctor
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?
Re: After care calls / evening call list for Doctor
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.
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.
Re: After care calls / evening call list for Doctor
/*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
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
-
- Posts: 1
- Joined: Tue Mar 07, 2023 1:12 pm
Re: After care calls / evening call list for Doctor
How to we edit this to choose certain procedure codes?