report bluechip linked patients with duplicate external_id
TRANSCRIPT
8/8/2019 Report BlueChip Linked Patients With Duplicate External_ID
http://slidepdf.com/reader/full/report-bluechip-linked-patients-with-duplicate-externalid 1/4
This article applies to HCN Products:
Medical Director 3
BlueChip
Software Versions Required: MD3.8 or higher & the 3.9.2 patch applied
BC2.5 or higher
Problem: Due to unexpected behaviour of the MD3 linking procedure before MD3.9.2, it is possible that when apatient’s major identifiers were modified in Bluechip (First name, surname, DOB), these details were notupdated in MD3, but rather a new patient was created.This had 2 undesirable results:
1. The patient was replicated in MD3 and the clinical details may now be spread betweenthe duplicate patient records.
2. The Bluechip Document Transfer mechanism would stop functioning as it would not knowwhich patient to assign the documents to
Resolution:
Identify the patients with duplicate External_ID values so that they may be checked by the site for theirvalidity of being duplicate patients.If they are truly duplicate patients, the site should merge them within MD3 ensuring they merge into thepatient with the currently correct demographic details.Once this has been completed, remaining duplicate External_ID should be “reset” and a synchronise fromBluechip to MD3 performed.
Instructions:This issue requires a two part process.
1. Run the Script ID00000-ReportBCLinkedDuplicateMD3Patients.sql to generate the report in theHCNInstMngr log file.
2. After ALL appropriate merging has been completed, run the script ID00000-
ResetBCLinkedDuplicateMD3Patients.sql so they are no longer linked to Bluechip to allow thestandard linking mechanism re-establish any missing.
Please find attached to this document the SQL repair scripts to rectify the problem at hand.
ID00000-ReportBCLinkedDuplicateMD3Patients.sql
ID00000-ResetBCLinkedDuplicateMD3Patients.sql
Procedure List:
8/8/2019 Report BlueChip Linked Patients With Duplicate External_ID
http://slidepdf.com/reader/full/report-bluechip-linked-patients-with-duplicate-externalid 2/4
8/8/2019 Report BlueChip Linked Patients With Duplicate External_ID
http://slidepdf.com/reader/full/report-bluechip-linked-patients-with-duplicate-externalid 3/4
9. Close the HCNInstMngrMonitor.LOG file10. Close the HCN Mechanic11. Use the Report to locate the Duplicates in MD3
The Report lists the details of the Bluechip patient, then below that the duplicate MD3 Patients.If the MD3 Patient Record is indeed a duplicate - check Letters, Scripts, Progress Notes, etc.
Merge the duplicates together, keeping the MD3 patient who’s demographics match Bluechip
(Enable the “Include inactive patients” filter in MD to find any inactive duplicate patient, so that they can bemerged as well)
If the MD3 Patient Record’s Name does NOT match the clinical records,Update the MD3 Patient Record’s Name appropriately
RESET External_ID Once all possible duplicates have been merged and incorrect names fixed, run the following Reset SQL scriptto ensure any remaining MD3 duplications have their External_ID reset to allow the normal Linking Mechanismto match unlinked Bluechip Patients to MD3 Patients based on their Demographic details.
1. Make sure that all users have exited Medical Director 3 and BlueChip on their computers.2. Create a FULL MD3 backup through HCN Maintenance.3. Save the script email attachment ID00000-ResetBCLinkedDuplicateMD3Patients.sql to a location on
your hard drive (eg. My Documents). 4. Start the HCN Mechanic.
a. From the Windows Start menu, Select Run (Start->Run)b. From the Run window, press the Browse button and browse to the HCNInstMngr.exe file located in
the following folder:C:\Program Files\Health Communication Network\Common\HCNInstMngr\
c. Once the HCNInstMngr.exe file has been highlighted press the Open button to return to the Runwindow.
d. From the Run window, scroll to the end of the file-path.Note: This can be done by single-clicking on the file-path and pressing the END key on your
keyboard.e. Press the Spacebar key and type in /mechanic
(the path now should look something like ….Common\HCNInstMngr\HCNInstMngr.EXE" /mechanic)
5. Once the PracSoft Installation Manager Mechanic has opened:a. Find and highlight the correct server listed within the Available Servers on the left hand side
(eg. “SERVER\HCNSQL07’)b. Find and highlight the BlueChip database listed within the Available Databases on the right hand
side6. Press the Exec SQL Script button and browse to the file saved in step 3.
ID00000-ResetBCLinkedDuplicateMD3Patients.sql After checking the confirmation details are correct, follow the remaining prompts to allow the script to
run.Note: The script may take a few minutes to complete, please wait.Note: If a message is displayed indicating ‘SQL Script file <drive\file.sql> Failed to Verify’, andYou will need to re-download the repair script from your email client and re-run this step as it has beendamaged or modified.
7. Open the HCN Mechanic log file to ensure that the script has successfully completed and obtain theReport.
a. If the PracSoft Installation Manager Mechanic is still open:Press the Installation Log button (bottom left corner) to open the log file.
b. If the PracSoft Installation Manager Mechanic is not open:From My Computer, browse to the C:\Documents and Settings\All
Users\Documents\HCN\HCNInstMngrAnd Open the HCNInstMngrMonitor.LOG file
Scroll to the end of the file and locate the report described below under SQL OUTPUT for RESETExternal_ID.
8. Copy the RESET External_ID report to an EMPTY NotePad / WordPad document for Printing.
8/8/2019 Report BlueChip Linked Patients With Duplicate External_ID
http://slidepdf.com/reader/full/report-bluechip-linked-patients-with-duplicate-externalid 4/4
9. Close the HCNInstMngrMonitor.LOG file10. Close the HCN Mechanic11. Use the RESET External_ID report as a reference to the Duplicates in MD3 that had their External_IDreset12. To re-synchronise BC & MD, perform a dump of all patients in BC and import them through theimport utility in HCN maintenance.13. Enable the link File processor.
Note: Once the repair process has been completed, the files should be deleted from the computer.These scripts should never be run without recommendation by Technical Support.
Note: These scripts should never be given or used at other surgeries without recommendation byTechnical Support.