Quality Assurance queries in CFE: Difference between revisions

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


== List of NDC queries ==
== List of NDC queries ==
{{#ask: [[category:Data Integrity Checks]] [[~Query NDC_*]][[DICStatus::!declined]]
{{#ask: [[Category:Data Integrity Checks]] [[~Query NDC*]] [[DICStatus::!declined]]
|?DICStatus
|?DICStatus
|format=table
|format=table
|default=none found
|default=none found
}}  
}}  


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

Revision as of 14:12, 2020 January 15

We have a bunch of Quality Assurance queries in CFE that are done as part of the Centralized data Vetting Process. Ideally all should be empty, if they are not the data needs to be fixed (see Processing errors in patient data).

The easiest way to check these is to click the NDCs button. It will check every query but only display those where problems were found.

If any false positives are found that are unique special cases or if there are errors that we deliberately decide not to correct for some reasons, set them as Known data errors so they no longer show up in queries.

When they have all been corrected you can move to the next step in Centralized data Vetting Process, likely "Vet all sent" button.

List of NDC queries

 DICStatus
Query NDC Bad Postal Codeimplemented
Query NDC CLI unacceptable dateretired
Query NDC Pacemaker acquired vs TISSretired
Query NDC Postal Code over timeimplemented
Query NDC TISS CCI endoscopicretired
Query NDC Trach Dx TISSretired
Query NDC VAP AcqDX but NoVAP DateinTMPV2retired
Query NDC VAP No AcqDX but VAP DateinTMPV2retired
Query NDC VAP unacceptable dateretired
Query NDC cardioversion dx vs TISSretired
Query NDC dx implying death across encountersimplemented
Query NDC zCRRT CCI Px but no TISSretired
Query NDC zCRRT TISS but no CCI Pxretired
Query NDC zCRRT TISS no tmpretired
Query NDC zCRRT tmp no TISSretired

Related articles

Related articles: