ICD10 Dx sorting issues
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)
|
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.