Query NDC TISS CCI endoscopic: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
← Older edit
Ttenbergen (talk | contribs)
CCMDB_legit, admin, approved, Bureaucrats, Interface administrators, Administrators (Semantic MediaWiki), Curators (Semantic MediaWiki), Administrators
92,608 edits
m Ttenbergen moved page Check Bronchoscopy/Laryngoscopy vs TISS28/43 to Check CCI Endoscopic inspection/exploration vs Scope in ICU (T43) without leaving a redirect: no longer just about bronchoscopy
m Text replacement - "|DIC_LProblem=no" to "|DIC_LProblem=No"
 
(13 intermediate revisions by the same user not shown)
Line 1: Line 1:
{{LegacyContent
|explanation=No longer collecting [[Endoscopy (TISS Item)]], so nothing to check
|content= 
{{Data Integrity Check
{{Data Integrity Check
|DIC_summary=If pt has [[TISS28]] item [[Endoscopy (TISS Item)|Endoscopy (any type of scope) in the ICU]] (T43) then there must be an endoscopic CCI for that day.
|DIC_summary=If pt has {{TISS w Nr | Endoscopy (TISS Item)}} then there must be an endoscopic CCI for that day.
|DIC_related_concepts=Endoscopy (TISS Item); Bronchoscopy/Laryngoscopy
|DIC_related_concepts=Endoscopy (TISS Item); ERCP (endoscopic retrograde cholangiopancreatography); Inspection, Exploration (endoscopic); Biopsy (endoscopic)
|DIC_firmness=hard check
|DIC_firmness=hard check
|DIC_timing=complete
|DIC_timing=complete
|DIC_status=needs review
|DIC_coding=query ''NDC_TISS_CCI_endoscopic''
|DIC_implementation_date=2019/01/06
|DIC_status=retired
|DIC_LProblem=No
|DIC_LProblem=No
|DIC_app=Centralized data front end.accdb
|DIC_app=Centralized data front end.accdb
}}
}}
== TISS28 item T43 without Bronchoscopy/Laryngoscopy dx ==
TISS28 refers to ''any'' scope, so dx 779 is not required at the same time.
and dx797.


== Bronchoscopy/Laryngoscopy dx without TISS28 entry 43 ==
This query is retired because {{TISS w Nr | Endoscopy (TISS Item)}} is no longer regularly collected.  
{{Discussion}} Is there a scenario where this would be allowed? "I just looked up Laryngoscopy [http://en.wikipedia.org/wiki/Laryngoscopy]. It doesn't seem to require any endoscopy." That would mean if a laryngoscopy was done, a fill endoscopy might not have been. If this were possible, this check would give false-positives. If not possible then this half of the test could be implemented.  


{{Discuss | who=Allan | question = Will we want this cross-check in ICD10/CCI? If so what will be the details? The relevant codes are likely [[(T) Glottis, Larynx, Related Structures]], [[(T) Bronchi]] [[Inspection, Exploration (non-endoscopic)]], [[Inspection, Exploration (endoscopic)]]. Ttenbergen 00:15, 2017 December 12 (CST)}}
== CCI without T43 ==
If there is at least one [[#Endoscopic CCI]] on a day, then {{TISS w Nr | Endoscopy (TISS Item)}} must be marked for that day.


*The Bronchoscopy/Laryngoscopy dx are old codes.  If we want to do this in acquired CCI vs  [[TISS28]] item [[Endoscopy (TISS Item)|Endoscopy (any type of scope) in the ICU]],  we can say, if  [[Inspection, Exploration (endoscopic)]] or [[Biopsy (endoscopic)]] is present in acquired CCI_2 regardless of the body part in CCI_1 then [[TISS28]] item [[Endoscopy (TISS Item)|Endoscopy (any type of scope) in the ICU]] should be marked  and vice versa. --[[User:JMojica|JMojica]] 14:12, 2018 November 13 (CST) 
== T43 without CCI - can't be checked ==
Many of the CCIs are not defined as endoscopic or not, just as what was accomplished (e.g. [[Extraction ]]), so we will not be able to check that all T43 have a matching CCI.  


== Endoscopic CCI ==
We only track the route of procedures in a few exceptional cases:
* [[ERCP (endoscopic retrograde cholangiopancreatography)]]
* [[Inspection, Exploration (endoscopic)]]
* [[Biopsy (endoscopic)]]
See also
{{ListCCICategory | categoryName = Endoscopic Px}}


[[Category: TISS28 checks]]
== Log ==
[[Category: CCI Px check‎‎]]
* 2020-12-02 - retired query as part of [[Change to collect TISS data in CCI Picklist]]
* 2019-09-11 - updated component query "has_TISS_43_endoscopic_px" to actually look for TISS43, was looking for 42.
 
}}
[[Category:Legacy CCI Px check‎]]
[[Category:Legacy TISS28 check]]

Latest revision as of 23:13, 22 July 2025

Legacy Content

This page contains Legacy Content.

  • Explanation: No longer collecting Endoscopy (TISS Item), so nothing to check
  • Successor: No successor was entered

Click Expand to show legacy content.

Data Integrity Checks
Summary: If pt has T26 & 27 - Endoscopy (TISS Item) then there must be an endoscopic CCI for that day.
Related: Endoscopy (TISS Item), ERCP (endoscopic retrograde cholangiopancreatography), Inspection, Exploration (endoscopic), Biopsy (endoscopic)
Firmness: hard check
Timing: complete
App: Centralized data front end.accdb
Coding: query NDC_TISS_CCI_endoscopic
Uses L Problem table: No
Status: retired
Implementation Date: 2019/01/06
Backlogged: true
  • Cargo


  • SMW


  • Categories:  
  • form:

This query is retired because T26 & 27 - Endoscopy (TISS Item) is no longer regularly collected.

CCI without T43

If there is at least one #Endoscopic CCI on a day, then T26 & 27 - Endoscopy (TISS Item) must be marked for that day.

T43 without CCI - can't be checked

Many of the CCIs are not defined as endoscopic or not, just as what was accomplished (e.g. Extraction ), so we will not be able to check that all T43 have a matching CCI.

Endoscopic CCI

We only track the route of procedures in a few exceptional cases:

See also

Other procedure in Endoscopic Px:
 Has CCI Picklist CodeHas CCI 1 CodeHas CCI 2 Code
Biopsy (endoscopic)71.b^
Capsule Endoscopy2.0Z.29
ERCP (endoscopic retrograde cholangiopancreatography)2.OE.70.BA
Inspection, Exploration (endoscopic)70d.b^

Log

Retrieved from "https://ccmdb.kuality.ca/index.php?title=Query_NDC_TISS_CCI_endoscopic&oldid=165138"