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

Need script or report to find duplicate MRNs

CPS, C-EMR, PM

Last Post by Anonymous 1 second ago

4 Posts

4 Users

0 Reactions

68 Views

RSS

gthornton

(@gthornton)

Posts: 16

Eminent Member

Topic starter

We are on EMR 9.8 spk3 and CPS11. I need to be able to find duplicate medical record numbers in the emr. I need help with this as soon as possible. Thanks
[email protected]

Posted : October 17, 2014 8:27 am

joeg1962

(@joeg1962)

Posts: 843

Noble Member

Do you have Crystal Reports?

Here is a CR definition.

(Well, I will try to upload it here... however, it appears that .rpt files cannot be uploaded)

O300 Patients Dup MRN

Note, I had to change the file extension from .rpt to .txt to get this to upload. So, download and then rename it.

Posted : October 20, 2014 1:28 am

acantu

(@acantu)

Posts: 722

Prominent Member

This script should do it for you...

SELECT First, Last, PatientProfileID, PatientId, MedicalRecordNumber
FROM PatientProfile
WHERE MedicalRecordNumber IN (
SELECT MedicalRecordNumber
FROM
(
SELECT ROW_NUMBER() OVER (PARTITION BY MedicalRecordNumber ORDER BY PatientProfileId DESC) AS MRN_COUNT, *
FROM PatientProfile
WHERE MedicalRecordNumber IS NOT NULL) AS TEMP
WHERE MRN_COUNT > 1)

Posted : October 20, 2014 5:21 am

ronmoses

(@ronmoses)

Posts: 158

Estimable Member

;WITH cte_MRN AS (
SELECT MedicalRecordNumber, COUNT(PId) AS PatientCount
FROM PatientProfile
GROUP BY MedicalRecordNumber
HAVING COUNT(PId) > 1)
SELECT p.* --edit column list as needed
FROM PatientProfile p
INNER JOIN cte_MRN c
ON p.MedicalRecordNumber = c.MedicalRecordNumber;

That would give you the list of patients who have duplicate MRNs. Or you could just run the contents of the CTE to get the list of MRNs that appear more than once.

Posted : October 21, 2014 7:23 am

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