Centralized data Vetting Process: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
m Text replacement - "[["Pull" Centralized_data.accdb]]" to ""Pull" Centralized_data.accdb"
 
(193 intermediate revisions by 4 users not shown)
Line 1: Line 1:
'' see [[Basic Analysis Capabilities]] for functionality not related to vetting new data
"Vetting" is our name for the initial quality control our data goes through after [[Data collector]]s finish [[sending]] it. It is one of the main responsibilities of the [[Data Processor]].


'''Need to resolve all http://ccmdb.kuality.ca/index.php/Special:WhatLinksHere/Centralized_data_Vetting_Process '''
== Instructions ==
* [["Pull" Centralized_data.accdb]]
* Double click to open ''Centralized_data_front_end.mdb''
* [[Reconnect CFE and initial error checks]]
* [[Pre-linking checks]] (PL checks)
* [[Populate linking_pairs]]
* [[Correcting suspect links]]
* [[Quality Assurance queries in CFE]] - NDC Queries
** as part of any of those, there might be [[Questioning data back to collectors]]
* [["Vet all sent" button]]
* [[Generate Person IDs]]
* [["Push" Centralized_data.accdb]] to return data to [[Regional Server]] so [[Data collector]]s can [[send]]


== Check for problems ==
== Related articles ==
Use [[Centralized data front end.mdb]] "NDC" (New Data Check) queries and fix data as needed:
{{Related Articles}}
# NDC_PHIN_Fake (renamed for consistency)
# NDC_SamePT_Site_Diff_chart - fix
# NDC_Chart_9_Digit - fix
# NDC_DiffPhin_SameLN_FN_DOB - confirm correct (do we have a list for false positives?), fix if needs
# NDC_SamePhinDiff_LN_FN_DOB_Sex - confirm correct (do we have a list for false positives?), fix if needs


== Make PseudoPHINs ==
# NDC_PHIN_Blank (renamed for consistency)
# NDC_Highest_PseudoPHIN


== any other checks after pseudoPhin? ==
#[[Query for centralized]]
#* should have a list here as we identify and implement, incl the best order to do this in
* last: set [[Record Status field]] to "<what?>" {{discussion}}
** how does "vetted" sound? Ttenbergen 15:01, 2014 January 16 (CST)
[[Category:2013 data upgrades]]
[[Category:Data Processing]]
[[Category:Data Processing]]

Latest revision as of 15:42, 23 July 2025

"Vetting" is our name for the initial quality control our data goes through after Data collectors finish sending it. It is one of the main responsibilities of the Data Processor.

Instructions

Related articles

Related articles: