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:	ready to implement
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.

Categories:

form:

	ready to be set up but not absolutely necessary for go-live.

if any of following dxs are present then must have Tracheostomy, has one:
- ICD10
  - Tracheostomy care (Z43.0)
  - (Tracheostomy complication, hemorrhage from site)
  - (Tracheostomy complication, malfunction)
  - (Tracheostomy complication, NOS)
  - (Tracheostomy complication, tracheo-esophageal fistula)
- CCI
  - Tracheostomy creation to this mix.