Query check CCI TISS time means must be two: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) (Created page with "{{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_related_c...") |
Ttenbergen (talk | contribs) No edit summary |
||
| (24 intermediate revisions by 2 users not shown) | |||
| 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; 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 = | |DIC_firmness=soft check | ||
| DIC_timing = | |DIC_timing=complete | ||
|DIC_coding=query ''check_CCI_TISS_time_means_must_be_two'' | |||
| DIC_coding = query '' | |DIC_implementation_date=2023-05-04 | ||
| DIC_status = | |DIC_status=declined | ||
| | |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) }} | |||
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 == | == Log == | ||
* 2021-09-01 - | * 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 == | ||
{{Related Articles}} | {{Related Articles}} | ||
[[Category:CCI Px check]] | [[Category:CCI Px check]] | ||
[[Category:TISS28 checks]] | [[Category:TISS28 check]] | ||
[[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 |
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:
- CAM positive (TISS Item) (T9)
- Intracranial pressure monitoring (TISS Item) (T10)
- Vasoactive drug IV continuous-single (TISS Item) (T13)
- Vasoactive drug IV continuous-multiple simultaneous (TISS Item) (T14)
- Pulmonary arterial line (TISS Item) (T15)
- Peripheral arterial line (TISS Item) (T16)
- Central venous catheter (TISS Item) (T17)
- Invasive Mechanical Ventilation (TISS Item) (T18)
- Supp O2 through any device, delivered via nose, mouth, ETT or trach (TISS Item) (T20)
- Non-invasive CPAP or BIPAP (TISS Item) (T21)
- ETT Present (TISS Item) (T22)
- Trach Tube Present (TISS Item) (T23)
- IV hyperalimentation (TISS Item) (T36)
- Patient is on isolation (TISS Item) (T38)
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