Max Rady College of Medicine

Concept: Record Linkage in Manitoba

 Printer friendly

Concept Description

Last Updated: 2014-02-24

Introduction

Record Linkage - Key Points

    The following key points identify the objectives and general process of record linkage in Manitoba for data held in the MCHP Data Repository:

    • to maintain privacy and confidentiality of the data;
    • record linkage is performed at Manitoba Health, not at MCHP;
    • each data file is stored separately and unlinked at MCHP;
    • only authorized persons can access the data files. In order to access the data, Ethics and Data Provider approvals must be obtained and a signed Researcher Agreement must be completed;
    • files are merged during the analysis stage at MCHP using an encrypted Personal Health Identification Number (PHIN).

Record Linkage of Health Data

    The key points of performing record linkage with health files include:

    • record linkage occurs at Manitoba Health;
    • an encrypted Personal Health Identification Number (PHIN) is assigned to each record consistently across different health data sets;
    • identifying data, such as names and address are removed from the file(s) prior to being sent to MCHP ( Note: most health related data files are updated on an annual basis); and
    • the encrypted PHIN in each of the files allows merging of data across different data sets.

Record Linkage with Non-Health Data

    The key points of performing record linkage with non-health files involve a "multistage de-identification process". This process, described in Roos et al. (2008), contains the following steps:

    1. the organization who maintains the data prepares a data file containing a scrambled organizational identification number for each individual, as well as identifying information, such as name, address, and date of birth. This file contains no program/service data from the organization.
    2. Manitoba Health uses the information in this file to find the corresponding Personal Health Identification Number (PHIN) for each individual in the Manitoba Health Insurance Registry Data file. For records that match, an encrypted PHIN is attached to each record in the file received from the organization.
    3. all identifying information is removed from the file, so that this "crosswalk" file contains only an encrypted PHIN and the scrambled organizational identification number for each individual. This file is then sent to MCHP.
    4. the organization then sends the corresponding program/service data file to MCHP that contains the scrambled organizational identification number. There is no identifying information in this file.
    5. each data file is stored separately and unlinked at MCHP. Only authorized persons can access the organizational data file(s) and the corresponding "crosswalk" file for approved projects.
    6. files are merged during the analysis stage at MCHP using either the encrypted PHIN and/or the scrambled organizational identification number.

Examples of Record Linkage at MCHP

    The following is a description of the methods used in two MCHP deliverables to link data. Please see the provided links for more information.

1. Garland et al. (2012)

1) Preliminary Processing of the Hospital Discharge Abstracts

    Prior to linking the data, two preliminary processing steps were completed to exclude the following:
    • hospital abstracts that did not represent inpatient hospitalizations (e.g.: outpatient surgery); and
    • duplicate hospital abstracts, identified as identical on five items - PHIN, hospital, hospital chart number, hospital entry date, and hospital separation date.

2) Preliminary Identification of Linkage between the WICUDB and the Hospital Discharge Abstracts

    Linkage of WICUDB records and hospital abstracts was completed by linking:

    1. the combination of the hospital and the hospital chart number
      AND
    2. a. the ICU entry date that occurs on or after hospital entry and on or before hospital separation
      OR
      b. the ICU separation date that occurs on or after hospital entry and on or before hospital separation

    For records that did not link with this initial step, a second step was completed to link the records using:

    1. PHIN
      AND
    2. a. the ICU entry date that occurs on or after hospital entry and on or before hospital separation
      OR
      b. the ICU separation date that occurs on or after hospital entry and on or before hospital separation

    In some instances there were records that were linked to more than one hospital abstract. Steps 3 and 4 address this issue.

    The results of linking the WICUDB records and the hospital abstracts can be found in Table 1.1: Interim Summary of Linkage between the Winnipeg ICU Database (WICUDB) and the Hospital Abstracts after Preliminary Processing on p.6 of The Epidemiology and Outcomes of Critical Illness in Manitoba deliverable by Garland et al. (2012) .

3) Addressing the WICUDB Records that Linked to Two Hospital Discharge Abstracts

    If a single hospital abstract (or two or more abstracts) could be identified to link the WICUDB record to, it was included in the project analyses. For example, if a WICUDB record was linked to two abstracts, the abstract that contains the ICU entry and separation dates within its hospital entry and separation dates would be selected as the abstract to link to. Cases where a WICUDB record could not be linked to a single abstract were eliminated from the project.

    The following six patterns were identified when two abstracts were linked to one WICUDB record (the first occurring abstract is denoted as "Abstract 1", and the second as "Abstract 2"):

    1. The date of hospital separation for Abstract 1 was the same as the date of hospital entry for Abstract 2.
    2. The hospital entry date for Abstract 1 was the same as Abstract 2, but both abstracts had different separation dates.
    3. The hospital entry and separation dates were identical for Abstract 1 and Abstract 2.
    4. The separation date of Abstract 1 was at least one day earlier than the entry date of Abstract 2.
    5. The separation date of Abstract 1 was later than the entry date of Abstract 2, but before the separation date of Abstract 2.
    6. The separation date of Abstract 1 was later than the entry date of Abstract 2, and both abstracts had the identical separation date.

    In all of the above situations, entry and separation dates for the ICU records and the hospital abstracts were compared in order to determine which were appropriately linked, and which records should be eliminated. Please see Results Part 3: Addressing the 180 WICUDB Records that Linked to Two Hospital Abstracts for more information on addressing the WICUDB records that were linked to two abstracts.

