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

Portal Query

General Discussion

Last Post by rwilliams 8 years ago

4 Posts

3 Users

0 Reactions

64 Views

RSS

Ty

(@thaulk)

Posts: 131

Estimable Member

Topic starter

Does anyone on the surescripts portal know how to run a report that would show all LINKED patients vs unlinked ? We can't find in the database where this information is stored

Posted : October 7, 2016 1:08 am

tcross

(@tcross)

Posts: 165

Estimable Member

I would like that information as well. We were recently given 2 reports that were developed by Surescripts but we can not get them to work and the one we did get to work does not seem accurate. Any help would be greatly appreciated.
THank you
Terry

Posted : October 7, 2016 1:52 am

Ty

(@thaulk)

Posts: 131

Estimable Member

Topic starter

Terry would you mind sharing what Surescripts gave you?

[email protected]

Posted : October 7, 2016 2:42 am

rwilliams

(@rwilliams)

Posts: 454

Honorable Member

Here is a query from a crystal report I have that returns a list of all portal users and shows the MRN if they are linked. We use externalID for everything so it shows that. You may need to modify DPartner.ServiceType=2 to be something else if you do not use externalid. Also, if you remove the "DPartner.ServiceType is null" it will not show unlinked accounts. Make sure to put your email domain where I put ##PUTYOURDOMAINHERE##

Here is the crystal report. You can not import it into Centricity so you will have to have some way of running Crystal Reports locally. (ie: Crystal Reports, Logicity, etc.)
portalaccounts

Here is the SQL from the report. It is messy because I did not clean up what was written by Crystal Reports.
SELECT DCommunity.Name, KUser.Name, KUser.UserName, KUser.Description, DPartner.ServiceType, KEmailAddress.EmailAddress, KUser.CreationDate, DPartner.Identifier, KEmailAddress.IsDefault FROM Enterprise.dbo.KEmailAddress KEmailAddress INNER JOIN (((Enterprise.dbo.DCommunityAccount DCommunityAccount LEFT OUTER JOIN Enterprise.dbo.DPartner DPartner ON DCommunityAccount.DCommunityAccountKey=DPartner.DCommunityAccountKey) INNER JOIN Enterprise.dbo.DCommunity DCommunity ON DCommunityAccount.DCommunityKey=DCommunity.DCommunityKey) INNER JOIN Enterprise.dbo.KUser KUser ON DCommunityAccount.UserID=KUser.UserID) ON KEmailAddress.UserID=KUser.UserID WHERE (DPartner.ServiceType IS NULL OR DPartner.ServiceType=2) AND KEmailAddress.EmailAddress NOT LIKE '%@##PUTYOURDOMAINHERE##' AND (KUser.Name IS NOT NULL OR KEmailAddress.EmailAddress NOT LIKE '%@%direct%') AND KEmailAddress.IsDefault=1 ORDER BY DCommunity.Name

Posted : October 7, 2016 2:57 am

Share:

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