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

Changing HDID in obs table

MEL, SQL, Oracle

Last Post by Anonymous 1 second ago

6 Posts

2 Users

0 Reactions

82 Views

RSS

amaskey

(@amaskey)

Posts: 88

Estimable Member

Topic starter

We have two labs sending result to two different obs terms for the same lab. We have updated the link logic mapping so everything goes to same obs term going forward.

Can I update obs table and change just the HDID to move those results to new obs terms?

Posted : December 19, 2018 7:26 am

jryan

(@jryan)

Posts: 119

Estimable Member

I have done this with a few of ours. As long as you can find the right ones to move, it should be no problem. As in, if you have other valid values attached to that hdid, you need to identify only the ones you want to assign to the other hdid. We have had a few where we wanted to move all values and some where we needed to be selective. In our case, when being selective on the labs, I queried for the obs attached to documents with the summary line that the labs came in under. I can send you some statements I have used as examples if needed and maybe try it in a test system first.

Posted : December 19, 2018 7:34 am

amaskey

(@amaskey)

Posts: 88

Estimable Member

Topic starter

Thank you quick response @jryan. I would appreciate if you could send me the statements you used.

Posted : December 19, 2018 8:03 am

jryan

(@jryan)

Posts: 119

Estimable Member

Here is an example of when the mammogram obs term was changed by GE without anyone realizing and our mammos were coming in via the interface unmapped. When GE imports one unmapped it assigns hdid of -1. Anything with -- before it is a comment (like in the first 2 I put a comment so I knew which hdid to use later). We had interfaced values and indexed values and summary lines are case sensitive so I had to use a mix of cases in my statements but I only provided one example here. The summary line is really important as we wouldn't want ALL unmapped values to be set to the mammo obs term. Let me know if that doesn't make sense or need something else. Thx. Jen

--find the hdid values you need
select * from obshead where name like 'MAMMOGRAM%' --hdid is 71 cpt 77055
select * from obshead where name='ZZ-GE-unk' -- hdid is -1

--a few stmts you can use to check counts to see how many are affected
select count(*) from obs where hdid='-1' and sdid in (select sdid from document where summary like'%MAMMO%')
select count(*) from obs where hdid='-1' and sdid in (select sdid from document where summary like'%mammo%'and db_create_date between '25-OCT-17' and '26-JUL-18')

--stmt to view the obs you plan to update to make sure you have the right ones
select * from obs where hdid='-1' and sdid in (select sdid from document where summary like '%MAMMO%')

--stmt to update the obs from one value to another
update obs set hdid='71' where hdid='-1' and sdid in (select sdid from document where summary like '%MAMMO%')
--if number of rows is correct, commit, if not rollback
commit

Posted : December 19, 2018 2:13 pm

jryan

(@jryan)

Posts: 119

Estimable Member

Also, I typically try it in test first and back up my obs table before I run the update just in case.

Posted : December 19, 2018 2:14 pm

amaskey

(@amaskey)

Posts: 88

Estimable Member

Topic starter

Thank you @jryan. happy holidays

Posted : December 21, 2018 2:14 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