document_templates


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

Digital document templates that are assigned to patients

Columns

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

The internal patient identifier.
provider INT UNSIGNED 10 √ NULL
encounter INT UNSIGNED 10 √ NULL
modified_date DATETIME 19 current_timestamp()
profile VARCHAR 63 null
category VARCHAR 63 null
location VARCHAR 255 √ NULL
template_name VARCHAR 255 √ NULL
status VARCHAR 31 √ NULL
send_date DATETIME 19 current_timestamp()
end_date DATETIME 19 √ NULL
size INT 10 0
template_content MEDIUMBLOB 16777215 √ NULL

Digital document template that is assigned to a patient to be filled out. Uses Domain Specific Language (DSL) template tags to inject specific functionality into the template for patients to fill out. Patient data template tags can be found at the following URL: https://www.open-emr.org/wiki/index.php/Patient_Portal_Document_Templates
mime VARCHAR 31 √ NULL

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
location Must be unique Asc/Asc/Asc/Asc pid + profile + category + template_name

Relationships

Close relationships within degrees of separation