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

Multiple obs term values in one day

MEL, SQL, Oracle

Last Post by Anonymous 1 second ago

5 Posts

2 Users

0 Reactions

65 Views

RSS

ken.takenaka

(@ken-takenaka)

Posts: 212

Reputable Member

Topic starter

I am trying to build a form where I can scroll through instances of obsterms chronologically. The big issue is if there has been more than 1 value entered on a single date to one obsterm. In other words, if a patient sees Dr. A and Dr. B on 6/1/2015 and both Dr. A and Dr. B enter values into the obsterm "HPI INFO 1", what I would like to be able to do is create a form where I can scroll through all instances of HPI INFO 1 for that patient and be alerted if there is more than 1 value for a specific date and have it allow me to choose which instance I would like to use. Any ideas?? Thanks in advance!

Posted : June 18, 2015 5:14 am

blackmanb

(@blackmanb)

Posts: 268

Reputable Member

Use LIST_OBS to get all the signed values of your obsterm.

.

local oList = LIST_OBS('HPI INFO 1','signed','delimited','value')

.

the list that gets returned into oList separates each separate value-row with "|"
and separates each value field within a row with "^"

.

local oArray = getfield(oList,"|","")

local i=0, imax=size(oArray)

local aRow
.

for i=1, i<=imax, i=i+1 do

aRow=getfield(oArray[i],"^","")

// Now you have access to all the values - see below

thisVal = aRow[1]

thisDate = aRow[2]

thisTime = aRow[3]

thisSignedBy = aRow[4]

etc....

endfor

.

[Field #] / Description ( Example )

[1] / Observation Value ( 69 )

[2] / Observation Date ( 01/01/2003 )

[3] / Observation Time ( 5:05:00 PM )

[4] / Signing User ( Jerry Lewis, M.D. / Note. Blank if unsigned)

[5] / Entering User ( Dean Martin )

[6] / Flags ( AA )

[7] / Comment ( Measured with ruler )

[8] / State ( F )

[9] / Location of Care ( Eastside )

[10] / Document Type ( Phone Note )

[11] / Visible Document ID ( 23 )
.
- Beverly

Posted : June 18, 2015 7:46 am

ken.takenaka

(@ken-takenaka)

Posts: 212

Reputable Member

Topic starter

Thanks Beverly,

I have that subarray and I can return those specific values and scroll through them chronologically. I am displaying that in a data display. However, what I would like to have is a watcher expression and a second data display. If there is more than 1 value for a specific date, I would like the second value to be displayed in the second data field.

Posted : June 18, 2015 8:00 am

blackmanb

(@blackmanb)

Posts: 268

Reputable Member

So if you are looping through all values of oList for obsterm "HPI INFO 1",
keep track of the previous date while looping.
Compare current to previous:
if DURATIONDAYS(prevdate, thisdate) = 0
then you have found an instance of the same obsterm stored multiple times on the same date.
.
As you loop, you could build a result string to later parse when populating the data displays,
where each "row" identifies ALL values for a single date.
Example of final result string:
result =
04/15/2015^value1~time1~signedby1
|03/15/2015^value1~time1~signedby1&value2~time2~signedby2
|10/15/2014^value1~time1~signedby1
.
Then when looping through to populate your data display 1,
//Get all rows (|) of dates
dateAry = getfield(result,"|","")
.
// for each date, get its groups of values
for i=1, i<=size(dateAry), i=i+1 do
valueAry = getfield(dateAry[i],"^","")
thisdate = valueAry[1]
.
fieldAry = getfield(valueAry[2],"&","")

//for each group of values (k), get its fields
for k=1, k<=size(fieldAry), k=k+1 do
aRow = getfield(fieldAry[k],"~","")
if k==1 then
//populate data display 1
document.display1_date = thisDate
document.display1_value =aRow[1]
document.display1_time = aRow[2]
document.display1_signedby = aRow[3]
else if k==2 then
//populate data display 2
document.display2_date = thisDate
document.display2_value =aRow[1]
document.display2_time = aRow[2]
document.display2_signedby = aRow[3]
endif // data display 2
endif // data display 1
endfor // k loop thru values
endfor // i loop thru dates
.
The above is off the top of my head, but that is the concept...
.
- Beverly

Posted : June 18, 2015 11:26 am

ken.takenaka

(@ken-takenaka)

Posts: 212

Reputable Member

Topic starter

awesome that is great advice! I have been trying to use the match data symbol but using the durationdays seems much more economical. And building the result string; had not thought of that. Thank you so much, I will give this a try!

Posted : June 18, 2015 1:04 pm

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