Centralized data Vetting Process: Difference between revisions

m u
m u
Line 1: Line 1:
*'''need to make sure all in [[Data Appending Process]] is addressed.'''
*'''need to make sure all in [[Data Appending Process]] is addressed.'''


== Pull data ==
== Pull data ==
Line 13: Line 12:
Perform the Queries in this order:
Perform the Queries in this order:


# [[Orphans in Centralized data.mdb| "NDC_orphans"]]
# [[Orphans in Centralized data.mdb| "PL_1orphans"]]
# see [[Generating PseudoPHINs]] (uses NDC_PHIN_fake_or_blank)
# PL_2Phin Fake or Blank (see [[Generating PseudoPHINs]]
# NDC_Diff_Phin_SameLN_FN_DOB
# PL_Diff_Phin_SameLN_FN_DOB
#* Home, Advanced, Advanced Filter/Sort, LastName (double click or drag & drop), Sort by ''ascending'', Home, Toggle Filter
#* Home, Advanced, Advanced Filter/Sort, LastName (double click or drag & drop), Sort by ''ascending'', Home, Toggle Filter
 
# PL_SameChart_Site_Diff_Phin
# NDC_SameChart_Site_Diff_Phin
# PL_SamePhin_Diff_LN_FN_DOB_Sex
# NDC_SamePhin_Diff_LN_FN_DOB_Sex
#* Home, Advanced, Advanced Filter/sort, Phin (double click or drag & drop), Sort by ''ascending'', Home, Toggle Filter
#* Home, Advanced, Advanced Filter/sort, Phin (double click or drag & drop), Sort by ''ascending'', Home, Toggle Filter
# NDC_SamePHIN_Site_Diff_chart
# PL_SamePHIN_Site_Diff_chart