form_clinical_instructions


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

Patient clinical instructions chart note

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INT 10 √ null
pid BIGINT 19 √ NULL
patient_data.pid Defined in XML R

The internal patient identifier
encounter VARCHAR 255 √ NULL
user VARCHAR 255 √ NULL
instruction MEDIUMTEXT 16777215 √ NULL

The actual instructions to be given to the patient
date TIMESTAMP 19 current_timestamp()
activity TINYINT 3 √ 1

Indexes

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

Relationships

Close relationships within degrees of separation