Quality Assurance queries in CFE: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
← Older edit
PTorres (talk | contribs)
CCMDB_legit, approved
1,548 edits
 
(54 intermediate revisions by 4 users not shown)
Line 1: Line 1:
We have a bunch of Quality Assurance questions in [[CFE]]. Most of them currently have a backlog or errors. As the backlog gets eliminated we can add them to [[Centralized data Vetting Process]].
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]]).  


== QA checks ==
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.
#[[Query NDC missing Ls | NDC_missing_Ls]] (There is one pt with no comorbid and that is correct)
# NDC_discharged_incomplete
# NDC_Bad_Postal_Code (This is corrected when time available)
# NDC_Missing_TransferDate_w_pivot
# NDC_CLI_AcqDX_but_NoCLI_DateinTMPV2
# NDC_CLI_No_AcqDX_but_CLI_DateinTMPV2
# NDC_CLI_unacceptable_date
# NDC_VAP_AcqDX_but_NoVAP_DateinTMPV2 (see [[VAP Dx vs Tmp checking]])
# NDC_VAP_No_AcqDX_but_VAP_DateinTMPV2 (see [[VAP Dx vs Tmp checking]])
# NDC_VAP_unacceptable_date (see [[VAP Dx vs Tmp checking]])


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 ==
{{#ask: [[Category:Data Integrity Checks]] [[~Query NDC*]] [[DICStatus::implemented||needs review]]
|?DICStatus
|format=table
|default=none found
|intro=Current list of queries
}}
{{#ask: [[Category:Data Integrity Checks]] [[~Query NDC*]]
|?DICStatus
|format=table
|default=none found
|searchlabel=Full list of queries including declined, retired, etc
|limit=0
}}
== Related articles ==
{{Related Articles}}




[[Category:Data Processing]]
[[Category:Data Processing]]
[[Category:Postal Codes]]

Latest revision as of 11:05, 15 July 2021

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

Current list of queries

 DICStatus
Query NDC Bad Postal Codeimplemented
Query NDC Postal Code over timeimplemented
Query NDC dx implying death across encountersimplemented

Full list of queries including declined, retired, etc

Related articles

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