Query NDC CLI unacceptable date: Difference between revisions

(6 intermediate revisions by the same user not shown)

Line 1:

{{Data Integrity Check

|DIC_summary=Checks that the [[QA Infection CLI]] Dt is between the [[Arrive DtTm]] and [[Dispo DtTm]]

|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~~; Dispo DtTm; QA Infection CLI

|DIC_related_concepts=Iatrogenic, infection, central venous catheter-related bloodstream infection (CVC-BSI, CLI); Dispo DtTm; QA Infection CLI

|DIC_firmness=hard check

|DIC_coding=query ''NDC CLI unacceptable date''

|DIC_status=~~needs review~~

|DIC_status=retired

|DIC_app=Centralized data front end.accdb

}}

~~{{Discuss | who = Julie | question = * 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. --[[User:JMojica|JMojica]] 10:49, 2018 November 20 (CST) }}

~~{{Discuss | who = Julie | question = * 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. --[[User:JMojica|JMojica]] 10:49, 2018 November 20 (CST)

}}

[[QA Infection CLI]] was retired with the move to [[ICD10]] so this won't be needed.

== Related articles ==

@@ Line 1: / Line 1: @@
 {{Data Integrity Check
-|DIC_summary=Checks that the [[QA Infection CLI]] Dt is between the [[Arrive DtTm]] and [[Dispo DtTm]]
+|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; Dispo DtTm; QA Infection CLI
+|DIC_related_concepts=Iatrogenic, infection, central venous catheter-related bloodstream infection (CVC-BSI, CLI); Dispo DtTm; QA Infection CLI
 |DIC_firmness=hard check
 |DIC_coding=query ''NDC CLI unacceptable date''
-|DIC_status=needs review
+|DIC_status=retired
 |DIC_app=Centralized data front end.accdb
 }}
-{{Discuss | who = Julie | question = * 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. --[[User:JMojica|JMojica]] 10:49, 2018 November 20 (CST)  }}
-{{Discuss | who = Julie | question = * 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. --[[User:JMojica|JMojica]] 10:49, 2018 November 20 (CST)
- }}
+[[QA Infection CLI]] was retired with the move to [[ICD10]] so this won't be needed.
 == Related articles ==