| Name |
Type
|
Description |
| personid |
VARCHAR(38) GUID |
Unique identifier representing a unique person that may include data from several sources that have been linked. This identifier is the person_id of a HIEBus recordgroup.
|
| observationid |
VARCHAR(38) GUID |
Internal identifier of the HIEBus source row.
|
| code |
VARCHAR |
Mapped by Rosetta. The primary mapped terminology code determined to represent the observation. This is the preferred mapped concept determined by the Rosetta Terminology Service.
|
| display |
VARCHAR |
Mapped by Rosetta. The primary mapped terminology description determined to represent the observation. This is the preferred mapped concept determined by the Rosetta Terminology Service.
|
| codesystem |
VARCHAR |
Mapped by Rosetta. The terminology namespace of the code field.
|
| termid |
INTEGER |
A reference to the original primary term that can be used to show the original code or relate to alternative mappings.
|
| origintable |
VARCHAR |
A reference to the source HIEBus table. Useful for joins back to HIEBus using observationid to indicate which table to join. Values: observations, labobservations.
|
| alternatetermids |
VARCHAR |
A comma delimited list of termids that provide supplemental terms (usually in alternate coding systems) to represent the observation.
|
| effective |
TIMESTAMP |
Clinically relevant time for the observation.
|
| encounterid |
VARCHAR(38) GUID |
Source encounter, if determined from an encounter-based data source.
|
| datasource |
VARCHAR |
The name of the data source. Commonly determined from the namespace of the source terminology namespace.
|
| category |
VARCHAR |
Mapped by Rosetta. Category or type. This is the preferred mapped concept determined by the Rosetta Terminology Service.
|
| categorycode |
VARCHAR |
Mapped by Rosetta. Coded Value. Category or type. This is the preferred mapped concept determined by the Rosetta Terminology Service.
|
| categorytermid |
INTEGER |
Reference to HIEBus terminology properties for the observation.
|
| value |
VARCHAR |
The finding or lab result.
|
| isnumeric |
BOOLEAN |
True if the value column is numeric and can be used in computations such as AVG, MIN, GREATER THAN, LESS THAN, etc.
|
| interpretation |
VARCHAR |
Mapped by Rosetta. High, low, normal, etc. This is the preferred mapped concept determined by the Rosetta Terminology Service.
|
| interpretationcode |
VARCHAR |
Mapped by Rosetta. This is the preferred mapped concept determined by the Rosetta Terminology Service.
|
| interpretationtermid |
INTEGER |
Reference to HIEBus terminology properties for the observation.
|
| lastupdated |
TIMESTAMP |
System generated timestamp indicating the most recent change to this data row. Used for differential operations. Managed in UTC.
|
