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

Patient Portal - Kryptiq

Patient Self Service

Last Post by Anonymous 1 second ago

5 Posts

5 Users

0 Reactions

111 Views

RSS

JBell

(@jbell)

Posts: 285

Honorable Member

Topic starter

We are using the Kryptiq patient portal (their name may have changed) and I am wondering what kind of reporting anyone can get out of it? Our admin would like to be able to report on the number of patients accessing the portal and the number of new patients joining the portal each month. The number of messages the staff receive and respond to and which staff login and are utilizing the portal.

I have reviewed the reports in the user administration area through CPS and find the reports are a bit lacking. I am curious how others are reporting.

Thanks!!

Posted : December 30, 2015 11:37 am

jsander

(@jsander)

Posts: 108

Estimable Member

Built-in reporting is pretty lame.
We run SQL queries on the Enterprise database on the portal's server.

A couple of sample queries:
SELECT KEmailAddress.EmailAddress, KEmailAddress.LastUpdate, KUser.Name, KUser.Description, KUser.LastUpdate AS Expr1, KUser.Identifier, KUser.FirstName,
KUser.MiddleName, KUser.LastName, KUser.LastLogin, KUser.CreationDate, KUser.Flags, KUser.UserName, KUser.NotificationAddress
FROM KUser INNER JOIN
KEmailAddress ON KUser.UserID = KEmailAddress.UserID

SELECT m.ReceivedDate, m.SenderName, m.Sender, m.Subject, mi.IsRead, mi.EmailAddress, mi.RecipientName, mi.OriginalEmail
FROM Message m inner join MessageInstance mi on m.MessageGuid = mi.MessageGuid
WHERE
m.sender = '[email protected]'
and m.MessageStatus = 'MESSAGE_DELIVERED'
and mi.IsSender = '0'
and m.SentDate > '10/18/2015'
ORDER BY m.sentdate desc

Posted : December 31, 2015 4:38 am

bruins1986

(@bruins1986)

Posts: 233

Reputable Member

They do not publish a database guide either so reporting is, unfortunately, a bit of a guess and check endeavor - and very frustrating at times.

We've asked them for it multiple times and have been denied every time.

Posted : December 31, 2015 4:56 am

jamesedward

(@jamesedward)

Posts: 257

Reputable Member

Here's an earlier post where I loaded Crystal Reports that query the Enterprise database. Will require a bit of Crystal skill in order to link the reports to your internal db -- try this and let me know if it doesn't work: https://centricityusers.com/forum/anyone-reporting-on-response-time-for-secure-messaging/

Posted : December 31, 2015 4:17 pm

tcross

(@tcross)

Posts: 165

Estimable Member

Julie
Is that something that you can show me at a time in the near future. As iam not as tech savy as you are?
Thanks
Terry

Posted : January 4, 2016 5:39 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