Note: The Decision Support Data Request department will not be notified of this data request until this form is "Submitted". If you would like to discuss the data you need for your initiative with a data specialist prior to submitting your Data Request Form, please e-mail
DataRequest@VIHA.ca Date (of most recent change to this form):
* must provide value
Today M-D-Y
Name of project or initiative
* must provide value
Project Number (if one has been assigned by Research Ethics or Quality Improvement Ethics)
Principal Investigator/Initiative Lead Name
* must provide value
The Principal Investigator is the leader of the initiative, and the person who assumes responsibility for the appropriate protection, use and destruction of any data used for the initiative.
Principal Investigator/Initiative Lead e-mail address
* must provide value
Principal Investigator/Initiative Lead phone number
* must provide value
Principal Investigator/Initiative Lead position and institution
* must provide value
Name of Primary Contact person for this data request (if different from the Principal Investigator/Initiative Lead)
Primary Contact person e-mail address (if different from the Principal Investigator/Initiative Lead)
Primary Contact Person phone number (if different from Principal Investigator/Initiative Lead)
Please list the names, positions and institutions of all members of the project team who will have access to the requested data.
* must provide value
If this project is supported by senior Island Health personnel (Director or higher), please provide their Name(s) and Position(s) at Island Health.
Name(s) of Island Health data specialist(s) who assisted with this data request?
Please Note: You can save this Request Form and return to it later. Click on "Save & Return Later" at the end of the form and be sure to record or e-mail yourself the link and access code that enable you to return to the form.
Please Note: Island Health charges an hourly fee for preparation of data extracts. (There is no charge for consultation about Island Health data holdings or the data required to answer a research/QI question.) For more information please e-mail
DataRequest@VIHA.ca Please provide a description of your project/initiative and the question you are trying to answer.
Templates for describing a research project or a quality improvement initiative may be downloaded from the next sections.
If your project is described in a separate document, you may upload that document below.
* must provide value
Download the Research Protocol template
Download the Quality Improvement Initiative template
If you have a project protocol, project charter, or other document describing your initiative/project, please attach it here.
(If you have already uploaded a research project protocol to the ROMEO system, you do not need to upload it again here.)
Do you have an additional project document to upload?
Yes
No
If you have an additional project document, you may attach it here.
Do you have an additional project document to upload?
Yes
No
If you have an additional project document you may attach it here.
Do you have an additional project document to upload?
Yes
No
If you have an additional project document you may attach it here.
Do you have an additional project document to upload?
Yes
No
If you have an additional project document you may attach it here.
What kind of activity is the project/initiative involved in? (please indicate all that apply)
* must provide value
Please explain what "other" kind of activity is involved.
Has this initiative been screened using the ARECCI Tool?
The ARECCI screening tool can be found
here
Please note: when you access the ARECCI tool, it will open a new window/tab on your web browwer. To get back to this Data Request Form, you will have to select the tab in your browser. * must provide value
Yes
No
Please upload a document containing the ARECCI assessment, results and comments by QI Ethics.
Please explain why this project/initiative has not been screened with the ARECCI tool
* must provide value
Has this initiative been registered with the Island Health QI Registry?
The QI Registry can be found
here
Please Note: the QI Registry is only available to and required for Island Health users. * must provide value
Yes
No
Please explain why this project/initiative has not been registered with the QI Registry.
* must provide value
This Data Request form distinguishes three kinds of data. Please indicate the kind(s) of data the project will use. (Please indicate all that apply.)
Data used to Identify the Study Population versus Data used for Analysis
For most projects there are two distinct groups of data:
1) data used to identify the group of people who will be studied, (e.g. Female Island Health seniors who had a heart attack); and
2) the data needed for the analysis to answer the project question, e.g. hospital and medication records for the identified group of people.
This form is used to request data needed for analysis. However, the definition of the study population must also be described in detail so that the correct data are provided for the analysis.
The study population in this example needs to be described in greater detail: What is the definition of "seniors"? Over what time period will they be selected? How will "heart attack" be identified in the data? One way to identify people who had a heart attack to search hospital records for people who received a Most Responsible Diagnosis of myocardiaI infarction during an acute care hospital stay. In this case, which hospitals would also need to be identified.
In most cases, developing a detailed cohort definition requires consultation with a data specialist. To be connected with a data specialist relevant to your study, e-mail DataRequest@viha.ca
Study Population - Please refer to this document to help you describe your study population.
Describe the study population
Estimated number of people in the study population (if known).
Will consent be obtained from the people whose records you are requesting?
* must provide value
Yes
No
If consent will be obtained, please attach the consent form here.
Do you have another document related to consent, such as an information sheet provided to potential participants, you would like to upload?
Yes
No
Please upload additional consent documentation here.
Please explain why consent will not be obtained
Is person-level information required for this project/initiative?
'Person-level information' means each row or record is related to a single person.
Yes
No
Please document your Data Management Plan to describe how you will protect the person-level data required for the project.
A Data Management Plan template can be found here. The Data Management Plan can be uploaded in the next step.
Please upload the project's Data Management Plan here.
* must provide value
What is the time period of the data required?
e.g. the project requires health records for the identified study population from January, 1 2017 to December 31, 2018. (Please enter dates in the next two fields below.)
Start date (Month-Day-Year)
Today M-D-Y
End date (Month-Day-Year)
Today M-D-Y
Please provide any other relevant information about the time period for the data.
If data are needed until a certain number of cases accrue, how many cases are required?
Please enter integer
Please identify the categories of data required for the project. Choose all that apply.
(Once you select a data category, a check-list of data elements for that category will appear below.)
If you need help to complete this portion of the Data Request form, please e-mail
DataRequest@VIHA.ca
* must provide value
If 'Other' was selected, please describe the data you require.
Patient Information
(select only the data fields required for this project.
Note: you do not need to select the patient information that will be used to identify the study cohort. Only select the information you required about the study cohort.)
* must provide value
If 'Other' was selected, please describe the data you require.
Blood Bank
(select only the data fields required for this project)
Product ID - Uniquely identifies a product
Product Class - A code value that identifies the class of products to which this specific type of product belongs - Blood Products, Derivatives.
Product Category - A code value that identifies the category of products to which this specific type of product belongs. - Red Cells, Frozen Plasma, IVIG, RhIG etc.
Product Type - Defines the type of the product of interest for reporting; Blood, Plasma, Platelets, Cryo, Factor, IVIG, etc
Product Name - A code value that identifies the name of product (e.g. Fresh Frozen Plasma) read from the label on the bag of blood. - RBC SAGM LR, Red Cells Syringe, Pooled Cryo etc.
Product Number - The number assigned to the product to identify it. Also known as "unit number". It is entered at the time the product is received into the blood bank's inventory, from the label on the actual bag of blood. In the case of derivative products, it is the lot number from the batch of derivatives. - C051015161973, C051016211496 etc.
Product ABO Type - A code value that identifies the current ABO group of the blood component product, whether entered at the time it was received, or confirmed through testing (e.g. "A", "B", "O").
Product Rh Type - A code value that identifies the current Rh for the blood component product, whether it was entered at time of receiving it or confirmed through testing (e.g. "Pos", "Neg").
Current Product Expiration Date Time - Most recent updated date and time for when the product is expired.
Number of Units per Pooled Cryo - Total number of products (units) used to create Pooled Cryo.
Product Final Disposition - Indicates the product final disposition being either transfused or disposed.
Order Name - Name of the product being ordered - Red Blood Cells Product; Albumin 25% Product; IVIG Product; Albumin 5% Product; RhIG Product; Plasma Product; Platelets Product; SCIG Product; Factor VIII Product; etc.
Unit of Measurement - Unit of measurement extracted from the product order entry form - Number of Units/Milliliter (mL), Alb 25% - mL, Alb 5% - mL, RhIG - IU, C1 Esterase - IU, Factor XI - IU, Fibrinogen - g, Number of 2.5g CMV IG Vials, Number of 2mL vials, Number of VZIG 125 IU vials, etc.
Quantity Ordered - Quantity entered on the product order associated with Unit of Measurement data entry box - 250mL, 250 IU, 0.5mL, 37.5, etc.
Estimated Total number of Doses on Order - Estimated total number of dose manually entered on the product order as applied.
Total Quantity Ordered - Indicates total quantity of the product ordered; it is calculated by Quantity_Ordered * Estimated_Doses_Ordered entered on the order entry form.
Clinical Indication Entered On Order - Clinical indication entered by selecting from the dropdown list at the time when the order is entered - Hgb < 70 g/L, Acute bleed, Acute ongoing hemorrhage, Open Heart Surg, On Hold for OR, Urgent transfusion, etc.
Number of Units Dispensed Associated with Order - Indicates # of units dispensed associated with order - Applicable to blood component products with valid order_id only;
Number of Units Transfused Associated with Order - Applicable to blood component products with valid order_id only
Transfusion Encounter - Uniquely identifies the encounter for transfusion event
Transfusion Encounter Type - Indicates encounter type for transfusion event
Patient receiving transfusion - Uniquely identifies the patient who received transfusion
Patient ABO Type - A code value that identifies the historical ABO group of the person - A,B,O, Null - Null value is expected as transfusion can be done without patient's ABO/Rh being available
Patient Rh Type - A code value that identifies the historical Rh type of the person (ex. "Pos", "Neg"). - Null value is expected as transfusion can be done without patient's ABO/Rh being available
Presumed Transfused Date Time - Presumed date and time when the product is transfused to patient - Actual transfusion time is not captured in Cerner. What is captured as Transfused Time is a system-generated time using Dispensed Time + 30 minutes;
International Unit Transfused - Number of international units (IU) transfused to the patient - Applicable to derivatives only for the product with the unit of measurement is 'IU'
Vials Transfused - Indicates the quantity of the derivative batch transfused to the patient - Applicable to derivatives only
Volume (mL) Transfused - Indicates the actual volume (mL) being transfused to the patient - Applicable to both blood components and derivatives; For the blood component product, this indicates the volume of the product that was actually infused into the patient. this amount may not be the entire volume that was in the bag.
For derivatives, this indicates the volume of each item within the derivative batch being transfused to the patient.
Gram Transfused - The total grams transfused to the patient - Applicable to derivatives only;
It is calculated by the number of items that make up the batch multiplied by the volume of each item within the batch
Unit Transfused - Number of unit transfused to the patient - Applicable to blood components only;
RBC Age (in Days) at Transfusion - RBC product age at the time of transfusion - Applicable to RBC only;
Platelet Age (in Days) at Transfusion - Platelet product age at the time of transfusion - Applicable to Product type 'Platelet' only;
Transfuse Event Indicator - Indicates if the event is a transfuse event or not - 0=no; 1=yes
Dispense Date Time - Date and time when the product is dispensed and associated with active transfusion - Product being dispensed without active transfusion occurred are not captured in the model
Dispense Reason - A code value that identifies the reason for dispense - For Infusion, Transfusion, MHP, Unmatched, Tissue - for Implantation
Inventory Area at Dispense - A code value that identifies product inventory area associated with dispense - RJH Blood Bank, NRG Blood Bank etc.
Dispense to Location (Unit and Site) - A code value that identifies patient's location at the time when the product is dispensed - DIALYSIS-RJH, CVU-RJH, ICU-NRG, etc
Dispense Event Indicator - Indicates if the event is a dispense event or not- 0=no; 1=yes
Dispose Date Time - Date and time when the product is disposed
Dispose Reason - A code value that identifies the reason for the dispose of the product - Modified, Product Expired, Integrity Compromised, Temp outside of blood product's limits, At R.T. >30 min, Send to St.Paul's (102), Send to Royal Jubilee (201), Corrected, etc
Inventory Area at Dispose - A code value that identifies product's inventory area associated with dispose event - NRG Blood Bank, RJH Blood Bank, VGH Blood Bank, CDH Blood Bank, CRG Blood Bank, zzCRH Blood Bank, etc
Dispose Event Indicator - Indicates if the event is a dispose event or not - 0=no; 1=yes
Other
If "Other" was selected for Blood Bank data, please list and describe the additional Blood Bank data elements required for this project.
Client Roster
The Client Roster is provided by the Ministry of Health. It contains demographic and geographic data of persons registered with the provincial health insurance plan (BC Medical Services Plan or MSP).
Patient records are snapshots as of July 1st of the fiscal year. Fiscal years are from April 1st to March 31, therefore the fiscal year 2019/20 is from April 1, 2019 to March 31, 2020.
Island Health obtains this information from the BC Ministry of Health (MOH), and its use is governed by an Information Sharing Agreement. The MOH does not permit Island Health to provide this information for research purposes. If you wish to access this information for research, please apply directly to the MOH.
Please note: If you apply for access to Client Roster, Heath System Matrix, or Population Grouping Methodology data (collectively known as Common Ground data) from Island Health, please download and complete the Common Ground application form, in addition to this form.
Fiscal Year Label
Client Gender - Client gender is the sex of the client. Sample values are: F Female, M= Male, N=Not Stated, O = Indeterminate, U= Unknown
Client Age Group - Client Age Group is the 5 year cohort that clients are grouped into based on their age at time of service, in the fiscal year. There are 20 groups and sample values are <1, 1-4, 5-9,10-14,...,85-89,90+
Client Birth Month - Month of Birth
Client Birth Year - Year of Birth
Client date of death
Client Forward Sortation Area - first three characters of the client's home postal code in the fiscal year.
Client Census Subdivision - the Stats Canada Census Subdivision the client lived in during the fiscal year.
Client HA - The Client Health Authority is a one-digit code that identifies the HA within BC in which the patient lives in the fiscal year.
Client HSDA - The Client Health Service Delivery Area is a two-digit code that identifies the HSDA within BC in which the patient lives in the fiscal year.
Client LHA - The Client Local Health Area is a three-digit code that identifies the LHA within BC in which the patient lives in the fiscal year.
Old Client LHA 1997 - the three-digit code that identifies the LHA within BC changed in 2018. This provides the older version of the three-digit LHA code in which the patient lived in the fiscal year, to allow mapping between the old and new LHA codes.
Other
If "Other" was selected for Client Roster data, please list and describe the additional Client Roster data elements required for this project.
The Community Health Services (CHS) data
Community Health Services are services delivered in the community, primarily in patients' homes. These services include Home Support, Home Care, and Assisted Living.
'Home Support' services are assistance with personal care (getting out of bed, getting dressed, bathing, eating, sometimes light housekeeping and food preparation).
'Home Care' services are professional services - nursing care, physiotherapy, massage therapy, occupational therapy, etc.
'Assisted Living' is publicly subsidized assistance for seniors and people with physical disabilities who need a safe environment to live, and help with daily tasks. It includes: rental accommodation; hospitality services (meals, housekeeping, recreation supports, emergency response); and personal care assistance.
Home and Community Care (HCC) was the name previously used for the Community Health Services program.
Community Health Services (CHS)
The data checklist for a sub-section? will be displayed on this form only if the section is selected here..
1. Home Care - Referrals
(select only the data fields required for this project)
ADP Service Days - Number of ADP (Adult Day Program) Service Days.
DAYS WAITING MET PRIORITY NUMERATOR - Number of cases where the number of days a client waited to receive service met the assigned wait time and did not exceed the allowable wait time.
DAYS WAITING NUMBER - Actual number of days a client waited for service or the number of wait days accrued while still waiting.
HS Service Days - Number of days when a client received Home Support Services.
Length of Referral Duration - Provides an estimate of a referral length of stay.
Length of Service Duration - Length of time between the first and last service in a referral. A proxy only as the dates are not completely reliable.
Service End Delay - Time between last service date and referral closed date.
Total Service Days - Count of ADP (Adult Day Program) or Home Support Days.
Visit Service Days - Sum of days when a visit or a service occurred.
ADP Service Days - ADP (Adult Day Program) service days set and granted (authorized) for a client to attend an ADP program from an approved Island Health representative.
Age at referral Closed - Referral closed date minus client birthdate. Age when a client stopped receiving a particular service.
Age at Referred on - Referral opened date minus client birthdate. Age when a client began receiving a particular service.
Case Opened Reopened Date - Date the client first became known to HCC (Home and Community Care). If the client had been seen previously and was fully discharged from care, it is the date the client was
referred back to HCC for further service (Ministry of health definition). Once first contact is made with the home care program, the Cerner home care encounter is created. An interface transfers this information to PARIS, where an 'intake referral' is created for the potential home care recipient. Once the home care team has confirmed the client's eligibility, the case management team assesses the client needs based on the RAI
HCS REFERRAL COMMON ONE - Includes several items common to all referrals: - Client Group - Reason for ending service - Referral Priority (code) - Referral Priority description - Referral Source - Referral Status.
HCS REFERRAL COMMON TWO - Includes several items common to all Home Care referrals. ADP (Adult Day Program) Active - Home Support Active - Professional Service Active - Assisted Living Active - Home Support Authorization - Residential Status - ADP (Adult Day Program) and Home Support Service Received - Respite Client Status
HCS REFERRAL TREATMENT REASON - treatment reasons at time of referral
HCS TEAM - Name of the team a client or resident is assigned to. Home Care Teams are typically located in community offices serving various geographies and the team names describe the geographies they serve. In addition there are several
regional teams identified by function.
INVOLVED PROF - Identifies the involved staff person for a client service.
Involved Prof Group - Identifies the professional disciplines involved with client care
Length of Referral Duration - Can be used to visualize the days between referral open date and referral closed date where there are large volumes of days over long lengths of time. Hours are grouped in bands
of hours i.e.: 0-100, 1000-2000 or 10,000+.
Length of Service Duration - Can be used to visualize the days between first and last service day where there are large volumes of days over long lengths of time. Hours are grouped in bands of hours i.e.: 0-
1000-2000 or 10,000+.
Received At Time - Time of day a referral was received by the team providing service.
Received On Date - Date a referral was received by the team providing service.
REFERRAL CLOSED DATE - Date a referral was closed.
REFERRED ON DATE - Date identified as the day the client requires service.
Service End Date - Last date of service on the referral.
Service End Delay - Can be used to visualize the delay between last visit date and referral end date where there are large volumes of days over long lengths of time. Hours are grouped in bands of
hours i.e.: 0-100, 1000-2000 or 10,000+
Service Start Date - This date is the date of the first service provided. Face to Face or remote visits qualify as a start. Must be on or after the Referred On Date.
Total Service Days - Can be used to visualize the visit days where there are large volumes of days over long lengths of time. Hours are grouped in bands of hours i.e.: 0-100, 1000-2000 or 10,000+.
Visit Service Days - Can be used to visualize the visit days where there are large volumes of days over long lengths of time. Hours are grouped in bands of hours i.e.: 0-100, 1000-2000 or 10,000+
2. Home Care - Services
(select only the data fields required for this project)
3. Home Care - Assessments - HCRS and RAI-HC
The data checklist for a RAI-HC sub-section will be displayed on this form only if the sub-section is selected here.
b) RAI-HC - Legal guardian, advance directive, payment
c) RAI-HC - Referral Date and Reason
d) RAI-HC - Assessment date and reason
e) RAI-HC - Memory and cognition
f) RAI-HC - hearing, vision, communication
g) RAI-HC - Mood, behaviour, socialization
h) RAI-HC - Informal Care
i) RAI-HC - Self Performance; Activities of Daily Living (ADL)
j) RAI-HC - Locomotion and Mobility
k) RAI-HC - Functional Potential
m) RAI-HC - Disease diagnosis and conditions
p) RAI-HC - Lifestyle and health status
q) RAI-HC - Weight and food consumption
r) RAI-HC - Skin and ulcers
s) RAI-HC - Living Arrangement
t) RAI-HC - Formal Care Received/provided
P1-A Formal Care: Number of Days - valid values: 0, 1, 2, 3, 4, 5. 6, 7. (P1aA Home Health Aides - Days; P1bA Visiting Nurses - Days; P1cA Homemaking Services - Days; P1dA Meals - Days; P1eA Volunteer Services - Days; P1fA Physical Therapy - Days; P1gA Occupational Therapy - Days; P1hA Speech Therapy - Days; P1iA Day Care or Day Hospital - Days; P1jA Social Worker in Home - Days)
P1-B Formal Care: Hours - valid values: 0-999. (P1aB Home Health Aides - Hours; P1bB Visiting Nurses - Hours; P1cB Homemaking Services - Hours; P1dB Meals - Hours; P1eB Volunteer Services - Hours; P1fB Physical Therapy - Hours; P1gB Occupational Therapy - Hours; P1hB Speech Therapy - Hours; P1iB Day Care or Day Hospital - Hours; P1jB Social Worker in Home - Hours)
P1-C Formal Care: Mins - valid values: 0-99. (P1aC Home Health Aides - Mins; P1bC Visiting Nurses - Mins; P1cC Homemaking Services - Mins; P1dC Meals - Mins; P1eC Volunteer Services - Mins; P1fC Physical Therapy - Mins; P1gC Occupational Therapy - Mins; P1hC Speech Therapy - Mins; P1iC Day Care or Day Hospital - Mins; P1jC Social Worker in Home - Mins)
P2a-P2z Special Treatments, Therapies, Programs - valid values: 0 Not applicable; 1 Scheduled, full adherence as prescribed; 2 Scheduled, partial adherence; 3 Scheduled, not received. (P2a Oxygen; P2b Respirator for Assistive Breathing; P2c All Other Respiratory Treatments; P2d Alcohol/Drug Treatment Program; P2e Blood Transfusion(s); P2f Chemotherapy; P2g Dialysis; P2h Infusion - Central IV; P2i Infusion - Peripheral IV; P2j Medication by Injection; P2k Ostomy Care; P2l Radiation; P2m Tracheostomy Care; P2n Exercise Therapy ;P2o Occupational Therapy; P2p Physical Therapy; P2q Day Centre; P2r Day Hospital; P2s Hospice Care; P2t Physician or Clinic Visit; P2u Respite Care; P2v Daily Nurse Monitoring; P2w Nurse Monitoring Less Than Daily; P2x Medical Alert Bracelet or Electronic Security Alert; P2y Skin Treatment; P2z Special Diet)
P2aa Special Treatment - None of the Above - valid values: 0 No; 1 Yes.
P3 Management of Equipment - valid values: 0 Not used; 1 Managed on own; 2 Managed on own if laid out or with verbal reminders; 3 Partially performed by others; 4 Fully performed by others. (P3a Oxygen; P3b IV; P3c Catheter; P3d Ostomy)
P4 Visits in Last 90 Days (or Since Last Assessment) - valid values: 0,1, 2, 3, 4, 5, 6, 7, 8, 9. (P4a Number of Overnight Hospital Admissions; P4b Number of ER Visits Without an Overnight Stay; P4c Emergent Care)
P5 Treatment Goals - valid values: 0 No change; 1 Improved - receives fewer supports; 2 Deteriorated - receives more support.
P6 Overall Change in Care Needs - valid values: 0 No; 1 Yes
P7 Trade Offs - valid values: 0 No; 1 Yes.
4. Home Support - Days
(select only the data fields required for this project)
The data dictionary has not been completed for this dataset.
Private Days of Service
Regular Days of Service
Short Term Days of Service
Total Days of Service
Total Hours of Service
Total Private Hours of Service
Total Private Visits
Total Regular Hours of Service
Total Regular Visits
Total Short Term Hours of Service
Total Short Term Visits
Total Visits
Age - Date of interest minus date of birth (calculated)
Expired Flag - Flag set when a client is deceased.
Gender - sex of the person.
GL Organization - Defines organizational accountability structure from CEO to department and extending to the level of employee belonging to the department.
HCC ADL LF Group
HCC ADL SP Group
HCC AS CPS Group
HCC HS Client Home Geography - Client's home geography at the time of the service, based on client's postal code.
HCC HS Department Status - Classification of a client's status. - Active - Held - Terminated - Discharged
HCC HS Funders - Classification of the types of care based on the intention of the care. - Long Term Support - Maintenance - Private - Home Care Acute - Home Care End of Life - Rehabilitation - Short Term Care.
HCC HS GL Accounting Period - Standardized time periods (13 fiscal periods per year) for activity reporting and financial accountability.
HCC HS Provider Geography - Classification of provider locations based on the postal code of the office location of the service providers. (Taken from Department Table in Procura). Geographic areas: cities,
Health Authority, HSDA etc.
HCC HS Service Date - classification of date characteristics, e.g. date can be attributed to: week of the year; fiscal period; or calendar month.
HCC HS Service Time - classification of time characteristics, e.g. time can be attributed to: am or pm; morning; or hour of the day.
HCC IADL DS Group
HCC IADL INV Group
HCC Provider - classification of service by provider type, e.g. home support, or assisted living.
Marital Status - marital status of client: married, single, apart, common law.
5. Home Support - Visits
(select only the data fields required for this project)
The data dictionary has not been completed for this dataset.
6. Assisted Living Facility Stays
(select only the data fields required for this project)
Authorized Hours - Number of Hours authorized for a subsidized Home Support service. Home Support hours must be authorized for all subsidized services. The hours authorized are for a month at a time.
Billing Service Day Counter - Counter to capture a billable service day when the reason for discharge from residential care is death. In MOH policy it is permissible to bill for the date of death. However, most systems do not count the date of discharge as a service day and this work around was required to meet the MOH policy requirements
Calculated Hours - Estimate of hours that a client should require based on RAI-HC (Residential Assessment Instrument - Home Care) content and subsequent algorithm. This field was to test an approach to estimating Home Support hours.
Home Support Service Days - Number of days when a client received Home Support Services. Client co-payments are based on a per day rate.
Home Support Service Hours - Number of hours Home Support Services a client received.
In Person visits - Number of Home Care visits that where conducted face to face. The location of the visit doesn't matter, just the fact that the service provider was in the presence of the service recipient.
Remote visits - Count of visits that are made without being in presence of the client or with a care giver provided the care of the client is influenced by the call. Remote visits can include telephone, email as examples
Service Day Counter - Adds a count of 1 to the total for each day that a service is provided. Enables summing and other calculations to be applied.
Total visits - Sum of remote and face to face visits.
Admit Date - Start date of the encounter. Refers to when the patient arrived for care. Start date of the Residential encounter for the inpatient encounter type. This table only brings in the Residential encounter, even though the client may be receiving home care.
Age at Admit - Admit date minus date of birth (calculated). Note - was age at admission, not current age.
Age at Discharge - Date of interest minus date of birth (calculated). Resident's Age at Discharge from the Facility.
Age at Service - Date of interest minus date of birth (calculated). Service date minus the client birthdate.
Client Group - Classification of Home Care Clients based on need. CIHI has defined Home Care client groups. MOH has added an additional group Residential to conform with reporting in BC
Date accepted for service - Date when a client is deemed to be accepted for service. Acknowledgement by the health authority that the individual qualifies for service, based on assessed needs and admission criteria as stated in Home and Community Care Policy Manual.
Date case opened reopened - Date the client first became known to the Home and Community Care program. If the client had been seen previously and was fully discharged from care, it is the date the client was referred back to HCC for further service.
Discharge Date - End date of the encounter. Date Resident leaves (is discharged from) a facility.
Discharge Disposition - Anticipated location following discharge, or the reason for discharge.
Encounter Type - Categorization of encounters into different types of care. Assisted Living clients are registered in Cerner using the Residential Encounter Type.
Facility Encounters Flag - Set of various characteristics related to a service provider that can be used to filter and focus analysis. Items include Referral source, MRR Type Description, MOH Provider number and Provider description.
HCS TEAM - Name of the team a client or resident is assigned to. Home Care Teams are typically located in community offices serving various geographies and the team names describe the geographies they serve. In addition there are several regional teams identified by function.
IH Encounter Number - Unique number for the Home Care encounter in Cerner Registration. All Home Care clients must have an open Home Care encounter as long as they receive any Home Care service,
including when in assisted living (AL uses the Residential Encounter type but AL refers to independent housing situation where hospitality services are provided, NOT residential car
INVOLVED PROF Group - Identifies the professional disciplines involved with client care
Location - Name of facility where the service was delivered
Patient Service - Classification of services a patient, client or resident is receiving
Service Date - Date a service was provided.
Other
If "Other" was selected for Community Health data, please list and describe the additional Community Health data elements required for this project.
Emergency Room Visits
An Emergency Room Visit is a record of an interaction in an Emergency Department between a patient and a health care provider for the purpose of providing healthcare service(s) or assessing the health status of a patient.
Note: Visiting an Emergency Department, and being admitted to an inpatient ward in a hospital, are two distinctly different types of encounters, and are recorded in different datasets. For additional information on hospital inpatient visits, please see "Acute Care Hospital (DAD)".
For additional information on all encounter types, see "Encounters". An "encounter" is a record of an interaction between a patient and a health care provider for the purpose of providing healthcare service(s) or assessing the health status of a patient.
Note: Emergency Room Visit data and NACRS data are not the same thing. NACRS data are also about Emergency Room Visits, however the dataset covers fewer facilities and contains a subset of the Emergency Room Visit data. See NACRS data, also in this form.
Emergency Department (ED) or Urgent Care Centre
(select only the facilities required for this project)
Emergency Encounters
(select only the data fields required for this project)
Admit Provider - the admitting physician
Age - ER Registration Date minus Date of Birth
Attending Provider - The Emergency Room physician entered as the Most Responsible Physician at the end of the encounter.
CEDIS Presenting Complaint Display - Canadian Emergency Department Diagnosis Shortlist code - more specific (e.g. cardiac arrest, chest pain, palpitations, hypertension, general weakness, fainting, etc.)
CEDIS Presenting Complaint Group - Canadian Emergency Department Diagnosis Shortlist code - less specific (e.g. cardiovascular, ear, gastrointestinal, genitourinary, mental health, neurologic, etc.)
Discharge Disposition
Encounter number - An encounter identifier created within the Enterprise Data Warehouse (EDW), from an interaction between a patient and a health care provider for the purpose of providing healthcare service(s) or assessing the health status of a patient.
ER Admit Mode - Air Ambulance/Ground Ambulance/Both/No ambulance
ER Discharge Date - Date the Emergency encounter type portion of the Emergency Encounter ended. For ER Encounters that did not transition to an inpatient hospital encounter, this is the Discharge Date of the whole encounter. For ER Encounters that did transition to a hospital inpatient encounter, this is the date when the encounter became "Inpatient".
ER Discharge Disposition - 0 if the Emergency Encounter was not admitted as an inpatient at the facility. 1 if the Emergency Encounter was admitted as an inpatient at the facility.
ER Discharge Time - Time the Emergency encounter type portion of the Emergency Encounter ended. For ER Encounters that did not transition to an inpatient hospital encounter, this is the Discharge Time of the whole encounter. For ER Encounters that did transition to a hospital inpatient encounter, this is the time when the encounter became "Inpatient".
ER Patient Time - time from triage to discharge (or decision to admit to an inpatient ward)
ER Registration Date - Date the encounter arrived at the Registration/Triage Desk and the encounter began. For Non-Admitted ER Encounters this = the Discharge Date/Time of the whole encounter.
ER Registration Time - Time the encounter arrived at the Registration/Triage Desk and the encounter began.
ER to Daycare - the encounter went from Emergency Encounter type to Daycare Encounter type (may or may not later go to inpatient)
ER to Inpatient - the encounter went directly from Emergency Encounter type to Inpatient Encounter type
ER Triage Acuity Level - Canadian Triage Acuity Score (CTAS); this value is available electronically only from emergency departments and urgent care centres that use the FirstNet system (see above). 1- Resuscitation ; 2 - Emergent; 3 - Urgent; 4 - Less Urgent; 5 - Non-Urgent; Unassigned.
ER Triage Date - Date the patient arrived at the Registration/Triage Desk and the encounter began.
ER Triage Time - Time the patient arrived at the Registration/Triage Desk and the encounter began.
ER Type - type of facility the encounter was at: Acute Care Hospital Emergency Department, or Urgent Care Centre.
ER Visit Only - the encounter is Emergency only (does not transition to or from an Inpatient Encounter or Daysurgery Encounter)
ER Visit Site Code - Emergency Department site or Urgent Care Centre acronym
ER Visit Site Name - Emergency Department site or Urgent Care Centre name
ER Visit Type - unscheduled, consult only, unassigned
For Admitted ED Encounters, this is when the encounter became Inpatient.
Gender
Inpatient Admit Date - date the decision was made to admit the patient to an inpatient hospital ward.
Inpatient Admit Time - time the decision was made to admit the patient to an inpatient hospital ward.
Inpatient Discharge from ER - To indicate an encounter was admitted, but discharged or deceased prior to being placed in an inpatient bed.
Left Emergency Without Being Seen - Patient came to the ER and left before being seen by a physician.
Patient - encrypted study identification number
Patient Home Geography - Based on patient's home postal code for this encounter. Can be reported as Forward Sortation Area (first three characters of postal code only), Community Health Service Area, Local Health Area, or Province - please document the geography you require by selecting "Other" and making a note below.
Primary Care Provider - the provider (usually physician) the patient identifies as his/her family care provider/family physician during the encounter.
Triage to ERP Minutes - Time from Triage to Assessment by Physician
Other
If "Other" was selected in any of the Emergency Encounter check lists above, please list and describe the additional Emergency Encounter information required for this project.
Encounters
An "encounter" is a record of an interaction between a patient and a health care provider for the purpose of providing healthcare service(s) or assessing the health status of a patient.
Encounter Types
Please select only the encounter types you require for your project/initiative.
Encounter Variables
Select only the data fields required for this project.
Please note that visiting an Emergency Room, and being admitted to a hospital inpatient ward, are two distinctly different kinds of encounters. For additional information on services received in emergency rooms or urgent care centres, see Emergency Room Visits. For information on services received as a hospital inpatient, see Hospital Stays.
Admit Age - Age at time of Admission
Admit Date - Start date of the encounter (any type). For non-inpatient encounters, this is the "registration date."
Admit Patient Service - Cerner Patient Service Code at Time of Admission. Only applicable for Inpatient Encounter Class. If an Emergency Encounter is changed to an Inpatient Encounter, the admit service is from the Inpatient Encounter.
Admit Time - Start time of the encounter. For non-inpatient encounters, this is the "registration time."
Age - Date of Birth minus ER Registration Date
Discharge Age - Discharge Date minus Date of Birth
Discharge Date - End date of the encounter.
Discharge Disposition - Examples: home, deceased, transferred to a facility, left against medical advice. "Left without being seen" is an option only for Emergency Department Encounters. After April 1, 2016, the discharge disposition is assigned when the encounter changes from one Encounter Type to another, such as Emergency to Inpatient. Discharge Location
Discharge Location Functional Centre - Location at the end of the encounter - based on functional centre.
Discharge Location GL Organization - Location at the end of the encounter - based on General Ledger.
Discharge Time - time of discharge; caution - may be default value of midnight.
Encounter number - An encounter identifier created within the Enterprise Data Warehouse (EDW), from an interaction between a patient and a health care provider for the purpose of providing healthcare service(s) or assessing the health status of a patient.
Encounter Status - Status (Active, Discharged, Cancelled, Pre-Admit) of the encounter at the time the data was last updated.
Encounter Type - The Encounter type of the encounter at the time of the event. Encounter Types in the EDW: Ambulatory, Day Care, Emergency, Home Care, Inpatient Acute, Lifetime, MHAS - Acute Care, MHAS - Residential, Morgue, Newborn, Not defined, Open Encounter, Phone Consult, Pre-Admission, Pre-DayCare, Pre-Newborn, Pre-Register Ambulatory, Primary Care (as of October 2019) Recurring/Series, Research, Residential Care, Specimen, Stillborn, Waitlist
ER Discharge Date - Date the Emergency encounter type portion of the Emergency Encounter ended. If the patient was not admitted to an inpatient hospital ward from the Emergency Department (ED), then this is the Discharge Date of the encounter. If the patient was admitted from the ED to an inpatient hospital ward, then this is when the encounter became an Inpatient or Daycare Encounter.
ER Discharge Time - Time the Emergency encounter type portion of the Emergency Encounter ended.
ER Service - Main Emergency Department or Psychiatric Emergency Services; available for Royal Jubilee Hospital and Nanaimo Regional General Hospital only; use with caution
Facility
Functional Centre
Gender - Female, Male, Unknown
Inpatient Admit Date - Start date of the encounter for the inpatient encounter type portion. If an encounter goes ER to Inpatient, then the admit date is the start of the ER visit, the Inpatient date is when the encounter becomes Inpatient. For Inpatient encounters that start as Inpatient, the Admit Date/time and Inpatient Date/times are the same. Similar process, if an encounter goes Daycare to Inpatient or ER to Daycare to Inpatient.
Inpatient Admit Time - Used for admitted encounters ONLY. Should represent the Physician Decision to Admit and start of the Inpatient Encounter type portion of the encounter.
Inpatient Encntr ID
Location - Location of encounter at time of Event
Patient - Medical Record Number - Unique patient identifier within Island Health.
Patient Home Geography - Based on patient's home postal code for this encounter. Can be reported as Forward Sortation Area (first three characters of postal code only), Community Health Service Area, Local Health Area, or Province - please document the geography you require by selecting "Other" and making a note below.
Patient Service - Only applicable for hospital inpatient encounters. Indicates the type of hospital care required by the patient at the time of the service event or at the time of hospital discharge. Service codes differ depending on the type of service.
Other
If "Other" was selected, please describe the additional Encounter information required for this project.
The Endoscopy data checklist.
The Endoscopy checklist is divided into two sections: completed cases; and cases waiting.
To access the Endoscopy data dictionary please e-mail
DataRequest@VIHA.ca
Completed Endoscopy Cases
(select only the data fields required for this project)
Endoscopy Cases Waiting
(based on a snapshot date)
(select only the data fields required for this project)
If "Other" was selected for Endoscopy data, please list and describe the additional Ambulatory data elements required for this project.
Health System Matrix
The Health System Matrix (HSM) is the BC Ministry of Health's approach to understanding health care needs of the province's residents and summarizing information from multiple databases into a single, person specific source (one record per BC resident). In the Health System Matrix, definitions and insights evolve from version to version as updates are available and as further insights are gained. Therefore, generally, comparisons should be made within a Matrix version, and not between Matrix versions.
To see detailed descriptions of HSM variables and variable categories included in this checklist, please see the HSM data dictionary available at:
https://www2.gov.bc.ca/assets/gov/health/forms/5511datadictionary.pdf Health System Matrix data are divided into seven categories.
The data checklist for a Health System Matrix (HSM) sub-section will be displayed on this form only if the sub-section is selected here.
Health System Matrix (HSM) - Information About BC Resident
(select only the data fields required for this project)
FISCAL_YEAR - Fiscal Year (runs from April 1st to March 31st of next calendar year). The Health System Matrix (HSM) presents a summary by patient and by fiscal year (based on information reported to the Ministry for publicly funded services). Note, hospital services have been counted for the year they occurred, and not by year of discharge which is the usual practice. Information is available from 2002/03 through 2016/17.
AGE_GROUP_5YR - 5 year age group (0, 1-4, 5-9, 10-14, 15-19, etc.), based on end of fiscal year.
AGE_GROUP_BM - 5 year age groups with the 15-19 age group split between child/youth (15-17) and adult (18-19), based on end of fiscal year.
AGE_GROUP_BROAD_BM - Broad age group (0-17, 18-49, 50-64, 65-74, 75+), based on end of fiscal year.
GENDER
Forward Sortation Area of usual residence (FSA) - First 3 digits of postal code of usual residence, based on Health Ideas Client Roster database. Last/best address in fiscal year.
POSTAL_CODE - Postal Code of usual residence, based on Health Ideas Client Roster database. Last/best address in fiscal year.
Lat/Long - latitude and longitude of usual residence, based on Health Ideas Client Roster database.
CDA - Census Dissemination Area of usual residence, based on Health Ideas Client Roster database.
CHSA_v1_1 - Community Health Service Area of usual residence, based on Health Ideas Client Roster database. There are 218 CHSAs in BC.
LHA - Local Health Area of usual residence, based on Health Ideas Client Roster database. There are 89 LHAs in BC, and 14 in Island Health.
LHA_v1_1 - Local Health Area of usual residence, based on Health Ideas Client Roster database, derived from street address. There are 89 LHAs in BC. These LHAs are assigned new numbers according to updated classification system.
HSDA - Health Service Delivery Area of usual residence, based on Health Ideas Client Roster database. There are 16 health services delivery areas in BC.
HA - Health Authority of usual residence, based on Health Ideas Client Roster database. There are 5 health authorities that serve geographic regions in BC: Northern, Interior, Vancouver Island, Vancouver Coastal and Fraser Health.
BORN_IN_PERIOD_FLG - Born during the fiscal year flag, based on Health Ideas Client Roster database.
DIED_IN_PERIOD_FLG - Died during the fiscal year flag, based on Health Ideas Client Roster database.
DAYS_ALIVE - Days alive in a fiscal year, calculated based on birth date and/or death date in fiscal year.
ATTACHED_PRACTICE - Attachment to GP and/or Nurse Practitioner Group Flag.
ATTACHED_GP - Attachment to GP or Nurse Practitioner Flag.
HSM Health Characteristics
HSM Health Characteristics is divided into five subsections. The data checklist for a sub-section will be displayed on this form only if the sub-section is selected here.
HSM Health Characteristics - Population Segments
Population Segments (Overlapping) - Population segmentation by health status, developed specifically for the Health System Matrix, assigns BC residents to population segments that represent their health care needs in the fiscal year based on diagnoses or use of specific services over multiple or single years depending on definition. People can meet the criteria for one or more of the 14 population segments (which can cause population segments to overlap if a person qualifies for more than one).
(select only the data fields required for this project)
PS01 - Non User - BC residents who did not use publicly funded health services included in Health System Matrix.
PS02 - Healthy - BC residents who were low users of publicly funded services and did not have any health conditions which would assign a person to a higher acuity population segment. They used up to $1,500 of physician services and up to $1,000 of prescription drugs (PharmaNet expenditures which includes both government paid and out-of-pocket / extended benefits prescription drugs); did not use any other health care services; and were alive at the end of the year.
PS03 - Adult Major Age 18+ - BC residents age 18 years and older with major health conditions other than those which assign a person to a higher acuity population segments. They used more than $1,500 of physician services; or used more than $1,000 of prescription drugs (PharmaNet expenditures which includes both government paid and out-of-pocket / extended benefits prescription drugs)l; or used any other health care services; or died during the year.
PS04 - Child and Youth Major < 18 years - BC residents under the age of 18 with major health conditions other than those which assign a person to a higher acuity population segments. They used more than $1,500 of physician services; or used more than $1,000 of prescription drugs (PharmaNet expenditures which includes both government paid and out-of-pocket / extended benefits prescription drugs); or used any other health care services; or died during the year. The unhealthy newborns were included in this population segment.
PS05 - Low Chronic Conditions - BC residents with one or more low complex chronic conditions (asthma, mood / anxiety disorder including depression, diabetes, epilepsy, hypertension, osteoarthritis, or osteoporosis), as defined by the Chronic Disease Registries.
PS06 - Medium Chronic Conditions - BC residents with one or more medium chronic conditions (angina, COPD, multiple sclerosis, Parkinson's, pre-dialysis chronic kidney disease, or rheumatoid arthritis), or have had a major cardiac event or intervention (CABG, AMI, PTCA), or have a specific combination of chronic conditions (diabetes & mood / anxiety disorder, osteoarthritis & hypertension, osteoporosis & hypertension, osteoporosis & osteoarthritis), as defined by the Chronic Disease Registries.
PS07 - Severe Mental Health & Substance Use - BC residents who were hospitalized with a specific range of conditions recorded as the Most Responsible Diagnosis in the hospital abstract for mental health conditions such as schizophrenia, mood disorders, drug addiction, etc. in the last 5 fiscal years; or received methadone treatment in the fiscal year; or used PharmaNet Plan G in the fiscal year.
PS08 - Maternity & Healthy Newborns - BC residents who received maternity or obstetric services from a physician or a midwife (MSP fee-for-service billings) or a hospital (DAD) in the fiscal year.
PS09 - Frail In Community - BC residents who live in the community and receive professional home care services or publicly funded services to assist with activities of daily living.
PS10 - High Chronic w/o Frailty - BC residents who do not receive support services from health authorities for activities of daily living and who have one or more high chronic conditions (Alzheimer's, dementia, cystic fibrosis, heart failure, or organ transplant), had stroke or are on dialysis, or have a specific combination of chronic conditions (AMI & pre-dialysis chronic kidney disease, angina & COPD, diabetes & hypertension & osteoarthritis), as defined by the Chronic Disease Registries.
PS11 - High Chronic with Frailty - BC residents who do receive selected support services from health authorities for activities of daily living and who have one or more high chronic conditions (Alzheimer's, dementia, cystic fibrosis, heart failure, or organ transplant), had stroke or are on dialysis, or have a specific combination of chronic conditions (AMI & pre-dialysis chronic kidney disease, angina & COPD, diabetes & hypertension & osteoarthritis), as defined by the Chronic Disease Registries.
PS12 - Cancer - BC residents with cancer identified via administrative data using a similar approach as the Ministry's chronic disease registries. Specifically, the Matrix assigns people to this population segment if during the current or previous fiscal year they had specific malignant diagnoses recorded on at least two physicians' MSP fee-for-service billings within 365 days or at least one hospitalization. It is important to note that the people undergoing active treatment for cancer would be more comprehensively identified using the cancer registry maintained by the BC Cancer Agency. However, the Ministry does not have access to this cancer registry.
PS13 - Frail in Residential Care - BC residents in residential care facilities that provide 24-hour nursing care and assistance with activities of daily living.
PS14 - End Of Life - BC residents who received palliative care services from physicians (based on physicians' MSP fee-for-service billings for palliative care), were hospitalized specifically for palliative care, received palliative services from health authority's home and community care programs, were registered in PharmaNet's BC Palliative Care Benefits Program (Plan P).
HSM Health Characteristics - Previous Year Population Segment
(select only the data fields required for this project)
HSM Health Characteristics - Chronic Conditions
(select only the data fields required for this project)
HSM Health Characteristics - Long Term Care Indicators
(select only the data fields required for this project)
HSM Health Characteristics - Medications
(select only the data fields required for this project)
HSM -- Cost by Broad Category of Service
(select only the data fields required for this project)
(Choose this if you are only interested in conventional cost aggregates - residential care, emergency, laboratory and diagnostics, hospital, home and community care, medications, physician care.)
All costs (publicly funded expenditures) are estimates except for those based exclusively on PharmaNet and MSP fee for service paid billings (APP/Shadow billings costs from MSP are estimates as well), use with caution .
HSM_ RES_CARE_TOTAL_COST - Total cost of residential care that includes HCC cost, MSP/APP cost, and PharmaCare and estimate of Rx costs for people in RC facilities associated with hospitals.
HSM_ ED_TOTAL_COST - Total cost of emergency department care, includes MSP, APP estimate, NACRS estimate of physician cost, and estimated facility costs (NACRS data is available from 2012/13 fiscal year).
HSM_ LAB_TOTAL_COSTS - Total MSP/APP laboratory cost estimate
HSM_ DIAGNOSTIC_TOTAL_COST - Total MSP/APP diagnostic cost estimate
HSM_ HOSPITAL_TOTAL_COST - Total hospital cost estimate, excluding physician fees
HSM_ HCC_COMMUNITY_TOTAL_COST - Total Home & Community Care cost estimate excluding residential care cost (SL22 ADS, CSIL, AL, CM, HS, plus SL01 home nursing and SL20 home rehab)
HSM_ PHARMACARE_PAID_TOTAL_COST - PharmaCare publicly paid cost excluding Residential Care Rx cost.
HSM_ PHYSICIAN_CARE_TOTAL_COST - MSP/APP physician and midwife cost estimate excluding emergency cost, laboratory cost, diagnostic cost, and residential care cost
HSM_ TOTAL_COST - Total cost estimate (MSP rural retention costs are excluded).
HSM -- Costs by Service Lines (all types of services and measures combined)
Choose this if you are only interested in HSM service line aggregate spending and do not need further disaggregation of service lines by type of service or measure. Service lines are much more detailed than broad category of services (see above for cost by broad category of service).
All costs (publicly funded expenditures) are estimates except for those based exclusively on PharmaNet and MSP fee for service paid billings (APP/Shadow billings costs from MSP are estimates as well), use with caution .
(select only the data fields required for this project)
SL01_COST - Service Line 01 - Primary Health Care cost, All data sources
SL02_COST - Service Line 02 - Obstetrics cost, All data sources
SL03_COST - Service Line 03 - Gynaecology, excluding Oncology cost, All data sources
SL04_COST - Service Line 04 - Mental Health & Substance Use cost, All data sources
SL05_COST - Service Line 05 - Medical Specialists cost, All data sources
SL06_COST - Service Line 06 - Oncology cost, All data sources
SL07_COST - Service Line 07 - Emergency cost, All data sources
SL08_COST - Service Line 08 - In Hospital Medical cost, All data sources
SL09_COST - Service Line 09 - Ambulatory Surgical cost, All data sources
SL10_COST - Service Line 10 - Inpatient Elective Surgical cost, All data sources
SL11_COST - Service Line 11 - Transplant Surgery cost, All data sources
SL12_COST - Service Line 12 - In Patient Trauma and Emergency Surgery cost, All data sources
SL13_COST - Service Line 13 - Palliative Care cost, All data sources
SL14_COST - Service Line 14 - Pathology/Laboratory cost, All data sources
SL15_COST - Service Line 15 - Diagnostics cost, All data sources
SL16_COST - Service Line 16 - Ambulatory Support Therapies (Dialysis) cost, All data sources
SL17_COST - Service Line 17 - Pharmaceuticals cost, All data sources
SL18_COST - Service Line 18 - Anaesthesia cost, All data sources
SL19_COST - Service Line 19 - Hospital Outpatients cost, All data sources
SL20_COST - Service Line 20 - Physical medicine and Rehabilitation cost, All data sources
SL22_COST - Service Line 22 - Community Supports for Daily Living cost, All data sources
SL24_COST - Service Line 24 - Residential Care cost, All data sources
SL25_COST - Service Line 25 - Paediatrics cost, All data sources
SL30_COST - Service Line 30 - Surgery cost, All data sources
SL31_COST - Service Line 31 - Out-of-province billings for medical service provided to BC residents, cost, All data sources
SL99_COST - Service Line 99 - Other, Physicians cost, All data sources
HSM - Cost by Service Line and Type of Service/Measure
Choose this if you want to see all the components that constitute each service line. (See above for cost by broad categories of service.)
All costs (publicly funded expenditures) are estimates except for those based exclusively on PharmaNet and MSP fee for service paid billings (APP/Shadow billings costs from MSP are estimates as well), use with caution . Costs are uniquely allocated to a single service line (no double counting).
(select only the data fields required for this project)
SL01_MSP_COST
Service Line 01 - Primary Health Care cost, Medical Service Plan and APP shadow billing
SL01_HCN_VISITS_COST - Service Line 01 - Primary Health Care cost - Professional Services (Home Nursing Care, Community Rehabilitation, and Other)
SL02_MSP_COST - Service Line 02 - Obstetrics cost, Medical Service Plan and APP shadow billing
SL02_DAD_COST - Service Line 02 - Obstetrics cost, Hospital
SL03_MSP_COST - Service Line 03 - Gynaecology, excluding Oncology cost, Medical Service Plan and APP shadow billing
SL03_DAD_COST - Service Line 03 - Gynaecology, excluding Oncology cost, Hospital
SL04_MSP_COST - Service Line 04 - Mental Health & Substance Use cost, Medical Service Plan and APP shadow billing
SL04_DAD_COST - Service Line 04 - Mental Health & Substance Use cost, Hospital
SL04_PCMH_COST - Service Line 04 - Mental Health & Substance Use cost, PharmaCare paid
SL04_PNMH_COST - Service Line 04 - Mental Health & Substance Use cost, PharmaNet claimed
SL05_MSP_COST - Service Line 05 - Medical Specialists cost, Medical Service Plan and APP shadow billing
SL06_MSP_COST - Service Line 06 - Oncology cost, Medical Service Plan and APP shadow billing
SL06_DAD_COST - Service Line 06 - Oncology cost, Hospital
SL07_ED_COST - Service Line 07 - Emergency cost, Medical Service Plan, APP shadow billing, and NACRS, includes physician and facility costs
SL08_DAD_COST - Service Line 08 - In Hospital Medical cost, Hospital
SL09_DAD_COST - Service Line 09 - Ambulatory Surgical cost, Hospital
SL10_DAD_COST - Service Line 10 - Inpatient Elective Surgical cost, Hospital
SL11_MSP_COST - Service Line 11 - Transplant Surgery cost, Medical Service Plan and APP shadow billing
SL11_DAD_COST - Service Line 11 - Transplant Surgery cost, Hospital
SL12_DAD_COST - Service Line 12 - In Patient Trauma and Emergency Surgery cost, Hospital
SL13_MSP_COST - Service Line 13 - Palliative Care cost, Medical Service Plan and APP shadow billing
SL13_DAD_COST - Service Line 13 - Palliative Care cost, Hospital
SL13_PCPA_COST - Service Line 13 - Palliative Care cost, PharmaCare paid
SL13_PNPA_COST - Service Line 13 - Palliative Care cost, PharmaNet claimed
SL14_MSP_COST - Service Line 14 - Pathology/Laboratory cost, Medical Service Plan and APP shadow billing
SL15_MSP_COST - Service Line 15 - Diagnostics cost, Medical Service Plan and APP shadow billing
SL16_MSP_COST - Service Line 16 - Ambulatory Support Therapies (Dialysis) cost, Medical Service Plan and APP shadow billing
SL16_DAD_COST - Service Line 16 - Ambulatory Support Therapies (Dialysis) cost, Hospital
SL17_PC_COST - Service Line 17 - Pharmaceuticals cost, PharmaCare paid
SL17_PN_COST - Service Line 17 - Pharmaceuticals cost, PharmaNet claimed
SL18_MSP_COST - Service Line 18 - Anaesthesia cost, Medical Service Plan and APP shadow billing
SL19_MSP_COST - Service Line 19 - Hospital Outpatients cost, Medical Service Plan and APP shadow billing
SL20_MSP_COST - Service Line 20 - Physical medicine and Rehabilitation cost, Medical Service Plan and APP shadow billing
SL20_DAD_COST - Service Line 20 - Physical medicine and Rehabilitation cost, Hospital
SL20_REHAB_OTHER_VISITS_COST - Service Line 20 - Physical medicine and Rehabilitation cost, Home & Community Care (Rehab and other professional services)
SL22_AL_DAYS_COST - Service Line 22 - Community Supports for Daily Living cost, Assisted Living
SL22_HS_HOURS_COST - Service Line 22 - Community Supports for Daily Living cost, Home Support
SL22_CSIL_HOURS_COST - Service Line 22 - Community Supports for Daily Living cost, Choice in Supports for Independent Living
SL22_ADS_DAYS_COST - Service Line 22 - Community Supports for Daily Living cost, Adult Day Services
SL22_CM_VISITS_COST - Service Line 22 - Community Supports for Daily Living cost, Case Management
SL24_MSP_COST - Service Line 24 - Residential Care cost, Medical Service Plan and APP shadow billing
SL24_PCRC_COST - Service Line 24 - Residential Care cost, PharmaCare paid
SL24_PNRC_COST - Service Line 24 - Residential Care cost, PharmaNet claimed
SL24_RC_DAYS_COST - Service Line 24 - Residential Care cost, Residential Care
SL24_PC_B_EST_COST - Service Line 24 - Residential Care cost, Estimated PharmaCare plan B (residential care) amount for residential care patient in extended facilities (hospitals)
SL25_MSP_COST - Service Line 25 - Paediatrics cost, Medical Service Plan and APP shadow billing
SL25_DAD_COST - Service Line 25 - Paediatrics cost, Hospital
SL30_MSP_COST - Service Line 30 - Surgery cost, Medical Service Plan and APP shadow billing
SL31_MSP_COST - Service Line 31 - Out-of-province billings for medical service provided to BC residents, cost
SL99_MSP_COST - Service Line 99 - Other, Physicians cost, Medical Service Plan and APP shadow billing
HSM - Utilization by Service Lines and Type of Service/Measure
Choose this if you want to see all the components that constitute each service line. (See above for broader categories of service.)
(select only the data fields required for this project)
SL01_MSP_ENC - Service Line 01 - Primary Health Care, MSP and APP shadow billing encounters
SL01_HCN_VISITS - Service Line 01 - Primary Health Care visits - Professional Services (Home Nursing Care, Community Rehabilitation, and Other)
SL02_MSP_ENC - Service Line 02 - Obstetrics, MSP and APP shadow billing encounters
SL02_DAD_ADJ_TDAYS - Service Line 02 - Obstetrics total hospital days
SL02_DAD_ADJ_ARDAYS - Service Line 02 - Obstetrics acute rehab days
SL02_DAD_ADJ_ALCDAYS - Service Line 02 - Obstetrics alternative level of care days
SL02_DAD_ADJ_ICUDAYS - Service Line 02 - Obstetrics intensive care unit days
SL02_DAD_ADJ_CASES_IP - Service Line 02 - Obstetrics number of inpatient cases
SL02_DAD_ADJ_RIWS_IP - Service Line 02 - Obstetrics inpatient resource intensity weights
SL03_MSP_ENC - Service Line 03 - Gynaecology, excluding Oncology, MSP and APP shadow billing encounters
SL03_DAD_ADJ_TDAYS - Service Line 03 - Gynaecology, excluding Oncology total hospital days
SL03_DAD_ADJ_ARDAYS - Service Line 03 - Gynaecology, excluding Oncology acute rehab days
SL03_DAD_ADJ_ALCDAYS - Service Line 03 - Gynaecology, excluding Oncology alternative level of care days
SL03_DAD_ADJ_ICUDAYS - Service Line 03 - Gynaecology, excluding Oncology intensive care unit days
SL03_DAD_ADJ_CASES_DS - Service Line 03 - Gynaecology, excluding Oncology number of outpatient cases
SL03_DAD_ADJ_CASES_IP - Service Line 03 - Gynaecology, excluding Oncology number of inpatient cases
SL03_DAD_ADJ_RIWS_DS - Service Line 03 - Gynaecology, excluding Oncology outpatient resource intensity weights
SL03_DAD_ADJ_RIWS_IP - Service Line 03 - Gynaecology, excluding Oncology inpatient resource intensity weights
SL04_MSP_ENC - Service Line 04 - Mental Health & Substance Use, MSP and APP shadow billing encounters
SL04_DAD_ADJ_TDAYS - Service Line 04 - Mental Health & Substance Use total hospital days
SL04_DAD_ADJ_ARDAYS - Service Line 04 - Mental Health & Substance Use acute rehab days
SL04_DAD_ADJ_ALCDAYS - Service Line 04 - Mental Health & Substance Use alternative level of care days
SL04_DAD_ADJ_ICUDAYS - Service Line 04 - Mental Health & Substance Use intensive care unit days
SL04_DAD_ADJ_CASES_DS - Service Line 04 - Mental Health & Substance Use number of outpatient cases
SL04_DAD_ADJ_CASES_IP - Service Line 04 - Mental Health & Substance Use number of inpatient cases
SL04_DAD_ADJ_RIWS_DS - Service Line 04 - Mental Health & Substance Use outpatient resource intensity weights
SL04_DAD_ADJ_RIWS_IP - Service Line 04 - Mental Health & Substance Use inpatient resource intensity weights
SL05_MSP_ENC - Service Line 05 - Medical Specialists, MSP and APP shadow billing encounters
SL06_MSP_ENC - Service Line 06 - Oncology, MSP and APP shadow billing encounters
SL06_DAD_ADJ_TDAYS - Service Line 06 - Oncology total hospital days
SL06_DAD_ADJ_ARDAYS - Service Line 06 - Oncology acute rehab days
SL06_DAD_ADJ_ALCDAYS - Service Line 06 - Oncology alternative level of care days
SL06_DAD_ADJ_ICUDAYS - Service Line 06 - Oncology intensive care unit days
SL06_DAD_ADJ_CASES_DS - Service Line 06 - Oncology number of outpatient cases
SL06_DAD_ADJ_CASES_IP - Service Line 06 - Oncology number of inpatient cases
SL06_DAD_ADJ_RIWS_DS - Service Line 06 - Oncology outpatient resource intensity weights
SL06_DAD_ADJ_RIWS_IP - Service Line 06 - Oncology inpatient resource intensity weights
SL07_ED_ENC - Service Line 07 - Emergency, MSP,APP shadow billing, and NACRS encounters
SL08_DAD_ADJ_TDAYS - Service Line 08 - In Hospital Medical total hospital days
SL08_DAD_ADJ_ARDAYS - Service Line 08 - In Hospital Medical acute rehab days
SL08_DAD_ADJ_ALCDAYS - Service Line 08 - In Hospital Medical alternative level of care days
SL08_DAD_ADJ_ICUDAYS - Service Line 08 - In Hospital Medical intensive care unit days
SL08_DAD_ADJ_CASES_IP - Service Line 08 - In Hospital Medical number of inpatient cases
SL08_DAD_ADJ_RIWS_IP - Service Line 08 - In Hospital Medical inpatient resource intensity weights
SL09_DAD_ADJ_CASES_DS - Service Line 09 - Ambulatory Surgical number of outpatient cases
SL09_DAD_ADJ_RIWS_DS - Service Line 09 - Ambulatory Surgical outpatient resource intensity weights
SL10_DAD_ADJ_TDAYS - Service Line 10 - Inpatient Elective Surgical total hospital days
SL10_DAD_ADJ_ARDAYS - Service Line 10 - Inpatient Elective Surgical acute rehab days
SL10_DAD_ADJ_ALCDAYS - Service Line 10 - Inpatient Elective Surgical alternative level of care days
SL10_DAD_ADJ_ICUDAYS - Service Line 10 - Inpatient Elective Surgical intensive care unit days
SL10_DAD_ADJ_CASES_IP - Service Line 10 - Inpatient Elective Surgical number of inpatient cases
SL10_DAD_ADJ_RIWS_IP - Service Line 10 - Inpatient Elective Surgical inpatient resource intensity weights
SL11_MSP_ENC - Service Line 11 - Transplant Surgery, MSP and APP shadow billing encounters
SL11_DAD_ADJ_TDAYS - Service Line 11 - Transplant Surgery total hospital days
SL11_DAD_ADJ_ARDAYS - Service Line 11 - Transplant Surgery acute rehab days
SL11_DAD_ADJ_ALCDAYS - Service Line 11 - Transplant Surgery alternative level of care days
SL11_DAD_ADJ_ICUDAYS - Service Line 11 - Transplant Surgery intensive care unit days
SL11_DAD_ADJ_CASES_IP - Service Line 11 - Transplant Surgery number of inpatient cases
SL11_DAD_ADJ_RIWS_IP - Service Line 11 - Transplant Surgery inpatient resource intensity weights
SL12_DAD_ADJ_TDAYS - Service Line 12 - In Patient Trauma and Emergency Surgery total hospital days
SL12_DAD_ADJ_ARDAYS - Service Line 12 - In Patient Trauma and Emergency Surgery acute rehab days
SL12_DAD_ADJ_ALCDAYS - Service Line 12 - In Patient Trauma and Emergency Surgery alternative level of care days
SL12_DAD_ADJ_ICUDAYS - Service Line 12 - In Patient Trauma and Emergency Surgery intensive care unit days
SL12_DAD_ADJ_CASES_IP - Service Line 12 - In Patient Trauma and Emergency Surgery number of inpatient cases
SL12_DAD_ADJ_RIWS_IP - Service Line 12 - In Patient Trauma and Emergency Surgery inpatient resource intensity weights
SL13_MSP_ENC - Service Line 13 - Palliative Care, MSP and APP shadow billing encounters
SL13_DAD_ADJ_TDAYS - Service Line 13 - Palliative Care total hospital days
SL13_DAD_ADJ_ARDAYS - Service Line 13 - Palliative Care acute rehab days
SL13_DAD_ADJ_ALCDAYS - Service Line 13 - Palliative Care alternative level of care days
SL13_DAD_ADJ_ICUDAYS - Service Line 13 - Palliative Care intensive care unit days
SL13_DAD_ADJ_CASES_IP - Service Line 13 - Palliative Care number of inpatient cases
SL13_DAD_ADJ_RIWS_IP - Service Line 13 - Palliative Care inpatient resource intensity weights
SL14_MSP_ENC - Service Line 14 - Pathology/Laboratory, MSP and APP shadow billing encounters
SL15_MSP_ENC - Service Line 15 - Diagnostics, MSP and APP shadow billing encounters
SL16_MSP_ENC - Service Line 16 - Ambulatory Support Therapies (Dialysis), MSP and APP shadow billing encounters
SL16_DAD_ADJ_TDAYS - Service Line 16 - Ambulatory Support Therapies (Dialysis) total hospital days
SL16_DAD_ADJ_ARDAYS - Service Line 16 - Ambulatory Support Therapies (Dialysis) acute rehab days
SL16_DAD_ADJ_ALCDAYS - Service Line 16 - Ambulatory Support Therapies (Dialysis) alternative level of care days
SL16_DAD_ADJ_ICUDAYS - Service Line 16 - Ambulatory Support Therapies (Dialysis) intensive care unit days
SL16_DAD_ADJ_CASES_DS - Service Line 16 - Ambulatory Support Therapies (Dialysis) number of outpatient cases
SL16_DAD_ADJ_CASES_IP - Service Line 16 - Ambulatory Support Therapies (Dialysis) number of inpatient cases
SL16_DAD_ADJ_RIWS_DS - Service Line 16 - Ambulatory Support Therapies (Dialysis) outpatient resource intensity weights
SL16_DAD_ADJ_RIWS_IP - Service Line 16 - Ambulatory Support Therapies (Dialysis) inpatient resource intensity weights
SL18_MSP_ENC - Service Line 18 - Anaesthesia, MSP and APP shadow billing encounters
SL19_MSP_ENC - Service Line 19 - Hospital Outpatients, MSP and APP shadow billing encounters
SL20_MSP_ENC - Service Line 20 - Physical medicine and Rehabilitation, MSP and APP shadow billing encounters
SL20_DAD_ADJ_TDAYS - Service Line 20 - Physical medicine and Rehabilitation total hospital days
SL20_DAD_ADJ_ARDAYS - Service Line 20 - Physical medicine and Rehabilitation acute rehab days
SL20_DAD_ADJ_ALCDAYS - Service Line 20 - Physical medicine and Rehabilitation alternative level of care days
SL20_DAD_ADJ_ICUDAYS - Service Line 20 - Physical medicine and Rehabilitation intensive care unit days
SL20_DAD_ADJ_CASES_IP - Service Line 20 - Physical medicine and Rehabilitation number of inpatient cases
SL20_DAD_ADJ_RIWS_IP - Service Line 20 - Physical medicine and Rehabilitation inpatient resource intensity weights
SL20_REHAB_OTHER_VISITS - Service Line 20 - Physical medicine and Rehabilitation visits, Home & Community Care (Rehab and other professional services)
SL22_AL_DAYS - Service Line 22 - Community Supports for Daily Living days, Assisted Living
SL22_HS_HOURS - Service Line 22 - Community Supports for Daily Living hours, Home Support
SL22_CSIL_HOURS - Service Line 22 - Community Supports for Daily Living hours, Choice in Supports for Independent Living
SL22_ADS_DAYS - Service Line 22 - Community Supports for Daily Living days, Adult Day Services
SL22_CM_VISITS - Service Line 22 - Community Supports for Daily Living visits, Case Management
SL24_MSP_ENC - Service Line 24 - Residential Care, MSP and APP shadow billing encounters
SL24_RC_DAYS - Service Line 24 - Residential Care days, Residential Care
SL25_MSP_ENC - Service Line 25 - Paediatrics, MSP and APP shadow billing encounters
SL25_DAD_ADJ_TDAYS - Service Line 25 - Paediatrics total hospital days
SL25_DAD_ADJ_ARDAYS - Service Line 25 - Paediatrics acute rehab days
SL25_DAD_ADJ_ALCDAYS - Service Line 25 - Paediatrics alternative level of care days
SL25_DAD_ADJ_ICUDAYS - Service Line 25 - Paediatrics intensive care unit days
SL25_DAD_ADJ_CASES_IP - Service Line 25 - Paediatrics number of inpatient cases
SL25_DAD_ADJ_RIWS_IP - Service Line 25 - Paediatrics inpatient resource intensity weights
SL30_MSP_ENC - Service Line 30 - Surgery, MSP and APP shadow billing encounters
SL31_MSP_ENC - Service Line 31 - Out-of-province medical services provided to BC residents, encounters
SL99_MSP_ENC - Service Line 99 - Other, Physicians, MSP and APP shadow billing encounters
Physician Information (from physicians billing the Medical Services Plan (MSP))
HSM Physician Information is divided into two subsections The data checklist for a sub-section will be displayed on this form only if the sub-section is selected here.
HSM Physician Information - General Practitioners
Choose if you need to see physician care information obtained from the Medical Service Plan.
All costs (publicly funded expenditures) are estimate, use with caution .
(select only the data fields required for this project)
HSM Physician Information - Specialist
Choose if you need to see physician care information obtained from the Medical Service Plan.
All costs (publicly funded expenditures) are estimate, use with caution .
(select only the data fields required for this project)
If you require HSM data not listed here, please describe.
Hospital Stay Checklists
The Canadian Institute of Health Information (CIHI) Discharge Abstract Database (DAD) captures administrative, clinical and demographic information on patients discharged from acute care hospitals (including deaths, sign-outs and transfers), and day surgery. Standardized International Classification of Disease (ICD-10-CA) and Canadian Classification of Health Interventions (CCI) systems are used to represent diagnoses and interventions.
Data on a patient's hospital stay is divided into 7 sections. The data checklist for a section will be displayed on this form only if it is selected here.
1. Island Health Acute Care Hospitals
Please select the hospitals you require data from.
* must provide value
If 'Other' was selected, please describe the data you require.
2. Hospital Stay - sub-sections
Data on a patient's hospital stay is divided into 7 sub-sections. The data checklist for a sub-section will be displayed on this form only if the section is selected here.
a) Hospital Stay - Admission, Discharge, Transfer
Encounter number - Unique identification number that is automatically assigned by Cerner Millennium (Person Management / ADT system).
Episode ID - Unique ID for group of abstracts that are related and meet criteria for being joined into one episode of care (per CIHI's specifications).
SMI Episode ID - Unique ID for group of abstracts that are related and meet criteria for being joined into one episode of care pertaining to severe mental illness (SMI).
Most Responsible Facility - Hospital where the patient stayed the longest.
Transfer From Facility - Hospital from which the patient was directly transferred for further treatment.
Reporting Facility - Identifies the facility and level of care where the patient received treatment. Reporting facility is the institution under which the entire abstract is reported. The institution numbers are assigned by the MoH and are unique to each facility (example:203 = Cowichan District Hospital), with an exception for RJH/VGH. For historical data before Feb 21, 2016, when a transfer occurred between RJH and VGH, the reporting facility was 90202 VGH. To determine the site where the activity actually took place, additional fields were used to establish the most responsible facility (facility where the patient stayed the longest) and discharge facility (facility from where the patient was discharged). Changes to this process were made with the implementation of IHealth on Feb 21, 2016 when transfers between RJH and VGH were treated as separate visits in both ADT and DAD. RJH visits are reported under RJH's institution number (201). From July 5, 2016 forward, ADT reverted to having RJH/VGH transfers be one Encounter, while DAD retained two abstracts.
Admit Ambulance - indicates if the patient arrived by ambulance and by what type of ambulance (air, ground); never blank; if no ambulance was used the record will be coded as 'no ambulance'.
Entry Code - the last point of entry prior to being admitted as an inpatient or day care patient - direct, emergency, newborn, stillborn, day care, clinic.
Admit category - Initial status of the patient at time of admission. Scheduled/elective, Urgent, Newborn, Stillborn.
Admit date - The date the patient was admitted to the facility
Admit time - The time of day the patient was admitted to the facility
Discharge date - The date the patient was discharged from the facility
Discharge time - The time of day the patient was discharged from the facility
Discharge Facility - Place where the activity of interest occurs; facility from which the patient was discharged.
Discharge Location - Place where the activity of interest occurs; unit from which the patient was discharged.
Discharge disposition - anticipated location following discharge, or reason for discharge, e.g. death, home, against medical advice, to an acute care facility, to a residential/continuing care facility, etc.
Project 325 - Mental Health Involuntary Admission Information. Significant changes in values in 2018/19 - see CIHI information or subject matter expert.
Returned to Original Residence - flag to indicate the patient returned to the residence they originated from; 1=yes; 0=no.
Transfer To Facility - Hospital to which the patient was directly transferred for further treatment.
b) Hospital Stay - Length of Stay
(also see Admission, Discharge, Transfer section for admission and discharge dates that can be used to calculate length of stay)
c) Hospital Stay - Service
d) Hospital Stay - Diagnosis
ACSC Count - 1 indicates the acute inpatient case meets diagnostic criteria for ACSC (Ambulatory Care Sensitive Condition).
ACSC Reason - Ambulatory Care Sensitive Condition (ACSC) disease groupings. Epileptic convulsions; chronic obstructive pulmonary disease, asthma, angina, diabetes, heart failure and pulmonary edema, hypertension. ACSC is an ge-standardized acute care hospitalization rate for conditions where appropriate ambulatory care prevents or reduces the need for admission to hospital, per 100,000 population
Clinical Cohort Group - Flag indicating inclusion in one or more clinical cohorts. Custom reference table of single and various combinations of frequently related/present clinical conditions. For example: asthma, heart failure, pneumonia (grouped).
CSAE Count - flag indicating whether an acute patient had at least one Care Sensitive Adverse Event during the hospital stay; 1=yes; 0=no. CIHI refers to this category as Nursing Sensitive Adverse Events.
CSAE Fracture Count - flag indicating whether an acute patient had a fracture meeting CSAE criteria.
CSAE Pneumonia Count - flag indicating whether an acute patient had pneumonia meeting CSAE criteria.
CSAE Pressure Ulcer Count - flag indicating whether an acute patient had a pressure ulcer meeting CSAE criteria.
CSAE UTI Count - flag indicating whether an acute patient had a urinary tract infection meeting CSAE criteria.
Most Responsible Diagnosis - the condition most responsible for the greatest portion of the length of stay and/or greatest use of resources (ICD10-CA codes).
Diagnosis - max 25 diagnoses per hospital stay (ICD10-CA codes); Note: - must be used with diagnosis type (below)
Diagnosis Type - a one-character code that signifies the impact the condition had on the patient's hospitalization - one type for each corresponding Diagnosis (above), e.g. M=most responsible diagnosis; 1 and 2= comorbidity diagnoses; 3=secondary diagnosis; 5=admitting diagnosis; etc.
Diagnosis Occurrence - Sequence of ICD-10-CA codes in an abstract.
Diagnosis Cluster - One-character code that indicates a group of two or more ICD-10-CA codes that relate to one another.
Diagnosis Prefix - One-character code that provides additional information related to the ICD-10-CA code to which it is assigned.
Intervention - Canadian Classification of Interventions (CCI) code that describes the procedure/intervention performed on the patient.
Special Populations - high volume diagnostic and intervention groups - acute myocardial infarction; asthma; congestive heart failure; chronic obstructive pulmonary disease; dementia; depression; diabetes; stroke; coronary artery bypass graft, cardiac valve replacement; hip replacement; knee replacement.
Glascow Coma Scale - GCS (Glasgow Coma Scale) is a clinical evaluation score used to assess the response of a neurologically impaired patient. A complete GSC is the sum of three components: best eye response, best verbal response, best motor response. Scale is from 1 to 15 with higher scores indicating lower brain injury.
Stillborn Case - Flag indicating a stillborn case.
e) Hospital Stay - Provider
f) Hospital Stay - Procedures or Interventions
Episode Count - Count of cases with or without interventions.
Principal CCI Intervention - The intervention that is considered to be most significant and/or resource intensive.
CCI Intervention - Canadian Classification of health-related Interventions code(s); interventions received by the patient.
Intervention Procedure ID - Identifier for data warehouse purposes.
Intervention Type - Indicates whether the intervention is the Principal Intervention, Other Intervention, or No intervention recorded.
Intervention Episode Count - number of intervention episodes a patient had during a hospital stay. One 'intervention episode' may included more than one intervention, e.g. an electrocardiogram, an xray of coronary arteries, and a coronary artery bypass, are three procedures that may occur in a single intervention episode. During a hospital stay, a patient may have more than one intervention episode.
Intervention Episode Occurrence - sequence number of the intervention episodes during the hospital stay e.g. 2nd
Intervention Episode Time Minutes - length of time of the intervention episode
Intervention Occurrence - Sequence of interventions in the abstract.
Intervention Procedure Sequence - Sequence of interventions within an episode.
Intervention Post op Days - number of days the patient was in hospital following surgical intervention
Intervention Pre op Days - number of days the patient was in hospital prior to the surgical intervention
Intervention Date - the date when the patient enters the intervention location to have one or more interventions
Intervention Time - the time the patient enters the intervention location to have one or more interventions.
Intervention Episode Type - indicates whether the episode is the Principle Intervention Episode, Other Intervention Episode, or No intervention recorded.
Intervention Provider - The unique identifier of the health care provider involved in each intervention.
Intervention Provider Service - The 5-digit code that reflects the specialty of the health care professional.
Intervention Relationship Anaesthetic Technique - the relationships between the number of Providers, Anesthetists, anesthetic types and number of interventions.
Intervention Relationship Anaesthetist - list of anesthetists and related intervention occurrences.
Intervention Relationship Provider - describes classes of characteristics between Providers (including anesthetists) and anesthetic types.
OOH Facility - Out of Hospital Facility where the intervention is performed.
Unplanned Return to OR - identifies that the patient returned to an intervention location for an unplanned procedure due to an unexpected problem following a previous intervention during the current inpatient stay.
g) Hospital Stay - Miscellaneous
h) Hospital Stay - Other
If you require Hospital Stay data that are not found in the 7 Hospital Stay sub-section checklists, please describe it here.
3. Hospital Stay Case Mix Group (CMG)
Case-mix products are methodologies fro grouping acute hospital care episodes. For a detailed description of these products, visit the CIHI web page
The methodologies for selecting cases into standardized categories as well as the RIW calculations are constantly changing. Only the last five years of hospitalization data are regrouped with the latest grouper year methodology, thus the years prior to that (6+) have the old grouper year methodologies. CIHI advises that grouper methodologies cannot be compared. Consequently, grouper values derived from different grouper year methodologies cannot be analyzed together. This may lead to longitudinal data sets that span multiple grouper year methodologies that cannot be compared. However, with a judicious selection of groupers, Island Health can minimize the number of grouper year methodologies by not using the latest grouper methodology, thus providing more opportunity for comparison across years.
Please select the grouper type required (any of this selection is associated with the Methodology Year variable, which also needs to be selected):
If 'Other' was selected, please describe the data you require.
4. Hospital Stay - Comprehensive Ambulatory Classification System (CACS)
This is a grouping methodology used for daycare surgery.
See the information on grouping methodology in #3 above.
(select only data fields required for this project)
If 'Other' was selected, please describe the data you require.
5. Hospital Stay - Hospital Harm
The CIHI Hospital Harm Framework divides harms that occur to patients during a hospital stay into four categories: (A) Health care/medication associated conditions; (B) Health care associated infections; (C) Patient accidents; and (D) Procedure-Associated conditions. Each data field contains a 1 or a zero. 1=hospital stay met criteria for this hospital harm clinical group; 0= criterial not met.
(select only data fields required for this project)
If "Other" was selected please describe the data you require.
6. Hospital Stay - Stroke Strategy Performance Improvement
CIHI Project 340, or the Canadian Stroke Strategy Performance Improvement Information - began 2018/2019.
(select only data fields required for this project)
If "Other" was selected please describe the data you require.
7. CIHI CMG WITH COMPLEXITY GROUPER VARIABLES/DAY PROCEDURES GROUP
NOTE: Case-mix products, such as Case Mix Group+ (CMG+) and the Comprehensive Ambulatory Classification System (CACS), are methodologies for grouping acute care episodes captured in CIHI's databases. For a detailed description of these products, please visit theCIHI webpage at http://www.cihi.ca/CIHI-ext-portal/internet/EN/TabbedContent/standards+and+data+submission/standards/case+mix/cihi010690 . The methodologies for selecting cases into standardized categories as well as the RIW calculations are constantly changing. Only the last five years of hospitalization data are regrouped with the latest grouper year methodology, thus the years prior to that (6+) have the old grouper year methodologies. CIHI advises that grouper methodologies cannot be compared. Consequently, grouper values derived from different grouper year methodologies cannot be analyzed together. This may lead to longitudinal data sets that span multiple grouper year methodologies that cannot be compared. How-ever, with a judicious selection of groupers, Island Health can minimize the number of grouper year methodologies by not using the latest grouper methodology, thus providing more opportunity for comparison across years.
Please select the grouper type required (any of this selection is associated with the Methodology Year variable, which also needs to be selected):
The Infection Prevention & Control (IPC)- Hand Hygiene Observations data Checklist.
The data dictionary for this check list can be found at
CHS Data Dictionary (wait for the app; it takes a minute to load)
If you are unable to access the IPC Data Dictionary, please e-mail
DataRequest@VIHA.ca
Infection Prevention & Control - Hand Washing Audit
(select only the data fields required for this project)
If "Other" was selected for Infection Prevention & Control data, please list and describe the additional Infection Prevention & Control data elements required for this project.
Laboratory Data
Note: One lab order may include many lab tests. Each test is called a Discrete Task Assay or DTA.
Timeframes: Lab order and DTA turn-around-time data are available from February 2016.
Lab test results are more easily available after April 1, 2016. Lab test results from 2007 to March 2016 are in legacy systems, more difficult to access, and availability depends on resources.
Laboratory Data
Laboratory data is divided into four sub-sections. The sub-section and its data checklist will be displayed on this form only if the sub-section is selected here.
Identify the lab tests for your study
If you are require information for specific laboratory tests, please list them here.
Laboratory test results
The information available for lab test results is not fully represented here.
To determine the data elements available please contact Island Health's Director of Laboratory Services or email DataRequest@VIHA.ca
Note: One lab order may include many lab tests. Each test is called a Discrete Task Assay or DTA.
Lab Test (Discrete Task Assay) turn-around-time
Note: One lab order may include many lab tests. Each test is called a Discrete Task Assay or DTA.
Orders placed on or after February 20, 2016.
Turnaround times associated with lab DTA workflows. Includes all completed non-micro lab orders which generate results data in Cerner Millennium.
Note: Anatomical Pathology and Respiratory orders are excluded as not all data relating to these types of orders are available.
(select only the data fields required for this project)
Laboratory Order turn-around-time
Note: One lab order may include many lab tests. Each test is called a Discrete Task Assay or DTA.
Orders placed on or after February 20, 2016.
Turnaround times associated with lab order workflows. Includes all completed lab orders which generate results data in Cerner Millennium.
Note: Anatomical Pathology and Respiratory orders are excluded as not all data relating to these types of orders are available. Anatomical Pathology (AP) orders are not included due to restrictions on availability of the data. All the timestamps required for AP TAT reporting are from provincial system (CoPath), they are not available in Cerner Millennium. Respiratory orders whose results are generated from external device are not included. For respiratory orders, the collection, in-lab and results occur simultaneously at the patient bedside and the order is auto-generated by the system.
(select only the data fields required for this project)/span>
If "Other" was selected above, please list and describe the additional Lab data you require.
Long Term Care
Long Term Care (LTC) data are divided into seven sections.
The Long Term Care data are complicated. If you require LTC data for your project, it is recommended that you discuss your needs with a LTC data expert to ensure you request the correct data to meet the needs of your project. To be connected with a LTC data expert, please send an email to DataRequest@VIHA.ca .
Note: LTC used to be called 'Residential Care'. Long Term Care data, including the Continuing Care Reporting System (CCRS)
Select the categories of LTC data you are interested in. Selecting a category here will cause the data checklist to appear below.
About the CIHI Continuing Care Reporting System (CCRS):
The CCRS captures longitudinal demographic, clinical and functional information on residents who receive continuing care services in hospital-based facilities and long-term care homes in Canada that have 24-hour nursing available.
See the CCRS Data Users Guide.
The database includes administrative information about residents and their stays, as well as information derived from clinical assessments. The clinical standard for CCRS is the Resident Assessment Instrument-Minimum Data Set (RAI-MDS 2.0) ©. It is a validated clinical assessment developed by interRAI, an international research network. The RAI-MDS 2.0 has been modified for use in Canada by CIHI, with permission from interRAI.
CCRS contains data from full RAI-MDS 2.0 assessments (completed within 14 days of admission and repeated annually within the same episode of care or after a significant change in clinical status) and shorter quarterly RAI-MDS 2.0 assessments. When using RAI-MDS 2.0 assessment data, users should be aware that not all data elements will be available for the quarterly assessments.
• CCRS does not contain assessment information about all residents, primarily because some stay in the continuing care facility for less than 14 days. For lengths of stay less than 14 days, completing an assessment is voluntary; thus only demographic and administrative data is available for these residents.
• The structure of CCRS longitudinal data is complex. There are more than 500 data elements, consisting of RAI-MDS 2.0 data elements plus data elements developed by CIHI. The supporting documentation will help with understanding and interpretation (e.g., RAI-MDS 2.0 User's Manual, CCRS RAI-MDS 2.0 Output Specifications Manual, CCRS Data Submission User Manual).
When analyzing CCRS data, users should be aware of item non-response (or partial non-response). Item non-response occurs when a record is received with some missing or invalid data.
This information is from the CCRS Data Users Guide published by CIHI.
If "Other" was selected above, please describe the other LTC data you require.
1: LTC Facility Encounter
2: LTC Placements
2011 to present
(select only the data fields required for this project)
3. LTC Assessment Date and Reason
4. LTC Outcome Scales
Outcome Scales are derived from RAI-MDS 2.0 and include a series of scales and indices that can be used to evaluate the clinical status of a resident or group of residents.
(select only the data fields required for this project)
5. LTC Clinical Assessments (CAPs)
Subsets of items from the RAI-MDS 2.0© instrument can be used to identify persons who may benefit from care and support for specific problem areas. These problem areas are identified by the triggering of CAPs (Clinical Assessment Protocols).
(select only the data fields required for this project)
6. LTC Quality Indicators (QI)
Select the CCRS quality indicator category you are interested in (selecting will cause the checklist of date elements to appear below on this form). Also see the section on "Original CHSRA Quality Indicators".
In 2010, CIHI implemented a new suite of indicators which now includes many outcome-based measures (measuring change in resident function or status) in addition to key prevalence measures. It also includes indicators in domains not covered by the first generation indicators, such as pain and new risk-adjustment techniques.
"Prevalence" indicators measure the residents' characteristics at a given point in time (i.e. at their assessment) and use a single assessment to represent the residents' characteristics for a given quarter.
"Incidence" indicators measure change over time: evaluating the change in status from one quarter compared with the previous quarter. Two assessments are required to calculate the incidence indicators.
Risk Adjustment - The CCRS QIs are intended to measure the quality of care delivered by continuing care facilities. However, some factors are beyond the facility's control, even though they affect resident outcomes. As a result, some facilities appear to perform worse because they have more higher-risk residents.
a) LTC QI - Assessment Selection Criteria
b) LTC QI - Assessment Selection for Incidence Indicators
c) LTC QI - Temporary Activities of Daily Living (ADL) Variables
G1aA Bed Mobility Self-Performance (valid values: 0, 1, 2, 3, 4, 8)
G1bA Transfer Self-Performance (valid values: 0, 1, 2, 3, 4, 8)
G1dA Walk in Corridor Self Performance (valid values: 0, 1, 2, 3, 4, 8)
G1eA Locomotion on Unit Self-Performance (valid values: 0, 1, 2, 3, 4, 8)
G1gA Dressing Self Performance (valid values: 0, 1, 2, 3, 4, 8)
G1hA Eating Self-Performance (valid values: 0, 1, 2, 3, 4, 8)
G1iA Toilet Self-Performance (valid values: 0, 1, 2, 3, 4, 8)
G1jA Personal Hygiene Self Performance (valid values: 0, 1, 2, 3, 4, 8)
d) LTC QI - Activities of Daily Living
g) LTC QI - Cognitive Function
h) LTC QI - Communication
o) LTC QI - Nutrition/Weight
q) LTC QI - Pressure Ulcers
7. LTC Resident Assessment Protocols (RAPs)
Resident Assessment Protocols (RAPs) are subsets of items from the RAI-MDS 2.0© instrument that can be used to identify persons who may benefit from care and support for specific problem areas. These problem areas are identified by the triggering of RAPs.
NOTE: For assessments after April 1, 2008, see CAPs.
(select only the RAPs required for this project)
If "Other" was selected in any of the LTC lists above, please list and describe the additional LTC data elements required for this project.
Medical Imaging
Medical Imaging (MI) data is divided into two sub-sets: Medical Imaging Orders (MI exams ordered and conducted), and Medical Imaging Results. In general, MI data is available from February 26, 2016 onwards. Data prior to this date are in legacy systems and required additional resources to access.
Medical Imaging
Medical Imaging data is divided into two subsections. The data checklist for a sub-section will be displayed on this form only if the sub-section is selected here.
Medical Imaging (MI)
Medical imaging orders completed on or after February 26, 2016
(select only the data fields required for this project)
ORDER_ID - Internal Cerner Imaging Order identifier assigned when the order is entered in RadNet. Does not change throughout the lifetime of the order. An [ENCNTR_ID] may contain multiple studies/exams, and a study/exam may contain multiple [ORDER_ID]s.
MI_ORDER_CATALOG - Order catalog ID for the imaging Order Name . Cerner Order name contains modality abbreviation, and type (body part of the image (if applicable), and side of body of the image (if applicable)). The Order Name field has a 40 character limit, so order names may be truncated or abbreviated.
ACCESSION_NBR - Unique Accession number that the exam was assigned at order time. Can be more than one order per accession (also referred to as an exam/study). The accession number contains a modality abbreviation and the year the order was entered in the system. There may be multiple orders per accession, since they are performed in the same exam/study (e.g. MRI Hand Right, MRI Hand Left)
MI_Exam_Scheduling_Priority - Determined by the ordering provider, the scheduling priority determines the target wait time for the order. Priorities are (in order of target wait time), Stat/Urgent, ASAP, Semi-Urgent, Routine/Elective. System Utilization, Unassigned and Undefined priorities do not have a target wait time. Target wait times vary by modality. Priority may change in the PACS system, and reporting priority may be different than scheduling priority.
MI_Cancel_Reason - The reason why the order was cancelled, such as 'duplicate order', 'equipment failure', or 'incorrect order'. Each order will have a single cancel reason. Will be 'unknown' if order was not cancelled. Cancelled orders will not have a complete date time.
MI_Section_Location - Exam area that the exam is to be performed within (e.g. Nainaimo Regional General (NRG) Ultrasound). Exam area is determined at the time of booking. Can be fixed or mobile, depending on modality and machine type.
MI_Exam_Room_Location - Exam room that the exam is to be performed within (e.g. NRG Ultrasound Room 2). Exam room is determined at the time of booking. Room 1 is the default. Can be fixed or mobile, depending on modality and machine type.
MI_PT_Exam_Complete_Location - Patient location at the complete date/time. The exam location where the exam actually took place. Used to compare volumes, wait times, and turnaround times across sites.
MI_Encounter_Type - Categorization of encounters into different types of care. Encounter Type at the complete date/time. (For Encounter Types, see the Encounters checklist.)
MI_Radiologist_Provider - Most recent (final) Primary Physician on the radiologist report. The Primary Physician who read the results in RadNet.
MI_Order_Physician_Provider - Physician, Midwives or Nurse Practitioner who ordered the exam
MI_Primary_Staff_Provider - The Primary Medical Imaging Technologist or Physician performing the exam at complete date/time.
MI_Order_Staff_Provider - Medical Imaging Personnel who entered the order in RadNet.
MI_Request_Date - For scheduled or unscheduled orders: The date the order was requested to be performed. Usually the same date as the scheduled appointment date.
MI_Request_Time - For scheduled or unscheduled orders: The time the order was requested to be performed. Usually the same time as the scheduled appointment time.
MI_Scheduled_Date - For scheduled orders: the date the Sched_Appointment_Date is entered in the system. The date the scheduled appointment date is entered in the system by the booking clerk (where system booking action = book).
MI_Scheduled_Time - For scheduled orders: the time the Sched_Appointment_Date is entered in the system. The time the scheduled appointment date is entered in the system by the booking clerk (where system booking action = book).
MI_Scheduled_Confirmed_Date - For scheduled orders: the date that the most recent appointment was confirmed with the patient. The date that the most recent appointment was confirmed with the patient by an automated phone call from the booking office (where system booking action = confirm).
MI_Scheduled_Confirmed_Time - For scheduled orders: the time that the most recent appointment was confirmed with the patient. The time that the most recent appointment was confirmed with the patient by an automated phone call from the booking office (where system booking action = confirm).
MI_Ordered_Date - For scheduled and non scheduled orders: The date the order is entered in RadNet. The date the order is entered in RadNet by the booking office. The order can be entered after the appointment is scheduled.
MI_Ordered_Time - For scheduled and non scheduled orders: Time order was entered in RadNet. The time the order is entered in RadNet by the booking office. The order can be entered after the appointment is scheduled.
MI_Start_Date - Date that the order was started
MI_Start_Time - Time that the order was started
MI_Exam_Complete_Date - Date that the order completed
MI_Exam_Complete_Time - Time that the order completed
MI_Dictation_Date - Time that the report was dictated. This is the most recent time the report was updated. There may be more than 1 dictation time stamp associated with the order. There is a timestamp associated with each time the report was updated.
MI_Dictation_Time - Time that the report was dictated. This is the most recent time the report was updated. There may be more than 1 dictation time stamp associated with the order. There is a timestamp associated with each time the report was updated.
MI_Transcribed_Date - Date that the report was transcribed. This is the most recent date the report was updated. There may be more than 1 transcription time stamp associated with the order. There is a timestamp associated with each time the report was updated.
MI_Transcribed_Time - Time that the report was transcribed. This is the most recent time the report was updated. There may be more than 1 transcription time stamp associated with the order. There is a timestamp associated with each time the report was updated.
MI_Final_Date - Date that the report was finalized or signed out. Date time that the report was finalized or signed out by a Provider. Once finalized, the results are available for viewing in RadNet.
MI_Final_Time - Time that the report was finalized or signed out. Time that the report was finalized or signed out by a Provider. Once finalized, the results are available for viewing in RadNet.
MI_Sched_Request_Date - For scheduled orders: date the booking form was received by the booking office or the date the order was scheduled in the system. Booking forms are sent by the ordering provider by 1) fax or 2) Department Order Entry (DOE) or 3) CPOE. If faxed, this is the date the booking form is received by the booking office and added to a request list. If DOE or CPOE, the date the order is scheduled in the system is autopopulated. Orders are scheduled 500 days out.
MI_Sched_Request_Time - For scheduled orders: time the booking form was received by the booking office or the time the order was scheduled in the system. If faxed, the time the booking form was received by the booking office. Autoinserted as 07:00 or 08:00. If DOE or CPOE, the time the order was scheduled in the system. Also autoinserted as 07:00 or 08:00.
MI_Sched_Booked_Date - For scheduled orders: the date the Sched_Appointment_Date is entered in the system. The date the scheduled appointment date is entered in the system by the booking clerk (where system booking action = book).
MI_Sched_Booked_Time - For scheduled orders: the time the Sched_Appointment_Time is entered in the system. The time the scheduled appointment date is entered in the system by the booking clerk (where system booking action = book).
MI_Sched_Appointment_Date - For scheduled orders: the planned date of the appointment. The planned appointment date. This will be the most recent planned date if the appointment was rescheduled.
MI_Sched_Appointment_Time - For scheduled orders: the planned time of the appointment. The planned appointment time. This will be the most recent planned time if the appointment was rescheduled.
Sched_Wait_Days_datetime - Number of days between Scheduled Request Date/Time to Scheduled Appointment/Time (rounded down to nearest hour). Used for reporting of the CT and MRI dashboard measure (Percentage of orders meeting benchmark).
Request_Sched_Appt_Wait_Days - Number of days between Scheduled Request Date/Time (at midnight) to Scheduled Appointment/Time. Used to replicate wait time statistics reported in the period report produced by the Medical Imaging department (Days_Wait field).
Exam_Complete_Count - Sum of records with valid order COMPLETE DATE TIME. If the complete date time field contains a valid date time, and the exam was not cancelled, then the value will be 1. If this criteria is not met, then the value will be 0.
Exam_Complete_Minutes - Time from START DATE TIME to order COMPLETE DATE TIME. Time between physical start date time and physical complete date time of the exam.
Transcribed_Minutes - Time from START DATE TIME to TRANSCRIBED DATE TIME. Time between physical start date time and most recent system transcription date time.
Dictation_Minutes - Time from START DATE TIME to DICTATION DATE TIME. Time between physical start date time and most recent system dictation date time.
Final_Minutes - Time from START DATE TIME to FINAL DATE TIME. Time between physical start date time and most recent system finalization date time.
Dictation_Count - Sum of records with valid DICTATION DATE TIME. If the dictation date time field contains a valid date time, and the exam was not cancelled, then the value will be 1. If this criteria is not met, then the value will be 0.
Transcribed_Count - Sum of records with valid TRANSCRIBED DATE TIME. If the transcribed date time field contains a valid date time, and the exam was not cancelled, then the value will be 1. If this criteria is not met, then the value will be 0.
Final_Count - Sum of records with valid FINAL DATE TIME. If the final date time field contains a valid date time, and the exam was not cancelled, then the value will be 1. If this criteria is not met, then the value will be 0.
MI_Accession_Class - Accession class (modality) of the order. Options are: BI: Breast Imaging; CA: Cardiac; CT: Computer Tomography; ES: Endoscopy; GI: Gastointestinal; IR: Intervential Radiology; MR: Magnetic Resonance Imaging; NE: Neurotelemetry; NM: Nuclear Medicine; RE: Respiratory; UR: Urology; US: Ultrasound; XR: X-Ray.
Scheduled_Count - Sum of records with valid SCHEDULE REQUEST DATE TIME. If the scheduled request date time field contains a valid date time, then the value will be 1. If this criteria is not met, then the value will be 0.
Other
Medical Imaging Results
A checklist of data elements for Medical Imaging Results is not currently available.
Please list or describe the data you require.
Please describe the other Medical Imaging data you require.
Mental Health & Substance Use (MHSU)
Brief descriptions of Mental Health and Substance Use (MHSU) Minimum Reporting Requirements (MRR) data:
Service Episode - A service episode has a date of first contact and a date of discharge from service. In this way, an episode covers a period of time and serves as an "envelope" within which other information are recorded. Data in the service episode records information pertaining to the date of first contact, date of first service event, living arrangement, service and the subsequent discharge. A client may be admitted to more than one service at the same time.
Service Event - If a particular programme of care or intervention, identified in the service episode data, requires event
information then, the service event record will contain the date and time of the events (or visits).
Diagnosis 5 (DSM-5 codes) - Certain continuum of MHSU services (episodes) require diagnostic data. The MHA MRR allows diagnostic data to be submitted using either DSM-IV TR or DSM-5 because not all health authorities have implemented DSM-5. At least one DSM-5 or DSM-IV TR is captured at enrolment and discharge. Updates may be submitted while the client is on care.
Diagnosis (DSM-IV-TR codes) - Certain continuum of MHSU services (episodes) require diagnostic data. The MHA MRR allows diagnostic data to be submitted using either DSM-IV TR or DSM-5 because not all health authorities have implemented DSM-5. At least one DSM-5 or DSM-IV TR is captured at enrolment and discharge. Updates may be submitted while the client is on care.
Health of the Nation Outcome Scale (HoNOS) - Certain continuum of MHSU services (episode) require a HoNOS record. The HoNOS is a clinician rated instrument comprising 12 simple scales measuring behaviour, impairment, symptoms and social functioning. Updates may be submitted while the client is on care. When required, the HoNOS must be completed at intervals not exceeding six months during the delivery of a Continuum of MHSU Service in which the client is enrolled.
Substance Use - Certain continuum of MHSU services (episodes) require substance use data. Substance use data are generally required at enrolment and discharge. More than one substance may be recorded for a given client and episode. Updates may be submitted while the client is on care. When required, the HoNOS must be completed at intervals not exceeding six months during the delivery of a Continuum of MHSU Service in which the client is enrolled.)
Please see the Ministry of Health
MHA MRR Data Dictionary for information on service episodes, reporting levels, and other important information related to this dataset.
There are seven MHSU data checklists.
MHSU data is divided into seven subsections. The data checklist for a sub-section will be displayed on this form only if the sub-section is selected here.
1. MHSU Client Information
(select only the data fields required for this project)
2. MHSU Service Episode Record
(select only the data fields required for this project)
3. MHSU DSM-5 Diagnostic Record
(select only the data fields required for this project)
4. MHSU DSM-IV-TR Diagnostic Record
(select only the data fields required for this project)
5. MHSU Health of the Nations Outcome Scale (HoNOS)
Valid values for HoNOS data fields:
00 no problem
01 minor problem requiring no action
02 mild problem but definitely present
03 moderately severe problem
04 severe to very severe problem
98 unknown/not asked
99 not applicable
Null
(select only the data fields required for this project)
N2 Date of HoNOS Assessment - Date the client received a HoNOS assessment
N3 HoNOS Problems with Overactive, Aggressive, Disruptive, Agitated or Antisocial Behaviour - Include such behaviour due to any cause, for example drugs, alcohol, dementia, psychosis, depression, etc. Do not include bizarre behaviour, rated at scale 6 (N8 HoNOS Problems Associated with Hallucinations, Delusions or Abnormal Perceptions (False Beliefs)
N4 HoNOS Non Accidental Self Injury - Does not include accidental self-injury, due for example to dementia or severe learning disability; the cognitive problem is rated at scale 4 (N6 HoNOS Cognitive Problems) and the injury at scale 5 (N7 HoNOS Problems Related to Physical Illness or Disability) Does not include illness or injury as a direct consequence of drug/alcohol use rated at scale 3 (N5 HoNOS Problems Drinking or Drug Taking/Use (Problems with Alcohol, Substance/Solvent Use), for example cirrhosis of the liver or injury resulting from drunk driving are rated at scale 5 (N7 HoNOS Problems Related to Physical Illness or Disability)
N5 HoNOS Problems Drinking or Drug Taking/Use - Does not include aggressive/destructive behaviour due to alcohol or drug use, rated at scale 1 (N3 HoNOS Problems with Overactive, Aggressive, Disruptive, Agitated or Antisocial Behaviour (Behavioural Disturbance). Does not include physical illness or disability due to alcohol or drug use, rated at scale 5 (N7 HoNOS Problems Related to Physical Illness or Disability)
N6 HoNOS Cognitive Problems - Include problems of memory, orientation and understanding associated with any disorder; learning disability, dementia, schizophrenia, etc. Does not include temporary problems, for example hangovers, resulting from drug/alcohol use, rated at scale 3 (N5 HoNOS Problem Drinking or Drug Taking/ Use (Problems with Alcohol, Substance/Solvent Use)
N7 HoNOS Problems Related to Physical Illness or Disability - Include illness or disability from any cause that limits or prevents movement, or impairs sight or hearing, or otherwise interferes with personal functioning Include side-effects from medication; effects of drug/alcohol use; physical disabilities resulting from accidents of self-harm associated with cognitive problems, drink-driving, etc. Does not include mental or behavioural problems rated at scale 4 (N6 HoNOS Cognitive Problems)
N8 HoNOS Problems Associated with Hallucinations, Delusions or Abnormal Perceptions - Include hallucinations and delusions irrespective of diagnosis. Include odd and bizarre behaviour associated with hallucinations or delusions. Do not include aggressive, destructive or overactive behaviours attributed to hallucinations or delusions, rated at scale 1 (N3 HoNOS Problems with Overactive, Aggressive, Disruptive, Agitated or Antisocial Behaviour)
N9 HoNOS Problems with Depressive Mood - Do not include over activity or agitation, rated at scale 1 (N3 HoNOS Problems with Overactive, Aggressive, Disruptive, Agitated or Antisocial Behaviour) Do not include suicidal ideation or attempts, rated at scale 2 (N4 HoNOS Non Accidental Self Injury) Does not include delusions or hallucinations, rated at scale 6 (N8 HoNOS Problems Associated with Hallucinations, Delusions or Abnormal Perceptions (False Beliefs)
N10 HoNOS Problems with Relationships - Rating of the patient's most severe problem associated with active or passive withdrawal from social relationships, and/or non-supportive, destructive or self-damaging relationships
N11 HoNOS Problems with Activities of Daily Living - Rating of the overall functioning in activities of daily living (ADL), for example problems with basic activities of self-care such as eating, washing, dressing, toilet; also complex skills such as budgeting, organizing where to live, occupation and recreation, mobility and use of transport, shopping, self-development. etc. Includes any lack of motivation for using self-help opportunities, since this contributes to a lower overall level of functioning. Does not include lack of opportunities for exercising intact abilities and skills, rated at scale 11 (N12 HoNOS Overall Problems with Living Conditions) and 12 (N13 HoNOS Problems with Occupation/Work and (Leisure) Activities - Quality of Daytime Environment)
N12 HoNOS Overall Problems with Living Conditions - Rating of the overall severity of problems with the quality of living conditions and daily domestic routine Are the basic necessities met (heat, light, hygiene)? If so, is there help to cope with disabilities and a choice of opportunities to use skills and develop new ones? Does not rate the level of functional disability itself, rated at Scale 10 (N11 HoNOS Problems with Activities of Daily Living)
N13 HoNOS Problems with Occupation / Work and (Leisure) Activities - Rating of the overall level of problems with quality of day-time environment. Is there help to cope with disabilities, and opportunities for maintaining or improving occupational and recreational skills and activities? Considers factors such as stigma, lack of qualified staff, access to supportive facilities, for example staffing and equipment of day centres, workshops, social clubs, etc. Does not rate the level of functional disability itself, rated at scale 10 (N11 HoNOS Problems with Activities of Daily Living)
N14 HoNOS Problems with Over Activity, Attention or Concentration - Include overactive behaviour associated with any cause such as hyperkinetic disorder, mania drug use Include problems with restlessness, fidgeting, attention or concentration due to any cause, including depression
N15 HoNOS Problems with Scholastic or Language Skills - Include problems with reading, spelling, arithmetic, speech or language associated with any disorder or problem, such as a specific developmental learning problem or physical disability such as a hearing problem Includes reduced scholastic performance associated with emotional or behavioural problems Do not include temporary problems resulting purely from inadequate education Children with generalised learning disability should not be included unless their functioning is below the expected level
N16 HoNOS Problems with Non Organic Somatic Symptoms - Include problems with gastrointestinal symptoms such as non-organic vomiting, cardiovascular symptoms, neurological symptoms, non-organic enuresis or encopresis, sleep problems or chronic fatigue Do not include movement disorders such as tics rated with "physical illness or disability problems" scale 5 (N7 HoNOS Problems Related to Physical Illness or Disability), or physical illnesses that complicate non organic somatic symptoms rated with "physical illness or disability problems" scale 5 (N7 HoNOS Problems Related to Physical Illness or Disability)
N17 HoNOS Problems with Emotional and Related Symptoms - Rates only the most severe clinical problem not considered previously Includes depression, anxiety, worries, fears, phobias, obsessions or compulsions, arising from any clinical condition including eating disorders Do not include aggressive, destructive or overactive behaviours attributed to fears or phobias, rated with "problems with disruptive, antisocial or aggressive behaviour" scale 1 (N3 HoNOS Problems with Overactive, Aggressive, Disruptive, Agitated or Antisocial Behaviour) Do not include physical complications of psychological disorders, such as severe weight loss, rated with "physical illness or disability problems" scale 5 (N7 HoNOS Problems Related to Physical Illness or Disability)
N18 HoNOS Problems with Peer Relationships - Include problems with school mates and social network, active or passive withdrawal from social relationships, over intrusiveness or ability to form satisfying peer relationships Includes social rejections as a result of aggressive behaviour or bullying Do not include aggressive behaviour, bullying rated with "problems with disruptive antisocial or aggressive behaviour" scale 1 (N3 HoNOS Problems with Overactive, Aggressive, Disruptive, Agitated or Antisocial Behaviour) or problems with family or siblings rated with "problems with family life and relationships" scale 12 (N10 HoNOS Problems with Relationships)
N19 HoNOS Problems with Self Care and Independence - Rates the overall level of functioning, for example problems with basic activities of self-care such as feeding, washing, dressing, toileting, also complex skills such as managing money, travelling independently, shopping etc., taking into account the norm for a child's chronological age Include poor levels of functioning arising from lack of motivation, mood or any other disorder Does not include lack of opportunities for exercising, intact abilities and skills, as might occur in an over restrictive family rated with "problems with family life and relationships" scale 12 (N10 HoNOS Problems with Relationships), or enuresis and encopresis rated with "problems with non organic somatic symptoms" scale 8 (N16 HoNOS Problems with Non-organic Somatic Symptoms)
N20 HoNOS Poor School Attendance - Includes truancy, school refusal, school withdrawal or suspension for any cause Includes attendance at type of school at the time of rating, for example hospital school, home tuition, etc. If school holiday, rates the last two weeks of the previous term
N21 HoNOS Problems with Knowledge or Understanding about the Nature of the Child/Adolescent's Difficulties - Include lack of useful information or understanding available to the child/adolescent, parents or caregivers Include lack of explanation about the diagnosis or the cause of the problem or the prognosis
N22 HoNOS LD#1 Behavioural Problems Directed at Others - Include behaviour that is directed to other persons. Does not include behaviour that is directed towards self-scale 2 (N23 Behavioural Problems Directed Toward Self) or primarily at property or other behaviours scale 3 (N24 Other Mental and Behavioural Problems) Rates risk as it is currently
N23 HoNOS LD#2 Behavioural Problems Directed Towards Self (Self Injury) - Include all forms of self-injurious behaviour. Do not include behaviour directed towards others scale 1 (N22 Behavioural Problems Directed at Others), or behaviour primarily directed at property, or other behaviours scale 3 (N24 Other Mental and Behavioural Problems)
N24 HoNOS LD#3 Other Mental and Behavioural Problems - This is a global rating to include behavioural problems not described in scales 1 or 2 Does not include behaviour directed towards others scale 1 (N22 Behavioural Problems Directed at Others) or self-injurious behaviour scale 2 (N23 Behavioural Problems Directed Toward Self). Rate the most prominent behaviours present, including: A. behaviour destructive to property; B. problems with personal behaviours, for example, spitting, smearing, eating rubbish, self-induced vomiting, continuous eating or drinking, hoarding rubbish, inappropriate sexual behaviour; C. rocking, stereotyped and ritualistic behaviour; D. anxiety, phobias, obsessive or compulsive behaviour; E. others
N25 HoNOS LD#4 Attention and Concentration - Includes problems that may arise from under activity, overactive behaviour, restlessness, fidgeting or inattention, hyper kinesis or arising from drugs
N26 HoNOS LD#5 Memory and Orientation - Includes recent memory loss and worsening of orientation for time, place and person in addition to previous difficulties
N27 HoNOS LD#6 Communications (Problems with Understanding) - Include all types of responses to verbal, gestural and signed communication, supported if necessary with environmental cues
N28 HoNOS LD#7 Communications (Problems with Expression) - Include all attempts to make needs known and communicate with others (words, gestures, signs). Rate behaviour under scale 1(N22 Behavioural Problems Directed at Others), 2 (N23 Behavioural Problems Directed Toward Self) and 3 (N24 Other Mental and Behavioural Problems)
N29 HoNOS LD#8 Problems Associated with Hallucinations and Delusions - Include hallucinations and delusions irrespective of diagnosis Includes all manifestations suggestive of hallucinations and delusions (responding to abnormal experiences, for example invisible voices when alone)
N30 HoNOS LD#9 Problems Associated with Mood Changes - Include problems associated with low mood states, elated mood states, mixed moods and mood swings (alternating between unhappiness, weeping and withdrawal on one hand and excitability and irritability on the other)
N31 HoNOS LD#10 Problems with Sleeping - Do not rate intensity of behaviour disturbance - this should be included in scale 3 (N24 HoNOS LD #3: Other Mental and Behavioural Problems). Includes daytime drowsiness, duration of sleep, frequency of waking and diurnal variation of sleep pattern
N32 HoNOS LD#11 Problems with Eating and Drinking - Include both increase and decrease in weight
Do not rate pica - which should be rated in scale 3 (N24 Other Mental and Behavioural Problems) This scale does not include problems experienced by people who cannot feed themselves, for example people with severe physical disability
N33 HoNOS LD#12 Physical Problems -Physical problems include illness from any cause that adversely affects mobility, self-care, vision and hearing, for example dementia, thyroid dysfunction, tremor affecting dexterity. Do not include relatively stable physical disability, for example cerebral palsy, hemiplegic. Behavioural disorders caused by physical problems should be rated under scale 1 (N22 Behavioural Problems Directed at Others), 2 (N23 Behavioural Problems Directed Toward Self) and 3 (N24 Other Mental and Behavioural Problems), for example constipation producing aggression
N34 HoNOS LD#13 Seizures - Seizures include all types of fits (partial, focal, generalised, mixed, etc.) to rate the short-term effect on the individual's daily life. Rates the effects of the fits. Does not include behavioural problems caused by, or associated with, fits: use scale 1(N22 Behavioural Problems Directed at Others), 2 (N23 Behavioural Problems Directed Toward Self) and 3 (N24 Other Mental and Behavioural Problems)
N35 HoNOS LD#14 Activities of Daily Living at Home - Include such skills as cooking, cleaning and other household tasks
Do not rate problems with daily living outside the home scale 15 (N36 Activities of Daily Living Outside the Home)
Do not rate problems with self-care scale 16 (N37 Level of Self Care) Rate what is seen regardless of cause, for example, disability, motivation etc. Rate performance, not potential
N36 HoNOS LD#15 Activities of Daily Living Outside the Home - Include skills such as budgeting, shopping, mobility and the use of transport, etc. Do not include problems with activities of daily living at home scale 14 (N35 Activities of Daily Living at Home). Do not rate problems with self-care scale 16 (N37 Level of Self Care). Rate the current level with the existing support
N37 HoNOS LD#16 Level of Self Care - Rate the overall level of functioning in activities of self-care such as eating, washing, dressing and toileting. Rate the current level achieved with the existing support. Rate appearance not motivation
N38 HoNOS LD#17 Problems with Relationships - Include effects of problems with relationships with family, friends and carers (in residential and day/ leisure settings) Measure what is occurring regardless of cause, for example, somebody who is known to have good relationships may still display problems
N39 HoNOS LD#18 Occupation and Activities - Rate the overall level of problems with quality of daytime environment. Take account of frequency and appropriateness of, and engagement with, daytime activities. Consider factors such as lack of qualified staff, equipment and appropriateness with regard to age and clinical condition. Do not rate problems with self-care scale 16 (N37 Level of Self Care)
N40 Mania - Based on observations at time of assessment
N41 Anxiety Including Obsessions / Compulsions - Based on observations at time of assessment
N42 Filler (blank)
N43 Filler (blank)
N44 Eating Disordered Behaviour - Where information leads practitioner to suspect eating disorder behaviour is present, or where client presents with issue
N45 HoNOS Problems with Lack of Information About Services or Management of the Child's / Adolescent's Difficulties - Include lack of useful information available to the child/adolescent, parents or carers or referrers. Include lack of information about the most appropriate way of providing services to the child such as care arrangements for educational placements or respite care or statementing
N46 HoNOS Tool - Identify the HoNOS tool used at assessment - 01 Children & Youth; 02 Adult/Senor; 03 Learning Disability; 99 Not applicable
Other
6. MHSU Substance Use - substances
(select only the substances required for this project)
7. MHSU Substance Use - client information
(select only the data fields required for this project)
If this project requires additional MHSU data elements not listed in the sections available, please list and describe the additional MHSU data elements required.
National Ambulatory Care Reporting System (NACRS)
The National Ambulatory Care Reporting System (NACRS) is a tool of the Canadian Institute for Health Information (CIHI) for collecting and reporting data from emergency departments across Canada through the use of standardized definitions and coding that adheres to national and international standards.
Note: Emergency Room Visit data and NACRS data are not the same thing. NACRS data covers fewer facilities and contains a subset of the Emergency Room Visit data. See Emergency Room Visits in this form.
NACRS data includes data from Emergency Departments at sites using Cerner FirstNet - Cowichan District Hospital, Campbell River General Hospital, Comox Valley Regional Hospital, Nanaimo Regional General Hospital, Royal Jubilee Hospital, Saanich Peninsula Hospital, Victoria General Hospital.
NACRS data does not include data from Tofino General Hospital, Port Hardy Hospital, Port McNeill Hospital, West Coast General Hospital (Port Alberni), nor the Urgent Care Centres.
National Ambulatory Care Reporting System (NACRS)
(select only the data fields required for this project)
Note: ED Discharge Diagnosis is not of high enough quality to use in an analysis.
Registration Date - Calendar date when patient presents for services and is officially registered as a patient.
Registration Time - The time when patient is registered at the facility on the day of the visit. Uses 24 hour clock. Midnight is 00:00 hours next calendar day
Admit by Ambulance - Identifies if a patient arrives at reporting facility via ambulance and the type of ambulance that was used. Air Ambulance (A), Ground Ambulance (G), Combination of Air and Ground (C), No Ambulance (N).
Triage Date - The calendar date when the patient is triaged in ED
Triage Time - The time when the patient was triaged.
Triage Time Unknown - Flag to indicate when Triage Time is unknown (Y or blank)
Triage Level - The Canadian Triage and Acuity Scale (CTAS) number to categorize patients according to the type and severity of their initial presenting signs and symptoms. (1-5, 9)
Date of Physician Initial Assessment - Calendar date when patient was first assessed by a physician
Time of Physician Initial Assessment - Time when patient was first assessed by a physician.(99:99 = unknown)
Time of Physician Initial Assessment Unknown - Flag to indicate that Time of Physician Initial Assessment is unknown.
ED Visit Indicator - Indicates if ED visit is a "true" emergency room visit or a scheduled clinic type visit. (N, Y)
Contact Mode - Describes method of contact between provider and patient. (1 to 7, 1=face-to-face visit with individual patient.)
ED Presenting Complaint - The reason for seeking emergency medical care as identified by the patient; reported as Canadian Emergency Department Information System (CEDIS) code.
ED Discharge Diagnosis Occurrence - counts number of occurrences of ED Discharge Diagnosis (1, 2 or 3)
ED Discharge Diagnosis - The patient's diagnosis at the time of discharge from the emergency department, reported as the select ICD10CA codes that are on the Canadian Emergency Department Diagnostic Short List (CED-DxS list). NOTE! ED Discharge Diagnosis collection in NACRS started with July 16, 2013 registrations, at NRG, RJH, and VGH. PowerNote ED in use only at NRG. At RJH and VGH, clerical support enters diagnoses from paper record into Cerner Diagnosis Control. The terms from Cerner are translated to CED-DxS terms by the interface process using a mapping database. The mapping database is external to Cerner and is maintained by Clinical Information Support. Use CAUTION when including ED Discharge Diagnosis in analysis as the data quality is unreliable.
Provider Number - Identification number associated with provider responsible for provision of services to patient during visit
Provider Type - Only the Most Responsible provider is listed. (M)
Provider Service - Identifies the role played by provider in association with the patient's visit (reflects provider specialty). (a 5-character number)
Disposition Date - The calendar date when the service provider makes the decision about the patient's disposition. It is the "end point" for an ED visit.
DIsposition Time - The time when the main service provider makes the decision about the patient's disposition. Use 24 hour clock. Midnight is 00:00 hours next calendar day. Note: Continuous Encounter: Patients at same site, ED to DC and ED to IP are not discharged. The encounter type is changed in the existing visit. Encounter number stays the same. To find when the Emergency level of care was changed to a higher level of care, access the View Encounter conversation and note the Inpatient Admit Date and Time or Day Care Admit Date and Time.
Disposition Time Unknown - Flag to indicate when Disposition Time is unknown. (Y, blank)
Discharge Disposition - Patient's type of separation from ambulatory care service after registration to that service. 06-Admitted to reporting facility as inpatient to SCU or OR;07-Admitted to reporting facility as inpatient to other unit; 08-Transferred to another acute care facility; 09-Transferred to another non-acute care facility; 12-Intra-facility transfer to day care; 14-Intra-facility transfer to clinic; 16-Discharged home with support service/referral; 17-Discharged home (no support service/referral); 30-Transfer to residential care; 40-Transfer to group/suppportive living; 61-Left after registration; 64-Left after initial treatment; 63-Left after triage; 64-Left after initial assessment; 71-Death on arrival (DOA); 72-Died in facility (DAA); 73-Medical assistance in dying (MAID); 74-Suicide in facility; 90-Transfer to correctional facility.
Date Patient Left ED - Required when patient is admitted to higher level of care or transferred to another facility. The calendar date when the patient physically leaves the emergency department and does not return during that visit. Use date admitted to inpatient or day care unit of same facility. Use ED discharge date if transferred to other facility.
Time Patient Left ED - Required when patient is admitted to higher level of care or transferred to another facility. The time when the patient physically leaves the emergency department and does not return during that visit. Use time admitted to inpatient or day care unit of same facility. Use ED discharge time if transferred to other facility.Note: NRG, SPH, and RJH have Inpatient rooms in ED Units. When patient is admitted and transferred to one of these rooms in the ED, use that transaction date/time for Left ED date/time.
Time Patient Left ED Unknown - Flag to indicate when Time Patient Left ED is unknown. (Y, blank)
L.O.S. Time in Hours - Patient's length of stay in ED, calculated in hours.
L.O.S. Total Minutes - Patient's length of stay in ED, calculated in minutes.
Other
If this project requires additional NACRS data elements not listed in the NACRS sections above, please list and describe the additional NACRS data elements required.
Patient Centred Measurement
The Acute Inpatient 2016-17 Survey
The Acute Inpatient 2016/17 Survey asked patients about their health-related quality of life and their experiences with the quality of care and services received as an inpatient in one of 78 acute care hospitals and two freestanding rehabilitation hospitals in British Columbia. Date range: September 2st 2016 - March 31st 2017
For more information: Acute Inpatient Survey 2016-2017: HealthIdeas Toolkit for Data Users
The Emergency Department 2018 Survey
The 2018 Emergency Department Survey asked patients about their health-related quality of life and their experiences with the quality of care and services received from one of 108 emergency department facilities in British Columbia. Date range: January 1, 2018-March 31, 2018
For more information: Emergency Department 2018: HealthIdeas Toolkit for Data Users
A check list of data elements and data dictionary are not currently available for Patient-Centred Measurement data.
For more information please e-mail
DataRequest@VIHA.ca
Island Health Pharmacy Data.
Explanations about the data elements are included in the checklist.
For more information about Island Health pharmacy data please send an e-mail to
DataRequest@VIHA.ca
Pharmacy
Please list the specific medications you are interested in.
Pharmacy
Island Health pharmacy data contain orders written by a physician, dentist, midwife or nurse practitioner, and verified by an Island Health pharmacist. These orders include prescription medications, over the counter medications, intravenous solutions, etc.
(select only the data fields required for this project)
Note: 'Duration' can be inferred/calculated based on the dose and the frequency
If "Other" was selected for Pharmacy data, please list and describe the additional pharmacy data elements required for this project.
CIHI Population Grouping Methodology
To comply with an Information Sharing Agreement with the Ministry of Health, Island Health is not able to provide these data for research purposes. If these data are required for research purposed, please contact the BC Ministry of Health.
The population grouping methodology builds clinical and demographic profiles for each person in a population, including health system non-users. For more information please see Population Grouping Methodology Information Sheet.
CIHI Population Grouping Methodology
(select only the data fields required for this project)
lookback_option - Lookback option
lookback_period - Beginning and end date of lookback period
lookback_start_dt - Lookback start date
lookback_end_dt - Lookback end date
cohort_year - Cohort year
overrides - Overrides applied
msp_elig_on_ref_dt_flag - Eligible at lookback end date
Study_ID - Project-specific study ID
age_num - Age in years
age_group_code - Age group code for 5 year age group (0, 1-4, 5-9, 10-14, 15-19, etc.
physician_flag - Physician flag
inpatient_flag - Inpatient flag
day_surgery_flag - Day surgery flag
emergency_flag - Emergency flag
ltc_flag - Long term care flag
hc_cnt - Health Condition Count
hc_interaction_cnt - Health Condition Interaction Count
pop_user_code - User Code
hpg_code - Health Profile Group Code
hpg - Health Profile Group
All Variables - A01 to S99 - Health condition tags (0 or 1) from A01 to S99. There are 227 health conditions
DATA_SOURCE_ID - Unique record identifier - distinguishes diagnoses by event; not to be used to count visits; HA Data Administrator will redact for HA Program Area Analysts if not required for project
PROVINCE_CODE - Client's province of residence, e.g., BC
DIAG_CLASSIFICATION_CODE - Diagnosis classification used in source data. 9 = ICD-9 diagnosis code (Physician data only); 0 = ICD-10-CA diagnosis code (DAD, NACRS only); R = RAI-MDS 2.0 data element name (CCRS data only).
POP_DATA_SOURCE_CODE - Source of record : DAD-IP, DAD-DS, NACRS-ED, CCRS-LTC, PLPB
SERVICE_DATE - Date of source record - starting from April 1, 2002
DIAG_CODE - Diagnosis code.
Primary Care
There is currently no check list of data elements or data dictionary for primary care data.
Please describe the primary care data you would like to obtain.
Surgical Cases
For additional information about day surgeries and interventions performed during a hospital stay, see Hospital Stay - procedures / interventions.
Surgical Cases
(select only the data fields required for this project)
Anesthesis Minutes -
Cleanup Minutes - Default planned minutes required to cleanup after a surgical case, specific to the selected procedure code. Cleanup duration occurs after incision close/ procedure stop time, but before the patient exits the OR.
Incision Minutes - Duration of surgical procedure, from Incision Start to Incision Close. Also known as the Cut to Close or Skin to Skin time.
Patient PARR Minutes - Number of minutes the patient spent in the Post Anesthetic Care Unit (PACU). Number of minutes between 'patient enter PARR' and 'patient exit PARR' date and time.
Patient Room Minutes - Number of minutes the patient spent in the OR. Number of minutes between 'patient enter room' and 'patient exit room' date and time.
Setup Minutes - Default planned minutes required to setup for a surgical case, specific to the selected procedure code. This setup duration occurs once the patient enters the OR, and before position/prep/drape begins.
Surgery Minutes - Duration of the surgical procedure in minutes. Surgical duration is from Position/Prep/Drape (PPD) time to Close time. This is the same calculation used to derive surgeon average times.
Actual Date - Date the surgery was performed. Defined as the date the initial incision was made.
Actual Nursing Unit Location - Post-operative nursing unit. Indicates where the patient was taken following their procedure, or after discharge from PACU (post-anesthesia care unit), if applicable.
Actual Operating Room Location - Operating room where the surgery was performed. While virtual rooms may be used for scheduling purposes, the physical location where the surgery finally occurred is documented in this dimension.
Age at Decision - Date of interest minus date of birth (calculated). Patient's age in years as of the decision date. This age is used to distinguish between adult and pediatric patients, specifically when assigning a BC Diagnosis code. Pediatric
patients are defined as 17 years old less a day or younger, as of the date of decision.
Age at Surgery - Date of interest minus date of birth (calculated). Patient's age as of the surgery date. BC Diagnosis code assignment of Pediatric vs Adult is based on age at Date of Decision, not Age at Surgery.
Anesthetist - Anesthetist who attended the case. Not all cases require an anesthetist, e.g., minor procedures done under a local anesthetic.
Hip Fracture admit date - Start date of the encounter. Date the patient is admitted for a hip fracture surgery. Admission refers to the first facility where the patient was admitted. If a patient is initially admitted at Hospital A, but is later transferred to Hospital B for their procedure, the admit date for Hospital A is used.
Post Case Surgical Procedure Group - Surgical procedure(s) performed. Includes the main and any/all sub-procedures. Requires a bridge table.
Surgeon - Surgeon who performed the case. Primary surgeon assigned to the case. There may also be secondary surgeons, assists etc., who can be linked using a staff bridge table.
Surgical Anesthesia Type Group - Type of anesthesia used on the case. Multiple types of anesthesia may be administered to a patient simultaneously, e.g., a general and a local. These are documented in the anesthesia group, using a bridge table.
Surgical Diagnosis - Patient's urgency category and associated diagnosis as indicated by the surgeon on the booking form. Diagnoses and associated clinical benchmarks are standardized provincially for adults, and nationally for pediatrics. Referred to as BC Diagnosis Codes, this data is used to assist in patient prioritization and waitlist management, and are not typically used for urgent/emergent surgeries. However, the Acute Hip Fracture diagnosis code is also stored here.
Wait List Surgical PROCEDURE GROUP - Surgical procedure(s) requested or scheduled to be performed. Record state = Wait List then it comes from the Request list. Record state = Pre-Case then it comes from the Schedule. Includes the main and any sub procedures.
Other
If "Other" was selected in the Surgical Cases checklist above, please list and describe the additional Surgical data elements required for this project.
Transfusion data
Transfusion data are available from March 19, 2016 and include patients who received transfusion during hospitalization within Island Health facilities.
Transfusion data
(select only the data fields required for this project)
Blood product blood types (ABO and Rh type)
Red Blood Cell (RBC) product age at transfusion
Blood products dispensed and transfused
Number of units dispensed
Number of units transfused
Derivatives transfused
Number of IU, vials, mL, gram transfused
Product inventory area at dispense
Verified Lab test results (based on time in relation to the surgery, transfusion and hospitalization)
Selected lab tests
Surgical and non-surgical interventions
Patient demographics
Patient blood types (ABO and Rh type)
Patient location at dispense
Patient hospital encounter details (LOS, ICU, readmission etc.)
Patient discharge disposition (in-hospital death)
Transfusion reaction
Patient diagnoses, Charlson Comorbidity Index and case mix groups
Patient medications of interest of transfusion medicine
Selected medications in the following category: Anticoag, Antiplatelet, IIbIIIa inhib, ESA's
Transfusion Medicine Laboratories (TML) product orders
Quantity of the product ordered
Clinical indication for transfusion (at order)
Other
If "Other" was selected in the Transfusion checklist above, please list and describe the additional Transfusion data elements required for this project.
If data required by your project is not listed above, please attach a list of data elements required with a plain-language description Please use the link on the right to upload the file
How often do you require the data to be provided?
One time
Weekly updates
Monthly updates
Annual updates
Need to accrue to a maximum number of patients/cases
Other
Please explain "other" data retrieval interval:
When are the ISLAND HEALTH data required by?
Today D-M-Y Note: data cannot be provided until after Institutional Certificate of Approval is issued by Research & Capacity Building.
Once the ISLAND HEALTH data are received, how long will they be needed for?
Will any of the data requested here be needed/used for future projects related to this one?
Yes
No
Please explain how it will be needed for future projects
Output format - indicate the preferred data file format.
Access
Excel
tab/comma-separated value (CSV)
fixed width file
Other
Please specify "other" format.
Will the Island Health data listed above need to be linked with Field Data, i.e. data collected as part of the research?
Yes
No
Please explain the purpose of this linkage.
Where will the linkage be performed?
Note: Unless otherwise stated, it is expected that linkage will occur at Island Health.
Will the Island Health data listed above need to be linked with External Data, i.e. data from other sources, such as the Ministry of Health, PopDataBC, disease registries, etc.?
Yes
No
Please explain the purpose of this linkage.
Where will the linkage be performed?
Note: Unless otherwise stated, it is expected that linkage will occur at Island Health.
Submit
Save & Return Later