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

script/report request

CPS, C-EMR, PM

Last Post by Anonymous 1 second ago

8 Posts

4 Users

0 Reactions

78 Views

RSS

hbias

(@hbias)

Posts: 83

Estimable Member

Topic starter

I am looking for a way to inactivate patients who have never been seen. The active report in GE only looks at last office visit. When we migrated to GE, we brought across 2 years of patient data and many of these patients never came in. Anyone have anything like this? I would like to be able to do by date created.

thanks in advance

Posted : April 23, 2015 4:02 am

acantu

(@acantu)

Posts: 722

Prominent Member

Here you go, this script will set patients the Inactive status if they are currently active but do not have a document in their Chart.

UPDATE PatientProfile
SET pstatus = 'I', PatientStatusMId = -901
WHERE pstatus = 'A' AND (SELECT COUNT(*) FROM DOCUMENT WHERE PID = PatientProfile.PID) = 0
AND (SELECT COUNT(*) FROM Appointments WHERE OwnerId = PatientProfile.PatientProfileId) = 0

If you want to see which patients will be inactivated, you can run this script below before you do the one above:

SELECT *
FROM PatientProfile
WHERE pstatus = 'A' AND (SELECT COUNT(*) FROM DOCUMENT WHERE PID = PatientProfile.PID) = 0
AND (SELECT COUNT(*) FROM Appointments WHERE OwnerId = PatientProfile.PatientProfileId) = 0

Posted : April 23, 2015 4:39 am

hbias

(@hbias)

Posts: 83

Estimable Member

Topic starter

Thanks, but wont that remove all the new patients who have not come in yet?

Posted : April 23, 2015 5:08 am

acantu

(@acantu)

Posts: 722

Prominent Member

I updated the script to look to see if they have any appointments as well.

Posted : April 23, 2015 5:16 am

jfitzmd

(@jfitzmd)

Posts: 419

Reputable Member

Nice solution.

Here is another approach. Identified HDID for Obs term used in all encounters which for our practice was "cardio HPI", left join PatientProfile on Obs by PID, listed pts with null value in obs term.

SELECT PatientProfile.Last, PatientProfile.First, PatientProfile.PatientId
FROM PatientProfile LEFT JOIN OBS ON PatientProfile.PId = OBS.PID
WHERE ((OBS.OBSVALU) Is Null) AND (OBS.HDID)=25317)

Posted : April 23, 2015 6:46 am

Jonathan

(@jonschultziddc)

Posts: 26

Eminent Member

If you want by date created, add a date condition to the where clause:

BEGIN TRANSACTION UPDATE PatientProfile SET pstatus = 'I' WHERE pstatus = 'A' AND (SELECT COUNT(*) FROM DOCUMENT WHERE PID = PatientProfile.PID) = 0 AND (SELECT COUNT(*) FROM Appointments WHERE OwnerId = PatientProfile.PatientProfileId) = 0 AND Created < '01/01/2013' -- COMMIT

Make you you have at least two backups before doing a mass-delete like this.
As recommended above, run a SELECT query first to verify which patients will be affected.
Add a BEGIN TRANSACTION at the first statement, when the update is done and the row count is correct run the COMMIT statement (highlight COMMIT then click Execute).
Note that using BEGIN TRANSACTION will lock out other users until the changes are committed, so it's best to run this after hours.

Posted : April 23, 2015 7:38 pm

acantu

(@acantu)

Posts: 722

Prominent Member

don't think you would need a begin transaction and commit, you are not deleting anything, just changing the patients status from Active to Inactive. But, i do agree, you do need to make sure you have a backup of the table just in case you need to rollback the changes. But recommended to run the select script first to view which records are going to be changed.

Posted : April 24, 2015 5:31 am

hbias

(@hbias)

Posts: 83

Estimable Member

Topic starter

thanks for all the answers!

Posted : April 27, 2015 4:11 am

Share:

24 Forums
9,940 Topics
39.9 K Posts
5 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