Controlling Dx Type for ICD10 codes

Data Integrity Checks
Summary:	Some dxs can't be Dx Types Primary Admit Diagnosis, Comorbid Diagnosis, Admit Diagnosis or Acquired Diagnosis
Related:	ICD10 Diagnoses, Primary Admit Diagnosis, Comorbid Diagnosis, Admit Diagnosis, Acquired Diagnosis, Dx Type
Firmness:	hard check
Timing:	complete
App:	CCMDB.accdb
Coding:
Uses L Problem table:	not relevant for this app
Status:	declined
Implementation Date:
Backlogged:	true

• Cargo

• SMW

• Categories: 

• form:

After considerable discussion over years it was decided that this would be very complicated to implement and that the effort wouldn't bring enough positive results to be worth it.

See proposed solution and discussion

Decision to decline Allan, Barret and Lisa and some collectors all at some point tried to generate the reference list for this. In all cases, a lot of it is almost trivial, but for some of it the decisions are almost impossible. The ultimate reason to decline was because the use of diagnoses as part of Combined ICD10 codes means they might be used for just about anything to express an unusual situation, and we want to be able to use them for this. So, we decided the cross checks would not be worth it. Decision made Task_Team_Meeting_-_Rolling_Agenda_and_Minutes_2023#ICU Database Task Group Meeting – April 19, 2023. Proposed Solution Encode which codes can not be of a particular type; this will likely be fewer checks, and it will also likely be an easier and more deterministic answer without ifs-thens-buts; it will be a slightly less tight check but with fewer false positives. Add three columns to the s_ICD10 table: comorbid_not_allowed (Comorbid Diagnosis) admit_not_allowed (Admit Diagnosis acquired_not_allowed (Acquired Diagnosis) primary_not_allowed (Primary Admit Diagnosis) 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