The valuesetaudit
table describes the current state of value sets used in HIEBus along with audit data to track historical changes to these value sets.
Source Concepts
- HIEBus termsubsets
- HIEBus termsubsetmembers
- HIEBus termsubsets_archive
- HIEBus termsubsetmembers_archive
Table Schema
Name |
Type
|
Description |
termid |
INTEGER |
The termid of a term that belongs to the value set. If a termid belongs to multiple value sets, it will have multiple rows in this table.
|
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.
|
name |
VARCHAR |
Name of the value set.
|
usecontext |
VARCHAR |
HIEBus scope, used to manage categories of value sets.
|
termorder |
INTEGER |
For ordered value sets, the sequence specified for the terms in the value set. Not all value sets are ordered.
|
code |
VARCHAR |
Code of the term (e.g. Female or Y93.D).
|
display |
VARCHAR |
Human-readable label of the term.
|
domain |
VARCHAR |
Corresponds to “family” in HIEBus. This column will be populated with “Reference” for terms in reference code systems that are created and managed by Rosetta.
|
codesystem |
VARCHAR |
The name of the code system (corresponds to HIEBus termnamespace.name) for the term. For example: ICD10, HCPCS, LOINC, etc. for terms in a reference system. If the term originated from a data source, this commonly describes the data source.
|
valuesetstatus |
VARCHAR |
Denotes status of valueset. Current - valueset is active and record was last pulled from the termsubsets table. Archived - valueset is not active and record was last pulled from the termsubsets table.
|
valuesetinserteddate |
TIMESTAMP |
Date the value set was inserted into HIEBus.
|
valuesetdeleteddate |
TIMESTAMP |
Date the value set was deleted from HIEBus.
|
membershipstatus |
VARCHAR |
Denotes origin of membership. Current - membership is active and record was last pulled from the termsubsetmembers table. Archived - membership is not active and record was last pulled from the termsubsetmembers_archive table.
|
inserteddate |
TIMESTAMP |
Date the term was inserted into the value set in HIEBus.
|
deleteddate |
TIMESTAMP |
Date the term was delete from the value set in HIEBus.
|
instances |
INTEGER |
If domain = Reference, the number of data rows in HIEBus that include a reference to a termid THAT IS MAPPED to this termid. Otherwise, the number of data rows in HIEBus that include a reference to the termid.
|
Back to Tables