Duplicate Clinical Notes in form_clinical_notes Table on 11k patients Instances

[KeerthikaSunchu]

Describe the bug

The form_clinical_notes table on both web12 and web13 contains duplicate entries for various descriptions.

To Reproduce

Steps to reproduce the behavior:

1. Log into web12 or web13 OpenEMR database.
2. Navigate to the SQL Query section.
3. Execute the following query:
   SELECT description, COUNT( * )
   FROM form_clinical_notes
   GROUP BY description
   HAVING COUNT( * ) > 1;
4. Observe multiple records showing the same description with counts greater than 1.

Expected behavior

Each clinical note's description should be unique, or the duplicates should be justified by different patient IDs or encounters. There should be no unintended duplication of note descriptions for the same patient encounter.

Client configuration

• OpenEMR version: 7.0.2