form_physical_exam


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

Physical Examination clinical note

Columns

Column Type Size Nulls Auto Default Children Parents Comments
forms_id BIGINT 19 null
forms.id Defined in XML R
line_id CHAR 8 null
form_physical_exam_diagnoses.line_id Defined in XML R
wnl BIT 1 0
abn BIT 1 0
diagnosis VARCHAR 255
form_physical_exam_diagnoses.diagnosis Defined in XML R
comments VARCHAR 255

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc/Asc forms_id + line_id

Relationships

Close relationships within degrees of separation