Description
Summarizes possible duplication of client records. This report identifies the possible duplicates by comparing:
- Date of Birth, Gender, Last Name at Birth (soundex), and the Health Card Number if it is available.
- Date of Birth, Gender, Last Name (soundex), and the Health Card Number if it is available.
- Health Card Number
- It excludes the following clients from the comparison:
- Clients with blank DATIS key and blank last name
- It excludes the following clients from the comparison:
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 number | Possible 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