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

SQL to pull Forms patient filled out on Patient Portal

MEL, SQL, Oracle

Last Post by Anonymous 1 second ago

8 Posts

3 Users

0 Reactions

82 Views

RSS

ErnieT

(@erniet)

Posts: 479

Honorable Member

Topic starter

Has anyone created or figured out a way to see what forms a patient has filled out on the patient portal? Is this even possible?

Posted : November 1, 2016 4:39 am

joeg1962

(@joeg1962)

Posts: 843

Noble Member

Are you referring to the Surebridge (formerly Kryptiq) portal?

Posted : November 1, 2016 4:51 am

ErnieT

(@erniet)

Posts: 479

Honorable Member

Topic starter

Yes, the surescripts patient portal

Posted : November 1, 2016 5:08 am

joeg1962

(@joeg1962)

Posts: 843

Noble Member

I never figured out from the SQL, but for the patient forms that flow into Logician documents, I simply run an Inquiry (or Crystal Report) to track.

Others, that become messages, we have the rule to place into a DONE folder. And thus, we can do a count of the DONE folder.

Neither is elegant, but gives us answers.

Posted : November 1, 2016 5:21 am

ErnieT

(@erniet)

Posts: 479

Honorable Member

Topic starter

Yeah. I have something similar to that also but now getting complaints that the patient filled out the paperwork and it showed it was submitted but nothing is coming into the chart. Nothing in LLogic or anywhere else I can find.

I have a case open with Surescripts but they haven't been able to find anything yet. I was hoping that there was some way to look in the SMPP database and see if it tracked what a patient filled out.

Posted : November 1, 2016 5:28 am

joeg1962

(@joeg1962)

Posts: 843

Noble Member

Could there be something odd with a Routing List? I have tried to get away from them so I do not have to continually update them.

I have not heard that issue - missing items. Although a common complaint is that items done by patients do not show up in the 'sent' folder. And I need to explain that the 'sent' folder is for messages, but forms are not processed that way.

Posted : November 1, 2016 7:34 am

ErnieT

(@erniet)

Posts: 479

Honorable Member

Topic starter

First thing I thought of and went back in and tested each doctor and facility and everything went in correctly for my test ones.

Its like they just disappear. At first, I was thinking it is user error but now I have had too many say it has happened so I have to investigate. I will be glad when ver 8 comes out so we will have the save session option.

Posted : November 1, 2016 7:56 am

rwilliams

(@rwilliams)

Posts: 454

Honorable Member

Did you check the audit log in SMPP for that user to see if it has the information in it?

Posted : November 2, 2016 1:57 am

Share:

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