"almost same patient" check: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
m (Text replacement - "{{DT" to "{{TT")
m (Text replacement - "PL_SamePhin_Diff_LN_FN_DOB_Sex" to "PL_SamePhin_Diff_DOB_Sex")
Line 4: Line 4:
*PL_SamePHIN_Site_Diff_chart  
*PL_SamePHIN_Site_Diff_chart  
*PL_DiffPhin_SameLN_FN_DOB  
*PL_DiffPhin_SameLN_FN_DOB  
*PL_SamePhin_Diff_LN_FN_DOB_Sex
*PL_SamePhin_Diff_DOB_Sex
*PL_SameChart_site_Diff_PHIN
*PL_SameChart_site_Diff_PHIN



Revision as of 14:25, 2020 December 17

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 "PL queries" were implemented in Centralized_data_front_end.accdb to check for this:

  • PL_SamePHIN_Site_Diff_chart
  • PL_DiffPhin_SameLN_FN_DOB
  • PL_SamePhin_Diff_DOB_Sex
  • PL_SameChart_site_Diff_PHIN

The queries are used during the Centralized data Vetting Process, see that article for more info.

See also: Cat button


If we need this page at all it needs to be integrated better.

  • added: no added date
  • action: no action date
  • Cargo


  • Categories