Controlling Dx Type for ICD10 codes
Data Integrity Checks | |
Summary: | Controlling Dx Type for ICD10 codes |
Related: | ICD10 Diagnoses |
Firmness: | hard check |
Timing: | complete |
App: | CCMDB.accdb |
Coding: | how to find this in containing program, eg. SAS file, function name, query name... |
Uses L Problem table: | not relevant for this app |
Status: | needs review |
Implementation Date: | date change was rolled out / first applied |
Backlogged: | true |
Many of the items on the ICD10 Diagnosis List are not suitable as certain Dx Types.
Examples:
- Severe sepsis, VAP, recurrent Pneumonia should never be a Comorbid Diagnosis
- Past history, removal of breast (mastectomy) should never be an Acquired Diagnosis / Complication or Admit Diagnosis
- many more
We would like a way to detect when such inconsistencies happen.
Proposed Solution 1
- Add three columns to the s_ICD10 table:
- como_not_allowed
- admit_not_allowed
- acquired_not_allowed
- populate the columns
- default answers: NO in comorbid and YES in Admit, Acquired
- put cross checks into CCMDB.accdb to prevent bad entries
why do this change outside the wiki?
The change will require editing every single record in the ICD10 Diagnosis List, so doing it on the wiki would be time-prohibitive. If we do it externally the new fields would be imported into the wiki, which would then again be the master repository for this.
- We will use a tool like AutoWikiBrowser] or similar to get the changes integrated into pages.
Implementation
It was decided that this is worth doing, and that the above is a reasonable way to do it. Allan is working on generating the list.
If we do this, should we do more?
- Discussed but rejected possibility to restrict impossible dx / sex field combinations.
- this would be the right time to also fix/implement the following:
- is_pathogen: see Category:Infection requiring pathogen
- pathogen requirement (see Category:Infection requiring pathogen, Category:Infection requiring pathogen, Category:Potential infection)
- min nr of combined codes field