Query s tmp QAInf LT 48 hrs after admit: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) mNo edit summary |
No edit summary |
||
| Line 12: | Line 12: | ||
Approximate implementation date, this is the first mention in a change log so it was present before. | Approximate implementation date, this is the first mention in a change log so it was present before. | ||
{{Discuss | who=Julie | 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)}} | {{Discuss | who=Julie | 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. --[[User:JMojica|JMojica]] 15:40, 2018 November 20 (CST) }} | |||
This query uses the following sub-queries: | This query uses the following sub-queries: | ||
Revision as of 16:40, 2018 November 20
| 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: | |
| App: | CCMDB.mdb |
| Coding: | query s tmp QAInf LT 48 hrs after admit |
| Uses L Problem table: | not relevant for this app |
| Status: | needs review |
| Implementation Date: | 2009-12-29 |
| Backlogged: | true |
Approximate implementation date, this is the first mention in a change log so it was present before.
|
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: |