Query check ICD10 trach dxs consistent: Difference between revisions

m only true for acquired dxs, otherwise the dx might still be there but the trach was on previous location; updated query, confirmed it gets run
 
(5 intermediate revisions by the same user not shown)
Line 1: Line 1:
{{Data Integrity Check
{{Data Integrity Check
| DIC_summary = Tracheostomy related CCI and ICD10 codes must be consistent with each other.  
| DIC_summary = Tracheostomy related CCI and ICD10 codes must be consistent with each other.  
| DIC_related_concepts = Tracheostomy, has one; Tracheostomy complication, hemorrhage from site; Tracheostomy complication, malfunction; Tracheostomy complication, NOS; Tracheostomy complication, tracheo-esophageal fistula; Tracheostomy creation
| DIC_related_concepts = Tracheostomy, has one; Tracheostomy complication, hemorrhage from site; Tracheostomy complication, malfunction; Tracheostomy complication, NOS; Tracheostomy complication, tracheo-esophageal fistula; Trach Tube Present (TISS Item)
| DIC_firmness = soft check  
| DIC_firmness = hard check  
| DIC_timing =
| DIC_timing =
| DIC_app = CCMDB.accdb
| DIC_app = CCMDB.accdb
| DIC_coding = Query ''check_ICD10_trach_dxs_consistent''
| DIC_coding = Query ''check_ICD10_trach_dxs_consistent''
| DIC_status = ready to implement
| DIC_status = implemented
| DIC_implementation_date = 2019-01-22
| DIC_implementation_date = 2019-01-22
}}
}}


* if any trach-implying dxs are present then pt must have at least one code that indicates that they have a trach :
* if any trach-implying [[Acquired Diagnoses]] are present then pt must have at least one CCI or ICD10 code that indicates that they have a trach :
** trach-implying dxs
** trach-implying dxs
*** {{ICD10WithCode|Tracheostomy complication, hemorrhage from site}}
*** {{ICD10WithCode|Tracheostomy complication, hemorrhage from site}}
Line 22: Line 22:


== Log ==
== Log ==
* 2023-05-03 - tweaked definition and implemented
* 2022-09-28 - definition tweaked
* 2022-02-10 - reviewed the proposed addition and have concerns, flagged for Julie  
* 2022-02-10 - reviewed the proposed addition and have concerns, flagged for Julie  
* 2019-04-08 - removed [[Tracheostomy care]] (retired code) from this query; changed how it is structured altogether to test new rule
* 2019-04-08 - removed [[Tracheostomy care]] (retired code) from this query; changed how it is structured altogether to test new rule