4) Addressing the WICUDB Records that Linked to Three Hospital Discharge Abstracts

5) Assessing How the Linked Records from Parts 2-4 Match on Seven Identifying Variables

6) Clarifying Manitoba Residency Status

Validation Process

    Health Information Management (HIM) at Manitoba Health validates records of newly admitted patients to WRHA ICUs every four to six weeks. The validation process involves the crosschecking of names, PHIN, and date of birth data in the WICUDB with the Manitoba Health Insurance Registry. The WRHA makes changes in the WICUDB for any inconsistencies HIM indicates in the crosschecking. Fields in the file from the WRHA used for linkages are PHIN, surname, given name, date of birth, and sex. Four steps are completed sequentially to link files in the WICUDB and the Manitoba Health Insurance Registry. These linked files (matches) were given a match indicator of 1 or 2, specifying how the files were matched, where "1" = PHIN used in linkage, and "2" = PHIN not used in linkage.

    The remaining linkages are visually verified using a 'Proc Print' in SAS in three additional steps. These linked files are also granted a match indicator of 1, 2, or 0, specifying how and whether the files were matched, where "1" = PHIN used in linkage, "2" = PHIN not used in linkage, and "0" = non match.

    At MCHP, the WICUDB database is updated with new files or missing information using the WICUDB records, a Medical Patient Registry Manitoba Health Insurance Registry snapshot, and Manitoba Health hospital abstracts with ICU admission. The following seven steps are followed in order to update missing data on new WICUDB records since previous linkage:

    • Step 1. Exclude all records previously checked by HIM with valid PHINs
    • Step 2. By surname, given (including initials), full birth date
    • Step 3. By surname, full birth date, sex
    • Step 4. By SOUNDEX (surname), full birth date, sex, COMPARE (given)
    • Step 5. By SOUNDEX (surname),sex, COMPARE (given), birth year, birth month,
    • Step 6. By full birth date, sex, COMPARE (given)
    • Step 7. By sex, full birth date, facility, admit and separation date (against hospital abstracts)

    NOTE: ALL matches found in steps 2 through 7 were visually verified.

    More information on the steps of these validation processes can be found in Appendix 1.1:WRHA Critical Care Validation Process-Linkages to Manitoba Health Insurance Registry Performed Regularly and in Appendix 1.2:WRHA Critical Care Validation Process-Linkages to Manitoba Health Insurance Registry when Transferring WICUDB Data to MCHP in Garland et al. (2012) .

SAS Code for ICU Linkage / ICU Episodes

    Example SAS® code for working with the ICU data and identifying ICU episodes of care in the MCHP data is available (internal access only) in the SAS code and formats section below.

2. Chartier et al. (2012)

    Chartier et al. (2012) used record linkage techniques to connect first-order family members (also known as First Degree Relatives : parents, children, siblings, and spouses) together in the Health and Health Care Utilization of Francophones in Manitoba deliverable. The Population Registry contains variables, including the family registration number (REGNO) / (REGNO_CODE) , date of birth, sex, and Personal Health Identification Number (PHIN), that were used to specify de-identified individuals of a family.

    The following additional characteristics were used to specify the type of family members:
    • Mothers - had a Manitoba birth occurring in 1978 or later, as specified in the hospital birth records
    • Fathers - family head, as specified by the REGNO
    • Children - dependents of the female and male family head
    • Siblings - dependents of the same family head at birth
    • Spouses - "spouse pair flag" indicating spouses and common-law spouses reported to Manitoba Health

    More information can be found in the Appendix for Chapter 3: Methods of Chartier et al. (2012)

Related concepts 

Related terms 

References 

  • Chartier M, Finlayson G, Prior H, McGowan K, Chen H, de Rocquigny J, Walld R, Gousseau M. Health and Healthcare Utilization of Francophones in Manitoba. Winnipeg, MB: Manitoba Centre for Health Policy, 2012. [Report] [Summary] (View)
  • Garland A, Fransoo R, Olafson K, Ramsey C, Yogendran M, Chateau D, McGowan K. The Epidemiology and Outcomes of Critical Illness in Manitoba. Winnipeg, MB: Manitoba Centre for Health Policy, 2012. [Report] [Summary] (View)
  • Roos LL, Brownell M, Lix L, Roos NP, Walld R, MacWilliam L. From health research to social research: Privacy, methods, approaches. Soc Sci Med 2008;66(1):117-129. [Abstract] (View)


Request information in an accessible format

If you require access to our resources in a different format, please contact us:

We strive to provide accommodations upon request in a reasonable timeframe.

Contact us

Manitoba Centre for Health Policy
Community Health Sciences, Max Rady College of Medicine,
Rady Faculty of Health Sciences,
Room 408-727 McDermot Ave.
University of Manitoba
Winnipeg, MB R3E 3P5 Canada

204-789-3819