Query check ICD10 trach dxs consistent

Data Integrity Checks
Summary:	* if any of following dxs are present then must have Tracheostomy, has one: Tracheostomy care Tracheostomy complication, hemorrhage from site Tracheostomy complication, malfunction Tracheostomy complication, NOS Tracheostomy complication, tracheo-esophageal fistula if Tracheostomy creation, then must have Tracheostomy, has one
Related:	[[Tracheostomy, has one, Tracheostomy care, Tracheostomy complication, hemorrhage from site, Tracheostomy complication, malfunction, Tracheostomy complication, NOS, Tracheostomy complication, tracheo-esophageal fistula]]
Firmness:	hard check
Timing:
App:	CCMDB.mdb
Coding:
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 (CCMDB.accdb, Centralized data front end.accdb, TISS28.accdb, SAP, DSM Labs Consistency check.accdb, not entered) of allowed values for the "DICApp" property. Property "DICRelatedConcepts" (as page type) with input value "Tracheostomy, has one]], Tracheostomy care, Tracheostomy complication, hemorrhage from site, Tracheostomy complication, malfunction, Tracheostomy complication, NOS, [[Tracheostomy complication, tracheo-esophageal fistula" contains invalid characters or is incomplete and therefore can cause unexpected results during a query or annotation process.

• Categories:  

• form:

Template:Discussion we may want to add CCI Tracheostomy creation to this mix.