Query check CCI TISS time means must be two
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