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

From CCMDB Wiki
Jump to navigation Jump to search
No edit summary
No edit summary
 
(17 intermediate revisions by 2 users not shown)
Line 1: Line 1:
{{Data Integrity Check
{{Data Integrity Check
| DIC_summary = If the [[Px Date]] component of a [[CCI Picklist]] has a time, then there must be a corresponding [[Boarding Loc]] entry
|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; Boarding Loc
|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 = incomplete
|DIC_timing=complete
| DIC_app = CCMDB.accdb
|DIC_coding=query ''check_CCI_TISS_time_means_must_be_two''
| DIC_coding = query ''check_CCI_TISS_matching_BoardingLoc_time''
|DIC_implementation_date=2023-05-04
| DIC_status = needs review
|DIC_status=declined
| DIC_implementation_date =  
|DIC_app=CCMDB.accdb
|DIC_backlogged=No
}}
}}
== 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:
* {{ 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) }}


{{DiscussTask|  1
This check will be a '''soft-check''' since it is possible for these things to be correct.  
* 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?
This check will be done on '''complete records only''' because in incomplete records, the collectors may put in inconsistent data as they review.
** 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 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
}}


== 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


Line 38: Line 41:


[[Category:CCI Px check‎]]
[[Category:CCI Px check‎]]
[[Category:TISS28 checks]]
[[Category:TISS28 check]]
[[Category:TISS28 timing checks]]
[[Category:TISS28 timing checks]]

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"