Query check CCI TISS time means must be two: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
mNo edit summary
No edit summary
Line 14: Line 14:
** Not necessarily... what if the CVC simply wasn’t there for the MICU portion of the switch day?  
** Not necessarily... what if the CVC simply wasn’t there for the MICU portion of the switch day?  
** Discussed with Julie: We might be able to do this as a soft check but would need to know how many false positives there would be. Also, we would not want to do this for all TISS items: for example, for intubation and extubation this would not make sense,but are there others? [[User:Ttenbergen|Ttenbergen]] 16:37, 2021 September 2 (CDT)
** Discussed with Julie: We might be able to do this as a soft check but would need to know how many false positives there would be. Also, we would not want to do this for all TISS items: for example, for intubation and extubation this would not make sense,but are there others? [[User:Ttenbergen|Ttenbergen]] 16:37, 2021 September 2 (CDT)
  }}
  Selected Tiss items that needs hard check if patient is at two locations on that day:
T9 CAM+
T10 IPM
T13 & 14 Vasoactive
T15 Swan Ganz
T16 Peripheral art line
T17 CVC
T18 Inv Mech Vent
T22 ETT present
T36 IV hyperalimentation
T38 Isolation
 
}}


== Log ==
== Log ==

Revision as of 16:52, 2021 September 2

Data Integrity Checks
Summary: If the Px Date component of a CCI Picklist has a time, then there must be a corresponding Boarding Loc entry
Related: CCI Picklist, Boarding Loc
Firmness: soft check
Timing: incomplete
App: CCMDB.accdb
Coding: query check_CCI_TISS_matching_BoardingLoc_time
Uses L Problem table: not relevant for this app
Status: needs review
Implementation Date:
Backlogged: true
  • Cargo


  • SMW


  • Categories: 
  • form:

1

  • Julie had said in email: If any CCI date has a matching date on boarding loc, CCI must have at least two records (one with time and without time) if the yesterday and tomorrow have this same item. Here we are identifying missing line. Example H7-3316. Boarding loc move Dec 10 20:57 . CVC has dates Dec 9, 10,11. Dec 10 must have two lines one with time and another with time 20:57.
    • Not necessarily... what if the CVC simply wasn’t there for the MICU portion of the switch day?
    • Discussed with Julie: We might be able to do this as a soft check but would need to know how many false positives there would be. Also, we would not want to do this for all TISS items: for example, for intubation and extubation this would not make sense,but are there others? Ttenbergen 16:37, 2021 September 2 (CDT)
Selected Tiss items that needs hard check if patient is at two locations on that day:

T9 CAM+ T10 IPM T13 & 14 Vasoactive T15 Swan Ganz T16 Peripheral art line T17 CVC T18 Inv Mech Vent T22 ETT present T36 IV hyperalimentation T38 Isolation

  • SMW


  • Cargo


  • Categories

Log

  • 2021-09-01 - requirement identified but there are questions

Related articles

Related articles: