form_observation


If there is patient data for this table the file for this export will be found in the extracted zip folder location under the filename of form_observation.csv

If there are non-patient data column elements that are not part of the designated record set they will be marked in the Comment's column for that data element

Description

Used for recording observations related to patients during medical encounters

Columns

Column Type Size Nulls Auto Default Children Parents Comments
form_id BIGINT 19 null
forms.form_id Defined in XML R

fk to forms.id represents the overall form for this observation
date DATETIME 19 √ NULL
pid BIGINT 19 √ NULL
patient_data.pid Defined in XML R

The internal patient identifier
encounter VARCHAR 255 √ NULL
form_encounter.encounter Defined in XML R

References form_encounter.encounter, representing the encounter for this record
user VARCHAR 255 √ NULL
patient_data.pid Defined in XML R

fk to users.username who created this observation
groupname VARCHAR 255 √ NULL
authorized TINYINT 3 √ NULL
activity TINYINT 3 √ NULL
code VARCHAR 255 √ NULL
observation VARCHAR 255 √ NULL
ob_value VARCHAR 255 √ NULL
ob_unit VARCHAR 255 √ NULL
description VARCHAR 255 √ NULL
code_type VARCHAR 255 √ NULL
table_code VARCHAR 255 √ NULL
ob_code VARCHAR 64 √ NULL
ob_type VARCHAR 64 √ NULL
ob_status VARCHAR 32 √ NULL
list_options.option_id Defined in XML R

Comes from the list_options.list_id=‘observation-status’
result_status VARCHAR 32 √ NULL
ob_reason_status VARCHAR 32 √ NULL
ob_reason_code VARCHAR 64 √ NULL
ob_reason_text TEXT 65535 √ NULL
ob_documentationof_table VARCHAR 255 √ NULL
ob_documentationof_table_id BIGINT 19 √ NULL
date_end DATETIME 19 √ NULL
id BIGINT 19 √ null
parent_observation_id BIGINT 19 √ NULL
patient_data.pid Defined in XML R

fk to form_observation.id and is used to create hierarchical relationships between observations
category VARCHAR 64 √ NULL
list_options.option_id Defined in XML R

Comes from the list_options.list_id=‘Observation_Types’ and represents the category/type of observation being recorded
questionnaire_response_id BIGINT 19 √ NULL
questionnaire_repository.id Defined in XML R

fk to questionnaire_repository.questionnaire_response_id and is used link a questionnaire response to this observation
uuid BINARY 16 √ NULL

UUID for the observation, used as unique logical identifier
ob_value_code_description VARCHAR 255 √ NULL

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
idx_category Performance Asc category
idx_date Performance Asc date
idx_form_id Performance Asc form_id
idx_parent_observation Performance Asc parent_observation_id
idx_pid_encounter Performance Asc/Asc pid + encounter
idx_questionnaire_response Performance Asc questionnaire_response_id

Relationships

Close relationships within degrees of separation