CCMDB Wiki

Quality Assurance queries in CFE: Difference between revisions

← Older edit
PTorres (talk | contribs)
CCMDB_legit, approved
1,617 edits
 
(7 intermediate revisions by 2 users not shown)
Line 5: Line 5:
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.  
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]].
These checks can be run in any order.  


# [[query NDC_CLI_AcqDX_but_NoCLI_DateinTMPV2]]
== List of NDC queries ==
# [[query NDC_CLI_vs_DX_but_no_TISS17_CentralLine]]
{{#ask: [[Category:Data Integrity Checks]] [[~Query NDC*]] [[DICStatus::implemented||needs review]]
# [[query NDC_CLI_No_AcqDX_but_CLI_DateinTMPV2]]  
|?DICStatus
# [[query NDC_CLI_unacceptable_date]]
|format=table
# [[query NDC_VAP_AcqDX_but_NoVAP_DateinTMPV2]]
|default=none found
# [[query NDC_VAP_No_AcqDX_but_VAP_DateinTMPV2]]
|intro=Current list of queries
# [[query NDC_VAP_unacceptable_date]]
}}
# [[query NDC_Bad_Postal_Code]](This is corrected when time available) 


{{Discuss | who=Pagasa | question =
{{#ask: [[Category:Data Integrity Checks]] [[~Query NDC*]]
Where on this list would fit:  
|?DICStatus
* [[query NDC VAP no TISS]]
|format=table
* [[query NDC Pacemaker acquired vs TISS]]
|default=none found
* [[query NDC TISS Extubation only on TISS Intubated days]]
|searchlabel=Full list of queries including declined, retired, etc
* [[query NDC_cardioversion_dx_vs_TISS]]
|limit=0
* [[query NDC_Dialysis_TISS_CCI]]
{{Discuss | who=Pagasa | question =  
seems like it should have superseded [[query NDC_CRRT_TISS_CCI]] but both are on CFE. Which do you use?
}}
}}


* [[query NDC_Dxs_vs_TISS_Dialysis]]
== Related articles ==
* [[query NDC_HD_TISS_CCI]]
{{Related Articles}}
* [[query NDC_PD_TISS_CCI]]
* [[query NDC_TISS_CCI_endoscopic]]
* [[query NDC_TISS_Spontaneous_vs_ETT_Trach]]
* [[query NDC_Trach_Dx_TISS]]
* [[query NDC_zCRRT_TISS_no_tmp]]
* [[query NDC_zCRRT_tmp_no_TISS]]
}}


== SMW List ==
{{#ask: [[category:Data Integrity Checks]] [[~Query NDC_*]]
|format=UL
|default=none found
}}


[[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"