intakeOutput
Purpose: Intake and output recorded for patients. Entered from the nursing flowsheet (either manually or interfaced into the hospital system).
Links to:
- PATIENT on
patientUnitStayID
Important considerations
- Absence of measurement does not indicate absence of intake or output.
- The
intakeTotal
,outputTotal
,diaslysisTotal
, andnetTotal
are cumulative measurements up to the current offset. The value measured for the given row is stored incellValueNumeric
andcellValueText
- When several entries are recorded at the same time for a patient, the values in intaketotal, outputtotal, dialysistotal and nettotal are duplicated!
- outputtotal does not only corrspond to urine output, but also output from drains, blood loss, etc.
- cellvaluenumeric is always POSITIVE, while dialysistotal is NEGATIVE for fluid removal and POSITIVE when fluid is administered to the patient via the dialysis machine.
- With each new entry in intakeoutput, the current daily net total is reported. If several entries happen at the same time, the daily net total will be repeated multiple times. So if you are trying to compute the daily fluid balance, you need to first isolate unique instances of daily net total (
select distinct patientunitstayid, intakeoutputoffset, nettotal
) and then sum these unique values. Failure to do so will result in a grossly overestimated daily fluid balance.
Table columns
Name | Datatype | Null Option | Comment | Key |
---|---|---|---|---|
patientUnitStayID |
int | NOT NULL | foreign key link to the patient table | FK |
intakeOutputID |
int | IDENTITY | surrogate key for the intake output data | PK |
intakeOutputOffset |
int | NOT NULL | number of minutes from unit admit time that the I and O value was observed | |
intakeTotal |
decimal(12,4) | NULL | total intake value up to the current offset, e.g.: 150.0000, 326.0000, 142.0000, etc. | |
outputTotal |
decimal(12,4) | NULL | total output value up to the current offset, e.g.: 230.0000, 350.0000, 150.0000, etc. | |
dialysisTotal |
decimal(12,4) | NULL | total dialysis value up to the current offset, e.g.: -96.0000, -2300.0000, 0.0000, etc. | |
netTotal |
decimal(12,4) | NULL | calculated net value of: intakeTotal – outputTotal + dialysisTotal | |
intakeOutputEntryOffset |
int | NOT NULL | number of minutes from unit admit time that the I and O value was entered | |
cellPath |
varchar(500) | NOT NULL | the root path of info from the label in I and O e.g.: flowsheet | Flowsheet Cell Labels |
cellLabel |
varchar(255) | NOT NULL | The predefined row label text from I and O e.g.: Enteral flush/meds panda, D5 0.45 NS w/20 mEq KCL 1000 ml, Continuous infusion meds, etc. | |
cellValueNumeric |
decimal(12,4) | NOT NULL | the value of the current I and O row e.g.: 100.0000, 60.9000, 10.0000, etc. | |
cellValueText |
varchar(255) | NOT NULL | text conversion of the numeric value of the I and O row e.g.: 100, 360, 50 |
eICU-CRD v2.0 documentation