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

From CCMDB Wiki
Jump to navigation Jump to search
mNo edit summary
No edit summary
Line 11: Line 11:


{{Discuss | who = Tina | question = * Needs ICD10 added, and likely be moved to [[CCMDB.mdb]]. }}
{{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...}}  
{{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? }}
{{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. }}
{{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 ==
{{Related Articles}}
{{Related Articles}}

Revision as of 13:04, 2018 November 20

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 NDC VAP AcqDX but NoVAP DateinTMPV2
Uses L Problem table: not entered
Status: needs review
Implementation Date: not entered
Backlogged: true
  • Cargo


  • SMW


  • Categories: 
  • form:

Despite the name this query doesn't check for the date entry, just for the presence of a line in tmp.

  • Needs ICD10 added, and likely be moved to CCMDB.mdb.
  • SMW


  • Cargo


  • Categories

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. --JMojica 12:01, 2018 November 20 (CST)
  • SMW


  • Cargo


  • Categories
  • in ICD10 we will have Dx Date available; do we want to change this check to include that?
  • yes, include all. --JMojica 12:01, 2018 November 20 (CST)
  • SMW


  • Cargo


  • Categories
  • 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. --JMojica 12:01, 2018 November 20 (CST)
  • SMW


  • Cargo


  • Categories

Related articles

Related articles: