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

How to determine date of last office visit

MEL, SQL, Oracle

Last Post by Anonymous 1 second ago

4 Posts

4 Users

0 Reactions

68 Views

RSS

joeg1962

(@joeg1962)

Posts: 843

Noble Member

Topic starter

I built a 'check-out' form entry, to guide through the check-out process. Trying to find the date of the most recent office visit (could be signed, but most likely not).

Do not see any MEL to list documents. Is there any function to do this?

Otherwise, thinking to:

(1) LIST_OBS("BP SYSTOLIC","signed","delimited","value")

(2) LIST_OBS("BP SYSTOLIC","unsigned","delimited","value")

(3) review thru both to filter on field 10 (document type) and determine max of field 2 (date)

Has anyone done anything like this? Have any suggestions?

Thanks.

Joe

Posted : November 1, 2017 1:48 am

bhoover

(@bhoover)

Posts: 360

Honorable Member

What you are suggesting makes sense to me. We do something simpler. In our banner we just have Last OV: {LASTOBSDATE("CHIEF CMPLNT")} We make two assumptions:

1. If it's an office visit the chief complaint will be completed every time.

2. The note should be signed. I know that this isn't always true, but we felt that only signed visits should count.

If you need to grab unsigned visits what you are suggesting makes logic sense.

Posted : November 1, 2017 2:23 am

jfitzmd

(@jfitzmd)

Posts: 419

Reputable Member

Similar approach, would need to be modified for your needs, i.e. unsigned encounters. I am assuming obs term "HPI" has been entered. I put all results in a string that is called by a data display. Contact me if you would like to discuss.

/*Retrieve List of Prior Office Visits*/
{fn Retrieve_Visits()
{
local i=0
local strList=""
local strHPI=""
strRetrieveList=""
OVArray1=getField(list_obs("HPI","Signed","Delimited","Value"),"|","")
if size(OVArray1)==0 then
return ""
else
for i=1,i<=size(OVArray1) and i<10,i=i+1 do
OVArray1[i]=getField(OVArray1[i],"^","")
strRetrieveList=strRetrieveList+(if strRetrieveList<>"",",","")+str(i)+"--"+OVArray1[i][2]+" "+OVArray1[i][3]+": "+OVArray1[i][4]+HRET
endfor
endif
return strRetrieveList
}
}

Posted : November 1, 2017 8:57 am

Scott Forest

(@sforest)

Posts: 527

Honorable Member

I agree with the use of either Chief complaint or HPI obsterms. No matter how much you drill it, there are going to be times when BP won't be entered.

Posted : November 2, 2017 3:04 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