quick reply to your points
- you need a triplet. lab test, bad unit, preferred unit (and what you propose only takes a pair)
- this is almost solved. But there is one field missing (it has been submitted to CDM repo) (orig. units I think)
- there is AoU knowledge base for that. (I posted that link on the forum). N3C has also their solution to that (maybe also posted publicly somewhere)
- Clair knows that this is something I am super motivated to submit PRs to DQD for. It was not on recent priority shortlist. I think that this item is the best way to nudge the network little by little. Super motivated for this fourth item.
EDIT: links are
1 Converting lab results into preferred unit at ETL time
2 https://github.com/OHDSI/CommonDataModel/issues/259