Query check CCI TISS Pharm Vasoactive

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_Pharm_Vasoactive
Uses L Problem table:	not relevant for this app
Status:	implemented
Implementation Date:	2021-03-31
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

• T13 - Vasoactive drug IV continuous-single (TISS Item)
• T14 - Vasoactive drug IV continuous-multiple simultaneous (TISS Item)

Relevant Pharmacy entriees

• Pharm Dopamine cont inf
• Pharm Dobutamine cont inf
• Pharm Norepinephrine cont inf
• Pharm Epinephrine cont inf
• Pharm Phenylephrine cont inf
• Pharm Vasopressin cont inf
• Pharm Milrinone cont inf

Log

2021-03-31 - implemented