form_vitals_calculation_components


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

Component values for calculations (e.g., systolic=120, diastolic=80)

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INT 10 √ null
fvc_uuid BINARY 16 null
form_vitals_calculation.uuid Defined in XML R

fk to form_vitals_calculation.uuid
vitals_column VARCHAR 64 null

Component type: bps, bpd, pulse, etc.
value DECIMAL 12,6 √ NULL

Calculated numeric component value
value_string VARCHAR 255 √ NULL

Calculated non-numeric component value
value_unit VARCHAR 16 √ NULL

Unit for this component value
component_order INT 10 0

Display order for components

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
idx_component_order Performance Asc/Asc fvc_uuid + component_order
idx_vitals_column Performance Asc vitals_column
unq_fvc_component Must be unique Asc/Asc fvc_uuid + vitals_column

Relationships

Close relationships within degrees of separation