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 you have one assigned by Research & Capacity Building) 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
Name(s) of Island Health data specialist(s) who assisted with this data request?
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 provide a description of your project/initiative and the question you are trying to answer.* must provide value
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.) ( MB)
If you have an additional project document, you may attach it here. ( MB)
If you have an additional project document you may attach it here. ( MB)
What kind of activity is the project/initiative involved in? (please indicate all that apply)* must provide value
Research
Quality Improvement
Quality Assurance
Evaluation
Contract with Island Health
Island Health-based Initiative
External Initiative
Other
Please explain what "other" kind of activity is involved.
If this project is supported by senior Island Health personnel (Director or higher), please provide their Name(s) and Position(s) at Island Health.
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.) "Field data" (data generated by the project through participant enrollment, measurements, surveys, focus groups, interviews, etc.)
Island Health data (data from Island Health's data holdings)
External data (data from other sources e.g. the Ministry of Health, PopDataBC, provincial disease registry, etc.)
Study Population - Please use this Reference Document for the following question. Describe the study population
Which data will be used to identify/choose the study population? Indicate all that apply.* must provide value
"Field data" (individuals will be recruited as part of the research project)
Island Health data (Island Health's data holdings)
External data (data from other sources e.g. the Ministry of Health, PopDataBC, provincial disease registry, etc.)
Other
Please explain what "other" data will be used to identify the study population.
Estimated number of people in the study population
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. ( MB)
Please explain why consent will not be obtained
Please describe measures that will be taken to protect person-level data (prevent the identification of an individual), during:a) analysis; b) transfer of data; c) storage of data; d) destruction of data; e) distribution of results; f) publication * must provide value
Please describe when person-level data will be destroyed, and by whom.
What is the time period of the data required? Start date Today M-D-Y End date 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.) DataRequest@VIHA.ca * must provide value
Acute Care Hospital (DAD) - acute hospital inpatient stays; day surgery/day care
Ambulatory Care - colon screening; endoscopy
Blood Bank
Community Health Services - Home Care; Home Support; RAI-HC home care assessments; Home Care Reporting System (HCRS); Nursing and Rehabilitation; Case Management; Assisted Living
Encounters - visits to Island Health services; Emergency encounters; Registration; Admissions Discharges Transfers; Bed Census
Infection Prevention & Control - Hand Hygiene observations
Laboratory - Lab test orders placed to Island Health laboratories; turn-around times; test results
Long Term Care - Continuing Care Reporting System (CCRS); RAI 2.0 assessments; complex care; wait lists.
Medical Imaging - wait times; wait lists; exam transactions; images or results.
Mental Health & Substance Use - MHSU Minimum Reporting Requirements.
Patient-Centred Measurement - patient reported experience measures (PREMS); patient reported outcome measures (PROMS).
Pharmacy - pharmacy orders placed at Island Health owned pharmacies
Surgical - cases; wait list; implants; safe medical devices; inventory; case cart.
Other
If 'Other' was selected, please describe the data you require.
The Acute Care Hospital (DAD) Checklist is divided into 11 sections.DAD Data Dictionary (wait for the app; it takes a minute to load) DataRequest@VIHA.ca 1. CIHI DAD Abstract(select only the data fields required for this project) ACSC Count
Acute ALC Case
Acute ALC LOS Days
Acute Case
Acute LOS Days
Acute PostOp LOS Days
Acute PreOp LOS Days
Age in Days
Age in Months Value
Age in Years Fractional
Albumin Transfusion Count
CSAE Count
CSAE Fracture Count
CSAE Pneumonia Count
CSAE Pressure Ulcer Count
CSAE UTI Count
Encounter Number
Episode ID
ER Wait Time Minutes
LOS Days
LOS Hours
Readmission Count
Readmission Count All Causes
Readmission Episode ID
Readmission Episode ID All Causes
Same Day Discharge Case
SMI Episode ID
SMI Readmission
Stillborn Case
Surgical Day Care Case
Weight
AAP Date
ACSC Reason
Acute ALC Case CIHI Abstract
Acute CIHI Abstract
Admit Date
Admit Time
Age
CIHI Accounting Period
CIHI Admit Ambulance
CIHI Admit Category
CIHI DAD MRP Provider
CIHI Discharge Disposition
CIHI Entry Code
CIHI Project 325
CIHI Project 340
CIHI ReAdmit
CIHI Responsibility for Payment
CIHI Special Populations
Clinical Cohort Group
Discharge Date
Discharge Facility
Discharge Location
Discharge Time
Encounter Type
ER Departure Date
ER Departure Time
Gender
Geography
Glasgow Coma Scale
Most Responsible Diagnosis CIHI ICD10
Most Responsible Facility
Patient
Principal CCI Intervention
Reporting Facility
Returned to Original Residence
Stillborn Case CIHI Abstract
Surgical Day Care CIHI Abstract
Transfer From Facility
Transfer To Facility
Other
2. CIHI DAD CACS (Comprehensive Ambulatory Classification System)This is a grouping methodology used for daycare surgery. (select only data fields required for this project) ABF Workload
ACW (ambulatory care weight)
CACS Year
CCI Intervention
CIHI CACS Code
CIHI CACS MAC
Other
3. CIHI DAD CMG (Case Mix Group)(select only data fields required for this project) ABF Workload
Acute ELOS Days
CMG Year
Inpatient Resource Intensity Level
Resource Intensity Weight
Trim Point
CIHI CMG
CIHI CMG Atypical Reason
Other
4. CIHI DAD Diagnosis(select only data fields required for this project) Diagnosis Occurrence
DiagnosisCluster
F CIHI DAD Diagnosis ID
CIHI ICD10
Diagnosis Prefix
Diagnosis Type
Other
5. CIHI DAD Intervention Episode(select only data fields required for this project) Episode Count
Intervention Episode Occurrence
Intervention Episode Time Minutes
Intervention Occurrence
Post op Days
Pre op Days
CIHI Intervention Date
CIHI Intervention Episode Type
CIHI Intervention Relationship Anaesthetic Technique
CIHI Intervention Relationship Anaesthetist
CIHI Intervention Relationship Provider
CIHI Intervention Time
CIHI OOH Facility
CIHI Unplanned Return to OR
Other
6. CIHI DAD Intervention Procedure(select only data fields required for this project) Intervention Episode Occurrence
Intervention Occurrence
Intervention Procedure Sequence
CCI Intervention
CIHI Intervention Type
Other
7. CIHI DAD Intervention Provider(select only data fields required for this project) Intervention Episode Occurrence
Intervention Occurrence
CIHI Intervention Provider
CIHI Intervention Provider Service
Other
8. CIHI DAD Patient Service(select only data fields required for this project) Patient Service Days
Patient Service Occurrence
CIHI Patient Service
CIHI Patient Service Location
CIHI Patient Service Type
Other
9. CIHI DAD Provider Service(select only data fields required for this project) Provider Service Occurrence
CIHI Provider Service
CIHI Provider Type
Provider
Other
10. CIHI Hospital Harm(select only data fields required for this project) A01 (Anemia - hemorrhage)
A02 (Obstetric hemorrhage)
A03 (Obstetric trauma)
A04 (Birth trauma)
A05 (Delirium)
A06 (Venous thromboembolism)
A07 (Altered blood glucose level with complications)
A08 (Pressure Ulcer)
A09 (Electrolyte and Fluid Imbalance)
A10 (Medication Incidents)
A11 (Infusion, transfusion and injection complications)
B12 (Urinary tract infections)
B13 (Post-procedural infections)
B14 (Gastroenteritis)
B15 (Pneumonia)
B16 (Aspiration Pneumonia)
B17 (Sepsis)
B18 (Infections due to Clostridium Difficile, MRSA or VRE)
C19 (Patient trauma)
Category A (Health Care-/Medication-Associated Conditions)
Category B (Health Care-Associated Infections)
Category C (Patient Accidents.)
Category D (Procedure-Associated Conditions)
CIHI Exclusion
D01 (Anemia - hemorrhage)
D02 (Obstetric hemorrhage)
D03 (Obstetric trauma)
D04 (Birth trauma)
D19 (Patient Trauma)
D20 (Device Failure.)
D21 (Laceration/Puncture)
D22 (Pneumothorax.)
D23 (Wound Disruption.)
D24 (Retained Foreign Body)
D25 (Post-Procedural Shock.
D26 (Selected Serious Events
Hospital Harm
Other
11. CIHI Project 340(select only data fields required for this project) Antithrombotic Prescribed
CT MRI Scan
Stroke Unit Admission
Thrombolysis Therapy
AntiThrombo Admin Date
AntiThrombo Admin Time
Stroke Symptoms Date
Stroke Symptoms Time
Other
If "Other" was selected in any of the hospital inpatient checklists above, please list and describe the additional hospital inpatient data fields you require.
The Ambulatory Care Checklist. (Note: Day surgery is included in Acute Care Hospital data, not Ambulatory data) DataRequest@VIHA.ca Ambulatory Care - Endoscopy(select only the data fields required for this project) ENDOSCOPY_PRIORITY
ENDOSCOPY_PROCEDURE
ENDOSCOPY_REQUEST
ENDOSCOPY_STATUS
ENDOSCOPY_SURGEON_PROVIDER
ENDOSCOPY_WAIT_LIST_STATUS
ENDO_Consults_Completed
ENDO_Procedures_Completed
CompletedCases
CompletedCases_1
CompletedCases_2
CompletedCases_2_
CompletedCases_addition
Navigatorlist_2018
WaitList
Other
If "Other" was selected for Ambulatory data, please list and describe the additional Ambulatory data elements required for this project.
There is currently no data dictionary for Blood Bank data.DataRequest@VIHA.ca Blood Bank (Transfusions)(select only the data fields required for this project) Clinical indication entered on order
Current expiry date
Current expiry time
Dispense date
Dispense time
Dispense reason
Dispense to location
Dispose date
Dispose reason
Dispose time
Event date
Event time
Final disposition
Inventory area
Inventory area at dispense
Inventory area at dispose
Order catalog
Order product measurement
Presumed transfuse date
Presumed transfuse time
Product
Quantity with units ordered
Other
If "Other" was selected for Blood Bank data, please list and describe the additional Blood Bank data elements required for this project.
The Encounters data Checklist is divided into 5 sections.Encounters Data Dictionary (wait for the app; it takes a minute to load) DataRequest@VIHA.ca 1. Encounter(select only the data fields required for this project) Acute Days to Date
Admit via ER Count
Admit via ER Under 10 Hour Count
ALC Days to Date
ALC Flag
Ambulatory Visit Count
BI DW Update Date Time
Cancelled Encounter Count
Day Care Visit Count
Death During Encounter Count
Emergency Visit Count
ENCNTR ID
Encounter Days to Date
Hours to Inpatient Bed Value
Inpatient Admit Count
Inpatient Direct Admit Count
Inpatient Discharge Count
Inpatient Preadmit Count
Inpatient Separation Count
LOS Days at Discharge
Other Visit Count
Total Days To Date
Went to ALC Count
Admit Age
Admit Date
Admit Location
Admit Location Functional Centre
Admit Location GL Organization
Admit Patient Service
Admit Provider
Admit Source
Admit Time
ADT Reason for Visit
Attending Provider
Consulting 1 Provider
Consulting 2 Provider
Consulting 3 Provider
Day Care Date
Day Care Time
Discharge Age
Discharge Date
Discharge Disposition
Discharge Location
Discharge Location Functional Centre
Discharge Location GL Organization
Discharge Time
Encounter
Encounter Status
Encounter Type
ER Encounter
First Inpatient Bed Date
First Inpatient Bed Functional Centre
First Inpatient Bed GL Organization
First Inpatient Bed Time
First Inpatient Location
Gender
Inpatient Admit Date
Inpatient Admit Time
Latest Location
Pastoral Care
Patient
Patient Flags
Patient Home Geography D
Patient Service
Primary Care Provider
Other
2. Addiction Medicine Consult Service (AMCS) Encounter(select only the data fields required for this project) admit type desc
building
Cancelled Encounter Count
ENCNTR ID M
Encounter Days to Date
Facility
Latest Unit Key
Occurred Status
personnel type
Physician Name
Unit
Admit Age
Admit Date
Admit Patient Service
Admit Source
Admit Time
ADT Reason for Visit
Consulting 1 Provider
Consulting 2 Provider
Consulting 3 Provider
Discharge Date
Discharge Time
Encounter
Encounter Status
Gender
Patient
Patient Home Geography
Other
3. Encounter Bed Census(select only the data fields required for this project) Acute Days to Date
ALC Days to Date
ALC Flag
Bed Census Date
Bed Census Time
Bed Count
ENCNTR ID
Encounter Event Sequence Number
LOS to Date Days
Same Day Discharge Flag
Encounter
Encounter Type
Functional Centre
GL Organization
Location
Most Responsible Provider
Patient
Patient Service
Other
4. Emergency Encounter(select only the data fields required for this project) ADMITTED INPATIENT SAME FACILITY COUNT
cde ARO
cde Chickenpox
cde Community Outbreak
cde Hepatitus M
cde HIV
cde Measles
cde Meningitis
cde Mumps
cde None
cde Other
cde Pertussis
cde Recent Travel
cde TB
DW Update Date Time
ENCNTR ID
ER Inpatient Time Minutes
ER Location Total LOS Minutes
ER Patient Time Minutes
ER Readmit Hours
ER Recidivism Hours
Inpatient Discharge from ER
Inpatient Encntr ID
ir Diarrhea
ir Fever
ir Known ARO
ir New or worsening cough
ir No Infection risk identified
ir Open or draining wound
ir Rash
ir Recent Hospitalization
ir Unable to assess patient for risk
Left ED Within 10 Hours
Left Emergency without Being Seen by ERP
NOT ADMITTED AS INPATIENT COUNT
NOT ADMITTED MET P4P BENCHMARK COUNT
pc Contact
pc Droplet
pc Routine
Placed in IP Bed within 10 Hours Admit
Placed in IP Bed within 10 Hours Triage M
SAW ERP WITHIN CTAS BENCHMARK COUNT
Source System
Triage to ERP Minutes
Admit Provider
Admit Source
Age
Attending Provider
CEDIS Presenting Complaint
Consulting 1 Provider
Consulting 2 Provider
Consulting 3 Provider
Discharge ADT Reason for Visit
Discharge Disposition
Encounter
ER Accompanied By
ER Admit Mode
ER ADT Reason for Visit
ER Discharge Date
ER Discharge Time
ER Doctor Assessment Date
ER Doctor Assessment Provider
ER Doctor Assessment Time
ER INDICATOR FLAGS
ER Nurse Assessment Date
ER Nurse Assessment Time
ER Registration Date
ER Registration Time D
ER Service
ER Streaming
ER Triage Acuity Level
ER Triage Date D
ER Triage Time
ER Visit Location
ER Visit Type
Gender
Inpatient Admit Date
Inpatient Admit Time
Inpatient Encounter
Left ER Ambulatory Location Date
Left ER Ambulatory Location Time
Patient
Patient Flags
Patient Home Geography
Primary Care Provider
Other
5. Encounter Event(select only the data fields required for this project) Acute Days to Date
ALC Days to Date
ALC Flag
Bed Census Flag
Bed Transfer Flag
BI DW Update Date Time
ENCNTR ID
Encounter Type Change Flag
Most Responsible Provider Change Flag
Patient Service Change Flag
Sequence Number
Site Transfer Flag
Unit Transfer Flag
Went off ALC Flag
Went to ALC Flag
Age
Encounter
Encounter Event Type
Encounter Status
Encounter Type
End Event Date
End Event Time
Event Date
Event Time
From Location
Functional Centre
Gender
GL Organization
Location
Most Responsible Provider
Patient Service
Previous Encounter Type
Previous Most Responsible Provider
Previous Patient Service
Other
If "Other" was selected in any of the Encounter check lists above, please list and describe the additional Encounter data elements required for this project.
The Community Health Services (CHS) data Checklist is divided into 5 sections.CHS Data Dictionary (wait for the app; it takes a minute to load) DataRequest@VIHA.ca 1. Community Health Services (CHS) Facility Encounter(select only the data fields required for this project) Authorized Hours
Billing Service Day Counter
Calculated Hours
Home Support Service Days
Home Support Service Hours
In Person visits
ref id
remote visits
Service Day Counter
total visits
Admit Date
Age at Admit
Age at Discharge
Age at Service
Client Group
CLIENT RATE
date accepted for service
date case opened reopened
Discharge Date
Discharge Disposition
Encounter Type
Facility Encounters Flag
HCS TEAM
IH Encounter Number
INVOLVED PROF Group
Location
Patient Service
Rate Effective Date
Rate End
Rate Start
Service Date
Temp Client Rate
Temp Rate Effective Date
Temp Rate End
Temp Rate Start
Other
2. HCC Home Care (HC) Scheduling Clients(select only the data fields required for this project) Total Clients Registered
Total Clients Serviced
Total Days of Service
Total Hours of Service
Total Private Days of Service
Total Private Hours of Service
Total Private Visits
Total Regular Days of Service
Total Regular Hours of Service
Total Regular Visits
Total Short Term Days of Service
Total Short Term Hours of Service
Total Short Term Visits
Total Visits
Age
Gender
GL Organization
HCC HS Client Home Geography
HCC HS Department Status
HCC HS Funders
HCC HS GL Accounting Period
HCC HS Provider Geography
HCC HS Service Date
HCC Provider
Other
3. HCC Home Support (HS) Scheduling Days(select only the data fields required for this project) 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
Expired Flag
Gender
GL Organization
HCC ADL LF Group
HCC ADL SP Group
HCC AS CPS Group
HCC HS Client
HCC HS Client Home Geography
HCC HS Department Status
HCC HS Funders
HCC HS GL Accounting Period
HCC HS Provider Geography
HCC HS Service Date
HCC HS Service Time
HCC IADL DS Group
HCC IADL INV Group
HCC Provider
Marital Status
Other
4. HCC Home Support (HS) Scheduling Visits(select only the data fields required for this project) 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
Expired Flag
Gender
GL Organization
HCC ADL LF Group
HCC ADL SP Group
HCC AS CPS Group
HCC HS Client
HCC HS Client Care Activity
HCC HS Client Home Geography
HCC HS Department Status
HCC HS Funders
HCC HS GL Accounting Period
HCC HS Provider Geography
HCC HS Service Date
HCC HS Service Time
HCC IADL DS Group
HCC IADL INV Group
HCC Provider
Marital Status
Other
5. Home Care Services (HCS) - Referrals(select only the data fields required for this project) ADP Service Days
DAYS WAITING MET PRIORITY NUMERATOR
DAYS WAITING NUMBER
HS Service Days
Length of Referral Duration
Length of Service Duration
Service End Delay
Total Service Days
Visit Service Days
ADP Service Days
Age at referral Closed
Age at Referred on
Case Opened Reopened Date
DAYS WAITING NUMBER (Dim)
HCS REFERRAL COMMON ONE
HCS REFERRAL COMMON TWO
HCS REFERRAL TREATMENT REASON
HCS TEAM
HS Service Days (Dim)
INVOLVED PROF
Involved Prof Group
Length of Referral Duration (Dim)
Length of Service Duration (Dim)
Received At Time
Received On Date
REFERRAL CLOSED DATE
REFERRED ON DATE
Other
6. Home Care Services (HCS) - Services(select only the data fields required for this project) ADP DAYS
HCS Authorized Hours
HCS DAYS
HCS HOURS
HCS SERVICES Fact Key
Home Care InPerson Duration
Home Care InPerson Visits
Home Care PRIOMET Duration
Home Care PRIOMET Visits
Home Care Remote Duration
Home care Remote Visits
Home Care Total Duration
Home Care Total Visits
HOME SUPPORT CALC HOURS
ACCEPTED SERVICE Date
ADP Provider
Age at referral Closed
Age at Referred on
Age at Service
Case Opened Reopened Date
Client Rate
HCS REFERRAL COMMON ONE
HCS REFERRAL COMMON TWO
HCS REFERRAL TREATMENT REASON
HCS TEAM
HCS TEAM Visit
INVOLVED PROF
Involved Prof Group
LOCATION
Rate End Date
Rate Start Date
REFERRAL CLOSED DATE
REFERRED ON DATE
SERVICE Date
SERVICE END Date
SERVICE START Date
Visit Time
Other
7. Home Care Reporting System (HCRS) including RAI-HC(select only the data fields required for this project) Assessment ID
A1 Assessment Reference Date
Assessment Authorized Date
Assessment Complete Date
cc1 case opened reopened date
CLIENT AGE AT ASSESSMENT
HCRS ASSESSMENT ADL Scales Results
HCRS ASSESSMENT B1a to B3b
HCRS ASSESSMENT BB5b to BB8k
HCRS ASSESSMENT C1 to D3
HCRS ASSESSMENT CC
HCRS ASSESSMENT CHESS CPS DRS Scales Results
HCRS ASSESSMENT Cognitive Social Caps
HCRS ASSESSMENT E1 to E2
HCRS ASSESSMENT E3 to F3
HCRS ASSESSMENT G1
HCRS ASSESSMENT G2 to G3
HCRS ASSESSMENT H1aA to H1fA
HCRS ASSESSMENT H1gA to H1gB
HCRS ASSESSMENT H2a to H2e
HCRS ASSESSMENT H2f to H2j
HCRS ASSESSMENT H3 to H7
HCRS ASSESSMENT I
HCRS ASSESSMENT IADL Scales Results
HCRS ASSESSMENT J1a to J1m
HCRS ASSESSMENT J1n to J1ac
HCRS ASSESSMENT J2
HCRS ASSESSMENT K1 to K3
HCRS ASSESSMENT K4 to K7
HCRS ASSESSMENT K8 to K9
HCRS ASSESSMENT L1 to N3
HCRS ASSESSMENT MISC
HCRS ASSESSMENT N4 to O2
HCRS ASSESSMENT P1aA to P1jA
HCRS ASSESSMENT P1aB to P1eB
HCRS ASSESSMENT P1fB to P1jC
HCRS ASSESSMENT P2
HCRS ASSESSMENT P3 to P7
HCRS ASSESSMENT PAIN PURS DIVERT MAPLE RUGIII Scales Results
HCRS ASSESSMENT Physcial Conditions Caps
HCRS ASSESSMENT Physical Caps
HCRS ASSESSMENT Q
HCS Client
HCS TEAM
LOCATION
R1c Assessment Signoff Date
VALIDATION RULE GROUP
Other
If "Other" was selected for Community Health data, please list and describe the additional Community Health data elements required for this project.
The Infection Prevention & Control (IPC)- Hand Hygiene Observations data Checklist.CHS Data Dictionary (wait for the app; it takes a minute to load) DataRequest@VIHA.ca Infection Prevention & Control - Hand Washing Audit(select only the data fields required for this project) Audit number
Health care working instance
Auditor
Date
GL organization
Hand hygiene guideline
Hand hygiene moment
Health care worker
Location
Observation
Time
Other
If "Other" was selected for Infection Prevention & Control data, please list and describe the additional Infection Prevention & Control data elements required for this project.
The Laboratory data Checklist is divided into 3 sections.DataRequest@VIHA.ca 1. Laboratory Test Results(select only the data fields required for this project) Encounter ID
Encounter number
Encounter type
Accession number
Patient sex
patient age at test
Date of Test
facility
DTA_mnemonic (discrete task assay i.e. test method)
Test ordered
STL simple
STL results
CYTO results
NAT results
Overall result
Discrepancy analysis
DTA result
Other
2. Lab Order turn-around-time(select only the data fields required for this project) Order after Lab Receive Ind
Order Catalog
Activity Subtype
Order Provider
Order Enter Provider
Order Enter Date
Order Enter Time
Encounter Type at Order Entry
Collection Priority
Specimen Type
Dispatch Date
Dispatch Time
Collect Date
Collect Time
Patient Location at Collect
Encounter Type at Collect
Collect Provider
Lab Receive Date
Lab Receive Time
Transit Date
Transit Time
Transit From Login
InLab Test Date
InLab Test Time
InLab Test Login
Order Complete Date
Order Complete Time
InLab Test Resource Location
Other
3. Lab Discrete Task Assay (DTA) turn-around-timeNote: One lab order may include many lab tests. Each test is called a Discrete Task Assay or DTA. (select only the data fields required for this project) Required_Ind
Reportable_Ind
DW Seq ID
Order Catalog
Task Assay
Activity Subtype
Result Status
Order Provider
Order Enter Provider
Order Enter Date
Order Enter Time
Patient Location at Order Entry
Encounter Type at Order Entry
Collection Priority
Reporting Priority
Dispatch Time
Collect Date
Collect Time
Patient Location at Collect
Encounter Type at Collect
Lab Receive Date
Lab Receive Time
Transit Date
Transit Time
Transit From Login
InLab Test Date
InLab Test Time
InLab Test Login
Verified Provider
Verified Date
Verified Time
InLab Test Resource Location
Other
If "Other" was selected in any of the above Lab data checklists, please list and describe the additional Lab data field you require that are not in the above checklists. The Long Term Care (LTC)/Residential care data Checklist is divided into 3 sections.LTC Data Dictionary (wait for the app; it takes a minute to load) DataRequest@VIHA.ca to request the information you need. 1. Long Term Care: Continuing Care Reporting System (CCRS)(select only the data fields required for this project) ADL01 LATE LOSS FUNCTIONING WORSENED NGQI DEN
ADL01 LATE LOSS FUNCTIONING WORSENED NGQI NUM
ADL05 MID LOSS FUNCTIONING IMPROVED OR INDEPENDENT NGQI DEN
ADL05 MID LOSS FUNCTIONING IMPROVED OR INDEPENDENT NGQI
NUM
ADL06 EARLY LOSS FUNCTIONING IMPROVED OR INDEPENDENT NGQI
DEN
ADL06 EARLY LOSS FUNCTIONING IMPROVED OR INDEPENDENT NGQI
NUM
ADL1A LATE LOSS ADL FUNCTIONING IMPROVED DEN
ADL1A LATE LOSS ADL FUNCTIONING IMPROVED NUM
ADL5A MID LOSS ADL FUNCTIONING WORSENED OR COMPLETELY
DEPENDENT DEN
ADL5A MID LOSS ADL FUNCTIONING WORSENED OR COMPLETELY
DEPENDENT NUM
ADL6A EARLY LOSS ADL FUNCTIONING WORSENED OR COMPLETELY
DEPENDENT DEN
ADL6A EARLY LOSS ADL FUNCTIONING WORSENED OR COMPLETELY
DEPENDENT NUM
ADLD7 ADL SELF PERFORMANCE WORSENED DEN
ADLD7 ADL SELF PERFORMANCE WORSENED NUM
ANTIANXIETY HYPNOTIC DRUG USE QI DEN
ANTIANXIETY HYPNOTIC DRUG USE QI NUM
BEHAVIOURAL SYMPTOMS AFFECTING OTHERS QI NUM
BEHD4 BEHAVIOURAL SYMPTOMS WORSENED DEN
BEHD4 BEHAVIOURAL SYMPTOMS WORSENED NUM
BEHI4 BEHAVIOURAL SYMPTOMS IMPROVED DEN
BEHI4 BEHAVIOURAL SYMPTOMS IMPROVED NUM
CAT02 INDWELLING CATHETERS DEN
CAT02 INDWELLING CATHETERS NUM
CCRS CONTINUING CARE REPORTING SYSTEM FACT KEY
CNT02 BOWEL CONTINENCE WORSENED DEN
CNT02 BOWEL CONTINENCE WORSENED NUM
CNT03 BLADDER CONTINENCE WORSENED DEN
CNT03 BLADDER CONTINENCE WORSENED NUM
CNT04 URINARY TRACT INFECTION DEN
CNT04 URINARY TRACT INFECTION NUM
CNT2A BOWEL CONTINENCE IMPROVED DEN
CNT2A BOWEL CONTINENCE IMPROVED NUM
CNT3A BLADDER CONTINENCE IMPROVED DEN
CNT3A BLADDER CONTINENCE IMPROVED NUM
COG01 COGNITIVE ABILITY WORSENED DEN
COG01 COGNITIVE ABILITY WORSENED NUM
COG1A COGNITIVE ABILITY IMPROVED DEN
COG1A COGNITIVE ABILITY IMPROVED NUM
COM01 ABILITY TO COMMUNICATE WORSENED DEN
COM01 ABILITY TO COMMUNICATE WORSENED NUM
COM1A ABILITY TO COMMUNICATE IMPROVED DEN
COM1A ABILITY TO COMMUNICATE IMPROVED NUM
COMBINED QUALITY INDICATOR DEN
CONTINUING CARE REPORTING SYSTEM SUM COUNTER
DELOX SYMPTOMS OF DELIRIUM DEN
DELOX SYMPTOMS OF DELIRIUM NUM
DRG01 ANTIPSYCHOTICS WITHOUT DIAGNOSIS DEN
DRG01 ANTIPSYCHOTICS WITHOUT DIAGNOSIS NUM
FAL02 FELL LAST 30 DAYS DEN M
FAL02 FELL LAST 30 DAYS NUM
INCIDENCE OF COGNITIVE IMPAIRMENT QI DEN
INCIDENCE OF COGNITIVE IMPAIRMENT QI NUM
INCIDENCE OF DECLINE IN LATE LOSS ADL QI DEN
INCIDENCE OF DECLINE IN LATE LOSS ADL QI NUM
INCIDENCE OF DECLINE IN RANGE OF MOTION QI DEN
INCIDENCE OF DECLINE IN RANGE OF MOTION QI NUM
INCIDENCE OF NEW FRACTURES QI DEN
INCIDENCE OF NEW FRACTURES QI NUM
INF0X ONE OR MORE INFECTIONS DEN
INF0X ONE OR MORE INFECTIONS NUM
MOB01 ABILITY TO LOCOMOTE WORSENED DEN
MOB01 ABILITY TO LOCOMOTE WORSENED NUM
MOB1A ABILITY TO LOCOMOTE IMPROVED DEN
MOB1A ABILITY TO LOCOMOTE IMPROVED NUM
MOD4A MOOD SYMPTOMS OF DEPRESSION WORSENED DEN
MOD4A MOOD SYMPTOMS OF DEPRESSION WORSENED NUM
NUT01 FEEDING TUBE DEN
NUT01 FEEDING TUBE NUM
PAI0X WITH PAIN DEN
PAI0X WITH PAIN NUM
PAN01 PAIN WORSENED DEN
PAN01 PAIN WORSENED NUM
PREVALENCE OF ANTISCHOTIC DRUGUSE ABSENT CONDITIONS QI DEN
PREVALENCE OF ANTISCHOTIC DRUGUSE ABSENT CONDITIONS QI NUM
PREVALENCE OF BEDFAST RESIDENTS QI NUM
PREVALENCE OF BLADDER BOWEL INCON QI DEN
PREVALENCE OF BLADDER BOWEL INCON QI NUM
PREVALENCE OF BLADDER BOWEL NOPLAN QI DEN
PREVALENCE OF BLADDER BOWEL NOPLAN QI NUM
PREVALENCE OF DAILY PHYSICAL RESTRAINTS QI NUM
PREVALENCE OF DEHYDRATION QI NUM
PREVALENCE OF DEPRESSION NO THERAPY QI NUM
PREVALENCE OF DEPRESSION SYMPTOMS QI NUM
PREVALENCE OF FALLS QI NUM
PREVALENCE OF FECAL IMPACTION QI NUM
PREVALENCE OF HYPNOTIC DRUG USE TWICE WEEKLY QI NUM
PREVALENCE OF INDWELLING CATHETERS QI NUM
PREVALENCE OF LITTLE OR NO ACTIVITY QI DEN
PREVALENCE OF LITTLE OR NO ACTIVITY QI NUM
PREVALENCE OF STAGE 1TO4 PRESSURE ULCERS QI NUM
PREVALENCE OF TUBE FEEDING QI NUM
PREVALENCE OF URINARY TRACT INF QI NUM
PREVALENCE OF WEIGHT LOSS QI DEN
PREVALENCE OF WEIGHT LOSS QI NUM
PRU05 STAGE 2 TO 4 PRESSURE ULCER DEN
PRU05 STAGE 2 TO 4 PRESSURE ULCER NUM
PRU06 STAGE 2 TO 4 PRESSURE ULCER WORSENED DEN
PRU06 STAGE 2 TO 4 PRESSURE ULCER WORSENED NUM
PRU09 NEW STAGE 2 TO 4 PRESSURE ULCER DEN
PRU09 NEW STAGE 2 TO 4 PRESSURE ULCER NUM
RES01 DAILY PHYSICAL RESTRAINTS DEN
RES01 DAILY PHYSICAL RESTRAINTS NUM
RSPX2 DEVELOPED RESPIRATORY CONDITION OR NOT BETTER DEN
RSPX2 DEVELOPED RESPIRATORY CONDITION OR NOT BETTER NUM
USE OF NINE OR MORE MEDS QI NUM
VALIDATION RULE GROUP KEY
WGT01 UNEXPLAINED WEIGHT LOSS DEN
WGT01 UNEXPLAINED WEIGHT LOSS NUM
Admission Date
Age
ASSESSMENT REASON
Assessment Reference Date
CCRS Actvts FdTb CAPS
CCRS ADL CAP
CCRS ADL FUNCTIONAL REHAB POTENTIAL RAP
CCRS ADL Self Performance Worsened
CCRS AGGRESSIVE BEHAVIOUR
CCRS AntpsychNDgnsPsych FllLst30Dys OnOrMrInf AbltyLcmtIWrs
AbltyLcmtImp
CCRS AprprtMdctns CrdRsprtrCndtns CAPS
CCRS ASSESSMENT E4 to F2
CCRS ASSESSMENT G1
CCRS ASSESSMENT G4 to J3
CCRS ASSESSMENT K1 to M6
CCRS ASSESSMENT O2 to P1
CCRS ASSESSMENT P3 to P8
CCRS BEHAVIOUR CAP
CCRS BEHAVIOURAL SYMPTOMS RAP
CCRS BlddrBwlIncntnc BlddrBwlIncntncNPln IndwllngCthtrs
CCRS BOWEL CONDITION CAP
CCRS CgntvAbltyWrsnd CgntvAbltyImp AbltyCmmnctWrsnd
AbltyCmmnctImp
CCRS CHESS SCALE
CCRS Cmmnctn CgntvLssDmnt PhysclRstrnts RAP
CCRS COGNITIVE LOSS CAP
CCRS COGNITIVE PERFORMANCE AND PAIN SCALES
CCRS COMBINED ADL INDICATOR
CCRS DEHYDRATION CAP
CCRS DELIRIUM CAP
CCRS DhydrtnFldMntnc FdTbs NtrtnlSts Actvts RAP
CCRS DRS ISE SCALES
CCRS ErlyLssFnctnngImp ErlyLssFnctnngWrsnd
CCRS FALLS PAIN CAPS
CCRS FALLS RAP
CCRS FclImp UrnTrcInf TbFd Dhyd PrsUlc
CCRS IncdncDclnLtLssADL D
CCRS IncdncDclnRngMtn
CCRS IndwllngCthtrs UrnryTrctInf BwlCntnc BlddrCntnc
CCRS LtLssFnctnngImp LtLssFnctnngWrsnd
CCRS MdLssFnctnngImp MdLssFnctnngWrsnd
CCRS Mood State RAP
CCRS PERSONAL SEVERITY INDEX SCALE
CCRS PhysclRstrnts Cmnctn SclRltnshps CAPS
CCRS PRESSURE ULCER CAP
CCRS PRESSURE ULCER RISK SCALE
CCRS PRESSURE ULCERS RAP
CCRS PrvAntAnxHypnDrgs Prv9rMrMds PrvHypntcDrgUs2Dys QI
CCRS PrvBhvrlSymptmsAfctOthrs PrvAntPsychtcDrgUsAbsntCndtns
IncCgntvImprmnt QI
CCRS PrvFlls IncNwFrc PrvBdFst PrvDlyPhysRst PrvLtlNActvty QIS
CCRS PrvSymptmsDprssn PrvDprssnWthtThrpy PrvWghtLss
CCRS PschtrpcDgUs Dlrm RAP
CCRS Psychosocial Well Being RAP
CCRS RsdntsWthPn RsdntsWhsPnWrsnd RsdntsWthFdngTb
MdDprssnWrsnd
CCRS RsdnWhsBhvrlSymptmsImp RsdnWhsBhvrlSymptmsWrsnd
CCRS Stg2t4PrssrUlcr DlyPhsclRstrnts RsprtryCndtn UnxplndWghtLss
CCRS Symptoms of Delirium
CCRS UNDERNUTRITION CAP
CCRS URINARY INCONTINENCE CAP
CCRS UrnryIncntnc DntCr VslFnctn RAP
DISEASE DIAGNOSES GROUP
Facility
HCS Client
ICD10 DISEASE DIAGNOSES GROUP
Infection GROUP
PROBLEM CONDITION GROUP
Special Treatment GROUP
Other
2. Long Term Care (Residential Care) Facility Encounters(select only the data fields required for this project) Acceptance Wait Duration
ENCNTR ID
HCS Facility Encounters Fact Key
ref id
Service Wait Duration
Stay Duration
Admit Date
Age at Admit
Age at Discharge
date accepted for service
date case opened reopened
Discharge Date
Discharge Disposition
Encounter Type
Facility Encounters Flag
HCS TEAM
IH Encounter Number
INVOLVED PROF Group
Location
Patient Service
Other
3. Long Term Care (Residential Care) Placements(select only the data fields required for this project) Admission Notice ID
Days Delayed
Days Waited
ID
Missing Acute Date
Preferred Area
Type For Reporting
Within 30 Days
Within 60 Days
Within 90 Days
Acute Date
Admission Date
Admission Service Provider
Admission Type
Assessed Approved Date
Awaiting Transfer Date
Care Type
Creation Date
Source Service Provider
Transfer Confirmed Date
Other
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 data - There is currently no data dictionary for these data. If you require information about this dataset, please send a note to DataRequest@viha.ca Medical Imaging (MI)(select only the data fields required for this project) MI accession class
MI benchmarks
MI cancel reasons
MI dictation date
MI encounter type
MI exam complete date
MI exam complete time
MI exam room location
MI exam scheduling priority
MI final date
MI final time
MI order catalog
MI order physician provider
MI order staff provider
MI ordered date
MI ordered time
MI primary staff provider
MI PT exam complete location
MI radiologist provider
MI request date
MI request time
MI scheduled confirmed date
MI scheduled confirmed time
MI scheduled date
MI scheduled time
MI section location
MI start date
MI start time
MI transcribed date
MI transcribed time
Other
If "Other" was selected in the Medical Imaging checklist above, please list and describe the additional Medical Imaging data elements required for this project.
The Mental Health & Substance Use (MHSU) data Checklist is divided into 9 sections (below).DataRequest@VIHA.ca 1. MHSU Administrative Elements(select only the data fields required for this project) A1 Record Type
A2 Last Update Date
A3 Delete Flag
2. MHSU Header Data Elements(select only the data fields required for this project) H1 HA Number Unique identifier assigned by MoH to an organization
H2 HA Extract Date
H3 Reporting Period in which information was collected or services provided
H4 Fiscal Year
3. MHSU Client Data Elements(select only the data fields required for this project) C1 HA Client Number
C2 PHN
C3 City
C4 Home Province, State, Other Country
C5 Postal Code
C6 Birth Date
C7 Sex Code
C8 Marital Status
C9 Height
C10Weight
C11 Household Composition
C12 Aboriginal Identity Indicator
C13 Aboriginal Identity Group
C14 First Nations Status Indicator
C15 First Nations On Reserve Indicator
C16 Highest Level of Education Completed
C17 Current Educational Engagement
C18 Employment Status Declaration
C19 Employment Hours
C20 WCB, Sickness or Disability Flag
C21 Duration of WCB, Sickness or Disability
C22 Criminal Justice Involvement
C23 Nature of Criminal Justice Involvement
C24 Legal Status First Field
C25 Legal Status Second Field
C26 Estimated Age
C27 History of Suicide Attempts
C28 History of Violence
C29 Age of First Use of Alcohol
C30 Age of First Use of Tobacco
C31 Age of First Use of Marijuana
C32 Age of First Use of Any Other Substance
4. MHSU Service Episode Record(select only the data fields required for this project) S1 HA Service Episode Key
S2 Continuum of MHSU Services
S3 Referral Source
S4 Referral Date
S5 Date of First Contact
S6 Date of First Service Event
S7 Date of First Service Event in Reporting Period
S8 Date of Last Service Event in Reporting Period
S9 Number of Service Events in Reporting Period
S10 Living Arrangement
S11 Acute Inpatient - Secure Room
S12 Acute Inpatient - Transport
S13 MHSU Affected Relationship
S14 Service Agency Location Code
S15 Type of CBT Intervention
S16 Type of DBT Intervention
S17 Date Extended Leave Ends
S18 Date of Discharge from Service
S19 Reason for End of Service
S20 Date of Hospital to Community Contact
S21 Reason for No Community Follow up Contact
S22 Pregnancy
S23 Parenting
S24 Suicide Attempt
S25 Violence
S26 Peer Support Service
S27 Fetal Alcohol Spectrum Disorder
5. MHSU Service Event Record(select only the data fields required for this project) T1 HA Service Event Key
T2 Date and Time of Service Event
6. MHSU DSM-5 Diagnostic Record (Diagnostic5) (select only the data fields required for this project) D1 Date of Diagnostic Assessment at Enrolment
D2 Clinician's Impression at Enrolment
D3 DSM-5 Diagnosis at Enrollment 1 (Primary)
D4 DSM-5 Diagnosis at Enrollment 2 (Secondary)
D5 DSM-5 Diagnosis at Enrollment 3 (Tertiary)
D6 DSM-5 Diagnosis at Enrollment 4 (Quaternary)
D7 DSM-5 Diagnosis at Enrollment 5 (Quinary)
D8 Date of Diagnostic Assessment at Discontinuation
D9 Clinician's Impression at Discontinuation
D10 DSM-5 Diagnosis at Discontinuation 1 (Primary)
D11 DSM-5 Diagnosis at Discontinuation 2 (Secondary)
D12 DSM-5 Diagnosis at Discontinuation 3 (Tertiary)
D13 DSM-5 Diagnosis at Discontinuation 4 (Quaternary)
D14 DSM-5 Diagnosis at Discontinuation 5 (Quinary)
7. MHSU DSM-IV-TR Diagnostic Record (Diagnostic)(select only the data fields required for this project) D1 Date of Diagnostic Assessment at Enrolment
D2 Clinician's Impression at Enrolment
D3 Diagnosis Axis 5: GAF Score at Enrolment or Service
D4 Diagnosis Axis 5: GAF Score at Discontinuation
D5 DSM-IV-TR Diagnosis Axis 1: Primary or First at Discontinuation
D6 DSM-IV-TR Diagnosis Axis 1: Primary or First at Discontinuation
D7 Initial DSM-IV-TR Diagnosis Axis 1: Second or Secondary at Enrolment
D8 DSM-IV-TR Diagnosis Axis 1: Second or Secondary at Discontinuation
D9 Initial DSM-IV-TR Diagnosis Axis 1: Other at Enrolment
D10 DSM-IV-TR Diagnosis Axis 1: Other at Discontinuation
D11 Initial DSM-IV-TR Diagnosis Axis 2: Primary or First at Enrolment
D12 DSM-IV-TR Diagnosis Axis 2: Primary or First at Discontinuation
D13 Initial DSM-IV-TR Diagnosis Axis 2: Second or Secondary at Enrolment
D14 DSM-IV-TR Diagnosis Axis 2: Second or Secondary at Discontinuation
D15 Clinician's Impression
8. MHSU Health of the Nations Outcome Scale (HoNOS)(select only the data fields required for this project) N1 HA HoNOS Record Key
N2 Date of HoNOS Assessment
N3 HoNOS Problems with Overactive, Aggressive, Disruptive, Agitated or Antisocial Behaviour
N4 HoNOS Non Accidental Self Injury
N5 HoNOS Problems Drinking or Drug Taking/Use
N6 HoNOS Cognitive Problems
N7 HoNOS Problems Related to Physical Illness or Disability
N8 HoNOS Problems Associated with Hallucinations, Delusions or Abnormal Perceptions
N9 HoNOS Problems with Depressive Mood
N10 HoNOS Problems with Relationships
N11 HoNOS Problems with Activities of Daily Living
N12 HoNOS Overall Problems with Living Conditions
N13 HoNOS Problems with Occupation / Work and (Leisure) Activities
N14 HoNOS Problems with Over Activity, Attention or Concentration
N15 HoNOS Problems with Scholastic or Language Skills
N16 HoNOS Problems with Non Organic Somatic Symptoms
N17 HoNOS Problems with Emotional and Related Symptoms
N18 HoNOS Problems with Peer Relationships
N19 HoNOS Problems with Self Care and Independence
N20 HoNOS Poor School Attendance
N21 HoNOS Problems with Knowledge or Understanding about the Nature of the Child/Adolescent's Difficulties
N22 HoNOS LD#1 Behavioural Problems Directed at Others
N23 HoNOS LD#2 Behavioural Problems Directed Towards Self (Self Injury)
N24 HoNOS LD#3 Other Mental and Behavioural Problems
N25 HoNOS LD#4 Attention and Concentration
N26 HoNOS LD#5 Memory and Orientation
N27 HoNOS LD#6 Communications (Problems with Understanding)
N28 HoNOS LD#7 Communications (Problems with Expression)
N29 HoNOS LD#8 Problems Associated with Hallucinations and Delusions
N30 HoNOS LD#9 Problems Associated with Mood Changes
N31 HoNOS LD#10 Problems with Sleeping
N32 HoNOS LD#11 Problems with Eating and Drinking
N33 HoNOS LD#12 Physical Problems
N34 HoNOS LD#13 Seizures
N35 HoNOS LD#14 Activities of Daily Living at Home
N36 HoNOS LD#15 Activities of Daily Living Outside the Home
N37 HoNOS LD#16 Level of Self Care
N38 HoNOS LD#17 Problems with Relationships
N39 HoNOS LD#18 Occupation and Activities
N40 Mania
N41 Anxiety Including Obsessions / Compulsions
N42 Filler (was Fetal Alcohol Spectrum Disorder)
N43 Filler (was Obsessions/Compulsions)
N44 Eating Disordered Behaviour
N45 HoNOS Problems with Lack of Information About Services or Management of the Child's / Adolescent's Difficulties
N46 HoNOS Tool
9. MHSU Substance Use Data Elements(select only the data fields required for this project) U1 HA Substance Record Key
U2 Date of Substance Use Assessment
U3 Substance Use
U4 Stage of Change
U5 Average Number of Cigarettes or Drinks in 30 Days Prior to Assessment
U6 Number of Days Drinking or Using Substance in 30 Days Prior to Assessment
U7 Primary Method of Substance Intake
U8 Sharing Needles in 30 Days Prior to Assessment
U9 Source of Substance
U10 Primary Substance Used
If this project requires additional MHSU data elements not listed in the 9 MHSU sections above, please list and describe the additional MHSU data elements required.
Patient-Centred Measurement (PCM) Acute Inpatient Survey 2016-2017: HealthIdeas Toolkit for Data Users Emergency Department 2018: HealthIdeas Toolkit for Data Users Patient-Centred Measurement data(select only the data fields required for this project) one
two
three
four
etc.
If you require Patient-Centred Measurement (PCM) data not found in the PCM checklist above, please list and describe the additional PCM data elements required for this project.
Island Health Pharmacy Data.DataRequest@VIHA.ca Pharmacy(select only the data fields required for this project) PRIMARY_MNEMONIC - Cerner Multum primary drug name. Cerner Multum is a proprietary medication identifier system. A cross-walk between Cerner Multum and more commonly used systems like ATC and DIN is not available in Cerner. Researchers will have to attempt to link systems themselves. See the link for an example: https://www.ncbi.nlm.nih.gov/pmc/articles/PMC5001754/
ADMIN_START_DTTM - Scheduled date and time for first medication administration
ORDER_END_DT_TM - The end date for the current medication order
ORDER_END_STATUS - The reason the order was stopped. Order end (Cancel, Discontinue, Complete order status) Cancel status occurs when the order is ended before the medication is administered. Discontinue status occurs when the order is ended after the medication has been administered at least once
ROUTE - The path by which the medication is taken into the body
DOSE - Amount of medication per administration
FREQUENCY - The schedule of medication administrations
PRN - The physician ordered the medication to be administered as needed
Other
If "Other" was selected for Pharmacy data, please list and describe the additional pharmacy data elements required for this project.
The Surgical data ChecklistSurgical Data Dictionary (wait for the app; it takes a minute to load) DataRequest@VIHA.ca to request the information you need. Surgical Cases(select only the data fields required for this project) Account No
Account No ORSOS
Anesthesis Minutes
Case No CERNER
Case No ORSOS
Cleanup Minutes
Days Out of Window Current
Days Out of Window Scheduled
Encounter Number
Incision Minutes
Patient PARR Minutes
Patient Room Minutes
Pct Out of Window Current
Pct Out of Window Scheduled
Post Case Create Date
Request id
Setup Minutes
SURG CASE ID
SURG CASE NBR FORMATTED
Surg Event Create Date
Surgery Minutes
System ID
Total Unavailable Days
Unadjusted Wait Days Current
Unadjusted Wait Days Decision Current
Unadjusted Wait Days Decision Scheduled
Unadjusted Wait Days Received Current
Unadjusted Wait Days Received Scheduled
Unadjusted Wait Days Scheduled
Unavailable 1 Days
Unavailable 2 Days
Unavailable 3 Days
Wait One Days
Wait Two Days Current
Wait Two Days Decision Current
Wait Two Days Decision Scheduled
Wait Two Days Received Current
Wait Two Days Received Scheduled
Wait Two Days Scheduled
Actual Date
Actual Nursing Unit Location
Actual Operating Room Location
Age at Decision
Age at Surgery
anes ready time
anes start time
Anesthetist
Booked Nursing Unit Location
Booked Operating Room Location
Cancel Date
Data Entry Staff
Decision To Operate Date
First Consult Date
Hip Fracture admit date
Hip Fracture admit time
Incision Close Time
Incision Start Time
Last Postponed Date
Patient Enter PARR Date
Patient Enter PARR Time
Patient Enter Room Date
Patient Enter Room Time
Patient Exit PARR Date
Patient Exit PARR Time
Patient exit room ROOM Date
patient exit room ROOM Time
Position Prep Drape Time
Post Case Surgical Equipment Group
Post Case Surgical Procedure Group
Post Case Surgical Staff Group
Received Date
Referral Request Date
Scheduled Date
Scheduled Time
Stop Date
Stop Time
Surgeon
Surgical Anesthesia Type Group
Surgical Checklist
Surgical Comments
Surgical Completed Flags
Surgical Diagnosis
Surgical Flags
SURGICAL OR DELAY GROUP
Surgical Scheduled Flags
Surgical Status Flags
Unavail 1 End Date
Unavail 1 Reason
Unavail 1 Start Date
Unavail 2 End Date
Unavail 2 Reason
Unavail 2 Start Date
Unavail 3 End Date
Unavail 3 Reason
Unavail 3 Start Date
Wait List Surgeon
Wait List Surgical EQUIPMENT GROUP
Wait List Surgical PROCEDURE GROUP
Wait List Surgical STAFF GROUP
Other
If "Other" was selected in the Surgical Cases checklist above, please list and describe the additional Surgical 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 ( MB)
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
Working...