forms


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 forms.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 chart forms that are connected to a patient’s encounter visit. Serves as the base record containing all of the common form encounter properties where each sub-type form has data records contained in a table that is named CONCAT(‘form_’,formdir)

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
form_physical_exam.forms_id Defined in XML R

Surrogate id of the record used as the primary incrementing key
date DATETIME 19 √ null

Date of the form
encounter BIGINT 19 √ null

ID of the associated encounter
form_name LONGTEXT 2147483647 √ null

Name of the form
form_id BIGINT 19 √ null
form_clinic_note.id Defined in XML R
form_group_attendance.id Defined in XML R
form_groups_encounter.id Defined in XML R
form_note.id Defined in XML R
form_painmap.id Defined in XML R
form_phq9.id Defined in XML R
form_prior_auth.id Defined in XML R
form_sdoh.id Defined in XML R
form_track_anything.id Defined in XML R
form_transfer_summary.id Defined in XML R
form_treatment_plan.id Defined in XML R
form_gad7.id Defined in XML R

ID of the specific form instance
pid BIGINT 19 √ null
patient_data.pid Defined in XML R

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

User responsible for creating this form.
groupname VARCHAR 255 √ null
groups.name Defined in XML R

The groupname that created this record.
authorized TINYINT 3 √ null

Authorization status
deleted TINYINT 3 0

Flag indicating if the form has been deleted
formdir LONGTEXT 2147483647 √ null

Directory name of where the form exists in the filesystem. Also is the suffix name of the sub-type form that holds the individual form data for this form. The full table name is CONCAT(‘form_’,formdir)
therapy_group_id INT 10 √ null
therapy_groups.group_id Defined in XML R

ID of the therapy group that this form’s encounter session is connected to
issue_id BIGINT 19 0
lists.id Defined in XML R

References lists.id to identify the medical issue this form is connected to
provider_id BIGINT 19 0
users.id Defined in XML R

References users.id to identify the provider who is responsible for or involved in the healthcare this form relates to. This field is only populated in some types of procedure order forms and when a form is a dynamic Layout Based Form (LBF)

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
form_id Performance Asc form_id
pid_encounter Performance Asc/Asc pid + encounter

Relationships

Close relationships within degrees of separation