Notifications
Clear all
Topic starter
Is there a way to have a document variable go to two separate obs terms? Or assign a value from one obs term to another? Here's the debacle: We have two separate forms that are collecting a date as an observation value for what is ultimately the same thing, but they were inadvertantly set to go to two separate obs terms. Both obs terms have a ton of patients that have data going to them, so clean up would be a nightmare.
I know that I can assign a variable to another variable with this: {DOCUMENT.VARIABLE1 = DOCUMENT.VARIABLE2}, but it doesn't appear to work with obs terms replacing the variables.
Any other thoughts on the best way to handle this?
Posted : January 7, 2016 2:51 am
You could do
{OBSNOW("OBSTERM1",OBSNOW("OBSTERM2"))}
Or...
{OBSNOW("OBSTERM1",DOCUMENT.VARIABLE1)}
{OBSNOW("OBSTERM2",DOCUMENT.VARIABLE1)}
Good Luck!
Posted : January 7, 2016 4:11 am
Topic starter
I used option 2! Thanks so much Michael!
Posted : January 7, 2016 5:30 am
I know that you said clean up would be a nightmare, but have you considered doing clean up with an SQL script? I have moved more than one set of values from one Obs Term to another Obs Term and we have a 600 GB database and it processes real quick.
update o
set o.HDID = '22766'
from OBS o
where o.HDID = '70586'
I just placed in 2 numbers at random, but the 22766 represents the HDID of the Obs Term you want to move all of your values to and the 70586 represents the HDID of the Obs Term you want to move the values from.
Posted : January 7, 2016 5:45 am
The first approach is the simplest and safest. You must be very comfortable executing an update query on your production data base, and if you are very conservative, create a backup of the database, execute the query in off hours. In any event, ....... the key is to change your obs terms to a single term.
Posted : January 7, 2016 6:21 am
Topic starter
Thank you, all, I appreciate the help! I will talk to my director about the clean up option, but for now, I've at least got the value going to both obs terms. 🙂 Thanks again!
Posted : January 7, 2016 6:27 am
