Search for Duplicate Charts Report Template

Share this
[featured_image]
  • Version
  • Download 149
  • File Size 0.47 KB
  • File Count 1
  • Create Date September 22, 2023
  • Last Updated September 22, 2023

Search for Duplicate Charts Report Template

Provided by Earl Wertheimer - A RBT to check for duplicate charts:

How it works: The grouping is by name & DOB.
The 'having count(*) > 1; lists the duplicates, but only a single line for each set of dups.

Change
group by last_name, first_name, year_of_birth, month_of_birth, date_of_birth
to
group by HIN
for duplicate HINs.

Attached Files

FileAction
Duplicate Demographics List.txtDownload