corrected_hormone — Convert a "raw" hormone concentration into a corrected concentration, using the provided mathematical expression.
NUMERIC(8,2)
corrected_hormone
(
|
raw_conc, | |
correction); |
NUMERIC(8,2)
raw_conc
;
text
correction
;The concentration in need of correction, e.g. a
HORMONE_RESULT_DATA.Raw_ng_g value. A
NUMERIC(8,2) number, or any other
data type that can be interpreted as a number and
converted to NUMERIC(8,2).
A text string containing a mathematical expression
that indicates the arithmetic needed to correct the raw
concentration. Usually this will be a HORMONE_KITS.Correction value. When
referring to the "raw" value, the string
%s must be used[308]. Some example expressions are provided
below.
| Correction | Interpretation |
|---|---|
%s
|
Use the raw value, no correction needed |
%s /
100
|
Divide the raw value by 100 |
(2 * %s) +
50
|
Multiply the raw value by 2, then add 50 |
It is assumed that this mathematical correction is
based on a linear relationship, so %s
cannot appear more than once in the "correction".
Returns a number, the corrected concentration. If
either or both of the parameters is NULL, returns
NULL.
This function is used by the ESTROGENS, GLUCOCORTICOIDS, HORMONE_RESULTS, PROGESTERONES, TESTOSTERONES, and THYROID_HORMONES views to generate their respective Corrected_ng_g columns. It may also be useful to users who want to try a different correction factor that is not recorded in HORMONE_KITS.
[308] Yes, %s is ugly, but this was
not chosen arbitrarily. It has a very specific meaning
for the PostgreSQL FORMAT() function, which is used in
this function to convert the "correction" string into
SQL that is executed to perform the calculation.