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

From CCMDB Wiki
Jump to navigation Jump to search
mNo edit summary
mNo edit summary
Line 1: Line 1:
{{Data Integrity Check
{{Data Integrity Check
| DIC_summary = If certain [[Px Date]]s have a time component, then there should also be a matching [[CCI Picklist]] without the time
| DIC_summary = If certain [[Px Date]]s have a time component, then there should also be a matching [[CCI Picklist]] without the time
| DIC_related_concepts = CCI Picklist; CAM positive (TISS Item); Intracranial pressure monitoring (TISS Item); Vasoactive drug IV continuous-single (TISS Item); Vasoactive drug IV continuous-multiple simultaneous (TISS Item); Pulmonary arterial line (TISS Item); Peripheral arterial line (TISS Item); Peripheral art line; Central venous catheter (TISS Item); Invasive Mechanical Ventilation (TISS Item); Supp O2 through any device, delivered via nose, mouth, ETT or trach (TISS Item); Non-invasive CPAP or BIPAP (TISS Item); ETT Present (TISS Item); Trach Tube Present (TISS Item); IV hyperalimentation (TISS Item); Patient is on isolation (TISS Item)   
| DIC_related_concepts = CCI Picklist; CAM positive (TISS Item); Intracranial pressure monitoring (TISS Item); Vasoactive drug IV continuous-single (TISS Item); Vasoactive drug IV continuous-multiple simultaneous (TISS Item); Pulmonary arterial line (TISS Item); Peripheral arterial line (TISS Item); Central venous catheter (TISS Item); Invasive Mechanical Ventilation (TISS Item); Supp O2 through any device, delivered via nose, mouth, ETT or trach (TISS Item); Non-invasive CPAP or BIPAP (TISS Item); ETT Present (TISS Item); Trach Tube Present (TISS Item); IV hyperalimentation (TISS Item); Patient is on isolation (TISS Item)   
| DIC_firmness = soft check  
| DIC_firmness = soft check  
| DIC_timing = complete
| DIC_timing = complete

Revision as of 15:35, 2022 December 1

Data Integrity Checks
Summary: If certain Px Dates have a time component, then there should also be a matching CCI Picklist without the time
Related: CCI Picklist, CAM positive (TISS Item), Intracranial pressure monitoring (TISS Item), Vasoactive drug IV continuous-single (TISS Item), Vasoactive drug IV continuous-multiple simultaneous (TISS Item), Pulmonary arterial line (TISS Item), Peripheral arterial line (TISS Item), Central venous catheter (TISS Item), Invasive Mechanical Ventilation (TISS Item), Supp O2 through any device, delivered via nose, mouth, ETT or trach (TISS Item), Non-invasive CPAP or BIPAP (TISS Item), ETT Present (TISS Item), Trach Tube Present (TISS Item), IV hyperalimentation (TISS Item), Patient is on isolation (TISS Item)
Firmness: soft check
Timing: complete
App: CCMDB.accdb
Coding: query check_CCI_TISS_time_means_must_be_two
Uses L Problem table: not relevant for this app
Status: ready to implement
Implementation Date:
Backlogged: true
  • Cargo


  • SMW


  • Categories: 
  • form:

Rationale

For certain CCI Picklist entries, if a patient changes units on a day and if the procedure continues, there should be two CCI entries, one with a date and one without. Julie noticed a pattern of errors where the entry with a time is made, but the entry without a time is not present. While that could be correct, chart reviews showed that the untimed entry is often just forgotten. So, we decided to put in place a soft-check that will flag records that have a timed CCI entry but no matching untimed CCI entry for one of the following CCI codes:


_dev_CCMDB

  • 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)
      • Hard check on selected TISS items which are present in continuous days with a date in-between where patient is at two locations :
  • T9 CAM+
  • T10 IPM
  • T13 & 14 Vasoactive
  • T15 Swan Ganz
  • T16 Peripheral art line
  • T17 CVC
  • T18 Inv Mech Vent
  • T20 Supp O2
  • T21 Non-Inv CPAP
  • T22 ETT present
  • T23 Trach present
  • T36 IV hyperalimentation
  • T38 Isolation
        • That can still at best be a soft check. They might have discontinued the therapy in prep for discharging from ICU and then have had to re-start it as pt got worse. And coincidentally the pt was moved to other loc.
          • This is ready to implement; Make a soft check: if there is a day before, or a day after, then there should be on day of. Needs to be a complete-check
  • added: no added date
  • action: no action date
  • Cargo


  • Categories

Log

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

Related articles

Related articles: