The sourcetermsnapshot
table provides a series of time-based “snapshots” that summarize the state of all source terms, their term mappings, and the number of related data instances at monthly intervals in the past.
The sourcetermsnapshot
table will contain exactly one row for each term in a source terminology that was present in HIEBus at the enddate for the specified snapshot.
Usage
See also:
Source Concepts
Table Schema
Name |
Type
|
Description |
termid |
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.
|
startdate |
TIMESTAMP |
The start date of the snapshot period. Typically the first day of a month.
|
enddate |
TIMESTAMP |
The end date of the snapshot period. Typically the last day of a month.
|
cumulativeinstances |
INTEGER |
The number of data rows in HIEBus that include a reference to the termid and were inserted into HIEBus prior to the enddate.
|
mappings |
INTEGER |
The total number of term mappings using this termid as the sourcetermid that were present on the enddate.
|
mappingsadded |
INTEGER |
The number of term mappings using this termid as the sourcetermid and inserted between the startdate and enddate.
|
mappingsdeleted |
INTEGER |
The number of term mappings using this termid as the sourcetermid and deleted between the startdate and enddate.
|
targetcodesystem1 |
VARCHAR |
|
targetcodesystem2 |
VARCHAR |
|
targetcodesystem3 |
VARCHAR |
|
targetcodesystem4 |
VARCHAR |
|
targetcodesystem5 |
VARCHAR |
|
Back to Tables