The valueset view manages links between a term and value sets that contain the term. A value set may contain a source term either by (most commonly) including a reference term to which the source term is mapped, or (less common) including a source term directly.
Table Schema
| Name |
Type
|
Description |
| term_id |
INTEGER |
Surrogate key. Foreign key reference to terms.id. A term that is a member of the value set described by the identifier, name, and use context columns.
|
| code |
VARCHAR |
The unique code (within the code system) that specifies the term (equivalent to terms.code).
|
| display |
VARCHAR |
A description of the term (equivalent to terms.name).
|
| codesystem |
VARCHAR |
The unique code that describes the code system to which the term belongs (equivalent to termnamespaces.code).
|
| mappedcode |
VARCHAR |
If the term_id represents a source term and that term is mapped to a reference term and that reference term is included in the value set- The unique code (within the code system) that specifies the term to with the source term (represented by term_id) is mapped. Otherwise, NULL.
|
| mappeddisplay |
VARCHAR |
A description of the mapped term, if applicable. Otherwise, NULL.
|
| mappedcodesystem |
VARCHAR |
The unique code that describes the code system to which the mapped term belongs, if applicable. Otherwise, NULL.
|
| identifier |
INTEGER |
The unique identifier used by HIEBus to describe the value set (equivalent to termsubsets.id)
|
| name |
VARCHAR |
A name to describe the value set (equivalent to termsubsets.name)
|
| usecontext |
VARCHAR |
A group category to which the value sets belongs (equivalent to termsubsets.scope)
|
Back to Tables
