Edit Data Integrity Check: Query s tmp QAInf LT 48 hrs after admit

Are you logged on?

You do not have permission to edit this page, for the following reason:

The action you have requested is limited to users in the group: CCMDB_legit.

Summary (what is the check, one-liner):
links to related pages:
Firmness (is this a warning only (soft check) or will it stop sending (hard check) - applicable only in CCMDB.accdb app):	None/unknown hard check soft check
Timing (does this query run for all records or only complete ones):	None/unknown complete always
Name of the function or query this is implemented as:	query ''s tmp QAInf LT 48 hrs after admit''
Implementation date:
Implementation Status:
L_Problem (are false positive special cases addressed in table L_Problems - applicable only in CFE):	None/unknown Yes No
App:
Backlogged (is this query cleaned up to date or backlogged? Applicable only in CFE):

Free text:

{{LegacyContent |explanation=Check using old DX coding schema |successor=[[Query check cooling vs arrest]] |content= 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. --[[User:JMojica|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}} }}

Explain your edit, if you think it needs explanation (e.g. "as discussed with ...", or "content moved to ...", or "duplicate content, see ..."):

This is a minor edit

Watch this page

Cancel