sourcetermsnapshot

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