ECHILD
ECHILD BridgingFile query #38
-
Question / Problem statementHi colleagues, with regard to the bridging file in the data catalogue it says that 'pseudo' which is the HES identifier is a Compliance checklist
|
Beta Was this translation helpful? Give feedback.
Replies: 1 comment 3 replies
-
|
Howdy linking different sources of data that was not designed to be used together is not an easy task. In the ideal world, we would say one pupil is exactly one patient. Given records on a person only, we can say this pupil is likely to be this patient based upon this set of characteristics stored in both datasets. Often, there are values which are similar e.g. two people with the same name, or same date of birth etc. Consequently, the one-to-one linkage is broken and we often find that a PMR might be linked to multiple TPID or the other way around. It is important in linked administrative data research for researchers to look at the tabulations of each PMR, and each TPID, to see if they appear more than once. It is then up to the researcher to decide how to deal with this |
Beta Was this translation helpful? Give feedback.
-
|
Thank you for this and all previous answers to my queries! Much appreciated. |
Beta Was this translation helpful? Give feedback.
-
|
What do you suggest for dealing with this? |
Beta Was this translation helpful? Give feedback.
-
|
Primarily a 1:1 match only i.e. removing any TPID's which link to multiple PMRs...and removing any PMR's which link to multiple TPIDs |
Beta Was this translation helpful? Give feedback.
Howdy
linking different sources of data that was not designed to be used together is not an easy task. In the ideal world, we would say one pupil is exactly one patient. Given records on a person only, we can say this pupil is likely to be this patient based upon this set of characteristics stored in both datasets. Often, there are values which are similar e.g. two people with the same name, or same date of birth etc. Consequently, the one-to-one linkage is broken and we often find that a PMR might be linked to multiple TPID or the other way around. It is important in linked administrative data research for researchers to look at the tabulations of each PMR, and each TPID, to see if they …