Table 3 List of administrative health databases accessed and the main variables extracted
From: A team approach to improving colorectal cancer services using administrative health data
Database | Variables |
|---|---|
Nova Scotia Cancer Registry (NSCR)/Oncology Patient Information System | â– Patient demographics â– Diagnosis and staging â– Cancer center referrals and visits â– Treatment information â– Previous and subsequent primary cancers â– Cancer recurrence |
Mental Health Outpatient Information System (MHOIS) | â– Mental health clinic visits â– Demographics â– Diagnoses |
Medical Service Insurance Physician Services (MSIPS) | â– Physician visits â– Diagnoses â– Procedures |
Medical Service Insurance (MSI) Insured Patient Registry | â– Patient demographics â– Enrollment status â– Program eligibility dates |
Licensed Provider Registry | â– Physician demographics â– Physician specialty â– Educational information |
Vital Statistics | â– Patient demographics â– Dates of death â– Cause of death |
Discharge Abstract Database (DAD) | â– Hospital discharges â– Diagnoses â– Procedures |
Canadian 2001 Census Data | Neighborhood or community level measures: â– Education â– Income â– Rural/urban residency |
Seniors' PharmaCare Prescriptions (SP) | Prescription data for individuals 65 years and older: â– Drug ID â– Cost â– Amount |
Community Services Prescriptions (CSP) | Prescription data for individuals less than 65 years who are enrolled in a provincial income assistance program: â– Drug ID â– Cost â– Amount |
Nova Scotia Breast Screening Program | â– Procedure dates â– Procedure types â– Screening results â– Diagnoses |
Cervical Cancer Prevention Program | â– Smear dates â– Diagnosis dates â– Healthcare professional specialty |
Capital Health Radiology Department (CHRD) | â– Radiology procedure codes â– Procedure dates |
Palliative Care Programs (PCP)* | â– Referral/enrollment date into a formal PCP |