Description

Summarizes possible duplication of client records. This report identifies the possible duplicates by comparing:

  1. Date of Birth, Gender, Last Name at Birth (soundex), and the Health Card Number if it is available.
  2. Date of Birth, Gender, Last Name (soundex), and the Health Card Number if it is available.
  3. Health Card Number
    1. It excludes the following clients from the comparison:
      1. Clients with blank DATIS key and blank last name


Conditions

Results

-Same DOB
-Same Gender
-Similar Last Name (soundex)
-One client has a non-blank health card number and the other has a blank health card number
Possible duplicates
-Same DOB
-Same Gender
-Similar Last Name (soundex)
-Same health card number or both clients have blank health card number
Possible duplicates
-Same DOB
-Same Gender
-Similar Last Name at Birth (soundex)
-Different non-blank health card numbers
Not considered as possible duplicates
-Same DOB
-Same Gender
-Similar Last Name at Birth (soundex)
-One client has a non-blank health card number and the other has a blank health card number
Possible duplicates
-Same DOB
-Same Gender
-Similar Last Name at Birth (soundex)
-Same health card number or both clients have blank health card number
Possible duplicates
-Same non-blank health card numberPossible duplicates

Report Columns

Refer to the sub-reports section.

Parameters

  • Created On Date Range – specifies the created on date range to report on.
  • Client Registration Site No – specifies the registration site number, i.e. the site number on the Client Info screen, to report on. Users can select All Sites to run the report for all sites.

Sub-reports

List of Possible Duplicate Clients:
Lists the possible duplicate clients who were created during the selected time period and were registered in the selected site.

Report Columns:

  • Client Name – The client’s first and last name
  • Last Name at Birth – The client’s last name at birth
  • Chart/File # - The client’s chart/file number
  • Client Site – The registration site number on the Client Information screen
  • DOB – The client’s date of birth
  • Gender – The client’s gender
  • DATIS Key – The DATIS key
  • Health Card No – The client’s health card number
  • Address – The client’s latest address
  • Admission Site – The admission site number of the latest admission
  • Admission Date – The admission date of the latest admission
  • Discharge Date – The discharge date of the latest admission
  • Created By – The user who created the possible duplicate client
  • Created On – The date on which the possible duplicate client was created
  • Variables Matched – The variables on which the possible duplicate client matches another client in the database
  • No labels