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:	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 "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: