form_vital_details


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_vital_details.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

Record of a specific vital sign measurement, including its interpretation, and reason of the measurement

Columns

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

FK to vital_forms.id
vitals_column VARCHAR 64 null

Column name from form_vitals
interpretation_list_id VARCHAR 100 √ NULL

FK to list_options.list_id for observation_interpretation
interpretation_option_id VARCHAR 100 √ NULL

FK to list_options.option_id for observation_interpretation
interpretation_codes VARCHAR 255 √ NULL

Archived original codes value from list_options observation_interpretation
interpretation_list_id Unknown 0 null
list_options.list_id Defined in XML R
interpretation_option_id Unknown 0 null
list_options.option_id Defined in XML R
interpretation_title VARCHAR 255 √ NULL

Archived original title value from list_options observation_interpretation
reason_code VARCHAR 31 √ NULL

Medical code explaining reason of the vital observation value in form codesystem:codetype;…;
reason_description TEXT 65535 √ NULL

Human readable text description of the reason_code column
reason_status VARCHAR 31 √ NULL

Valid values are ‘completed’,‘negated’,‘pending’ or '' for none

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
fk_form_id Performance Asc form_id
fk_list_options_id Performance Asc/Asc interpretation_list_id + interpretation_option_id

Relationships

Close relationships within degrees of separation