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.51k stars 1.5k forks source link

add crrt to kdigo concept #1461

Closed aegis301 closed 1 year ago

aegis301 commented 1 year ago

Dear MIMIC-Community,

I noticed that the presence of CRRT is missing as a parameter for KDIGO stage calculation. KDIGO states that "presence of CRRT" automatically classifies the patient as AKI stage 3.

I allowed myself to quickly write up a query which I believe would fix the problem.

I am so grateful to be able to contribute to this amazing project and I am looking forward to your input.

Kind regards Christian

alistairewj commented 1 year ago

Thanks for the PR! I think this is a good contribution - two quick comments:

  1. We automatically generate the scripts in the concepts_postgres folder from the concepts folder. So you'll need to move your edits over to the concepts/ folder
  2. You'll need to add in the times from the CRRT table to the tm_stg CTE, with something like UNION DISTINCT SELECT stay_id, charttime FROM mimiciv_derived.crrt
aegis301 commented 1 year ago

Hello @alistairewj, thank you so much for your kind reply. I put in place the changes you recommend and am looking forward to your input. Thank you so much for this opportunity to contribute to this project.