Some lab results like WBC are sometimes reported with different units (so value could be 17 or could be 17,000, even though really means the same thing).
Add something like a "std_value" (and "std_units") column where can mostly copy, but also modify some of the result values to be in a consistent form, so that downstream analytics can just use this column without worry about correcting each time.
Make this part of standard ETL workflow that we do, like adding numerical values to flowsheets and parsing out the systolic vs. diastolic blood pressure, and adding UTC datetimes.
Some lab results like WBC are sometimes reported with different units (so value could be 17 or could be 17,000, even though really means the same thing).
Add something like a "std_value" (and "std_units") column where can mostly copy, but also modify some of the result values to be in a consistent form, so that downstream analytics can just use this column without worry about correcting each time.
Make this part of standard ETL workflow that we do, like adding numerical values to flowsheets and parsing out the systolic vs. diastolic blood pressure, and adding UTC datetimes.