Query check ICD10 Inf Infection req Pathogen must have one

Data Integrity Checks
Summary:	every dx in Category:Infection requiring pathogen must have a dx in Category:Pathogen as Combined ICD10 codes and vice versa.
Related:	[[Category:Infection requiring pathogen, Category:Pathogen, Combined ICD10 codes, Infections in ICD10]]
Firmness:	hard check
Timing:	always
App:	CCMDB.mdb
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

• Cargo

• SMW

"CCMDB.mdb" is not in the list (SAP, not entered, Centralized data front end.accdb, DSM Labs Consistency check.accdb, CCMDB.accdb, TISS28.accdb) of allowed values for the "DICApp" property. Property "DICRelatedConcepts" (as page type) with input value "Category:Infection requiring pathogen]], Category:Pathogen, Combined ICD10 codes, [[Infections in ICD10" contains invalid characters or is incomplete and therefore can cause unexpected results during a query or annotation process.

• Categories:  

• form:

Steps to implement:

1. make sure the listings in the following categories are correct:
   • Category:Infection requiring pathogen
   • Category:Pathogen
2. make structure in CCMDB.mdb for dx categories
3. export categories from wiki and import into CCMDB.mdb
4. implement checks