Query check CCI TISS Pharm Vasoactive: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
mNo edit summary
 
Line 1: Line 1:
{{Data Integrity Check
{{Data Integrity Check
|DIC_summary=Compare [[Vasoactive drug IV continuous-single (TISS Item)]]/{{TISS w Nr | Vasoactive drug IV continuous-multiple simultaneous (TISS Item)}} against Pharmacy entries for vasoactive drugs.
|DIC_summary=Compare [[Vasoactive drug IV continuous-single (TISS Item)]]/{{TISS w Nr | Vasoactive drug IV continuous-multiple simultaneous (TISS Item)}} against Pharmacy entries for vasoactive drugs.
|DIC_related_concepts=Vasoactive drug IV continuous-single (TISS Item); Vasoactive drug IV continuous-multiple simultaneous (TISS Item); Pharmacy collection
|DIC_related_concepts=Vasoactive drug IV continuous-single (TISS Item); Vasoactive drug IV continuous-multiple simultaneous (TISS Item); Pharmacy collection; Service tmp entry
|DIC_firmness=hard check
|DIC_firmness=hard check
|DIC_timing=complete
|DIC_timing=complete
Line 31: Line 31:


== Log ==
== 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-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-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
* 2021-03-31 - implemented



Latest revision as of 16:38, 2022 April 21

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
  • Cargo


  • SMW


  • Categories:  
  • form:

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

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: