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:	Query check_ICD10_trach_dxs_consistent
Uses L Problem table:	not relevant for this app
Status:	implemented
Implementation Date:	2019-01-22
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:

• if any of following dxs are present then must have Tracheostomy, has one (Z93.0):
  • 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.