ValueMap¶

mapping category: mapping-table supports `||` resultSize: N

Resolves a vocabulary value code to its standard concept ids using the OMOP CDM vocabulary tables.

ValueMap is the value-domain analog of VocabMap. Instead of mapping a source concept code to its standard concept id, it maps a value code (e.g. a measurement unit, a gender code, a drug strength code) using the OMOP concept_relationship Maps to value linkage. The rule returns every matching standard concept id, supporting multi-sized results.

Typical use: resolving a free-text or coded measurement value to its standard concept id when populating *_value_as_concept_id fields.

Parameters¶

1 — vocabulary Mandatory — accepts: STRING: The vocabulary used in the mapping (e.g. "ICD10CM", "LOINC").
2 — default Optional — accepts: INT, NULL: Default value used when no match is found.

Input type¶

STRING

Output type¶

INT

Requires¶

Allows multi-sized results.

Examples¶

Multi-sized ICD10CM value mapping (test063)

ValueMap("ICD10CM")[]

Single-result with default

ValueMap("LOINC", 0)