search

MIT-LCP / mimic-code

MIMIC Code Repository: Code shared by the research community for the MIMIC family of databases
https://mimic.mit.edu
MIT License
2.41k stars 1.5k forks source link

Question about dialysis #1601

Closed heisenbug-1 closed 10 months ago

heisenbug-1 commented 11 months ago

Hello. I have a question regarding the dialysis table in mimiciv_derived.rrt

I'm using the following query to extract stay_ids of patients that got a continuous heparin treatment and some kind of dialysis SELECT DISTINCT r.* FROM mimiciv_derived.rrt as r, mimiciv_icu.inputevents as i WHERE i.itemid = 225152 AND i.ordercategorydescription = 'Continuous Med' AND r.stay_id = i.stay_id ORDER BY stay_id

What do dialysis_present and dialysis_active mean? The first stay_id returned by this query has CRRT at 11 o'clock with dialysis_active=0 and dialysis_active=1. Isn't this contradictive? Best regards

alistairewj commented 10 months ago

It could be they are transitioning from inactive to active at that charted hour. If that's the case, then it's technically true.. albeit confusing. I recall something like this happening when I was doing data exploration.

The goal of the present vs. active distinction is to identify when dialysis is actually ongoing versus when dialysis equipment is in place. So for example, a dialysis line could be in place (dialysis_present = 1), but the patient is not currently being dialyzed (dialysis_active = 0). There were a few items which indicated past dialysis / presence of lines so I thought it useful to capture both. For all intents and purposes I think you can subselect to dialysis_active = 1

Message ID: @.***>

heisenbug-1 commented 10 months ago

Great! Thanks for the clarification :)