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

	Is there a reason we are doing this at Pagasa's end rather than in CCMDB.mdb?

	In ICD10 we will have Dx Date. Does that change how we want this query?

Related articles