Skip to main content
Close

Data Available

PMR’s Enterprise Data Warehouse integrates many different databases across PHSA and contains a range of clinical, financial, administrative and demographic data.

Performance Measurement and Reporting's (PMR) Enterprise Data Warehouse (EDW) is a dynamic system that integrates all its data holdings into a central warehouse. It is continually evolving as PMR acquires new data sources. Additional fields are also developed in-house by PMR analysts to enhance the utility of the data and support new ways to measure and manage research, clinical and administrative operations. 

The EDW contains data mostly from BC Children’s Hospital (BC Children’s) and BC Women’s Hospital + Health Centre  (BC Women’s). 

Standard patient-specific personal identifiers are available. Due to the sensitivity of these data, a strong rationale for the use of personal identifiers is required prior to their release.

Data fields include: 

  • Personal Health Number (PHN)
  • Medical Record Number (MRN)
  • date of birth
  • sex
  • postal code
  • geographic location of residence (e.g., health authority) 

Physician encounters database

The physician encounters database contains clinical data from outpatient clinics at BC Children’s for each patient encounter. Each clinic has a unique form. Common data elements collected include: 

  • clinic name
  • diagnosis
  • intervention
  • visit type (e.g,. new patient, follow-up)
Physicians record information onto paper forms for subsequent entry by a data entry clerk.  
 
Data are available for BC Children's from September 2006.

Nurse Practitioner Reporting Database

The Nurse Practitioner Reporting Database is the primary data collection tool used to support mandatory nurse practitioner reporting. It is designed to collect, process and analyze summary data on nurse practitioner care visits. 

Data collected include:

  • demographics
  • where the activity took place
  • diagnosis
  • patient complexity
  • services provided
This database has been expanded to collect performance metrics to reflect nurse practitioner practice.

Nurse practitioners record patient visit data after the service has been provided in an outpatient clinic, inpatient ward, in the community, school setting or over the phone. 

Data are available for BC Children's and BC Women's from April 1, 2011.

The British Columbia Perinatal Data Registry (BCPDR) is a provincial database managed by Perinatal Services BC.  


The Registry contains data abstracted from obstetrical and neonatal health records on nearly all births in BC, including data from more than 60 hospitals and all home births attended by BC registered midwives. The Registry captures approximately 45,000 births per year.

Data collected include: 

  • past obstetrical history 
  • antenatal, intrapartum, postpartum data 
  • newborn information (at birth, transfers and readmissions)
  • birth information
  • course in hospital
Trained and experienced health coders abstract data from medical charts, using standardized definitions and forms. Rigorous data quality processes are performed to ensure high quality data. 

BCPDR data are available for BC Women's from April 1, 1997. Data are available for the current fiscal year, subject to corrections until the fiscal year closes. 

Perinatal Services BC’s website provides further information and a data dictionary
 
Cerner is a core integrated patient management system at BC Children’s and BC Women’s that collects data to describe the entire patient care journey from arrival to discharge. Data are updated daily.

Cerner consists of several separate modules:

Registration 

This module provides detailed patient flow information including location and time stamps. Data collected includes basic registration, admission, transfer, location, discharge and patient demographics. Information such as "no show" and cancellations is also collected.

Data are available for BC Children's and BC Women's from June 2008. Selected data elements prior to 2008 are available from a non-Cerner data source.

Wait List

Data collected includes referral date, time, source, reason and additional information. It is the recommended method for tracking wait times for outpatient services.

Data are available for selected BC Children's and BC Women's outpatient services from June 2008 or later. Selected data elements prior to 2008 are available from a non-Cerner data source.

FirstNet

FirstNet collects emergency department information, such as admission, provider, diagnosis and discharge.

Data are available for BC Children’s Hospital from June 2008.  Selected data elements prior to 2008 are available from a non-Cerner data source. 

Ambulatory Scheduling

Data collected through the Ambulatory Scheduling module include resources associated with the clinical service (treatment or exam room, specific providers, or provider types) and appointment type. The appointment length of stay is not available for outpatient encounters beyond the initial “scheduled duration” of the appointment. 

Data are available for BC Children's and BC Women's from July 2008. Registration and scheduling data elements from 2001 to 2008 are available from a non-Cerner data source. 
 
The PHSA Corporate Statistics Database collects hospital financial and activity data to enable standardized tracking and reporting on the day-to-day operations of PHSA’s agencies and programs. 

Data collected contribute to Health Authority Management Information System (HAMIS), which is used by the BC Ministry of Health and the Canadian Institute for Health Information

CIHI’s Canadian MIS Database (CMDB) houses merged financial and activity data within a structured framework known as the Standards for Management Information Systems in Canadian Health Service Organizations (MIS Standards).

PHSA’s Corporate Statistics Database contains activity totals for all applicable cost centres across the health authority. Data elements are organized according to an internal PHSA financial hierarchy and are available in summarized form by fiscal period. 

Data quality checks are performed to ensure data quality.

Data are available for all PHSA agencies from April 1, 2008.
 
The Discharge Abstract Database (DAD) is a national database managed by the Canadian Institute for Health Information.

