The terminstance table summarizes the number for occurrences by month (using the date that the data row was inserted into HIEBus) of a particular term in HIEBus data.
Source Concepts
Table Schema
| Name |
Type
|
Description |
| termid |
INTEGER |
Unique key (in the context of a deployment) for the term.
|
| 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.
|
| tablename |
VARCHAR |
The name of a HIEBus table in which the termid is used.
|
| columnname |
VARCHAR |
The name of a HIEBus column in which the termid is used.
|
| startdate |
TIMESTAMP |
The start date of the period for which instances are counted. Typically the first day of a month.
|
| enddate |
TIMESTAMP |
The end date of the period for which instances are counted. Typically the last day of a month.
|
| instances |
INTEGER |
The number of rows in HIEBus (for the specified deployment, datapartition and HIEBus tablename and column) that reference the termid.
|
Back to Tables
