form_vitals_calculation


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

Main calculation records - one per logical calculation (e.g., average BP)

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INT 10 √ null
uuid BINARY 16 √ NULL
form_vitals_calculation_components.fvc_uuid Defined in XML R
form_vitals_calculation_form_vitals.fvc_uuid Defined in XML R
encounter BIGINT 19 √ NULL
form_encounter.encounter Defined in XML R

fk to form_encounter.id
pid BIGINT 19 null
patient_data.pid Defined in XML R

fk to patient_data.pid
date_start DATETIME 19 √ NULL
date_end DATETIME 19 √ NULL
created_at DATETIME 19 √ NULL
updated_at DATETIME 19 √ NULL
created_by BIGINT 19 √ NULL
updated_by BIGINT 19 √ NULL
calculation_id VARCHAR 64 √ NULL

application identifier representing calculation e.g., bp-MeanLast5, bp-Mean3Day, bp-MeanEncounter

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
idx_calculation_id Performance Asc calculation_id
idx_encounter Performance Asc encounter
idx_pid Performance Asc pid
unq_uuid Must be unique Asc uuid

Relationships

Close relationships within degrees of separation