Value Columns
The OBSERVATION_FACT table has six columns associated with values. This section contains additional information about each of these columns that contain value related data.
OBSERVATION_FACT Value Columns |
|
|
|
|
| |
VALTYPE_CD | TVAL_CHAR | NVAL_NUM | VALUEFLAG_CD | UNITS_CD | OBS_BLOB | |
N | E (equal) | Actual numeric value of object | H (high) | Units associated with object | Misc. encrypted information | ]]></ac:plain-text-body></ac:structured-macro> |
T | Actual short text value of object | N/A | A (abnormal) | Units associated with object | Misc. encrypted information | ]]></ac:plain-text-body></ac:structured-macro> |
B | N/A | N/A | X (encrypted) | N/A | Raw text | |
NLP | N/A | N/A | X (encrypted) | N/A | NLP result XML |
VALTYPE_CD Column
The VALTYPE_CD defines what type of object is being stored in the remaining value columns. The possible values are:
Value | Description |
@ | No value |
N | Numeric objects such as those found in lab tests |
T | Text objects such as labels, short message, enumerated values |
B | Raw text objects such as a doctor's note, discharge summary, and radiology report |
NLP | NLP result xml objects |
TVAL_CHAR Column
The TVAL_CHAR column is used in conjunction with the VALTYPE_CD column. The information stored in the TVAL_CHAR column is dependent on what the VALTYPE_CD is for the object.
VALTYPE_CD = "T"
The text value associated with the CONCEPT_CD is stored.
VALTYPE_CD = "N"
If an operator is associated with the numeric value then it is stored in the VALTYPE_CD.
The operators are:
Operator | Description |
E | Equal |
NE | Not equal |
L | Less than |
LE | Less than and Equal to |
G | Greater than |
GE | Greater than and Equal to |
NVAL_NUM Column
If the VALTYPE_CD = "N" then the actual numeric value associated with the CONCEPT_CD is stored in the NVAL_NUM.
In the section "TVAL_CHAR column" it says
VALTYPE_CD = "N"
If an operator is associated with the numeric value then it is stored in the VALTYPE_CD.
I believe it should say "...it is stored in the TVAL_CHAR."
A little further down, it should say:
"less than or equal to" instead of "less than and equal to"
and
"greater than or equal to" instead of "greater than and equal to"
In the section for "VALUEFLAG_CD column", the entry for "N | Normal" is missing from the table.
Wonderful wiki and wonderful page. Thank you! I hope this proves helpful.