respiratoryCare
Purpose: The table contains information related to respiratory care. Patient data includes sequence of records for historical ordering, airway type/size/position, cuff pressure and various vent details including vent start and end dates/times, pressure limits, etc.
Links to:
- PATIENT on
patientUnitStayID
Table columns
| Name | Datatype | Null Option | Comment | Is Key | Stored Transformed Created |
|---|---|---|---|---|---|
patientUnitStayID |
int | NOT NULL | foreign key link to the patient table | FK | C |
respCareID |
int | IDENTITY | surrogate key for the respiratory data | PK | C |
respCareStatusOffset |
int | NOT NULL | number of minutes from unit admit time that the respiratory value was entered | C | |
currentHistorySeqNum |
int | NULL | the sequence number of the records for historical ordering | S | |
airwayType |
varchar(30) | NULL | the airway picklist type input into the respiratory care status e.g.: Laryngectomy, Tracheostomy, Oral ETT, etc. | S | |
airwaySize |
varchar(10) | NULL | the picklist airway size input into the respiratory care status e.g.: 35F, 9.5, NULL | S | |
airwayPosition |
varchar(32) | NULL | picklist airway position for the patient e.g.: 23 @ lip, 26 @ teeth, 20, etc. | S | |
cuffPressure |
decimal(5,1) | NULL | the picklist cuff pressure of the patient e.g.: 23.0, 22.0, NULL, etc. | S | |
ventStartOffset |
int | NULL | number of minutes from unit admit time that the vent was started | C | |
ventEndOffset |
int | NULL | number of minutes from unit admit time that the vent was ended | C | |
priorVentStartYear |
smallint | NULL | year when the prior vent started | T | |
priorVentStartTime24 |
time(0) | NULL | time in 24 hour format of when the prior vent start event occurred e.g.: “12:45”, “15:30”, “3:45” | T | |
priorVentStartTime |
varchar(20) | NULL | time frame when the prior vent started: ‘midnight’, ‘morning’, ‘midday’, ‘noon’, ‘evening’, or ‘night’ | T | |
priorVentStartOffset |
int | NULL | number of minutes from unit admit time that the prior vent was started | C | |
priorVentEndYear |
smallint | NULL | year when the prior vent ended | T | |
priorVentEndTime24 |
time(0) | NULL | time in 24 hour format of when the prior vent event ended e.g.: “12:45”, “15:30”, “3:45” | T | |
priorVentEndTime |
varchar(20) | NULL | time frame when the prior vent ended: ‘midnight’, ‘morning’, ‘midday’, ‘noon’, ‘evening’, or ‘night’ | T | |
priorVentEndOffset |
int | NULL | number of minutes from unit admit time that the prior vent was ended | C | |
apneaParams |
varchar(80) | NULL | the picklist apnea parameters of the vent e.g.: set, on, done, etc. | S | |
lowExhMVLimit |
decimal(11,4) | NULL | the low Ex MV Limit of the vent e.g: 5.0000, 200.0000, 3.0000, etc. | S | |
hiExhMVLimit |
decimal(11,4) | NULL | the high Ex MV Limit of the vent e.g.: 18.000, 20.0000, 40.0000, etc. | S | |
lowExhTVLimit |
decimal(11,4) | NULL | the low Exh TV limit of the vent e.g.: 300.0000, 200.0000, 350.0000, etc. | S | |
hiPeakPresLimit |
decimal(11,4) | NULL | the high peak pressure limit of the vent e.g.: 45.0000, 65.0000, 50.0000, etc. | S | |
lowPeakPresLimit |
decimal(11,4) | NULL | the low peak pressure limit of the vent e.g.: 10.0000, 150.0000, 15.0000, etc. | S | |
hiRespRateLimit |
decimal(11,4) | NULL | the high respiration rate limit of the vent e.g.: 40.0000, 32.0000, 24.0000, etc. | S | |
lowRespRateLimit |
decimal(11,4) | NULL | the low respiration rate limit of the vent e.g.: 12.0000, 5.0000, 8.0000, etc. | S | |
sighPresLimit |
decimal(11,4) | NULL | the sigh pressure limit of the vent | S | |
lowIronOxLimit |
decimal(11,4) | NULL | the low iron ox limit of the vent e.g.: 90.0000, 40.0000, 0.0000, etc. | S | |
highIronOxLimit |
decimal(11,4) | NULL | the high iron ox limit of the vent e.g.: 100.0000, 120.0000, 90.0000, etc. | S | |
meanAirwayPresLimit |
decimal(11,4) | NULL | the mean airway pressure limit of the vent e.g.: 60.0000, 45.0000, 50.0000, etc. | S | |
PEEPLimit |
decimal(11,4) | NULL | the PEEP limit of the vent e.g.: 10.0000, 14.0000, 8.0000, etc. | S | |
CPAPLimit |
decimal(11,4) | NULL | the CPAP limit of the vent e.g.: 2.0000, 10.0000, 5.0000, etc. | S | |
setApneaInterval |
varchar(80) | NULL | the picklist apnea interval of the vent e.g.: .20, 1:5, 20 sec, etc. | S | |
setApneaTV |
varchar(80) | NULL | the picklist apnea TV of the vent e.g.: 300, 460, 800, etc. | S | |
setApneaIPPEEPHigh |
varchar(80) | NULL | the picklist apnea IPPEEP high of the vent e.g.: 5, 7.0, 3.0, etc. | S | |
setApneaRR |
varchar(80) | NULL | the apnea RR of the vent e.g.: 20, 10, 28, etc. | S | |
setApneaPeakFlow |
varchar(80) | NULL | th picklist e apnea peak flow of the vent e.g.: .80, 70, 100, etc. | S | |
setApneaInspTime |
varchar(80) | NULL | the picklist apnea insp time of the vent e.g.: 096, 80, .7, etc. | S | |
setApneaIE |
varchar(80) | NULL | the picklist apnea IE of the vent e.g.: 1:2, 1:5, 1:3, etc. | S | |
setApneaFIO2 |
varchar(80) | NULL | the picklist apnea FIO2 of the vent e.g.: 1.0, 100, 100%, etc. | S |
eICU-CRD v2.0 documentation