Query NDC TISS CCI endoscopic

From CCMDB Wiki
Revision as of 21:07, 18 November 2018 by Ttenbergen (talk | contribs)
Jump to navigation Jump to search
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), Bronchoscopy/Laryngoscopy
Firmness: hard check
Timing: complete
App: Centralized data front end.accdb
Coding: not entered
Uses L Problem table: No
Status: ready to implement
Implementation Date: not entered
Backlogged: true
  • Cargo


  • SMW


  • Categories:  
  • form:

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.