The reftermmap table provides a catalog of HIEBus™ term mappings to terms in reference code systems.
Term mappings in the reftermmap table are described using a sourceterm and a targetterm.
- sourcetermid is commonly the
termid representing a term concept obtained from a data source and stored in a *termid column in other data tables.
- targettermid represents the term concept to which the
sourcetermid is mapped. It is commonly a term concept in a reference term namespaces maintained by Rosetta and used in value sets maintained by Rosetta.
Usage
Obtain all term mappings related to a *termid column in another table by joining the termid to reftermmap.sourcetermid.
See also:
Source Concepts
- HIEBus terms
- HIEBus termnamespaces
- HIEBus termmappings
- HIEBus termmappings_archive
- terminstance
Table Schema
| Name |
Type
|
Description |
| sourcetermid |
INTEGER |
A termid in the terms table. Indicates the termid used on data rows from a source systems terminology system.
|
| deployment |
VARCHAR |
The name of the originating HIEBus deployment. In some data marts, terms may be consolidated across deployments for analysis. Termids are unique within a deployment. In multi-deployment data marts, deployment+termid uniquely identifies a term.
|
| tenant |
VARCHAR |
The name of the originating HIEBus tenant. NULL for terms in reference code systems indicated by domain = Reference.
|
| sourcecode |
VARCHAR |
Code of the sourcetermid (e.g. Female or Y93.D).
|
| sourcedisplay |
VARCHAR |
Human-readable label of the sourcetermid.
|
| sourcedomain |
VARCHAR |
Corresponds to “family” in HIEBus for the sourcetermid.
|
| sourcecodesystem |
VARCHAR |
The name of the code system (corresponds to HIEBus termnamespace.name) for the sourcetermid. Commonly, this commonly describes the data source.
|
| targettermid |
INTEGER |
A termid in the terms table. Indicates the termid from a reference terminology system to which the source term is mapped.
|
| targetcode |
VARCHAR |
Code of the targettermid (e.g. Female or Y93.D).
|
| targetdisplay |
VARCHAR |
Human-readable label of the targettermid.
|
| targetcodesystem |
VARCHAR |
The name of the code system (corresponds to HIEBus termnamespace.name) for the targettermid. For example: ICD10, HCPCS, LOINC, etc. for terms.
|
| inserteddate |
TIMESTAMP |
The date and time that the mapping was created.
|
| deleteddate |
TIMESTAMP |
The date and time that the mapping was deleted. NULL if the mapping is status = Current.
|
| status |
VARCHAR |
Denotes origin of mapping. Current - mapping is active and record was last pulled from the termmappings table. Archived - mapping is not active and record was last pulled from the termmappings_archive table.
|
| instances |
INTEGER |
COMPUTED. The number of rows in HIEBus that reference the sourcetermid.
|
| batchid |
VARCHAR |
Identifier of the Rosetta batch event that created the mapping.
|
| mapperuri |
VARCHAR |
Information about the Rosetta batch event that created the mapping.
|
| technique |
VARCHAR |
Information about the Rosetta batch event that created the mapping.
|
| detail |
VARCHAR |
Information about the Rosetta batch event that created the mapping.
|
| apiversion |
VARCHAR |
Information about the Rosetta batch event that created the mapping.
|
| termsversion |
VARCHAR |
Information about the Rosetta batch event that created the mapping.
|
| confidence |
INTEGER |
Information about the Rosetta batch event that created the mapping.
|
Back to Tables
