devicedatapoints

The devicedatapoints table store data points that are captured from devices such as mobile phones or fitness trackers. Examples include heart rates, step counts, etc.

Table Schema

Name Type Description
id VARCHAR

Surrogate key. Primary key for the devicedatapoints table.

identifier VARCHAR

An external identifier provided by the data source to describe the device data point.

startdate VARCHAR

The start date provided by a device data source that applies to this device data point.

observationdate VARCHAR

The date the device data point was observed.

value VARCHAR

The value of the data point.

patient_id VARCHAR

Surrogate key. Foreign key reference to patients.id

typeterm_id INTEGER

Surrogate key. Foreign key reference to terms.id

unitsterm_id INTEGER

Surrogate key. Foreign key reference to terms.id

devicedatacontext_id VARCHAR

Surrogate key. Foreign key reference to devicedatacontexts.id

devicedatasource_id VARCHAR

Surrogate key. Foreign key reference to devicedatasources.id

properties VARCHAR

An xml formatted field with additional properties of the device data point managed as key-value pairs.

inserteddate TIMESTAMP

Timestamp (UTC) indicating the date the row was first inserted into HIEBus.

insertedbyapplication_id SMALLINT

The application that first inserted the row into HIEBus. Foreign key reference to applications.id.

insertedbyuser_id VARCHAR

The user associated with the process that first inserted the row into HIEBus. Foreign key reference to users.id.

modifieddate TIMESTAMP

Timestamp (UTC) indicating the date the row was last modified.

modifiedbyapplication_id SMALLINT

The application that last modified the row. Foreign key reference to applications.id.

modifiedbyuser_id VARCHAR

The user associated with the process that last modified the row. Foreign key reference to users.id.

tenant_id SMALLINT

Surrogate key. Foreign key reference to tenants.id


Back to Tables