Centralized data Vetting Process: Difference between revisions

m Text replacement - "[["Pull" Centralized_data.accdb]]" to ""Pull" Centralized_data.accdb"
 
(195 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]] queries and fix data as needed:
{{Related Articles}}
*'''need content re. correcting actions. chances are those are already in Pagasa's current append instructions... Ttenbergen 15:01, 2014 January 16 (CST){{discussion}}
# 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


#[[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]]