Group Notes

[Cheryl Stern]

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.

[Cheryl Stern]

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

[jordansparks]

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.

[Hersheydmd]

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;