"almost same patient" check: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
No edit summary
No edit summary
Line 1: Line 1:
not implemented yet, will be implemented with other multi-encounter checks.  
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.  


If records match on all of the following 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


Flag records that match on (all - 1) fields of the following:
The queries are used during the [[Centralized data Vetting Process]], see that article for more info.
* PHIN
* first name & last name
* DOB
* sex
* chart number (if same hospital)


We would likely want a way to exclude legitimately similar patients from future comparisons.
This was actually implemented as part of [[Centralized data Vetting Process]] Ttenbergen 21:31, 2014 April 23 (CDT)


[[Category:Multiple encounter finding and confirmation]]
[[Category:Multiple encounter finding and confirmation]]

Revision as of 20:21, 5 May 2014

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.