"almost same patient" check
If any records match on most demographic entries they almost certainly are for the same patient; if they only match on some they are likely for the same patient with a data entry error in the differing field.
A number of "NDC queries" were implemented in Centralized_data_front_end.mdb to check for this:
- NDC_SamePHIN_Site_Diff_chart
- NDC_DiffPhin_SameLN_FN_DOB
- NDC_SamePhin_Diff_LN_FN_DOB_Sex
- NDC_SameChart_site_Diff_PHIN
The queries are used during the Centralized data Vetting Process, see that article for more info.