"almost same patient" check: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) m u |
Ttenbergen (talk | contribs) m been PL for a while, not NDC |
||
| Line 1: | Line 1: | ||
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 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 " | A number of "PL queries" were implemented in [[Centralized_data_front_end.mdb]] to check for this: | ||
* | *PL_SamePHIN_Site_Diff_chart | ||
* | *PL_DiffPhin_SameLN_FN_DOB | ||
* | *PL_SamePhin_Diff_LN_FN_DOB_Sex | ||
* | *PL_SameChart_site_Diff_PHIN | ||
The queries are used during the [[Centralized data Vetting Process]], see that article for more info. | The queries are used during the [[Centralized data Vetting Process]], see that article for more info. | ||
Revision as of 18:44, 21 January 2016
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.mdb to check for this:
- PL_SamePHIN_Site_Diff_chart
- PL_DiffPhin_SameLN_FN_DOB
- PL_SamePhin_Diff_LN_FN_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