Centralized data Vetting Process: Difference between revisions
TOstryzniuk (talk | contribs) m →steps: n |
Ttenbergen (talk | contribs) m →steps: clean-up |
||
| Line 14: | Line 14: | ||
# [[Orphans in Centralized data.mdb| "NDC_orphans"]] | # [[Orphans in Centralized data.mdb| "NDC_orphans"]] | ||
# | # 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 | ||
#* 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 | # NDC_SamePHIN_Site_Diff_chart | ||
?? | |||
NDC_discharged_incomplete | |||
NDC_Highest_PseudoPHIN | |||
QA checks | |||
# see [[Generating PseudoPHINs]] | |||
#* should always be zero | |||
# NDC_Chart_9_Digit | |||
# NDC_Bad_Postal_Code | |||
# NDC_Missing_TransferDate_w_pivot | |||
# NDC_CLI_AcqDX_but_NoCLI_DateinTMPV2 | # NDC_CLI_AcqDX_but_NoCLI_DateinTMPV2 | ||
# NDC_CLI_No_AcqDX_but_CLI_DateinTMPV2 | # NDC_CLI_No_AcqDX_but_CLI_DateinTMPV2 | ||
| Line 29: | Line 39: | ||
# NDC_VAP_No_AcqDX_but_VAP_DateinTMPV2 (see [[VAP Dx vs Tmp checking]]) | # NDC_VAP_No_AcqDX_but_VAP_DateinTMPV2 (see [[VAP Dx vs Tmp checking]]) | ||
# NDC_VAP_unacceptable_date (see [[VAP Dx vs Tmp checking]]) | # NDC_VAP_unacceptable_date (see [[VAP Dx vs Tmp checking]]) | ||