How are Duplicate Records Handled in the Grouper?
A unique patient record is considered as the same Organisation ID, Patient ID, Clinic ID and Attendance Date
So if a patient attends the same clinic on the same date it is considered the same attendance no matter how many time the patient attends in that day.
If there is more than one combination of Organisation Id, Patient ID, Clinic ID and Attendance Date in any month of data submitted then those records are merged into one using the following rules:
Where a field is populated in only one of the records then that field remains in the merged record, where a field is populated in more than one of the duplicate records then the last record uploaded will remain in the merged record.
For example, image two duplicate records, record 1 and record 2, with the same Organisation ID, Patient ID, Clinic ID and Attendance Date, but with the following SHHAPT fields:
| SHHAPT 1 | SHHAPT 2 | SHHAPT 3 | |
| Record 1 | T1 | ||
| Record 2 | T2 | C4 | |
| Merged Record: | T2 | C4 |
In the File Uploads tab on the Grouper you can see the number of records from each file you upload are considered as unique, in the Accepted tab the total records figure shows the number of records uploaded in total including duplicates. (This is a little counter intuitive and we are considering how to improve the display of this information).