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 (CCMDB.accdb, Centralized data front end.accdb, TISS28.accdb, SAP, DSM Labs Consistency check.accdb, not entered) of allowed values for the "DICApp" property. 

• Categories: 

• form:

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

• SMW

• Cargo

• Categories

• 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.