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"
 
(200 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]] 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]]
[[Category:Data Processing | * ]]
#* 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]]

Latest revision as of 13: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: