Centralized data Vetting Process: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
m Text replacement - ""Pushing" Centralized data.mdb" to ""Pushing" Centralized data.accdb"
 
(197 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 ==
* [["Pulling" 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]]
* [["Pushing" 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? ==
[[Category:Data Processing | * ]]
{{discussion}}
 
== Set record as vetted ==
* 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]]

Latest revision as of 12:00, 6 January 2026

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