Way to see if all prompts in notes are filled out?

For users or potential users.
Post Reply
noestervemb
Posts: 59
Joined: Sat Jul 09, 2016 7:45 am

Way to see if all prompts in notes are filled out?

Post by noestervemb » Wed Mar 14, 2018 6:56 am

Is there a query that will shows if the word "prompt" is in any of the patients notes. Wanting to make sure we get our autonotes fully filled out but i cant find a way to search for the word "prompt" in the patient notes. This would give me a list to make sure all prompts are answered and none are unanswered. The incomplete note report does not give me these even if "" marks are added.

User avatar
cmcgehee
Posts: 711
Joined: Tue Aug 25, 2015 5:06 pm
Location: Salem, Oregon

Re: Way to see if all prompts in notes are filled out?

Post by cmcgehee » Wed Mar 14, 2018 10:15 am

What are you referring to when you say "patient notes"? Are you referring to the appointment-like objects that are placed on the appointment schedule?
Chris McGehee
Open Dental Software
http://www.opendental.com

noestervemb
Posts: 59
Joined: Sat Jul 09, 2016 7:45 am

Re: Way to see if all prompts in notes are filled out?

Post by noestervemb » Wed Mar 14, 2018 11:14 am

I am referring to the auto notes i use for patient procedures, chart notes.

User avatar
cmcgehee
Posts: 711
Joined: Tue Aug 25, 2015 5:06 pm
Location: Salem, Oregon

Re: Way to see if all prompts in notes are filled out?

Post by cmcgehee » Wed Mar 14, 2018 12:35 pm

This query might work.

/*404 Procedures with key word in note for date range*/
SET @FromDate= '2009-01-01', @ToDate='2010-07-31'; /*change dates here*/
SELECT procedurelog.ProcDate,procedurelog.ProvNum,
CONCAT(patient.LName,', ',patient.FName) AS 'PatientName',
procedurecode.ProcCode,procedurecode.AbbrDesc,
procedurelog.ToothNum, LEFT(n1.Note, 30) AS 'First 30 characters of Note'
FROM procedurelog,patient,procedurecode,procnote n1
WHERE procedurelog.PatNum = patient.PatNum
AND procedurelog.CodeNum = procedurecode.CodeNum
AND procedurelog.ProcStatus = 2
AND procedurelog.ProcDate BETWEEN @FromDate AND @ToDate
AND procedurelog.ProcNum=n1.ProcNum
AND n1.Note LIKE('%prompt%') /*change keyword here*/
AND n1.EntryDateTime=(SELECT MAX(n2.EntryDateTime)
FROM procnote n2
WHERE n1.ProcNum = n2.ProcNum)
ORDER BY procedurelog.ProvNum, procedurelog.ProcDate;
Chris McGehee
Open Dental Software
http://www.opendental.com

Post Reply