Notifications
Clear all
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
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
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
