Update postgres-make-concepts.sql

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

Update postgres-make-concepts.sql #1494

Closed trostalski closed 1 year ago

trostalski commented 1 year ago

Looks to me like the file medication/norepinephrine.sql is missing here. Therefore, the scripts for the dependent tables are failing (and also score/sofa.sql which also seems to be dependent). 😄

alistairewj commented 1 year ago

Thanks for highlighting this. The postgres-make-concepts script is actually automatically generated by convert_bigquery_to_postgres.sh. The bug is that it skipped adding medication.norepinephrine because the check was a regex which incorrectly matched against medication.norepinephrine_equivalent_dose. Fixing it in an upcoming PR.