MIT-LCP / MIT-LCP/mimic-code

lods.sql BUN value

Open
#1,065 1 comment 0 reactions 0 assignees View on GitHub

Nobody has claimed this yet.

mimic-iii
Dominant language
Jupyter Notebook
Stars
3.4k
Forks
1.7k
PR merge metrics
No merged PRs in 30d

Description

Prerequisites

I am using the following code
https://github.com/MIT-LCP/mimic-code/blob/main/mimic-iii/concepts/severityscores/lods.sql
to calculate lods score.
Is this the right one to use?
I noticed in the code,
for renal score it has - " when bun_max >= 7.50 then 1" which seems not right as the one above "bun_max >= 17.0 then 1" is the right one (i.e 17.0 to 28.0 is I think considered score of 1).

Also i noticed in a related query,
https://github.com/MIT-LCP/mimic-code/pull/112,
the code is bit different (and units are also different) but seems right(when (BUN_Max >= 6 and BUN_Max <10) then 1).:

Could someone clear my doubt about, whether am i using the right code and whether the additional line in the first code affects the calculation for renal score?

Thanks,
Selva

Contributor guide

No contributing guide indexed for this repository

First steps

  1. Read the whole issue, then the project's contributing guide.
  2. Comment on the issue to say you are picking it up — it saves two people doing the same work.
  3. Fork the repository and make your change on a branch.
  4. Open a pull request that references the issue number.

Research direction

Read mimic-iii/concepts/severityscores/lods.sql and compare its BUN branches with pull request #112, paying attention to the units stated in each query. Confirm whether the extra bun_max threshold is intentional and whether it changes the renal score, then document the finding or proposed correction.

Written by the indexing model from the issue text.

Assessment

Tech stack
sql
Domain
databases
Issue type
Bug
Difficulty
3/5
Estimated time
1-2 days
Activity status
Quiet
Clarity
Mostly clear
Newbie friendliness
48/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.