form_note


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

Work/School note written by a provider for a patient to provide documentation of their medical condition to their work or school

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id Unknown 0 null
forms.form_id Defined in XML R

The primary key which is the same as the forms.form_id column
pid Unknown 0 null
patient_data.pid Defined in XML R

The internal patient identifier

Relationships

Close relationships within degrees of separation