ventilation-classification

# Ventilation Classification Classifies each ICU charting observation into a ventilation status category and groups consecutive observations into ventilation episodes. This concept is used directly by SOFA (respiratory component requires mechanical ventilation for scores 3-4), OASIS, and many other severity scores and research definitions. ## When to Use This Skill - Determining ventilation type and duration for ICU stays - SOFA respiratory scoring (requires knowing if patient is on invasive mechanical ventilation) - Weaning studies (tracking transitions between ventilation modes) - Respiratory support characterization in cohort studies - Any task requiring classification of oxygen delivery or ventilator data ## Ventilation Categories | Category | Description | Examples | |----------|-------------|---------| | **Tracheostomy** | Patient has a tracheostomy tube | Tracheostomy tube, Trach mask | | **InvasiveVent** | Invasive mechanical ventilation via endotracheal tube or ventilator mode | Endotracheal tube, CMV, SIMV, PRVC/AC, VOL/AC, etc. | | **NonInvasiveVent** | Non-invasive positive pressure ventilation | BiPAP mask, CPAP mask, NIV modes | | **HFNC** | High-flow nasal cannula | High flow nasal cannula | | **SupplementalOxygen** | Low-flow or standard oxygen delivery | Nasal cannula, Non-rebreather, Face tent, Venti mask | | **None** | No supplemental oxygen (room air) | None | ### Classification Priority When multiple indicators are present simultaneously, the classification follows this priority (highest first): 1. **Tracheostomy** — `o2_delivery_device_1` is 'Tracheostomy tube' or 'Trach mask ' 2. **InvasiveVent** — `o2_delivery_device_1` is 'Endotracheal tube' OR any invasive ventilator mode present 3. **NonInvasiveVent** — `o2_delivery_device_1` is 'Bipap mask ' or 'CPAP mask ' OR Hamilton NIV modes 4. **HFNC** — `o2_delivery_device_1` is 'High flow nasal cannula' 5. **SupplementalOxygen** — Other oxygen delivery devices 6. **None** — `o2_delivery_device_1` is 'None' ## Classification Rules ### By Oxygen Delivery Device (`o2_delivery_device_1`) | Device Value | Category | |-------------|----------| | `'Tracheostomy tube'` | Tracheostomy | | `'Trach mask '` | Tracheostomy | | `'Endotracheal tube'` | InvasiveVent | | `'Bipap mask '` | NonInvasiveVent | | `'CPAP mask '` | NonInvasiveVent | | `'High flow nasal cannula'` | HFNC | | `'Non-rebreather'` | SupplementalOxygen | | `'Face tent'` | SupplementalOxygen | | `'Aerosol-cool'` | SupplementalOxygen | | `'Venti mask '` | SupplementalOxygen | | `'Medium conc mask '` | SupplementalOxygen | | `'Ultrasonic neb'` | SupplementalOxygen | | `'Vapomist'` | SupplementalOxygen | | `'Oxymizer'` | SupplementalOxygen | | `'High flow neb'` | SupplementalOxygen | | `'Nasal cannula'` | SupplementalOxygen | | `'None'` | None | Note: Some device values have trailing spaces (e.g., `'Trach mask '`, `'Bipap mask '`, `'Venti mask '`). These must be matched exactly. ### By Ventilator Mode (`ventilator_mode`) All of these map to **InvasiveVent**: `'(S) CMV'`, `'APRV'`, `'APRV/Biphasic+ApnPress'`, `'APRV/Biphasic+ApnVol'`, `'APV (cmv)'`, `'Ambient'`, `'Apnea Ventilation'`, `'CMV'`, `'CMV/ASSIST'`, `'CMV/ASSIST/AutoFlow'`, `'CMV/AutoFlow'`, `'CPAP/PPS'`, `'CPAP/PSV'`, `'CPAP/PSV+Apn TCPL'`, `'CPAP/PSV+ApnPres'`, `'CPAP/PSV+ApnVol'`, `'MMV'`, `'MMV/AutoFlow'`, `'MMV/PSV'`, `'MMV/PSV/AutoFlow'`, `'P-CMV'`, `'PCV+'`, `'PCV+/PSV'`, `'PCV+Assist'`, `'PRES/AC'`, `'PRVC/AC'`, `'PRVC/SIMV'`, `'PSV/SBT'`, `'SIMV'`, `'SIMV/AutoFlow'`, `'SIMV/PRES'`, `'SIMV/PSV'`, `'SIMV/PSV/AutoFlow'`, `'SIMV/VOL'`, `'SYNCHRON MASTER'`, `'SYNCHRON SLAVE'`, `'VOL/AC'` ### By Hamilton Ventilator Mode (`ventilator_mode_hamilton`) **InvasiveVent**: `'APRV'`, `'APV (cmv)'`, `'Ambient'`, `'(S) CMV'`, `'P-CMV'`, `'SIMV'`, `'APV (simv)'`, `'P-SIMV'`, `'VS'`, `'ASV'` **NonInvasiveVent**: `'DuoPaP'`, `'NIV'`, `'NIV-ST'` ## Episode Boundary Detection Individual charting observations are grouped into ventilation episodes using these rules: 1. **New episode starts when**: - First observation for a stay (no previous observation) - Gap of >= 14 hours between consecutive observations of the same status - Ventilation status changes from previous observation 2. **Episode boundaries**: - `starttime` = earliest charttime in the episode - `endtime` = latest charttime in the episode (or the next observation's charttime if it's within 14 hours) - Single-observation episodes (starttime == endtime) are excluded 3. **14-hour gap rule**: If two consecutive observations of the same ventilation status are more than 14 hours apart, they are treated as separate episodes. This prevents spanning overnight gaps where ventilation may have been discontinued and restarted. ## Pre-computed Table ```sql SELECT stay_id, starttime, -- Episode start timestamp endtime, -- Episode end timestamp ventilation_status -- InvasiveVent, NonInvasiveVent, HFNC, SupplementalOxygen, Tracheostomy, or None FROM mimiciv_derived.ventilation; ``` ## Required Tables for Custom Calculation ### Standard Mode (intermediate tables available) - `mimiciv_derived.ventilator_setting` — Ventilator mode, FiO2, PEEP, tidal volumes (pivoted from chartevents) - `mimiciv_derived.oxygen_delivery` — O2 delivery device, O2 flow rate (pivoted from chartevents) ### Raw Mode (from chartevents directly) **Ventilator settings** — itemids from `mimiciv_icu.chartevents`: - 224688: Respiratory Rate (Set) - 224689: Respiratory Rate (spontaneous) - 224690: Respiratory Rate (Total) - 224687: Minute Volume - 224684: Tidal Volume (set) - 224685: Tidal Volume (observed) - 224686: Tidal Volume (spontaneous) - 224696: Plateau Pressure - 220339, 224700: PEEP - 223835: Inspired O2 Fraction (FiO2) - 223849: Ventilator Mode - 229314: Ventilator Mode (Hamilton) - 223848: Ventilator Type - 224691: Flow Rate **Oxygen delivery** — itemids from `mimiciv_icu.chartevents`: - 223834, 227582: O2 Flow - 227287: O2 Flow (additional) - 226732: O2 Delivery Device For classification, the critical itemids are: - **223849** (Ventilator Mode) — text value maps to InvasiveVent - **229314** (Ventilator Mode Hamilton) — text value maps to InvasiveVent or NonInvasiveVent - **226732** (O2 Delivery Device) — text value maps to all categories ## Critical Implementation Notes 1. **Trailing Spaces in Device Names**: Several `o2_delivery_device_1` values have trailing spaces (e.g., `'Trach mask '`, `'Bipap mask '`, `'Venti mask '`, `'Medium conc mask '`). These must be matched exactly as stored in MIMIC-IV. 2. **Priority of Device over Mode**: Tracheostomy and Endotracheal tube (from `o2_delivery_device_1`) take priority over ventilator mode classification. A patient on a tracheostomy with a ventilator mode set is classified as Tracheostomy, not InvasiveVent. 3. **CPAP/PSV Modes Are Invasive**: In MIMIC-IV charting conventions, CPAP/PSV and related modes (CPAP/PPS, CPAP/PSV+ApnPres, etc.) are recorded as ventilator modes on patients with endotracheal tubes. These are classified as InvasiveVent, not NonInvasiveVent. Non-invasive CPAP is identified by the CPAP mask device, not the ventilator mode. 4. **Hamilton vs Standard Modes**: MIMIC-IV has two ventilator mode columns — `ventilator_mode` (standard ventilators) and `ventilator_mode_hamilton` (Hamilton ventilators). These are combined with COALESCE for classification purposes. 5. **Single-Observation Episodes Excluded**: Episodes where starttime equals endtime are filtered out. This removes transient or erroneous observations that don't represent sustained ventilation periods. 6. **NULL Ventilation Status Excluded**: Observations that don't match any classification rule produce NULL status and are excluded from episode detection. 7. **LAG Partitioning**: The gap detection LAG function partitions by `(stay_id, ventilation_status)` — not just `stay_id`. This means the 14-hour gap rule applies within each status category separately. ## Example: Ventilation Duration by Type ```sql SELECT ventilation_status, COUNT(*) AS n_episodes, ROUND(AVG(DATE_DIFF('hour', starttime, endtime)), 1) AS avg_hours, ROUND(MEDIAN(DATE_DIFF('hour', starttime, endtime)), 1) AS median_hours FROM mimiciv_derived.ventilation GROUP BY ventilation_status ORDER BY n_episodes DESC; ``` ## Example: Patients with Invasive Ventilation ```sql SELECT DISTINCT stay_id FROM mimiciv_derived.ventilation WHERE ventilation_status = 'InvasiveVent'; ``` ## Example: Ventilation Timeline for a Stay ```sql SELECT stay_id, ventilation_status, starttime, endtime, DATE_DIFF('hour', starttime, endtime) AS duration_hours FROM mimiciv_derived.ventilation WHERE stay_id = 30000110 ORDER BY starttime; ``` ## References - Johnson AEW et al. "MIMIC-IV, a freely accessible electronic health record dataset." Scientific Data. 2023;10(1):1. - MIT-LCP mimic-code repository: ventilation concept definition.