Query check CCI TISS time means must be two: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) mNo edit summary |
Ttenbergen (talk | contribs) mNo edit summary |
||
Line 1: | Line 1: | ||
{{Data Integrity Check | {{Data Integrity Check | ||
| DIC_summary = If | | 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 | ||
| DIC_firmness = soft check | | DIC_firmness = soft check | ||
| DIC_timing = complete | | DIC_timing = complete | ||
| DIC_app = CCMDB.accdb | | DIC_app = CCMDB.accdb | ||
| DIC_coding = query '' | | DIC_coding = query ''check_CCI_TISS_time_means_must_be_two'' | ||
| DIC_status = ready to implement | | DIC_status = ready to implement | ||
| DIC_implementation_date = | | DIC_implementation_date = | ||
}} | }} | ||
== 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: | |||
* {{ CCIWithCode | CAM positive (TISS Item) }} T9 CAM+ | |||
* {{ 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 | {{TT| _dev_CCMDB |
Revision as of 15:23, 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 |
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 |
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:
- CAM positive (TISS Item) (T9) T9 CAM+
- Intracranial pressure monitoring (TISS Item) (T10) T10 IPM
- Vasoactive drug IV continuous-single (TISS Item) (T13) T13 & 14 Vasoactive
- Vasoactive drug IV continuous-multiple simultaneous (TISS Item) (T14) T13 & 14 Vasoactive
- Pulmonary arterial line (TISS Item) (T15) T15 Swan Ganz
- Peripheral arterial line (TISS Item) (T16) T16 Peripheral art line
- Central venous catheter (TISS Item) (T17) T17 CVC
- Invasive Mechanical Ventilation (TISS Item) (T18) T18 Inv Mech Vent
- Supp O2 through any device, delivered via nose, mouth, ETT or trach (TISS Item) (T20) T20 Supp O2
- Non-invasive CPAP or BIPAP (TISS Item) (T21) T21 Non-Inv CPAP
- ETT Present (TISS Item) (T22) T22 ETT present
- Trach Tube Present (TISS Item) (T23) T23 Trach present
- IV hyperalimentation (TISS Item) (T36) T36 IV hyperalimentation
- Patient is on isolation (TISS Item) (T38) T38 Isolation
_dev_CCMDB
|
|
Log
- 2021-09-01 - requirement identified but there are questions