Query s tmp QAInf LT 48 hrs after admit

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.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

• Cargo

• SMW

"CCMDB.mdb" is not in the list (SAP, not entered, Centralized data front end.accdb, DSM Labs Consistency check.accdb, CCMDB.accdb, TISS28.accdb) of allowed values for the "DICApp" property. Property "DICRelatedConcepts" (as page type) with input value "QA Infection]], QA Infection CLI, [[QA Infection VAP" contains invalid characters or is incomplete and therefore can cause unexpected results during a query or annotation process.

• Categories:  

• form:

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)

• SMW

• Cargo

• Categories

This query uses the following sub-queries:

• s_tmp_QAInf__dx
• s_tmp_QAInf__tmp