Welcome to the NEW CHUG— your ultimate destination for cutting-edge insights and discussions at the intersection of healthcare and technology.

Our platform is dedicated to exploring the dynamic landscape of healthcare technology, empowering professionals, enthusiasts, and innovators alike with the knowledge and resources to navigate the rapidly evolving field.

From telemedicine revolutionizing patient care to the transformative potential of artificial intelligence in diagnostics, we delve into a myriad of topics shaping the future of healthcare delivery. Whether you’re a seasoned healthcare IT professional, an aspiring entrepreneur in the digital health space, or simply curious about the latest innovations, our curated content, expert interviews, and thought-provoking articles provide a comprehensive exploration of healthcare technology’s most pressing issues.

Join us as we navigate the forefront of innovation, driving forward the transformation of healthcare for a healthier, more connected world.

Have questions or suggestions? Please use the contact button below.

Notifications

Clear all

Suggestions for unmerging patient data ?

General Discussion

Last Post by mj2718 11 years ago

3 Posts

2 Users

0 Reactions

73 Views

RSS

mj2718

(@mj2718)

Posts: 54

Trusted Member

Topic starter

We have an issue where 2 patient records were merged together. We've had this happen before but don't have a good solution for it.

Obviously, preventing it is the best solution (using application Security, procedures, etc).

Here is the process we are thinking of:

Identify which patient of the 2 we'd rather not have to recreate data for, then designate the single remaining chart as that patient (Patient A).
Update the registration as necessary for Patient A, including Guarantor. (making note of any reg data that will be needed for the other patient – Patient B).
Create new patient record for Patient B
Identify all PM data that does not belong in Patient A's record.
Recreate the PM data in new record for Patient B and inactivate or remove that PM data for Patient A.
Identify all EMR data that does not belong in Patient A's record.
Recreate the EMR data in new record for Patient B and inactivate or remove that EMR data for Patient A.

Unfortunately we can't think of any good way to move observations.

Has anyone developed scripts or an automated tool to unmerge patient records? Or even have documentation of what would need changed in the database (we have some in-house SQL experience).

Does anyone have a recommended method of dealing with these?

Any other thoughts or recommendations?

Thanks, Matthew | IS Analyst

Posted : January 23, 2014 11:32 pm

jamesedward

(@jamesedward)

Posts: 257

Reputable Member

CPS or Oracle?

Posted : January 26, 2014 10:05 pm

mj2718

(@mj2718)

Posts: 54

Trusted Member

Topic starter

CPS

Posted : January 26, 2014 10:11 pm

Share:

24 Forums
9,940 Topics
39.9 K Posts
1 Online
6,470 Members

Forum Icons: Forum contains no unread posts Forum contains unread posts

Topic Icons: Not Replied Replied Active Hot Sticky Unapproved Solved Private Closed

Powered by wpForo Powered by wpForo version 2.4.0