Query check CCI TISS Pharm Vasoactive

Revision as of 19:01, 26 October 2018 by Ttenbergen (talk | contribs)
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)
Firmness: hard check
Timing: complete
App: CCMDB.mdb
Coding: not entered
Uses L Problem table: not relevant for this app
Status: needs review
Implementation Date: not entered
Backlogged: true
  • Cargo


  • SMW
"CCMDB.mdb" is not in the list (SAP, not entered, Centralized data front end.accdb, DSM Labs Consistency check.accdb, CCMDB.accdb, TISS28.accdb) of allowed values for the "DICApp" property. 
  • Categories:  
  • form:

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

Likely candidates for checks:

If neither of the above, this article can be deleted. If either of the above, please explain and add to Change Priorities. Template:Potential Change

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

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)

Template:Data Integrity Checks

No idea if this is implemented.