Query NDC VAP No AcqDX but VAP DateinTMPV2: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
← Older edit
mNo edit summary
mNo edit summary
 
(7 intermediate revisions by the same user not shown)
Line 3: Line 3:
|DIC_related_concepts=Pneumonia, ventilator-associated (VAP); Acquired Diagnosis / Complication; QA Infection VAP
|DIC_related_concepts=Pneumonia, ventilator-associated (VAP); Acquired Diagnosis / Complication; QA Infection VAP
|DIC_firmness=hard check
|DIC_firmness=hard check
|DIC_coding=query ''NDC VAP AcqDX but NoVAP DateinTMPV2''
|DIC_coding=query ''Query query NDC_VAP_AcqDX_but_NoVAP_DateinTMPV2''
|DIC_status=needs review
|DIC_status=retired
|DIC_app=Centralized data front end.accdb
|DIC_app=Centralized data front end.accdb
}}
}}


Despite the name this query doesn't check for the date entry, just for the presence of a line in tmp.
[[QA Infection VAP]] was stopped with the start of ICD10 2019-01-01, so this check is no longer required and has been removed. [[User:Ttenbergen|Ttenbergen]] 16:20, 2021 January 27 (CST)  
 
{{Discuss | who = Tina | question = * Needs ICD10 added, and likely be moved to [[CCMDB.mdb]]. }}
{{Discuss | who= Julie | question = Was there a reason we didn't move this into ccmdb, or was that just a ball dropped? We'd need to review with ICD10 anyway...
* Same comment as in CLI. --[[User:JMojica|JMojica]] 12:01, 2018 November 20 (CST)}}
 
{{Discuss | who = Julie | question = * in [[ICD10]] we will have [[Dx Date]] available; do we want to change this check to include that?
* yes, include all. --[[User:JMojica|JMojica]] 12:01, 2018 November 20 (CST)}}
 
{{Discuss | who = Julie | question = * If a sputum culture is no longer a defining feature of [[VAP]], then is collecting the date of one in [[QA Infection VAP]] really reasonable in the first place? If it is not then this check can go away. See discussion at [[QA Infection VAP]], just flagging it here.
* the Tmp QAInf will stop when we collect Acquired dates - no need to enter in two places. --[[User:JMojica|JMojica]] 12:01, 2018 November 20 (CST) }}


== Related articles ==
== Related articles ==

Latest revision as of 16:20, 27 January 2021

Data Integrity Checks
Summary: Checks that any record with QA Infection VAP entry with a date also has an Acquired Diagnosis VAP .
Related: Pneumonia, ventilator-associated (VAP), Acquired Diagnosis / Complication, QA Infection VAP
Firmness: hard check
Timing: always
App: Centralized data front end.accdb
Coding: query Query query NDC_VAP_AcqDX_but_NoVAP_DateinTMPV2
Uses L Problem table: not entered
Status: retired
Implementation Date: not entered
Backlogged: true
  • Cargo


  • SMW


  • Categories:  
  • form:

QA Infection VAP was stopped with the start of ICD10 2019-01-01, so this check is no longer required and has been removed. Ttenbergen 16:20, 2021 January 27 (CST)

Related articles

Related articles:
Retrieved from "https://ccmdb.kuality.ca/index.php?title=Query_NDC_VAP_No_AcqDX_but_VAP_DateinTMPV2&oldid=148905"