Site Level Extracts

Resources such as Nurse Managers, Clinical Educators or ED Directors can download eCTAS site level triage data for up to 120 days for their site using the Site Level Extracts feature located in the Administration Console. Each extract request is limited to 120 days of data however the start date for the extract period can be any date within the previous 2 years.

Resources must be assigned the role of Hospital Data Viewer at their site by their Facility Role Administrator to access Site Level Extracts. The extract is generated as a file in comma-separated values (CSV) format.

See the eCTAS Training page for webinar recordings on this feature.

Important: Site Level Extracts contain Personal Health Information (PHI). Follow your hospital's policies for handling and disposing of PHI securely.

Note: For additional eCTAS PHI data that is not available through the Site Level Extract, please send a request via email to eCTASsupport@ontariohealth.ca and include the date range(s) (MM/YY) and hospital site name(s) pertinent to your request.

Data Columns

Most data columns in the Site Level Extract correspond to fields in the eCTAS Clinical Application or your hospital interface, and reflect what was entered or selected by the triage nurse (e.g. vital signs). Other data columns reflect system generated data (e.g. ED Visit Number) or actions that were applied to a triage record via the eCTAS Registration View (e.g. Mark as Triaged in Error). The table below provides a description for each column.

Note: The default format for dates in the Site Level Extract is yyyy-mm-dd.  This allows Excel to unambiguously interpret the date regardless of local date format settings.

Field Name

Data Source

Brief Description

eCTAS ID

System generated (eCTAS)

Unique identifier generated by eCTAS (EpisodeID)

Site

System generated (eCTAS/HIS)

Site name

ED Visit Number

System generated (HIS)

Identifier sent to eCTAS by hospitals that receive patients in their own HIS

Triaged In Error

eCTAS Registration View

Yes/No field to confirm if the patient record has been indicated as 'Triaged in Error' via the eCTAS Registration View

Pre-Triage Time

System generated (eCTAS/HIS)

Time stamp for Pre-Triage completion

Pre-Triage RN

System generated (eCTAS/HIS)

Name of nurse who completed Pre-Triage for the patient

Patient First Name

Nurse input (eCTAS/HIS)

Text entered by nurse

Patient Last Name

Nurse input (eCTAS/HIS)

Text entered by nurse

Health Card Number

Nurse input (eCTAS/HIS)

Text entered by nurse

Date Of Birth

Nurse input (eCTAS/HIS)

Text entered by nurse

Gender

Nurse input (eCTAS/HIS)

Selection made by nurse

Consent Revoked

Nurse input (eCTAS/HIS)

Selection made by nurse

Age

Nurse input (eCTAS/HIS)

Text entered by nurse

Age Unit

Nurse input (eCTAS/HIS)

Selection made by nurse for Paeds patients (i.e. Years or Months)

Cohort

Nurse input (eCTAS/HIS)

Selection made by nurse

Arrival Mode

Nurse input (eCTAS/HIS)

Selection made by nurse

EMS Number

Nurse input (eCTAS/HIS)

Text entered by nurse

EMS Arrival Date Time

Nurse input (eCTAS/HIS)

Text entered by nurse

EMS Offload Date Time

Nurse input (eCTAS/HIS)

Text entered by nurse

Police Badge Number

Nurse input (eCTAS/HIS)

Text entered by nurse

Police Division

Nurse input (eCTAS/HIS)

Text entered by nurse

Screening Status

System generated (eCTAS)

Displays:

  • Unable to Screen if the 'Unable to complete screening...' check box was selected
  • Screened if any Infection Control Screening question was answered for this episode
  • If no ICS questions are answered the field will be blank

Selected Precaution

Nurse input (eCTAS/HIS)

Selection made by nurse

Suspected COVID-19

System generated (eCTAS)

Displays True or False based on responses entered in the COVID screening assessment fields including entering Suspected COVID in the Subjective Notes field

Vaccinated for COVID-19

Nurse input (eCTAS)

Selection made by the nurse

Triage Start Time

System generated (eCTAS/HIS)

Time stamp for Triage Assessment start

Triage End Time

System generated (eCTAS/HIS)

Time stamp for Triage Assessment completion

Triage RN

System generated (eCTAS/HIS)

Name of nurse who completed Triage Assessment for the patient

Patient Stated Complaint

Nurse input (eCTAS/HIS)

Text entered by nurse

Nurse Assessed Complaint

Nurse input (eCTAS/HIS)

Text entered by nurse

CEDIS Complaint

Nurse input (eCTAS/HIS)

Selection made by nurse

eCTAS Calculated Score

System generated (eCTAS)

Final CTAS score calculated by the eCTAS Application based on input from the triaging nurse (i.e. CEDIS complaint selection, vital signs entry and modifier selection/deselection)

WSCert Submitted Score

System generated (HIS)

Final CTAS score submitted to CCO by Web Service and Certification hospitals

Override Score

Nurse input (eCTAS/HIS)

Final CTAS score when an override selection and reason is selected by the nurse

Override Reason

Nurse input (eCTAS/HIS)

One of the five reasons available for nurse override

Modifiers

Nurse input (eCTAS/HIS)

Modifiers triggered by vital sign entry or selected by the nurse. Any deselected modifiers will not be included in this list.

Temperature (C)

Nurse input (eCTAS/HIS)

Text entered by nurse

Pulse Rate (beats/min)

Nurse input (eCTAS/HIS)

Text entered by nurse

Respiratory Rate (breaths/min)

Nurse input (eCTAS/HIS)

Text entered by nurse

Blood Pressure (mm Hg)

Nurse input (eCTAS/HIS)

Text entered by nurse

Blood Pressure 2 (mm Hg)

Nurse input (eCTAS/HIS)

Text entered by nurse

SpO2 (%)

Nurse input (eCTAS/HIS)

Text entered by nurse

Pain Scale

Nurse input (eCTAS/HIS)

Selection made by nurse

Pain Response Status

Nurse input (eCTAS/HIS)

Selection made by nurse

GCS

Nurse input (eCTAS/HIS)

Text entered by nurse

GCS Responses

Nurse input (eCTAS/HIS)

Selection made by nurse

Capillary Refill

Nurse input (eCTAS/HIS)

Selection made by nurse

Blood Glucose (mmol/L)

Nurse input (eCTAS/HIS)

Text entered by nurse

Weight (kg)

Nurse input (eCTAS/HIS)

Text entered by nurse

High MOI

Nurse input (eCTAS/HIS)

Selection made by nurse

Immunocompromised

Nurse input (eCTAS/HIS)

Selection made by nurse

Blood Disorder

Nurse input (eCTAS/HIS)

Selection made by nurse

EMS Notes

Nurse input (eCTAS/HIS)

Text entered by nurse

Subjective Notes

Nurse input (eCTAS/HIS)

Text entered by nurse

Objective Notes

Nurse input (eCTAS/HIS)

Text entered by nurse

Medical History

Nurse input (eCTAS/HIS)

Selection or text entered by a nurse

Medications

Nurse input (eCTAS/HIS)

Selection or text entered by a nurse

Allergies

Nurse input (eCTAS/HIS)

Selection or text entered by a nurse

Treatments and Interventions

Nurse input (eCTAS/HIS)

Selection or text entered by a nurse

Priority in Queue

Nurse input (eCTAS)

Selection made by nurse

Care Location

Nurse input (eCTAS)

Selection made by nurse

Care Instructions

Nurse input (eCTAS)

Text entered by nurse

First Reassessment Time

System generated (eCTAS)

Time stamp for first Re-assessment to occur after the Triage Assessment

Second Reassessment Time

System generated (eCTAS)

Time stamp for second Re-assessment to occur after the Triage Assessment

Third Reassessment Time

System generated (eCTAS)

Time stamp for third Re-assessment to occur after the Triage Assessment

Total Reassessment Count

System generated (eCTAS)

Total number of times a patient has been reassessed. "No Change" to patient condition is considered a reassessment.

Initial TOA Time

System generated (eCTAS/HIS)

Time stamp for the first Transfer of Accountability

Initial TOA Notes

Nurse input (eCTAS/HIS)

Notes entered by the nurse with the first Transfer of Accountability

Initial TOA Is LWBS

Nurse input (eCTAS/HIS)

Selection made by a nurse to indicate the patient left without being seen

Initial TOA RN

System generated (eCTAS/HIS)

Name of the nurse who completed the first Transfer of Accountability

 

 

© 2016-2024 Ontario Health. All rights reserved. Terms of Use.