CCMDB Wiki

Query check ICD10 trach dxs consistent: Difference between revisions

← Older edit
mNo edit summary
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
 
(8 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
}}
}}
----
*The following had been added some time ago
::*This can now include:
::* if there is a {{ICD10WithCode|Tracheostomy, has one}} ICD10, there needs to be a {{TISS w Nr | Trach Tube Present (TISS Item)}} for at least the first day
::* if there is an [[Acquired Procedure]] of {{CCIWithCode| Tracheostomy creation}}, there has to be a {{TISS w Nr | Trach Tube Present (TISS Item)}} for at least the [[Px Date]]
* This is actually not so. Pt could have the ostomy with no tube in it. Definitely possible for the first one, less likely for the second, but still more likely than I would like to put a check in place. If you are OK with leaving the check out, we should still include a remnant of this discussion so we don't need to have it again. If you want to re-visit, please bring it to JALT or Task. [[User:Ttenbergen|Ttenbergen]] 16:51, 2022 February 10 (CST)


{{Todo
* 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 :
| who = Tina 
| question = 
* first one can happen, should be soft check; second one can never happen.
| todo_added = 2022-02-17
| todo_action = 2022-02-17
}}
-----
 
* if any trach-implying dxs are present then pt must have at least one 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 37: 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
Retrieved from "https://ccmdb.kuality.ca/index.php?title=Query_check_ICD10_trach_dxs_consistent"