Query NDC CLI unacceptable date

Data Integrity Checks
Summary:	Checks that the QA Infection CLI Dt is between the Arrive DtTm and Dispo DtTm
Related:	Iatrogenic, infection, central venous catheter-related bloodstream infection (CVC-BSI, CLI), Arrive DtTm field, Dispo DtTm, QA Infection CLI
Firmness:	hard check
Timing:	always
App:	Centralized data front end.accdb
Coding:	query NDC CLI unacceptable date
Uses L Problem table:	not entered
Status:	needs review
Implementation Date:	not entered
Backlogged:	true

• Cargo

• SMW

• Categories: 

• form:

Is there a reason we are doing this at Pagasa's end rather than in CCMDB.mdb? This can be done at CCMDB level. maybe this was not in placed yet when Pagasa had this query in CFE. --JMojica 10:49, 2018 November 20 (CST)

• SMW

• Cargo

• Categories

In ICD10 we will have Dx Date. Does that change how we want this query? All Dx dates and CCI dates must be between the Arrive DtTm and Dispo DtTm. Once we move to ICD10 and CCI, the QAInf project (CLI and VAP dates) will stop, so we can drop this NDC CLI query. --JMojica 10:49, 2018 November 20 (CST)

• SMW

• Cargo

• Categories