NurseCharting vs physicalExam tables

MIT-LCP / eicu-code

Code and website related to the eICU Collaborative Research Database

https://eicu-crd.mit.edu

MIT License

308 stars 212 forks source link

NurseCharting vs physicalExam tables #189

Open Olivier998 opened 2 years ago

Olivier998 commented 2 years ago

Hi, I am comparing the GCS values derived from the script concepts/pivoted/pivoted-gcs.sql with the GCS values found in the physicalExam. However the results from the two tables are not the same;

Some patients have different minimum values in the two tables
Others may only have values in one table or the other.

Anyone has an idea why this is? And is one table more reliable than the other? Or should I consider using a combination of the two?

Thanks!

jraffa commented 2 years ago

These tables may represent different data collection processes, so unless the values have the same offset, your observations are not necessarily inconsistent.

Documentation practices may also vary between hospitals.