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, Service tmp entry |
| 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 |
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-12-02 - using Accept DtTm means that any pt who didn't have an Accept DtTm didn't get checked; changed this to use first service dttm instead.
- 2021-04-06 - changed to only include profiles with Accept DtTm after 2020-12-07 (Change_to_collect_TISS_data_in_CCI_Picklist#Change_date)
- 2021-03-31 - implemented
Related articles
| Related articles: |