Query check CCI TISS time means must be two: Difference between revisions
Jump to navigation
Jump to search
No 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 | Selected Tiss items present in continuous days with a date in-between where patient is at two locations : | ||
T9 CAM+ | * T9 CAM+ | ||
T10 IPM | * T10 IPM | ||
T13 & 14 Vasoactive | * T13 & 14 Vasoactive | ||
T15 Swan Ganz | * T15 Swan Ganz | ||
T16 Peripheral art line | * T16 Peripheral art line | ||
T17 CVC | * T17 CVC | ||
T18 Inv Mech Vent | * T18 Inv Mech Vent | ||
T22 ETT present | * T20 Supp O2 | ||
T36 IV hyperalimentation | * T21 Non-Inv CPAP | ||
T38 Isolation | * T22 ETT present | ||
* T23 Trach present | |||
* T36 IV hyperalimentation | |||
* T38 Isolation | |||
}} | }} | ||
Revision as of 16:57, 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 |
1
Selected Tiss items present in continuous days with a date in-between where patient is at two locations :
|
Log
- 2021-09-01 - requirement identified but there are questions