Incorrect units for 'Length in cm' and 'Length Calc Inches'

Prerequisites

• Put an X between the brackets on this line if you have done all of the following:
  • Checked the online documentation: https://mimic.physionet.org/about/mimic/
  • Checked that your issue isn't already addressed: https://github.com/MIT-LCP/mimic-code/issues?utf8=%E2%9C%93&q=
  • Checked online common solutions: https://opendata.stackexchange.com/questions/tagged/mimic-iii

Description

The valueuom column (units) for 'Length in cm' and 'Length Calc Inches' must be incorrect. The issue can be demonstrated with this query:

select d.label, ce.itemid, ce.value, ce.valueuom, ce.charttime
from chartevents as ce
inner join d_items as d on ce.itemid = d.itemid
where subject_id = 10 and d.label in ('Length Calc Inches', 'Length in cm');

EDIT: I can see from your demographics query that it is not an issue there, however it might be confusing for people who aren't using that particular script to obtain height (like me!)

Start with the supplied query against chartevents and d_items for subject_id 10, focusing on the two named labels and their valueuom values. Compare the results with the demographics query mentioned in the issue and determine the expected units. Done means the units for both labels are consistent and no longer misleading for users querying the tables directly.