mimic iii :difference between sofa and pivoted_sofa

[zyh1996007]

hi, thanks for your works! a difference was found in our works

the materialized view of sofa : The score is calculated on the first day of each ICU patients' stay. the materialized view of pivoted_sofa : The score is calculated for every hour of the patient's ICU stay

So, dose the 'sofa_24hours' mean the first day's sofa score of icustay when hr=24 in pivoted_sofa ?

But we found that many results are different between two views when hr=24 in pivoted_sofa.

if i want to find the first day's sofa ,which should i use? thank you very much!