Query s tmp QAInf LT 48 hrs after admit
Jump to navigation
Jump to search
Legacy Content
This page contains Legacy Content.- Explanation: Check using old DX coding schema
- Successor: Query check cooling vs arrest
Click Expand to show legacy content.
| Data Integrity Checks | |
| Summary: | DtTm of QAInf entry has to be at least 48hrs after patient admission unless the inf_dttm is blank. |
| Related: | QA Infection, QA Infection CLI, QA Infection VAP |
| Firmness: | hard check |
| Timing: | always |
| App: | CCMDB.accdb |
| Coding: | query s tmp QAInf LT 48 hrs after admit |
| Uses L Problem table: | not relevant for this app |
| Status: | retired |
| Implementation Date: | 2009-12-29 |
| Backlogged: | true |
Approximate implementation date, this is the first mention in a change log so it was present before.
question=elsewhere we wrongly listed that we have a cross check that the date in tmp is checked/mandatory. This check currently doesn't test for mandatory date. Should it? The instructions in QA Infection CLI, QA Infection VAP make it look like it would be mandatory. Ttenbergen 10:35, 2018 September 25 (CDT)
Since 48 hrs is part of the definition for VAP (i.e. in trach or ETT) and CLI (in ICU), this query maybe a helpful check. But I notice that in ICD10, we only required Date and not time, so the calculation of exactly at least 48hrs after patient admission will be hard to know without the time. If we will use the dates only, then the cutoff must be 2 or more calendar days from admission date, does this make sense? Onwards, the query must be done on the acquired ICD10 (since QAInf tmp will be dropped) but only for acquired VAP and CLI cases for now. --JMojica 15:40, 2018 November 20 (CST)
This query uses the following sub-queries:
- s_tmp_QAInf__dx
- s_tmp_QAInf__tmp
Related articles
| Related articles: |