Query check ICD10 trach dxs consistent

Data Integrity Checks
Summary:	Tracheostomy related CCI and ICD10 codes must be consistent with each other.
Related:	[[Tracheostomy, has one, Tracheostomy care, Tracheostomy complication, hemorrhage from site, Tracheostomy complication, malfunction, Tracheostomy complication, NOS, Tracheostomy complication, tracheo-esophageal fistula, Tracheostomy creation]]
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 (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, [[Tracheostomy creation" contains invalid characters or is incomplete and therefore can cause unexpected results during a query or annotation process.

• Categories:  

• form:

• 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

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