Query NDC CLI unacceptable date: Difference between revisions

Revision as of 18:29, 6 November 2018

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?

@@ Line 1: / Line 1: @@
 {{Data Integrity Check
-|DIC_summary=Checks {{discussion}} what?
+|DIC_summary=Checks that the [[QA Infection CLI]] Dt is between the [[Arrive DtTm]] and [[Dispo DtTm]]
-|DIC_related_concepts=Iatrogenic, infection, central venous catheter-related bloodstream infection (CVC-BSI, CLI); Arrive DtTm field
+|DIC_related_concepts=Iatrogenic, infection, central venous catheter-related bloodstream infection (CVC-BSI, CLI); Arrive DtTm field; Dispo DtTm; QA Infection CLI
 |DIC_firmness=hard check
 |DIC_coding=query ''NDC CLI unacceptable date''
@@ Line 9: / Line 9: @@
 {{Discuss | who = Julie | question = * Is there a reason we are doing this at Pagasa's end rather than in CCMDB.mdb? }}
-{{Discuss | who = Julie | question = * What does this actually check? We never used to have dx dates so I don't understand.  }}
+{{Discuss | who = Julie | question = * In [[ICD10]] we will have [[Dx Date]]. Does that change how we want this query?  }}
-{{Discuss | who = Julie | question = * In [[ICD10]] we will have [[Dx Date]]. Does that change how we want this query?  }}
 == Related articles ==
 {{Related Articles}}