CCMDB Wiki

Quality Assurance queries in CFE: Difference between revisions

← Older edit
PTorres (talk | contribs)
CCMDB_legit, approved
1,617 edits
 
(55 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
# 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]]
Retrieved from "https://ccmdb.kuality.ca/index.php?title=Quality_Assurance_queries_in_CFE"