Query check CCI TISS Pharm Vasoactive

From CCMDB Wiki
Revision as of 12:07, 2021 March 31 by Ttenbergen (talk | contribs) (Ttenbergen moved page Query NDC TISS vs pharmacy to Query check CCI TISS vs Pharmacy without leaving a redirect: consistency)
Jump to navigation Jump to search
Data Integrity Checks
Summary: Compare Vasoactive drug IV continuous-single (TISS Item)/T14 - Vasoactive drug IV continuous-multiple simultaneous (TISS Item) against Pharmacy entries for vasoactive drugs.
Related: Vasoactive drug IV continuous-single (TISS Item), Vasoactive drug IV continuous-multiple simultaneous (TISS Item), Pharmacy collection
Firmness: hard check
Timing: complete
App: CCMDB.accdb
Coding: query check_CCI_TISS_vs_Pharmacy
Uses L Problem table: not relevant for this app
Status: ready to implement
Implementation Date: not entered
Backlogged: No
  • Cargo


  • SMW


  • Categories: 
  • form:

  • Have all info now, Allan confirmed drug list. Once implemented let Julie know so she can not do this in SAS any longer
  • added: no added date
  • action: no action date
  • Cargo


  • Categories

Has vasoactive drug but doesn't have TISS

If one of the #Relevant Pharmacy Entries is present, then at least one of the #Relevant TISS Items must exist.

Has TISS but doesn't have drug - Uncheckable

We don't collect all vasoactive drugs, so this check can't be done. There are other vasoactive drugs ie. nitroglycerine/nitroprusside that are used but we do not collect them, so we cannot reverse the quality check.

Relevant TISS Items

Relevant Pharmacy entriees


Related articles

Related articles: