The triage table
The triage table contains information about the patient when they were first triaged in the emergency department. Patients are assessed at triage by a single care provider and asked a series of questions to assess their current health status. Their vital signs are measured and a level of acuity is assigned. Based on the level of acuity, the patient either waits in the waiting room for later attention, or is prioritized for immediate care.
All fields in triage were originally free-text. For deidentification purposes, the vital sign and pain fields were converted into a numeric value. As a result, a small number of
NULL values were introduced for text entries.
Table source: Emergency department information system.
Number of rows:
- edstays on
- There is no time associated with triage observations. The closest approximation to triage time is the
intimeof the patient from the edstays table.
|Name||Postgres data type|
||INTEGER NOT NULL|
||INTEGER NOT NULL|
subject_id is a unique identifier which specifies an individual patient. Any rows associated with a single
subject_id pertain to the same individual.
An identifier which uniquely identifies a single emergency department stay for a single patient.
The patient’s temperature in degrees Farenheit. Some temperatures may be incorrectly documented as Celsius.
The patient’s heart rate in beats per minute.
The patient’s respiratory rate in breaths per minute.
The patient’s peripheral oxygen saturation as a percentage.
The patient’s systolic and diastolic blood pressure, respectively, measured in millimitres of mercury (mmHg).
The level of pain self-reported by the patient, on a scale of 0-10.
An order of priority based upon acuity utilizing the Emergency Severity Index (ESI) Five Level triage system. This priority is assigned by a registered nurse. Level 1 is the highest priority, while level 5 is the lowest priority. The levels are:
- When Level 1 condition or patient meets ED Trigger Criteria, the triage process stops, the patient is taken directly to a room and immediate physician intervention requested.
- Patient conditions which trigger level 1 include being unresponsive, intubated, apneic, pulseless, requiring a medication/intervention to alter ESI level e.g. narcan/adenosine/cardioversion, trauma, stroke, stemi
- When a Level 2 condition is identified, the triage nurse notifies the resource nurse and appropriate placement will be determined.
- Patient conditions which trigger level 2 include high risk situations, new onset confusion, suicidal/homicidal ideation, lethargy, seizures or disorientation, possible ectopic pregnancy, an immunocompromised patient with a fever, severe pain/distress, or vital sign instability
- Includes patients requiring two or more resources (labs, EKG, x-rays, IV fluids, etc) with stable vital signs
- Patients requiring one resource only (labs, EKG, etc)
- Patients not requiring any resources
A deidentified free-text description of the patient’s chief complaint.
Was this page helpful?
Glad to hear it! Please raise an issue here to tell us how we can improve.
Sorry to hear that. Please raise an issue here to tell us how we can improve.