Notifications
Clear all
Topic starter
Good morning,
I'm trying to pull in the date of the last observation value for the obsterm "MICRALB RANU". I'm using this:
{LASTOBSDATE("MICRALB RANU")}
The patient definitely has this value in the flowsheet. I even updated the obsterm in a test patient and tried it out, and it's coming up null. It seems like some type of glitch with the database or something. I've double checked that the obsterm doesn't share an HDID with any other obsterm.
Has anyone ever seen this issue before?
Any help would be appreciated. Thanks!
Sarah
Posted : February 11, 2014 12:29 am
Are you sure there is a space between the 2 words? If someone has changed the display name on the flowsheet, it may not in fact be the actual obsterm you need to pull the selected data.
Posted : February 11, 2014 12:42 am
Topic starter
Positive. I've double checked the display name and everything.
Posted : February 11, 2014 12:44 am
Try without the space. I think it is "MICRALBRANU".
Posted : February 11, 2014 12:44 am
The obsterm has 2 variants. one with a space MICRALB RANU and the other MICRALBRANU. I would try the other one.
Posted : February 11, 2014 12:47 am
Since you said that you have checked the Display Name, are you referring to the name in the Flowsheet View? Those can be changed, or maybe you knew that.
One way to determine the actual OBS CODE is to find the document that is attached to the creation of the OBS value entry, right-click on the document, and then click to view 'clinical list changes'.
This is what I see in OBSHEAD:
| HDID | NAME | DESCRIPTION | UNIT | MLCODE |
| 330.00 | MICROALB URN | microalbumin/total urine volume | mg/L | LOI-1754-1 |
| 7,682.00 | MICROALB COM | microalbumin, urine, comments | MLI-7682 | |
| 13,557.00 | MICROALB TST | microalbumin, urine | mg/dL | MLI-13557 |
| 17,242.00 | MICROALB/CRE | microalbumin/creatinine ratio, urine | mg/g | MLI-17242 |
| 23,575.00 | MICROALBRANU | microalbumin, random, urine | mcg/mL | MLI-23575 |
Posted : February 11, 2014 12:47 am
Topic starter
The obsterm has several variants, and the issue is that our labs have been sending values to each one, so when we build our forms, we have to take this into consideration with data displays and such.
I've checked the Display Name in the sense that it is not a customized display name that is different from the obsname. It is the actual observation name. I've viewed Clinical List Changes, and the obsterm that was updated for that document is exactly "MICRALB RANU" with the space.
It's really throwing me for a loop! But thanks for these suggestions!
Posted : February 11, 2014 12:58 am
Topic starter
The HDID I got was 21974.
Posted : February 11, 2014 1:00 am
What does a MEL trace show? Have you just tried it in a quick text with the same result - no date?
Posted : February 11, 2014 1:30 am
Topic starter
The LASTOBSDATE("MICRALB RANU") is part of a function that is supposed to pull the latest value from a series of obsterms. In this case, MICRALB RANU is the latest value, yet it's pulling an older value from the obsterm "MICROALBRANU".
I tried using this function in a letter, and it works perfectly; it's pulling the value from MICRALB RANU. However, when I use the function in my VFE form, it's pulling the older value from MICROALBRANU.
The related section of a MEL trace says this:
02/11/2014 11:49:08.273-execute> Array[1]
02/11/2014 11:49:08.273-results> "MICRALB RANU"
02/11/2014 11:49:08.273-execute> call LASTOBSDATE("MICRALB RANU")
02/11/2014 11:49:08.273-results> ""
02/11/2014 11:49:08.273-execute> "" <> ""
02/11/2014 11:49:08.273-results> FALSE
Posted : February 11, 2014 1:42 am
