Quality Assurance queries in CFE: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
← Older edit
Ttenbergen (talk | contribs)
CCMDB_legit, admin, approved, Bureaucrats, Interface administrators, Administrators (Semantic MediaWiki), Curators (Semantic MediaWiki), Administrators
92,590 edits
m Text replacement - "NDC Pacemaker acquired wo TISS" to "NDC Pacemaker acquired vs TISS"
 
(28 intermediate revisions by 2 users not shown)
Line 3: Line 3:
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.  
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.  


{{Discuss | who = Trish | question = This manually generated list is now out of date and will be hard to keep up to date. An automatic one exists at [[CFE Data Integrity Checks]] but it is in no priority order. Are these? Can we use the automatic list instead?}}
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.  


== NDC queries / [[CFE Data Integrity Checks]]==
When they have all been corrected you can move to the next step in [[Centralized data Vetting Process]], likely [["Vet all sent" button]].
# [[NDC_missing_L_Tables_content]]
# [[NDC_discharged_incomplete]] (It is ok if there is a list of Incompletes)
# [[Postal_code_cross_check|NDC_Bad_Postal_Code]] ([[Postal_code_cross_check]])(This is corrected when time available) 
# [[NDC_Missing_TransferDate_w_pivot]] (This is done during reports, OK to skip this one)
# [[NDC_CLI_AcqDX_but_NoCLI_DateinTMPV2]]
# [[NDC CLI vs DX but no TISS17 CentralLine]]
# [[NDC_CLI_No_AcqDX_but_CLI_DateinTMPV2]]
# [[NDC_CLI_unacceptable_date]]
# [[NDC_VAP_AcqDX_but_NoVAP_DateinTMPV2]]
# [[NDC_VAP_No_AcqDX_but_VAP_DateinTMPV2]]
# [[NDC_VAP_unacceptable_date]]


{{discussion}} Where on this list would fit:  
== List of NDC queries ==
* [[Check VAP vs TISS ventilated]]
{{#ask: [[Category:Data Integrity Checks]] [[~Query NDC*]] [[DICStatus::implemented||needs review]]
* [[NDC Pacemaker TISS wo acquired]]
|?DICStatus
* [[NDC Pacemaker acquired vs TISS]]
|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]]
[[Category:Postal Codes]]

Latest revision as of 12: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

none found

Full list of queries including declined, retired, etc

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