CCMDB Wiki

Quality Assurance queries in CFE: Difference between revisions

← Older edit
mNo edit summary
 
(24 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 = Pagasa | 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]].
# [[PL 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
* [[query 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}}


{{Discuss | who=Pagasa | question =
* need to confirm that all of [[CFE Data Integrity Checks]] are addressed. }}


[[Category:Data Processing]]
[[Category:Data Processing]]
[[Category:Postal Codes]]
[[Category:Postal Codes]]
Retrieved from "https://ccmdb.kuality.ca/index.php?title=Quality_Assurance_queries_in_CFE"