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 BIGINT 19 √ null
forms.form_id Defined in XML R

The primary key which is the same as the forms.form_id column
date DATETIME 19 √ null
pid BIGINT 19 √ null
patient_data.pid Defined in XML R

The internal patient identifier
user VARCHAR 255 √ null
groupname VARCHAR 255 √ null
authorized TINYINT 3 √ null
activity TINYINT 3 √ null
note_type VARCHAR 255 √ null
message LONGTEXT 2147483647 √ null
doctor VARCHAR 255 √ null
date_of_signature DATETIME 19 √ null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id

Relationships

Close relationships within degrees of separation