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 |