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

Get Patient's Last Appt

Trading Post

Last Post by Anonymous 1 second ago

3 Posts

2 Users

0 Reactions

58 Views

RSS

mikeseale

(@mikeseale)

Posts: 344

Reputable Member

Topic starter

I'm working on a form, and I need to logically figure out when the last time this patient visited a clinic (in our database). I've been working with find() and using the mldefs as a guide, but I haven't had much luck yet. Here is what I am currently trying to use:

find("_CurPatientAppointment", "ApptStart", "OwnerId", PATIENT.PATIENTID)

From my understanding of the find function, this would search the object _CurPatientAppointment for ApptStart associated with OwnerId = PATIENT.PATIENTID; however, I'm having zero luck getting anything to return. I'm tempted to just use office visit CPT Codes in past orders to go by, but I don't want to give up on find().

Something I've noticed is that if I were to query this in the database, I would have multiple results come up if the patient had more than one appt in the past (which would be 99% of the time). Maybe this is somehow affecting the results from showing.

Posted : April 17, 2012 5:13 am

mikeseale

(@mikeseale)

Posts: 344

Reputable Member

Topic starter

APPT_PRIOR() works in this situation (just forgot about it). I would still like to understand why find() wasn't working for me, there are a few other situations I'm needing to use it in.

Posted : April 17, 2012 5:47 am

Stacey LaGrange

(@slagrang)

Posts: 185

Reputable Member

We use the code below in usrlib.txt to show last arrived appt, the only problem is that am and pm may not work correctly between noon and 12:59 pm.

//APPT (PRIOR) FUNCTION

fn SMRMC_APPT_PRIOR() {
                local a, b,c, loc, atype, book
                local result=''
                local i = getRowCount('_MELCurPatientAppt')
    // Loop thru patients appointments
                while i > 0 do
                   i = i-1
                       a = getRow('_MELCurPatientAppt',i,'ApptDate', 'ApptTime',
                      'Appttype','Booklist','ApptStatus')
           // Find the last appointment
           if val(a[1]) < ._TODAYSDATE and val(a[5]) = 3 then
               // Get the type of appointment
               atype = find('_MELApptDef', 'ApptType', 'ID', a[3])
               // Get the location of care from the first book
               b = getfield(a[4],',',' :')
               loc = find('_MELBook', 'LocationAbbrevName', 'ID', b[1])
               //Get the Book Name
                       c = getfield(a[4],',',' :')
               book = find('_MELBook', 'Name', 'ID',
c[1])
               // Build the result
                           result = a[1] + ',' + appttime(a[2]) + ',' + atype + ',' + loc + "," + book
               break
           endif
                endwhile
                result
}

Stacey LaGrange
Software Developer/Analyst
St. Mary's Health System
[email protected]
(207) 777-8410

Posted : April 18, 2012 9:42 pm

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