The derivedobservation table normalizes features of a person that are not readily represented in other columns within the analytics data model.
These rows may represent computed concepts or simple concepts moved from other parts of the data model in order to be more readily accessible in this consistent structure.
Source Concepts
Table Schema
| 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.
|
| derivedobservationid |
VARCHAR(38) GUID |
|
| code |
VARCHAR |
|
| display |
VARCHAR |
|
| date |
TIMESTAMP |
|
| enddate |
TIMESTAMP |
|
| value |
VARCHAR |
|
| secondvalue |
VARCHAR |
|
| resourceid |
VARCHAR(38) GUID |
The id of the related data resource (i.e. Condition, Observation, etc.)
|
| resource |
VARCHAR |
Name of the resource referenced in resourceid (i.e. Condition, Observation, etc.)
|
| resourcecode |
VARCHAR |
Denormalized from the related data resource.
|
| datasource |
VARCHAR |
Denormalized from the related data resource.
|
Back to Tables
