CCMDB Wiki

Centralized data Vetting Process: Difference between revisions

← Older edit
TOstryzniuk (talk | contribs)
CCMDB_legit, approved, Bureaucrats, Administrators
27,522 edits
mNo edit summary
m Text replacement - "[["Pull" Centralized_data.accdb]]" to ""Pull" Centralized_data.accdb"
 
(189 intermediate revisions by 4 users not shown)
Line 1: Line 1:
"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]].


{{Discussion}}
== Instructions ==
Where is the article that listed the 6 QA checks and the Pivot article?  I need to show Pagasa how is was transcribe into this here. [[User:TOstryzniuk|Trish Ostryzniuk]] 15:29, 2014 January 24 (CST)
* [["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]]


'' see [[Basic Analysis Capabilities]] for functionality not related to vetting new data
== Related articles ==
{{Related Articles}}


'''Need to resolve all http://ccmdb.kuality.ca/index.php/Special:WhatLinksHere/Centralized_data_Vetting_Process '''


need to make sure all in [[Data Appending Process]] is addressed.
== Check for problems ==
Use [[Centralized data front end.mdb]] "NDC" (New Data Check) queries and fix data as needed:
# 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? ==
{{discussion}}
== Set record as vetted ==
* last: set [[Record Status field]] to ... how does "vetted" sound? if so, get rid of this comment. Ttenbergen 15:01, 2014 January 16 (CST) {{discussion}}
[[Category:2013 data upgrades]]
[[Category: Data Processing]]
[[Category:Data Processing]]
[[Category:Data Processing]]
Retrieved from "https://ccmdb.kuality.ca/index.php?title=Centralized_data_Vetting_Process"