Notifications
Clear all
Topic starter
Would anyone be able to share the data dictionary with us, for Kryptiq Patient Portal database, if it exists? We couldn't find it in the GE website.
If that doesn't exist does someone know a column that we could use to join Centricity Patients with Patient Portal patients in SQL?
We would appreciate any help.
Thanks
Posted : August 1, 2017 1:38 pm
I have asked GE/Kryptiq/Enli for a data dictionary in the past. I can't recall the reasoning behind the "no" answer, but it was definitely a "no".
One way to join CPS and the Patient Portal in SQL is [Enterprise].[KUser].[EmailAddress] = [CentricityPS].[PatientProfile].[EmailAddress]
Posted : August 2, 2017 1:31 am
I answered this question here:
https://centricityusers.com/forum/portal-query/#answer-185765
I also included a crystal report. You would probably need to run the report directly from Crystal (it wouldn't be able to run within EMR)
The data with the patient ID information is in the dpartner table.
Posted : August 2, 2017 10:21 am
Would you mind re-posting this answer or email me directly.
Posted : December 20, 2018 5:14 am
Looks like the URL for the forum updated at some point. Below are the updated links.
https://forum.centricityusers.com/forum/portal-query/#answer-185765
https://forum.centricityusers.com/wp-content/uploads/logged_in/PortalAccounts.rpt
Posted : December 20, 2018 5:21 am
