ehi_export_job


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

User initiated export of patient electronic health info.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
ehi_export_job_id INT 10 √ null
ehi_export_job_patients.ehi_export_job_id FK_ehi_export_job_patients_job_id C
ehi_export_job_tasks.ehi_export_job_id FK_task_ehi_export_job_id R
uuid BINARY 16 √ NULL
user_id BIGINT 19 null
users.id FK_ehi_export_job_users R

FK to users.id - represents the user that started the export process
creation_date DATETIME 19 current_timestamp()
completion_date DATETIME 19 current_timestamp()
status VARCHAR 20 'processing'

processing=export in progress, failed=error occurred in one or more tasks, completed=export completed without errors
include_patient_documents BOOLEAN 3 1

1=Include patient documents into zip export, 0=no patient documents included in the export
document_limit_size INT UNSIGNED 10 524288000

The batch zip file export size, default set to 500MB max value size is 4GB

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc ehi_export_job_id
FK_ehi_export_job_users Performance Asc user_id

Relationships

Close relationships within degrees of separation