Query check ICD10 trach dxs consistent: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) 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) |
|||
| (22 intermediate revisions by 2 users 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; | | 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 = hard check | | DIC_firmness = hard check | ||
| DIC_timing = | | DIC_timing = | ||
| DIC_app = CCMDB. | | DIC_app = CCMDB.accdb | ||
| DIC_coding = Query ''check_ICD10_trach_dxs_consistent'' | | DIC_coding = Query ''check_ICD10_trach_dxs_consistent'' | ||
| DIC_status = implemented | | DIC_status = implemented | ||
| Line 10: | Line 10: | ||
}} | }} | ||
* if any trach-implying | * 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 17: | Line 17: | ||
*** {{ICD10WithCode|Tracheostomy complication, tracheo-esophageal fistula}} | *** {{ICD10WithCode|Tracheostomy complication, tracheo-esophageal fistula}} | ||
** code that indicates that they have a trach | ** code that indicates that they have a trach | ||
*** CCI - | *** CCI - {{CCIWithCode| Tracheostomy creation}} | ||
*** ICD10 - {{ICD10WithCode|Tracheostomy, has one}} | *** ICD10 - {{ICD10WithCode|Tracheostomy, has one}} | ||
*** TISS - {{TISS w Nr | Trach Tube Present (TISS Item)}} | |||
* | |||
** | |||
== Log == | == Log == | ||
* 2019-04-08 - removed [[Tracheostomy care]] from this query; changed how it is structured altogether to test new rule | * 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 | |||
* 2019-04-08 - removed [[Tracheostomy care]] (retired code) from this query; changed how it is structured altogether to test new rule | |||
* 2019-03-20 - previously this also required one of the above if "has one" was present, but that makes no sense, because one could be present without additional care requirements, so have taken that part out. Ttenbergen 12:45, 2019 March 20 (CDT) | * 2019-03-20 - previously this also required one of the above if "has one" was present, but that makes no sense, because one could be present without additional care requirements, so have taken that part out. Ttenbergen 12:45, 2019 March 20 (CDT) | ||
== Related articles == | |||
{{Related Articles}} | |||
[[Category:Tracheostomy]] | [[Category:Tracheostomy]] | ||
[[Category:ICD10 Dx check]] | [[Category:ICD10 Dx check]] | ||
[[Category:CCI Px check]] | [[Category:CCI Px check]] | ||
[[Category:TISS28 check]] | |||
Latest revision as of 10:38, 2023 May 3
| Data Integrity Checks | |
| Summary: | Tracheostomy related CCI and ICD10 codes must be consistent with each other. |
| Related: | Tracheostomy, has one, Tracheostomy complication, hemorrhage from site, Tracheostomy complication, malfunction, Tracheostomy complication, NOS, Tracheostomy complication, tracheo-esophageal fistula, Trach Tube Present (TISS Item) |
| Firmness: | hard check |
| Timing: | |
| App: | CCMDB.accdb |
| 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 |
- 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
- code that indicates that they have a trach
- CCI - Tracheostomy creation (1.GJ.77)
- ICD10 - Tracheostomy, has one (Z93.0)
- TISS - T23 - Trach Tube Present (TISS Item)
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
- 2019-04-08 - removed Tracheostomy care (retired code) from this query; changed how it is structured altogether to test new rule
- 2019-03-20 - previously this also required one of the above if "has one" was present, but that makes no sense, because one could be present without additional care requirements, so have taken that part out. Ttenbergen 12:45, 2019 March 20 (CDT)