46 lines
1.5 KiB
MySQL
46 lines
1.5 KiB
MySQL
|
-- THIS SCRIPT IS AUTOMATICALLY GENERATED. DO NOT EDIT IT DIRECTLY.
|
||
|
|
DROP TABLE IF EXISTS urine_output; CREATE TABLE urine_output AS
|
||
|
|
-- First we drop the table if it exists
|
||
|
|
select oe.icustay_id, oe.charttime
|
||
|
|
, SUM(
|
||
|
|
-- we consider input of GU irrigant as a negative volume
|
||
|
|
case when oe.itemid = 227488 then -1*value
|
||
|
|
else value end
|
||
|
|
) as value
|
||
|
|
from outputevents oe
|
||
|
|
where oe.itemid in
|
||
|
|
(
|
||
|
|
-- these are the most frequently occurring urine output observations in CareVue
|
||
|
|
40055, -- "Urine Out Foley"
|
||
|
|
43175, -- "Urine ."
|
||
|
|
40069, -- "Urine Out Void"
|
||
|
|
40094, -- "Urine Out Condom Cath"
|
||
|
|
40715, -- "Urine Out Suprapubic"
|
||
|
|
40473, -- "Urine Out IleoConduit"
|
||
|
|
40085, -- "Urine Out Incontinent"
|
||
|
|
40057, -- "Urine Out Rt Nephrostomy"
|
||
|
|
40056, -- "Urine Out Lt Nephrostomy"
|
||
|
|
40405, -- "Urine Out Other"
|
||
|
|
40428, -- "Urine Out Straight Cath"
|
||
|
|
40086,-- Urine Out Incontinent
|
||
|
|
40096, -- "Urine Out Ureteral Stent #1"
|
||
|
|
40651, -- "Urine Out Ureteral Stent #2"
|
||
|
|
|
||
|
|
-- these are the most frequently occurring urine output observations in MetaVision
|
||
|
|
226559, -- "Foley"
|
||
|
|
226560, -- "Void"
|
||
|
|
226561, -- "Condom Cath"
|
||
|
|
226584, -- "Ileoconduit"
|
||
|
|
226563, -- "Suprapubic"
|
||
|
|
226564, -- "R Nephrostomy"
|
||
|
|
226565, -- "L Nephrostomy"
|
||
|
|
226567, -- Straight Cath
|
||
|
|
226557, -- R Ureteral Stent
|
||
|
|
226558, -- L Ureteral Stent
|
||
|
|
227488, -- GU Irrigant Volume In
|
||
|
|
227489 -- GU Irrigant/Urine Volume Out
|
||
|
|
)
|
||
|
|
and oe.value < 5000 -- sanity check on urine value
|
||
|
|
and oe.icustay_id is not null
|
||
|
|
group by icustay_id, charttime;
|