valueset

The valueset table is related to the ValueSet resource that is available via the FHIR API.

The valueset table represents groups of terms that can be associated with higher-order terminology concepts. Join to this table from *termid columns in other tables of the model in order to determine value sets that summarize the related term.

In most cases, a termid will be related to a value set through a mapping to a code in a reference terminology system. In this case, the mappedcode, mappeddisplay, and mappedsystem columns will be populated with that mapping.

If a termid is directly related to a value set, the mappedcode, mappeddisplay, and mappedsystem columns will be NULL.

If a termid has multiple mappings or is related to multiple value sets, it will have many rows in this table. If a termid is not related to a value set (directly or via a mapping), it will have zero rows in this table.

Usage

Obtain value sets related to a *termid column in another table by joining that column to valueset.termid.

Source Concepts

HIEBus termmappings
HIEBus termsubsets
HIEBus termsubsetmemers

Table Schema

Name	Type	Description
termid	INTEGER	Internal HIEBus identifier for a term concept. Generally, only terms from source systems and used in the *termid columns in other tables are included. Terms from reference systems will not be included. A termid will appear multiple times in this table if it has multiple mappings to reference code systems, or if it relates to multiple value sets.
code	VARCHAR	Coded value. Obtained from a data source.
display	VARCHAR	Name or description for the coded value.
codesystem	VARCHAR	The terminology namespace of the coded value.
mappedcode	VARCHAR	Mapped by Rosetta. A mapped terminology code determined to represent the coded value acquired from a source system. This concept is determined by the Rosetta Terminology Service.
mappeddisplay	VARCHAR	Mapped by Rosetta. The mapped terminology description determined to represent the mappedcode. This concept is determined by the Rosetta Terminology Service.
mappedcodesystem	VARCHAR	Mapped by Rosetta. The terminology namespace of the mappedcode.
identifier	VARCHAR	An internal identifer to represent the valueset to which the code or mapped code is related.
name	VARCHAR	Name of the valueset to which the code or mapped code is related.
usecontext	VARCHAR	The scope of the valueset to which the code or mapped code is related.

Back to Tables