NAV

Health Tracker Analytics Schema v1

Overview

The Health Tracker Analytics bundle contains tracker data and health and fitness metrics for a consumer in the Wellness Application service. Health and fitness trackers are devices that are used to monitor activity, biometrics, sleep, and exercise to improve an individual’s overall health.

Character Separated Values (CSV) Properties

Property Value
Header Record  Yes
Field Delimiter  Comma
Record Delimiter   CR/LF
Character Encoding   UTF-8

Files

File Name Description
Consumer_Engagement_F_HTA_Observations This table contains information about the health tracker data of the consumer.

Field Definitions

Consumer_Engagement_F_HTA_Observations

Field Definition Data Type
OBSERVATION_ID The unique identifier of the observation. VARCHAR(255)
CONSUMER_ID The unique identifier of the consumer. VARCHAR(255)
SOURCE The source from which the observation was recorded. VARCHAR(80)
METHOD The method in which the observation was recorded. VARCHAR(191)
STARTED_DT_TM The date and time when the observation started. TIMESTAMPTZ
ENDED_DT_TM The date and time when the observation ended. TIMESTAMPTZ
OBSERVATION_VALUE The value of the observation. VARCHAR(80)
UNIT_CODE The code value for the unit of measurement associated with the observation value. This value uses the standard coding systems recognized by Oracle Health Data Intelligence. VARCHAR(255)
UNIT_DISPLAY The code of the unit of measurement associated with the observation value, in human readable format. This value uses the standard coding systems recognized by Health Data Intelligence. VARCHAR(255)
UNIT_SYSTEM The coding system that originated from the unit of measurement code value associated with the observation value. This value uses the standard coding systems recognized by Health Data Intelligence. VARCHAR(255)
UNIT_SOURCE_CODE The code value for the unit of measurement associated with the observation value. This value uses codes that are provided by the data source, which can use either a standard or proprietary coding system. VARCHAR(255)
UNIT_SOURCE_DISPLAY The code of the unit of measurement associated with the observation value, in human readable format. This value uses codes that are provided by the data source, which can use either a standard or proprietary coding system. VARCHAR(255)
UNIT_SOURCE_SYSTEM The coding system that originated from the unit of measurement code value associated with the observation value. This value uses codes that are provided by the data source, which can use either a standard or proprietary coding system. VARCHAR(255)
CATEGORY_CODE The code value for classifications of the observation record, such as vital signs, laboratory, or activity. VARCHAR(255)
CATEGORY_CODE_DISPLAY The code for classifications of the observation record in human readable format, such as vital signs, laboratory, or activity. VARCHAR(255)
CATEGORY_CODE_SYSTEM The coding system that originated from the category code. VARCHAR(255)
OBSERVATION_CODE The code value for the type of observation record, such as a glucose or hemoglobin lab test, an observed eye color, or a measured height. VARCHAR(255)
OBSERVATION_DISPLAY The observation code, in human readable format. VARCHAR(255)
OBSERVATION_SYSTEM The coding system that originated from the observation code. VARCHAR(255)
ISSUED_DATE The date and time the observation was made available to providers, typically after the results have been reviewed and verified. TIMESTAMPTZ