Query NDC TISS CCI endoscopic: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
mNo edit summary
mNo edit summary
Line 1: Line 1:
{{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); ERCP (endoscopic retrograde cholangiopancreatography); Inspection, Exploration (endoscopic); Biopsy (endoscopic)
|DIC_related_concepts=Endoscopy (TISS Item); ERCP (endoscopic retrograde cholangiopancreatography); Inspection, Exploration (endoscopic); Biopsy (endoscopic)
|DIC_firmness=hard check
|DIC_firmness=hard check
Line 6: Line 6:
|DIC_coding=query ''NDC_TISS_CCI_endoscopic''
|DIC_coding=query ''NDC_TISS_CCI_endoscopic''
|DIC_implementation_date=2019/01/06
|DIC_implementation_date=2019/01/06
|DIC_status=implemented
|DIC_status=retired
|DIC_LProblem=Yes
|DIC_LProblem=Yes
|DIC_app=Centralized data front end.accdb
|DIC_app=Centralized data front end.accdb
}}
}}


This query includes incomplete patients; the [[Data Processor]] only checks into incompletes during reporting time.  
This query is retired because {{TISS w Nr | Endoscopy (TISS Item)}} is no longer regularly collected.  


== Endoscopic Procedures ==
== 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.
 
== 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:  
We only track the route of procedures in a few exceptional cases:  
* [[ERCP (endoscopic retrograde cholangiopancreatography)]]
* [[ERCP (endoscopic retrograde cholangiopancreatography)]]
* [[Inspection, Exploration (endoscopic)]]
* [[Inspection, Exploration (endoscopic)]]
* [[Biopsy (endoscopic)]]
* [[Biopsy (endoscopic)]]
 
See also
== CCI without T43 ==
The CCI in category "Endoscopic Px" are the only ones that are always done with an endoscope.
{{ListCCICategory | categoryName = Endoscopic Px}}
{{ListCCICategory | categoryName = Endoscopic Px}}
== 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.


== Log ==
== Log ==

Revision as of 18:39, 2020 December 2

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: Yes
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

  • 2019-09-11 - updated component query "has_TISS_43_endoscopic_px" to actually look for TISS43, was looking for 42.
Retrieved from "https://ccmdb.kuality.ca/index.php?title=Query_NDC_TISS_CCI_endoscopic&oldid=147827"