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
id BIGINT 19 null
date DATETIME 19 √ NULL
pid BIGINT 19 √ NULL
patient_data.pid Defined in XML R

The internal patient identifier
encounter VARCHAR 255 √ NULL
user VARCHAR 255 √ NULL
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
result_status VARCHAR 32 √ NULL
ob_reason_status VARCHAR 32 √ NULL
ob_reason_code VARCHAR 64 √ NULL
ob_reason_text MEDIUMTEXT 16777215 √ NULL
ob_documentationof_table VARCHAR 255 √ NULL
ob_documentationof_table_id BIGINT 19 √ NULL
date_end DATETIME 19 √ NULL

Relationships

Close relationships within degrees of separation