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 [[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_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=ready to implement
|DIC_coding=NDC_TISS_CCI_endoscopic
|DIC_LProblem=No
|DIC_implementation_date=2019/01/06
|DIC_status=implemented
|DIC_LProblem=Yes
|DIC_app=Centralized data front end.accdb
|DIC_app=Centralized data front end.accdb
}}
}}
== Endoscopic Procedures ==
We only track the route of procedures in a few exceptional cases:
* [[ERCP (endoscopic retrograde cholangiopancreatography)]]
* [[Inspection, Exploration (endoscopic)]]
* [[Biopsy (endoscopic)]]
== CCI without T43 ==
== CCI without T43 ==
The CCI in category "Endoscopic Px" are the only ones that are always done with an endoscope.  
The CCI in category "Endoscopic Px" are the only ones that are always done with an endoscope.  

Revision as of 23:29, 6 January 2019

Data Integrity Checks
Summary: If pt has TISS28 item Endoscopy (any type of scope) in the ICU (T43) 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: NDC_TISS_CCI_endoscopic
Uses L Problem table: Yes
Status: implemented
Implementation Date: 2019/01/06
Backlogged: true
  • Cargo


  • SMW


  • Categories:  
  • form:

Endoscopic Procedures

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

CCI without T43

The CCI in category "Endoscopic Px" are the only ones that are always done with an endoscope.

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^

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.