The DAD captures administrative, clinical and demographic information on all hospital discharges (including deaths, sign-outs and transfers) from acute inpatient care across Canada. BC also uses the DAD to capture day surgery. 

Data collected include:

  • patient demographics
  • admission and discharge information
  • patient service
  • service transfers
  • provider information
  • diagnosis and intervention information
  • special care unit information
Trained and experienced health coders abstract data from medical charts, applying Canadian coding standards and CIHI’s rigorous data quality process to ensure high data quality. 

DAD data are available for BC Children's and BC Women's from April 1, 2001. Data are available for the current fiscal year, subject to corrections until the fiscal year closes. Data for earlier years (prior to 2001) are available upon special request. 

CIHI’s website provides further information on DAD's data elements.

The Mental Health Database (MHDB) contains referrals and service activity data for Pediatric Mental Health Services at BC Children’s. The main services contributing to this database are child and adolescent psychiatry inpatient units, psychiatric emergency unit, outpatient mental health clinics and eating disorders services.

Data collected include: 
  • general patient demographics
  • mental health referrals information
  • service activities related to referral outcomes (e.g. redirects, waitlists, admissions and discharges)
  • appointment scheduling
The database does not capture information on patient medications or diagnoses.

Data are entered into the system by intake clerks and/or by designated clerks specific to each mental health service. Intake clerks are responsible for entering information from paper-based standardized referral charts received via internal mail or by fax. Service-specific designated clerks are responsible for recording service activities for their units, including recording date and time of admissions, discharges and waitlists. They also maintain appointment schedules for clinicians within their units. 

Mental health data are available for BC Children's from January 1, 2000. Data for the current fiscal year are subject to data quality corrections until the fiscal year closes. 
The National Ambulatory Care Reporting System (NACRS) is a national database of hospital-based and community-based ambulatory care managed by the Canadian Institute for Health Information (CIHI). 

Data collected include: 

  • patient demographics
  • admission and discharge information
  • triage information
  • financial information
Trained and experienced health coders abstract data from medical charts, applying Canadian coding standards and a rigorous data quality process to ensure high data quality. CIHI’s website provides further information about its data quality program. 

NACRS emergency department visit data (level 1) are available for BC Children’s from April 1, 2012. Data are available for the current fiscal year, subject to corrections until the fiscal year closes.

CIHI’s website provides further information on NACRS' data elements.
 
The Operating Room Scheduling and Operating System (ORSOS) is the primary waitlist management, booking and clinical data system for capturing operating room activity. 

Detailed information is collected on:

  • interventions
  • providers
  • operating room management 
  • waitlist management
Booking information is provided by each surgeon’s office using electronic booking forms and later uploaded into ORSOS by the central booking office. Post-surgical details are collected using paper forms completed by nurses in the operating room and later entered into the ORSOS by clerks. 

Data quality is ensured through a routine report sent by PMR to the surgical department each period. To ensure consistency, the surgical department also regularly reviews the ORSOS waitlist against paper lists managed within each surgeon’s office.

ORSOS data are available for BC Children's and BC Women's from April 30, 1999. Data are refreshed daily.

The Workload Measurement System Database contains patient-level information of workload and patient activities by treatment service professionals.  This database is a required component of the national Standards for Management Information Systems in Canadian Health Service Organizations (MIS Standards). 

 

Data are self-reported by treatment service professionals and collected at the patient encounter level. Data quality checks are performed to ensure data quality.


Data are available for BC Children's and BC Women's from April 1, 2008. Data are refreshed daily.

 

Personal identifiers

 
Standard patient-specific personal identifiers are available for almost all databases. Due to the sensitivity of these data, a strong rationale for the use of personal identifiers is required prior to release of these data.
Data fields include: 
  • Personal Health Number (PHN)
  • Medical Record Number (MRN)
  • date of birth
  • sex
  • postal code
  • geographic location of residence (i.e., health authority)

Ambulatory clinics

 

Physician database

The physician database contains clinical data from outpatient clinics at BC Children’s Hospital, including:

  • diagnosis patient 
  • complexity
  • interventions
Physicians record information onto standardized paper forms for subsequent entry by a data entry clerk.  
 
Data are available from September 2006.

Nurse Practitioner Reporting Database

The Nurse Practitioner Reporting Database is the primary data collection tool used to support mandatory nurse practitioner reporting and is designed to collect, process, and analyze summary data on nurse practitioner care visits. Data collected include:

  • demographics
  • where the activity took place
  • diagnosis
  • patient complexity
  • services provided
This database has been expanded to collect performance metrics to reflect nurse practitioner practice.

Patient visit data are collected after the service has been provided by a nurse practitioner in an outpatient clinic, inpatient ward, in the community, school settings, or over the phone. 

Data are available from April 1, 2011.

Content

 

Content

Content

SOURCE: Data Available ( )
Page printed: . Unofficial document if printed. Please refer to SOURCE for latest information.

Copyright © Provincial Health Services Authority. All Rights Reserved.

    Copyright © 2017 Provincial Health Services Authority