onsite_documents


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 onsite_documents.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 documents that have been assigned to a patient from a document_template that the patient has saved or submitted for review by clinical staff

Columns

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

The internal patient identifier
facility INT UNSIGNED 10 √ NULL
facility.id Defined in XML R
provider INT UNSIGNED 10 √ NULL
encounter INT UNSIGNED 10 √ NULL
form_encounter.encounter Defined in XML R
create_date TIMESTAMP 19 current_timestamp()
doc_type VARCHAR 255 null
patient_signed_status SMALLINT UNSIGNED 5 null
patient_signed_time DATETIME 19 √ NULL
authorize_signed_time DATETIME 19 √ NULL
accept_signed_status SMALLINT 5 null
authorizing_signator VARCHAR 50 null
review_date DATETIME 19 √ NULL
denial_reason VARCHAR 255 null
authorized_signature TEXT 65535 √ NULL
patient_signature TEXT 65535 √ NULL
full_document MEDIUMBLOB 16777215 √ NULL
file_name VARCHAR 255 null
file_path VARCHAR 255 null
template_data LONGTEXT 2147483647 √ NULL
user Unknown 0 null
users.id Defined in XML R

User who created the esignature

Indexes

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

Relationships

Close relationships within degrees of separation