Query check CCI TISS Pharm Vasoactive

From CCMDB Wiki
Revision as of 16:39, 2018 November 15 by JMojica (talk | contribs)
Jump to navigation Jump to search
Data Integrity Checks
Summary: Compare Vasoactive drug IV continuous-single (TISS Item)/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: Centralized data front end.accdb
Coding: not entered
Uses L Problem table: not entered
Status: needs review
Implementation Date: not entered
Backlogged: true
  • Cargo


  • SMW


  • Categories: 
  • form:

The following items on your pharmacy form should be confirmed against the corresponding items on the TISS:

Likely candidates for checks:

Has vasoactive drug but doesn't have TISS

If one of the following drugs is present, then at least one TISS13/14 must exist:

  • dopamine, dobutamine, norepinephrine, epinephrine, phenylephrine, vasopressin and milrinone

Is this being done in CFE or SAS at this point? Ttenbergen 20:04, 2018 October 26 (CDT)

   *done in SAS as needed and not on regular basis.  Yes, we can implement this at CFE but one way only as noted by Lisa below. --JMojica 15:39, 2018 November 15 (CST)
  • SMW


  • Cargo


  • Categories

Uncheckable - Has TISS but doesn't have drug

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.Lisa Kaita 12:35, 2017 April 25 (CDT)