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

Getting a list of patients who are signed up on our Surescripts portal

General Discussion

Last Post by woodjh 9 years ago

9 Posts

7 Users

0 Reactions

81 Views

RSS

woodjh

(@woodjh)

Posts: 57

Estimable Member

Topic starter

We are using surescripts for our patient portal. Does anyone know of a way to get a list of our patients who have signed up for the portal?

Posted : March 23, 2016 2:21 am

cecild

(@cecild)

Posts: 314

Reputable Member

We actually make a entry in the registration notes when they sign up. So we can run a query from that..

Posted : March 23, 2016 5:27 am

tcross

(@tcross)

Posts: 165

Estimable Member

I would like to know the answer to this question as well. Also are you satisfied with the GE patient portal? Do you have a vendor that assits you with building templates and forms?

Posted : March 23, 2016 6:27 am

gpincomb

(@gpincomb)

Posts: 278

Reputable Member

What about running the following script against the Enterprise database on your Patient Portal Application Server? For our company I rule out the system records (donotreply and system); you may have to do the same. And by selecting that they have validated their email gives me the patients who have signed up for our portal.

select kea.EmailAddress, kea.HasValidatedEmail, ku.*

from KUser ku, KEmailAddress kea

where ku.UserID = kea.UserID

and kea.EmailAddress notin('[email protected]','system')

and kea.HasValidatedEmail = 1

Posted : March 23, 2016 7:24 am

tleonard

(@tleonard)

Posts: 31

Eminent Member

Depending on what you're looking for, you can just look at the muactivitylog table and then expand the query from there.

select * from MUActivityLog where MUActivityLogTypeId = '510'

What we've done is joined tables to give more useful data. This is also based on us using the portal sign up method, not the patportalpin for signups. We use the patportalpin obs term for declines only. I'm sure others may have different or better ways of doing it, but this is what we've got. I've removed anything that may not apply.

WITH INITIAL AS (select distinct
a.last
, a.First
, a.PatientId
, a.EMailAddress
, DB_Create_Timestamp
, UserAccessIdentifier
, MUActivityLog.MUActivityLogTypeId
, MUActivityLogType.Description
, MUActivityLog.Recipient
, a.ContactByMId
, a.EthnicityMId
--, DoctorFacility.First as DoctorFirst
--, DoctorFacility.Last as DoctorLast
, DoctorFacility.DotId
,DATEDIFF(YY,Birthdate,GETDATE()) -
CASE
WHEN DATEADD(YY,DATEDIFF(YY,Birthdate,GETDATE()),Birthdate)
> GETDATE() THEN 1
ELSE 0
END AS [AGE]
,DoctorFacility.Last+', '+DoctorFacility.First AS DoctorName
from MUActivityLog
inner join PatientProfile a on MUActivityLog.PID = a.PId
inner join MUActivityLogType on MUActivityLog.MUActivityLogTypeId = MUActivityLogType.MUActivityLogTypeId
inner join DoctorFacility on a.DoctorId = DoctorFacility.DoctorFacilityId
where MUActivityLog.MUActivityLogTypeId = '510'
and a.First not like 'test' and a.last not like 'test'),

START AS (SELECT
PatientId
, SUMMARY
, DB_CREATE_DATE
, LoginUser
, OrgName
from DOCUMENT
inner join PatientProfile a on DOCUMENT.PID = a.PId
inner join DoctorFacility on DOCUMENT.USRID = DoctorFacility.PVId
where SUMMARY like 'pin generator')

SELECT * from INITIAL
left join START on INITIAL.PatientId = START.PatientId
order by INITIAL.Last

Posted : March 23, 2016 7:30 am

mscianni

(@mscianni)

Posts: 10

Active Member

You can get a list of patients who have successfully registered from the audit events in the portal admin.

Posted : March 23, 2016 7:33 am

tcross

(@tcross)

Posts: 165

Estimable Member

Thank you mscianni. that did the trick!!!

Posted : March 23, 2016 7:55 am

Ty

(@thaulk)

Posts: 131

Estimable Member

I would like the opposite, a list of active patients who have not registered for the portal

Posted : March 23, 2016 9:07 am

woodjh

(@woodjh)

Posts: 57

Estimable Member

Topic starter

Thanks for the info. Are they a way for the list to show the patient's name?

Posted : March 24, 2016 3:01 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