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

Reset smartlists? Why?

MEL, SQL, Oracle

Last Post by Anonymous 1 second ago

3 Posts

3 Users

0 Reactions

64 Views

RSS

rwilliams

(@rwilliams)

Posts: 454

Honorable Member

Topic starter

The ICD10 Community on ge's website had a post about resetting the smartlist to "relearn" icd-10. They provided a script ( https://data.gehealthcare.com/fs/v.aspx?v=8b6e678e5d6771ba6d) that would do just that. I downloaded the script and all it does is delete every entry out of the mostusedproblem table.

This means that the smartlists will be unusable until the data builds up again. I don't understand why they don't just remove unbillable items in the table. I did a quick search on our table for anything without an icd10 code or with an icd10 code that is not billable and it is only a little more than 10% of the table. I am thinking about just deleting this 10%.

Here is my script to find them. Any thoughts?

SELECT * FROM MOSTUSEDPROBLEM LEFT JOIN ICDSTRUCTURE ON ICDSTRUCTURE.CODEMASTERDIAGNOSISID = MOSTUSEDPROBLEM.ICD10MASTERDIAGNOSISID WHERE ICDSTRUCTURE.LEAF = 0 OR MOSTUSEDPROBLEM.ICD10MASTERDIAGNOSISID IS NULL

Posted : September 25, 2015 5:45 am

bruins1986

(@bruins1986)

Posts: 233

Reputable Member

I think you did the right thing, we were not planning on running that either. That you for sharing your statement to find the ones that should be removed. Thoughts on sharing that with the GE person to see if they will incorporate that into their standard script?

Posted : September 25, 2015 6:22 am

dduschel

(@dduschel)

Posts: 207

Reputable Member

We reset our smart list in test and mine looks just like mine in production but I don't add much to my smart list because I am not adding many problems. I could find many of the OB codes but our OB doctor's couldn't using their smart list. I am going to ask one of them to log into test and try searcing with the reset smart list and see what happens. I will let you know Monday after I test when them.

Posted : September 25, 2015 8:22 am

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