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
 
(10 intermediate revisions by 2 users not shown)
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
|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
| DIC_app = CCMDB.accdb
|DIC_coding=query ''check_CCI_TISS_time_means_must_be_two''
| DIC_coding = query ''check_CCI_TISS_time_means_must_be_two''
|DIC_implementation_date=2023-05-04
| DIC_status = ready to implement
|DIC_status=declined
| DIC_implementation_date =  
|DIC_app=CCMDB.accdb
|DIC_backlogged=No
}}
}}
== Rationale ==
== 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:  
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 check that will flag records that have a timed CCI entry but no matching un-timed CCI entry for one of the following CCI codes:  
* {{ CCIWithCode | CAM positive (TISS Item) }}
* {{ CCIWithCode | Intracranial pressure monitoring (TISS Item) }}
* {{ CCIWithCode | Vasoactive drug IV continuous-single (TISS Item) }}
* {{ CCIWithCode | Vasoactive drug IV continuous-multiple simultaneous (TISS Item) }}
* {{ CCIWithCode | Pulmonary arterial line (TISS Item) }}
* {{ CCIWithCode | Peripheral arterial line (TISS Item) }}
* {{ CCIWithCode | Central venous catheter (TISS Item) }}
* {{ CCIWithCode | Invasive Mechanical Ventilation (TISS Item) }}
* {{ CCIWithCode | Supp O2 through any device, delivered via nose, mouth, ETT or trach (TISS Item) }}
* {{ CCIWithCode | Non-invasive CPAP or BIPAP (TISS Item) }}
* {{ CCIWithCode | ETT Present (TISS Item) }}
* {{ CCIWithCode | Trach Tube Present (TISS Item) }}
* {{ CCIWithCode | IV hyperalimentation (TISS Item) }}
* {{ CCIWithCode | Patient is on isolation (TISS Item) }}


* {{ CCIWithCode | CAM positive (TISS Item) }} T9 CAM+
This check will be a '''soft-check''' since it is possible for these things to be correct.
* {{ CCIWithCode | Intracranial pressure monitoring (TISS Item) }} T10 IPM
* {{ CCIWithCode | Vasoactive drug IV continuous-single (TISS Item) }} T13 & 14 Vasoactive
* {{ CCIWithCode | Vasoactive drug IV continuous-multiple simultaneous (TISS Item) }} T13 & 14 Vasoactive
* {{ CCIWithCode | Pulmonary arterial line (TISS Item) }} T15 Swan Ganz
* {{ CCIWithCode | Peripheral arterial line (TISS Item) }} T16 Peripheral art line
* {{ CCIWithCode | Central venous catheter (TISS Item) }} T17 CVC
* {{ CCIWithCode | Invasive Mechanical Ventilation (TISS Item) }} T18 Inv Mech Vent
* {{ CCIWithCode | Supp O2 through any device, delivered via nose, mouth, ETT or trach (TISS Item) }} T20 Supp O2
* {{ CCIWithCode | Non-invasive CPAP or BIPAP (TISS Item) }} T21 Non-Inv CPAP
* {{ CCIWithCode | ETT Present (TISS Item) }} T22 ETT present
* {{ CCIWithCode | Trach Tube Present (TISS Item) }} T23 Trach present
* {{ CCIWithCode | IV hyperalimentation (TISS Item) }} T36 IV hyperalimentation
* {{ CCIWithCode | Patient is on isolation (TISS Item) }} T38 Isolation


{{TT| _dev_CCMDB
This check will be done on '''complete records only''' because in incomplete records, the collectors may put in inconsistent data as they review.
* 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? [[User:Ttenbergen|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
}}


== Log ==
== Log ==
* 2023-05-30 - declined the check, it was causing too many false positives (as discussed with Lisa and Julie)
* 2023-05-04 - implemented
* 2021-09-01 - requirement identified but there are questions
* 2021-09-01 - requirement identified but there are questions


Latest revision as of 13:57, 2023 May 30

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: declined
Implementation Date: 2023-05-04
Backlogged: No
  • 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 check that will flag records that have a timed CCI entry but no matching un-timed CCI entry for one of the following CCI codes:

This check will be a soft-check since it is possible for these things to be correct.

This check will be done on complete records only because in incomplete records, the collectors may put in inconsistent data as they review.

Log

  • 2023-05-30 - declined the check, it was causing too many false positives (as discussed with Lisa and Julie)
  • 2023-05-04 - implemented
  • 2021-09-01 - requirement identified but there are questions

Related articles

Related articles:
Retrieved from "https://ccmdb.kuality.ca/index.php?title=Query_check_CCI_TISS_time_means_must_be_two&oldid=159525"