Table 1

Databases requested in data linkage

DatabasesDescriptionDate range requested
1. IRCC Database21Demographic and immigration-related data for all permanent residents to Canada1985/04/01 to 2013/12/31
2. BC Vital Statistics22Deaths recorded in BC1985/04/01 to 2013/12/31
3. BC MSP Registration23Dates of registration in the BC MSP1985/01/01 to 2013/12/31
4. BC MSP Physician Billing24Outpatient and inpatient physician fee-for-services billing records, as paid by MSP. Includes ICD-9 diagnostic codes (available since 1991/92) and MSP-specific fee-item codes1985/01/01 to 2013/12/31
5. Hospital Discharge Abstracts (DAD)25BC hospital discharge records (inpatient and day surgeries). Includes up to 20 ICD diagnostic codes and up to 20 procedure codes. Coding systems are ICD-9-CA/CCI (1991/92 to 2000/01) and ICD-10-CA/CCP (from 2001/02 to present)1985/04/01 to 2013/12/31
6. Statistics Canada Census26Income quintiles, by 3-digit postal code area (note: quintiles data only available beginning in 1994): ‘Neighbourhood income per person equivalent, household income adjusted for household size’1989/04/01 to 2013/12/31
7. Statistics Canada Income Bands271000 income bands per year, based on ranking of Revenue Canada's tax filer data of average equalised income per postal code1992, 1996, 2002
8. BC PharmaNet28All drugs dispensed from BC community pharmacies (including drugs paid by MSP and private insurers; excluding inpatient drugs in acute care hospitals)1996/01/01 to 2013/12/31
9. BC Provincial TB Registry (BCCDC-iPHIS)29Active TB and LTBI diagnostics and treatment in BC301985/01/01 to 2013/12/31
10. BC Provincial Renal Agency Database (PROMIS)31All chronic kidney disease clinic visits (after first referral to nephrologist), inpatient/outpatient dialysis visits and transplant registration, collected through BC renal clinics and transplant programmes32 332003/01/01 to 2013/12/31
11. BC Provincial HIV/AIDS Surveillance Database (BCCDC-HAISIS)34All individuals with a positive HIV test done in BC, or reported to the BCCDC. Includes BCCDC confirmatory laboratory testing for HIV antibodies (>95% of all screening tests for HIV in the province), IRCC reporting of HIV-positive status detected through immigration screening medical exams and passive clinician reporting of AIDS cases. Note: mandatory reporting of HIV test-positive status began in 2003351985/01/01 to 2013/12/31
12. BC Cancer Agency Registry36All primary cancers diagnosed in BC residents (obtained from multiple sources, including pathology, cytology, other labs, death certificates and admissions to BC cancer centres)371985/04/01 to 2013/12/31
  • BC, British Columbia; BCCDC, BC Centre for Disease Control; CCI, Canadian Classification of Interventions; CCP, Canadian Classification of Procedures; DAD, hospital discharge abstract database; ICD, International Classification of Diseases; IRCC, Immigration, Refugees and Citizenship Canada; MSP=Medical Services Plan.