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

Link a note to an appointment SQL

MEL, SQL, Oracle

Last Post by Anonymous 1 second ago

2 Posts

2 Users

0 Reactions

51 Views

RSS

rfisher

(@rfisher)

Posts: 126

Estimable Member

Topic starter

Anyone have an update query to link a Chart note to an appointment for when a provider forgets this step when starting their note?

Posted : May 20, 2015 2:41 am

rwilliams

(@rwilliams)

Posts: 454

Honorable Member

It would be a manual process because you would need to lookup the appointment visitid and the document.

To find the VISITID you could perform a query like this:

SELECT RPTAPPT.VISITID, RPTAPPT.APPTDATE, BOOK.NAME, PERSON.SEARCHNAME, PERSON.DATEOFBIRTH FROM RPTAPPT INNER JOIN BOOK ON RPTAPPT.BOOKID = BOOK.ID INNER JOIN PERSON ON PERSON.PID = RPTAPPT.PID WHERE UPPER(PERSON.SEARCHNAME) LIKE 'TEST, ANGELA%' ORDER BY APPTDATE DESC

You would probably want to search for something other than the patient by name, we would use PERSON.EXTERNALID to search for a particular patient. The query above would return a list of all of that patients appointments and which appt book it was in. The VISITID from the appropriate appt would neet to be put into the documents table.

To find the document try something like this:
SELECT DOCUMENT.SDID, PERSON.PID, PERSON.SEARCHNAME, PERSON.DATEOFBIRTH, DOCTYPES.ABBR, DOCUMENT.SUMMARY, USRINFO.SEARCHNAME PROVIDER, ML.CONVERT_ID_TO_DATE(CLINICALDATE) CLINICALDATE FROM DOCUMENT INNER JOIN PERSON ON DOCUMENT.PID = PERSON.PID INNER JOIN DOCTYPES ON DOCTYPES.DTID = DOCUMENT.DOCTYPE INNER JOIN USRINFO ON DOCUMENT.USRID = USRINFO.PVID WHERE DOCTYPES.ABBR LIKE 'Ofc Visit' AND UPPER(PERSON.SEARCHNAME) LIKE 'TEST, ANGELA%' AND DOCUMENT.VISITID IS NULL AND DOCUMENT.XID = 100000000000000000000000000000000000 ORDER BY CLINICALDATE DESC

What we need is the document SDID and, just in case, the PERSON.PID in the documents table for the appropriate note. These are both 16 digit numbers.

The update would look something like this: (replace the <> and everything in between with the appropriate info)

UPDATE DOCUMENT SET VISITID = '<VISITID>' WHERE SDID = '<SDID>' AND PID = '<PID>'

Posted : May 20, 2015 4: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