Centralized data Vetting Process: Difference between revisions
TOstryzniuk (talk | contribs) mNo edit summary |
|||
| Line 11: | Line 11: | ||
== Check for problems == | == Check for problems == | ||
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_PHIN_Fake (renamed for consistency) | # NDC_PHIN_Fake (renamed for consistency) | ||
# | # NDC_SamePHIN_Site_Diff_chart - fix | ||
# NDC_Chart_9_Digit - 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_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 == | == Make PseudoPHINs == | ||