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 (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:
  • 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

we may want to add CCI Tracheostomy creation to this mix. Yes add this. --JMojica 11:46, 2018 November 23 (CST)

• SMW

• Cargo

• Categories