ICD10 Dx sorting issues: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
m (Text replacement - "CCMDB.mdb" to "CCMDB.accdb")
mNo edit summary
 
(One intermediate revision by the same user not shown)
Line 1: Line 1:
The ICD10 tab in [[CCMDB.accdb]] sorts somewhat inconveniently. This is not really a bug as much as it is awkward functionality. {{Bug}}
The ICD10 tab in [[CCMDB.accdb]] sorts somewhat inconveniently. This is not really a bug as much as it is awkward functionality. {{fixed bug}}


The ICD10 tab by default sorts ICD10 dxs as follows:  
The ICD10 tab by default sorts ICD10 dxs as follows:  
Line 9: Line 9:


== Team input ==
== Team input ==
{{Discuss |
What does everyone think, would this be a possible and worthwhile thing to add? Am I missing something and there would be an easier way to do this? Ttenbergen 10:57, 2018 August 2 (CDT)
What does everyone think, would this be a possible and worthwhile thing to add? Am I missing something and there would be an easier way to do this? Ttenbergen 10:57, 2018 August 2 (CDT)
* This is an older discussion and I think the form has changed since. Do we still have sorting issues in the ICD10 form? If I don't hear anything I will set this to fixed and clear this out in a month or so. Ttenbergen 21:14, 2019 March 9 (CST) }}
* This is an older discussion and I think the form has changed since. Do we still have sorting issues in the ICD10 form? If I don't hear anything I will set this to fixed and clear this out in a month or so. Ttenbergen 21:14, 2019 March 9 (CST)  
** Never heard back Ttenbergen 17:29, 2019 November 7 (CST)


== Possible solutions ==
== Possible solutions ==

Latest revision as of 18:31, 2019 November 7

The ICD10 tab in CCMDB.accdb sorts somewhat inconveniently. This is not really a bug as much as it is awkward functionality.


The ICD10 tab by default sorts ICD10 dxs as follows:

  • by Dx Type
  • by Dx Priority
  • I thought it also sorted them alphabetically inside this, but turns out it does not; it would be easy to add that as a third level sort.

This means that lines that are Combined ICD10 codes do not show up in an order that intuitively makes sense, e.g. for infections you would first want to see what the infection is, then the pathogen, then any resistance to antibiotics. Fixing this is perhaps surprisingly hard: for the computer to sort data it needs to have a field it can sort by, and there is no field that declares "intuitively this should be first". So, if we wanted to improve this, we would have to add a column to the s_ICD10 table that contains all ICD10 codes and add numbers to it that would lead to correct sorting in all cases. But because of the way we define what can be combined in Combined ICD10 codes, the list of possibly combined codes is hard to pin down. Also, implementing this would mean someone has to go through all 1800+ codes and add these numbers.

Team input

What does everyone think, would this be a possible and worthwhile thing to add? Am I missing something and there would be an easier way to do this? Ttenbergen 10:57, 2018 August 2 (CDT)

  • This is an older discussion and I think the form has changed since. Do we still have sorting issues in the ICD10 form? If I don't hear anything I will set this to fixed and clear this out in a month or so. Ttenbergen 21:14, 2019 March 9 (CST)
    • Never heard back Ttenbergen 17:29, 2019 November 7 (CST)

Possible solutions

Dx Primary to the top

Change sorting so that the line with Dx Primary checked always sorts to the top. This would be easy to do but would single out that one dx from how everything else is sorted, ie not intuitive.