lods.sql BUN value
Nobody has claimed this yet.
- Dominant language
- Jupyter Notebook
- Stars
- 3.4k
- Forks
- 1.7k
- PR merge metrics
- No merged PRs in 30d
Description
Prerequisites
- [ X] Put an X between the brackets on this line if you have done all of the following:
- Checked the online documentation: https://mimic.mit.edu/
- Checked that your issue isn't already addressed: https://github.com/MIT-LCP/mimic-code/issues?utf8=%E2%9C%93&q=
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
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- 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