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 (J95.00)
  - Tracheostomy complication, malfunction (J95.02)
  - Tracheostomy complication, NOS (J95.08)
  - Tracheostomy complication, tracheo-esophageal fistula (J95.03)
- CCI
  - Tracheostomy creation to this mix.