Centralized data Vetting Process: Difference between revisions
Jump to navigation
Jump to search
TOstryzniuk (talk | contribs) |
TOstryzniuk (talk | contribs) |
||
| Line 12: | Line 12: | ||
Use [[Centralized data front end.mdb]] "NDC" (New Data Check) queries and fix data as needed: | Use [[Centralized data front end.mdb]] "NDC" (New Data Check) queries and fix data as needed: | ||
# NDC_Highest_PseudoPhin | # NDC_Highest_PseudoPhin | ||
# | # NDC_PHIN_Fake_Blank | ||
# NDC_SamePHIN_Site_Diff_chart - fix | # NDC_SamePHIN_Site_Diff_chart - fix | ||
# NDC_Chart_9_Digit - fix | # NDC_Chart_9_Digit - fix | ||
Revision as of 17:22, 30 January 2014
Template:Discussion 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. Trish Ostryzniuk 15:29, 2014 January 24 (CST)
see Basic Analysis Capabilities for functionality not related to vetting new data
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_Highest_PseudoPhin
- NDC_PHIN_Fake_Blank
- NDC_SamePHIN_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_SamePhin_Diff_LN_FN_DOB_Sex - confirm correct (do we have a list for false positives?), fix if needs
- need to create: NDC_SameChart_site_Diff_PHIN
Make PseudoPHINs
- NDC_PHIN_Blank (renamed for consistency)
- NDC_Highest_PseudoPHIN
any other checks after pseudoPhin?
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) Template:Discussion
- can decide at our meeting Jan 30 at 1400 hrs. How and when do you see Pagasa using this field?