We may need to convert and standardise unitage in the test & QC data units.

 

Problem

0106TestUProblem

One analyser sends data for Calcium in conventional units 

mg/dL

A second analyser sends mEq/L

A third  analyser sends mmol/l

Requirement

0206TestURequirement

We want to use SI Units

These will be mmol/L for Calcium

Solution

0306TestUSolution

We find two fields in the database called UnitsOrig and Units.

UnitsOrig has our original values mg/dL, mEq/L or mmol/l

Units has mmol/L.

We need to be aware that we are doing two different things.

Converting mmol/l  to mmol/L is a simple label change.

mEq/L to mmol/L requires a conversion factor.

We store both our original and revised values and need to compare them in order to validate the system and the conversion