Open Dental Forum

I have been using group notes to write my progress note at the end of each appointment. I need a report at the end of the day to check these notes and make sure each patient has a note written. Is there some way to produce this report? It's a pain to go to each patient chart and check this. The incomplete procedure notes report , under daily in the reports window, does not show this. My daily procedures report does not show if there is a signed note. All the queries and reports I see are connected to procedure codes and my notes are under the code ~GRP~ and I sign these. Thank you.

Can anyone help here? Any one using group notes? Thanks

A query could do it, but someone would need to write it. We offer that as a paid service, if you're interested in doing it that way.

Cheryl,
This will give you Progress Notes missing signatures. Not sure if it will work for Group Notes. Maybe someone can modify it.

• SET @FromDate='2012-01-01' , @ToDate='2020-12-31';
  SELECT A.provnum, A.patnum, A.procdate, C.proccode, C.descript
  FROM procedurelog A, procedurecode C
  WHERE (A.procnum NOT IN (SELECT DISTINCT B.procnum FROM procnote B WHERE (TRIM(B.signature) <> ''))) AND
  (A.procstatus = 2) AND (A.codenum = C.codenum) AND (A.provnum = 1) AND
  (DATE(A.procdate) BETWEEN DATE(@FromDate) AND DATE(@ToDate))
  ORDER BY A.patnum, A.procdate;