Table 2:

Health administrative databases

Health administrative database	Description	Database variables or data used
Ontario Registered Persons Database (RPDB)	The RPDB records vital statistics, including date of death.	Date of death Rurality Index Ontario Score Age Sex
Immigration, Refugees and Citizenship Canada Permanent Resident Database	The CIC database contains landing records for every permanent legal immigrant to Canada who arrived from 1985 onward.	Date of landing or immigration
Local Health Integration Network (LHIN) database	The LHIN database contains records of the health authorities responsible for the regional administration of public health care services in the province.	Geographic location of residence of included patients
Ontario Drug Benefit (ODB) database	The ODB database contains highly accurate records for outpatient prescriptions dispensed to patients aged 65 yr or older (with error rates reported to be < 1%).19	Prescription drug fill dates and costs Long-term care indicator
Canadian Institute for Health Information Discharge Abstract Database (CIHI-DAD)	The CIHI-DAD contains validated patient-level demographic, diagnostic, procedural and treatment information on all acute- and long-term–care hospital admissions.	ICD-10 codes for hospital discharge diagnoses and Johns Hopkins ACGs and EDCs Hospital admissions (elective and urgent) and costs
CIHI — National Ambulatory Care Reporting System (NACRS) database	The CIHI-NACRS database contains patient-level demographic, diagnostic, procedural and treatment information for all hospital-and community-based ambulatory care including day surgery, outpatient and community-based clinics and emergency departments.	ICD-10 codes for hospital discharge diagnoses and Johns Hopkins ACGs and EDCs Visits and costs
CIHI — Same Day Surgery (SDS)	The CIHI-SDS contains patient-level demographic, diagnostic, procedural and treatment information for all day surgeries.	ICD-10 codes for hospital discharge diagnoses and Johns Hopkins ACGs and EDCs Visits and costs
CIHI — National Rehabilitation Reporting System (NRS)	The CIHI-NRS contains patient-level demographic, diagnostic, procedural and treatment information from participating adult inpatient rehabilitation facilities and programs.	Visits and costs
Ontario Home Care Database (HCD)	The Ontario HCD contains patient-level demographic, diagnostic, procedural and treatment information or all home care visits.	Home care visits Type of home care service provided Visits and costs
Ontario Continuing Care Reporting System (CCRS)	The Ontario CCRS contains demographic, clinical, functional and resource use information or patients receiving continuing care services in hospitals or long-term care homes in Canada.	Visits and costs
Ontario Mental Health Reporting System (OMHRS) database	The OMHRS database contains patient-level demographic, diagnostic, procedural and treatment information for all psychiatric facility visits.	Visits and costs
ICES Physician Database (IPDB)	The IPDB reports prescriber and specialist referral and billing data in Ontario. The physician demographic data are validated against the Ontario Physician Human Resource Data Centre database.	Visits to primary care and specialists
Ontario Health Insurance Plan database (OHIP)	The OHIP database includes health claims for physician services.	ICD-10 codes for hospital discharge diagnoses and Johns Hopkins ACGs and EDCs All health service visits and costs
Client Agency Program Enrolment (CAPE) database	The CAPE database contains enrolment information of an individual in a program with a specific practitioner and group.	Primary care practitioner reimbursement model of included patients
ICES-derived cohorts: Congestive Heart Failure database Chronic Obstructive Pulmonary Disease database Ontario Crohn’s and Colitis Cohort dataset Ontario Diabetes Dataset Ontario Myocardial Infarction Database Dataset Ontario Rheumatoid Arthritis Dataset	The ICES-derived cohorts are chart-validated cohorts of patients with specific diseases and conditions. These cohorts are created using health administrative case definitions that link hospital inpatient and outpatient care, physician claims and drug benefits data over time using an anonymous unique identifier.20 The case definitions are validated by clinical scientists at ICES using data collected directly from reviews of medical charts in the community. For example, the diabetes and hypertension definitions have a positive predictive value of 80% and 87%, respectively.21,22	Comorbidities of included patients

Note: ACG = Adjusted Clinical Group, EDC = Expanded Diagnosis Cluster, ICD-10 = International Statistical Classification of Diseases and Related Health Problems, 10th Revision.