Centralized data Vetting Process: Difference between revisions

m steps: clean-up
Line 14: Line 14:


# [[Orphans in Centralized data.mdb| "NDC_orphans"]]
# [[Orphans in Centralized data.mdb| "NDC_orphans"]]
# see [[Generating PseudoPHINs]] (uses NDC_PHIN_fake_or_blank)
# NDC_Diff_Phin_SameLN_FN_DOB
# NDC_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
# NDC_PHIN_fake_or_blank
 
# NDC_SameChart_Site_Diff_Phin
# NDC_SameChart_Site_Diff_Phin
# NDC_SamePhin_Diff_LN_FN_DOB_Sex
# NDC_SamePhin_Diff_LN_FN_DOB_Sex
Line 22: Line 23:
# NDC_SamePHIN_Site_Diff_chart
# NDC_SamePHIN_Site_Diff_chart


??
NDC_discharged_incomplete
NDC_Highest_PseudoPHIN


QA checks
QA checks
# see [[Generating PseudoPHINs]]
* NDC_discharged_incomplete
#* should always be zero
 
# NDC_Chart_9_Digit
# NDC_Chart_9_Digit
# NDC_Bad_Postal_Code
# NDC_Bad_Postal_Code