form_questionnaire_assessments


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

Holds questionnaires results for a patient entered in by a provider as a patient charted form

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
date DATETIME 19 √ current_timestamp()
response_id TEXT 65535 √ null
questionnaire_response.response_id Defined in XML R

The foreign uuid key to the questionnaire_response.response_id
pid BIGINT 19 0
patient_data.pid Defined in XML R

The internal patient identifier
user VARCHAR 255 √ null
users.username Defined in XML R
groupname VARCHAR 255 √ null
groups.name Defined in XML R

The groupname that created this record.
authorized TINYINT 3 0
activity TINYINT 3 1
copyright TEXT 65535 √ null
form_name VARCHAR 255 √ null
response_meta TEXT 65535 √ null

json meta data for the response resource
questionnaire_id TEXT 65535 √ null
questionnaire_repository.questionnaire_id Defined in XML R

The foreign uuid key to the questionnaire.questionnaire_id
questionnaire LONGTEXT 2147483647 √ null
questionnaire_response LONGTEXT 2147483647 √ null
lform LONGTEXT 2147483647 √ null
lform_response LONGTEXT 2147483647 √ null

Indexes

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

Relationships

Close relationships within degrees of separation